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 implement business intelligence, data warehousing, and analytics products for the company.Specific responsibilities include the design and maintenance of application databases in SQL Server and Postgres; visual design using Tableau desktop with end-user presentation implemented via Tableau server; all responsibilities regarding data ETL using SQL Server Integration Services (SSIS).

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 upgradeTrain end-users in multi-dimensional concepts and Tableau Desktop use

- 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 responsible for all operational reporting for direct-to-consumer and wholesale sales data• 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• Designed, implemented and maintained a system that helped manage Fathead’s licensing agreements and product cost data to be used in the data warehouse. • Built SSAS 2005/2008 cube which was used to deliver direct and wholesale sales analysis, customer metrics, royalty liability data and product cost analysis• Implemented ProClarity desktop integration with the Analysis Services environment and provided training and support to the end-users• Designed, programmed and maintained dozens of operational and analytical reports. • Implemented and supported Excel 2007 integrations with the Analysis Services cube• Designed, implemented and maintained a Dundas dashboard that provided a real-time view of our website sales activity throughout the day

- 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 to the warehouse. It also provided feedback to the Lakewood loan system to help improve processes upstream• 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• Converted several ETL jobs from DTS to SSIS• Subject matter expert for overall data warehouse data and process flow• Worked with several business users to refine and implement processes in the data warehouse to provide answers to business questions• Developed support materials and trained “The Guy” tier-one support to handle end-users issues• Trained all new hires on our ETL processes and overall construct of the data warehouse, including the life-cycle of a loan through the Quicken Loan System• Using SQL Server Reporting Services (SSRS), designed and created operational reports based on specifications provided by the Metrics team

• 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 translation and import into the data warehouse, maintenance and enhancements of existing warehouse implementations. • 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• Interacted directly with hospital business office professionals to assess business process needs and provide analysis and reports using the data warehouse• Using business requirements provided by the client, designed and implemented a patient communications process using the data warehouse which increased patient communication accuracy by 30% over the legacy health information system capabilities• Lead developer on an auto-outsourcing product which used data feeds from HIS legacy systems and sent the account placement data, as well as daily data updates, to outside vendors in an XML format. Product also provided the hospital with outsourcing vendor performance report cards, monthly fee reports and communications from the vendor back to the legacy system through an automated electronic process