Roger Geiwitz Email & Phone Number

United States

Mr. Geiwitz has over 30 years of hands-on experience in data architecture and integration architectures. Including data warehousing, data virtualization, operational data stores, data management, data integration, requirements gathering, application development, support and training. EXPERIENCE OVERVIEW:- Hands-on involvement performing a technical review and comparison of Composite and Informatica Data Services including data caching, data masking, query optimization, and performance benchmarking.- Primary developer of ETL processes for a major web services provider. Several data warehouse was created for each independent Web application. The architecture utilized Informatica as the primary ETL Tool. - Hands-on involvement with requirements gathering, data migration, ETL development, data administration, data modeling, and database management, performance tuning and monitoring and Source-To-Target (STTM) Mapping documents- Primary ETL Architect of data warehouse implementations for several fortune 500 companies- Designed and implemented the data architecture for a large data migration from IBM mainframe to a distributed architecture- Participated in the implementation of a support organization required to support a Corporate Information Factory implementation; the tasks included hardware support software support, network support, help desk support, change control and configuration management- Managed the movement of 138 Oracle databases and applications from a data center in San Diego to a permanent data center in Colorado. This was part of a larger effort to move the entire production data center from San Diego to Denver Colorado

Denver, Colorado, United States

The project at UCHealth was for the supply chain department. They had built a report and data distribution application using Stored Procedures. The stored procedures got so large they were unable to maintain or enhance them. The decision was made to migrate all stored procedure functionality to utilize SSIS ETL technology. They also need to move to a more flexible reporting database. They decided to use a Datamart design. Mr. Geiwitz was responsible for documenting the functionality that was contained in these stored procedures and move that functionality to SSIS packages. He was also responsible for designing and implementing the new Datamart for reporting purposes. - Converted a SQL Server stored procedure-based reporting architecture to a SSIS Data Mart environment.- Created source-to-target mappings (STTM) using an industry standard for documenting ETL transformation requirements.- Designed and implemented data mart using star schema dimensional modeling.- Designed developed and implemented over 100 SSIS packages to populate acquisition layer and presentation layer (data mart) databases. - Trained UCHealth employees in SSIS, team development services and database design

Denver, Colorado, United States

Mr. Geiwitz primary responsibilities are as follows:- Analyzed data requirements based on current reporting and the stored procedures that supported that reporting.- Designed data acquisition and integration architecture to support current and future reporting using SSIS as the ETL tool.- Designed and implemented data mart architecture using star schema design.- Converted stored procedure functionality to SSIS packages for loading the new data mart architecture. - Architected design for the development, test and production environments.

Denver, Colorado, United States

Mr. Geiwitz primary responsibilities are as follows:- Part of 6-person team to assess the current reporting environment for Home Advisor.- Developed roadmap for implementing an integration architecture to cloud based Snowflake database.- Architected an integrated data model to support marketing efforts.- Gathered business requirements and created STTM mappings for all ETL development.- Design developed and implemented Informatica mapping to populate Snowflake from an existing data warehouse and additional data sources.- Worked in a strict Agile environment.

Denver, Colorado, United States

Mr. Geiwitz primary responsibilities are as follows:- Received data requirements for the BI analysts to analyze the best ETL solution to satisfy the requirements.- Created detailed ETL design document that will be used by the ETL developers who will do the ETL development- Documented the source-to-target mappings (STTM) for extracting the data from the sources systems- This also included documenting any transformation, aggregations and/or conforming of the data- Unit and system tested all load processes - Performance tuned ETL processes running on a continuing basis- Extensive data analysis was required to resolve the most difficult of data problems- Performed code reviews for all code developed by the ETL developers.- Worked in a strict Agile environment.

Denver, Colorado, United States

Janus Capital did have a full Data Warehouse containing transaction data. The issue was the backlog of work to be performed was six months to a year out impacting management need for data. To resolve this issue, they utilized Virtual software that brought together data from many sources for reporting without storying the data. Composite software was chosen for the virtual environment. An environment was set up to provide rapid access to data for management until permanent solution is developed. Mr. Geiwitz was responsible for designing and implementing the virtual environment. - Developed and implemented processes in order for Composite to better communicate to Autosys (External Scheduler) when failures occur when loading cache tables.- Developed Composite SQLScripts to do production monitoring of cache tables and report to Autosys when a failure occurred so that the Autosys job would fail also.- Designed and documented an interface between 3 sources and Salesforce.com using Composite Data Virtualization. - Created Composite views and SQLScripts to integrate data from 3 sources to be a source of data into Salesforce.com.- Migrated all Composite objects from development to production.- Created production support documentation.- Designed and developed Informatica mappings to support a Cognos reporting environment.

Denver, Colorado, United States

