Professional Summary:

• Over 7 years of experience in Analyzing complex business requirements, designing, implementation and management of BI reporting requirements.
• Over Seven years of experience in providing Business Intelligence and OLAP solutions to Financial, Pharmaceutical, Insurance, and Telecom sectors.
• Experience in developing applications using different versions of Business Intelligence BI Tools and Data Warehousing Environment.
• Extensive experience on OBIEE 10.1.3.4, OBIEE 11.1.1.7, Siebel Analytics 7.8.4 Applications.
• Expertise in OLTP/OLAP system study, analysis, E-R modeling and developing Database schemas like Star Schema/Snowflake Schema.
• Experience in developing all the layers physical layer, business model and mapping or logical layer and presentation layer of the OBIEE repository.
• Experience in developing Reports / Dashboards with different Analytics Views Drill-Down / Dynamic, Pivot Table, Chart, Column Selector, Tabular with global and local Filters using OBIEE
• Hands on experience in setting External Table Authentication in OBIEE.
• Implemented and extensively worked in Multi User Development MUDE and performed some administration tasks such as Creating users, groups, Projects and provide required authentication as needed.
• Expertise in implementing Security Models for Dashboards, Row level, object Level, Role Level
• Expertise in Creating Dynamic Dashboards and Reports using Prompts, Filters, Calculations, Conditional Formatting and Drill down Properties.
• Experience in Interactive Dashboards with drill-down capabilities using global local Filters, Security Setup groups, access/query/report privileges .
• Good experience in UNIX and writing shell scripts for execution of the work flows and scheduling the tasks.
• Responsible for Unit, System and Integration Testing and Performed Data Validation for all the ETL's and reports that are generated from Informatica and OBIEE.
• Expertise in Data Warehousing development using ETL tools such as Informatica Power Center
• Extensively used the four basic Informatica Power Center tools - Repository Manager, Designer, Workflow Manager and Workflow Monitor.
• Working knowledge of developing various applications using .Net languages and Java.
• Effective Communication skills, Extrovert, and Versatile to work in team or Individual.
• Analytical and logical skills with ability to follow project standards and procedures as per client specifications.

Technical Skills:

Technology/Tools : OBIEE 11g/10g, Siebel Analytics 7, Informatica Power Center 8/9, SSIS Language : SQL, PL/SQL, C, Java, C RDBMS : Oracle 11g/10g/9i, SQL Server 2005/2008 DB Tools and Utilities : TOAD, Oracle SQL Developer, SQL Management Studio Operating Systems : Windows 7/8, Windows XP, Windows NT/95/98/2K, UNIX

Professional Experience:

Confidential

Role: Sr. OBIEE Developer

Responsibilities:

• Analyzed the specifications provided by the clients and Developed specification documents for Reports as per the client requirement.
• Developed custom reports using OBIEE Answers and assigned them to application specific dashboards.
• Developed many Reports / Dashboards with different Analytics Views Drill-Down / Dynamic, Pivot Table, Chart, Column Selector, Tabular with global and local Filters
• Addedusers to the new group and applied the data level and object level security at the repository and Web catalog
• Involved in managing appropriate security privileges on subject areas and dashboards according to business requirements
• Implemented external table authentication using session variables and validate using OBIEE Admin tool.
• Involved in creating, maintaining and managing repositories.
• Worked with business partners to design and maintain BI solutions.
• Configured the BI Delivers scheduler to schedule the daily reports.
• Maintaining the Full and Incremental loads through DAC on different environments like Development, test and production environment.
• Involved in developing the Incremental ETL process by Informatica Mappings Mapplets using various Transformations.
• Worked on transformations like Source Qualifier, Expression, Filter, Lookup, Router, Aggregator and normalizer transformation
• Developed and established the standards and checklists for report development.
• Involved in making changes in the reports generated as business requirements changed and moved to validation and verification of the reports.
• Prepared test plans for the reports and documented the test results.

Environment: OBIEE 11, Oracle 11g, TOAD, Informatica 8.1.1/8.6.1, Windows 2008 server, UNIX, PL/SQL, SQL Server 2005/2008

Confidential

Role: Sr. OBIEE Developer

Responsibilities:

• Involved in business requirement gathering, understanding business objectives and analysis.
• Designed and developed RPD models physical layer, business mapping layer, and presentation layer to support defined reporting requirements and ad hoc requirements.
• Developed many Reports / Dashboards with different Analytics Views Drill-Down / Dynamic, Pivot Table, Chart, Column Selector, Tabular with global and local Filters
• Designed and developed dashboards, reports and alerts.
• Used Filters Global and Local and provided customized prompts to avoid excessive data showing up in the reports.
• Involved in creating reports using OBIEE Answers using forced selection prompts, OBIEE XML editing, common go button for multiple prompts, guided navigation ,GO URL and many other features.
• Exploration of Administration in weblogic11g OBIEE Enterprise Manager.
• Enhancement and customization of the existing reports as per the user specifications.
• Used Parent-child functionality hierarchy for different reports.
• Implement data level security permissions/privileges as per role of each user.
• Involved in design and development of data modeling using ETL tool.
• Developed the data model by using Informatica ETL tool.
• Used various transformations in Informatica to extract the data from different data sources.
• Created Unit test case scenarios and also assisted testing team for development of test cases and test execution.

Environment: OBIEE 10, Oracle 10g, Oracle SQL Developer, Informatica7, Windows 2003 server, UNIX, PL/SQL, SQL Server 2005

Confidential

Role: OBIEE Developer

Responsibilities:

• Involved in the full life cycle implementation of Annualized premium application associated with policy details and claims.
• Involved in preparation of technical documents and end user training.
• Interacted with Business Analysts and Key Business Users in gathering the Analytics / Reports Requirements.
• Participated in the installation and configuration of Oracle BI EE 10.x in the windows
• Developed the repository model for the different work streams with the necessary logic that involved creating the Physical, BMM and the Presentation layer. Also created hierarchies, variables, and event poll strategies in the repository.
• Developed Dashboards / Reports using different Views Pivot Table, Chart and Column Selector , with drill-down and drill across capabilities, guided navigation and dashboard and page prompts.
• Created dimension hierarchies aggregates and logical sources in the BMM layer.
• Configured the security settings in Analytics Admin tool to setup users Groups and Access privileges.
• Involved in Reconciliation Process Oracle BI Reports output with Excel Reports.
• Developed many Reports / Dashboards with different Analytics Views Drill-Down / Dynamic, Pivot Table, Chart, Column Selector, Tabular with global and local Filters
• Worked with ETL Team for enhancement to Facts / Dimensions in developing the Initial and Incremental ETL process.

Environment: Oracle Business Intelligence OBI EE 10.x, Oracle 9i, Windows 2000,Powermart.

Confidential

Role: OBIEE Developer

Responsibilities:

• Investigated and resolved data issues.
• Worked with ETL team for enhancement to facts/dimensions.
• Developed various reports/dashboards using different views.
• Involved in designing logical and physical data models.
• Identified the key facts and dimensions necessary to support the business requirements.
• Involved in translating functional requirements into technical requirements.
• Involved in creating, maintaining and managing repositories.
• Responsible for designing, developing and implementing information based business solutions related to reporting and analysis.
• Involved in Unit testing and regression testing.

Environment:Oracle business Intelligence OBI EE 10, Oracle 8i, Windows NT platform