Summary

• Solid Years of experience in Siebel Analytics(OBIEE) 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.
• Used Informatica Client tools like Designer, Workflow Manager, Workflow Monitor, 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.
• Experience in Domain Life Science/Pharma
• 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.
• Siebel Analytics.
• 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.
• Excellent analytical/ communication skills and good team player.

Technical Skills

Tools: Siebel Analytics, OBIEE, Informatica, DAC

Operating Systems: Windows Platform

Databases: Oracle 9i,Oracle 10g

Education
Bachelor of Engineering from Confidential.

Professional Experience

Confidential, USA
Client: Confidential, USA Jan’-12 –Sept’12
Informatica and Siebel Analytics 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.
• 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.
• 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.
• 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, Siebel Analytics 7.8.52, DAC 7.7.1, Toad, Windows XP

Confidential 
Client : Confidential, Glendale CA , USA Feb’ 10 – Dec’ 11
Informatica and Siebel Analytics Developer 
Confidential 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, gathering requirements, 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 Analytics, ETL and DAC.
• Co-ordinated offshore ETL and Analytics team with onsite team.
• Participate in Design Reviews of Data model and Informatica mapping design.
• Assisted in creating Logical and Physical data modeling.
• Performed Data Analysis.
• 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.

Environments: Informatica 7.7.212, Siebel Analytics 7.8.52, DAC 7.7.1,Toad, Windows XP

Confidential
Client: ESSA Healthnet, 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
Client: SimplifierMD, 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