Summary of Skills

Over * years of experience with business intelligence solutions, data warehouses, and business process design in HR Analytics on Oracle. Excellent written and spoken communication; Decisive, action oriented, and results driven

DW & BI Tools

OBIEE 10.1.3.x

Siebel Analytics 7.8

SQL Server Reporting Services

Crystal Reports.

ETL Tools

Informatica Power Center 8.6

SQL Server Integration Services

Database

Oracle 10G

SQL server 2005/2000

Operating Systems

Windows 2000/NT 4.0/98/95/ME/XP

UNIX (Solaris 8)

Professional Experience

Access MED August 2011- Current

Consultant

Access MED, LLC provides reimbursement consulting services to device manufacturers, physicians, patients, hospitals, pharmacists, and pharmaceutical companies. Its consulting services include reimbursement assessment and payer research, legislative and policy monitoring, sales tool development, reimbursement education and training, compendia support, and product support services. The company also offers reimbursement case management, patient assistance programs, patient education, and practice and facility resource services, as well as technology solutions, such as on-line applications, reports, and Web hosting, and status checks. In addition, it involves in verifying insurance, resolving complex denied claims, and identifying funding sources for uninsured or underinsured patients. Further, Access MED, LLC provides drug reimbursement and financial services through its call center. The company was founded in 1995 and is based in Overland Park, Kansas. As of July 6, 2006, Access MED, LLC operates as a subsidiary of US Oncology Inc.

Some of the activities / responsibilities include:

• Created Informatica mappings, Sessions and executed them to Load the data from the source system using Informatica Server Manager.

• Developed and documented Data Mappings/Transformations and Informatica Sessions as per the business requirement.

• Performed integrated Testing for various Mappings Tested the data and data integrity among various Sources and Targets

• Developing SQL Scripts for Data Validation after Loading and other data manipulation activities in various environment(mainly Oracle 10g & SQL Server 2005).

• Configuring Data Warehouse Administration Console (DAC) and running the Complete Workforce Informatica Sessions Using DAC.

• Implementing Slowly Changing Dimensions – Type I & II in different mappings as per the

• Creating Unique Index, Clustered Index and Non-Clustered Index on the Fact tables.

• Creating Session and Workflow for Full Load and Incremental Load

• Loading data into data warehouse (ETL).

• Involved in Performance tuning of ETL mappings

• Monitoring ETL full and incremental loads

• Defining and implementing Backup strategy for Informatica Repository, DAC repository , OBIEE RPD, and Web Catalog

Creating and modifying requests, along with charts and filters, in OBIEE

Eaton Corporation. May 2011- August 2011

Consultant

Eaton Corporation is a diversified power management company with 2010 sales of $13.7 billion. Celebrating its 100th anniversary in 2011, Eaton is a global technology leader in electrical components and systems for power quality, distribution and control; hydraulics components, systems and services for industrial and mobile equipment; aerospace fuel, hydraulics and pneumatic systems for commercial and military use; and truck and automotive drivetrain and powertrain systems for performance, fuel economy and safety. Eaton has approximately 70,000 employees and sells products to customers in more than 150 countries.

Some of the activities / responsibilities include:

• Created Informatica mappings, Sessions and executed them to Load the data from the source system using Informatica Server Manager.

• Developed and documented Data Mappings/Transformations and Informatica Sessions as per the business requirement.

• Performed integrated Testing for various Mappings Tested the data and data integrity among various Sources and Targets

• Developing SQL Scripts for Data Validation after Loading and other data manipulation activities in various environment (mainly Oracle 10g & SQL Server 2005).

• Configuring Data Warehouse Administration Console (DAC) and running the Complete Workforce Informatica Sessions Using DAC.

• Implementing Slowly Changing Dimensions – Type I & II in different mappings as per the

• Creating Unique Index, Clustered Index and Non-Clustered Index on the Fact tables.

• Creating Session and Workflow for Full Load and Incremental Load

• Loading data into data warehouse (ETL).

• Involved in Performance tuning of ETL mappings

• Monitoring ETL full and incremental loads

• Defining and implementing Backup strategy for Informatica Repository, DAC repository , OBIEE RPD, and Web Catalog

• Creating and modifying requests, along with charts and filters, in OBIEE

American Multi-Cinema, Inc. Oct 2010- May 2011

Consultant

American Multi-Cinema, Inc. operates movie theatre chains in the United States. The company was formerly known as Durwood Theatres and changed its name to American Multi-Cinema, Inc. in 1968. The company was founded in 1920 and is based in Kansas City, Missouri. American Multi-Cinema, Inc. operates as a subsidiary of AMC Entertainment, Inc.

Some of the activities / responsibilities include:

• Created Informatica mappings, Sessions and executed them to Load the data from the source system using Informatica Server Manager.

• Developed and documented Data Mappings/Transformations and Informatica Sessions as per the business requirement.

• Performed integrated Testing for various Mappings Tested the data and data integrity among various Sources and Targets

• Developing SQL Scripts for Data Validation after Loading and other data manipulation activities in various environment (mainly Oracle 10g & SQL Server 2005).

