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.
• Ability to adapt and learn new technologies at a fast pace.
• Strong Knowledge in dimensional Star Schema, and Snowflakes Schema methodologies to develop data marts.
• Experience in Testing and writing SQL and Procedures.
• Involved in Unit Test Case, Integration Test, User Acceptance Test UAT preparation and testing of the applications.
• Expert in debugging, troubleshooting, monitoring, and performance tuning.
• Proficiency in data warehousing techniques for data cleansing, Slowly Changing Dimension phenomenon, surrogate key assignment and change data capture.
• Experience in logical and physical data modeling using Erwin, Dimensional Data Modeling and OLTP design.
• 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.
• 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 Expertise:

Professional Experience

Confidential

• The key objective of the Control Tower Report Migration CTRM initiative is to re-engineer the current Control Tower Reporting CTR environment to that of a dimensional design environment with an analytics platform specifically designed for Business Intelligence BI reporting and decision-support analytics. Re-engineering current CTR data structures into dimensional Data Marts will provide a robust and reliable reporting environment that delivers the information management needs to make business decisions. Additionally, the intent is to transform CTRM into a new process structure with the appropriate rigor and controls that would sustain data quality and alleviate any user confidence, as well as, policy compliance issues.

• This project used agile methodology and implementation is divided into multiple releases.
• This 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
• Have 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

• Technical metadata source and target database name, table name, column name, field type, length, default values, domain of values.
• Business metadata element names, definitions, etc. specific attributes to be provided
• Establish an integration path between the metadata repositories and IIS for the capture of metadata for key elements where one or more of the systems is a source or a target. For data elements make available in IIS specific attributes that correspond to:
• 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

Confidential has decided on SAP Bank Analyzer Profitability being the strategic application for the CLPR reimplementation. Target of the new architecture is to re-implement CLPR for Bank of America worldwide and to move from the Oracle OFSA to a SAP Bank Analyzer platform. The CLPR Reimplementation project is part of the FSR Release R3 Program FSR R3P

• 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

• Integrated ETL Processing for greater consistency and ease in maintenance -Unified data environment eliminating data redundancy -Increased claims details to support finance -Robust member centric view without sacrificing claims view.
• Strategic data warehouse SDW consists of 6 releases providing incremental business values with Analytics CoE, Advanced Analytics providing new and innovative capabilities. SDW customized solution represents fundamental shift in analytical capability for AETNA using IBM's Health plan data model HPDM including migration of legacy EDW to SDW and provide a reduce cost SDW support model. SDW solution framework is going to address the design, build of a data warehouse and analytical solutions using IBM's BI Reference Architecture. Followings are the key focus areas of SDW:
• 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

• Transport for London TfL is the local government body responsible for most aspects of the transport system in Greater London in England. Its role is to implement the transport strategy and to manage transport services across London
• 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.

Confidential

• Confidential. is one of the world's leading theatrical exhibition companies with interests in approximately 360 theatres with 5,128 screens. About 89 percent of theatres are located in the U.S. and Canada. In the U.S., They have significant presence in major urban markets with location in 30 states and the District of Columbia. AMC have the No.1 or 2 market shares in 22 of the top 25 Designated Market Areas DMAs The balance of AMC company's screens is in attractive international markets, including Mexico, Hong Kong, France and the United Kingdom.
• 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

• Micron is one of the world's leading providers of advanced semiconductor solutions. Micron's DRAM and Flash components are used in todays most advanced computing, networking, and communications products, including computers, workstations, servers, cell phones, wireless devices, digital cameras, and gaming systems. Micron also provides CMOS image sensor solutions to the handset camera, digital still camera, and PC video camera markets.
• 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

• Schneider Electric manufactures electrical distribution and automation control equipment utilizing its world leading brands - Merlin Gerin, Telemecanique, etc.
• 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

• Stored Value Systems SVS , a Comdata company, offers private label, electronic cash cards to companies that sell products or services including but not limited to petroleum, restaurant, retail and supermarket industries. SVS founded in 1992, employs over 150 people at customer support center in Louisville, KY and EI Paso, TX. Scope includes creating a data mart using DB2 as backend, Datastage as an ETL Tool and Business Objects as a reporting tool.
• 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

• The project supports the organization in providing the ability to access operational data for management reporting and allowing knowledge workers to investigate the history of the customer.
• The project involved development and implementation of a data warehouse for PerkinElmer that encompasses the following functional areas:
• PerkinElmer Fluid Sciences manufactures parts for the military and defense related markets.
• 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