OBJECTIVE

• To continue my computer science career with a progressive and growth oriented organization and to seek the opportunity to fully utilize my education, background, experience, interpersonal relationship skills, and proven administrative abilities.

TECHNICAL SKILLS

Software: Data Warehouse; Oracle 11g; IBM InfoSphere DataStage 11.5; Python 3.4; Excel power query 2016; SQL Server Integration Services SSIS; Business Objects 10; OBIEE Reports; SQL*Plus; SQR Report Writer; Visual Studio 2016; PeopleSoft EPM 9.1; PeopleSoft HRMS 9.1;PeopleSoft Financials 9.1 General Ledger, Payables, Receivables.

Operating Systems: WIN; UNIX; DOS

PROFESSIONAL EXPERIENCE

Confidential, Charlotte

Senior Analytics Technology Developer

Responsibilities:

• Develop Python 3.4 programs to verify text files format for processing,
• Created DataStage 11.5 Parallel ETLs, to load text files.
• Created DataStage 11.5 Parallel ETLs, to clean, verify and load data into the OWS.
• Implemented SCD type 2 for OWS and MDW to facilitate as of date reporting.
• Develop UNIX script to move files from input folder to proper folder for processing.
• Develop DataStage 11.5 Parallel ETLs to parse multi record type file for ETL processing.

Confidential, Platteville, WI

Business Intelligence Team Lead

Responsibilities:

• Installed Campus Solutions for EPM 9.1 data warehouse.
• Created new DataStage 8.5 Parallel ETLs, to clean, verify and load data into the OWS.
• Installed update and configured dimension and fact tables to accommodate custom tables.
• Improved the overall load time from 16 hours to less than 4 hours from the campus solutions source system to the Data Marts.
• Created new DataStage 8.5 Parallel ETLs, for the top ten slowest ETLs improve performance.
• Developed change management ETL process to detect changes in online system to improve uptime of data warehouse.
• Developed error reporting ETL to facilitate distributive departmentalized reporting to help end - users correct data issues.
• Knowledge transfer of staff to ensure independents.
• Modified delivered ETL maps to facilitate changed or missing data structures in the online system.
• Automate load process through the director with email notification.

Confidential, Madison, WI

ETL Developer

Responsibilities:

• Created database triggers to capture “changed data” from the source database to ETL into EPM 9.1 data warehouse.
• Created new DataStage 7.5.2 ETLs, to clean, verify and load data into the
• Created new DataStage 7.5.2 ETLs, to enrich and load data into the enrichment layer of the EPM 9.1 data warehouse.

Confidential, Manhattan, NY

ETL Developer

Responsibilities:

• Design and develop Ascential DataStage 7.5.2 ETLs, to load payroll data from several different systems from several different countries into EPM 9.1.
• Design and develop complicated data cleansing and validation procedures.
• Design and develop Ascential DataStage 7.5.2 ETLs, to load OWS tables into MDW data warehouse.
• Design and develop Ascential DataStage 7.5.2 procedures to auto load data from dissimilar systems using source system variables.

Confidential, Albany, NY

ETL Developer

Responsibilities:

• Document and design customizations for EPM 9.0 data warehousing process in Oracle 11g.
• Developed Ascential DataStage 8.1. data maps to move data from OLTP database to OWS of data warehouse.
• Created a custom Repository for custom OBIEE reports.
• Created custom views in the Repository to facilitate business rules for OBIEE reports.
• Developed custom OBIEE reports for general ledger.
• Developed custom OBIEE reports for accounts payables and account receivables.

Confidential, VA

Sr. System Consultant

Responsibilities:

• Designed data models for the data warehouse process using Erwin Data Modeler.
• Developed data warehouse product using DataStage 8.1.
• Developed DataStage 8.1. data maps to move data from OLTP database to ODS of data warehouse.
• Developed DataStage 8.1. incremental data maps to move data from ODS to data warehouse tables.
• Developed incremental DataStage 8.1. data maps to move data from ODS to dimensional and fact tables of data marts.

Confidential

DataStage Developer conversion specialist

Responsibilities:

