PROFESSIONAL SUMMARY:

• 9+ years experience in different Software Development Life Cycle phases like Gathering requirements, Requirement analysis, Design and development, ETL mappings, Integration testing and User Acceptance testing (UAT).
• Good understanding of Data warehousing architecture and ETL framework. Worked on end to end implementation for Data warehousing/BI solution.
• Experience in source systems analysis and data extraction from various sources like Oracle 8.x/9i/10g, DB2 UDB, MS SQL Server and Worked on integrating data from Flat Files, CSV files and XML files into a common reporting and analytical Data Model.
• Experience in logical and physical data modeling using Erwin, Dimensional Data Modeling and OLTP design.
• Proficiency in data warehousing techniques for data cleansing, Slowly Changing Dimension phenomenon, surrogate key assignment and change data capture.
• Expert in debugging, troubleshooting, monitoring, and performance tuning.
• Involved in Unit Test Case, Integration Test, User Acceptance Test (UAT) preparation and testing of the applications.
• Experience in Testing and writing SQL and Procedures.
• Strong Knowledge in dimensional Star Schema, and Snowflakes Schema methodologies to develop data marts.
• Ability to adapt and learn new technologies at a fast pace.
• A Team Leader with scholastic aptitude, object - oriented approach.
• An organized professional with excellent communication and interpersonal skills, with ability to deliver projects well within timeframe and budgets

TECHNICAL SKILLS:

Tools: / 3rd party Applications: IBM InfoSphere DataStage v 7.5.1/8.1/8.7, Metadata Workbench, Information Analyzer, Business Glossary, SQL Server Integration Services, MS Reporting Services.

Databases: Oracle 9i/11g, DB2, Sql Server and Teradata.

Programming languages: C, C++

Operating Systems: IBM AIX 5.1/4.3,UNIX LINUX and Windows 95/98/ NT/2000/ XP.

Other S/W Tools: MS Office, Clear Case, Visio etc.

PROFESSIONAL EXPERIENCE:

Confidential

Responsibilities:

• dis project used agile methodology and implementation is divided into multiple releases.
• dis project is to build a BI solution which includes creation of Data Warehouse for Home Loans. Data is sourced from SQL Server, transformed in between process based on business rules and loaded to Oracle DataMart.
• Involved in functional and technical meetings and worked closely with business analysts for gathering and understanding the requirements.
• Collaboration with offshore and onsite teams in US and India with regards to work assignment, managing offshore resources.
• Involved in effort estimation
• Involved in designing ETL jobs using Datastage in GRID environment for an end to end Data warehousing implementation, developing DataStage Parallel/Sequencer jobs, Unit testing, and peer review process.
• Used many stages like Transformer, Sequential file, Dataset, Remove Duplicates, Sort, Join, Lookup, Funnel, Copy, Filter, ODBC etc.
• Extensively worked on Job Sequences to control the execution of the job flow using various Activities & Triggers (Conditional and Unconditional) like Job Activity, Wait for file, Email Notification, Sequencer, Exception handler activity and Execute Command.
• Involved in designing the ABC (Audit balance Control) framework to capture job statistics.
• Worked on tuning performance for DataStage jobs and Sql queries.
• Worked in all the environments Development, QA, Preproduction, and Production.
• Provided production support and troubleshoot run time issues during batch loads.
• Responsible for supporting the existing jobs and work on change requests from different teams as per the new requirements
• Has been continuously assisting in seamless on boarding and mentoring of new team members.
• Involved in Data validation.
• Involved migration process with admin team to different environments
• Extensively worked with database objects including tables, views, indexes and sequence objects.

Environment: IBM Information Server (Datastage) 8.7, Oracle, Sql Server, Unix, TOAD, Autosys

Confidential, California

Responsibilities:

• Being responsible for Design and Development of ETL jobs to load the data into Metadata workbench to maintain the lineage of metadata.
• Involved in functional and technical meetings and worked closely with business analysts for gathering and understanding the requirements.
• Collaboration with offshore and onsite teams in US and India with regards to work assignment, managing offshore resources.
• Involved in the analysis, detailed system design, development and technical documentation.
• Being responsible for Design jobs to load metadata into Metadata workbench.
• Responsible for review and the testing of created jobs and make sure metadata is being loaded properly into MWB.
• Extensively worked on Job Sequences to control the execution of the job flow using various Activities & Triggers (Conditional and Unconditional) like Job Activity, Wait for file, Email Notification, Sequencer, Exception handler activity and Execute Command.
• 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.
• Involved migration process with admin team to different environments.
• Involved in solving Production support issues.

Environment: IBM Information Server (Datastage) 8.7, Metadata workbench, Oracle, Sql Server, Unix, TOAD, Autosys

Confidential, Charlotte

Responsibilities:

• Involved in designing ETL jobs using Datastage, Unit testing, and peer review process.
• Used many stages like Transformer, Sequential file, Dataset, Remove Duplicates, Sort, Join, Lookup, Funnel, Copy, Filter, ODBC etc.
• Collaboration with offshore and onsite teams in US and India with regards to work assignment, managing offshore resources.
• Involved in the analysis, detailed system design, development and technical documentation.
• Creating datastage jobs to extract data from SAP R3 system to load data processed data to SAP BW system.
• Involved in Data validation.
• Involved migration process with admin team to different environments
• Involved in Performance tuning of datastage Jobs.

