SUMMARY:

• 13 years of experience in IT using DataStage, Implementation and Testing of ETL applications in Banking, Healthcare and Retail performing Data Extraction, Data Cleansing, Data Transformation, Data Loading and Data Analysis.
• Strong experience in Data Warehouse projects, familiar with all areas of Data warehouse.
• Expertise in data requirement analysis, design, development of ETL process using Confidential Data Stage v7.5 thru 11.3 Data Stage Designer, Data Stage Director, Parallel Extender (PX) and experience with Information Analyzer and Quality Stage

TECHNICAL SKILLS:

Operating Systems: Windows, Linux, Unix Sun Solaris 5.10, and AIX 5.3

Languages: SQL, T - SQL, My SQL

Tools: 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

EXPERIENCE:

Confidential, Charleston, WV

DataStage Developer

Responsibilities:

• Worked remotely
• Documented extensive Confidential InfoSphere Data warehouse processes in DataStage 11.3
• Work was off-shored

Confidential, Newark, DE

DataStage Developer

Responsibilities:

• Developed and modified DataStage jobs using Runtime Column Propagation to dump many tables
• 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
• Migrated jobs from DataStage 8.5 to 11.3
• Developed jobs to load data in slowly changing dimensions to the Data Warehouse using CDC Stage using DataStage 11.3
• Utilized Pivot, Looping, Transformer, Join, Lookup, User variables, Command stage and other stages

Confidential, Newark, DE

DataStage Developer/Business Analyst

Responsibilities:

• Worked as Business Analyst for Basel certification
• Confidential 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

Confidential

Senior Technical Consultant

Responsibilities:

• Participated in analysis and design of new ODS from existing warehouses
• Developed tested and maintained Confidential InfoSphere DataStage jobs and Sequences.
• Implemented slow changing dimensions using Change Data Capture stage to load the Data Warehouse
• Created processes to extract Master Data extracts from several sources using DataStage 9.1.2

Confidential, Princeton, NJ

Senior Technical Consultant

Responsibilities:

• Attended HIPAA training to for Data security and privacy requirements
• Adhered to HIPAA Privacy Rules and Compliance and received required training for the same
• Created and Updated DataStage jobs and sequences to load data into Netezza Data Warehouse
• Created Unix scripts to run the assets required to be implemented

Confidential, Newark, DE

Lead DataStage Developer

Responsibilities:

• 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
• Created and implemented Information Analyzer and QualityStage rules
• Performed thorough data profiling by using the Investigate stage of Quality Stage
• 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)
• Developed jobs to load data in slowly changing dimensions using CDC Stage in DataStage 9.5
• Used Autosys job scheduler for automating the monthly regular run of DW
• Migrated and Tested all programs in several different environments

Confidential, Raleigh, NC

DataStage Developer

Responsibilities:

• 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

Confidential, Arlington, VA

Database Analyst / DataStage Developer

Responsibilities:

• Provided experienced technical consulting in the definition, design, and creation ofdata migrationand integration projects.
• Mentored Junior DataStage developers on Confidential 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

Confidential, Promontory, UT

DataStage ETL Developer

Responsibilities:

• Developed standard Confidential 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

Confidential, Maumee, OH

DataStage ETL Developer

Responsibilities:

• 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
• UsedDataStage Designerto 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

Confidential, Kansas City, MO

DataStage ETL Developer

Responsibilities:

• 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
• UsedDataStage Designerto 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 Activities

Confidential

DataStage ETL Developer

Responsibilities:

• 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

Confidential

DataStage ETL Developer

Responsibilities:

• Developed ETL applications using Confidential 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

Confidential, Chicago, IL

DataStage ETL Developer

Responsibilities:

• Developed ETL applications using Confidential 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)
• Developing various ETL jobs to extract, cleansing, transforming, integrating and loading data into Data Mart and Data Warehouse
• Aggregated and summarized data from multiple sources to be used by business for marketing
• Created scripts to send email and data to client site for review by end users

Confidential, Washington, DC

DataStage ETL Developer

Responsibilities:

• Migrate Mainframe 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.