SUMMARY

• Over 9+ years of experience in ETL Technologies using IBM Infosphere Data Stage v8.7,v9.1,v11.5 and UNIX Shell Scripting. Extremely proficient in SQL, Oracle,PL/SQL, DB2, Teradata, Data warehousing concepts, Shell scripting and ETL techniques (extraction, transformation and loading).
• Extensive experience in ETL Development & Design, Data Modelling,Data extraction, Manipulation, Mapping and Testing & validation of data.
• Strong Knowledge on Data warehousing basics, relational database management systems and Dimensional modeling (Star schema and Snowflake schema).
• Knowledge in data warehouse implementation process, from business requirements through logical modeling, physical database design, data sourcing and data transformation, data loading, SQL, end - user tools, database and SQL performance tuning.
• IBM Infosphere Datastage 8.5 certified professional with exposure to ETL tasks involving Datastage.
• Experience in process improvement and re-engineering with an understanding of technical data problems and solutions as they relate to the current and future business environment.
• Experience in Extracting, Transforming, Loading (ETL) and maintaining of data warehouses and data marts, handling large data loads, automatic error handling, performance tuning for bulk data aggregation.
• Strong experience in Data Cleansing, Data Migration.
• Experienced as a Tech Lead on multiple, large integration and data publishing projects or as a project lead on smaller projects, ensuring consistent design and efficient data processing.
• Extensively worked on agile methodology projects and waterfall methodology projects.
• Strong skills in Data Analysis, Requirement Analysis, and Data mapping for business process.
• Responsible for the documentation and maintenance of new and existing Extract, Transform, and Load (ETL) processes within the Enterprise Data Warehouse. Extensively used Autosys and Tivoli Maestro for scheduling and executing the Datastage jobs.
• Developed cost-effective information technology solutions by creating new and modifying existing data processing jobs. Experience in Coding, testing, debugging, documentation and implement of complex ETL and SQL logic.
• Extensively used Quality Center to import test scripts and raise defects whenever required during testing phase and tracking it to closure.
• Technically proficient, Customer dedicated, IBM DB2 Certified Software professional with remarkable experience in Mainframe development & Maintenance projects built with COBOL, JCL, DB2 & IBM Tools
• Extensive experience in working with Requirement/Business Analysts, Usability Team & Architect Team for system design, documenting and implementation
• Involved in unit, functional, system integration, performance and load testing of applications to provide quality deliverables.
• Coordinate activities of the project team and assist in monitoring project schedules and costs. Functions as technical lead and acts as liaison between IT groups.
• Strong organizational & presentation skills with excellent analytical & problem solving proficiency
• Deliver new and complex high quality solutions to clients in response to varying business requirements.
• Received 7 times ‘On The Spot Award’s and one time ‘Beyond Performance Awards’ for timely project deliverables and client appreciations.
• Have hands on experience in Onsite-Offshore model projects as well.

TECHNICAL SKILLS

ETL Skills: IBM Infosphere Datastage 8.7,9.1,11.5, Data warehouse concepts

Mainframe: IBM Mainframe, JCL,COBOL, Easytrieve, Sorting

Languages: SQL,PL/SQL,REXX(Basics), APS Program

Databases: Oracle,DB2,IMS,Teradata

Operating Systems: UNIX, Windows XP

Tools: IBM Infosphere Datastage client (Designer, Director, Manager and Administrator), SQL Explorer/TOAD, SSH Tectia, Teradata SQL Assistant, Autosys scheduler, Tivoli Maestro scheduler, File manager, SPUFI, Expeditor, SDSF, Change man, SAR, CA7, QMF, PLAT, NDM, PDSM, IMF, DCLGEN, and Endevor.

PROFESSIONAL EXPERIENCE

Confidential, Texas

Senior ETL Developer

Responsibilities:

