Dan Colbert Email & Phone Number

Naperville, IL, US

Naperville, Illinois, United States

Naperville, Illinois, United States

Naperville

Naperville, IL

Responsible for the design and architecture of the analytics platform used by Forecast5 Analytics. Specifically responsible for data acquisition, ETL processes, data architecture, data quality, and data visualization for a Software-as-a-Service (SAAS) product marketed to school districts and municipalities.Lead a team of developers as we build and.

Naperville, IL

Aurora, IL

Artisan coffee roasting company specializing in micro-batch roasted beans.

Oakbrook, IL

Responsible for BI development best practicesSubversion and TFS version controlProduct licensingDesigned, built and maintain SQL Server database projects using Visual Studio 2010 with both "DB Pro" and SQL Server Data ToolsDesigned, developed, built and deployed an 8-server SharePoint Business Intelligence farmResponsible for Tableau Server maintenance and.

• Chief Architect responsible for all aspects of the company’s enterprise business intelligence environment- Solution was built completely on the Microsoft SQL Server product suite with SQL Server 2005/2008- Also.
• Designed the data warehouse architecture using the Kimball dimensional model
• Designed, built and maintained an integrated ETL system that loaded data from several data sources including the Fathead website database, Salesforce.com and Dynamics GP
• Integrated an address verification service solution with several environments including in real-time for the website, as a batch process for Dynamics GP and for the data warehouse SSIS ETL packages
• Successfully implemented a process that pulled sales order process data from Dynamics GP (Great Plains) and presented a single, consolidated view of the life cycle of an order
• Contributed to the design and maintenance of the Fathead website database to ensure good data quality and consistency

• Data Warehouse Engineer responsible for development and support of ETL processes, report design and delivery, Analysis Services cube maintenance and end-user training- Work highlights:
• Re-built the nightly ETL process, through the CSA, that brings in a snapshot of all loans that were edited in the previous calendar day. The result was a more accurate, faster import which provided higher quality data.
• Assisted in the design of a central staging area that served as the hub for communication between disparate data systems
• Improved nightly processes which gained several hours of processing time each night, which provided much needed margin with regard to maintenance and support of the data warehouse
• Designed several critical ETL processes using SSIS that provided the data for operational reports
• Worked with a team to design and implement a dynamic, data-driven SSIS process which provided auditing reporting for troubleshooting

• Integrated data from several of the largest hospital data systems including Siemens, McKesson and HBOC
• Lead developer/production support/data analyst for all existing and new data warehouse implementations. This included analysis and extraction of data from disparate Hospital Information Systems legacy systems for.
• Participated regularly with application design teams to identify needed database structure changes and the best way to utilize those changes in both ETL and applications sides of the data
• Performed routine data quality and impact analysis using SQL Query Analyzer, Enterprise Manager and other tools to ensure our main suite of applications is presented with an accurate and efficient data layer.
• Provided data analysis expertise to the three main business intelligence application development teams, as well as smaller development teams interacting with the data warehouse.
• Part of a two-man team which created custom-built ETL process for hospital patient accounting using SQL Server and Visual FoxPro interface