Experience Summary

• Around 7 years of overall IT experience involving Design, Development, Analysis and implementation using standard SDLC methodologies.
• Core competencies include design and development of ETL(Informatica) and reporting(OBIEE- developing repository and building Dashboards/Reports).
• Expertise in design and development of the three layers (Physical/Business Model and

Mapping/Presentation) of an OBI Metadata Repository using Oracle BI Administration
Tool.

• Configured Answers (ad-hoc querying, reports/analyses ), Interactive Dashboards with drill-down capabilities (charts/tables/graphs), ibots/agents (alerts) and administered Web Catalog Objects (pages, folders).
• Experience in Security Setup at both Object and Data levels.
• Strong Knowledge of Data Warehouse Architecture and Star Schema, Snow flake Schema, FACT and Dimensional Tables.
• Proficient in ETL processes of creating Source/Target definitions, building Mappings using various Transformations, creating and monitoring Sessions/Workflows.
• Extensively used the four basic Informatica Power Center tools - Repository Manager,

Designer, Workflow Manager and Workflow Monitor.

• Expertise in different stages of handling data viz. requirement gathering, identifying data

sources/targets , data cleansing, data loading.

• Created ETL mappings, Mapplets, reusable transformations, sessions, workflows, scheduling of ETL process, worked on performance tuning of ETL mappings, debugged

mappings and Mapplets.

• Strong conceptual background of RDBMS and access methods SQL, PL/SQL.
• Has good experience in preparing software requirement specifications(SRS) and software design documents.
• Performed Functionality and Performance testing for Informatica Power Center ETL tool,

Client/Server.

• Very Good Exposure to the entire Software Development Life Cycle.
• Outstanding communication, analytical and presentation skills.
• Ability to provide timely solutions and work within specified time frames.

Professional Experience

Project Title

Data Marts for MMO

Project Description

This client is a health insurance company headquartered in Cleveland and providing health insurance service across the states of Ohio. The data retrieved from the source was loaded to the data marts for report generation after implementing with the business logic in ETL. UNIX was the scripting environment while Informatica acted as an interface where inputs were tables in Oracle.

Client

Confidential,Ohio

Duration

June 11 to Tilldate

Responsibilities

• Extracted data from different source systems into the data warehouse.
• Extensively used mapping and mapplet designer of Informatica Power Center.
• Designed and implemented various transformations like Source Qualifier, Filter, Expression, Router, Aggregator, Sorter, and Lookup for loading the data into fact and dimension tables using mapping designer.
• Performed unit testing.
• Created and executed the sessions using Informatica workflow manager.
• Maintained reference document for all source systems data locations.
• Experience in Performance Tuning.
• Created reusable transformations and Mapplets.
• Used Workflow manager for Creating, Validating, Testing and running the sequential and

concurrent Batches and Sessions.

• Creating daily, weekly and monthly batches and scheduling them according to the precedence diagrams.
• Designing the ETL Technical Specifications Documents.
• Providing timely responses to all client requests.

Role

ETL Developer

Business Area

Insurance Domain

Technology

Informatica 8.5.1.X, Oracle 10g, SQL, UNIX, Flat Files, TOAD

Project Title

Marketing Research and Analysis , CA

Project Description

Cox Communications (also known as Cox Broadcasting Corporation) is a privately owned subsidiary of Cox Enterprises providing digital cable television, telecommunications and wireless services in the United States.

Client

Confidential,

Duration

October 09 to May 11

Responsibilities

• Designing the logics to be implemented at the RPD level and development of all layers of OBIEE Repository i.e. Physical, Business Model, and Presentation layer.
• Implementation of data and Object level security.
• Defining Multiple Dimension Hierarchies for the Dimension Logical Table and also Experience in creation of logical columns, hierarchies, level based measures in Business model.
• Created hierarchy for product and customer dimension tables.
• Implemented Usage Tracking.
• Created around 500 metrics in RPD.
• Created Reports with graphical representation such as Bar charts, pie charts.
• Created the reports using prompts and filters.
• Tested RPD performance

Role

OBIEE Developer

Business Area

Telecom Domain

Technology

Oracle 10g,OBIEE 10.0.1.3.4.1

Project Title

Accounting Finance

Project Description

GEICO is the 5th largest private-passenger auto insurer in the United States with $13.7 billion in assets. This project is developed in Insurance Accounting Department with a view of how to optimize cash flow and its various financial analysis. This project forecast and manages cash position eight to 12 months in advance.

Client

Confidential,

Employer

KPI Partners, Hyderabad, INDIA.

Duration

August 07 to September 09

Responsibilities

• Understand the business requirements.
• Imported various Sources, Targets, and developed Transformations using Informatica Power Center Designer.
• Developed various Mappings with the collection of all Sources, Targets, and Transformations.
• Designed, developed and deployed new data marts along with modifying existing marts to support additional business requirements.
• Created functional specification Document for each module of the project.
• Worked with complex mappings.
• Used Workflow manager for Session Management, Database Connection Management and Scheduling of jobs.
• Designed and Developed Transformations, Mappings and Sessions in Informatica to load target database and tuned mappings for improving performance.
• Experience in Co-ordinating with Testing Team.
• Created and Scheduled sessions and worklets using workflow manager to load the data into target database.
• Worked with different data sources such as Oracle and Flat files.
• Used Workflow manager for Creating, Validating, Testing and running the sequential and concurrent Batches and Sessions

Role

ETL Developer

Business Area

Insurance Domain

Technology

Informatica 8.1, Oracle 9i,Teradata,UNIX, Flat Files

Project Title

Enhancement Of HNI

Project Description

This client is a leading health insurance company headquarterd in California and providing health insurance service across the states of columbia. This project will enhance the existing datamart with new data elements taken from different lines of business, which can be used by Marketing Analysts for marketing campaigns. This project will expand the datamart with new fact and dimension tables, which can be accessed by marketing analyst for future marketing campaigns. The data retrieved from the source was loaded to the data marts for report generation after implementing with the business logic in ETL. UNIX was the scripting environment while Informatica acted as an interface where inputs were tables in Oracle.

Client

Confidential,

Employer

KPI Partners, Hyderabad, INDIA.

Duration

October 05 to July 07

Responsibilities

• Played a role of Team member.
• Extracted data from different source systems into the data warehouse
• Extensively used mapping and mapplet designer of Informatica Power Center.
• Customized data by adding calculations, summaries and functions.
• Designed and implemented various transformations like Source Qualifier, Filter, Expression, Router, Aggregator, Sorter, and Lookup for loading the data into fact and dimension tables using mapping designer.
• Performed unit testing.
• Created and executed the sessions using Informatica workflow manager

Role

ETL Developer

Business Area

Insurance Domain

Technology

Informatica 7.1.2 , SQL Developer, UNIX

Education

• Bachelors in Electronics and Communications Engineering.