SUMMARY

• Over 9+ years of overall IT experience with 7 years of experience on Extraction, Transformation and Loading (ETL) processes using IBM DataStage and QualityStage 8.7/8.1/ 7.x
• Extensive knowledge of Data Warehousing, business intelligence, ETL processing and Data Modeling
• Experience in designing and implementing Data Mart applications, mainly transformation processes using ETL tool DataStage.
• Experience in using Information Analyzer for column analysis, primary key analysis and foreign key analysis
• Designing and developing jobs using DataStage Designer DataStage Director and DataStage Administrator.
• Developed jobs for SCD Type 2 using CDC stage, developed ABAP programs using datastage to extract data from SAP.
• Extensively used DataStage Designer to design and develop server and parallel jobs to migrate data from transactional systems (Sybase, DB2UDB and flat files) into the Data Warehouse.
• Expertise in Designing Parallel jobs using various stages like join, merge, lookup, remove duplicates, filter, dataset, lookup file set, modify, aggregator, Transformer.
• Knowledge in Extraction, cleansing and modification of data from/to various Data sources like Oracle, XML files, Flat files and Comma Delimited files.
• Extensively worked on DataStage Parallel Jobs using Various Stages like Join, Lookup, Change Capture, Filter, Funnel, Copy, Sort, File set, Sequential File, Data set, Oracle Enterprise, Merge, Aggregator, and Remove Duplicate Stages.
• Experience working with Pentaho Data Integration Tool
• Practical Understanding of Data Modelling concepts like Star Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables.
• Experience in Data warehouse development life cycle and Design of Data marts
• Worked with DB2, SQL, SQL*PLUS, Oracle PL/SQL, Stored Procedures, Table Partitions, SQL queries, and loading data into Data Warehouse/Data Marts.
• Good knowledge of Database concepts such as indexing, views, schemas and other database objects in both Oracle and DB2 databases.
• Conceptual knowledge of Pentaho Report Designer, Hyperion and Cognos.
• Detail oriented with good problem solving, organizational, analysis, highly motivated and adaptive with the ability to grasp things quickly.
• Ability to work effectively and efficiently in a team and individually with excellent interpersonal, technical and communication skills.

TECHNICAL SKILLS

ETL Tools: InfoSphere Information Server 8.7/8.1 (Datastage, Quality stage & Information Analyzer), Ascential Data stage 7.5/7.1(Designer, Director, Manager, Administrator), Pentaho, SQL*Loader

Environment: Linux, Unix, DOS, ESXi (VMWare), Windows Server 2003/2008, Windows NT 4.0/ 2000/ XP/ 7, IBM AIX, IBM - PC Compatibles

Databases: Oracle 10g/11g, MS SQL 2005, DB2 9.x

GUI: Autosys 4.5/11.3, Toad for Oracle, SQL Navigator, Visual Basic 5.0/6.0, IBM Datastudio

Languages: SQL, T-SQL, Oracle-PL/SQL, C/C++, VB Script, Perl script

Applications: MS proxy server, NetApp Storage, VMWare View, vSphere, Putty, Erwin r7, SAP 7.30

PROFESSIONAL EXPERIENCE

Confidential - Columbus, OH

Sr. ETL Developer

Responsibilities:

• Work with the BA to gather and analyze requirements.
• Designed and developed Dimension and Fact jobs
• Work with the DBA to develop tables in Staging and Dimension layers.
• Code review, debugging, troubleshooting and performance tuning of Datastage jobs.
• Co-ordinated with the reporting team for understanding their requirements and designing the tables and jobs accordingly.
• Generated Ad-hoc reports in Cognos to test the data sources for reports.
• Involved in the meetings with the Client and Users, and responsible for providing progress updates and demos.

Environment: IBM Infosphere Datastage 11.3 (Designer, Director, Administrator), DB2, IBM Data Studio 4.1, MS SQL server Management Studio 12.0, Cognos

Confidential - Houston, TX

Lead ETL Developer

Responsibilities:

• Work with the Mainframe and COBOL team to gather and analyze requirements.
• Come up with a list of files to be generated by the Mainframe team to be moved to Oracle.
• Designing FSDs (Functional Specification Documents) for extraction, transformation and load implementation
• Work with the DBA to develop tables in Staging, Integration and Presentation layers.
• Working with the Offshore team, providing input for development of ETL jobs.
• Code review, debugging, troubleshooting and performance tuning of Datastage jobs.
• Working with the business and getting the Query log updated and communicating it with the offshore team.
• Co-ordinated with the QA team for various testing phases, defects, bugs analysis and fixing them.
• Involved in the meetings with the Client and Users, and responsible for providing progress updates and demos.
• Presenting a demo of the data by creating views of the existing tables, this would provide the users a real-time picture of the report they would see.

Environment: IBM Infosphere Datastage 9.1 (Designer, Director, Administrator), Oracle 10g, TOAD, UNIX, Autosys

Confidential - Greensboro, NC

Sr. ETL Developer

Responsibilities:

• Involved in meetings to understand the process Timberland used in the past and attempt to integrate with VF’s operations.
• Developed jobs using CDC stage to achieve SCD type 2.
• Worked with SAP team to help us source data from SAP systems using datastage using SAP R/3 plugin
• Wrote ABAP programs to source from SAP environment and store the data into DB2 tables
• Use BSEG to dump data and create MSEG jobs to filter out the required data into transactional datastore
• Used SAP developer 7.30 for validating and testing the data that comes into DB2.
• Sourced from MDM systems using MQ (Message Queue) and transformed the XML messages using XML stage
• Involved in meeting to gather requirements for creating reports.
• Understand the requirements of each department and transform data as per users requirement of each department.
• Pivoted a csv file with 824 columns into 72 columns for Forecast and planning reports.
• Integrate with the Cognos team to generate required reports.
• Transformed MQTs of Timberland into Datastage jobs

Environment: IBM Infosphere Datastage 8.5 (Designer, Director, Administrator), IBM DB2/UDB, SAP Developer 7.30, ESP scheduler, Cognos, Unix, IBM Datastudio

Confidential - Minneapolis, MN/ Orlando, FL

Sr. Datastage Developer

Responsibilities:

• Write technical procedures and documentation for the applications including operations, user guide, etc
• Involved in understanding of business processes and coordinated with business analysts to get specific user requirements.
• Participated in meeting with business users and subject matter experts to understand business requirement and design banking metrics.
• Worked with DataStage designer to design jobs with various stages, like Join, Lookup, Change Capture, Filter, Funnel, Copy, Sort, File set, Sequential File, Data set, Oracle Enterprise, Merge, Aggregator, and Remove Duplicate Stages
• Sourced data from MSSQL, Oracle, XML and .csv files and performed calculations and manipulation to the data.
• Used QualityStage to ensure consistency, removing data anomalies and spelling errors of the source information before being delivered for further processing.
• Created tables in oracle and stored the data from the jobs.
• Work with banking team to understand their requirement and views of the report then worked with SQL Reporting team and provide input for the report.
• Migrating parallel jobs from Datastage 7.5 to Datastage 8.1 and Datastage 8.1 to Datastage 8.7 as per requirement.
• Migrated JIL scripts from legacy versions of Autosys to Autosys 11.3
• Worked along side in creating of Dimensional Model for reporting system using Erwin r7
• Working on a project of migrating MSSQL server to Oracle 11g environment.
• Converted all the MSSQL queries and DDLs of old SQL server to Oracle
• Created tables, views and indexes for the new Oracle server.
• Worked on complex queries and used SQL navigator to write queries
• Worked with business users to validate and compare results against Source system’s data and re-load data, if we found any discrepancy.
• Involved in creating Unit Test Plans and System test plans for debugging and testing

Environment: IBM Infosphere Datastage 8.7/8.1/7.5 (Designer, Director, Administrator), DB2, Oracle, MSSQL, PL/SQL, flat files, csv files, UNIX, JIL scripts, Autosys 11.3, SSRS, MS Visio, MS-Office, IBM-AIX, SQL Navigator, Putty, Erwin r7

