Professional Summary:

• Solid years of Experience in the Healthcare and Pharmaceutical industry
• Experience with Customer Relationship Management (CRM) tools like Siebel and Siebel Analytics.
• Strong knowledge of OBIEE as a Business Intelligence tool and Data Extraction using Informatica as ETL tool.
• Experience in Data Warehousing Concepts like Star Schema, Snowflake Schema Methodologies.
• Participated in Requirements gathering, preparing Business Specification Documents, Functional Specification Documents, Data Mapping Sheets, Design Reviews and Test Cases for modules.
• Experience in Source Target Data Mapping.
• Participated in Integration of Siebel Database with OBIEE Database.
• Experience in ETL data loading from OLTP (Siebel CRM) Database to OLAP (OBIEE) Database.
• Involved in Integration of Siebel UI screen to OBIEE Dashboard.
• Experience in installation and configuration of Informatica Services.
• Experience in Development and maintenance of Informatica Repository and OBIEE repository.
• Experience in Performance tuning and Optimization of Cache with Informatica and OBIEE.
• Used Informatica Client tools like Designer, Workflow Manager, Workflow Monitor, and Repository Manager Etc.
• Well acquainted with Informatica Designer Components - Source Analyzer, Transformation Developer, Mapplet and Mapping Designer.
• Knowledge of Entity-Relationship concept, Facts and dimensions tables, slowly changing dimensions and Dimensional Modeling (Star Schema and Snow Flake Schema).
• Experience in designing/developing mapping using Source Qualifier, Lookup, Filter, Expression, Router, Update Strategy, Rank, Sequence Generator etc.
• Experience in developing Workflows, Worklets, sessions and tasks to effectively manage the Load .Also create and control workflows, tasks and sessions.
• Experience in Scheduling and monitoring Informatica sessions for automation of loads in DAC.
• Identified and debugged the errors before deploying and worked on migration of the mappings and workflows from development to testing, testing to QA and from QA to production.
• Worked on developing and debugging Informatica mappings, mapplets, sessions and workflows.
• Involved in Unit testing, System testing to check whether the data loads into target are accurate.
• Experience in support and knowledge transfer to the production team.
• Proficient in interaction with the clients in Requirements Analysis phase.
• Experience in Developing Repository (RPD) using Admin tool (i.e.) Physical layer, BMM layer and Presentation layer.
• Experience in RPD Security Development.
• Experience in pulling session logs and debugging the RPD defects.
• Experience in basic Report buildings, Dashboards etc.
• Identified and debugged the errors in RPD before deploying and moved RPD from DEV to QA and QA to Production.
• Involved in moving Web Catalog from DEV to QA, QA to PROD.
• Involved in Unit testing, System testing to check if the reports are behaving correctly and fixing the same.
• Attended complete training sessions on OBIEE 11g and Informatica 8.1.
• Excellent analytical/ communication skills and good team player.

Technical Skills:

Database Tools: Siebel Analytics, OBIEE, Informatica, Siebel CRM, DAC

Reporting Tools: OBIEE

Documentation Tools: MS Office

Languages: Java, C, C++, UNIX, DBMS,SQL, PL/SQL

Operating Systems: Windows Platform

Databases: Oracle 9i, Oracle 10g, Oracle 11g, OLAP, OLTP

Education:

Bachelor of Engineering

Professional Experience:

Confidential,USA Jan’-12 –Oct’12
Informatica and OBIEE Developer
Analysis Dashboard was intended to be a guide to help health plans proactively identify and target members with CV disease, Obesity, Hypercholesterolemia, Hypertension, CHF, and Type 2 diabetes. It was designed to help customers identify the subpopulations who stand to obtain the most benefit from interventions.
Responsibilities

• Participated in User meetings, gathering requirements, discussing the issues to be resolved.
• Preparation of Functional Design documents.
• Development tasks for Analytics, ETL.
• Identify Source tables (OLTP) and Target tables (OLAP) for Data mapping.
• Integration of Siebel CRM Database with OBIEE Database.
• Participate in Design Reviews of Data model and Informatica mapping design.
• Assisted in creating Logical and Physical data modeling.
• Worked on Mapping designer, workflow designer, workflow monitor etc. of Informatica.
• Development of mappings workflows and session tasks using Informatica Power Center.
• Examining the session logs if the workflows fail and fixing up the defect.
• Debugging mappings using Debugger tool in Designer.
• Participated in testing Data matching between Siebel and OBIEE Databases and Dashboards.
• Worked on transformations like Lookup, Sequence Generator, Filter, Expression, Source Qualifier, Router Update Strategy etc.
• Involved in Data loading to staging tables and from staging tables to Target tables i.e. Data loading from Siebel (source) to OBIEE (target) Database.
• Involved in RPD development using Admin tool to build Physical layer, BMM layer and presentation layer.
• Identified joins, tables, Dimensions, Facts, Aggregates, and Measures etc.
• Unit testing the reports, debugging and fixing the errors for Right reports.
• End to End testing of Reports for data and functional behavior.
• Providing support and fixing issues related to Data on Reports, Dashboards etc.
• Provided RPD support to manage the Reports and Dashboards.
• Worked using Oracle SQL.
• Monitoring Daily ETL data load in DAC.
• Involved in Moving the RPD from DEV to QA, QA to PROD. Also, involved in moving the Web Catalog used for Reporting from DEV to QA and QA to PROD.
• Involved in Informatica Mappings migration from DEV to QA, QA to Prod.

