Summary

** ***** ** *********** ********** and 16 years in ETL processing using DataStage, Implemented and Tested of ETL applications in Banking, Healthcare and Retail performing Data Extraction, Data Cleansing, Data Transformation, Documented many programs. Data Loading and Data Analysis. Strong experience in Data Warehouse projects, created complex SQL statements using joins and sun queries. Familiar with all areas of Data warehouse. Expertise in design and development of ETL process using IBM Data Stage v7.5 thru 11.5, Upgrades from older versions to 11.5, Data Stage Designer, Data Stage Director, Parallel Extender (PX) and experience with Information Analyzer and Quality Stage

Technology

Operating Systems: Windows, Linux, Unix

Languages: SQL, T-SQL and My SQL

Tools: IBM InfoSphere DataStage, QualityStage, Information Analyzer, Autosys,

Toad, SQL Plus, SQL Server Management Studio, and others

Databases: Oracle 9I, DB2, MS SQL, SQL Server, Vertica and Netezza

PROFESSIONAL EXPERIENCE

General Motors Nov 2020 – Dec 2022

DataStage Developer

●Developed jobs in DataStage 11.5 using complex SQL Joins and Queries also used stages such as Aggregator, CDC (Change Data Capture), JDBC (Used for HANA/SAP), DB2 Connector, Lookup, Transformers, Remove duplicates, DataSets and Sequential Files

●Performed Sparse look ups and normal lookups.

●Created programs to update changing data similar to dimensional data.

●Created Sequences with Activities to run jobs daily and CMD stages to update some files with Starting dates to pull data.

●Support Middle East, South America and Europe ETL processes

●Reviewed Autosys logs and Unix logs to resolve any issues

Ahold-Delhaize April 2020 – Oct 2020

DataStage Developer

●Developed jobs in DataStage 11.7 using stages such as Look Up, Aggregator, Transformer, ODBC Connections, Seq File, Datasets and other

●Aggregated and Summarized three years of promotions and advertised sales

●Developed Sequence to run and schedule the DataStage jobs to produce test results

●Documented all jobs

Bank of America (Tata) Mar 2019 – Aug 2019

DataStage L3 Support

●Determine the appropriate code for ETL applications based on information gathered including data sources, data targets, data definitions, data relationships, and business rules

●Resolved support tickets that required some code changes and scripting changes while updating and testing DataStage jobs using Autosys

●Reviewed all security and privacy training and other training in the banking industry

●Provided level 3 Support for Credit card dept

Walmart (Tata) Oct 2018 – Mar 2019

DataStage Developer

●Migrated DataStage jobs from 9.1 to 11.5, DB2, UNIX

●Updated various UNIX scripts to perform automation of stopping and starting DataStage jobs

●Used DataStage stages namely Sequential file, Transformer, Aggregate, Sort, Datasets, Join, Lookup, Change Capture, Funnel, Peek, Row Generator stages in accomplishing the ETL Coding and MQ FTE

●Updated and tested DataStage jobs and Unix scripts to run in new environment

●Tested updated scripts / DataStage jobs

Encode Inc July 2017 – June 2018

Manalapan, NJ

Data Analyst (Worked Remotely)

●Installed and configured IBM’s Analyst Notebook, DB2 and DataStage for future project

●Attending Analyst Notebook Demo on data ingestion

●Configured and tested Analyst Notebook with Demo data and Law Enforcement example

●Created data to run jobs to extract data for Analyst Notebook

MRC Global Jan 2017 – June 2017

Charleston, WV

DataStage Developer(Remote)

●Developed and modified DataStage jobs and Sequences

●Documented IBM InfoSphere Data warehouse processes in DataStage 11.5

●Created detailed design documents for hundreds of ETL jobs and sequences processing facts and dimensions

●DB was DB2 9.7

HP Enterprise Oct 2015 – Oct 2016

Newark, DE

DataStage Developer

●Developed jobs to load data in slowly changing dimensions to the Data Warehouse using CDC Stage using DataStage 11.3

●Developed and modified DataStage jobs using Runtime Column Propagation to dump many tables

●Utilized Pivot, Looping, Transformer, Join, Lookup, User variables, Command stage and other stages

●Developed Job Sequences, job activities, execute commands, user variable activity and implemented logic for job sequence loops, recovery and restart

●Created detailed design documents for ETL jobs and Sequences

●Worked with State of Delaware Medicaid and Medicare systems

Bank of America June 2015 – Sept 2015

Newark, DE

DataStage Developer/Business Analyst

