Ketki Hande

Ph :732-***-**** Sr. OBIEE Consultant

acpaad@r.postjobfree.com

Profile

. 7 Years of IT Experience

. 6 Years of OBIEE /Siebel Analytics Experience

Professional Summary

. Around 7 years of Complete Software development Life cycle (SDLC)

(gathering Business Users Requirements, System Analysis, Design & Data

Modelling, Development, Testing) implementation experience of Data

Warehouse, Data Mart and Business Intelligence using Siebel Analytics/

OBIEE.

. Experience in identifying & analyzing the source/feeder systems,

identifying GAPS and providing appropriate solutions.

. Very strong in OBIEE/Siebel Analytics Admin Tool, Analytics Web,

Presentation Services and Delivers .

. Expertise in developing Oracle BI/Siebel Analytics Repository

consisting of three layers (Physical Layer, Business Model &

Presentation Layer.

. Good in validating the BI reports/dashboards by preparing the Test

Plans & Cases.

. Expertise in providing end-to-end business intelligence solution by

dimensional modeling design, building business models, configuring

metadata, Answers, Delivers/iBots, creating Interactive Dashboards

with drill-down and drill-across capabilities, Security (groups,

access/query privileges), Web Catalog Objects (Dashboard, Pages,

Folders, Reports), cache monitor, Job Manager, Catalog Manager and

building Repository consisting of three layers (Physical Layer,

Business Model & Presentation Layer) using Oracle BIEE/Siebel

Analytics.

. Expertise in creating Calculation Measures and Dimensions, using

Initialization Blocks and Variables (Session and Repository), creating

aggregate tables, adding multiple sources, executing direct Database

requests, Implementing Siebel Security Setup (groups, object and data

level), LDAP, External Tables, Single sign on etc.

. Experience serving industrial segments like Sales, Marketing, Finance

and Service in business related to implementation of ERP and BI

Solutions.

. Expertise in fine tuning reports by using view selector, column

selector and prompts, where ever necessary to increase performance.

. Expertise in debugging and optimizing the Oracle BI/Siebel Analytics

Dashboards/Reports and Informatica Mappings/Workflows

. Expertise in enhancing performance of Reports / Dashboards by

implementing the Aggregate tables, Materialized Views, Table execution

path by making use of hints, Creation / Re-building of Indexes and

managing Cache etc.

. Involved in implementing prebuilt solutions in converting data from

ERP systems like Siebel CRM into Oracle provided data warehouse.

. Experience in setting up a Multi-User Development Environment (MUDE)

. Hands on experience in developing Informatica Mappings/Mapplets using

various Transformations for Extraction, Transformation and Loading of

data from Multiple Sources to Data Warehouse and creating Workflows

with Worklets & Tasks and scheduling using both Workflow Manager .

. Performance tuning of Oracle BIEE/Siebel Analytics Repository,

Analytics Dashboards/Reports.

. Working Knowledge of Disconnected Analytics and BI Publisher.

. Good in validating the BI reports/dashboards by preparing the Test

Plans & Cases.

. Involved in implementing prebuilt solutions in converting data from

ERP systems like Siebel CRM into Oracle provided data warehouse

. Good knowledge of Versioning Control system like VSS

. Excellent communication skills and experience working with business

users and leads/managers with strong analytical & problem solving

skills and a quick learner of new technologies and concepts.

Organisational Skills

. Team based working

. Time management

. Ability to communicate at all levels within an organization

. Ability to work autonomously and as part of a small project team

. Sound functional background of corporate Marketing & Strategy

Planning.

. Ability to write user requirements, system specifications and test

plans

. Experience working in large, medium and small sized projects

. Goal setting

Education

. Bachelor of Engineering, Rajiv Gandhi Technical University, INDIA

Technical Skills

Siebel Analytics Siebel Analytics 7.x, Siebel CRM7.x

OBIEE OBIEE 10.1.X,, Siebel Analytics 7.8, OBIEE

marketing

Languages/Utilities SQL, PL/SQL, ODBC, TOAD

Databases, Database Oracle 8I/9I/10G, MS SQL Server 2000/2005

Tools

ETL\Data migration Informatica 7.1, 7.1.4 and DAC 10.1.3.3.

Web Servers / Tools Microsoft IIS

BI Tools Business Objects, Quality Stage, Data Stage

Testing Tools Manual Testing

Operating systems Windows 98/NT/XP/2000/2003

Domain Experience

. Telecom

. Finance

. Marketing

Professional Experience

New York State Department, Albany, NY

Senior BI Consultant

Feb15 - Till Date

Project Title : Information Technology Services

Phase : Development

Scope of the Project: New York State Department Business Information Team

is responsible for providing information about Children and People with

Disabilities. Improving the facilities based upon the information obtained

through the statistics.

Responsibilities:

. Participated in gathering and analysing the Business Requirements in

collaboration with the Subject Matter Experts (SMEs), Business

Analysts, Users and base lining the details.

. Developed and customized the OBIEE Metadata repository (.rpd) model by

creating connection pools, physical / Alias Tables, defined joins and

implemented authorizations in the physical layer, aggregates,

dimensions, hierarchies & time series functions in the BMM Layer,

Catalogues & folders in Presentation Layer using Oracle BI

Administration tool.

. Identified the aggregate levels for measures and created dimension

hierarchy sources for each level of aggregates for performance

enhancement.

. Developed and customized executive level dashboards and reports in

various views such as Pivot Table, Charts, View Selectors, Column

Selectors, catering to provide insight into the Sales / Marketing /

Financial data.

. Created different types of Reports (Drilldown, Aggregation, Levels) to

meet business requirements. Generated various Analytics Reports like

Formulary Report, Union Report and Direct Sales Report using global

and local filters.

. Implemented security by creating users & web groups, setting up

External Table Authentication, creating Session Variables and

Initialization Blocks and associating catalogue objects and Web

modules with the created groups.

. Utilized Oracle Delivers for sending real-time, personalized alerts

via intelligence agents (iBots) to subscribed users.

. Created comprehensive and easy-to-understand Documentation of the

complete implementation of the Customer Sales Business modules

(Reports, Dashboards, Security and Star schema).

. Working extensively BI Publisher to create the reports as per the

business requirements.

. Working on BI Aps for merging the existing Data Warehouse with the

OBIA.

. Co-ordinating with the Business Users and the Stakeholders for

bringing up the merge.

. Administered NQSConfig.ini and Instanceconfig.xml configuration files.

. Used PL/SQL procedures and packages to load data in the Data

Warehouse.

. Co-ordinating and working closely with the Client to understand the

business needs.

. Participated in complete life cycle of the project from project

initiation, to development, to production support and maintenance.

. Resolved bugs in production.

. Extensively involved in task allocation and release management

Environment: Oracle Business Intelligence (OBI) EE 11.1.1.x, Oracle 10g,

SQL Developer, MS Windows XP, MS Office Suite

South Jersey Industries, Hammonton, NJ

Senior OBIEE / Siebel Analytics Consultant

Apr14 - Jan '15

Project Title : Street

Phase : Development

Scope of the Project: 'Street' provides Material Failure report to allow

SJG to track their mechanical fitting failures and identify any trends in

order to make business improvement decisions on an annual basis .'Street'

Project provides the listing of retired services by division and city. This

shows the retired number of units and retired number of feet of the asset's

materials,that were installed on retired services.The 'Street' provides

leak survey status information of SJG's mains and services to the Board of

Public Utilities (BPU).

Responsibilities:

. Used the OBIEE 10.1.3.2 Admin tool to develop and enhance metadata

. Built different kinds of sales report by using filters and advanced

filters.

. Creation/customization of star schemas and Business Metrics in RPD as

per customer requirements.

. Development of Subject Area specific to client requirements.

. Work with Physical, Business model and Presentation Layer.

. Developing reports via Oracle Business Intelligence Answers.

. Extensively worked on various types of reports according to the client

requirements.

. Defining hi-level design for new business requirements and also

drafting and building technical portion of the same.

. Implemented Object level security to hide Tables and columns according

to the user responsibilities.

. Monitored the Informatica jobs which will load the data from OLTP to

OLAP.

. Run/Schedule ETL from DAC Client, monitor and trouble shoot complete

ETL log files, DAC email notifications and DAC Server issues.

. Involved in entire life cycle of enhancements that are proposed to the

business.

. Estimation of the work requirements provided by the Business.

. Involved in Unit testing and System testing of the metrics created in

BMM Layer.

. Interacting with client for appropriate requirement specifications.

Environment: OBIEE Platform 10.1.3.2, OBI Apps 7.9, Oracle 10.1.2.0.2, and

Windows 2000

Child Maintenance Group, Leeds, United Kingdom

Senior OBIEE / Siebel Analytics Consultant

Apr12 -

Mar14

Project Title : Business Information and Case Closure

Phase : Development

Scope of the Project: Child Maintenance & Group is the Commission set by

the Government of United Kingdom for maintaining the rights and benefits of

children living in separated or single families. As an OBIEE developer, I

worked on the core data for the individual customers and also created

Campaigns using OBIEE Marketing.

It work with every client to research, analyze and interpret the business

of Information Technology.

Responsibilities:

. Participated in gathering and analyzing the Business Requirements in

collaboration with the Sales, Marketing and Finance Subject Matter

Experts (SMEs), Business Analysts, Users and base lining the details.

. Developed and customized the Oracle BIEE Metadata repository (.rpd)

model by creating connection pools, physical / Alias Tables, defined

joins and implemented authorizations in the physical layer,

aggregates, dimensions, hierarchies & time series functions in the BMM

Layer, catalogs & folders in Presentation Layer using Oracle BI

Administration tool.

. Identified the aggregate levels for measures and created dimension

hierarchy sources for each level of aggregates for performance

enhancement.

. Developed and customized executive level dashboards and reports in

various views such as Pivot Table, Charts, View Selectors, Column

Selectors, catering to provide insight into the Sales / Marketing /

Financial data.

. Created different types of Reports (Drilldown, Aggregation, Levels) to

meet business requirements. Generated various Analytics Reports like

Formulary Report, Union Report and Direct Sales Report using global

and local filters.

. Implemented security by creating users & web groups, setting up

External Table Authentication, creating Session Variables and

Initialization Blocks and associating catalog objects and Web modules

with the created groups.

. Utilized Oracle Delivers for sending real-time, personalized alerts

via intelligence agents (iBots) to subscribed users.

. Performed Performance Tuning of Dashboards / Reports by aggregate

navigation, cache management, Oracle materialized views and making

changes to reports.

. Integrated OBIEE Presentation Layer with BI Publisher and provided the

capability to download the reports in the user defined formats.

. Worked on Multi-User Environment (MUDE) by merging and importing

multiple projects.

. Created comprehensive and easy-to-understand Documentation of the

complete implementation of the Customer Sales Business modules

(Reports, Dashboards, Security and Star schema).

. Worked extensively on BI Answers & BI Publisher to create the reports

as per the business requirements

. Administered NQSConfig.ini and Instanceconfig.xml configuration files.

. Configured iBots to deliver Analytics content based on schedule,

automated iBot queries to obtain weekly reports.

. Creating marketing Campaigns for the enabling the scheme to reach

remote customers through SMSs

. Worked with Catalog Manager tool.

. Used Informatica Power Center for ETL purpose, for Data Extraction

from ERP, Data Mapping and Data Conversion (Transformation) and Data

loading into the OLAP warehouse.

. Involved in developing the Incremental ETL process i.e., Mappings &

Mapplets using various Transformations and Workflows with Sessions /

Tasks.

. Maintained the Full and Incremental loads through DAC on different

environments like Development and Test environment.

. Created the OBIEE environment for Development, QA and Production

environment.

. Participated in complete life cycle of the project from project

initiation, to development, to production support and maintenance.

. Identified complex bugs in production and resolved them.

. Extensively involved in task allocation and release management

. Co-ordinating and working closely with the offshore team. located in

Mumbai, India.

Environment: Oracle Business Intelligence (OBI) EE 10.1.3.x, OBIEE

Marketing, Informatica 7.1.8, DAC 7.8, Oracle 10g, TOAD, MS Windows XP

Royal Bank of Canada, Mumbai, India

Senior OBIEE Developer

Jan11 -Mar12

Project Title : Business Intelligence and Independent Price

Verification

Phase : Development

Scope of the Project: Royal Bank of Canada is one of the Leading banking

firms. The project involved maintaining Business Information spanning to

all the sectors of work for the bank and analysis for the day to day

business.

Responsibilities:

. Participated in requirements gathering of the various work streams by

discussing with the business user and base lining the details.

. Requirement analysis, Designed and implemented custom business

intelligence solutions (Metadata and Dashboards/Reports) using the

Siebel / Oracle Business Intelligence (OBI) Analytics platform.

. Developed the repository model for the different work streams with the

necessary logic that involved creating the Physical, BMM and the

Presentation layer, customized the existing model and Created

hierarchies, variables, and event poll strategies in the repository.

. Developed and customized OTB reports and new Reports, cosmetic changes

to Dashboards with different subject matter Views (Drill-Down /

Dynamic, Pivot Table, Chart, Column Selector, Tabular with global and

local Filters) using Siebel Analytics Web / Oracle Business

Intelligence (OBI) Presentation Services for the various work streams

and sales force.

. Enhance performance of Reports / Dashboards by implementing the

Aggregate tables, Materialized Views

. Created and customized reports with different views - Table, Pivot

Table, Charts, Column Selector, etc using Answers.

. Administered NQSConfig.ini and Instanceconfig.xml configuration files.

. Managed Security privileges for each Subject area and Dashboards

according to user requirements.

. Configured and automated iBots to deliver Analytics content.

. Customized OTB mappings for Financial Analytics and customizing for

the new requirements.

. Prepared the Test Plans and Test cases for validating the

reports/dashboards.

. Created the OBIEE environment for Development, QA and Production

environment.

. Participated in complete life cycle of the project from project

initiation, to development, to production support and maintenance.

. Identified complex bugs in production and resolved them.

Environment: Oracle Business Intelligence (OBI) EE 10.1.3.x, Oracle 10g,

TOAD, MS Windows XP

Saudi Telecom Company, Mumbai, India

OBIEE/ Siebel Analytics Developer

Nov08 - Dec10

Project Title : Enhancement and Outsourcing

Phase : Development

Scope of the Project: Saudi Telecom Company is the largest service provider

in the Middle East countries.

As a member of the Business Intelligence team I was responsible for

providing the Business Statistics for the management decision making.

Responsibilities:

. Worked closely with Business Users and Subject Matter Experts (SMEs),

reviewed Functional Design Document, created Technical Design Document

and gathered the requirements from different user groups and created

the design for the application.

. Developed and customized the OOTB OBI EE metadata repository model

with the necessary logic that involved creating the Physical, BMM and

the Presentation layer.

. Developed hierarchies, variables, joins, time series objects,

aggregate navigation and event poll strategies in the repository.

. Migration from Siebel Analytics 7.8.x to Oracle Business Intelligence

10.1.x

. Developed Calculated Measures and assigned Aggregation levels based on

Dimension Hierarchies, thereby achieved performance enhancement.

. Created various reports in multiple views such as Pivot Table, Charts,

Tabular, View Selector, configured Global Filters and Prompts; these

reports were placed under various dashboards based on the subject

areas that were used for managerial decisions.

. Performed Performance Tuning of Dashboards/Reports by implementing

strategies like aggregate navigation, cache management, materialized

views.

. Created Action Links, generated navigation reports with conditional

format of columns.

. Customized logical tables and columns, defined the Analytics

dimensions, aggregations and levels.

. Implemented Security (Object Level, Column Level) by setting up users,

groups with access privileges and query privileges.

. Implemented row-wise Initialization configured Bridge and Helper

tables.

. Administered NQSConfig.ini and Instanceconfig.xml configuration files.

. Worked in MUDE environment, simultaneously working on repository with

multiple other developers.

. Configured iBots to deliver Analytics content and automated iBot

queries for daily and weekly reports.

. Implemented Usage Tracking reports which read statistics from the

usage tracking database. These reports helped identify performance

bottlenecks for further tuning.

. Configured Repository, Presentation and Session variables to get

dynamic reports and dashboards.

. Executed Informatica SDE/SIL ETL mappings to populate Siebel

facts/dimensions.

. Used Informatica Power Center for ETL purpose, for Data Extraction

from ERP, Data Mapping and Data Conversion (Transformation) and Data

loading into the OLAP warehouse.

. Involved in developing the Incremental ETL process i.e., Mappings &

Mapplets using various Transformations and Workflows with Sessions /

Tasks.

. Maintained the Full and Incremental loads through DAC on different

environments like Development and Test environment.

. Performed the Server Administration tasks of migrating the BI

Repository, Webcat between the Development, Testing, UAT and PROD

environments.

. Performed all phases of end-to-end testing which includes Unit

Testing, Integration Testing, Functionality Testing, Regression

Testing, System Testing and Smoke Testing of the application.

Environment: OBI EE 10.1.3.3.1, Siebel Analytics 7.8.x, Siebel CRM 8.1,

Informatica 7.1, DAC 7.9.5, Oracle 10g, MS Windows XP

Sony Pictures, Mumbai, India

Business Objects/Quality Stage Developer

Nov07 -

Oct08

Project Title : BI - Centre of Excellence - Delivery

Phase : Development

Scope of the Project: Sony Pictures is one of the leading Movie Production

House and Home Entertainment Company. The Business Intelligence team was

responsible for the Overall Business Information for the decision making.

Responsibilities:

. Creating Business Objects reports as per requirements.

. Creating Quality Stage jobs for the data Cleansing and de-

duplication.

. Creating User documentation for the Quality Stage jobs created.

. Testing the reports and jobs created.

Environment: Business Objects, Quality Stage, Oracle 8i, MS Windows XP

Contact this candidate