Project Customer Service

Summary

. Accomplished professional with ** yrs. of experience in globally

distributed project environments for consulting firms and corporations

nationwide.

. Extensive experience in cross industry - manufacturing, food, hi-tech,

financial, membership processing, banking, retail/distribution,

telecommunication/wireless.

. Consult with clients to identify, clarify, and resolve complex issues

critical to clients' strategic and operating success by developing

insight, conducting independent analysis for identifying technology led

improvements based on benchmark data and managing projects and meeting

with clients to assure assignment progress.

. Over 8 yrs. of IT Program/Project Management experience with full

lifecycle project implementations of IT Strategy, Information Management,

Business Process Re-engineering, Enterprise Architecture Framework, Data

Warehousing, Business Intelligence, EPM and MDM solutions. In-depth

knowledge of Big Data.

. Over 9 yrs. of experience leading, managing and implementing Business

Intelligence application architect and development using OBIEE, Essbase,

Hyperion Planning, Business Objects and Crystal Reports.

. Over 7 yrs. of experience in implementing (Architect) OBIEE packaged

analytics applications such as Financial Analytics, Project Analytics,

Supply Chain and Order Management Analytics, Procurement and Spend

Analytics,Sales Analytics, Service Analytics, DAC and custom development

using OBIEE platform. OBIEE Administration and Migration. Upgraded OBIEE

Platform to OBIEE 11.1.1.6

. Experience leading and managing Data Warehousing system development using

Informatica.

. Over 14 yrs. of Database Design, Data Modeling, Data Migration, Data

Quality, Data Governance, Data Stewardship experience with entire system

development life cycle using Netezza, Teradata, Oracle, Informix, SQL

Server.

. Over 9 yrs. of IT Technical Architecture Design, Development and

Integration experience with system development life cycle and project

implementation using various development methodology.

. Worked very closely with the CxO layer and other senior management and

participated in Steering Committee meetings and developing strategies

related to Stakeholder Management, Communication Plan, Project

Governance, Risk Management and Training.

. Good experience managing geographically distributed and culturally

diverse work-groups with strong leadership, team management,

interpersonal and mentoring skills.

. Excellent verbal and written skills, relationship management skills

across all levels of an organization, great enthusiasm to learn, self

motivated, and be able to work with minimal supervision.

PROFESSIONAL EXPERIENCE

