Experience Summary

• 10 Years of experience in IT industry including expertise in design and development of Relational Database
• Systems, Design and Development of Data Warehousing using Oracle warehouse builder and Informatica Power Center ETL tool.
• Extensively worked on data warehousing concepts using various ETL tools like Informatica and Oracle Warehouse Builder.
• Good knowledge on reporting tools like business objects and microstrategy.
• Highly successful in implementing ETL workflows using oracle warehouse builder ETL tool.
• Experience in ETL tool, INFORMATICA V 7.x , V 8.x V9.x . Experience in Using Repository Manager,
• Designer and Workflow Manger, Workflow Monitor Tools in Informatica Power Center.
• High successful in implementing dimentional modelling methodlogy.
• Good understanding in creating data marts for the business requirements.
• Experienced in handing informatica CDC data
• Good knowledge on the MDM master data management and IDQ informatica data quality
• Good experience in power exchange for handling the variable lenth mainfram files.
• Good experience in working the informatica in cloud servers.
• Having very good understading on the Confidentialge of webservices in informatica
• Extensive understanding of Transactional and Dimensional Data Modeling, Data Ware house concepts and
• Designing Star schemas Snowflake Schemas for OLAP Systems.
• Developed Slowly Changing Dimension mappings of Type1, Type2 and Type3 version, flag and time .
• Experience in Trouble shooting and implementing Performance tuning at various levels such as Source,
• Target, Mapping, Session and System in ETL Process.
• Strong experience in developing complex mappings using transformations like Unconnected and Connected Lookups, Router, Aggregator, Sorter, Joiner, Transaction Control, Filter and Update Strategy.
• Expertise in data extraction from Flat Files XML, mainframes,excel, csv, fixed width, delimited, txt , and Oracle server.
• Good in scheduling jobs and administration activities using Tivoli and control-M
• Good experience in handling terabytes of data and good at analyzing the data related issues.
• Extensively worked on oracle warehouse builder tool. Supported customizations and testing.
• Created various tasks like sessions, and workflows in the workflow manager to test the mapping during development.
• Hands on experience on SQL and PL SQL concepts. Working experience on oracle server.
• Extensively worked on performance tuning areas. Good knowledge on partitions, indexes, table space related issues.
• Very good experience on RDBS databases like Oracle and DB2, MS SQL server 2012
• Good at analyzing AWR Automatic Workload Repository report and good in providing suggestions on SQL tuning techniques using explain plans.
• Good working experience on partition exchange load process offline data loads in oracle.
• Implemented the offline data load activity using staging environment for the application performance improvement.
• Good in providing estimations on hardware sizing for the database servers.
• Good in suggesting the performance tuning techniques to increase the data load through put.
• Implement UNIX shell scripts for scheduling various tasks.
• Strong Knowledge in ETL design document and mapping sheet creation.
• Proficient in understanding Functional Requirements and Design documents.
• Good in creating HLD and other design documents as needed.
• Extensive expertise in designing, developing and executing test scenarios and test cases.
• Hands on Experience in HP Quality Center QC .
• Experience in testing various ReConfidentialble ETL Transformations which facilitate Daily, Weekly Monthly Loading of Data.
• Issue log maintained to track the Issues/Queries/Clarifications for each of the project
• Possess good communication skills and effective client communication.
• Strong problem solving technical skills coupled with confident decision making for enabling effective solutions
• leading to high customer satisfaction.
• Good understanding of ITIL process and working experience in production support environment.
• Having good experience as team lead and led the team with team size 3-5.
• Self-learner and highly self-motivated attitude.

Technical Experience

Professional Experience

Confidential

Role : Team Lead, Designer and Deveoper

Technology : Data warehouse, oracle, sql, plsql, Unix, DB2, MS sql server 2012

Tools : Informatica 9.5, Tivoli,HP QC

Confidential is one of the largest independent licensees of Confidential. Currently it is headquartered in Confidential. in downtown Detroit. Confidential, a nonprofit organization, provides and administers health benefits to more than 4.3 million members residing in Confidential in addition to members of Confidential groups who reside outside the state.

Key Responsibilities:

• Understanding existing business model and customer requirements in different data marts
• Designing the datamart with dimentional modelling.
• Implementation of new data marts and enchancement of the existing data marts.
• Developed mappings using various transformations such as the Source qualifier, Router, Filter, Sequence Generator, Aggregator, Lookup Connected Un-Connected , Stored Procedure , Normalizer and Expression as per the
• business requirement.
• Created/modified various Informatica Mappings and workflows for the successful migration of the data from various source systems to oracle which meets the business requirements for reporting and analysis.
• Worked with different source systems like MS sql server, DB2, mainfram flat files.
• Good understanding of the health insurance plans and processes in the CONFIDENTIAL.
• Design and development of UNIX Shell Scripts to handle pre and post session processes and also for validating the incoming files.
• Coordinating with the team and interacting with the client for implementation of deliverable.
• One to one interaction with the clients SME's and Data base teams.
• Proactively interacting with clients in understanding the requirements and fixing the issues.
• Debugged mappings by creating logic that assigns a severity level to each error, and sending the error rows to error
• table so that they can be corrected and re-loaded into a target system.
• Developing the unit test case document and performed various kinds of testing like unit testing, regression testing
• and system test in Dev, QA environments before deployment.
• Scheduling the control-M jobs using Tivoli.
• Design document creation and implementation.
• Testing of ETL jobs that are scheduled for file transfers from Operational Data Stores to designated file systems/directories.
• Developed Test Strategy document, Test schedule, Test plan and Test cases for Application development projects.

