­SUMMARY:

• Over 8 years of experience in Data modeling, DataWarehouse Design, Development and Testing using ETL and Data Migration life cycle using IBM WebSphere DataStage 8.x/7.x.
• Experience in analyzing the data generated by the business process, defining the granularity, source to target mapping of the data elements, creating Indexes and Aggregate tables for the data warehouse design and development.
• Data Processing experience in designing and implementing Data Mart applications, mainly transformation processes using ETL tool DataStage (Ver8.x) and V9.1, designing and developing jobs using DataStage Designer, Data Stage Manager, DataStage Director and DataStage Debugger.
• Efficient in all phases of the development life cycle, coherent with Data Cleansing, Data Conversion, Performance Tuning and System Testing.
• Experience in Mapping Server/parallel Jobs in DataStage to populate tables in Data warehouse and Data marts.
• Expert in designing Parallel jobs using various stages like Join, Merge, Lookup, Remove duplicates, Filter, Dataset, Lookup file set, Complex flat file, Modify, Aggregator, XML.
• Experience in different Scheduling tools like AutoSys, ROBOT, CA7 for automating and scheduling jobs run.
• Excellent with PL/SQL, Stored Procedures, Functions, Database Triggers.
• Experience in UNIX Shell Scripting.
• Excellent knowledge of operating systems Windows, UNIX, and databases including Oracle, SQL Server and DB2.
• 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:

• IBM Information Server V7.x, V8.x, V9.1(DataStage, QualityStage).
• Oracle 8i/9i/10g, Db2 and Teradata.
• SQL, PL/SQL.
• Hadoop Basics and Concepts.
• Oracle Developer 2000.
• UNIX Shell Scripting.
• Java, JCAPS and ICAN.
• ROBOT Scheduler, Autosys, CA7 job Scheduler.
• Red Hat Enterprise Linux 4, Windows NT/XP, C,C++.

PROFESSIONAL EXPERIENCE:

ETL Developer

Confidential, MN

• Integrating the data related to Review Diagnosis, which involves the conversion of ICD9 diagnosis codes to ICD10 codes.
• Generating the DrugID for each specific Drug based on GPI received from different sources. Drig dirves the process for this Data Model.
• Developed all the datastage jobs and worked on ROBOT scheduler for scheduling the jobs and adding reactivities
• Developing DataStage jobs which extract data from different DB2 sources and load into a common Canonical Flat files.
• Performing Change Data Capture(CDC) and perform Inserts, Updates and Deletes based on the resultant. Capture Slowly Changing Dimensions (using SCD1 and SCD4) and perform the respective changes to the data in Main table and also maintain history (if required).
• Developing the common insert, update and delete jobs by using RCP and schema files with the ability to restart.
• Developing Datastage jobs to load the integration tables after performing necessary transformations.
• Working on ROBOT Scheduler and setting up all the parameters and reactivities to schedule the jobs.
• Worked in Production Support Environment as well as QA/TEST environments for projects, work orders, maintenance requests, bug fixes, enhancements, data changes, etc.
• Analysis of issues occurring in a production, resolving issues in Development and Test environment and roll over the changes to production.

Confidential, MN

Responsibilities:

• Developing DataStage jobs which extract data from different sources like DB2,Oracle, Flat files and load the data into Oracle Confidential environment.
• Worked in creating UNIX Shell Scripting for File Intake process of Confidential and also in Archival scripts.
• Performing Change Data Capture(CDC) and perform Inserts, Updates and Deletes based on the resultant.
• Working on ROBOT Scheduler and setting up all the parameters and reactivities to schedule the jobs.
• Worked in Production Support Environment as well as QA/TEST environments for projects, work orders, maintenance requests, bug fixes, enhancements, data changes, etc.
• Performed modifications on existing designs as per change request and maintained it.
• Analysis of issues occurring in a production, resolving issues in Development and Test environment and roll over the changes to production.

Confidential, AR

Responsibilities:

• Developing DataStage jobs which extract data from different sources like Teradata, DB2, Mainframe and Greenplum and load the data into Oracle Exadata environment.
• Worked in creating UNIX Shell Scripting .
• Working on CA7 Scheduler and setting up all the params for CA7 to schedule the DataStage jobs.
• Worked in Production Support Environment as well as QA/TEST environments for projects, work orders, maintenance requests, bug fixes, enhancements, data changes, etc.
• Performed modifications on existing designs as per change request and maintained it.
• Testing of Configurations.
• Analysis of issues occurring in a production, resolving issues in Development and Test environment and roll over the changes to production.

Confidential, MI

Responsibilities:

• Design and implement generic control framework which includes DataStage and Database components.
• Design solution to address areas of improvement in existing system
• Wrote Shell Scripts for Data loading and DDL Scripts.
• Set - up and Design of Backup and Recovery Strategy for various databases.
• Involved in the unit testing and documenting the test results.
• Preparing the System Design Document and other documents for the Project.
• Strictly observed Standard for Error Handling, Audit report generation using CSF (Common Services Framework).
• Worked in Production Support Environment as well as QA/TEST environments for projects, work orders, maintenance requests, bug fixes, enhancements, data changes, etc.
• Team-Oriented and focused on delivering exactly what the client needs to succeed in timely and efficient manner.
• Analysis of issues occurring in a production, resolving issues in Development and Test environment and roll over the changes to production.

Confidential

• Design and implement generic control framework which includes DataStage and Database components.
• Design solution to address areas of improvement in existing system
• Wrote Shell Scripts for Data loading and DDL Scripts.
• Set-up and Design of Backup and Recovery Strategy for various databases.
• Involved in the unit testing and documenting the test results.
• Preparing the System Design Document and other documents for the Project.
• Strictly observed Standard for Error Handling, Audit report generation using CSF (Common Services Framework).
• Worked in Production Support Environment as well as QA/TEST environments for projects, work orders, maintenance requests, bug fixes, enhancements, data changes, etc.
• Team-Oriented and focused on delivering exactly what the client needs to succeed in timely and efficient manner.
• Analysis of issues occurring in a production, resolving issues in Development and Test environment and roll over the changes to production.

Confidential

Responsibilities:

• Developing new code for ASEAN and Thailand interfaces.
• Meeting with Clients for requirement gathering, addressing issues.
• Involved in the unit testing and documenting the test results.
• Preparing the System Design Document and other documents for the Project.
• Strictly observed GM GIF (Global Integration Foundation) EAI Standard for Error Handling, Audit report generation using CSF (Common Services Framework)
• Team-Oriented and focused on delivering exactly what the client needs to succeed in timely and efficient manner.
• Analysis of issues occurring in a production, resolving issues in Development and Test environment and roll over the changes to production.

Confidential

• Developed PL/SQL Procedures and Functions in the implementation of business logic. Generated server side PL/SQL scripts for data manipulation and validation.
• Created collaborations in Java CAPS (EAI) so that end systems will not face any issues with respect to integration.
• Created DataStage jobs in DataStage 8.5 for outbound flow of the application.
• Used JCAPS 5.1.3 environment in integration of all the different segments.
• Used the logic of RRTDiff, which is very important in handling the changes which are received on daily basis from the plants.
• Design solution to address areas of improvement in existing system
• Prepare low level design documents based on the requirements analysis.
• To eliminate latency and quality issues which are impacting the future material availability.
• Coordination with operations team post-deployment in order to ensure smooth execution of the project.

Confidential

Responsibilities:

• Resolving the issues related to customer.
• Creating the systems maintenance plans on a regular basis and executing them.
• Getting the statistical reports on a regular basis.
• Perform report analysis and Bug fixes to improve the performance of the system
• Understanding the system design Document and developing Interface design document.
• Developing the Interfaces based on Interface design document.
• Coordination with Team in getting the accounts to be configured.
• Preparation of UNIX scripts.
• End to end testing of interfaces.