Experience Summary
Accomplished and Versatile Manager with a proven record of performance, leadership and results in a fast paced, business driven environment. Highly effective in providing DW/Business Intelligence solutions. Extensive experience in all aspects of project life cycle. Skilled liaison between Business and IT functions. Blends a thorough understanding of architecture, technology and methodologies with project management and best practices. Proactive and knowledgeable leader of productive technical teams.

SKILLS INVENTORY
Project Management:

• Project Planning & Management
• Risk Management & Mitigation Strategies
• Communication Management
• Change Management
• Scope Development & Management
• Resource Management

Analysis/Design:

• Rapid Application Development (RAD)
• Joint Application Design (JAD)
• Data Analysis
• Solution Design
• Technical and Business Use Cases
• QA Review

DW/BI Technology :

• Oracle
• IBM

Deployment:

• User Training
• Post Production Business User Support

ROLES:

• Project Manager
• Technical Manager
• Business Analyst
• Technical Lead
• Software Engineer

TOOLS/METHODS:

• SDLC
• RUP
• MS Project/Niku/Clarity
• OBIEE v 11g, 10.1.3.4
• OBIA v7.9.6.3
• Siebel Analytics v7.5,7.8
• Siebel v8.1,7.8,7.7,7.5,7.0,6.0,5.0
• PeopleSoft CRM,Clarify
• Kimball and Inmon DW Design approach

INDUSTRY APPLICATION:

• Retail
• Financial Services
• Insurance
• Healthcare
• Manufacturing

EDUCATION:

• Bachelor Of Science In Electronics Engineering

CERTIFICATIONS/TRAINING:

• Certificate in Applied Framework for Project Management
• Siebel Business Requirement Training
• Oracle Business Intelligence Application Workshop using v11g (Oracle Corp)
• Account Management Training (In-House-WIPRO)

CHRONOLOGICAL SUMMARY OF EXPERIENCE
Lead Consultant/ Senior Project Manager
Confidential, Fremont,CA,April 2010 to Till Date
BI Project Manager
Confidential,MN, Aug 2012 to Till Date

• The objective of the project is Assessment and Solution roadmap for eDW Commerce across multiple business areas to align with Confidential implementation

BI Project Manager
Confidential,OH, April 2012 to June 2012

• The objective of the project was Assessment and Solution roadmap for BI across multiple business areas
• As a BI Project Manager, responsible for Assessment and Solution roadmap for next 3years for OBIA-Financial Analytics BI Implementation across multiple business area to align with Oracle R12 Finance Implementation

Project Manager
Client- Confidential,MN, Sept 2011 to March 2012

• The objective of the project -Global Deployment of OBI Apps Implementation-Supply Chain Analytics for APAC/AMERICAS/EMEA
• As a Project Manager, responsible for building and leading project teams through all phases of project from inception to completion in an onsite/offshore model for OBIA - Supply Chain AnalyticsImplementation
• Involved in setting up SDLC (combination of waterfall & iterative)for OBIA Customization projects with three primary objectives: ensure that high quality systems are delivered, provide strong project management controls over overlapping projects, and maximize the productivity of the team
• Analyzed the source systems data-JDE ERP(E1) to gather the requirements and worked with the Business to identify key performance indicators for measuring project success
• Develop and maintain Project WBS including project dependencies and resource leveling
• Identify, manage and mitigate project risks.
• Responsible for Building Star Schema data models consistent with data requirements
• Responsible for translating functional requirements into technical requirements
• Design & Managed security privileges for each subject area
• Performed end to end testing of the ETL /DAC and validated RPD from Business prospective
• Provide weekly activity reports to client.

Project Manager
Client-Confidential,CA, March 2011 to Aug 2011

• The objective of the project was enhancements to existing OBIEE-Service Analytics Reporting.
• As a Project Manager, responsible for building and leading project teams through all phases of project from inception to completion in an onsite/offshore model for OBIEE - Service AnalyticsImplementation Analyzed the source systems data-Siebel Service(process change) to gather the requirements
• Develop and maintain Project WBS including project dependencies and resource leveling
• Identify, manage and mitigate project risks.
• Responsible for Building Star Schema data models consistent with reporting requirements
• Designed Report mockups using OBIEE Answers.
• Designed ETL customized mappings with Siebel OLTP source
• Design & Managed user level security for intelligence dashboards based on Business Requirement
• Validated and tested the custom OBIEE reports and dashboards
• Performed end to end testing of the ETL/DAC
• Provide weekly activity reports to client.

Project Manager
Client-Confidential, NY, July 2010 to Feb 2011

• The objective of the project was merging the Wyeth Marketing Analytics with Pfizer’s existing Marketing Analytics for Physicians area
• As a Project Manager, responsible for building and leading project teams through all phases of project from inception to completion in an onsite/offshore model for OBIEE Marketing AnalyticsImplementation with Sales Centric data for Physicians area
• Analyzed the source systems data-Teradata DW to gather the requirements
• Develop and maintain Project WBS including project dependencies and resource leveling
• Identify, manage and mitigate project risks.
• Responsible for Building Business model and established relationships consistent with business requirements
• Design & Managed security privileges for each subject area
• Designed ETL custom mappings for integration with Terradata Semantic Layer
• Performed end to end testing of the Ad-hoc Segmentation criteria using OBIEE Marketing Analytics tools.
• Performed environment migrations between the Development, Quality Assurance
• Provide weekly activity reports to client.

BI Consultant
Client-Confidential, IN, May 2010 to June 2010

• The objective of the project was Assessment and Solution roadmap for OBIEE-Service Analytics across multiple business units
• As a BI Consultant, responsible for Assessment and Solution roadmap for OBIEE-Service Analytics Implementation across multiple business units

