SUMMARY

• Have 7 yrs of IT experience which includes analysis, design, development, implementation, deployment and maintenance of Business Intelligence, Data Warehousing applications
• Have 6+ yrs of experience as OBIEE Developer/Consultant with Installations, Administration and development of Oracle Business Intelligence Applications and Siebel Analytics.
• Experience in OLTP/OLAP System, dimensional modeling, star schema
• Proficient in designing and configuring the Physical layer, Business Model and Mapping layer, Presentation layer of Meta data Repository (.rpd) using OBIEE Administration tool.
• Experience configuring Analysis/Interactive Dashboards with drill - down capabilities using global and local Filters, Security Setup (groups, access / query privileges), Metadata Objects and Web Catalog Objects (Dashboard, Pages, Folders, Reports).
• Experience of implementing new features of OBIEE 11g which includes new dimensional Hierarchal models (Ragged & Skipped hierarchies), and new time-series functions (Periodic Rolling and Aggregate At) & Map View.
• Experience of implementing security (Object Level & Data Level) in OBIEE 10g as well as in OBIEE 11g by using Application roles and policies/permissions groups.
• Experience of pre-deployment activities like RPD and Webcat merging, as well as deployment process documentation
• Experience of implementing different features of OBIEE like
• Usage Tracking Implementation
• Caching using event polling technology
• Programmatically Caching
• OBIEE Clustering
• MUD Environment
• Experience of Oracle Supply Chain and Order Management Analytics
• Experience of performing ETL operations using Informatica Power Centre tools like Repository Manager, Ware house Designer, Workflow Manager, and Workflow Monitor.
• Experience in DAC to monitor and schedule ETL routines.

TECHNICAL SKILLS

Business intelligence: Siebel Analytics 7.x, OBIEE 10g/11g, OBIA 7.9.x

ETL: Oracle Warehouse Builder, Informatica Power Center 8.x/9.X

RDBMS: Oracle 11g/10g, DB2 & MS-Access

Languages: SQL, PL/SQL

Web Technologies: HTML / HTML DB

Operating systems: Windows XP/2003/2000, UNIX, Linux

Tools: /Utilities Toad, SQL Developer, MS Office

Version Control: Microsoft Visual Source Safe 2005, SVN Version Control

PROFESSIONAL EXPERIENCE

Confidential, Cambridge MA

OBIEE Lead/Sr.Developer

Responsibilities:

• Interact with business analyst to understand requirements.
• Analyze requirement document and translate them into functional specifications and design specifications.
• Experience of working on Oracle Supply Chain and Order Management Analytics
• Prepare deployment document (Installation Plan and Qualification).
• Design and configure the Meta data repository (RPD) i.e., Physical, Business model and Mapping and Presentation layer.
• Create Dimensional Hierarchies, key metrics, variables & Initialization blocks in RPD.
• Create reports/dashboards with different views (Table, Pivot, Charts)
• Perform testing of Reports/dashboards by comparing the results of SQL queries run against data warehouse to validate the results generated by reports and dashboards.
• Merge and deploy repository and webcat from different environments.
• Create new tables/views in Oracle database.
• Create new and enhance existing mappings/mapplets to accommodate requirements in Informatica.
• Experience of data loading with DAC.

Environment: OBIEE 11.1.1.6.4 , Oracle 10g, Informatica 9.0.1, DAC 10.1.3.4

Confidential, NYC

OBIEE Consultant

Responsibilities:

• Interact with mangers/Executives to define the global reporting requirements for Business Analysis and forecasting.
• Analyze the functional specifications and translated them into technical specifications.
• Experience of working on Oracle Sales Analytics.
• Design and configure the Meta data repository (RPD) i.e., Physical, Business model and Mapping and presentation layer.
• Develop a comprehensive security strategy.
• Create Repository variables (dynamic) and session variables using Initialization blocks.
• Create requests with Tables, Pivots, View Selector, Column Selector and Charts etc.
• Create highly interactive dashboards/dashboard pages with global and local filters (Dashboard Prompts).
• Perform testing of Reports/dashboards by comparing the results of SQL queries run against data warehouse to the results generated by reports and dashboards.
• Actively interact with end users, developers and Administrators to resolve ongoing production issues.
• Merge and deploy repository and webcat from different environments (ST,UAT,RT) (windows & Unix)
• Monitor ETL routines through DAC and resolve issues in case of any failure.
• Develop and enhance mappings using ware house designer of Informatica.
• Handling DAC ETL schedule failure in development, QA & production environment.

Environment: OBIEE 10g, Informatica, DAC, DB2, Windows server 2008, UNIX, Siebel CRM 8.1.1.3

Confidential

Module Lead

Responsibilities:

