Shikha Agrawal

**** ******* **,

Twinsburg, Oh, *4087

acbcug@r.postjobfree.com

330-***-****

Summary:

Experienced Business Intelligence professional with over 12 years on focused expertise on OBIEE Dashboard, Answer

Reporting, DAC, OBIEE Scheduler, OOB Data Model, Disconnected Analytics, Usage Tracking), Mobile BI ( iPad /

iPhone /iOS integration), Mapviewer integration, Siebel Pharma, Siebel Sales modules, I nformatica ETL, Oracle Data

warehousing.

Specialization:

Since 2000, my focus has been exclusively on the design and implementation of successful OBIEE/Siebel Analytics

deployments especially in the pharmaceutical, telecom and Consumer Goods industries. I have actively performed

during assessment, designing, implementing analytical and Data-warehousing solutions for number of clients, some of

those are – Novo Nordisk, Astellas, Hologic, Pfizer Animal Health, Otsuka, Cytyc, Merck, Borehinger Ingelheim,

Serono, Shire, Proctor & Gamble, Johnson & Johnson, Teva, Covidien, Watson,Leo and Schlumberger.

Education:

Master’s in Computer Software Mgmt (MCM) securing a GPA Score of 3.78 (out of 4.0).

Areas of Specialization::

OBIEE environment Performance Tuning.

CRM (OBIEE Analytics) Package Software Configuration / Customisation / Implementation / Support.

OBIEE RPD Configuration, Weblogic Enterprise Manager and Weblogic Console setup

Business Intelligence (Tactical and strategic reports) using OBIEE Analytics

OBIEE Agents and Schedulers (iBots)

OBIEE iPad plug in configuration.

CRM Business Process Re-engineering and Design

Informatica ETL/ Integration / Architecture / Performance Optimisation

Data warehouse applications involving data mapping, data extraction-transform and loading, data mining.

Technology Assessment and Evaluation to fit the Client Business requirements and criteria’s.

Technical Skills ::

OBIEE / Siebel OBIEE 11g.x/Siebel ver. 7.8.4/7.7/7.5 / 6.x, Siebel Architecture, Siebel Analytics Admin Tool, Siebel

Technical Answer, Siebel Dashboard, DAC 7.8/7.7,Siebel Tools, Siebel Web Services, Siebel Scheduler Server,

Siebel iBots, Siebel Disconnected Mobile application. Google api Integration to OBIEE, OBIEE

Application Install and setup, OBIEE Marketing Segmentation, Multi User Development Setup.

Siebel Functional Oracle-Siebel Pharma, Siebel Call Centre 2000, Siebel Marketing 2000, Siebel Sales 8.1 & 7.5 .211,

Siebel Field Services, FTI (Fusion Transportation Intelligence).

Exposure to other BI Cognos 8, Microstrategy, Business Objects, Ab-nitio, Data stage, Hyperion 9

Tools\ Tech

CRM-Best Practices FirstLogic CRM, Achieving Real-time Intelligence through Siebel Analytics, Siebel Performance

Tuning, Managing Entire Customer Life-cycle, Cross-Application Integration

Reports Siebel Analytics Report, Actuate Report Designer ver 5.x, Actuate Viewer, Crystal Reports, Cognos

Report studio, Hyperion(Interactive Report Studio, Financial Reporting Studio)

Databases Oracle 10g /9i / 8.x(SQL, PL SQL), CASE, TOAD, SQL Loader, MS Access, MySQL, INGRES.MS SQL

Data Warehouse/ETL Informatica Powercenter 5.1.2, Informatica Repository Manager, Informatica Server Manager

Methodology SSADM, Waterfall, Conversant with the entire Software Engineering lifecycle, R2i.

Programming XML, JSP, CGI PERL, HTML, JavaScript, VBScript, PHP, WML, Shell Scripting

Web Technology Apache1.3.1, Web logic 5, Microsoft Personal Web Server, E-Business Applications, SSL

OS Window XP/NT/Workgroups 2000, UNIX (HP, Scored Hat Linux7, AIX), Macintosh

Page 1 of 5

Work Experience:

Tek Systems - Schlumberger (Solution Architect) May13 - Present

Schlumberger limited is the world’s leading supplier of technology, integrated project management and information solutions to

customers working in the oil and gas industry worldwide.

Role:

Schlumberger is has multimillion dollar inventory of parts and supplies to support their current and future operations

worldwide. To maintain and effectively utilize the existing inventory the VP of Inventory management within EMS needs a BI

solution displaying the inventory stock revenue snapshot of 12 months by Age, Classification and Month in Excess by business

units where the inventory resides. My role is to lead the overall proof of concept development and working with the offshore

teams and on site team to get the POC completed. The Poc is build using the Obiee 11.6 on the development environment.

Skills:

OBIEE11g.6 (RPD Data Modeling, Answer Reports), iPad integration, Advanced Dashboard design techniques using

assist in functional & technical creating design documents such as screen design, metadata design, architecture

design .

IMS Health -Leo Pharma, NJ (OBIEE Technical lead) July’ 12- Mar13

Role:

IMS product Performance Analytics is a hosted OBIEE application that business intelligence and reporting requirement

for Leo. The Performance analytics offering for Leo includes and Adhoc reporting subject area to full fill all the

reporting needs of senior management and a set of dashboard and reports for various levels of Geographical hierarchy

such as Sales Rep, District manager, Regional Manager, National HQ Users, and Market Research groups. My role from

the beginning in the projects have been to architect and design the metadata and develop to support all the reporting

needs and coordinate the data requirements for the project.

Skills:

OBIEE11g.6 (RPD Data Modeling, Answer Reports), Weblogic Server Administration, RCU database Install and set

up, Multi User Development Environment, iPad integration, Advanced Dashboard design techniques using HTML and

JavaScript’s, assist in functional & technical creating design documents such as screen design, metadata design,

architecture design .

IMS Health -Watson Pharmaceuticals, NJ (OBIEE Technical lead ) June’ 11- July12

Role:

IMS product Performance Analytics is a hosted OBIEE application that business intelligence and reporting requirement

for Watson. The Performance analytics offering for Watson includes vast amount of data starting from territory to

National level for Monthly and Weekly data feeds from IMS Secondary Data factory. There were dashboard and

reports for various levels of Geographical hierarchy such as Sales Rep, District manager, Regional Manager, National

HQ Users, and Market Research groups. My role from the beginning in the projects have been to architect and design

the metadata and develop to support all the reporting needs and coordinate the data requirements for the project. As

part of the projects extension an iPad rollout to the district managers and Sales Rep was delivered using OBIEE mobile

plug in.

Skills:

OBIEE11g (RPD Data Modeling, Answer Reports), Weblogic Server Administration, RCU database Install and set up,

Multi User Development Environment, iPad integration, Advanced Dashboard design techniques using HTML and

JavaScript’s, assist in functional & t echnical creating design documents such as screen design, metadata design,

architecture design .

IMS Health -Covidien, St Louis, MO (OBIEE RPD lead ) July’ 10 – May’ 11

Role:

Performance Analytics is a hosted OBIEE application that full fills all the Market Research and Sales Force analytics

reporting requirement for Covidien. The Performance analytics offering for Covidien includes vast amount of data

starting from territory to National level for Monthly and Weekly data feeds from IMS Secondary Data factory. There

were more then 160 aggregates table and metadata with efficient performance is being developed to meet the diverse

needs of both Sales Force and Market Research groups. My role from the beginning in the projects have been to

architect and design the metadata and develop to support all the reporting needs.

Skills:

OBIEE (RPD, Answer, Reports),Multi User Development Environment, Advanced Dashboard design techniques

Page 2 of 5

using HTML and JavaScript’s, Functional & Technical Design documents, Screen Design, Metadata Design,

Architecture Design .

IMS Health -Novo Nordisk, Princeton, NJ (OBIEE Lead) July’ 09 – June’ 10

Role:

Novo Nordisk Assessment project involved multiple t echnologies evaluation (OBIEE, BIP, Custom, and MS Office Plug-

in) to meet the requirements for One Stop Shop project which it geared towards Sale Rep in the Diabetics Sales Force.

The main objective for the project is to enable Sales rep to obtain reports without network connectivity on their tablet

PC and one source of all the other requirements such as (reporting /calendar/news types /my favourites /shared

calendar / Google map with multiple pinpoints for activities) while connected & Disconnected. As OBIEE lead I created

wireframes in OBIEE and rank/weight those on several criteria's such as functional, cost, time etc. We created demo

screen for the wireframes in all different solutions that we assessed. Also performed a Cost benefit Analysis for ach of

the option. I was actively involved in business requirement and layout design workshops for the application. I was

leading the OBIEE development project effort which included disconnected application for 2000 Reps and connected

application for district Managers.

Skills:

OBIEE (RPD, Answer, Reports), Google API, Advanced Dashboard design techniques using HTML and JavaScript’s,

Functional & Technical Design documents, Screen Design, Metadata Design, Hw design, Architecture Design .

IMS Health -Astellas, Chicago, Deerfield (OBIEE Data Model Expert) April’ 09 – July’ 09

Role:

Weekly Split Syndicated data: Lead and manage day today activities and overall Data Warehouse management task

at different phases of Weekly WXDM data delivery project for Astellas. Apart from DW management task also

facilitated how client can fit the split week data into client existing data warehouse and best practices around obiee.

Skills:

RPD, OLAP Data model Design, Best Practice around ETL Frequency and Full vs Inc, Historic Data Model, Microsoft