Gradient Consulting - Sr. Principal Consultant (Oct

'10 - Till date)

. Work as OBIEE Architect and OBIEE subject matter expert to define best

practices and standards. Activities range from problem identification,

solution architect, defining specifications, data modeling, data

extraction, transformation and loading, repository design and

development, dashboards and answers development, client training and

deployment.

Key Projects

Coventry Healthcare, Downers Grove, IL- Sr. Data Warehouse Architect

(Netezza, Informatica)

. Currently working on a project to migrate Coventry Data Warehouses

developed in Oracle to Netezza Warehouse Appliance.

Navistar Inc, Lisle, IL- OBIEE Architect (OBIEE 11.1.1.6, Essbase, Hyperion

Planning)

. Upgraded OBIEE Platform to OBIEE 11.1.1.6. Worked as OBIEE Administrator

(10g & 11g) to administer the instances (Development, Test & Production)

and migrations.

. Implemented Truck Sales Analytics (Phase 1 & Phase 2) custom development

project using OBIEE, Teradata and Datastage. Created 3NF data model for

various subject areas, ETL Specification, OBIEE repository and report

development.

. Implemented PCM and Finance Transformation reports using Essbase,

Hyperion Planning reports and OBIEE dashboards and reports.

Responsibilities include repository, dashboard and report development.

. Implemented Parts Sales Analytics OBIEE custom development project using

Teradata, Datastage and OBIEE. Responsibilities include data modeling

(Star Schema), defining ETL specifications, OBIEE repository development

and dashboard and report development. Interacted heavily with Business

sponsor to define business rules.

CPS, Chicago, IL- OBIEE Architect (OBIEE 10.1.3.4, BI Apps 7.9.4,

Informatica 8.1, DAC)

. Worked as OBIEE subject matter expert to create data modeling standards

for custom development and extension. Created Dashboard and Reporting

standards. Responsibilities include maintaining pre-built BI Apps, OBIEE

Administration, Migration and off-shore team management.

Rolta-TUSC - Management Consultant (Apr '10 -

Oct '10)

. Work as part of Oracle BI practice as OBIEE subject matter expert.

Activities range from practice development, project management to problem

identification, gathering requirements, solution architect and defining

specifications for product configuration and implementation, warehouse

design, data extraction, transformation and loading, report design,

dashboards and answers, client training, and deployment.

. Architect and implement OBIEE out of the box Analytics applications

(Financial Analytics, Supply Chain Analytics, Procurement and Spend

Analytics).

Key Projects

Diversey, Racine, WI - Sr. OBIEE Architect (OBIEE 10.1.3.3, BI Apps 7.9.5,

Informatica 8.1, DAC)

This project aims to replace Business Objects, the MS SQL data marts and

implement OBIEE pre-built applications such as Financial Analytics, Supply

Chain and Order Management Analytics, Procurement and Spend Analytics. I

led Financial Analytics implementation, my responsibilities include

configuring GL Accounts, validating pre-built dashboard with business

users, managing offshore team for customization and OBIEE Administration

and migration. Managed Supply Chain and Order Management Analytics,

Procurement and Spend Analytics implementations.

Hitachi Consulting - Manager/Architect, Specialized Services (Sep

'08 - Apr '10)

. Work as part of National BIPM team as OBIEE subject matter expert.

Activities range from project management to problem identification,

gathering requirements and defining specifications for product

configuration and implementation, warehouse design, data extraction,

transformation and loading, report design, dashboards and answers,

software testing, client training, and deployment.

. Architect and implement OBIEE out of the box Analytics applications and

custom development.

Key Projects

Manheim Financials, GA-OBIEE Architect (OBIEE 10.1.3.3, BI Apps 7.9.5,

Informatica 8.1, DAC)

It was not possible to obtain a single view of a dealers overall debt

picture with Manheim. Information related to UCL, MAFS and other A/R debt

is contained in various operational systems at Manheim. Due to various

disconnected credit and collections management applications it is difficult

to obtain a view of Manheim's current credit risk exposure with dealers.

The Objective of this project is to provide a single consolidated view of

debt for dealers, individual dealer owners as well as mega dealers by

combining auction specific debt, MAFS debt and other A/R debt. My

responsibilities include design a data model, create ETL specification,

design and develop OBIEE repository, create reports and dashboards.

MARS M&M, NJ - OBIEE Architect (OBIEE 10.1.3.2, BI Apps 7.8, Informatica

7.x)

MARS had fundamental issue complicating the generation of accurate Brand

Spend reports has to do with lack of event spend data availability at the

appropriate level of detail (Brand/Product/Amount).

The objective of this project is to Allocate cost (percentage) based on the

ratios and sales volumes, calculate ratios based on product, brand and

events, and Identify specific dashboard and reporting requirements to build

out that will offer the most value. My Responsibilities includes initial

assessment to delivery of the project.

AAI Corporation, MD-OBIEE Consultant (OBIEE 10.1.3.3, BI Apps 7.9.4,

Informatica 7.x, DAC)

The objective of this OBI implementation is to leverage Oracle ERP's

capabilities and build robust Business Intelligence and Performance

Management capability for AAI. The implementation includes two tracks such

as Implementation of standard ARMS-to-OBI integration and analytics &

Development of custom ARMS-to-OBI integration to accommodate Projects-based

analytics.

US Oncology, TX - OBIEE Consultant (OBIEE 10.1.3.3, BI Apps 7.9.4,

Informatica 7.x, DAC)

Led the business requirements gathering and OBIEE customization for Service

Analytics. Developed technical solutions to business problems in the OBIEE,

customized Informatica mapping, created custom fields in database and

presentation service, customized dashboards, answers and iBots.

Infosys Consulting Inc. - Senior Associate (Oct

'06 - Jun '08)

. Analyze and redesign business processes such as Marketing Campaign,

Closed Loop Corrective Action, Earlier Field Failure Analysis, Enterprise

Selling Process, Channel management, Strategy, Customer Service and

Support, Supply Chain related areas and how these processes integrates to

create a seamless business process flow with improved visibility of real

time data, information and reporting for the Hi-Tech and Discrete

Manufacturing companies.

. Define and interpret key business drivers, vision, strategy, process

challenges, metrics, operational and management reporting and business

intelligence needs, information technology challenges and formulate

strategies for process improvements to improve efficiency and

effectiveness.

. Discuss best practices, metrics, benchmarks and reports used in the

industry and facilitate workshops and interviews to gather requirements,

out of the box process flows and functionality existing in enterprise

applications such as Siebel Analytics and OBIEE.

. Manage projects and develop project artifacts and deliverables that

highlight the value proposition, business case and benefits of the future

redesigned process.

Key Projects

Palm Inc, Sunnyvale, CA - Business Intelligence & Siebel CRM - OBIEE

Consultant

Led the OBIEE implementation for Closed Loop Corrective Action process to

enable real time data capture, analysis and reporting of relevant and

accurate product return/failure information to enable accountable parties

to perform root-cause analysis and corrective action. Led the business

requirement track to gather business requirements for Siebel CRM and OBIEE

solution, developed technical solutions to business problems in the OBIEE,

configured Sales Analytics, Business Intelligence Application Repository

and explored the functionality of Contact Center Telephony Analytics.

Microsoft Corporation, Redmond, WA - Business Intelligence - Information

Lead

Led the development of the vision and scope document and business

requirements definition from Microsoft's worldwide subsidiaries (New

Zealand, Norway, Switzerland) for Enterprise Sales Process(EPG), to enable

an enterprise customer relationship marketing system worldwide to improve

the Information Delivery and Business Intelligence capability, by

establishing a single version of the truth, 360 degree view of the customer

and foundation of data quality improvement to improve Field Productivity by

15% to drive revenue and business growth.

American Medical Association, Chicago, IL - Project Manager (May

'01 - Oct '06)

. Managed project activities from initiation to implementation of Data

Warehousing, BI Analytics and Enterprise Architecture applications and

participated in the entire Project Life Cycle Management.

. Analyze and redesign business processes such as Invoice and Payment

Processing, Marketing Campaign, Customer Service and Support and how these

processes integrates to create a seamless business process flow with

improved visibility of real time data, information and reporting for AMA.

. Converted business requirements to technical specifications and ensuring

timely delivery of quality project. Created long-term strategies to

forecast membership marketing and projected response by population

variance.

. Worked in the following projects apart from the key projects listed below

Join/Renew Membership, Online Catalog and AIMSIP.

Key Projects

Partnership for Growth Data Reciprocity - Managed Data Warehouse project

using Informatica and Oracle based on star schema.

Customer Relationship Marketing - Led the development of the Data Warehouse

project using Informatica and Oracle based on star schema. Led the entire

system development activities such as data mapping, star schema database

design and Informatica development.

XPEDIOR INC Chicago, IL - Senior Consultant (May '98 -

Apr '01)

Key Projects

OfficeMax, Cleveland, OH - Data Architect & Release Manager

Upgraded OfficeMax's retail ecommerce website to BroadVision 5.5 from

BroadVision 4.0 to increase online transactions volume by 10 times.

Enhanced with additional capabilities of personalization, content

management and pricing modules.

HA-LO, Chicago, IL - Project Leader

Led the requirements gathering, laying out architectural frame work,

design, development and implementation of 15 webstores using ASP, IIS 3.0,

SQL Server and Windows 2000

Multiple Clients - Consultant (Jun

'95 - Apr '98)

Worked with various clients such as Lucent Technologies, Oracle Corp,

Comnet International, Progressive Solutions as a consultant.

Educational Background

. Master's in Business Management (MBA) 1999 - 2002 - Chicago, IL.

. Master's in Computer Application (MCA) 1992 - 1995 - Chennai, India.

Technical Expertise

Data Warehouse : Informatica, DAC, Powermart, SAP Business Warehouse

Business Intelligence : OBIEE, Siebel Analytics, Crystal Reports, Business

Objects, SQR Workbench

EPM Tools : Essbase, Hyperion Planning

Databases/Appliances: Netezza, Teradata, Oracle, Informix, SQL Server, DB2,

MS Access

4GL/3GL : JAM, Power Builder, JSP, C, PL/SQL

Operating Systems : OS/2, Windows, UNIX-HP, Sun Solaris

Application Servers : ATG Dynamo, BroadVision, IIS Web Server, Tuxedo

Ecommerce Tools : Java, JavaScript, HTML, XML

Tools : Erwin, Topdog Market Campaign Management Tool, UML, PVCS,

Rational ClearQuest, Rational RequestPro, MS Project, Rational

Test Manager

Training Received

. Oracle BI Suite EE: Build Repositories by Oracle

. Oracle BI Applications 7.9: Develop a Data Warehouse by Oracle

. Informatica Power Center Developer by Informatica

. Data Warehouse Lifecycle in Depth by Kimball University

. SAP Business Warehouse by SAP

. Manage E-business projects more effectively and strategically

Contact this candidate