• Worked with data modeling team to develop OLTP production database using Erwin Data Modeler in Oracle 11g.
• Developed QualityStage map to perform name cleansing.
• Developed QualityStage map to perform address cleansing.
• Developed QualityStage map to perform date cleansing.
• Developed Ascential data maps to move data from mainframe legacy system into
• Oracle database 11g tables using complex flat file.

Confidential, Tallahassee, FL

PeopleSoft 9.0 EPM Developer

Responsibilities:

• Converted EPM 8.8 to EPM 9.0 for PeopleSoft Financials.
• Created new Ascential maps to work with customized tables to load data into existing EPM tables.
• Created new Ascential maps to populate new data marts.
• Developed Ascential data maps to load customized tables from PeopleSoft Financials 9.0 to create custom data mart.
• Reduced total load time from thirteen hours to seven hours.
• Developed financial Business Object reports, accounts payables and account receivables.

Confidential, Tucson AZ

PeopleSoft 8.9 EPM Developer

Responsibilities:

• Configured EPM 8.9 delivered Ascential data maps to work with PeopleSoft Financials and Supply Chain Management 8.0.
• Created new Ascential maps to work with customized tables to load data into existing EPM tables.
• Modified existing Ascential maps to populate delivered data marts.
• Developed Ascential data maps to load customized tables from PeopleSoft Financials 8.0 to create custom data mart.
• Implemented SCD type 2 for OWS and MDW to facilitate as of date reporting.

Confidential, Chantilly, VA

PeopleSoft EPM 8.8 Implementation - Programmer/Analyst

Responsibilities:

• Designed and implement ODS tables, data loader maps, data warehouse tables.
• Conducted fit/gap analysis between PeopleSoft SCM 8.4 and PeopleSoft EPM 8.8.
• Designed and implement alternative solutions to resolve gaps.
• Created custom Informatica 6.1 maps to load legacy data into ODS.
• Implemented and executed Informatica 6.1 processes to migrate data from source systems.
• Trained client staff to manage and maintain EPM process.

Confidential, Reston, VA

PeopleSoft EPM 8.8 Implementation - Programmer/Analyst

Responsibilities:

• Performed analysis and development of four data marts.
• Designed and implement ODS tables, data loader maps, data warehouse tables, data mart tables and data mart builder.
• Conducted fit/gap analysis between PeopleSoft Financials 8.8 and PeopleSoft EPM 8.8.
• Designed and implement alternative solutions to resolve gaps.
• Created custom Ascential DataStage 7.1 maps to load legacy data into ODS.
• Implemented and executed Ascential DataStage 7.1 processes to migrate data from source systems.
• Developed and modified Cognos cubes to facilitate custom reports.
• Trained client staff to manage and maintain EPM process.

Confidential, Oklahoma City, OK

Position: PeopleSoft EPM 8.8 Implementation - Programmer/Analyst

Responsibilities:

• Performed data analysis on source system to identify corrupt data due to implementation, conversions, and mergers.
• Conducted fit/gap analysis between HR 8.3 and PeopleSoft EPM 8.8.
• Designed and implement alternative solutions to resolve gaps.
• Coordinated and conducted system testing and researched/resolved testing issues.
• Implemented and executed Informatica processes to migrate data from source systems
• Analyzed external source data from ADP payroll and benefits and mapped it to PeopleSoft payroll tables.
• Created custom Informatica maps to load ADP payroll and benefits data into ODS.
• Trained client staff to manage and maintain ETL process.
• Installed and upgraded informatica PowerMart from 5.1 to 6.1.

Confidential, Green Bay, WI

PeopleSoft EPM 8.3 Implementation - Programmer/Analyst

Responsibilities:

• Conducted fit/gap sessions and demonstrated PS 8 Enterprise Warehouse functionality.
• Scoped client’s business requirements.
• Developed Informatica ETL maps to move data from operational system to the ODS that was not delivered with PeopleSoft EPM 8.3.
• Used Informatica to load the staging and reporting tables in PeopleSoft EPM 8.3.
• Coordinated and conducted system testing and researched/resolved testing issues.
• Trained client staff to manage and maintain ODS system.
• Completed on a timely basis the development of all conversion SQRs used to convert employee data into the new system.