SUMMARY:

• Over 81/2 years of experience in System Analysis, Design, Development, Testing and Implementation.
• Over 7 years in the fields of Data Warehousing, Data Integration and developing client server application using IBM Websphere DataStage (9.1,8.5,8.1,8.0.1/7.5.2), Oracle, Sybase, PL/SQL, DB2 UDB, SQL procedural language and Shell Scripts.
• Extensive experience in Data warehousing tools DataStage v 9.1,8.5, 8.1, 8.0.1 /7.5.2 (Manager, Designer, Director, Parallel Extender PX and Administrator) Quality stage and Data Modeling Tools (Erwin, VISIO).
• Experienced in business applications in all stages of SDLC from gathering requirements to production.
• Extensive experience in developing strategies for Extraction, Transformation, Loading (ETL) data from various sources into Data Warehouse and Data Marts using Ascential DataStage (Manager, Designer and Director).
• Extensive experience in UNIX Shell Scripting.
• Used IBM information analyzer extensively for complete source system profiling and analysis, to validate data values, validate column/table relationships and drill down to exception rows for further analysis.
• Experience in integration of various data sources like DB2, DB2UDB, ORACLE, SQL Server, Informix, Sybase, Teradata, MS Access.
• Extensive experience on Star and Snowflake schema, Dimensional Data Modeling, Fact and Dimensional tables, Slowly Changing Dimensions (SCD).
• Extensive experience in production support and troubleshooting issues and arising post deployment.
• Worked with Oracle PL/SQL Stored Procedures, Sybase Stored Procedure, Table Partitions, Triggers, SQL queries, PL/SQL Packages, and loading data into Data Warehouse/Data Marts.
• Experience in domains such as Insurance, Healthcare, Finance, Pharma and Retail.
• Involved in Performance Fine Tuning of ETL programs. Tuned DataStage and Stored Procedures.
• Excellent communication skills, good organizational skills, self - motivated, hardworking, ability to work independently or cooperatively in a team, eager to learn, ability to grasp quickly.

SOFTWARE SKILLS:

ETL: IBM Information Server v9.1,8.5,8.1,8.0.1, Ascential DataStage 7.5.2/7.5.1(Server and Parallel Extender, Metastage) Version Controller, IBM Information Analyzer 8.0.1,Quality Stage 7.5,Informatica Power Center 6.0,7.1,8.1

Languages: C/C++, SQL*PLUS, PL/SQL, XML, HTML.

Databases: Teradata, SQL Server 6.5/7.0, DB2UDB/EEE 9.1/8.2/7.1, Oracle 11g/10g/9i.

Software/Configuration Tools: TOAD,QUEST, Clear Case, VSS, SVN, CVS

Operating Systems: Windows NT /2000/XP/7 MS-DOS, UNIX (Solaris 2.6, Linux, AIX)

Reporting Tools: Business Objects XIr3, Business Intelligence, Cognos8.0,Microstrategy.

PROFESSIONAL EXPERIENCE:

Confidential, Herndon, VA

Sr. Datastage Developer

Roles & Responsibilities

• Interacted with the Business Analyst’s and reporting team to Understand the Current Functionality and replicate the same results with the Datastage 9.1
• Converted the data stage jobs from 7.5 server jobs to 9.1 parallel Jobs.
• Developed parallel jobs using Datastage Development/debug stages and processing stages Aggregator, Change Capture, Filter, Sort, look up, Join, Merge, Funnel, and Remove Duplicate Stage.
• Worked on change management system on code migrations from Development to QA to Production environments.
• Co-ordinated with the other source teams to re direct the trigger files to the new server location.
• Worked with the dbas to move the database objects Tables, Procedures, Views and Materialized Views to the new database.
• Co-ordinated with the end users, reporting team to retire the tables which are no longer using in the reports and retired the corresponding etls in the Datastage.
• Converted the Oracle Enterprise Stages to the Oracle Connectors using the Converter Migration tool.
• Converted couple of the MVs to the tables.
• Coordinated with the production dba’s and data stage operations team to schedule the Materialized views and sequencers in the new production database.
• Compared the data between the 7.5 code and 9.1 code and tweaked the code to match the data.
• Job Parameters were extensively used to parameterize the parallel jobs.
• Developed Unit Test Cases and conducted Peer Code Review for the developed jobs
• Conducted the end to end testing to achieve the throughput.

