SUMMARY

• 8 years of experience having full lifecycle development (SDLC) experience in analysis, design, development and implementation of medium to large enterprise Data Warehouses using IBM Information Server (formerly Ascential DataStage).
• Strong combination of business analysis, database and data warehouse (OLAP) technical experience.
• Expertise in Development and Implementation of Data Warehouse applications using ETL tool IBM InfoSphere DataStage 9.1/8.7/8.0.1 /7.5.
• Experience in development, testing, documentation, production support & Integrating applications using IBM DataStage 9.1/8.x/7.x, IBM DB2, Oracle 10g, 9i technologies in Data Warehousing.
• Extensive experience in Data warehousing tools DataStage v8.x/7.5.2(Manager, Designer, Director, Parallel Extender PX and Administrator) Quality stage and Data Modeling Tools (Erwin, VISIO).
• Experience in developing Data Quality jobs to Investigate, Standardize addresses and match with USPS database using IBM InfoSphere QualityStage.
• Experience in Database/Data Warehousing/Client/Server/Legacy applications for Publishing, Reinsurance & Pharmaceutical industries using Data Analysis, Data Modeling, Data Extraction, Data Transformation and Data Loading.
• Extensively implemented SCD Type1, Type2 & Type3.
• Extensively made use of job sequencer, Nested condition activity in runningDataStagejobs.
• Experienced in writing UNIX shell scripting and hands on experience with scheduling of shell scripts using Control - M.
• Expertise in performingData Migrationfromvarious legacy systems to target database
• Performed Debugging, troubleshooting, monitoring and performance tuning usingDataStage.
• Experienced in developing user defined stages like custom, build and Wrapped.
• Expertise in using stages, Standardization, Scrubbing, Matching and Survivorship rules using Quality Stage.
• Functions, Triggers, Sequences, Views, Cursors, Packages and Exceptions.
• Designing the SQL queries with Joins, Sub queries and used Analytical Functions in Queries.
• Designing the Procedures for Data Validations and Business Validations and Integrating the Modules.
• Experience in Data Warehouse development, worked with Data Migration, Data Conversion, and (ETL) Extraction/Transformation/Loading using Ascential DataStagewith DB2 UDB, Oracle,SQL Server.
• Experience in Peer & Lead level business, system requirementsanddesign reviews.
• Experience in design and implementation of Server and Parallel jobs including Batches and Job Sequencers.
• Experience in Integration of various data sources likeOracle, TeraData,DB2, SQL Server, Mainframesinto ODS and DWH areas.
• Participated in all phases including requirements analysis, client interaction, coding, testing and documentation.
• Expertise in OLTP/OLAP System Study, Analysis and E-R modeling, developing Database Schemas like Star schema and Snowflake schema used in Relational, Dimensional and Multidimensional modeling.
• Experience in Oracle 10g/9i, Database development experience using PL/SQL, Stored Procedures, Triggers, Functions, Packages, Views and Oracle Objects.
• Experience in HP Quality Center to manage manual and automated test cases and to track defects.
• Used IBM Tivoli Workload Scheduler to automate, monitor and control workflow.
• Strong communication and analytical skills and a demonstrated ability to handle multiple tasks as well as work independently or in a team towards resolution.

TECHNICAL SKILLS

ETL Tools: IBM Information Server (DataStage) 9.1/8.7/8.0.1 , Ascential DataStage EE 7.5 X2,Quality Stage

Scheduling Tools: Control-M Enterprise Manager 6.3.0.1, Tivoli Workload Scheduler, Autosys

RDBMS: IBM DB2 8.1, Toad, Oracle 9i/10g/12c, Sybase, MS Access,SQL-Server 2005

BI-Tools: Cognos ReportNet1.1, Cognos Impromptu Administrator 6.0,Crystal Reports

Operating System: Windows and UNIX

PROFESSIONAL EXPERIENCE

Confidential, Phoenix AZ

Sr.Datastage Developer

Responsibilities:

• Analyzing the specifications and functional documents of project requirement.
• Design and development of ETL job’s using Data Stage
• Support Source feed data into the Data Warehouse - EDW processes data from multiple sources including some external vendors. Commerce system is the main source of EDW.
• Developed ETL jobs using Change Data Capture (CDC) stage to implement Type 2 Slow Changing dimension.
• To Develop the technical components like PL/SQL Procedures, Unix Shell Scripts, sqlloader control files to achieve the exact business needs
• BMC Remedyfor creating tickets when on support with migration issues and when DEV, QA, Pre-Prod& Prod disk space issues
• Created and performance tuned the SQL scripts for data extraction
• Involved in creating and documenting the ETL naming standards and process flow procedures
• Created DataStage parallel and sequencer job templates to have all the developers to follow the same standards across the board
• Involved in design and development of ETL jobs for Extraction of Health care data from source systems, Cleansing, Staging, applying Transformations and eventually Loading into the data warehouse
• Involved in creating and documenting the ETL naming standards and process flow procedures
• Work on the ad-hoc requests like analysis of data inconsistency, data being populated incorrectly, code fix and improving performance of the existing processes.
• To run the monthly loads into data ware house and monitor it and resolve the errors if it errors out.
• Worked on Tight schedules of the data loads to make sure the loads get completed within SLA.
• Working on CGDS migration process using the Datastage tool and DB2 UDB, SQL,Tera Data database.
• Analysis of the Data Quality, impact analysis, monitoring the data loads and resolving the production issues.
• Worked with SVN for Version Control and to migrate the code from Development to Stage and then to Production environments.
• Reviewing, Unit testing, Integration testing on the deliverables and prepared unit test case documents to verify the jobs and data.
• Wrote UNIX shell scripts for data files FTP and to run SQL *Loader scripts.
• Good Experience in providing production support 24/7