Confidential

Role : Team Lead, Designer and senior technical Developer

Technology : Data warehouse, oracle, sql, plsql, Unix, DB2

Tools : Informatica 9.1, Oracle Warehouse builder 1.0, 1.5 and 2.0 releases , Tivoli,HP QC, remedy ticket tool

Confidential is the world's top wireless phone services carriers with more than 370 million customers in about 25 countries. In the CONFIDENTIAL, Confidential holds 45 stake in leading CONFIDENTIAL wireless provider Confidential wireless. They are operating on a billing system provided by oracle which is the oracle Confidential System. eBilling system provided by oracle uses owb as the etl tool. Around tera bytes of data will be loaded for very month.

Key Responsibilities:

• Understanding existing business model and customer requirements in different local markets.
• Designing the dataware house with dimentional datamodelling methodology.
• Implementation of the data ware house part in all the local markets based on the requirements.
• Developed mappings using various transformations such as the Source qualifier, Router, Filter, Sequence Generator, Aggregator, Lookup Connected Un-Connected , Stored Procedure and Expression as per the business requirement.
• Created/modified various Informatica Mappings and workflows for the successful migration of the data from various source systems to oracle which meets the business requirements for reporting and analysis.
• Involved in performance tuning by identifying the bottlenecks at source, target, mapping, session, and database level.
• Implementation and up gradation of the billing system for all the local markets.
• Design and development of UNIX Shell Scripts to handle pre and post session processes and also for validating the incoming files.
• Developing the SQL scripts in TOAD and creating Oracle Objects like tables, materialized views, views, Indexes, sequences, synonyms and other Oracle Objects.
• Excellent understanding of Star Schema modeling, Snowflake modeling.
• Coordinating with the team and interacting with the client for implementation of deliverable.
• One to one interaction with the clients.
• Proactively interacting with clients in understanding the requirements and fixing the issues.
• Debugged mappings by creating logic that assigns a severity level to each error, and sending the error rows to error
• table so that they can be corrected and re-loaded into a target system.
• Developing the unit test case document and performed various kinds of testing like unit testing, regression testing and system test in Dev, QA environments before deployment.
• Played key role in performance improvement activities like query tuning.
• Provided table space ASCII for the database. Handled 10TB of database
• Experience in loading terabytes of data. Loaded 150GB per month. Like wise loaded 6-7months data into the data base.
• Scheduling the control-M jobs using Tivoli.
• Design document creation and implementation.
• Testing of ETL jobs that are scheduled for file transfers from Operational Data Stores to designated file systems/directories.
• Developed Test Strategy document, Test schedule, Test plan and Test cases for Application development projects.
• Tested various ReConfidentialble ETL Transformations which facilitate Daily, Weekly Monthly Loading of Data.
• Prepared status summary reports with details of executed, passed and failed test cases
• Worked in production support and good knowledge on the ITIL process of resolving the issues

Confidential

Role : Team Lead

Technology : Data warehouse, oracle 10g, sql, plsql, DB2.

Tools : Informatica Power Center 8.6, Unix, Toad, Sql developer

• This system is mainly concerned with pharmaceutical. It is migration of mapping from Informatica version 7.X to Informatica version 8.X, Error handler and Sending email to Lotus Notes distribution on execution error. Removing the detail of the persons who are no longer with the company and have Confidential account are to be stored into the Flat files for COE management.
• Understanding the existing business model and requirements, involved in requirements gathering and understanding business needs.
• Extensive experience in using ETL process using Informatica Power Center 8.x/7.x.
• Have participated in exporting the sources, targets, mappings, workflows, tasks etc. And imported into the new Informatica 8.X, tested, reviewed to make sure that all the workflows are Execute as per the Design documents and
• Tech specs.
• Developing the Mappings using needed Transformations in Informatica tool according to technical specifications
• Created/modified various Informatica Mappings and workflows for the successful migration of the data from various source systems to oracle which meets the business requirements for reporting and analysis.
• Extensively used XML Source, XML target and XML Parser transformations
• Imported Source and Target tables from their respective databases
• Developing Mapplets and Transformations for migration of data from existing systems to the new system using Informatica Designer
• Excellent understanding of Star Schema modeling, Snowflake modeling.
• Extensively worked on Informatica Power Center Transformations such as Source Qualifier, Lookup, Filter,
• Expression, Router, Normalize, Joiner, Update Strategy, Rank, Aggregator, and Sorter.
• Interacting with off-shore people and Database team if any issues.
• Good in handling database of size 5TB. Loaded data of 100GB per month.
• Preparing the Documentation for the mapping according to the designed logic used in the mapping.
• Preparing Test Cases and executing them along with the Testing team
• Tested various ReConfidentialble ETL Transformations which facilitate Daily, Weekly Monthly Loading of Data.
• Attend the meeting and update the testing status and discuss about blocking issues.
• Performed Regression testing, Smoke Testing, Integration Testing, GUI Testing.
• Identified defects were reported using Quality Center QC tool.
• Classified the defects according to severity level, priority level and prepared Test Status Report during test execution process.
• Participated in weekly status meetings, and conducting internal and external reviews as well as formal walkthroughs among various teams, and documenting the proceedings.