Environment: IBM Information Server 9.1(Designer, Director and Administrator), Ascential DataStage 7.5.2 (Parallel Extender) (Designer, Administrator and Director) SVN, K-Shell Scripts, Oracle11g,Beyond Compare, FileZilla,Sun OS 5.10,Microsoft Windows 2003,SQL Developer 3.0.04.

Confidential, Mclean, VA

Sr.Datastage Developer

Roles & Responsibilities

• Interacted with the Business Analyst in gathering the technical and business requirements for the project.
• Designed and developed jobs for extraction of data from different data feed into IBM DB2 database.
• Worked on preparing the test cases and testing ETL jobs and data validation.
• Performed debugging on these jobs using Peek stage by outputting the data to Job log or a stage.
• Extensively worked on building ETL interfaces to read and write data from DB2 database using DB2 Enterprise Stage.
• Involved in functional and technical meetings and responsible for creating ETL Source - to - Target mappings.
• Loading the Historical data into the Warehouse.
• Worked on the TDQ SAS reports to validate the ETL Load, which does the source to target database, source file to Target DB comparison and generates the report.
• Developed jobs for transforming the data and stages like Join, Merge, Lookup, Funnel, Transformer and Aggregator.
• Coded many shell scripts for efficient job scheduling.
• Developed the Autosys Jill files and run books for the Production scheduling.
• Involved in developing a Control Module for the complete process using UNIX scripting.
• Worked on documenting technical design documents and source to target (STT) documents.
• Involved in Unit Testing, Integration testing and UAT Performance Testing.
• Worked with Rapid SQL to interact with DB2.

Environment: IBM Datastage 8.5/7.5.2 (Designer, Director and Administrator), Clear Case, AutoSys, K-Shell Scripts, IBM DB2 9.7.4, AIX 6.1,Rapd SQL 8.1.1.

Confidential, VA

Sr.Datastage Developer

Roles & Responsibilities

• Worked closely with Data Warehouse Architect, Data Modelers, Data Analysts, Business Analysts and BI developers to understand requirements and using the infosphere toolkit and ETL best Practices.
• Provided status and progress reports on development and maintenance activities as required to Manager and Data Warehouse Architect.
• Created High Level Design, Low Level Design Specs and Data Mapping Documents for various subject areas included in the project.
• Extracted data from sources like SQL Server, flat files and loaded into target tables.
• Designed the Datastage parallel Jobs using Join, Lookups, Transformers, Sequential Files, Datasets, Copy, Filter, Row Generator, Change Capture, Remove Duplicate and Peek Stages.
• Created Database objects like Tables, Sequence, Synonym, Views and indexes for Staging area.
• Developed PL/SQL Stored Procedures, triggers, cursors for implementing business rules and transformations.
• Worked in the Agile software development life cycle methodologies, processes and procedures to meet the Sprint dead lines.
• Converted complex Job designs to different job Segments and executed through job sequencer for better performance and easy maintenance.
• Performed the Source system analysis, Analyzed the source and target.
• Created DataStage jobs, batches, job sequences and tuned them for better performance
• Created data validation documents and ETL rules for the development of the DataStage job design.
• Responsible for UNIT, System Integration testing. Developed Test scripts, Test plan and Test Data.
• Developed the Comparison Scripts to find out the Differences from Source to target.
• Provided support in different Environments like QC and UAT.
• Able to do end to end production support which includes on-call 24/7 schedule, trouble tickets for B2C.

Environment: IBM Datastage v8.5,Sql Server 2008 R2, Microsoft Windows 7,Microsoft Visio Studio 2008/2010,SSIS 2008 R2.

Confidential, NJ

Sr.ETL Developer

Roles & Responsibilities

