I have held positions specializing in IT services as a programmer and business intelligence analyst. My practical experience includes systems integration, ETL, business intelligence, data warehousing, mobile app development, fullstack web development, and team collaboration. Find me online via the links below.
While working for a Fortune 200 manufacturing client, I built a dimensional Data Warehouse for reporting and analytics. The warehouse integrated five SQL Server databases holding gigabites worth of data each that required extraction from different server locations and heavy cleansing via SQL stored procedures. The model was based on Ralph Kimball's Dimensional Modeling. I executed an architecture that follows a simple ETL pattern using four schema definitions (staging, ods, dim, fact):
NULLvalues and replacing them with the mapped defaults below based on column data types:
Apart from being a developer, I spend most of my time outdoors. During the warmer months here in Nashville, I enjoy mountain biking, rock climbing, cooking out, and fly fishing.
When forced indoors, I follow a number of television shows, I am an aspiring cook, and I spend a large amount of my free time exploring the latest technology advancements in the machine learning, data science, and AI world.