Environment: IBM Information Server (Datastage) 8.5, Oracle, Sql Server, Unix, TOAD, SAP.

Confidential

Responsibilities:

• Involved in functional and technical meetings and worked closely with end user to create mapping and technical documents.
• Collaboration with offshore and onsite teams in US and India with regards to work assignment, managing offshore resources.
• Involved in effort estimation
• Involved in designing ETL jobs using Datastage for an end to end Data warehousing implementation, developing DataStage Parallel/Sequencer jobs, Unit testing, and peer review process.
• Used many stages like Transformer, Sequential file, Dataset, Remove Duplicates, Sort, Join, Lookup, Funnel, Copy, Filter, ODBC etc.
• Extensively worked on Job Sequences to control the execution of the job flow using various Activities & Triggers (Conditional and Unconditional) like Job Activity, Wait for file, Email Notification, Sequencer, Exception handler activity and Execute Command.
• Worked on tuning performance for DataStage jobs and Sql queries.
• Responsible for supporting the existing jobs and work on change requests from different teams as per the new requirements
• Involved in Data validation.
• Involved migration process with admin team to different environments
• Extensively worked with database objects including tables, views, indexes etc.

Environment: IBM Information Server (Datastage) 8.1, Oracle, Sql Server, Unix, TOAD

Confidential

Responsibilities:

• Being responsible for Design and Development of ETL jobs
• Developing and implementing MIS for reporting purpose.
• Leading 8 members team as a Tech lead.
• Being responsible for Design and Development of ETL jobs.
• Created technical specifications using the functional specifications.
• Extracting data from the two different source system (SQL Server & DB2).
• Using Datastage as the ETL Tool for extracting data from source.
• Data validation and calculation for the Staging and Reporting tables.
• Creating a job for loading data into staging table from Raw Tables and from staging area to reporting area.
• Involved in unit testing and writing test cases.

Environment: IBM Information Server (Datastage) 8.1, Oracle, DB2, Unix.

Sr. System Executive

Confidential

Responsibilities:

• Developing and implementing Enterprise data warehouse for reporting purpose.
• Leading the team of 12 members as a Tech lead.
• Being responsible for Design and Development of ETL jobs.
• Created technical specifications using the functional specifications.
• Extracting data from the two different source system (SQL Server2005 & Oracle9i).
• Using Datastage 7.5 as the ETL Tool for extracting data from source.
• Carrying out cleansing, data validation, and calculation for the fact table and dimension tables.
• Creating a job for loading data into staging table from Raw Tables and from staging area to Data Warehouse.
• Involved in Data validation.
• Involved in unit testing and writing test cases.

Environment: IBM Information Server (Datastage) 7.5.1, Oracle, DB2, Unix.

Confidential

Responsibilities:

• Developing and implementing Inventory data mart for reporting purpose.
• Created tech specifications using the functional specifications.
• Extracting data from the two different source system (SAP & Oracle).
• Using Datastage 7.5.1 as the ETL Tool for extracting data from source.
• Carrying out cleansing, data validation, and calculation for the fact table and dimension tables
• Creating a job for loading data into staging table from flat file (Created by BAPI for SAP tables) and Oracle tables and from staging area to Data Warehouse.
• Being responsible for the development of ETL jobs.
• Involved in Data validation.
• Involved in unit testing and writing test cases.

Environment: IBM Information Server (Datastage) 7.5.1, Oracle, DB2, Unix, SAP R3.

Confidential

Responsibilities:

• Developing and implementing a data warehouse for reporting purpose.
• Involved in requirements gathering process
• Created tech specifications using the functional specifications
• Extracting data from the SQL Server database.
• Using SQL Server integration services as the ETL Tool for extracting data from source
• Carrying out cleaning, data validation, and calculation for the fact table and dimension table
• Creating a job for loading data into staging table from XLS File and from staging area to Data Warehouse.
• Worked as an ETL Developer as well as Report Developer
• Worked with client management team and created reports using MS Reporting Services for analysis and decision making process

Environment: SQL Server 2005, Integration Services, MS Reporting Services.

Confidential

Responsibilities:

• Developing and implementing a data warehouse for reporting purpose.
• Created tech specifications using the functional specifications
• Extracting data from the DB2 Server database.
• Using Datastage as the ETL Tool for extracting data from source
• Carrying out cleaning, data validation, and calculation for the fact table and dimension table
• Created jobs for loading data in staging server (ODS) and then to data mart.
• Being responsible for the development of modules, dimension and fact tables.
• Involved in Data validation.
• Involved in unit testing and writing test cases.

Environment: DataStage, DB2, BO Xi, Unix

Confidential

Responsibilities:

• Developing and implementing a data warehouse for reporting purpose.
• Extracting data from the MS SQL Server database.
• Using Datastage as the ETL Tool for extracting data from source.
• Carrying out cleaning, data validation, and calculation for the fact table and dimension table.
• Creating jobs for loading data in stage server from staging table and from staging to data mart.
• Using BO for reporting, fetching data from the fact table for generating different types of reports such as financial report, ad hoc report, backlog report, and graphical report.
• Being responsible for the development ETL jobs.
• Involved in Data validation.
• Involved in unit testing and writing test cases.

Environment: DataStage, Ms SQL Server, Unix