JHANSI RAVIRALA

Phone: 617-***-****

_____________________________________________________________________________________

PROFESSIONAL EXPERIENCE

* ***** ** ** ********** involving Analysis, Design, Development and Implementation using standard SDLC methodologies.

Core competencies include design and development of OBIEE repositories (Framework Model), and building OBIEE Dashboards/Reports, Development of DAC, BI APPS and Informatica.

Expertise in building Repositories, developing Subject Areas, and applying Security at object and data level in Administration Tool

Strengths include Seibel Analytics development and Administration, attention to detail and problem solving

Expert in creation and customization of repository using Siebel Analytics Administration Tool.

Expertise in analyzing and designing customized analytical reports and creating Interactive Dashboards with drill-down capabilities using OBIEE

Expertise in creating complex reports in Answers using various views

Extensive experience in creating iBots and scheduling them using delivers

Involved in merging applications from Dev - Test – Prod for deployment.

Designing the report layout templates in the BI Publisher

Hands on experience in configuring and developing the Analytics/OBIEE Repository (.rpd),which involves Schema Import, Implementing the Business Logic by customization, Dimensional Hierarchies, Aggregate Navigation, Level Based Measures, Security Management (Data level/Object level security), Variables, Initialization blocks, Cache Management, Utilities, and Subject Areas.

Developed new subject areas in the RPD per business requirements

Expertise in creating Object Level Security and Row Level Security at the repository level

Extremely strong in OBIEE Metadata development

Significant experience in how to pass parameters between Map viewer and a Dashboard Prompt

Expertise in OBIEE DAC configuration

Experience in Oracle BI Apps that include OBIEE/Siebel Analytics, ETL Tools and DAC in Financial ( AP, AR, GL, FA modules), Pharmaceutical and Sales & Marketing domains.

Expert in working with OBI administration tool developing metadata repository consisting of three layers (Physical Layer, Business Model & Presentation Layer)

Strong understanding of data modeling and dimensional modeling, and designing Kimball’s Star and Snowflake schemas

Expertise in Report Bursting using BI Publisher

Develops, executes, and manages Customer Relationship Management (CRM) marketing activities in an organization, including e-marketing programs and strategies, campaign management, and analytics.

Good at understanding business requirements and translating them into data warehouse dimensional modeling

Significant experience with ETL methodology for supporting data extraction, transformations and loading processing, in a corporate-wide-ETL Solution.

Has got significant experience in oracle EBS

Significant in developing and testing ETL solutions using Informatica Power Center and Expertise in analyzing business issues and providing possible reporting solutions to end users

Expertise in providing end-to-end user training and support and provided detail documentation

Excellent analytical, problem solving skills and a motivated team player with an excellent inter-personal skills and familiar with offshore and multi site development

TECHNICAL SKILLS

BI Tools: OBIEE 11.1.1.5, 10.1.3.x, Siebel Analytics 7.5/7.7/7.8, Oracle BI Apps (HR & Financial Analytics)

ETL: Informatica Power Center 8.1/7.1.4/7.1.1, Oracle Warehouse Builder (OWB), Scheduling – DAC 10.1.3.4

Databases: Oracle9i/10g/11g, MS SQL Server 2008

Programming Languages: PL/SQL and SQL

Tools & Utilities: SQL Developer, SQL*Plus, TOAD, MS Office

PROFESSIONAL EXPERIENCE

Client: Commonwealth Of Mass OBIEE Lead

Boston, MA June 2011 – Till date

Responsibilities

Developed OBIEE Repository as per user requirements and available information in Data Warehouse.

Installed and configured of Oracle BI 11g on Windows.

Analyzed and validated the business model in OBIEE Administration Tool by performing consistency check, validating logical source tables, logical columns, and also validating repository level calculations done in the business model layer.

Different levels of Security set-up for the entities of the application (on both Repository file and Web catalog file)

Worked closely with BA Team to understand the Business Requirements.

Data Model Design and Documentation (Facts and Dimensions, Business Users & Security Permissions, Stars with Hierarchies, Business Model Names for Source Columns, Reports and Dashboard Layouts)

OBIEE meta-data development. Configure repository on all the three layers (Physical Layer, Business Logic and Mapping Layer and Presentation Layer)

Prepared SRS documentation, Detail Report Documentation

Environment: OBIEE 11.1.1.5/11.1.1.3, OWB, Oracle 11g, BI Publisher

Client: Dassault Systems – Solid Works OBIEE Developer

Concord , MA Sep 2010 – May 2011

Dassault Systems - SolidWorks Corp. is a world leader in 3D solutions that help millions of engineers and designers succeed through innovation.Solidworks products deliver an intuitive experience in product deign, simulation, publishing, data management, and environmental impact assessment.

