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

Project Description

Confidential 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: Confidential, 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: Shutterfly
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 Of Ohio
Employer: Confidential, 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 reusabletransformations 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

Confidential 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: KPI Partners, Hyderabad, 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.