SUMMARY:

• SAP BI, SAP BPC Techno Functional Consultant with Over 9 Years of Experience
• Strong Experience 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.
• Expert level Knowledge of the Back End and Front End Functionality in BPC and BW on HANA
• Worked on End to End Implementation, Upgrade, Enhancement and Support Projects.

TECHNICAL SKILLS:

SAP BPC & EPM (6+ Years): Business Planning & Consolidation 7.5, EPM (10.0/10.1), BADI & Script logicSAP BI (5+ Years): Business Intelligence (7.0/7.3/7.4), ABAP/4, HANA

Reporting Tools: Bex, BO Analysis 2.4, BO(4.0), QlikView

Office Tools: Microsoft Office Suite (Excel, PowerPoint, Access, Outlook, Lync)

Ticketing Tools: BMC, SAP Solution Manager

PROFESSIONAL EXPERIENCE:

Confidential, Fort Worth, TX

SAP BPC Consultant

Responsibilities:

• Client Profile - Client is one of the leading Pharma Company in the World
• Optimized BPC Gross Margin Planning system allows detailed level Brand Planning 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 EPM add-ins for 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 BADI, 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
• Provides Financial Strategic Analyses to Business for Improve Reporting Accuracy
• Supporting 1200+ user community across globe for following Technology EPM, BI/BW, BO Analysis and QlikView dashboard.
• 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, East Hanover, NJ

SAP BPC Consultant

Responsibilities:

• Prepared Complete Business Flow and Designed for Revenue Forecasting, P&L, Capex, OpEX and FTE Solution
• Prepared Financial Data’s for Month End Management Reporting and Planning’s
• 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 EPM Add-ins
• 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 and Retraction BADI for data copy from EPM to BI system
• 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 SP27 and Analysis 2.4 for Excel 2013 & Ad-hoc Report Support for End user
• 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 end to end BPC Applications for following Novartis Business divisions
• 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 Info provider, BI reports like Ageing, Spend, Demand, Balance Sheet, Capacity and etc.
• Provide ERP 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

Confidential

SAP BI Consultant

Responsibilities:

• Responsible for Financial BW Support and Enhancements
• Data load Monitoring using Process Chains for Critical Reports and Trigger Report Managers
• Maintaining Reconciliation’s to verify the data in SAP R/3 and SAP BW after data loads.
• Improve on performance by Creating Aggregates, Compression and Rollup Setups.
• Manage Info Cubes, ODS, PSA, Info Objects, Multi Providers, Info Sources, Data Sources, Open hub and Info Packages
• Manage Bex Query, Web Reporting, Free Characteristics, RKF/CKF, Variables, Structures, Exceptions, Cell definition, Filters, Conditions
• Monitoring Delta Failures & Handling Error Stocks

Confidential

SAP BI Consultant

Responsibilities:

• Developed and implemented OLTP extractions from SAP R/3 using LO Cockpit, Copa, and Generic Extractions. SAP Modules SD, PUR, MM, PP, AA, AR, AP, GL and PCA
• GLPCA and GLPCP table data extracted and loaded. Balance Sheet data was also loaded from Totals table and GL line item data source. Many reports, workbooks, charts created for FI users. Data was used by FI period end closing.
• Developed Aggregates, Compression, Index and Rollups to Improve Query Performance
• Developed Hierarchies and Flat file Datasources and RRI for Summarized Report level to Details Report level.
• Performed BW Transportation of all Objects into BW Production System after Validation in Testing & Development System.
• Developed Info packages and Schedule the Data load Process with Full and Delta update mode
• Worked with Open Hub services and APD for Non-SAP data feed
• Developed Extensively in Creating Exceptions, Variables, Structures, Restricted and Calculated Key figures and Formulas in BEX Queries
• Supported to Business Users During BAT/UAT and Perform Hypercare Support & Perform Transition to Support Team
• Migrated many BEx reports to Microstrategy reports and dashboards.
• Developed and implemented cost controlling data from standard business content, crested WIP reports, variance reports, cost of yield reports and many more.
• Developed and implemented PP data production order confirmation, goods movement for orders, production routing, production order confirmation data and BOM data. They were used for analyzing production order detail like yield, standard cost, order completion, WIP etc.
• Developed and implemented SNC data from SAP SNC module using standard business content enhanced to include more detail. Created report to analyze ranking of vendor based on vendor material alert profile, alert rating for vendor etc.
• Activated standard Business content of Purchasing data, purchasing group data, Purchase order history data and enhanced the DS for detailed data extraction. Reports were created for analyzing vendor, material lead time, on time receipt and spending pattern.
• Created many open hubs to provide data from BW to load into other systems like CRM system (non SAP), BPC system, S&OP system etc.
• Created broadcast scheduled to deliver reports, workbooks, cashing reports at scheduled times to users.
• Worked on Performance tuning of improving the load and read performance by maintaining indexes, partitioning, aggregates, query properties etc.
• Worked on BEx Analyzer. Used Navigational attributes, Filters, Exceptions, Conditions, Jump targets, Variables, Hierarchies, etc.
• Extensively used process chains to automate the process of loading data into data targets.
• Trained the super users and query developers with skills needed to build BEx Queries.
• Activated BW Statistics to analyze BW performance.
• Conducted regular meeting with user to gather the new data requirements, enhancement to data and data validation issues.
• Assigned and tracked all the tasks that were assigned to the offshore member on a day-to-day basis