PROFESSIONAL SUMMARY:

• Over nine years of total IT experience in the Business Requirements Analysis, Application Design, Development, Implementation , Testing and production support of Data warehousing, Data Migration and Business Intelligence Application using Informatica, Oracle warehouse Builder (OWB), OBIEE & SQL.
• Expertise in installation, implementation and troubleshooting involving ETL Tools like Oracle Warehouse Builder 10G and 11G and Informatica 8.6
• Experience in Data Warehousing development using ETL tools such as OWB Designer, Control Manager and with Informatica Power Center ,Workflow Manager, Workflow Monitor, Source Analyzer, Transformation developer
• Created complex mappings in Designer using Aggregate, Expression, Filter, Sequence Generator, key look-up, Update Strategy, Rank, Joiner, and Stored procedure transformations to extract data from client’s operational databases, Transform and cleanse data and load it into data warehouse
• Good Understanding of dimensional modeling/Data Warehousing concepts and techniques
• Experience in developing OBIEE Repository (.rpd) at three layers (Physical Layer, Business Model & Presentation Layer).
• Created OLAP reports using Presentation Services (Answers, Dashboard, Prompts, Filter, and Views).
• Implemented OBIEE Security (Object Level and Data Level Security in the OBIEE Repository and Answers) using Repository Variables, Session Variables and Initialization Blocks.
• Experience in creating Time series measures using AGO & TODATE functions and Level based measures.
• Executed projects in Waterfall and V-model Software development methods
• Worked in on site and remote development models and in various environments requiring team coordination.
• Highly motivated team player with good communication skills and excellent problem solving abilities to work independently or as part of a team

TECHNICAL SKILLS:

ETL:
Oracle Warehouse Builder
Informatica Power Center 9.1 ,8.6.1 and 7.2
Oracle Data Integrator 10g

Databases:
Oracle 11g/10g/9i/8i
Reporting Tools:
OBIEE 10.1.3.x,11.1.1.x(Administration Tool, Oracle BI Web / Presentation Services, Answers, scheduling iBots using BI delivers)
Languages:
SQL, PL/SQL, Unix Shell Scripting, SQL*Loader
Tools:
Toad, SQL Developer, Erwin, PVCS, SVN
Operating Systems:
Windows , UNIX
Scheduling Tools:
Control-M, IBM’s Tivoli Workflow Manager

WORK EXPERIENCE:
Responsibilities:

• Designed and developed many simple as well as Complex Mappings, from varied transformation logic using Unconnected and Connected lookups, Filter, Expression, Aggregator, Joiner and more.
• Designed the ETL processes using OWB and Informatica tool to load data from File system and Oracle into the target Oracle Database.
• Developed mappings to load data from various sources using standard ETL transformations to store the data in the staging area and target tables.
• Extensively used Oracle External Tables in OWB
• Developed multiple Workflows using work flow manager for initial loading

Environment: Informatica 9.1, Oracle Warehouse Builder 11g, Oracle 11g/10g, SQL Developer

Confidential
ETL Developer

Confidential is the largest centralized national data warehouse that aggregates standardized medical and pharmacy claims, membership and account information from the BHI participating Plans. BHI brings together the healthcare experience of more than 54 million Confidential members nationwide in a safe and secure database.

• The data is accessible by each participating Plan to support their internal analysis and reports.
• As part of BHI Stage III project, Provider, SCCF (ITS Standard Claims Collection Facility claim) and
• Account reporting information will be added to the existing process of sending claims file to BCBSA.

Responsibilities:

• Analyzed the designed dimension model and laid out the steps for the data extraction, business logic implementation & loading into targets.
• Designed and developed many simple as well as Complex Mappings, from varied transformation logic using Unconnected and Connected lookups, Router, Filter, Expression, Aggregator, Joiner, Update Strategy and more.
• Designed the ETL processes using Informatica tool to load data from File system and Oracle into the target Oracle Database.
• Developed mappings & mapplets to load data from various sources using standard ETL transformations to store the data in the staging area and target tables.
• Responsible for Performance Tuning at the Source level, Target level, Mapping Level and Session Level.
• Extensively used both Connected and Un connected Lookup transformations
• Developed slowly changing dimension, according to the data mart schemas.
• Developed multiple Workflows using work flow manager for initial loading, historical data loading, using sessions, commands, decisions, events and timers.
• Responsible for implementing Incremental Loading mappings using Mapping Variables and Parameter Files
• Executed sessions, sequential and concurrent batches for proper execution of mappings and sent e-mail using workflow manager.