SolidWorks choose Oracle BI application and Siebel Analytics to generate Business Reports. SolidWorks uses OBIEE Sales & Marketing Analytics application for supporting SolidWorks Marketing people with business needs by generating Business reports using OBIEE. SolidWroks MIS Team uses OBIEE to provide role based Dashboards, Guided Navigation

Responsibilities

Developed OBIEE Repository as per user requirements and available information in Data Warehouse.

Installation and configuration of Oracle BI on Windows.

Analyzed and validated the business model in OBIEE Administration Tool by performing consistency check, validating logical source tables, logical columns, and also validating repository level calculations done in the business model layer.

Different levels of Security set-up for the entities of the application (on both Repository file and Web catalog file)

Designed Test Plans, Test Cases and Test Procedures.

Developed and Debugged Interactive Dashboards and Reports relating to Customer Feedback Analytics, with different Analytic Views (Guided Navigation, Pivot Table, Chart, View Selector, Column Selector, Filters, and Dashboard Prompts) using Presentation Services.

Implemented Object Level Security for the objects like Dashboards, Reports, and Data Level Security for Region and Product dimensions using Session Variables.

Used java script to customize the dashboard look and feel.

Worked closely with BA Team to understand the Business Requirements.

Configured navigational links and drills while creating Dashboards.

OBIEE meta-data development. Configure repository on all the three layers (Physical Layer, Business Logic and Mapping Layer and Presentation Layer)

Data Model Design and Documentation (Facts and Dimensions, Business Users & Security Permissions, Stars with Hierarchies, Business Model Names for Source Columns, Reports and Dashboard Layouts)

OBIEE meta-data development. Configure repository on all the three layers (Physical Layer, Business Logic and Mapping Layer and Presentation Layer)

Involved in migration for OBIEE components into various test, UAT and production environments.

Environment: OBIEE 10.1.3.4.1/10.1.3.4, Informatica Power Center 8.1, Oracle 10g, Oracle BI Apps, DAC

Client: Wellington Management LLP OBIEE Consultant

Boston, MA June 2009 – Aug 2010

Global Performance Standards:

Description: The GPS team currently uses an OBIEE tool to generate reports for composites and products. These reports allow the analysts to review the performance (returns) and membership for a given time period. After reviewing the reports, a manual sign-off process is used to indicate that the composites and products have been reviewed. This specification details the requirements for a new tool that will allow the users to generate the reports on-line, review the information and then sign-off on the data.

Responsibilities

Create and modify Business Intelligence requests using Oracle Business Intelligence Answers

Create and modify Interactive Dashboards

Create guided navigation links within Interactive Dashboards

Use Oracle Business Intelligence Delivers to configure, schedule, and deliver personalized alerts to Interactive Dashboards by using iBots

Perform administrative tasks related to the development and configuration of Interactive Dashboards

Customize the Oracle Business Intelligence Presentation Services interface

Interacted with Client Services Management business representatives for gathering the Reports / Dashboards requirements and to define business and functional specifications

Worked on MS Office Plug-in

Data Model Design and Documentation (Facts and Dimensions, Business Users & Security Permissions, Stars with Hierarchies, Business Model Names for Source Columns, Reports and Dashboard Layouts)

OBIEE meta-data development. Configure repository on all the three layers (Physical Layer, Business Logic and Mapping Layer and Presentation Layer)

Configured LDAP / Single Sign-on / in OBIEE

Set up Usage tracking and Scheduler in OBIEE.

Database Report Layouts Using BI Publisher Desktop (Template Builder) in MS Word

Integrating OBIEE and BI Publisher and Scheduling BI Publisher reports

Creating BI publisher reports based on various data sources

Different levels of Security set-up for the entities of the application (on both Repository file and Web catalog file)

Developed and Debugged Interactive Dashboards and Reports relating to Customer Feedback Analytics, with different Analytic Views (Guided Navigation, Pivot Table, Chart, View Selector, Column Selector, Filters, and Dashboard Prompts) using Presentation Services.

Implemented Object Level Security for the objects like Dashboards and Reports, and Data Level Security for Region and Product dimensions, using Session Variables.

Developed Performance Tuning Strategies, for optimized performance, by implementing Aggregate Navigation, Cache Management, re-organizing data, and making some changes to Reports.

Developed and Integration Testing, and User Acceptance Testing (UAT), to validate reports, and played an active role in product rollouts.

Created comprehensive and easy-to-understand Oracle Answers & Dashboards User Guide, and provided intensive Training to business users and Implemented Usage Tracking Reports.

