- SAP BPC Consultant with extensive Global SAP BPC implementation expertise in Planning and Consolidation areas for over 10 combined years of experience in SAP BPC/BW and SAP S/4 HANA.
- Skilled in reporting and data modeling in SAP BPC, FICO, SD, MM, HCM, CRM, and integrating it to SAP S/4 HANA
- Experience in Cost Center Planning, Profit and Loss Planning, Revenue, Headcount and Gross Margin Planning, Budgeting and Forecasting processes in BPC.
- Developed ABAP programming in S/4 HANA and in native SAP BW for running custom BADIs and K2 Logic.
- Performed project management duties in analysis, design, coding, testing and implementation of SAP development projects and tasks to support key client specific business requirements.
- SAP BPC: 10.1 on HANA (Embedded & Classic)/10.0/7.5 NW & MS
- SAP BW 7.0, 7.3, 7.4 with Composite Providers and Unions; BW Upgrade Projects
- SAP S/4 HANA1709 with SQL Stored procedures, HANA PAL & HANA
- SAP Business Objects Analysis for Office
- SAP ECC 6.0: FICO, FI - GL, SD, MM, HCM
- Tableau 9.2
- QuickBooks Enterprise
SAP BPC / FICO / HANA Consultant
- Managed sales and support for Oracle BI products to existing and prospective customers in Asia Pacific region.
- Implemented sales forecasting, account resource allocation, account strategy, and planning for OBIEE products.
- Working on new configuration for new company for FICO with RTR, MM, FI, SD and WM module as per reference Company. Maintain organization standard as per requirements.
- Developed analytic dashboards in OBIEE, Tableau 9.2 and SAP Lumira for comparison to lead customers toward acquisition of OBIEE products.
Confidential, Atlanta, GA
Principal Lead Consultant
- Led SAP BPC 10.1 embedded Planning and 10.1 consolidation projects on for clients, Confidential and Confidential .
- Performed project management duties in leading requirements gathering, blueprinting, testing and post-implementation support.
- Created complex EPM reports and input schedules using EPM functions, local members, VBA macros, logic script and worksheet logic.
- Working on new configuration for new company for FICO, MM, SD module as per reference Company. Maintain organization standard as per requirements.
- Created BPC security using teams, task profiles, data access profiles from authorization security in BW.
- Wrote and enhanced logic script, business rules, worksheet logic, transformation and conversion files for data loads using BW and non-SAP data sources.
- Implemented pre-process Write Back Pre-process BADIs for writing to parent base level members where script logic cannot be used to perform calculations.
- Worked with Corp FP&A and other senior management to deliver fast-paced complex P & L, Balance Sheet, Cash Flow planning and consolidations implementation.
Confidential, Irvine, CA
BW/BPC Lead Consultant
- Worked as lead consultant to solution SAP S/4 HANA BPC 10.1 embedded planning.
- Extensively worked with finance and accounting team to gather requirements for white board sessions, carried out Proto types and developed functional specifications in blueprint design document analyzing existing budgeting and forecasting processes.
- Worked with business to identify hierarchies for GL Account, Cost Center, Profit Center and alternate hierarchies. Implemented conversion and transformation files from BW to BPC.
- Developed driver-based BPC planning model which summarized at various aggregated levels, using Revenue, Spend, Finance and Headcount Planning data from SAP ECC.
- Developed BW data model and carried out ABAP development for routines to automate data between ECC, BW and BPC.
- Implemented custom BADI development, such as UJD Routine for transforming master data, UJD Writeback for molding the data before updating the Infocube, UJD Custom Logic for transferring source to destination transfer and UJD Retract for retraction from BPC to ECC.
Confidential, Greenwood Village, CO
- Based on business requirements, developed Consolidated Balance Sheet, Consolidated Cashflow, Consolidated Income Statement and Trial Balance Reports out of SAP BPC on S/4 HANA.
- Led Confidential and client-based BPC consultants in creating training manuals and trained the finance team on BPC reports.
- Worked on Currency Translation and interfaces to move data between applications using Logic Script and Business Rules.
- Designed Intercompany Elimination architecture to enable the client to eliminate and carry out the adjustments to produce the IFRS reports.
- Enhanced BPC models, dimensions, master data automations, reports, input schedules, data manager packages, package links, PFF, and DM package automation using Process Chains, Scheduling and
- Customized FI-GL BW Extractors to load actual data for Planning and Consolidation in BPC.
Confidential, Reston, VA
SAP BPC Administrator
- Worked on extensively heavy volume of data between SAP ECC, BW and BPC.
- Worked on Process optimization, BPC 7.5 service pack upgrades, performance tuning, ongoing BPC design, development, dimension property updates and Process Automation support.
- Configured top-sided adjustments to provide adjustments or reclassification across all levels including summary as a separate ledger or category.
- Worked on complex parent level Allocation using custom BADI UJ Custom Logic implementation.
- Worked on BPC elimination and driver based Planning implementation using BPC BADI development, testing and integration testing with Data Manager Packages and Package Links.
- Worked on automating SAP BPC Data Manager Packages, Package Links using Process Chains and Custom ABAP programs to manage automation process.
- Worked on Unit, functional and integration testing of SAP BW, BPC Forecast data, templates development and testing for Rolling Estimates Calculation.
Confidential, Kingsport, TN
SAP BW/BPC Consultant
- Developed Input forms for Revenue and Spend Planning Applications.
- Enhanced existing functionality using VBA macros to deliver custom menu selections, to derive ad-hoc reports for sophisticated financial modeling.
- Build a new rate application and UOM application to support UOM conversions unique to the client.
- Worked with Finance team to identify hierarchies for Account, Cost Center and Profit Center dimensions
Confidential, San Antonio, TX
Senior SAP BPC Consultant
- Generated Liquidity Cash flow forecast templates, applications, reports and input schedules which would allow the end user to compare actual vs. forecast, forecast vs. forecast, and choose different time periods to pull up the reports.
- Designed custom menus, pivot tables and vlookups to enhance existing Excel functionality to allow end users perform advanced analysis on Excel.
Confidential, Wayne, NJ
SAP BPC Consultant
- BPC migration project from 7.5 to 10.0 MS using Life Cycle Management - Transports, Process Chains and Optimization.
- Project objectives were to create new SAP BPC 10.0 Legal Consolidation Model from migrating from 7.5 and to automate external systems of data using DB Connect to develop reports and input schedules in BPC.
- Created Legal Consolidation structure for newly acquired subsidiaries, creating groups and defining hierarchies. Set up business rules for Currency Translations and Intercompany Eliminations.
- Configured IC Eliminations for Consolidations, reconciliations and adjustments.
- Configured BPC Security using Users, Teams, Tasks and Member access Profiles.
Confidential, Tarrytown, NY
SAP BW/BPC Consultant
- Developed SAP BI dashboard, using SAP BI as a data source, Universe Designer and Webi.
- Worked on Vendor Spend Analytics using Purchasing Data Model.
- Performance tuning of BW system, customizing and purchasing enhancements.
- Developed BEx Reports and dashboards for Vendor Spend Analytics, BW Configuration and Revenue Reconciliation and Custom Implementation solution.
- Worked with Confidential Finance team for Cost Center Planning, Profit and Loss Planning, Revenue, Spend, Headcount and Gross Margin Planning in BPC.
- Configured Application Set, Applications, Dimensions, Master and Transaction data loads from key figure model into account based model.
- Customized Data Manager Packages, Conversion Files, Transformation Files, Report Templates and Input Schedules for Adjustments.
Confidential, Verona, WI
SAP BW/BPC Consultant
- Worked with Business users in identifying current “AS-IS” process and then provided a “TO-BE” solution.
- Worked with business to identify hierarchies for GL Account, Cost Center, Profit Center and alternate hierarchies. Implemented conversion, transformation files to load to BPC.
- Customized FI-GL extractors to load actual data into BPC.
- Configured Business Process Flow to automate Planning approval and notification.
- Implemented Performance tuning approaches for Reports and Concurrent Locks.
- Configured Work status to lock the data during the close process.