Environment: IBM InfoSphere DataStage 9.1/8.7, IBM InfoSphere QualityStage 9.1, DB2 9.7.6, SQL Server 2005, Oracle 10g, Red Hat LINUX 5.8, TOAD 4.7, SQL Developer, Erwin, SAS DataFluxdfPower Studio 8.1

Confidential, Phoenix Arizona

Sr.Datastage Developer

Responsibilities:

• Involved in preparation of technical designs as per the business logics mentioned in Functional specification (AI Specification).
• Design and development of ETL jobs for Extraction of Health care data from source systems,Cleansing, Staging, applying Transformations and eventually loading into the data warehouse.
• Developed Parallel jobs using various stages likeJoin, Merge, Lookup, Surrogate key, Scd, Funnel, Sort, Transformer, Copy, Remove Duplicate, Filter, Pivot and Aggregatorstages for grouping and summarizing on key performance indicators used in decision support systems.
• To Develop the technical components like PL/SQL Procedures, Unix Shell Scripts, sqlloader control files to achieve the exact business needs.
• Configured ODBC connections to DB2 and Oracle databases on the DataStage server
• Managed user sessions and logged events of suite components
• Designed DataStage Parallel jobs for Extraction, Cleansing, Transformation and Loading of the source data into the Data Warehouse.
• Created ETL jobs to execute SQL Server Stored Procedures and extract data from them
• Involved in the migration of Data Stage jobs from development to QA for testing of the Jobs.
• Prepared Unit Test cases for the developed code and did the Unit Testing.
• Involved in On-Call activities and Cycle monitoring.
• Designed ETL job sequencers to facilitate scheduling and better maintenance of ETL processes.
• Responsible for Production Support and involved in On-Call for Data Integration Applications.
• Provided defect fixes for the issues in the production

Environment: Datastage7.5x2, Oracle 9i/10/11, Teradata 12.4, UNIX, AIX 5.0 and TWS

Confidential, Atlanta, GA

ETL Developer

Responsibilities:

• Understanding existing business model and customer requirements.
• Analyzing the specifications and functional documents of project requirement.
• Developed documents like source-to-target mapping for developing the ETL jobs
• Developed SQL and PL/SQL Prototypes as the initial building blocks for ETL Processes
• Design and development of ETL job’s using Data Stage
• Used most of the Stages in Data stage, such as the Transformer Stage, lookup stage, joiner stage, funnel stage ODBC Stage, Aggregator Stage, Sequential Stage, Shared Containers Etc.
• Tuned Data Stage jobs for better performance.
• Created local and shared containers to facilitate ease and re-use of jobs.
• Preparation and Execution of unit test cases
• Involved in the migration of DataStage projects from Development to Production environment
• Involved in 24/7 production support on a rotation basis

Environment: Datastage7.5, Oracle 9i, IBM DB2, UNIX, AIX 5.0 and Tivoli Workload Scheduler

Confidential

Datastage Developer

Responsibilities:

• Designing of the jobs to extract, transform and load data from flat files into data warehouse using Data stage Designer.
• Prepared detailed design and program specifications documents based on the high level design document, Functional specification document and BRD.
• Provide day to day status report to the manager.
• Involved in testing in various phases like Unit Testing, SIT and UAT.
• Involved in deployment of jobs in the production environment
• Playing key role in resolving the problem tickets raised by the users.
• Involved in preparing the Database scripts for newly added systems and countries.
• Migrating DataStage jobs from old version to new version

Environment: Datastage7.5, Oracle 9i, IBM DB2, UNIX, AIX 5.0 and Autosys

Confidential

Application Developer

Responsibilities:

• Designing of Impact Analysis and Technical Document.
• Developed DataStage applications (Jobs) based on the Design and Mapping documents and also tuned them for better performance
• Designing of Unit Test Cases and Involved in Unit Testing.
• Provide day to day status report to the manager.
• Involved in preparing the Database scripts for newly added systems and countries.
• Involved in Migrating DataStage jobs from old version to new version
• Solved the issues with SIT Team.

Environment: Datastage7.5, IBM DB2, UNIX, AIX 5.0 and Autosys