●IBM InfoSphere DataStage Version 9.5

●Reviewed scope and requirements to achieve Basel certification

●Created documentation for gaps and test cases

●Completed all required training for fraud prevention and other financial related crimes

●Worked as Business Analyst for Basel certification

XO Communication July 2014 – Jan 2015

Senior Technical Consultant

●Participated in analysis and design of new ODS from existing warehouses

●Developed tested and maintained IBM InfoSphere DataStage jobs and Sequences.

●Created processes to extract Master Data extracts from several sources using DataStage 9.1.2

●Implemented slow changing dimensions using Change Data Capture stage to load the Data Warehouse

●Prepared technical design/specifications for Data Extraction, Data Transformation, Data Cleansing and Data Loading

Otsuka Pharmaceuticals & IBM July 2014 – Oct 2014

Princeton, NJ

Senior Technical Consultant

●Migrated and Updated DataStage jobs and sequences to load data into Netezza Data Warehouse

●Created Unix scripts to run the assets required to be implemented

●Attended HIPAA training to for Data security and privacy requirements

●Adhered to HIPAA Privacy Rules and Compliance and received required training for the same

Bank of America June 2013 – April 2014

Newark, DE

Lead DataStage Developer

●Developed DataStage jobs to load data in slowly changing dimensions using CDC Stage in DataStage 9.5

●Created DDLs for DB2 and Vertica tables from Mainframe files and loaded the same tables

●Used Linux scripts and Osh Wrappers to load tables to Vertica and DB2

●Created and Implemented Information Analyzer and QualityStage rules

●Provided technical expertise and assisted DataStage developers with creating jobs and following best practices

●Created JIL scripts for implementation of effective Autosys jobs (job scheduler)

●Used Autosys job scheduler for automating the monthly regular run of DW

●Migrated and Tested all programs in several different environments

IBM Feb 2012 – April 2013

Raleigh, NC (Remote)

DataStage Developer

●Provided experienced technical consulting in the definition, design, and creation of many DataStage jobs in FDB

●Reviewed test results and verified Data transformations where implemented according to designed mappings

●Debugged and resolved any Data issues with Unicode and various NLS maps

●Implemented several Bit fields to match Data as it is produced today using PL/1 in a mainframe environment

●Mentored, assisted and lead junior DataStage developers and implemented DataStage ETL standards

●Developed many DataStage jobs on 8.5 using many different stages such as DB2 connectors, Transformers, Filters, Look ups, Joins and Complex Flat Files and others

●Assisted in trouble shooting issue HM jobs implemented April 2012

U.S. Department of State, Diplomatic Security Sept 2010 – Feb 2012

Arlington, VA

Database Analyst / DataStage Developer

●Provided experienced technical consulting in the definition, design, and creation of data migration and integration projects.

●Mentored Junior DataStage developers on IBM InfoSphere DataStage mapping and requirements

●Created ETL standard mapping document and demonstrated its use both for analyst and developers

●Developed many DataStage using DataStage 8.1.2 using many different stages such as ODBC connectors, Oracle enterprise, Oracle connectors, Transformers, Filters, Look ups, Flat Files and others

●Databases used: Oracle 9i, 10g and 11 and MS Access

ATK Corporation July 2010 – August 2010

Promontory, UT

DataStage ETL Developer

●Developed standard IBM InfoSphere DataStage job using the Oracle connector stage and documented the process for the initial dimension load

●Created and implemented and instructed DataStage developers in the use of Parameter sets

●Mentored Junior developers on DataStage mapping and requirements and documentation

●Demonstrated the creation and use Parameters sets

●Created standards and best practices document for DataStage

●Worked with DataStage version 8.1.2

Dana Corporation April 2010 – June 2010

Maumee, OH

DataStage ETL Developer

●Migrated existing ETL from DataStage 7.5 to 8.1 replacing Oracle 8i stages with Oracle ODBC

●Modified Parallel jobs with version 8.1 using Stages, which included Transformer, Sort, Join, Lookup, Filter, Aggregator, Funnel, Change Data Capture etc

●Migrated target DB from Oracle 9i to SQL Server

●Worked remotely as needed

●Used DataStage Designer to develop ETL processes to cleanse, transform, extract and load data to Data warehouse

●Used Infosphere information Manager to do analysis and review logs

●Utilized Administrator to create test projects and create of update Parameters and project properties

AMC Theatres Feb 2008 – Oct 2009

Kansas City, MO

DataStage ETL Developer