• Participated in application design and development discussions with clients and management to determine client needs and ensure that product adheres to established specifications and standards.
• Created technical designs based on business/functional requirements. Involved in Analysis of the requirements and preparation of source to target mapping.
• Involved in Data Modelling changes and performed impact analysis for the requirement.
• Reviews development, modification and testing of applications to ensure that product efficiency and cost effectiveness are achieved.
• Developed extract, transform, and load (ETL) solutions with IBM WebSphere DataStage.
• Performs moderately complex modification, testing and debugging tasks on vendor supplied utilities and packages to ensure fit with current operating environment.
• Used various stages like Transformer stage, Filter stage, different file stages, Oracle database, Teradata database, DB2 database, Job sequencer stages and various other parallel job stages to perform ETL Operations.
• Developed various UNIX shell scripts to control the batch flow and some ETL operations.
• Scheduled the parallel jobs flow in Autosys to run the jobs in Batch mode.
• Performed Unit testing & integration testing in various phases with different data.
• Used Data Stage Director to validate, run and monitor the data stage jobs.
• Investigate production ETL issues and work to determine the root cause of problems. Fixed various defects occurred during various types testing.
• Communicated with different upstream and downstream application owners for data availability and resolving different types of issues during testing.
• Deliver new and complex high quality solutions to clients in response to varying business requirements.
• Responsible for effective communication between the team and the client.
• Deliver final results in terms of KPI’s (Key Performance Indicators) to the business team to improve the business.

Environment: IBM Data stage V8.7, V9.1,V11.5, Congo’s, Teradata, UNIX, Shell scripting, SQL,PL/SQL, Autosys, SSH Tectia, Oracle Database.

Confidential, Delware

ETL Developer

Responsibilities:

• Review program specifications for development.
• Involved in the design of High Level and Low Level Design document for different applications.
• Understanding the business requirements and designing/coding the ETL flow in Data Stage.
• Developed ETL jobs to load data from DB2 databases, Flat files, CSV files to Target warehouse, and experience with high volume databases on Mainframes.
• Worked with stages like Complex Flat File, Transformer, Aggregator, Sort, Join and Lookup
• Extensively Worked on Job Sequences to Control the Execution of the job flow using various Triggers (Conditional and Unconditional) and Activities like Job Activity, Email Notification, Sequencer, Routine activity and Exec Command Activities.
• Optimized QMF Queries for maximum performance.
• Used Data Stage Director to validate, run and monitor the Data Stage jobs.
• Working knowledge of mainframe based tools such as File Aid, BMC, and JCL.
• Developed UNIX Shell scripts to automate file manipulation and data loading procedures.
• Experience in generating and interpreting mapping documentation, and translating into detailed design specifications using ETL code.
• Performed the Unit testing for jobs developed to ensure that it meets the requirements.
• Prepared Data model mapping and MDD (Metadata dictionary) documents for different applications.
• Communicated with different upstream and downstream application owners for data availability and resolving different types of issues during testing.
• Deliver new and complex high quality solutions to clients in response to varying business requirements.
• Responsible for effective communication between the offshore team and the client.

Environment: IBM Data stage 8.7 (Director, Designer, Administrator), IBM DB2, Mainframes, UNIX, Autosys, Tivoli Maestro and Request Net.

Confidential

ETL Developer

Responsibilities:

• Involved in Analyzing the Business Requirements
• Responsible for Extracting the data from various source systems, Transforming and Loading data into data warehouse.
• Used various Stages such as Sequential File, Dataset, and File set, Transformer, Lookup, Filter, Aggregator, Join, Sort, Funnel, and Merge.
• Used DataStage Designer tools for creating Parallel jobs and importing and exporting the jobs.
• Used DataStage Job Sequences to execute the jobs in a sequence order.
• Used Quality stages for enrich data to meet business objectives and data quality management standards.
• Used DataStage Director to run and monitor status of the jobs.
• Created DataStage Jobs to build business rules to load data.
• Involved in Performance Tuning and Enhancement.
• Onsite/Offshore Coordinator and updating offshore status to Client.
• Coordinating with Release Management, Data Management and Configuration Management.
• Communicate and resolve issues with application teams and Client team.
• Responsible for bringing new members of the team up to speed through knowledge sharing sessions.