Environments: Informatica 7.7.212, OBIEE 10g, Siebel CRM 7.8, DAC 7.7.1, Toad, OLAP,OLTP
Windows XP

Confidential,USA Feb’ 10 – Dec’ 11
Informatica and OBIEE Developer
Nestle Health Care Nutrition uses Siebel Analytics (Pharma) as their reporting tool, to track their Sampling Promotional activities; training provided for their products. The application is also used for employee status reporting like time-off territory and synchronization activities.
Responsibilities

• Participated in User meetings, requirements gathering, discussing the issues to be resolved.
• Translating user inputs into ETL and Siebel Analytics design docs.
• Requirement gathering from business users
• Participating in peer reviews and knowledge transition for new members.
• Development tasks for OBIEE, ETL and DAC.
• Co-ordinated offshore ETL and OBIEE team with onsite team.
• Prepared Source Target Data mapping and documentation.
• Participate in Design Reviews of Data model and Informatica mapping design.
• Loading of Data from Siebel CRM to Siebel Analytics Database.
• Assisted in creating Logical and Physical data modeling.
• Performed Data Analysis and Data matching between Siebel CRM and Siebel OBIEE Database.
• Developed Logical and Physical Data Model using Star Schema to build the Repository.
• Developed mappings, sessions and workflows in Informatica Power Center.
• Design and deploy ETL job workflows with exemption handling and reporting strategy.
• Unit tested the mapping logic for correctness.
• Utilized the Debugger utility to test the mappings.
• Provided support for the implemented code for defects and enhancements.
• Using Workflow Manager, Server Manager for creating, validating, Testing and running the Batches and Sessions.
• Used DAC for running and monitoring the daily scheduled loads.
• Worked on all the transformations like Filter, Aggregator, Expression, Router, Lookup, Update Strategy, Sequence Generator, Rank, Union, Joiner, Source Qualifier, etc.
• Developed number of Informatica Mappings, Mapplets and Reusable Transformations for loading of data.
• Used Informatica Workflow Manager for creating, running the Workflows and Sessions.
• Worked on Data Extraction, Data Transformations, Data Loading, Data Conversions and Data Analysis,
• Worked with Oracle SQl.
• Used different transformations for Extraction/transformation and loading data into staging areas and Presentation Tables.
• Worked with workflow manager and workflow monitor to run the workflow and monitor session logs.
• Involved in RPD development using Admin tool to build Physical layer, BMM layer and presentation layer.
• Identified joins, tables, Dimensions, Facts, Aggregates, and Measures etc.
• Worked on Security Implementation using RPD.
• Built few basic reports and Dashboards for Reporting.
• Examined Session logs, identified errors and debugged.
• Unit testing the reports, debugging and fixing the errors for Right reports.
• Involved in Moving the RPD from DEV to QA, QA to PROD. Also, involved in moving the Web Catalog used for Reporting from DEV to QA and QA to PROD.
• Participated in integration of Siebel CRM screen to Siebel Analytics Dashboards.

Environments: Informatica 7.7.212, OBIEE 10g, Siebel CRM 7.8, DAC 7.7.1, Toad, Windows XP, OLAP, OLTP

Confidential,USA Nov’ 09 – Jan’10
OBIEE Tester
The objective of this initiative is to provide the organization with a timely and standardized analytical view of sales in order to better forecast sales membership, manage the sales force, and improve Health Net business. Oracle Business Intelligence (OBI) has been determined as the right tool for enterprise sales analytics.
Responsibilities

• Preparation of test scripts and testing the same.
• Security testing was carried out for various logins (i.e.) different positions in the hierarchy to ensure data integrity.
• Performance testing was carried out to check if links, drilldowns, prompts etc. open within the specified time as indicated.
• Editing the queries and execution of the same in Toad.
• Have been involved in understanding new change requirements and development of test cases for the same.

Environments : OBIEE 10g,Toad,MS Excel, Windows XP

Confidential,USA Jun’ 08 – Jul’09
Siebel Analytics Tester
SimplifyMD acts as a middle layer between hospitals, laboratories. SimplifyMD provides a modern platform that picks the health records of patients added by the facility and seamlessly updates them.
Responsibilities

• Developed the manualtest casesbased on thetest scenarios.
• Assisted in developing theSQL queries to run and test them in toad.
• Tested the behavior of Dashboards and reports.
• PerformedDB testingon the linked SQL database.
• Thetest caseswere executed and results logged inMS excel.

Environments: Siebel Analytics, Siebel, Toad, Windows XP