●Developed Parallel jobs in Unix AIX with version 8.0 using Stages, which included Transformer, Sort, Join, Merge, Lookup, Filter, Pivot, Aggregator, Funnel, Change Data Capture, Column Export, Column Import, etc

●Participated in development phase for Business Analysis and Requirements Gathering

●Worked remotely on Fridays and other times as needed

● Used DataStage Designer to develop ETL processes to cleanse, transform, extract and load data to Analytical Data Mart, ODS and Enterprise Data Warehouse from various Sources such as Flat files, Oracle and SQL Server

●Worked closely with data modelers to understand the business process and the Data Warehouse model

●Used Designer, Administrator, Director and Infosphere Information Manager to perform daily tasks

●Created detailed design documents, Technical Application Design documents and Mapping documents for ETL jobs to load the new Data Warehouse and several data marts

●Worked with DBA’s to address day-to-day issues with items like privileges, etc

●Utilized Erwin modeling tool to view data structures and Database design

●Created Job Sequences to Control the job flow execution using various Activitie

Royal Bank Of Canada

Ontario, Canada Feb 2007 – Dec 2007

DataStage ETL Developer

●Developed ETL Applications with DataStage 7.51A Parallel Extender using Stages, which includes Transformer, Sort, Join, Merge, Lookup, Filter, Pivot, Aggregator, Funnel etc.

●Designed Data Stage Jobs to extract data from Oracle and load to Data Marts and Data Warehouse

●Worked closely with Data Analyst and Data Architects to understand the business processes

●Created detailed design documents with illustrations to show data flow and processes

●Created Job Sequences to Control the job flow execution using various Activities

●Extensively worked on Parallel Extender using Parallel Processing (Pipeline and partition parallelism) techniques to improve job performance while working with bulk data sources

●Assisted the project manager in project planning, resourcing, ETL Designs and developing conceptual designs

Citi Bank June 2006 – Dec 2006

Duisburg, Germany

DataStage ETL Developer

●Developed ETL applications using IBM InfoSphere DataStage 7.51A Enterprise Edition on a Unix platform

●Developed ETL processes to cleanse, transform, extract and load data into Analytical Data Mart and Enterprise Data Warehouse from various Sources such as Flat file, Oracle and SQL Server

●Used Parallel Processing techniques to improve job performance

●Created Job Sequences to Control the job flow execution using various Activities

Blue Cross Blue Shield Jan 2006 – April 2006

Chicago, IL

DataStage ETL Developer

●Developed ETL applications using IBM InfoSphere DataStage Parallel Extender

●Created DataStage jobs summarizing patient billing and provider data

●Utilized Parallel Job Stages like Dataset, Sequential file, ODBC, Lookup/Lookup File set, Aggregator, Join, Transformer, Sort, Funnel, Remove Duplicates, Surrogate Key, Merge, Filter

●Created Job Sequences to Control the job flow execution using various Activities (Job Activity, Email Notification, Sequencers)

●Created scripts to send email and data to client site for review by end users

Inter American Development Bank July 2004 – Dec 2005

Washington, DC

DataStage ETL Developer

●Migrate Legacy DB2 Data Warehouse to DataStage Oracle 9I Data warehouse

●Extensively used Job Stages like Dataset, Sequential file, ODBC, Lookup, Aggregator, Join, Transformer, Sort, Funnel, Remove Duplicates, Merge, Filter, Hash files, etc

●Work with business analyst and DBA to learn Data Model business process to load new Oracle Data Warehouse

●Analyzed existing legacy code and created detail mappings and detail Design Documents of existing DB2 Data warehouse for migrating to new Oracle 9I Warehouse.

●Created views and code SQL in Oracle 9i to migrate legacy Data Warehouse

●Prepared test data from legacy system to perform unit testing and system testing for ETL routines

Inactive Clearance Level: Secret Expired (2/14)

U.S. Department of State

●PS800 Cyber Security Awareness Training

IBM HIPAA Compliance Program

●Department of Children and Families Training and Development September 2014

Education

University of Maryland, College Park, Maryland

Major Computer Science and Information services

Languages: Unix, Oracle SQL

Delaware County Community College, Media, Pennsylvania

Associates Degree Computer Science (MIS) GPA 3.64

Languages: Cobol II, Pascal, SQL, Visual Basic and C

Member: Phi Theta Kappa (Honor Society)

Computer Learning Center, Philadelphia, Pennsylvania

Certificate Computer Programming

Languages: COBOL, Assembler and JCL

Contact this candidate