Confidential - San Diego, CA

ETL Datastage Developer

Responsibilities:

• Involved in scrum meeting for daily status and interacted with Business Analyst to get the business rules.
• Performed requirement analysis with the Team Lead for beter understand the requirements
• Designed and Developed Parallel jobs to extract data from different sources that include Oracle 11g, MSSQL, sequential files, comma separated files and apply business rules to transform the data.
• Developed Parallel and Server jobs for the entire cycle from pulling source of records to loading into target, where we first load to staging Layer, then Integration Layer and then semantic layer.
• Extensively used Oracle Connector stage, Oracle Enterprise stage, Stored Procedure Stage, sequential stage and Data set.
• Implemented slowly changing dimension type -2 using SCD stage in 8.1, Change Capture Stage in 7.5.
• Used Processing stages Join, Lookup, merge, Transformer, Surrogate key Generator, Modify, Filter, Funnel, Copy, Sort, Aggregator and Remove Duplicate Stages during ETL development.
• Extensively worked on Sequences in the project using Job activity, Execute Command, User Variables, Start loop, End loop, Sequencer, Exception Handler, Terminator activity.
• Implemented the Add checkpoints, automatically handle activities concepts in sequences.
• Implemented the multiple instance option, before job sub routine, after job sub routines.
• Developed Parallel Shared Containers for the jobs to store the common logic and use them across different parallel jobs in the project.
• Worked with Pentaho reporting team to create reports.
• Used Quality Stage to check the data quality of the source system prior to ETL process.
• Performed through data profiling by using the Investigate stage of QualityStage and also by writing PL/SQL queries to identify and analyze data anomalies, patterns, inconsistencies etc
• Created Parameter sets in the project developed Unit Test Cases for the jobs.
• Extensively worked on performance tuning of parallel jobs, reducing the number of stages, using appropriate stages and partitioning techniques.
• Extensively used Information Server Manager to build and deploy packages from Dev environment to Integration Testing environment.
• Used Autosys to schedule the jobs.
• Worked on Pentaho Data Integration as the company was planning to replace Datastage with PDI
• Defined test scenarios and making sure all funcationalities are working accorsing to the planned scenario.

Environment: Ascential Datastage 7.1/7.5 (Designer, Manager, Administrator, Director), Qualitystage, Pentaho Data Integration, Oracle 9i/10g, MS SQL Server 2005, UNIX, Windows Server 2008/2003, PL/SQL, SQL, T-SQL, C/C++, Visual Basic 6.0, Sun Solaris, ESXi (VMWare), MS proxy server, NetApp Storage, VMWare View, vSphere, Putty, Toad, Pentaho Report Designer

Confidential

Oracle/ETL Developer

Responsibilities:

• Understanding existing business model and Translate Business Requirements into ETL jobs.
• Implemented Extract, Transformation, and Load (ETL) functionality for Enterprise Data Warehouse and Data Marts using Datastage designer.
• Handled Complex Transformations of large volumes of Data from multiple Data sources using Datastage Designer.
• Developed various Datastage jobs, Shared containers, Routines and Transformations to migrate data from various Legacy systems to the new database.
• Involved in creating Unit test plans and System test plans for debugging and testing individual datastage jobs and Entire system.
• Worked with Datastage Manager to import and export jobs, while moving code into Production Env.
• Worked with Datastage Director to Run jobs, Monitor and check log files.
• Implemented Slowly Changing Dimensional tables in different Data Marts.
• Involved in implementation of UNIX shell scripts to process and copy Flat Files among different servers, to invoke PL/SQL scripts and DataStage jobs.
• Set up roles, grants and privileges for the application and database users.
• Involved in Building Data warehouse Using SQL, PL/SQL and SQL Loader
• Prepared Production Support documents, Monitoring production jobs, Resolve data issues and document them.

Environment: Ascential Datastage 6.0 (XE), Oracle 9i, PL/SQL, SQL*Loader, MS SQL, UDB, UNIX, Shell Scripting, Autosys, Windows NT 4.0/2000, Visual Basic 5.0