SUMMARY

• Over 5 years of ETL and Data Integration technical experience in IT Industry as a developer in System Analysis, Design, Development, Testing and Support of projects using Datastage 7.5/8.1/8.5/9.1 /11.3 in Banking, Retail and Insurance and Automobile verticals.
• Experience in Software Development Life Cycle - SDLC (Analysis, Design, Development and Testing), requirement gathering, client interaction, Use Case Design and understanding.
• Have hands on experience in design and development of complex datastage jobs, sequencers and Fast track, Metadata Workbench and Business Glossary.
• Have hands on experience in Auto sys and Control-M job schedulers.
• Experience in UNIX scripting, troubleshooting and file handling on the UNIX system.
• Good hands on experience in RDBMS like Oracle, Netezza, SQL Server, Teradata and DB2. Working experience in data modeling and implementing stored procedures using PL/SQL. Extensive knowledge of writing complex queries using SQL. Working experience in DB2 cursors, triggers and stored procedures.
• Demonstrated work experience in using the state of art Datastage Grid environments.
• Experience in Data Integration, EDW and Data Mart projects.
• Strong knowledge in OLAP and OLTP Systems, Dimensional modeling using Star schema and Snowflake schema.
• Demonstrated work experience in Mainframe to Datastage Migration projects.
• Experienced in designing and using several process tracking mechanisms and communication designs that give a snapshot of the status of the jobs in an application/system.
• Worked on integrating data from sequential files, flat files, COBOL files and XML files.
• Experience in working closely with mainframe applications for the ETL interactions.
• Prepared High Level design document, Low Level design document, Technical design document for various projects and good at Bug fixing, Code reviews, and Unit & System testing.
• Expertise in application development in various Datastage versions like 7.5/8.1/8.5/9.1
• Expertise in creating Data Mapping for various projects and applications.
• Experience in working in a Multi-Dimensional Warehouse projects.
• Experience in reading and loading high-volume Type 2 dimensions by implementing SCD (Slowly Changing Dimensions).
• Experience in using Mainframe applications for browsing the files and NDM’ ing the files.
• Hands on Experience in working with BOXI for report generation.
• Good experience in working with HP ALM(QC)
• Good experience in designing metadata for all data moves and to re-use them during the job designing with the help of Metadata Management and Fasttrack Mapping specifications.
• Providing 24X7 productions supports for the application stability.
• Quick learner and up-to-date with industry trends, Excellent written and oral communications, analytical and problem solving skills and good team player, Ability to work independently and well-organized.

TECHNICAL SKILLS

Languages: SQL, PL/SQL, Unix shell scripting, COBOL

ETL Tools: Datastage 7.5/8.1/8.5/9./11.3 , Designer, Administrator, Director, Fast track, Metadata Workbench, Business Glossary

Databases: Oracle 10g, DB2, Teradata, SQL Server, Netezza, DB2

Software’s: TOAD for oracle, TOAD for DB2, WINSCP,MS SQL server 2008 Management Studio, SQL * PLUS, SQL Developer, Queryman, AQT for DB2, AQT for Oracle, MAINFRAMES

Other Tools used: Clear Case, Tortoise SVN Sub Version, HP ALM

Operating Systems: UNIX (AIX), LINUX, Windows 95/98/2000/XP/2003, MS-DOS.z/OS

Reporting Tools: BOXI R2

PROFESSIONAL EXPERIENCE

Confidential, Portland, Oregon

ETL Developer

Responsibilities:

• Active participation in decision making and QA meetings and regularly interacted with the Business Analysts &development team to gain a better understanding of the Business Process, Requirements& Design.
• Used DataStage as an ETL tool to extract data from sources systems, loaded the data into the IBM DB2 database.
• Wrote SQL, PL/SQL, queries, stored procedures, triggers for implementing business rules and transformations.
• Used Data Stage Director and its run-time engine for job monitoring, testing and debugging its components, and monitoring the resulting executable versions on ad hoc or scheduled basis.
• Converted complex job designs to different job segments and executed through job sequencer for better performance and easy maintenance.
• Created master jobs sequencers.
• Also worked for different enhancements in FACT tables.
• Created shell script to run data stage jobs from UNIX and then schedule this script to run data stage jobs through scheduling tool Autosys using JIL’s.
• Coordinated with team members and administer all onsite and offshore work packages.
• Identified source systems, their connectivity, related tables and fields and ensured data suitability for mapping.
• Prepared FastTrack Mapping Specifications created metadata layouts in Metadata Workbench and update Business Glossary.
• Prepared Data Mapping Document and Design the ETL jobs based on the DMD with required Tables in the Dev Environment.
• Designed and Developed Data stage Jobs to Extract data from heterogeneous sources, applied transform logics to extracted data and Loaded into Data Warehouse.
• Created Datastage 8.5 jobs using different stages like Transformer, Aggregator, Sort, Join, Merge, Lookup, Data Set, Funnel, Remove Duplicates, Copy, Modify, Filter, Change Data Capture, Change Apply, Surrogate Key, Column Generator, Difference, Row Generator, Sequencer, Email Communication activity, Command activity.

Confidential, Irving,TX

Sr. Datastage Consultant

Responsibilities:

• Attended meetings with client and business teams to understand the requirement and prepared the low level design document, technical specification documents.
• Identified the impacts and created Data Mapping Sheets.
• Active participation in decision making and QA meetings and regularly interacted with the Business Analysts &development team to gain a better understanding of the Business Process, Requirements& Design.
• Used DataStage as an ETL tool to extract data from sources systems, loaded the data into the IBM DB2 database.
• Involved in the design, development of the SQL and PL/SQL stored procedures, packages and triggers for the ETL Datastage processes.
• Created jobs to read and write data into complex flat files, COBOL files, sequential files.
• Designed and Developed Data stage Jobs to Extract data from heterogeneous sources, Applied transform logics to extracted data and Loaded into Datamart.
• Created Datastage 8.5 jobs using different stages like Transformer, Aggregator, Sort, Join, Merge, Lookup, Data Set, Funnel, Remove Duplicates, Copy, Modify, Filter, Change Data Capture, Change Apply, Column Generator, Difference, Row Generator, Sequencer, Email Communication activity, Command activity, Sequential File, CFF stage, Dataset, Terminator activity.
• Used Data Stage Director and its run-time engine for job monitoring, testing and debugging its components, and monitoring the resulting executable versions on ad hoc or scheduled basis.
• Converted complex job designs to different job segments and executed through job sequencer for better performance and easy maintenance.
• Created master jobs sequencers.
• Created shell script to run data stage jobs from UNIX and then schedule this script to run data stage jobs through scheduler called VERTIS which runs based on ILOG JRules.
• Coordinated with team members and administer all onsite and offshore work packages.
• Performed performance tuning of the jobs by interpreting performance statistics of the jobs developed.
• Documented ETL test plans, test cases, test scripts, and validations based on design specifications for unit testing, system testing, functional testing, prepared test data for testing, error handling and analysis.
• Prepared DDL’s for table creation, table modification, index changes. Tested and executed the same in all environments Dev, CIT, SIT, UAT, Pre production and Production.
• Prepared the DML’s for maintenance tables, reviewed, tested and executed them.
• Used Clear case and IBM Infoshpere Information Sever Manager for version control tool for version controlling and movement of code to upper environments like SIT, UAT, Pre production and Production.
• Used the HP ALM to upload the unit test cases and executed them. And to track any defects in the project during different phases of testing, debugging, investigating and worked towards closure of the defects.

Environment: IBM Web Sphere DataStage 11.3 Parallel Extender, IBM Infoshpere Information Sever Manager, Web Services, Clear case, Microsoft Visio, IBM AIX 4.2/4.1, SQL, PL/SQL, SQL Server, IBM DB2, Vertis, ilOG JRules, Unix, Windows, HP ALM

Confidential, Columbus, Ohio

Datastage Consultant

Responsibilities:

• Identified source systems, their connectivity, related tables and fields and ensured data suitability for mapping.
• Prepared Fasttrack Mapping Specifications, created metadata layouts in Metadata Workbench and update Business Glossary.
• Prepared Data Mapping Document and Design the ETL jobs based on the DMD with required Tables in the Dev Environment.
• Active participation in decision making and QA meetings and regularly interacted with the Business Analysts &development team to gain a better understanding of the Business Process, Requirements& Design.
• Used DataStage as an ETL tool to extract data from sources systems, loaded the data into the IBM DB2 database.
• Wrote SQL, PL/SQL, queries, stored procedures, triggers for implementing business rules and transformations.
• Designed and Developed Data stage Jobs to Extract data from heterogeneous sources, Applied transform logics to extracted data and Loaded into Data Warehouse.
• Created Datastage 8.5 jobs using different stages like Transformer, Aggregator, Sort, Join, Merge, Lookup, Data Set, Funnel, Remove Duplicates, Copy, Modify, Filter, Change Data Capture, Change Apply, Surrogate Key, Column Generator, Difference, Row Generator, Sequencer, Email Communication activity, Command activity.
• Used Data Stage Director and its run-time engine for job monitoring, testing and debugging its components, and monitoring the resulting executable versions on ad hoc or scheduled basis.
• Converted complex job designs to different job segments and executed through job sequencer for better performance and easy maintenance.
• Created master jobs sequencers.
• Also worked for different enhancements in FACT tables.
• Created shell script to run data stage jobs from UNIX and then schedule this script to run data stage jobs through scheduling tool Autosys using JIL’s.
• Coordinated with team members and administer all onsite and offshore work packages.
• Performed performance tuning of the jobs by interpreting performance statistics of the jobs developed.
• Documented ETL test plans, test cases, test scripts, and validations based on design specifications for unit testing, system testing, functional testing, prepared test data for testing, error handling and analysis.
• Used the HP ALM to upload the unit test cases and executed them. And to track any defects in the project during different phases of testing, debugging, investigating and worked towards closure of the defects.
• Performed Performance testing with different sets of node configuration, different queue and different volumes.
• Prepared the DML’s for maintenance tables, review, and test and execute them.
• Used Tortoise SVN version control tool for version controlling and movement of code to upper environments like SIT, UAT, Pre production and Production.

Environment: IBM Web Sphere DataStage 8.5 Parallel Extender, Grid environment, Fasttrack, Metadata Workbench, Business Glossary, Web Services, Quality Stage 8.5, SQL, PL/SQL, Microsoft Visio, IBM AIX 4.2/4.1, SQL Server, IBM DB2, ORACLE 11G, Autosys Scheduler, Unix, Windows, HP ALM