• Developed ETL Processes in support of the requirements, validating to meet business and technical specifications, ensuring dat any issues raised during testing are addressed prior to migration into Production and managing ongoing maintenance of the system and data.
• Designed various Datastage jobs for the dimensions and fact tables of star schema data warehouse using lookups, Transformers, Datasets, Funnel, Join, Merge, Aggregator and OCI Stages of Datastage.
• Tuned the Data stage jobs to obtain the better Performance.
• Designed Complex Sequencers dat include steps for load balancing and file validation checks.
• Performed Unit testing for jobs developed to ensure dat it meets the business requirements.
• TEMPEffectively Designed ETL jobs in order to make the data availability for client through Cognos Reports.
• Used Parallel extender Development / Debugging stages like Row Generator, Column Generator, Head, Tail and Peek Stages.
• Designed and developed various Stored Procedures, Functions, Packages and triggers to simplify the complex business logic for ETL Purposes.
• Implemented the database partition methods Range and List to improve the extract and load Performance.
• Developed UNIX shell scripts to automate the data load process to the target data warehouse.
• Created the Shell scripts to perform validations and run jobs on different instances(Dev, Test, and Prod).
• Provided the 24/7 Production Support.

Environment: IBM Datastage v8.5, Oracle 11g,Microsoft XP 2002,IBM AIX 6.1,HP-Quality Center 9.2, Cognos, Control-M.

Confidential, CA

Sr.ETL Developer

Roles & Responsibilities:

• Interacted with Data warehouse Architect, Technical Business Analysts to understand the Business Requirement Specifications and implemented the ETL jobs using DataStage.
• Created the Low level Design Documents based on the High level Documents and Functional Documents.
• Developed the Datastage Jobs using the Stages like Transformer, funnel, Look up, Join, sort, Remove Duplicate, Copy, Filter, Row Generator, Peek, Dataset.
• Used DataStage Designer to design and developed jobs for extracting, transforming, integrating and loading data Into targets.
• Implemented Partition techniques using the partition methods available in DataStage.
• Developed SQL queries while extracting data from source.
• Created the Indexes and Aggregate tables for the data warehouse Design and Development.
• Implemented Table Partition Methods Range, List Partition to Improve the Performance of the Extraction and Loading into the table.
• Designed DataStage parallel jobs to develop processes for extracting, transforming, cleansing, transforming, integrating and loading the data into the data warehouse data base.
• Extensively used Pivot stage to pivot and un pivot the source data to achieve required table structures like converting data from columns into rows and rows into columns.
• Performed the Unit Testing for jobs developed to ensure dat it meets the requirements.
• Performed data loading with multiple and parallel ETL processes to QA and UAT environments.
• Delivering the implementation plans to Release the code to the Production.
• Able to do end to end production support which includes on-call 24/7 schedule, trouble tickets for B2C.

Environment: IBM Datastage v8.1,Oracle 11g, Microsoft XP 2002,IBM AIX 5.3,OBIEE10g,Crontab.

Confidential, TN

DataStage Developer

Roles & Responsibilities:

• Extensively used DataStage Designer to develop the Parallel Jobs.
• Developed jobs using different stages like Transformer, Aggregator, Lookup, Join, Merge, Modify, Remove Duplicate, Oracle Stage, Sort, Peek, Row Generator, Column Generator, Sequential File, and Data Set.
• Created parameters to run the same job for different schemas.
• Conducted peer code review for the developed Jobs.
• Migrated PL/SQL code to the DataStage for the automation.
• Used DataStage Director and the runtime engine to schedule running the parallel jobs, monitoring and debugging its components.
• Developed UNIX Shell Scripts to automate the data load processes to the target Data warehouse.
• Designed database PL/SQL triggers and procedures, Functions, Packages.
• Used Job Control routines and Transform functions in the process of developing the job.
• Used TOAD to interact with Oracle and used SQL Trace and Explain plan to improve the performance of the Jobs.
• Used PL/SQL features such as stored procedures, functions, packages and database triggers for maintaining complex integrity constraints and implementing the complex business rules.
• Proactively evaluated the quality and integrity of data required by the users to satisfy their business needs.
• Used MS Visio to illustrate process flows for documentation purposes.