• Attend face to face workshops with clients to understand and analyze existing reporting system
• Capture the requirements and prepare Business Requirement Documents
• Supervise team meetings and explain the Business requirements to the teams at multiple geographical locations (UK and India).
• Implement the business requirements using latest functionalities of OBIEE 11g on POC basis.
• Involvement in complete development of repository at three layers i.e., Physical, Business model and Mapping and presentation layer.
• Create Dimensional Hierarchies and measures in BMM layer.
• Hands on experience in creating Requests, Dashboards as well of implementing Map View in OBIEE 11g.
• Analyze and import Spatial Data in database with the help DBA
• Merge and deploy repository and webcat from different environments (ST,UAT,RT) (windows & Unix)
• Map Building using map viewer.
• Deploying repository and webcat through Admin Console.
• Experience of OBIA Telecom Analytics.

Environment: OBIEE 11g, Oracle 10g, Toad 9.6, Informatica 8, OBIA 7.x, Windows server 2005, UNIX.

Confidential

OBIEE Consultant & Administrator

Responsibilities:

• Gather requirements and prepare Business Requirement Documents & design document
• Present design to Business team and getting sign-off
• Involvement in complete development of repository at three layers i.e., Physical, Business model and Mapping and presentation layer by implementing the business logic.
• Create measures and Level-based measures using expression builder.
• Implement tree structure in presentation layer of repository.
• Design reports as per requirements with different analytical views.
• Review developed OBIEE interactive dashboards and reports.
• Perform testing of Reports/dashboards by comparing the results of SQL queries run against data warehouse to the results generated by reports and dashboards
• Create users and groups for Authentication and Authorization.
• Perform Code review in order to maintain BT and OBI coding standards.
• Provide User Acceptance Testing (UAT) Support; analyze and resolve UAT issues.
• Prepare deployment documents and release note prior to releasing the applications to production environments.
• Manage cache (seeding & purging) in QA environment.

Environment: Siebel Analytics 7.8.5, Oracle Warehouse Builder, Oracle 9i, Toad, Windows 2005

Confidential

OBIEE Designer

Responsibilities:

• Involvement in complete development of repository at three layers i.e., Physical, Business model and Mapping and presentation layer
• Create Hierarchies, Key measures, Level based measures
• Create measures and using expression builder.
• Develop custom reports using different report features like Pivot, table, and View selector with global and local filters.
• Design intelligent Dashboards by integrating several reports to ensure easy navigation of reports.
• Create Users/Groups for Authentication & Authorization.
• Implement caching by using event polling functionality
• Present developed reports and dashboards to business team
• Provide User Acceptance Testing (UAT) Support; analyze and resolve UAT issues.
• Prepare deployment documents and release note prior to releasing the applications to production environments.
• Merge & Deploy RPD and Webcat in SIT and UAT environments.

Environment: Siebel Analytics 7.8.5, Oracle Warehouse Builder, Oracle 9i, Toad, Windows 2005

Confidential

OBIEE Designer/Developer

Responsibilities:

• Involvement in gathering the business requirements and reporting needs.
• Understand existing systems developed with different technologies like Oracle Discoverer and BO
• Implement data model based on star schema as well considering adhoc reporting requirement.
• Configure the Physical layer (imported schemas), BMM layer (logical tables and data source mappings) and Presentation layer (presentation catalogs) of repository using Siebel Analytics Administration tool.
• Create different calculation measures/metrics in BMM layer of repository.
• Extensively worked on Siebel Answers to create Dashboards/pages with embedded content and custom reports as per end user requirements.
• Implement permissions and security using Repository Authentication.
• Perform testing of Reports/dashboards by comparing the results of SQL queries run against data warehouse to the results generated by reports and dashboards.
• Develop ETL maps using Oracle Warehouse Builder extracting data from different sources like Flat files, Oracle.
• Assist business team to develop adhoc reports using Siebel Analytics.

Environment: Siebel Analytics 7.8.5, Oracle Warehouse Builder, Oracle 9i, Toad, Windows 2005.

Confidential

OBIEE Developer

Responsibilities:

• Involvement in gathering business requirements and reporting needs.
• Configure the Physical layer (imported schemas), BMM layer (logical tables and data source mappings) and Presentation layer (presentation catalogs) of repository using Siebel Analytics Administration tool.
• Create calculation measures/metrics, dimensional hierarchies & level based measures in BMM layer of repository.
• Extensively worked on Siebel Answers to create Dashboards/pages with embedded content and custom reports as per end user requirements.
• Implement data level security for external users using filter option from permissions of repository group.
• Perform testing of Reports/dashboards by comparing the results of SQL queries run against data warehouse to the results generated by reports and dashboards
• Develop ETL maps using Oracle Warehouse Builder extracting data from different sources like Flat files, Oracle.
• Unit testing of maps and preparing test cases and test scripts.
• Deploy RPD and webcat in QA environment.

Environment: Siebel Analytics 7.8.5, Oracle Warehouse Builder, Oracle 9i, Toad, Windows 2005.