Environment: Informatica 9.1, Oracle 11g/10g, SQL Developer, SQL*LOADER, UNIX

Confidential, Atlanta
ETL Developer
This project deals with Anti money laundering system of Confidential. AML project replaces existing 4 different systems into one consolidated system. The first logical component in the new AML architecture is the data acquisition subsystem. The primary function of this subsystem is to acquire the data needed for AML surveillance. This data will originate from source systems in the different divisions of the firm: ISG, Zurich, IM and GWMG and will be loaded into consolidated Legal & Compliance (LC) Data Warehouse. Main subject areas that Application uses are: TRANSACTION and supporting reference data Confidential.

Environment: Informatica 9.1, Oracle 11g/10g, SQL Developer, SQL*LOADER, UNIX
Responsibilities:

• Gathering the Business Requirements.
• Analyzed the data in the source system, analyzed the Target schemas, transformed the data and mapped the data and load the data into targets using Informatica according to TDD specifications.
• Extensively worked with Informatica power center components for reusing the Business Functionality.
• Developed mappings to load the data in slowly changing dimensions such as Type1 and Type 2 according to the requirements.
• Created mappings using Informatica tool for DQ checks and for bring the data from source to staging tables and from staging tables to target tables. Actively participated in team meetings to gather business requirements and in developing the specifications.
• Involved in unit testing and integration testing

Environment: Informatica 9.1, Oracle 11g/10g, SQL Developer, UNIX, SQL*LOADER
Confidential, California
ETL & BI Developer

Confidential is a prebuilt business intelligence solution. Oracle Tax Analytics supports the source system Oracle Enterprise Taxation Management V2.2.1.Oracle Enterprise Taxation Management is an integrated Tax System solution that provides an end-to-end solution for Tax authorities at all levels of government and improves tax office efficiency. The Confidential Warehouse is a data repository for forms(Number of processed, suspended & corrected Forms by Form Type, Tax Type, Tax Year, Time, Employee, Time to Correct), payments(Number and $Amount of processed, suspended & corrected payments by Payment Type, Source, Tax Type, Time, Employee, Time to Correct), and accounting(Number and $Amount of financial transactions (Penalty, Interest, Write Off, Tax, credit), Penalty & Interest waivers) data which supports the analytical requirements of the source system Oracle Enterprise Taxation Management.

The Oracle Tax Analytics Warehouse includes

• A complete relational data warehouse data model with prebuilt star schemas encompassing conformed dimensions and fact tables
• Prebuilt data extractors to incorporate data from Oracle Enterprise Taxation Management into the Oracle Tax Analytics Warehouse
• Prebuilt RPD, reports and dashboards.

Responsibilities:

• Gathering the Business Requirements.
• Developed several reports and dashboards involving various views like table, pivot, graphs, narrative and maps.
• Developed the RPD file.
• Attribute level Data Analysis and building Data Mapping from source to target applications.
• Worked extensively on OBIEE Answers to test the reports as per the requirements.
• Identified and worked with various application areas in identifying, analyzing, and documenting various information sources solutions to meet the business requirements
• Extensively worked on OBIEE repository modeling at Physical, BMM and presentation layer
• Designed, developed and customized Reports and Dashboards using different analytical views.
• Designed and tested Reports in the Dashboards for the Oracle Tax Analytics and created the adhoc reports according to the client needs.
• Created session variables for users to provide row- level security to build the query
• Implemented Row level, Column level and object level security..
• Used OBIEE Answers to create the Tax Statement reports and Dashboards as per the detailed design requirements
• Coordinated the OBIEE RPD and Presentation Catalog objects migration across instances.
• Involved in setting up and working in multi-user developer (MUD) environment

Environment: OBIEE 10.1.3.4, OBIEE 11.1.1.3, Oracle Data Integrator, UNIX, Oracle 11g, SQL Developer,
Oracle’s Enterprise Tax Management Suit

Confidential, UK

(Data Analyst , ETL(OWB) and BI Developer)

Confidential has implemented an Oracle based ERP solution, enabling it to react to business initiatives quickly and to be future ready. As a result of this many legacy applications will be replaced with this packaged Oracle ERP suite of applications. This will call for migration of legacy data to the identified packaged applications that includes Finance, Trading & Supply Chain, Logistics, Stores, Merchandising and Manufacturing.

Responsibilities:

• Gathering the Business Requirements.
• Attribute level Data Analysis and building Data Mapping from source to target applications.
• Involved in designing the Requirement and Technical design documents.
• Coordinating with Offshore Team members for accurate code development.
• Involved in OWB code deployment activities across various environments.
• Analytic Business Analysis: Translating high-level business requirements into logical Business dimensional model; Defining various logical subject areas and organization Of presentation layer meta data, Understanding and defining key metrics, Dimensions, hierarchies and attributes.
• Developed new subject areas in the repository per business requirements.
• Created, modified and formatted requests, along with charts and filters, in OBIEE Answers.
• Created, modified, and administered analytics intelligence dashboards with links to web sites; HTML text; links to documents; and embedded content, such as images, text, charts, and tables.

Environment: Oracle Warehouse Builder (OWB 10g/11g), OBIEE 10.1.3.4, Informatica Power Center 8.6.1, UNIX, Oracle 10g/11g, SQL Developer, TOAD

Confidential, India
PL/SQL Developer
Project Engineer
The Power Smart project is designed to provide consumers about the real-time information on their electric power usage and provides pre estimated bill to the consumers. In this way the consumers can monitor to regulate the total monthly bill amount.
Responsibilities:

• Co-ordinate with the Onsite team about the daily activities in offshore.
• To work on the requirement as specified by the user in consultation with the functional team and developing the SQL and Shell scripts.
• Preparing the test data to suit the various business scenarios and to perform rigorous testing to validate the requirement.
• Complete documentation of the requirement

Environment: Oracle 10g, SQL Developer, UNIX
Confidential, India
Project Engineer
The project involved post implementation support for i2 Demand Planner and Supply Chain Planner implemented at Medtronic Inc, USA. This is based on CIS-ODS architecture and uses TmAPI schema. The project involves support of i2 DP & i2 SCP for 5 business units of Medtronic, upgrade initiatives for i2 DP and i2 SCP from 5.x to 6.x and fresh rollout of i2 DM for one business unit.
Responsibilities:

• Development of scripts (SQL,.KSH, .PL) to suit the business requirement.
• Development and testing the Forms as per the CRs. - Providing in time resolution to the EPM's (CR's) to meet the SLA.
• Developing the extract scripts to populate data into i2 ODS schema.

Environment: Oracle 9i, D2K (Oracle Forms and Reports 6i), Unix, Informatics, Oracle Database 10g, PL/SQL, PL/SQL Developer, SQL * LOADER, TOAD
Confidential, India
Project Engineer

Confidential based company associated with various business partners like bank and insurance companies. This project is for one of its Finance Companies, which is involved in distribution of loan amounts. This project aims to provide detail level of analysis that would help the company to enhance their business while making appropriate decisions.
Responsibilities:

• Design and development of ETL process using Informatica 7.1 to load data from file systems to the Warehouse.
• Implemented complex SQL scripts in the Informatica mapping as per the business requirement.
• Developed sessions, scheduling, monitoring and debugging the sessions.
• Developed test plans and writing test cases for unit testing.

Environment: Informatica Power Center 7.1.2., UNIX, Oracle 9i, SQL Developer, TOAD
Confidential, India
Project Engineer
Confidential help the customer to evaluate the sales and functional performance of its business operations. Confidential has 3 manufacturing plants in Merida (Mexico), Xiamen (China) & Bangalore (India) and having five liaison offices across the globe and above 20 warehouses across the globe.
Confidential requires the best-cost analysis & sales Evaluation system to compare the cost trends in different manufacturing locations & sales trends in different warehouses and liaison offices. The Confidential provides the information on customer’s buying patterns and trend over a period of time. The Production Cost & Sales standard reports are generated automatically. The software is designed to provide Confidential reports as per customer requirements. The business development team analyze for further improvement of their business by providing adequate information about sale leads & business conversion ratio.
The data is stored on the oracle database in all manufacturing & liaison office locations and stored on flat files in warehouses. Each location at the end of the day shall upload data into central server(s). We have provided Data Warehouse so that they could maintain historical data at central location for integration; analyze business in different locations, according profit areas, which could serve a purpose of a DSS for decision makers.
Responsibilities:

• Informatica Power Center 7.1, 2. UNIX
• Responsibilities: Responsible for Extracting, Transforming and loading data from operational database to warehouse database.
• Create and maintain Informatica Mappings. Defined source and
• Target Definitions in Informatica
• Developed reusable mappings using Mapplet designer

Environment: Informatica Power Center 7.1.2., UNIX, Oracle 9i, SQL Developer, TOAD