The U.S. Army was unable to track recruit’s from when they signed up to Join the Army to when they were accepted into the Army. This 18-month project consisted of gathering requirements, designing the underlying data architecture, mapping source-to-target requirements to load the reporting system, creating the reporting system database and loading it using SSIS. All reporting was performed using Cognos reporting software. Mr. Geiwitz was responsible for performing all function except the Cognos reporting.- Part of 3-person team to assess the current reporting environment for U.S. Army recruiting.- Developed roadmap for implementing an integrated data warehouse for Army Recruiting Marketing Group.- Architected an integrated data model to support marketing efforts.- Architected the data flow from several source systems to an integrated data warehouse.- Documented and implemented Leading Practices for all data warehouse projects.- Documented ETL requirements for populating the integrated data warehouse.- Currently implementing marketing integrated data warehouse.- Design developed and implemented in SSIS the architected solution I designed.

San Diego, California, United States

LPL Financials did not have the time and budget to build a full Data Warehouse of financial transaction for reporting. To resolve this issue, they utilized Virtual software that brought together data from many sources for reporting without storying the data. Composite software was chosen for the virtual environment. Mr. Geiwitz was responsible for designing and implementing the virtual environment. - Installed and Configured Composite Software- Configured Security that included column and row level security- Designed and implemented Virtual tables for internal financial system using Composite. These tables included virtualizing tables from 8 separate Microsoft SQL Server Databases - Set up best practices for doing Data Virtualization on an ongoing basis at LPL- Converted several stored procedures to use Composite. These stored procedures resulted in:o Web Service – For external customers access to their Datao Data Service – For internal processing and reporting- Performed performance tuning to reduce run times that included:o Caching the virtual tables for speed of retrievalo Using data shipment for speed of retrievalo Setting up SQL Server Bulk copy for speed of loading cached tables- Performed demonstrations on how to use Composite Software to the LPL employees- Performed production comparison between Composite and another Data Virtualization product

Denver, Colorado, United States

This project was the implementation of a loyalty program that required Point-of-Sale (POS) transactions to be able to apply points making the purchase to their loyalty number. The actual loyalty software was handled by a third-party vendor but feeding data to the loyalty software was the responsibility of the ETL team. Every night POS sales were downloaded and formatted into an XML format and fed to the loyalty software using WEB services software. The status of the loyalty account was fed back to Sports Authority using a WEB service and loaded into a DB2 database for access in real time by the POS software. Mr. Geiwitz led the ETL team that was responsible for moving data to and from the Loyalty application.- Documented the source-to-target mappings for extracting the data from the sources systems- This also included documenting any transformation, aggregations and/or conforming of the data- Unit and system tested all load processes - Performance tuned ETL processes running on a continuing basis which required execution in 10 second time frames.- Develop and test mappings that consumed and produced SOA messages that were loaded into the target tables- SOA message processing was required to run in near real time- Resolved performance issues to meet SLA requirements for each message - Extensive data analysis was required to resolve the most difficult of data problems- Provided production support for all processed developed for the Data Center Messaging program by several Informatica developers- Developed several UNIX KORN Shell scripts to support functions that were best performed outside of Informatica- Defined and created all scheduling jobs using an external job scheduler called Robot- Created and implements an Audit process for recording runtimes, batches and dynamic parameter file

Denver, Colorado, United States

TransFirst is a credit card processing company that needed to be able to collect large amounts of individual credit card transactions. This 8-month project included gathering requirements, designing the data architecture, mapping the source-to-target load process, creating the ETL programs required to load the data, validate the validity of the data to be loaded and created the Cognos reporting that TransFirst required. Mr. Geiwitz was responsible for performing all function required for gathering and loading all transaction data.- Assisted with requirements gathering for the data integration architecture- Designed and implemented the ETL server architecture- Installed and configured Informatica server components- Designed and documented ETL naming and development standards for project- Designed and documented the change control and security architecture for ETL development- Implemented an audit control architecture for the integration process- Designed, developed, and tested Informatica mappings and batch control processes

Miami Metropolitan Area

JM Family is the importer of all Toyota and Lexis auto’s in the south east region. Their objective was to migrate packages off a mainframe to different packages in UNIX environments. All packages needed to exchange data in a real time Service-oriented architecture (SOA) utilizing Simple Object Access Protocol (SOAP) to do the message transferring. IBM MQ was used to que the transactions once they arrived at the target application. This was all done through a datahub that utilized Informatica for pulling the mainframe data and loading to the datahub. This 24-month project had two areas of responsibility that were performed by 2 separate people. The hardware software implementation was handled by one of the people and Mr. Geiwitz was responsible for the Data Architecture and moving the data. His team consisted of 10 developers.- Led data migration including large scale data consolidation and cleansing- Designed an Operational Data Store to support data sharing between the new applications and the remaining mainframe applications- Architected the data flow from several source systems to the Operational Data Store.- Created and documented Operational Data Store data model using near 3rd normal form modeling techniques- Designed and document the data flow from the Operational Data Store to the existing Data Warehouse- Assisted in documenting Leading Practices for future migration projects- Developed roadmap for implementing Data Governance in the new environment.