Environment: OBIEE 10.1.3.4, Informatica 8.1, Oracle 10g, TOAD, Oracle BI Applications,

BI Publisher, DAC

Client: Group DCA OBIEE Consultant

Parisippany, NJ October 2008 – April 2009

Group DCA is a multichannel, pharmacy research company that specializes in Brand Promotional programs, e.g., e Detailing (online & convention-based), brand analysis, Patient education, adherence, and persistency programs leveraging the strengths of Internet, multimedia, tablet PCs, dimensional direct mail, and proprietary software to allow clients to better understand the needs and opinions of their audiences and, in turn, to market their brands more effectively.

Involved in modeling, designing, developing and implementing the conceptual, logical & physical design of the data model using dimensional modeling techniques to support diverse business requirements in the area of Interaction metrics, e Detail summary Stats and Alerts & notification. ETL (Extract, Transform & Load) transformations (SDE & SIL) were built using Informatica Power Center 8.11 as ETL tool. Multiple aggregate tables were built at data mart level to meet less than 15 sec reports rendering requirement.

Responsibilities

Having pharmaceutical research experience

Data Model Design and Documentation (Facts and Dimensions, Business Users & Security

Permissions, Stars with Hierarchies, Business Model Names for Source Columns, Reports and Dashboard Layouts)

OBIEE meta-data development. Configure repository on all the three layers (Physical Layer, Business Logic and Mapping Layer and Presentation Layer)

Interacted with Client Services Management business representatives for gathering the Reports / Dashboards requirements and to define business and functional specifications

Configured LDAP / Single Sign-on in OBIEE

Set up Usage tracking and Scheduler in OBIEE.

Created Usage Tracking Reports.

Integrating OBIEE and BI Publisher.

Developed and Debugged Interactive Dashboards and Reports relating to Customer

Feedback Analytics, with different Analytic Views (Guided Navigation, Pivot Table, Chart, View Selector, Column Selector, Filters, and Dashboard Prompts) using Presentation Services.

Performed Unit Testing, Integration Testing, and User Acceptance Testing (UAT), to validate reports, and played an active role in product rollouts

Environment: OBIEE 10.1.3.3, Informatica Power Center 7.1.4, Oracle 10g

Client: LMS (Loyalty Management System) Cognos Developer

Bangalore, India February 2006 – August 2008

The Loyalty Technology is a flexible, modular, secure and scalable system for deploying and operating a coalition loyalty program for use by the bank and its partners/customers to enhance their relationship with their customers. Loyalty program, in this sense, provide ways for customers to earn points (designated by some currency: e.g. points) and to redeem those points for some benefit. The design intent for the Loyalty Technology has to ensure that the platform can operate in an enterprise-computing environment and can integrate with existing processes and CRM systems.

Responsibilities

Work with Business Units to define Business strategy and create a centralized reporting capability for users to perform analytical, and ad-hoc reporting for business applications and provide accurate information available to Decision Makers.

Creating List Reports, Cross-tab Reports, Chart Reports, Repeater reports and Master Detail Reports using Report Studio and simple reports in Query Studio.

Generated various reports List Reports, Grouped Reports, Cross-tab Reports, Chart Reports, and Drill -Through Reports

Developed Prompt pages and Conditional Variables, Creating Query Prompts, Calculations, Conditions & Filters in Cognos 8.

Performed unit Testing of the reports

Provided documentation, training users and Business Partners on Query Studio for ad-hoc Reporting.

Participated while creating the Model in Framework manager, publishing the Model

Created the data sources using Cognos Connection

Importing & Exporting Reports, models using deployment application

Prepared program specification document for reports

Environment: Cognos 8, Cognos Reportnet 1.1 MR2, Informatica 7.1.4, Oracle 9i (SQL, PL/SQL), UNIX, Windows XP and Toad

Client: IHS Energy Cognos Developer

Bangalore, India May 2004 – January 2006

IHS Energy is the global source of oil and gas information, analytical software and consulting services. IHS Energy intends to develop a single, standard System to accumulate oil and gas production data. The system architecture should be flexible enough to accumulate production data for three regions – US, Canada and International.

Responsibilities

Created the Reports using Report Studio

Created filers and prompts using Report Studio

Participated while creating the Model in Framework manager, publishing the Model

Created the data sources using Cognos Connection

Importing & Exporting Reports, models using deployment application

Installation of Cognos report net

Prepared program specification document for reports

Environment: Cognos Reportnet 1.1 MR2, SQL Server, Windows XP, Toad, Citrix and Oracle 9i

(SQL, PL/SQL)

EDUCATION

Bachelor of Engineering (IT)

Contact this candidate