Experience Summary

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

Technical Skills

• Reporting Tools
• OBIEE 10g,OBIEE 11g
• ETL Tools
• Informatica Power Center 9.x/8.x
• Operating Systems
• Windows 7/98/XP, UNIX
• Languages
• SQL, PL/SQL
• Tools & Utilities
• Oracle, Teradata, SQL*Loader, TOAD, MS SQL Server 2000, DB2, Flat files, SQL.
• Databases
• Oracle 11g/10g,SQL Server 2000, DB2 UDB

Professional Experience

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

June 11 to Till date

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 11g,OBIEE 11.1.1.5

Project Title

CDF(Commercial Distribution Finance), CA

Project Description

The objective of the project is to implement a reporting solution for GE Dealers & Distributors to analyse their Credit Line, Utilization, trending over year analysis etc.

Client

Confidential,

Duration

October 09 to May11

Responsibilities

• Understand the Business Requirements.
• Analyzing the requirement gathered from Business Users .
• Designing the logics to be implemented at the RPD level.
• Implementation of data and Object level security .
• Created Reports, prompts and Filters using OBIEE.
• Created dashboard pages and sections.
• Implemented language translation for different users.
• Implemented GE related branding.
• Created Reports with graphical representation such as Bar charts, pie charts
• Created alerts for reports.
• Created bookmark Link, Prompted Links and Saved Customizations.
• Formatted the Reports as per the Client requirement.

Role

OBIEE Developer

Business Area

Finance Domain

Technology

Oracle 10g,OBIEE 10.0.1.3.4,OBIEE 11g

Project Title

HR-Analytics, CA

Project Description

The objective of the project is to Implement OBIEE and HR Analytics Software on EBS in Shutterfly Inc. Integrating JobVite Recruitment system with BI Applications and Extend the Out of Box data model to support the current Shutterfly Recruitment related reports.

Client

Confidential,

Duration

August 2008 to September 2009

Responsibilities

• Understand the Business Requirements.
• Analysing the requirement gathered from Business Users
• Designing the logics to be implemented at the RPD level.
• Created Reports, prompts and Filters using OBIEE.
• Created dashboard pages and sections.
• Implemented Shutterfly related branding.
• Created Reports with graphical representation such as Bar charts, pie charts
• Created alerts for reports
• Created Links, Prompted Links and Saved customizations.
• Formatted the Reports as per the Client requirement

Role

OBIEE Consultant

Business Area

Human Resource-Analytics

Technology

Oracle 10g, OBIEE 10.0.1.3.4.1, SQL Server

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,

Employer

KPI Partners, Hyderabad, INDIA.

Duration

February 07 to July 08

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

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

Geico Insurance

Employer

Confidential,INDIA.

Duration

June 05 to January 07

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.5.1.X, Oracle 10g, Teradata, SQL, UNIX, Flat Files

Education

• Bachelors in Electronics and Communications Engineering.