Environment: IBM Data stage, 8.7 (Director, Designer, Administrator), Oracle, Mainframes, UNIX, Autosys, Tivoli Maestro and Request Net.

Confidential

ETL Developer

Responsibilities:

• Develop HLD and LLD documents from Project Specifications meetings and discussion with Confidential technology and functional architects.
• Involved in developing the code components in line with the design documents created.
• Prepare test plan and test scripts.
• Review unit test results and System Integration Test results.
• Involved in preparation of schedules, jobs and production documents for installs.
• Deployment in production and providing PIW support.
• Responsible for effective communication between the team and the client.

Environment: Data stage 8.1, DB2, SQL, UNIX, Tivoli Maestro and Request Net, Quality Center.

Confidential

ETL Developer

Responsibilities:

• Review program specifications for development. Involved with the design of Low Level Design document.
• Understanding the Mainframe work flow and implemented the same in Datastage
• Extracted data from various sources likeDB2 Database, Flat Filesand sent files to downstream applications.
• Designed jobs using different parallel job stages such as Join, Merge, Lookup, Filter, Dataset, Lookup file Set, Remove Duplicates, Change Data Capture,Switch,Modify, and Aggregator.
• Involved in developingDatastage Designer Parallel jobs for Extracting, Cleansing, Transforming, and Integrating.
• Developed Job Sequences for controlling the execution of Datastage Jobs.
• Created Tivoli maestro schedules to run the Datastage jobs in test and production region.
• Involved in Unit Testing and System Integration Testing during testing phase.
• Compared the results with Mainframe results and made sure that functionality working same.
• Extensively usedDatastage Directorto Monitor and check the run statistics of the Jobs and to clear the job logs, job resources.
• Prepared PRISM DTS tasks for installation procedures.

Environment: Data stage 8.1, DB2, SQL, UNIX, Tivoli Maestro and Request Net, Quality Center.

Confidential

Developer

Responsibilities:

• Review program specifications for development. Involved with the design of Low Level Design document.
• Understanding the Mainframe work flow and implemented the same in Datastage
• Extracted data from various sources likeDB2 Database, Flat Filesand sent files to downstream applications.
• Designed jobs using different parallel job stages such as Join, Merge, Lookup, Filter, Dataset, Lookup file Set, Remove Duplicates, Change Data Capture,Switch,Modify, and Aggregator.
• Involved in developingDatastage Designer Parallel jobs for Extracting, Cleansing, Transforming, and Integrating.
• Developed Job Sequences for controlling the execution of Datastage Jobs.
• Created Tivoli maestro schedules to run the Datastage jobs in test and production region.
• Involved in Unit Testing and System Integration Testing during testing phase.
• Compared the results with Mainframe results and made sure that functionality working same.
• Extensively usedDatastage Directorto Monitor and check the run statistics of the Jobs and to clear the job logs, job resources.
• Extensively usedDatastage Managerto Export/import Datastage components.
• Prepared PRISM DTS tasks for installation procedures.

Environment: Data stage 8.1, DB2, SQL, UNIX, Tivoli Maestro and Request Net, Quality Center.

Confidential

Developer

Responsibilities:

• Impact Analysis for the given requirement.
• Analysis of impacted modules to do required code changes.
• Development and enhancement of modules to address the specific requirement.
• Unit testing of the developed code.
• Creation of CA7 Scheduling document for impacted JCL’s and raising the ISTT tickets for job execution in test region.
• Creation of DTS (Detail Task Schedule) for project implementation.
• Support test cycle execution (CIT/SIT).
• Supports during production install.

Environment: IBM Mainframe,COBOL, DB2, JCL, Easytrieve