Project Sales
Resume:
Ketki Hande
Ph :732-***-**** Sr. OBIEE Consultant
*****.****@*****.***
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