Environment: IBM DataStage v8.1, Oracle10g, Microsoft xp2002, IBM AIX 5.3, Toad 9.6.1, Crontab and Business Objects XI r3

Confidential, CA

DataStage Developer

Roles & Responsibilities:

• Interacted with Data warehouse Architect, Technical Business Analysts to understand the Business Requirement Specifications and implemented the ETL jobs using DataStage.
• Analyzed the Source system to understand the Data and Created the Source to Target mapping Documents to Build the Datastage Jobs.
• Developed various Jobs using Designer stages like Join, Lookup, Transformer, Slowly changing dimensions(SCD), Copy, Sort, Change Capture, Change Apply, Filter, Funnel, Aggregator, remove duplicate stages.
• Used parallel extender Development/Debugging stages like Row Generator, column generator, Head, Tail and Peek stages.
• Extensively worked with Parallel Extender using parallel processing (Pipeline and partition parallelism) techniques to improve job performance while working with bulk data sources.
• Developed sequencers to control the job execution of the DataStage Jobs.
• Implemented various partition methods like Hash, Entire, Auto,DB2.
• Dealed with various Database stages like DB2/UDB, ODBC.
• Extensively used SQL to extract the data from the History tables to improve the performance.
• Analyzed the target tables to avoid the Bottleneck at the Target Side.
• Involved in developing the shell scripts to create indexes, drop the indexes on the tables, FTP Processes and developed the master script to run the master sequencer.
• Performed the Unit Testing for jobs developed to ensure dat it meets the requirements.
• Involved in migration of DataStage code to the Integration and Production, participated in Integration testing.
• Moved the ETL Jobs from Integration to Production.
• Submitted Run books for Production Scheduling.
• Onsite Offshore Coordination with the backend team in India.

Environment: IBM DataStage v 8.0.1, DB2/AIX64 9.5.4, Microsoft XP 2002, IBM AIX 5.3,SQL server 2005, Crystal Reports, DB2 Command editor, Crontab.

Confidential, NJ

DataStage Developer

Responsibilities:

• Extracted data from various sources like DB2, Oracle, XML and Flat Files and loaded to target tables.
• Used DataStage Designer to design and developed jobs for extracting, transforming, integrating and loading data targets.
• Developed Shared Containers, which can be reused several times.
• Automated the FTP Extraction Process by job control to use one job for several extractions.
• Extensively worked with Parallel Extender for parallel processing to improve job performance while working with bulk data sources.
• Used DataStage Parallel Extender for and then split the data into subsets and to load data, utilized the available processors to achieve job performance, configuration management of system resources in Orchestrate environment.
• Developed Unit Test Cases and conducted Peer Code Review for the developed jobs.
• Used DataStage Director and the runtime engine to schedule running the server jobs, monitoring and debugging its components.
• Optimized/ Tuned Mappings for better performance and efficiency.
• Wrote PL/SQL procedures, SQL scripts for updating data in different tables.
• Enhanced the job properties for performance tuning.

Environment: Ascential DataStage 7.5.2 (Parallel Extender) (Designer, Administrator and Director), DB2 UDB 9.0, Oracle10g, Toad 9.0, SQL, PL/SQL, Windows NT 4.0 and IBM AIX.5.2.

Confidential

Database Developer

Responsibilities:-

• Designed Database schema, created indexes and Identified Integrity constraints for tables.
• Performance monitoring and tuning of Oracle database servers. System study and design, Involved in the re-organization of the table structures.
• Analyzed Tables and Indexes for performance tuning. Optimized database objects.
• Creation, maintenance, backups and restoration of databases.
• Developed screens using Oracle Forms 4.5, creating database objects like tables, indexes, views etc. using SQL*Plus, Import and export of data using SQL*Loader.
• Manufactured Test Data to make sure dat all the business requirements are satisfied.
• Written the PL/SQL procedures to extract data from Source systems (RMS) to Warehouse.
• Validated the reports to make sure all the products are identified.
• Involved in Developing Test Conditions, Test Scripts using SQL.
• Involved in Unit/Functional Testing, and Integration testing.

Environment: Informatica power center 6.0, Oracle9i, SQL*Plus, SQL*Loader, PL/SQL.