We provide IT Staff Augmentation Services!

Sap Bpc Lead Resume

SUMMARY

  • Specializing in SAP EPM business module SAP BPC 7.5 NW, 10.0 NW, 10.1 NW and SAP BI - BW 7.0, 7.3, 7.4.
  • SAP BW Professional has vast Experience to deal with Business analysis to system design, application development and implementation.
  • With over 7 years of IT experience of which 4+ years of SAP BW experience, 5+years SAP BPC and one year of SAP BO experience in Implementation and Production Support.
  • Have successfully delivered 6+ SAP BW/BI solutions, 5+ SAP BPC Planning, Consolidation and Forecasting solution.
  • I have nearly 6 years of hands on working experience on various BPC implementations. Possess four projects (with multiple complex BPC applications) strong end-to-end implementation project experience in SAP BPC.
  • Have successfully implemented BPC optimization and reduced IT cost by 50% from 5 FTE to 2.5 FTE
  • Developed good number of simple and complex Input Templates and Reports using EPM functions by working closely with Senior Solution Architect & Business Process Owners.
  • Provided key support during Blueprinting, Realization, Data loading, Unit & User Acceptance Testing and end user training.
  • Prepared Technical specifications, Unit testing documents, & supported in preparation of user training manual.
  • Worked closely with ABAP on BADI development giving functional specs, test data, & taking complete ownership of development / testing. Got developed very complex business logics, & movement of data across different models.
  • Good strong experience on integration of SAP BPC NW 10 with SAP BI-BW 7.3
  • Strong knowledge & experience in writing all types of Script logics according to the Business needs.
  • Created complex BEX reports, created crawl, trend analysis report. Built many KPI reports and dashboards for upper management.
  • Converted BEx reports, workbooks to Business Object Analysis for Excel.
  • Trained the super users and query developers with skills needed to build BEx Queries, EPM 10.x reports, WEBI reports, BO Analysis Excel.
  • Worked in application areas like SD, MM, PP, and FI/CO. Expertise in Data Modeling using MDM and BW extended star schema models.
  • Undergone Implementation and rollout in a Global company with multiple marketing organizations in Europe, Asia Pacific and America.
  • Managing all phases of project from Blueprinting, Configuration, Development, Integration Testing, Cutover, and Training to Go Live.
  • Proficiency in on call support for monitoring system, monitor Process chains and resolving the tickets in a timely manner.
  • Managed a BI team from operational prospective meeting Internal and external SLAs.
  • Managed projects to ensure that deliverables are met within schedule, budget and quality.
  • Experience of working in a big team and a true team player with excellent inter-personal skills under demanding and challenging situations.

PROFESSIONAL EXPERIENCE

Confidential

SAP BPC Lead

Responsibilities:

  • Client Profile - Client is one of the leading Pharma Company in the World
  • Optimized BPC Gross Margin Planning system allows detailed Brand level planning (Strat, Budget and Forecast) of the following areas & Reduced Operations cost from 5 FTE to 2.5 FTE
  • Sales & Cogs, Advertisement and Promotion, TPC(Strategic and Consolidated), Equipment Base
  • Optimized B3 planning models i.e. Full Planning, Units and Sales planning and Sales only planning
  • Optimized on different planning and reporting levels i.e. Market level planning but Entity level reports
  • Optimized on different level currency conversion i.e. Market level currencies and Entity level currencies
  • Optimized MDX, Write back BADI for allocation, SQE BADI to Calculate Roll-Ups and Custom BADI for Calculated KPI’s
  • Designed Different level templates and Scripts logics for Key Product, Non-Key Product, Advertisement and Promotion, P&L, Disbursed, Non-Disbursed Sales and Market data actualize, TPC & SPC
  • Key components of project objectives are
  • Select Key Brands, Planning Sales by Brand, Adjusting historical Market data
  • Calculating and Adjusting Non Disbursed Sales, Planning Non Disbursed Total Product Costs
  • Assigning Brand and Market combinations to Entities, Planning Advertising and Promotion costs
  • Tracking installed surgical Equipment
  • Prepare Financial Data’s for Month End Management Reporting and Planning’s (Extraction & Retraction from BW and BPC)
  • Provides Financial Strategic Analyses to Business for Improve Reporting Accuracy
  • Supporting 1200+ user community across globe & Enabling weekly planning
  • Designed and created new entity hierarchy, which aided in viewing more than 100 legal entities arranged per new business area process. This helped in users to automatically roll up the entities per new business area process instead manually building the structure for many reports and workbooks.

Confidential

SAP BPC Lead

