Experience Summary

• 8 Years of experience in IT industry including expertise in design and development of Relational Database Systems, Design and Development of Data Warehousing using 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.
• 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.
• Experienced in handing informatica CDC data
• 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, 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.
• 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.
• Worked predominantly in billing systems.
• 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.
• 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

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

Tools : Informatica 9.1, Oracle Warehouse builder 1.0, 1.5 and 2.0 releases , Tivoli

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 Verizon wireless. They are operating on a billing system provided by oracle which is the oracle eBilling 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.
• 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.
• Scheduling the control-M jobs using Tivoli.
• Design document creation and implementation.

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.
• 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
• 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 reusability 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. CONFIDENTIAL services over 50 million customers throughout the world. CONFIDENTIAL, 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

Confidential 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.
• 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.