SUMMARY

• Have Six+ years of IT experience which includes analysis, design, development, implementation, deployment and maintenance of Business Intelligence, Data Warehousing applications
• Over 5 Years of experience as OBIEE Developer in Installations, Administration and Developing Oracle Business Intelligence and Siebel Analytics Applications.
• Excellent in implementing the Software Development Life Cycle (SDLC) projects and related documentation as well.
• Excellent Business knowledge in Telecom and Banking domains.
• Extensively worked on various functionalities of Business Intelligence, data warehouses/data Marts and business applications using Ralph Kimball and Bill Inmon methodology.
• Experience interacting directly with the business users to gather and analyze Business and analytical requirements.
• Experience configuring Interactive Dashboards with drill - down capabilities using global and local Filters, Siebel Security Setup (groups, access / query privileges), Metadata Objects and Web Catalog Objects (Dashboard, Pages, Folders, Reports).
• Proficient in designing and configuring the Physical layer, Business Model and Mapping layer, Presentation layer of Meta data Repository (.rpd) using OBIEE Administration tool.
• Excellent in creating/configuring Interactive dashboards with global Prompts and dashboard prompts and reports with different views like table, pivot, column selector, view selector, and filter view etc. using BI Presentation Services.
• Set up Analytics Server Security to control access given to business users
• Hands on experience in creating Requests, Dashboards as well of implementing Map View in OBIEE 11g.
• Map Building using map viewer on POC basis.
• Experience of OBIEE 11g with its Architecture and new features which includes new dimensional Hierarchal models (Ragged & Skipped hierarchies), and new time-series functions (Periodic Rolling and Aggregate At)
• Experience of implementing security in OBIEE 11g by authorizing different users using Application roles and policies/permissions groups.
• Experience of pre-deployment activities like RPD and Webcat merging after development, as well as preparing deployment process documentation
• Experience of implementing different features of OBIEE like
• Usage Tracking Implementation
• Caching using event polling technology
• Programmatically Caching
• OBIEE Clustering
• Experience in performing ETL operations using Informatica Power Centre tools like Repository Manager, Ware house Designer, Workflow Manager, and Workflow Monitor.
• Experience of developing and deploying maps using Oracle Warehouse Builder tool.
• Experience in DAC to configure, monitor and schedule ETL routines.
• Experience in Implementing QA, Generating test scripts and Writing Test Case
• Quick learner with respect to new technologies, best practices and techniques.
• Excellent communication, interpersonal, written, analytical and problem solving skills.
• Effective Team Player and an individual contributor with steep learning curve.

TECHNICAL SKILLS

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

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

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

Languages: SQL, PL/SQL

Web Technologies: HTML / HTML DB, XML, Java Script

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, NYC

OBIEE Engineer

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.
• Design and configure the Meta data repository (RPD) by importing the essential data from OLAP source into the physical layer of repository.
• Involve in complete development of repository at three layers i.e., Physical, Business model and Mapping and presentation layer by implementing the business logic.
• Define complex joins, created Dimensional Hierarchies and developed key metrics in BMM 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.
• Deploy repository & webcat in different environments (ST,UAT,RT)
• Monitor ETL routines through DAC and resolve issues in case of any failure.
• Perform ETL operations using Informatica Power Centre tools like Repository Manager, Ware house Designer, Workflow Manager, and Workflow Monitor
• Develop and enhance mappings using ware house designer of Informatica.
• Create new ETL routine using DAC if required.

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 by implementing the business logic.
• Develop complex joins, created Dimensional Hierarchies and key metrics 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
• Map Building using map viewer.
• Implement new dimensional hierarchy models (Ragged & Skipped hierarchies)
• Present implementations to business team
• Mentor junior team members and guide them for application development process.

Environment: OBIEE 11g, Oracle 10g, Toad 9.6, Oracle Warehouse Builder, Windows server 2005, UNIX.

Confidential

OBIEE Consultant

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.
• Develop complex joins, created Dimensional Hierarchies and key metrics in BMM layer.
• 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.
• Explain BRD & report design document to other team members.
• 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 demos for the 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 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

Responsibilities:

• Gather requirements and preparing 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.
• Develop complex joins; create Dimensional Hierarchies and key metrics in BMM layer.
• Configure the BMM layer with logical tables, Hierarchies (drill downs), Key measures, aggregates and presentation layer with catalog folders.
• Create measures and Level-based measures 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.
• Implement the 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
• For better performance implement caching by using event polling functionality
• Configure event polling table in physical layer of repository
• Execute event polling utility from OBIEE Administration tool.
• Develop database trigger to capture data modifications.
• 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 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 tree structure in presentation layer.
• 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
• Implicate performance tuning on Reports and dashboards, targets, sources, mappings and sessions to ensure maximum efficiency and performance.
• Develop ETL maps using Oracle Warehouse Builder extracting data from different sources like Flat files, Oracle.
• Unit testing of maps and prepare test cases and test scripts
• Familiarize the new business team with the Siebel Analytics features and conducting end to end training for basics of Siebel Analytics (Answers, Dashboards, Prompts elc)
• 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 different calculation measures/metrics in BMM layer of repository.
• Create dimensional hierarchies and level based measure 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 Go URL using java scripts.
• Customize dashboard page using HTML
• Implement data level security for external users using filter option from permissions of repository group.
• Implement the 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
• Conduct Unit testing and preparing test logs.
• 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.

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