Responsibilities:

  • Prepared complete process flow and Design for Revenue forecasting, P&L, Capex, OpEX and FTE solution in use. These solutions are used for Planning, Forecasting and Consolidation.
  • Prepared Financial Data’s for Month End Management Reporting and Planning’s (Extraction & Retraction from BW and BPC)
  • Provides Financial Strategic Analyses to Business for Improve Reporting Accuracy
  • Works closely with Business to track the Budget and Actual Spending for Capital, Assets and Expenses.
  • Interface with Business and Site Owners to Reconcile & Review Financial Data
  • Configuring and Scheduling Data Manager packages through BPC for Office
  • Build and Maintain Dimensions (Members, Hierarchies, Properties, Dimension Formulas)
  • Develop and Manage - Transformation, Conversion, Package, Script logic, Formulas, BPF, Work Status, Formatting
  • Develop and Manage Top Down and Bottom Up Planning for Allocation on Cost by BADI’s
  • Solution Provided to Map WBS/IO/PO with Corresponding Projects in BW/BPC and Reduced Super user Manual efforts
  • Perform Detailed System/Reporting Analyses & Develop Functional & Technical Specifications for Improvement
  • Develop Financial Reports and Templates in BPC by using Local Members, Dimension Overwrite, Sorting and other EPM Function Based on Business User’s Requirements
  • Develop BW/BO Data Model for Reporting Financial Data’s including BPC Planned Data’s
  • Perform Testing on HANA Upgrade & Service Packs &Trace BPC logs to Maintain System Performances
  • Developed a new process to increase the single data load from BW to multiple data loads during the period close to aid the business in efficiently performing planning and Consolidation cycle.
  • Designed & developed Reports that provide the Business users with the plan/Actual data.
  • Developed Input templates Maintain Enrolment, New business driver, Input grade planning label, Track state adaption, Capture residual budget/Forecast by state for Sales Ops and Input territory forecast for District managers.
  • Developed revenue summary, revenue Vs Market, Sales channel spread, forecast report workbook, Monthly Spread and Forecast review reports.
  • Deployed the EPM Add-In for Excel 2013 & Involved upgrade from 7.5 to 10 version
  • Modified existing data model by adding new dimension and the data in the Fact table updated to with new dimension values.
  • Developed a new environment in development and granted restricted access to users for analyzing different scenario before implementing them in production.

Confidential

SAP BPC Consultant

Responsibilities:

  • Developed Four Different BPC Applications for Confidential Business
  • Research Unit, Sales and Operations Unit, Warehouse & Distribution and Technical Operations
  • Developed Different Level Planning - Cost Center, Cost Center Group, Cost element, WBS, IO, PO, Brand, SKU and Batch levels
  • Developed Steering Model to Control Dimension Members to Activate or De-Activate for planning cycles
  • Developed Custom and Write back BADI for Top Down Planning and Allocations, Script logics for various Business use
  • Retract BADI for Plan data retraction from BPC to BW layer for financial BI reporting.
  • Developed BW currency conversion for BPC plan data using BADI’s
  • Configuring and Scheduling Data Manager packages through BPC
  • Perform Detailed System/Reporting Analyses & Develop Functional & Technical Specifications for Improvement
  • Develop BW/BO Data Model for Reporting Financial Data’s including BPC Planned Data’s
  • Perform Testing on HANA Upgrade & Service Packs and Trace BPC logs to Maintain System Performances
  • Responsible for Various Financial Functions, Budgeting, Forecasting and Financial Modeling in BW and BPC
  • Review Client systems, Structures, and Processes to Identify where Improvements can be made to Enhance Operations
  • Manage BPC admin roles and trigger monthly planning’s by using BPF, Work Status, Securities
  • Develop Report in BI on top of BPC Infoprovider, BI reports like Ageing, Spend, Demand, Balance Sheet, Capacity and etc.
  • Provide ERP Training to Business users and Operational team to Gain BW and BPC Knowledge across the Divisions
  • Develop Ad Hoc Report and Process Chains for Business User to Trigger the Data Extraction from OLTP to OLAP System
  • Perform Data Validation between BI and BPC to Reduce Risk for Smooth Month End Closure
  • Identified, designed and developed custom info Objects and hierarchies.
  • Design & Developed acquisition, integration and reporting layer data providers such as Info objects, DSOs (write optimized, Direct and standard), Cubes (standard), Infoset and Multiproviders
  • Designed several BEx Reports for Free Characteristics, Calculated & Restricted Key figures, Filters, Variables and Exceptions
  • Designed Process chain to automate the data load process for new Marketing data
  • Managed client expectation and ensuring on time and quality deliverable from on site and offshore

Hire Now