• Configuring Data Warehouse Administration Console (DAC) and running the Complete Workforce Informatica Sessions Using DAC.

• Implementing Slowly Changing Dimensions – Type I & II in different mappings as per the

• Creating Unique Index, Clustered Index and Non-Clustered Index on the Fact tables.

• Creating Session and Workflow for Full Load and Incremental Load

• Loading data into data warehouse (ETL).

• Involved in Performance tuning of ETL mappings

• Monitoring ETL full and incremental loads

• Defining and implementing Backup strategy for Informatica Repository, DAC repository , OBIEE RPD, and Web Catalog

• Creating and modifying requests, along with charts and filters, in OBIEE

AXA Montreal July 2010- Oct 2010

Consultant

AXA Montreal Canada, A leader in financial protection, AXA works hard so its clients can be life confident.

AXA puts its know-how and broad range of Liability Insurance and Personal Insurance products at the service of its clients to protect them from life’s hazards and build their estate, while giving them the tools to fulfil their dreams and look to the future with confidence.

This project involved deployment of HR – Analytics on Oracle

Some of the activities / responsibilities include:

• Created Informatica mappings, Sessions and executed them to Load the data from the source system using Informatica Server Manager.

• Developed and documented Data Mappings/Transformations and Informatica Sessions as per the business requirement.

• Performed integrated Testing for various Mappings Tested the data and data integrity among various Sources and Targets

• Developing SQL Scripts for Data Validation after Loading and other data manipulation activities in various environment (mainly Oracle 10g & SQL Server 2000).

• Configuring Data Warehouse Administration Console (DAC) and running the Complete Workforce Informatica Sessions Using DAC.

• Implementing Slowly Changing Dimensions – Type I & II in different mappings as per the

• Creating Bit Map Index On the Fact tables

• Creating Session and Workflow for Full Load and Incremental Load

• Loading data into data warehouse (ETL).

• Involved in Performance tuning of ETL mappings

• Monitoring ETL full and incremental loads

• Defining and implementing Backup strategy for Informatica Repository, DAC repository , OBIEE RPD, and Web Catalog

• Creating and modifying requests, along with charts and filters, in OBIEE.

Agilysys, Inc. March 2010- July 2010

Consultant

Agilysys is a leading provider of innovative IT solutions to corporate and public-sector customers, with special expertise in select markets, including retail and hospitality. The company uses technology including hardware, software and services to help customers resolve their most complicated IT needs.

This project involved deployment of Finance, Procurement & Spend

Projects, Service and Order Management Analytics on Oracle application R12.1

Some of the activities / responsibilities include:

• Created Informatica mappings, Sessions and executed them to Load the data from the source system using Informatica Server Manager.

• Developed and documented Data Mappings/Transformations and Informatica Sessions as per the business requirement.

• Performed integrated Testing for various Mappings Tested the data and data integrity among various Sources and Targets

• Developing SQL Scripts for Data Validation after Loading and other data manipulation activities in various environment (mainly Oracle 10g & SQL Server 2000).

• Configuring Data Warehouse Administration Console (DAC) and running the Complete Workforce Informatica Sessions Using DAC.

• Implementing Slowly Changing Dimensions – Type I & II in different mappings as per the

• Creating Bit Map Index On the Fact tables

• Creating Session and Workflow for Full Load and Incremental Load

• Loading data into data warehouse (ETL).

• Involved in Performance tuning of ETL mappings

• Monitoring ETL full and incremental loads

• Defining and implementing Backup strategy for Informatica Repository, DAC repository , OBIEE RPD, and Web Catelog

• Creating and modifying requests, along with charts and filters, in OBIEE.

Cricket Communications Oct 2009- Mar 2010

Consultant

Cricket Communications is a simple, affordable wireless service offering consumers and local businesses a flat-rate unlimited service over the latest technology, high-quality, all-digital wireless network. Designed for customers whose basic and advanced wireless needs have not been met by traditional communications companies.

Deployment of HR analytics 7.9.5 on a highly customized Oracle instance and Upgrade to 7.9.6

Some of the activities / responsibilities include:

• Analyzing the requirements and converting into the technical documents. Identified the stars (Dimensions/Facts) that need to be populated

• Created Informatica mappings, Sessions and executed them to Load the data from the source system using Informatica Server Manager.

• Developed and documented Data Mappings/Transformations and Informatica Sessions as per the business requirement.

• Performed integrated Testing for various Mappings .Tested the data and data integrity among various Sources and Targets

• Developing SQL Scripts for Data Validation after Loading and other data manipulation activities in various environments (mainly Oracle 10g & SQL Server 2000)

• Configuring Data Warehouse Administration Console (DAC) and running the Complete Workforce Informatica Sessions using DAC

• Built metadata in the analytics repository with Analytics Administration Tool in physical, business and presentation layers

• Created a multi-developer environment utilizing projects.

• Created modified and formatted requests, along with charts and filters in OBIEE

Great West Insurance Feb 2008- October 2009

Consultant

