Jason Hover Email & Phone Number

Coeur d'Alene, Idaho, United States

Denver, Colorado, United States

Worked with client to transform their DW team and architecture by establishing standard patterns (data modeling & ETL), processes (agile & SDLC, etc.), and best practices (ETL/DB performance tuning approaches, etc.). This resulted in major gains in quality and speed of delivery, as well as improved team culture and morale. Functioned as lead architect, and.

Denver, Colorado, United States

The client was looking to retire their Informatica ETL implementation due to having implemented SAP across the business & thus now owning the SAP Data Services ETL tool. The objective was to migrate legacy Informatica ETL to SAP Data Services ETL and/or Teradata ELT.Worked closely with client’s ETL team to prove out new approaches, conduct performance.

Denver, Colorado, United States

The client was responsible for constructing the federally-mandated healthcare exchange at the state level to allow businesses and individuals to shop for and purchase health insurance. Designed the Informatica ETL processes for all three architectural layers, and collaborated with ETL team to develop patterns for each process to promote consistency.

Denver, Colorado, United States

The client was experiencing usability, performance and maintenance issues with their existing data warehouse. Assisted client in launching their EDW (“enhanced” data warehouse, in this case) initiative, as described below.Conducted dimensional modeling training/mentoring for internal client team; delivered twelve 2-hour in-depth sessions on dimensional.

Denver, Colorado, United States

Client had built a new debt collection system from the ground up and migrated a portion of their accounts to it. Remaining were 13 million accounts in a legacy debt collection system. The ETL team’s task was to construct a robust process for performing the migration, which populated dozens of tables in the target system, in large batches of accounts. As a.

Denver, Colorado, United States

ETL Architect / Developer responsible for ETL design and development related to a new EDW initiative charted with adding mine surface and process operational data to the data warehouse. Assisted with dimensional modeling activities for tracking detailed metrics (distance traveled, number of dumps completed, etc.) at mine sites around the globe, down to a.

Denver, Colorado, United States

Led the redesign of the company’s existing data warehouse architecture, from a hub-and-spoke model with department-specific data marts to a conformed dimensional bus architecture. This reduced the number of ETL layers that data flowed through, significantly improving development efficiency. Drafted a BI Center of Excellence (BI COE) organizational design.

Appleton, Wisconsin, United States

The client's data warehouse was in need of a redesign, due to the primary source system having recently changed, and the legacy DW being very source-specific. It also had significant stability, performance, functionality and usability issues. Led the redesign effort leveraging the bus matrix approach to create a conformed dimensional model (Oracle) for the.

Denver, Colorado, United States

Established strategy & vision for the EDW 2.0 project. The objective of the project was to address performance, functionality and usability issues associated with the current EDW, while also leveraging packaged BI apps (OBIEE) to the extent possible. The strategy was well received and the client expressed interest in pursuing it after the implementation of.

Denver, Colorado, United States

ETL Lead/Architect for the conversion of the Enterprise Data Warehouse from SQL Server to Teradata. Worked in conjunction with the data architect to significantly streamline and simplify the data and ETL architecture. Modified the ETL architecture where appropriate to leverage the power and performance of Teradata, and also to account for known limitations.

Denver, Colorado, United States

As the Technical Lead for the Supply Chain Management Reporting & Analytics (SCMRA) team, led the effort to distill a 600-row metrics requirements spreadsheet from the Standard Operations Procedures Handbook project team into a data warehouse “bus matrix” deliverable organized by business process & associated dimensions, to provide an overall scope and.

Denver, Colorado, United States

ETL Technical Lead for the Human Resources Data Warehouse (HRDW) project. Managed over 60 change controls (releases) including new development, enhancements, and bug fixes. This involved scoping ETL work, clarifying business requirements, defining technical requirements, resource balancing across developers, conducting design & code reviews (including unit.

Denver, Colorado, United States

Redesigned several ETL & reporting applications to improve performance & maintainability. For a particular BI app, reduced the reporting footprint (Cognos) from 18 reports to 2, the ETL load time (Informatica) from 80 hours to 2 ½ hours, and the unix shell script (ksh) which automated the system from from 1084 to 228 lines of code. Client was pleased with.

Charlotte, North Carolina, United States

Provided recommendations and high-level designs for improved load performance. Gathered and presented empirical evidence through testing various ETL tuning techniques in the client’s environment, using Informatica.

Denver, Colorado, United States

Assisted client with creating a Business Intelligence Center of Excellence (BI COE), to establish standards and methodologies to enable the enterprise to develop a consolidated, integrated analytics solution, rather than business-unit-specific stovepipe solutions. Performed high-level requirements gathering to generate a list of analytic requirements from.

Denver, Colorado, United States

Assisted in implementing an enterprise-wide financial data warehouse to enable holistic management reporting of revenue data across over 15 source systems.Developed UNIX scripts (Korn shell) to automate the ETL process, and performed ETL development in Informatica.

Denver, Colorado, United States

ETL developer (Informatica) on an energy trading credit risk data mart development project

Dallas, Texas, United States

Created a consolidated data warehouse to incorporate data from the firm’s sales force automation system, legacy system, billing system, and the state’s centralized electric customer registration system.Architected the ETL process, implemented ETL using Microsoft DTS, and developed reports including automated generation & distribution.

Denver, Colorado, United States

Various consulting roles... learning the roles with Tactica, a boutique DW/BI consulting company (later acquired by Experio, later acquired by Hitachi Consulting)