PROFESSIONAL SUMMARY:

• As a recognized leader in Business Intelligence and Analytics, I have proven track record in setting strategic direction, moving organizations from traditional reporting to advance Analytics platform and self - service model. Working closely with the C Level executives to provide KPI’s, metrics and solutions to improve performance.
• BI Strategy and Road Map
• Build Competitive Analytics platform for Pharma Industry integrating IMS, Orange Book and Medispan information providing the strategic and business development team the advantage to analyze the market, competitors and price alerts.
• Implemented Gross to Net solution for Pharma
• Operational analytics and KPI’s for Manufacturing, Supply Chain, Order Management, Trade Management, Finance and Procurement.
• Implemented Oracle BPM to automate the selection and approval of product pipeline.
• Lead multiple BI projects and Data Governance projects.
• Manage and plan budget for BI team.
• Implemented Oracle Business Intelligence Application (OBIA).
• Vendor management and negotiations.
• Conducted Customer Satisfaction program with internal/external customer feedback and improved delivery process.

SKILLS:

• Excellent people management skills and resolving conflicts.
• Problem solving & Decision Making capabilities and facilitates team discussions.
• Consistently seeking for process improvements.
• Excellent Data warehousing/BI concepts and skilled in implementing end-to-end BI solutions.
• Excellent written and communication skills.

PROFESSIONAL EXPERIENCE:

Confidential

Director, Enterprise Performance Management

Tools: OBIEE+, Tableau, ODI, Oracle BPM, Hyperion, Big Data, IMS, FDA, OrangeBook

Responsibilities:

• Define the strategy/roadmap for Business Intelligence and Analytics
• Self-service BI using Tableau for Supply Chain and Procurement.
• Seeded and implemented the Self-service BI Practice.
• Build Competitive Analytics platform integrating data from IMS, Orange Book, FDA and Price Rx giving the organization a competitive advantage to quickly analyze the market, competitors, market share and pricing analytics.
• Automated the product selection and approval process using Oracle BPM tool, integrating 10 departments’ business process and inputs. Reducing the product selection and approval cycle time by 75%
• Operational analytics for Procurement, Planning, Manufacturing, Supply Chain, Order Management, Trade Management and Finance.
• Implemented Gross to Net process solution for Pharma incorporating all deductions and chargebacks.
• Oracle Financial Analytics and Supply Chain & Order Management.
• Operation Excellence platform to provide the much needed metrics for taking corrective actions.

Confidential

Portfolio Manager, Data Warehouse & Business Intelligence

Responsibilities:

• Execution of Managed Services Model (MSM)
• Strategy building and growth opportunities
• Development and execution of operational Model with On-site and Offshore team
• Manage the DWBI Portfolio with 17 offshore and 5 on-site resources and includes 35 applications on OBIEE+, Data Stage and Informatica tool.
• Created/presented Proposals for new programs
• Manage the cost/revenue for the team and created SOW’s for upcoming projects and resource needs.

Confidential

Manager, Data Warehouse & Business Intelligence

Tools: OBIEE+, Oracle Business Intelligence Application (OBIA), Informatica, DAC, BI Publisher, Oracle Warehouse Builder, SPSS, Discoverer, Business Objects 6.5.1, Oracle EBS, SAP Data Services

Responsibilities:

• Manage/Lead the development team and vendors.
• Manage six applications and 600+ users.
• Budgeting for BI team and capital projects.
• Migration project from OWB 9i to 11g, OFA to Hyperion, Oracle 9i to 11g.
• Implemented Oracle Business Intelligence Applications for Procurement /Finance /Sales /Order Mgmt. and HR modules sourcing from EBS 11.5.10 and EBS 12
• Implementation of OBIEE+ tool.
• Short term and long term strategy/planning for BI team.
• Executed several projects successfully on time and under budget.
• Prepare project charter, planning and cost estimates/budgets for projects.
• Improved the SLA from 60% to 92% in couple of years.
• Reduced the application downtime to less than 2%

Sr. Architect, Data Warehouse & Business Intelligence

Confidential

Tool: OBIEE+, BIApps, Informatica, Oracle Warehouse Builder, Discoverer, Business Objects 6.5.1, Microsoft Project Plan, Tivoli, Oracle EBS, Hyperion

Responsibilities:

• Tech Lead for several BI projects.
• Architecture/Data Modeling for BI/DW
• ETL Development using OWB/Informatica
• Production support and maintenance
• Design and development of ongoing projects
• Enhancements and break/fix of data marts
• Increased data warehouse refresh from weekly to nightly.

Confidential

Data Warehouse Consultant

Tool: Informatica7.1.3, Business Objects XI

Responsibilities:

• Meet with BO users to understand the existing and future reporting needs
• Develop a prototype with new functionality and present to users
• Evaluate BO 5.1, intermediate and BO XI version and provide recommendation.
• Compare with Microsoft Analytics
• Feasibility study for up gradation from BO 5.1 to BO XI

Confidential

Project Tech lead/Architect

Tool: Oracle Warehouse Builder, ERWin

Responsibilities:

• Lead a team of 11 offshore and 3 on-site members.
• Gather and document requirements and review with offshore team.
• Responsible for delivery on time, review Off-shore developments.
• Resource planning and work allocation.

Data Warehouse Architect, Designer

Confidential

Responsibilities:

• Architecting the Data Warehouse from scratch
• Dimensional Modeling based on requirements.
• Lead the Development team and responsible for project delivery.

Developer/Tester

Confidential

Tool: eTrust SSO, Eureka Strategy, Web Olap, eTrust Audit, eTrust Access Control, Cleverpath Portal, iPlanet Web Server, Erwin, Business Objects,, WEB Intelligence 2.6.3, Broadcast Agent, Toad, Visual Interdev, Siteminder

Responsibilities:

• Developing Reports, scheduling and publishing them.
• Implemented security using Single Sign On