Confidential

Role : Developer

Technology : Informatica 9

Tools : Informatica Power Centre 9.

CONFIDENTIAL is the leading telecommunications and CONFIDENTIAL service provider in The Confidential, offering wireline and wireless telephony, internet and TV to consumers, and end-to-end telecommunications and CONFIDENTIAL services to business customers. CONFIDENTIAL's subsidiary Getronics operates a global CONFIDENTIAL services company with a market-leading position in the Benelux, offering end-to-end solutions in infrastructure and network-related IT.

Key Responsibilities:

• Understanding the existing business model and requirements, involved in requirements gathering and understanding business needs.
• Involved in analyzing the requirements and created Design Documents and Data Mapping Documents.
• Worked with Source Analyzer, Warehouse designer, Mapping, Mapplet Designer, Transformations, Workflow Manager and Monitor.
• Developed mappings using various transformations such as the Source qualifier, Router, Filter, Sequence Generator, Aggregator, Lookup Connected Un-Connected , Stored Procedure and Expression as per the business requirement.
• Used Mapping Parameters and Variables to implement object orientation technologies and facilitate the reConfidentialbility of code.
• Developed mappings to implement Slowly Changing Dimensions Type 1 2 .
• Involved in performance tuning by identifying the bottlenecks at source, target, mapping, session, and database level.
• Design and development of UNIX Shell Scripts to handle pre and post session processes and also for validating the incoming files.
• Developing the SQL scripts in TOAD and creating Oracle Objects like tables, materialized views, views, Indexes, sequences, synonyms and other Oracle Objects.
• Debugged mappings by creating logic that assigns a severity level to each error, and sending the error rows to error
• table so that they can be corrected and re-loaded into a target system.
• Developing the unit test case document and performed various kinds of testing like unit testing, regression testing and system test in Dev, QA environments before deployment.
• Developed Audit Strategy to validate the data between Source and Target System.
• Involved in Production Support.

Confidential

Role : Developer

Technology : SQL, PL SQL, Informatica 8.5,sql server

Tools : Informatica Power Centre 8.5.1.

Confidential is a world leader in financial protection and wealth management. v services over 50 million customers throughout the world. v, occupies leading positions in its main markets: life insurance, health insurance and general insurance. Over here data is processed and Individual sales system ISS was implemented for business with the objective to keep accurate customer profiles ,to enable better targeted and more flexible database for performing marketing campaigns, To produce and manage renewal and mid-term changes and to introduce the sale of a new lower premium product to a targeted customer base

Key Responsibilities:

• Understanding existing business model and customer requirements.
• Developed mappings using informatica for data flows from Source to Target.
• Used various transformations like the Joiner, filter, lookup, expression, aggregator etc... In mappings to perform the ETL process.
• Worked on mapping review, if design flaws found as a part of peer testing.
• Created Effective Test Data and Unit Test cases to ensure successful execution of data loading processes.
• Performed Informatica code migrations, testing, debugging and documentation.

Confidential

Role : Developer

Technology : SQL, PL SQL, Informatica 8.5,Oracle 9i

Tools : Informatica Power Centre 8.5.1,TOAD, Visual Source Safe, QC

Confidential Services helps multi-site organization's to master the complexity of business communication. It serves corporate and government customers worldwide, and wholesale customers outside the Confidential. Over here all the data related to customer orders for different types of access types and billing amounts are processed and loaded into target for business users for analysis.

Key Responsibilities:

• Understanding existing business model and customer requirements.
• Developing the Mappings using needed Transformations in Informatica tool according to technical specifications
• Created/modified various Informatica Mappings and workflows for the successful migration of the data from various source systems to oracle which meets the business requirements for reporting and analysis.
• Used various transformations like the Joiner, filter, lookup, expression, aggregator etc... In mappings to perform the ETL process.
• Involved in testing the ETL mappings
• Created Effective Test Data and Unit Test cases to ensure successful execution of data loading processes.
• Identified defects were reported using Quality Center QC tool.