Project, Visio.

IMS Health -Pfizer Clinical Trial, Kalamazoo, MI (OBIEE Answers) May’ 09

Role:

Training Lead, Conducted 1 week OBIEE Dashboarding and Answers Techniques workshop to facilitate training to the

business group . The objective was to train a group of 25 executives to be able to perform day today decision making

reporting using answers adhoc reporting tools and share their vision with other team members. This project was also

supporting another in parallel assessment project for their existing OBIEE system which needed to be rebuilt /

enhanced to fit their requirements.

Skills:

Training & Presentation, OBIEE dashboard and Answers

IMS Health, Union Meeting, PA (OBIEE & On Demand Server Architect) Jan’ 09 – March’ 09

Role:

To assist as part of the business development team worked on creating prototypes based on OBIEE and Oracle On

demand platforms. These prototypes not only demonstrate t he t echnical capabilities of the tool but included wide

range of functional area such as Close Loop Marketing and other analytical reports based on Sales, Call, Segmentation,

Managed Market, Patient Level Data to facilitate and effective business Intelligence system to Pharmaceutical clients

Skills:

Oracle On Demand, OBIEE Repository, Answers

Skura Corp- Hologic - Marlborough, MA Aug’ 08 – Nov’ 08

Role:

RPD and Data model specialist, Worked on the release management projects for addition of new business

requirements into pre-existing analytics system. Design, configuration, test, migration and implementations on the

Siebel Analytics platform.

Skills:

RPD, DAC, I nformatica.

Skura Corp -Pfizer Animal Health, Midtown, New York (OBIEE Lead/ Architect) Sept’ 07 to June’ 08

Role:

Pfizer Animal health implemented a global CRM and Sales Application for their Sales, Marketing, Finance and

Research groups to enable strategic planning and forecasting based on the current and time based matrix. I was

Page 3 of 5

leading discovery, design implementation and testing of their several projects to achieve an integrated OBIEE

platform to facilitate effective business intelligence and reporting system. I was also part of several assessments and

project merge that was designed to integrate and convert several small BI reporting system on OBIEE platform.

Skills:

OBIEE 10.1.3.3.0, Oracle DB, MS SQL Datawarehouse.

Skura Corp -Otsuka- Princeton, NJ (Data Modeller/ design Architect) August’ 07

Role:

Data Modeller and Design Architect: Facilitate fully customized architectural design and POC for incorporating the

terabytes of syndicated Xponent and plantrack information within the Siebel Analytics Datamarts to reduce the ETL

Load time by 60%, enhance the report performance by 40% and reduce the Disk space consumption by 30%

through implementation of Oracle & Data warehouse best practices.

Skills:

Oracle OLAP Design Concepts and Best Practice, Oracle Database, Informatica ETL, DAC

Skura Corp -Cytyc -Marlborogh, Boston, MA (Data Modeller) April’ 07- July’ 07

Role:

I was responsible for architecting Data Model and Configuration of the business model in the Siebel Analytics

Repository to support the Adhoc reporting requirement for Sales and Call Activities. Coordinating and performing

release management task from Development to QA, UAT.

Skill:

Siebel Analytics 7.8.4 E Medical, Oracle 9 Db, Windows Platform, DAC, Informatica, Siebel Administration tool,

Siebel Answers

Skura Corp Borehinger Ingelheim – Connecticut (Senior Analyst) April’ 07

Role:

Assessment of a disconnected report for filed sales reps performance evaluation. Investigation of existing Data model

as well as other data sources required for report . Delivering various design options and possible solution to implement

the requirement.

Skills:

Siebel Analytics, Oracle DB, Excel and Microsoft plug-in for Siebel Analytics, Direct SQL From Answers.

Skura Corp -Serono- Boston, MA Jan’ 07- March’ 07

Role:

Designed and developed ‘live data’ demo. Installation of all software components, data cleaning and loading, and

development Of DAC (Data warehouse Admin Console) Execution plans. Performed positioning of the dashboard as

per business user requirements.

Skill:

Siebel 7.8.4 Analytics, DAC, ETL, Informatica, SQL, Oracle OLAP.

Skura Corp - Shire Pharmaceutical – Philadelphia, PA (Analytics Technical Architect) June’ 06 – Dec’ 06

Role:

Performed server metadata design, donfiguration and administration. Worked on Siebel RPD (Presentation, Logical,

and Physical), initialization blocks and Expression Builder. Design & Deployment of the Mobile Analytics application

for 700 users.

Skills:

Siebel 7.8.4 Analytics, Analytics Repository, WebCatalog Manager, Answers, Disconnect ed Analytics

Skura Corp -Proctor & Gamble – Mason, Ohio (Analytics Technical Architect & Team Lead) Jan’ 06 – Apr’ 06

Role:

Worked through the design, development, implementation of the Siebel7.8.2 Siebel Analytics reporting application to

replace the customized datawarehouse and excel reports for Targeting, Calls, Objectives and Syndicated data.

Assisted in the resolution of technical, architectural and business issues. Managed Oracle Siebel sizing, configuration

and production readiness reviews.

Skills:

Vision, Siebel Analytics, Informatica, Dac, Oracle OLAP, Siebel Metadata, Answers, Webcat Management

Skura Corp -Johnson & Johnson, Princeton, NJ (Senior ETL Consultant) July’ 05 Dec’ 05

Configuration and Execution. Configured DAC Tasks, Table, Indexes, Table Groups, Subject Area, Execution

plan for custom objects. Assisted in configuration of Disconnected Mobile Analytics

Role:

Page 4 of 5

Developed the Informatica workflows, mapping for the custom aggregates, dimension and facts.

Configured DAC Tasks, Table, Indexes, Table Groups, Subject Area, Execution plan for custom objects.

Developed and designed the Answers reports, Charts, filters, Graphs, pivot tables.

Skill:

Siebel 7.8.2 Analytics, Informatica Powercenter 6.2.1, Oracle OLAP 9.X, DAC Administration ver.7.7 build 306

Bell Canada Enterprises, Toronto, Canada (Senior Siebel Consultant) Nov’ 04 to Jun’ 05

Bell is Canada's largest communications company and provides telephone, long distance, wireless, Internet, data,

satellite television and other services to residential and business customers. I am involved as a lead consultant on ETL

(informatica) and Data Warehouse Admin Console and was extensively involved during the development and

implementation cycle.

Role:

Developed the Informatica workflows, mapping for the custom aggregates, dimension and facts.

Configured DAC Tasks, Table, Indexes, Table Groups, Subject Area, Execution plan for custom objects.

Worked on Siebel RPD(Presentation, Logical, Physical ), initialization blocks and Expression Builder

Developed and designed the Answers reports, Charts, filters, Graphs, pivot tables.

Skill:

Siebel e communication Analytics 7.7 (RPD, Webcat, Answers), Informatica Powercenter 6.2.1, Oracle OLAP 9.X, DAC

Administration ver.7.7 build 306.

Bearing Point, LLP (Senior Siebel Analytics Administrator) Sep’ 03 - Nov’ 04

CRM Siebel Sales 7.5 and Analytics 7.5 is implemented to manage the worldwide sales and customer operations

through connected and disconnected channels.

Role:

Maintain Siebel Analytics application on Production, QA and development environments.

Manage Siebel Analytics Server, Web Catalog, Repository, Standard Reports, ETL and regular data loads

Develop and implement enhancements to keep the Analytics application up to date for new reporting

requirements. This involved ETL changes, Rpd (all three layers) changes, OLAP schema changes and Answers report

changes.

Skill:

Siebel Analytics 7.5.2, Informatica Powercenter 5.5, Oracle OLAP 9, LDAP Authentication, Win 2000,BMC Petrol.

Kraft Canada Inc (Siebel Data Analyst) Dec’ 02 - Apr’ 03

Kraft Canada Inc. is one of the leading consumer product companies in North America. CRM Siebel Call Centre 7.5 and

Siebel Marketing 7.5 is being implemented by Kraft to manage and coordinate its customer interactions across

multiple channels. Kraft customers, spread across the globe are managed through the Siebel CRM System.

Role:

Performed data analysis for Kraft system, mapped to Siebel data mart for Siebel OLTP/EIM data loading process.

Designed TestScripts for Siebel EIM dataload and process optimisation as per Siebel recommended “best-

practices” for Batch size analysis and I FB configuration file parameters.

Developed PL/SQL scripts based on business rules to perform ETL and load the EIM Interface Tables.

Designed and customised Siebel Marketing Dashboard / tactical reports using Siebel Analytics Web tool Answer.

Used SQL Expression Builder to design the Logical and Presentation Layer in Siebel Analytics Administration

Tool.

Skills:

Siebel Call Centre7.5, Siebel Marketing 7.5, Siebel Analytics 7.5, EIM, Oracle 8.1.7, FirstLogic CRM.

Continuing Education :

Oracle Business Intelligence11g Fusion middleware administration, Aug 2011-IMS Health

Managing projects – ESI International, June 09 – IMS Health

Oracle On demand Certificate – Feb 09 – I MS Health

Cognos8 Reporting, Modelling & Authoring Fast Track Course from Cognos.

Siebel Core Consultant 7.7 training – Siebel System Inc.

Siebel 2000 by Electronic Research & Development Centre.

Mastering “CRM– Best Practices” by Bearingpoint.

Oracle 8, Developer 2000(Forms4.5 /Reports2.5) by National Institute of Information Technology.

References :Available upon request

Page 5 of 5

Contact this candidate