Summary

• 15+ years of experience successfully implementing or remediating Business Intelligence (BI) and Data Warehousing (DW) programs
• 10+ years of experience standing up high - performance agile DW/BI teams

PROFESSIONAL EXPERIENCE

Data Warehousing/Business Intelligence

Confidential, Indianapolis, IN

Responsibilities:

• Implemented scaled agile framework (SAFe) for BI/DW product development and delivery, coordinating that effort with a certified SAFe trainer and coach.
• Served the agile BI team as data architect, BI/DW developer, scrum master, and product owner while helping management to attract and hire qualified staff to permanently fill these roles.
• Trained existing staff how to create and use both data vault and dimensional modeling techniques.
• Worked directly with business unit directors and other stakeholders to implement SAFe at a program level, to build their backlogs, and to define their acceptance criteria.
• Utilized Datawa.re to automate ETL processes and to provide data lineage and other audit controls.
• Modeled in-memory datasets and delivered reporting using Qlikview.
• Brought clarity and impact to communications between IT staff and business stakeholders.

Data Warehousing/Business Intelligence

Confidential, Indianapolis, IN

Responsibilities:

• Designed and helped construct processes to integrate newly-acquired subsidiary operations
• Assisted with migration of MS Dynamics GP from an on-premise to an AWS cloud instance of MS SQL Server

Data Warehousing/ETL Architect

Confidential, Indianapolis, IN

Responsibilities:

• Designed and helped construct solution using MS SQL Server 2014, SSIS, SSAS tabular, Power BI, and Tableau.
• Ensured deliverables met expectations of the client’s executive team.

ETL Data Warehousing/Business Intelligence

Confidential, Wooster, OH

Responsibilities:

• Brought low-performing MS SQL Server 2012 R2 SSIS ETL jobs up to expected performance levels.
• Presented to executive team a summary of options for improving overall data management efficiency.

ETL Data Warehousing/Business Intelligence

Confidential, St. Louis, MO

Responsibilities:

• Designed and constructed an enterprise data warehousing solution to satisfy reporting requirements for clinical care excellence using MS SQL Server 2014, SSIS, SSAS multidimensional, and SSRS.
• Provided roadmap for future improvements to enable more rapid integration of new data sources.

ETL Data Warehousing/Business Intelligence

Confidential, Anderson, IN

Responsibilities:

• Designed and constructed an enterprise data warehousing and business intelligence solution to warehouse and report information measuring overall equipment effectiveness using MS SQL Server 2014, SSIS, and IBM Cognos 10 Business Intelligence suite.
• Partnered with multiple services providers, including Datawa.re data management services, to reduce cost, and speed delivery time.
• Provided direction for both staffing and infrastructure needs.
• Participated in interviews with candidates for employment.

Data Integration/Migration Specialist

Confidential, Indianapolis, IN

Responsibilities:

• Modified a customized sales and marketing software package to accommodate organizational changes affecting this departmental solution.
• Participated as part of a multi-person delivery team to achieve client satisfaction.

ETL Developer

Confidential, Indianapolis, IN

Responsibilities:

• Completed SSIS construction and resolved quality issues uncovered during solution implementation.
• Participated as part of a multi-person delivery team to achieve client satisfaction.

Data Modeler/BI Architect

Confidential, Indianapolis, IN

Responsibilities:

• Prepared and presented an introduction to Data Vault and Agile BI concepts and implementation strategies.
• Designed data vault model using ER/Studio.
• Interviewed and hired ETL and BI development resources.
• Prepared and executed marketing plan to support adoption of agile BI methodologies.
• Implemented reporting solutions for financial operations using DB2 and Cognos 8.
• Developed Cognos reporting solution for JD Edwards data residing on AS/400.
• Developed project plan for upgrade to Cognos 10.

Data Warehousing Architect/BI Developer

Confidential, Indianapolis, IN

Responsibilities:

• Designed reporting solution for cardiac registry reporting using ER/Studio, SSIS, and SAP BusinessObjects BI 4.0.
• Evaluated MicroStrategy, IBM Cognos 10.2, and SAP BusinessObjects BI 4.0 for purchase for this implementation.
• Interviewed and selected BO developer and SSIS ETL resource.

Data Warehousing/Business Intelligence Architect

Confidential, Columbus, OH

Responsibilities:

• Architected framework for enterprise data warehouse and business intelligence reporting using ER/Studio, Oracle DB, SSIS, and SSAS multidimensional.
• Implemented Data Vault and Agile BI Development Methodology.

Data Architect/ETL Architect/ETL Developer

Confidential, Fishers, IN

Responsibilities:

• Produced BI and ETL solutions using MS SQL Server 2008 R2, SSIS, JavaScript, and SAP Business Objects. Gathered requirements, produced dimensional data model, and designed data mart.
• Managed and mentored SSIS ETL development staff.

BI Architect/Developer

Confidential, Bloomington, MN

Responsibilities:

• Implemented BI solutions using Cognos 8 BI Framework Manager, Transformer, Report Studio, Analysis Studio, and Query Studio. Extracted data from Cognos Planning, TM1, Hyperion, and ODBC data sources.

Data Warehousing/ETL/BI Architect/Developer

Confidential, Richardson, TX

Responsibilities:

• Completed delivery of four very complex interactive reports critical to the success of Region 10's multimillion-dollar EMPOWER Data Warehouse and Business Intelligence offering.
• Discovered opportunities for sweeping improvements to the data model and ETL processes that could fundamentally transform Region 10's ability to meet its current and future service level agreements.
• Worked in cooperation with the staffs of both divisions, a cross-functional team of over 20 skilled professionals, to seize this transformational opportunity.
• Met with the superintendents and administrative staff members of client independent school districts to define requirements and formulate workable solutions.
• Modeled the business dimensionally and worked with the database administration staff to implement the model, while expanding their knowledge base in the DW/BI space as it pertains to database design, scalability, extensibility, and optimization.
• Worked very closely with the ETL development and BI reporting staff members to achieve a cooperative and synergistic working relationship focused on those matters of greatest importance to the clients.
• Served as a close and trusted adviser to the CIO and the Director of Data Warehousing in matters regarding the BI road map, allocation and acquisition of staff, and personnel issues, including the need to create a new Assistant Director of Data Warehousing position.
• Intimately involved in the process of interviewing and selecting for hire an individual to fill that position.
• Served as a consultant to the newly-hired Assistant Director of Data Warehousing until he could take over all day-to-day duties and responsibilities.

Data Warehousing/BI Architect

Confidential, Chevy Chase, MD

Responsibilities:

• Reviewed and advised on infrastructure, data modeling, database design and optimization, ETL processing, and BI reporting and development for the simultaneous implementation of BI programs for the interactive advertising division of each of these three communications conglomerates.
• Directed and supervised the overseas ETL development effort, which was executed simultaneously for both Oracle and SQL Server data warehouse platforms.
• Served as the primary Cognos report developer, while also providing support and advise for simultaneous development efforts using both Business Objects and MicroStrategy. The functionality of each BI program was essentially identical, but each client had already selected their tools prior to program initiation. This created the necessity for multiple database platforms and BI tools in these implementations. The strategy, however, was truly tool-agnostic, utilizing Kimball's full life-cycle methodology for iterative development and implementation.