Data Warehouse Consultant (Development and Analysis)

• Developing and enhancing ETL data load jobs with IBM DataStage and optimizing SQL in an IBM DB2 environment as part of the Agree21 data migration
• Analyzing data quality and developing test procedures
• Creating scripts in MS Powershell and documenting GIT deployment processes

Technologies RedHat Linux, IBM DB2 with DB Visualizer, IBM InfoSphere

• Analyzing data quality and performing consistency tests
• Creating and optimizing ad-hoc SQL queries for runtime performance with index optimization
• Prototyping partition and tablespace distribution for large tables
• Developing ETL data load jobs in Python in an IntelliJ environment
• Optimizing data query performance in Oracle DB using indexes, pragmas, and partitioning

• Developing and modeling a new data warehouse core in consultation with the business department
• Performing ad-hoc queries and risk analysis based on the DWH core for the business side
• Supporting the setup of a business layer based on the DWH core
• Defining and reviewing data mappings
• Developing and enhancing ETL data load jobs with IBM DataStage and PL/SQL in an Oracle, IBM DB2 (with IDAA), and MS SQL environment
• Analyzing data quality and developing test procedures
• Prototyping QuerySurge routines and integration into IBM DataStage
• Introducing a new data compression functionality into the data warehouse
• Connecting data from IBM CDC, Kafka/Avro, Schema Registry, and Kafka Connect framework with IBM DataStage and the Java Integration Stage
• Involved in areas: contract, partner, object, product, location, claim
• Updating SAP BO reports, universes, and lists of values
• Testing and updating InfoBurst configurations
• Reverse engineering historical ETL processes and troubleshooting
• Monitoring daily data processing and resolving loading issues

• Led a team and served as the point of contact for resolving technical and business issues
• Conducted data quality analysis of contract and debt collection data in a staging database and in the SAP GUI
• Migrated data from external source systems into a new SAP FS-CD system
• Performed as-is analysis, created data mappings, and analyzed data in collaboration with the business department

• Supported troubleshooting and function enhancements of ETL jobs for a CRM system
• Performed functional testing of SOAP components and assisted with software extensions
• Designed and implemented ETL jobs for data extraction
• Prepared development and test documentation for DataStage
• Optimized data extraction SQL for large data volumes in the CRM system
• Integrated DataStage web services into SAP NetWeaver

• Implementation, documentation and unit tests of ETL mappings
• Configuration and execution of unit tests
• Enhancement of existing ETL mappings based on business requirements
• Impact analysis and documentation of ETL mapping enhancements for SAP systems
• Programming PL/SQL stored procedures
• GUI programming of diagnostic tools for database interfaces using C#

• Designing a workshop presentation and project plan for a Daimler data warehouse
• PowerCenter Informatica ETL implementation of ETL mappings and populating a DB2 data model
• Programming and documenting a multithreading application on Linux (C++ and GTK)
• Extension to generate three-dimensional Mandelbrot figures, viewable with VRML plug-ins in modern web browsers

• Validating data and entity relationships, and assisting the business side in improving source data quality
• Creating SQL scripts for data analysis in Oracle DB
• Designing and programming ETL routines for Ascential DataStage
• Integration and testing in the IBM AIX environment
• Documenting and creating ETL mappings based on business requirements
• Developing control mechanisms for DataStage jobs using custom UNIX scripts

• Programming ETL routines for Ascential DataStage data warehouse
• Performance analysis and tuning, testing and integration in the HP Unix environment
• Creating stored procedures for validation
• Defining standards for data extraction and data transfer within Unix scripts and SQL
• Building a web user interface to manage the entire data warehouse process in PHP on HP Unix with Oracle DB connection