Great West Insurance Company serves more than 3.6 million Americans through a full range of managed healthcare, life and disability insurance, and retirement savings products and services. This system gives full information regarding benefits, plans offered by the company, educate people about diseases, prevention, ICD codes, HIPPA act and users can enroll and can avail the benefits offered.

This project includes developing Data warehouse from different data feeds and other operational data sources. This application is specifically designed for Financial and Productions department. It helps these departments to frequently evaluate their strategies regarding Production and Finance. Build a central Database where data comes from different sources like oracle, SQL server. Actively involved as an Analyst for preparing design documents and interacted with the data modelers to understand the data model and design the ETL logic.

Some of the activities / responsibilities include:

• Creating new mappings and updating old mappings according to changes in Business logic

• Performing major role in understanding the business requirements and loading data into data warehouse (ETL)

• Using ETL (Informatica) to load data from source to ODS

• Using Informatica client tools - Source Analyzer, Warehouse designer, Mapping Designer

• Mapplet Designer, and Transformation Developer for defining Source & Target definitions

• Code the process of data flow from source system to data warehouse.

• Implementing Slowly Changing Dimensions – Type I & II in different mappings as per the requirements.

• Using Informatica Workflow Manager and Workflow Monitor to schedule and monitor session status

• Using Debugger to troubleshoot the mappings

• Creating Workflows using Workflow Manager

• Preparing Test Cases

• Developing mappings in Informatica to load the data from various sources into the Data Warehouse, using different transformations like Joiner, Aggregator, Update Strategy, Rank, Router, Lookup, Sequence Generator, Filter, Sorter, Source Qualifier

Bank of America Nov 2006- Feb 2008

Consultant

Bank of America is the largest commercial bank in the United States in terms of deposits, and the largest company of its kind in the world. The purpose of the project developed here is to build a comprehensive information warehouse that gathers stores and analyzes the data necessary to facilitate target marketing and risk management decisions. This warehouse accumulates information about clients, including detailed information regarding transactions and type of usage. The historical data was linked with current transactions to generate various reports for executive decision support regarding target marketing of new products and services.

Some of the activities / responsibilities include:

• Used Informatica for extraction from legacy and oracle based sources.

• Used various transformations like Source Qualifier, Lookup, Router, Filter, Update Expression, Aggregator, Sorter, Sequence Generator etc

• Used unconnected lookup where different expressions used the same lookup and had multiple targets, which use same logic executed and return one value.

• Implemented special data loading techniques using Informatica External loader and Teradata tools, providing efficient load times

• Used the Debugger in debugging some critical mappings to check the data flow from instance to instance

• Created error log table to capture the error messages, session load time

• Created various tasks like sessions and workflows in the workflow manager to test the mapping during development

• Informatica PC client tool is only used during development and debugging

• Used Workflow monitor to see the work flows running and get the session properties and session log.

• Developed all the mappings according to the design document and mapping specs provided and performed unit testing

• Performed unit testing and documented the unit test plan and its results

• Involved in performance tuning of various mappings and sessions to increase the performance

British Telecommunications Dec 2005- Nov 2006

Consultant

British Telecommunication has two major applications, One View and One Siebel to support its customers all around Europe. One View is basically a call centre application and One Siebel is used to create, modify, amend and delete orders.

Some of the activities / responsibilities include:

• Prepared the test cases and executed the test cases.

• Load Runner and Test Partner script development.

• Formal Performance and Load tests execution

• Regression testing is implemented at various phases of the test cycles.

• Involved in logging the defects in the defect tracking tool

• Evaluated test results with reference to the design specification documents

Securities Exchange Board of India Oct 2004- Dec 2005

Consultant

We were given a project for implementing ERP into workflow of SEBI. Oracle Applications 11i was used for the same along with J2EE platform, oracle forms and Reports as tools. Integration of Oracle Financials(AP, General Ledger) and Oracle HR with customized Reimbursement module was managed very successfully and enhanced the workability of this important Government organization

Some of the activities / responsibilities include:

• Co-ordination with Team members, Client and other interactive modules within the application especially Human resource as well as Finance Module

• Analyzed vital points with client regarding their present workflow, the different contrasting conditions for data migration for meeting their requirements to maximum and smooth implementation

• Worked as a PLSQL Developer and also conveyed the details to my team members through proper documentation, gave demonstration for User acceptance testing.

• Developed Procedures, functions, packages, triggers with appropriate exception handlers for loading the reimbursement balances successfully through batch programs for different types of reimbursements and also maintaining the claim records

Interstate Battery System International Inc. Feb 2003- Oct 2004

Consultant

Interstate All Battery Center provided the facility with a total of 900 alkaline batteries (size D and 9V), 10 solar crank flashlight radios, 10 surge protectors, two 800-watt power inverters, 50 baseball cap lights, and an uninterrupted power supply unit.

Some of the activities / responsibilities include:

• Co-ordination with Team members, Client and other interactive modules within the application especially Human resource

• Prepared the test cases and executed the test cases.

• Load Runner and Test Partner script development.

• Formal Performance and Load tests execution

• Regression testing is implemented at various phases of the test cycles.

• Involved in logging the defects in the defect tracking tool

• Evaluated test results with reference to the design specification documents.

Contact this candidate