Consultant
Confidential, Oct 2009 to Jan 2010

• The objective of the project was to provide a tool to the business for near real time data
• As Consultant in BI Strategy and Architecture group, responsible for RFP/RFI/POC(Proof of Concept) process for Tool Selection in "Change Data Capture" area Client-Target Corp,MN)
• Involved in defining business requirements/business objectives working with business and Senior Technical Architects from Target Corp so that business would be able to see near real time data changes.
• Organize and coordinate activities across the enterprise.
• Organize and plan the project schedule
• Develop and maintain Project WBS including project dependencies, external linkages.
• Identify, manage and mitigate project risks.
• Involved in Testing Product capabilities working with Two Vendors (IBM&Oracle) in a lab environment.
• Involved in integrating Product with IBM Data Stage ETL tool as well as with IBM MQ middleware.
• Provide weekly activity reports to client.
• Involved in Pricing Negotiations working with Technical Acquisition Team of Target Corp
• Involved in Vendor Selection process based on pricing and product capabilities.

Consultant/ Manager
Confidential, July 2006 to Oct 2009
Project Manager
Client- Confidential,CA, Feb 2009 to Oct 2009

• The objective of the project was enhancements and Data Quality to existing Customer Profile Registry data and integration across the enterprise
• As Project Manager, responsible for building and leading multiple project teams through all phases of project from inception to completion in an onsite/offshore model for MDM(Customer Profile Registry) using Service Oriented Architecture
• Organize and coordinate activities across multiple business areas.
• Analyzed the source systems data to gather the requirements
• Develop and maintain Project WBS including project dependencies, external linkages, and resource leveling
• Responsible for Building data models consistent with business requirements
• Proactively manage scope to ensure agreed deliverables; monitor adherence to master plan and schedules.
• Provide weekly activity reports to client. and Conduct weekly project team meetings.
• Managed multiple projects, on-time

Project Manager
Client- Confidential,MN, July 2006 to Jan 2009

• The objective of the project was enhancements including Data Quality to ADW-Marketing area and new DW in Finance area for the enterprise
• As Project Manager, responsible for building and leading multiple project teams through all phases of project from inception to completion in an onsite/offshore model for ADW-Marketing & EDW-Finance area and Web Focus Reporting and Essbase using IBM Technology Client-Target Corp,MN
• Organize and coordinate activities across multiple business areas.
• Analyzed the source systems data and current reports to gather the requirements for theAnalytical Data Warehouse -ADW-Marketing and EDW-Finance.
• Studied the relationship at the source system level that includes Siebel Analytics, Web Sales,Confidential,Store Sales
• Responsible for Building data models consistent with business/reporting requirements
• Design and implement Star schemas, fact tables, dimension tables, ETL processes
• Responsible for Development of the Extract/Transform/Load processes to source the appropriate data to be delivered to the Data Warehouse
• Develop and maintain Project WBS including project dependencies, external linkages, and resource leveling
• Identify, manage and mitigate project risks.
• Proactively manage scope to ensure agreed deliverables; monitor adherence to master plan and schedules.
• Prepare and present briefing at high level executive reviews.
• Provide weekly activity reports to client.
• Commended by Business and IT managers for exceeding expectations.
• Managed highly successful projects, on-time and on-budget.

Consultant
Confidential, February 2006-July 2006

• The objective of the project was Analytical Reporting for existing Siebel Call Center Implementation
• As a Consultant, gathered requirements working with business users for Siebel Analytical Reporting, on behalf of Accenture HR at Best Buy
• Involved in Report Analysis/Design and deployment of reports in production.
• Involved in post production support

Senior Consultant
Confidential, March 2004 to January 2006

• As a Senior Consultant coordinated with business for gathering the requirements and analysis and translating the business requirements into Solution Design- Client – Capital Group, CA, BMC Software, TX, Astellas Pharma, IL
• Analyzed the source systems data and current reports to gather the requirements for the Siebel Marketing Analytics /Siebel eFinance /Siebel Sales /Siebel ePharma
• Design and implement -Star schemas, fact tables, dimension tables, ETL processes and also data conversion/migration from various legacy applications.
• Worked on developing all mapping needed to load the staging area and into the base tables of the DW.Developed mappings to load both dimensions/facts and look up tables for warehouse
• Involved in writing EIM scripts for loading data from interface table to Base tables using PL/SQL ,Informatica ETL
• Led development team during development process; providing help with tasks and transfer knowledge for Informatica Power Mart
• Successfully implemented various Siebel initiatives i.e. ePharma, efinance, Siebel Sales and Marketing Analytics.

Consultant
May 2001 to March 2004

• Configuration Manager; worked with business for Siebel Sales Implementation while at GE-TIP.
• Technical Manager; Siebel eFinance implementation while at Northwestern Mutual.
• Project Manager; developed offshore development methodology for Siebel Implementation while at Datamatics America.
• Consultant; led team of developers for EAI integration between Siebel service and portal billing system while at US Interactive.

Senior Consultant
Confidential, Lake Forest, IL, December 1998 to April 2001

• Senior Consultant for successful design and development and deployment of various package implementations: Siebel, PeopleSoft CRM, Clarify –

Clients- Confidential

• Gained strong knowledge of SDLC processes and project management.

Software Engineer
Confidential, January 1997 to December 1998

• Implemented Scopus and Vantive at customer sites (Cadence Design/Phillips Semiconductor/Kodak Plychrome).

Software Engineer
Confidential, Mumbai, India, January 1992 to December 1996

• Implemented ERP and Sales Force Automation Solutions.