Sign in

SAP BPC Lead Consultant

Franklin Township, New Jersey, 08873, United States
April 26, 2018

Contact this candidate



P: 682-***-****


EPM Consultant with 8+ years of diverse industry experience in Finance, retail, healthcare and banking Services. Expertise in Financial planning and analysis. Design technological solutions for OPEX/CAPEX, Revenue, Head count, & Investments planning. Integrated planning – Cost Center planning/Balance sheet & PL Planning

Budgeting, Forecast and Rolling Forecast

Functional understanding and end to end implementations in Financial Consolidation

US GAAP, IFRS (Stat. & Management reporting), & SIN GAAP

Knowledge in COREP and FINREP – (EBA reporting), Solvency ii and IFRS 2 reporting frameworks

Consolidation concepts: Foreign Currency Translation, Inter-Company Eliminations

Consolidation of Investments – Investments, Minority Interests,

Goodwill and Reserves management


SAP Business Objects Planning and Consolidation (10.1/10.0 Embedded & Classic/Optimized for S4 HANA)

Design Environment, Models, Dimensionality, data model

Journals, Controls & Business rules, Ownership & Rates Management

Design Script logics & enhancements through Business Add-ins (BADI)

Design Planning Functions/Sequence - FOX scripting

Design HANA views, ADSOs, Composite providers, Aggregation levels & filters

Reporting – Analysis for office 2.5, EPM 10 Add-in & Web Reporting, Tableau

Data – Transformations, Conversions for Master & Transaction records

Design integration of Calculation views/Info providers/queries in HANA to BPC

Design real time consolidation/business planning views in S4 & integration to BPC

Work flow – Business Process Flows, Security/Analysis authorizations & Transports

SAP Business Objects Analysis for Office, BEX Query Designer

SAP Business Objects Financial Consolidation (Version 7.5 & 10 based on HANA)

Dimension & Scope management

Category management – Accounts, Flows, Business Controls/Validations and Formulae

Business rules, Schedules & Journal templates

FX rate tables, Conversion and Tax rate table management

Security, Work status, Operational Cycle management (Period Closure)

SAP Inter-Company Services, Financial Information Management

SAP HANA – Modelling concepts, Data migration, System adaptability for BPC and BFC

Downstream applications

SAP BI/BW – Administration – Modeling & Transport management

SAP FI CO – General ledgers, AP/AR, Cost center accounting, costing, profitability analysis

ETL - SAP Data Services and Extended Analytics

Vast experience in requirement gathering & customer Interactions

Involved in four full life cycle implementation & Support project in SAP BPC/BFC and BO Web Intelligence and Dash boards


Johnson & Johnson (WW BPC Reporting) Piscataway, NJ Oct 2017 - td

Manufacturer of Medical Devices, Pharmaceutical & Packaged goods leading as 2nd largest group of US in terms of revenue. BPC reporting system E/AMS with integration to JDE/EDW & support the financial planning, Analysis & Closure process


Designed data flow architecture from source systems JDE/EDW/Work day

Structural mapping and conversions of master to BPC

Designed scripts to handle Currency conversion without business rules

Achieved elaborated reporting capabilities on total number of product units sold based by different packet size through conversion of Product units to Single units

Designed script logic –

- Copy tax account data from No channel to Distributor Entities

- Automate adjustments for OCNIS (Other Costs not in standard) to the departmental expenses on Quality Assurance/Check

Provided EPM Add-in Input schedules/Forms for data collection related to Adjustments/Tax/Depreciations

Enhanced User experience on EPM reports for P&L, BS and standard comparative reports through VBA based APIs

Allergan (Embedded Consolidation BPC 10.1) Rockaway, NJ Jun 2017 – Nov 2017

Pharmaceutical industry decommissioning their BPC 10 MS version of Planning & Consolidation system and focusing to implement Embedded BPC on AWS cloud to align with the future migration strategy of S4HANA and Strategic Reporting system.


Conducted brainstorming sessions to align Planning and consolidation implementation with future S4 Finance system

Designed HANA views of ACDOCA & ACDOCC structures and integrate data layer from ECC

Built real time info providers and aggregation levels for Exchange rates, Ownership rates and Consolidation data

Built Composite providers to consume Historic & ACDOCA data for consolidation

Constructed multiple composite providers to ease business user reporting requirements

Built reconciliation reports for Currency rates & Master data maintained in ECC tables through virtual providers

Prepared Functional and technical specification documents for BCF, Currency translations, IC Eliminations & Consolidation of Investments, Work status, Security & BPF

Built business rules and task sequences for Carry forward, Currency translations, Eliminations

Achieved retained earnings calculation through account transformation rules

Designed logics for computing P&L to RE via Journal Entries by planning functions – FOX scripts

30%-time reduction in closure cycle through simpler, faster, automated controls and validations to check and enforce data consistency at entity level

Designed Journal templates, allowing Group Accountants and Controllers to enter adjustments at entity/group level through journals at site

Delivered seamless integration of business teams and processes through Business process flows and work status, providing data locks after each financial process

Designed input queries in BEX and skull templates for reporting financial statements – Balance sheet, Income statements, Statement of Equity, Cash flows with drill down at PC

Built calculated key figures for management reporting

Captured consolidation team structure and implemented analysis authorization to restrict users based on their role in reporting system

Designed data access profiles and teams to provide User community with right data set and execution authorization level

Conducted workshops to demonstrate the reporting features and flexibility for Excel based add-in Analysis for Office

Consumed functions, calculations, cell based formatting, variable passing, filters, conditional formatting to enhance User experience with AO reports and input forms

Project Pegasus (Duty Free Shoppers) Los Angeles, CA Jun 2016 – May 2017

Role: BPC Senior Consultant

Tools used: SAP BPC 10.1 (NW), SAP HANA

Requirements: Duty-free shops are retail outlets exempted from the payment of local or national taxes and duties, on the requirement that the goods sold will be sold to travellers who will take them out of the country. DFS Group holds 90 entities and needs a robust solution to address a speedy, easy and simple platform to close their consolidation cycle.


Involved in process and functional design activities

Built Environment with Consolidation, Ownership and Rates model

Modeled data structures and dimensions for Consolidation model

Implemented standard SAP extractors for data collection from ECC

Created Data migration packages to import data from legacy consolidation system ECCS

Achieved Non-SAP systems data collection through Input templates and Free forms

Design data transformation and conversion from ECC to BW on Hana and then to BPC

Involved in designing Consolidation Reports BS, P and L, Product based Revenues, Cash Flow statements with drill down functionality

Implemented Legal consolidation based on US GAAP & SIN GAAP

Ownership Management & Consolidation life cycle management

Designed Business process templates for corporate data collections and validations

Built Business rules for Foreign currency translations, Intercompany matching, Intercompany eliminations, Investments & Cash flow statements

Designed Script logics and Business rules for baseline calculations and derivations

Designed free forms for collection of Travel expenses based on Profit centers, class, period, Employee designation, trip, cost of air fares, meals, conveyance & lodging including adjustments with the vendor funding

Built input template to collect the POS mark ups, discounts, client services, merchandise, marketing and other allocations in the budgeting

Built template to collect CAPEX projects based on asset class, useful life, depreciation start date and end date not available from the source system

Designed occupancy cost planning based on concession fee, Ground and facilities rent expenses and distribute (allocation) to the shops

Designed scripts and calculations to generate reports on operation expenditure by consumer marketing, FPA and business administration including baseline adjustments/calculations and payroll costs

Designed sales planning based on retail sales by metrics – nationality by channel and retail sales by Shop, allow adjustments and review allocations by product category as a break down. Achieved data integration through flat file data source for Sales info

Configured application level security through member access profile, task profile and teams to restrict users as per management and business team structure

created Journal template for Consolidation Model, allowing adjustments through JEs

Maintained and tuned parameters for smooth application performance

Scheduled daily lite optimization to improve the reporting performance of the application

(AFRS project) - Miller Coors Chicago, IL Feb 2015 – May 2016

Role: BPC Consultant

Tools used: SAP BPC 10.1 (NW), SAP HANA

Requirements: Miller Coors was a joint venture between SABMiller and Molson Coors Brewing Company since ‘07. Miller Coors had implemented Planning and Consolidation package solution for preparing, and reporting their Financials. Planning, Budgeting, Forecasts and Consolidation were implemented in various phases


Gathered Business requirement to understand their core business operation model and built planning, budgeting solutions

Configured system to compute asset planning based on the depreciation class and asset type in CAPEX planning

Designed Cost estimates and allocation logics for the Revenue planning based on LOBs

Built OPEX planning model with break down reporting based on plant and division

Designed technical data flow and business user data collection process via process flows (Input templates and data loads)

Built Dimensions & Models and their master data maintenance

Built Input schedules and complex EPM input sheets for data collection based on

Brand, Segment, Product & their CCs

Built Data Manager Packages for both Master data and Transaction data loading

Designed Logic Scripts for computation from Cross reference models

Designed Formulae for KPI calculation based on dimensional values

Built business rules for

Account transformations & Currency translation

Elimination of intercompany transactions & Elimination of Internal Dividends

Consolidation of Investments & Minority Interests

Developed Business Process Flow (BPF) Templates for each business operation

Security setup for Users and assigning them to the respective teams and access groups

Audit Log and Work status configuration to adhere local governing Compliances

Conducted User training on BPF, Free forms and data packages

Change/Incident/Knowledge management

Applied Materials Santa Clara, CA Feb 2014 – Feb 2015

Role: BPC Consultant

Tools used: SAP BPC 10 (NW)

Requirements: Applied Materials, Inc. is the global leader in materials engineering solutions for the semiconductor, flat panel display and solar photovoltaic (PV) industries. Technologies developed by them help make innovations like smart phones, flat screen TVs and solar panels more affordable and accessible to consumers and businesses around the world.

They have diversified business lines in Material Engineering and deliver products and software services to the consumer market. To sophisticate their business model with refined planning strategy and Top level operational facilitation in Financials was the core aspect of this project delivery


Involved in process and functional design activities

Involved in developing the Sales Planning Model to report on their business targets

CAPEX and OPEX models to deliver their Organizational financial operations

Developed Head count planning model for Human resource management

Designed and developed Reports & Input Schedules using EPM PANE and other EPM Functions like EPMsaveData, EPMRetrieveData, EPMComment, EPMdimensionOverride, EPMcomparison, EPMurl etc.,

Involved in designing financial planning reports with standard planning functions Spread, trend, weight in Sales planning based on product by segment and region

Designed input sheets for resource planning based on new & old contract, Full time resources and their cost by grades

Designed input forms for Revenue planning based on the comparative data from actuals

Involved in designing Consolidation Reports BS, P and L, Product based Revenues, Cash Flow statements with drill down functionality

Business process templates for corporate data collections and validations

Designed Script logics, BADIs and Business rules

Security configurations for member access profile, task profile and teams to restrict users as per management and business requirement.

Designed and developed Templates as per business requirement.

Involved in Data management and loading of data into BPC using the DMP, transformation, conversion logic files

Insurance DRS - Lloyds Banking Group London, UK Nov 2012 - Jan 2014

Role: BFC Consultant

Tools used: SAP BO Financial Consolidation, FIM, EAD (Extended Analytics)

Requirements: Scottish Widow Group which is a subsidiary to LBG dominantly provides services in Insurance domain. To meet the regulatory reporting requirements constituted by the Banking authorities, Lloyds Bank required financial reporting specific to Insurance division.


Team member of the Technical implementation of Insurance reporting & Solvency II reporting requirements

Built new dimension walk category to stimulate the function of audit id dimension

Designed Data model for COA, AC families and flow behavior of Insurance accounts

Designed business rules to re-classify the objectives of Solvency ii

Capital Adequacy ratio

Deferred Acquisition Costs (DAC)

Deferred Organization costs (DOC)

Deferred Taxation effect

Current Taxation effect

Net Technical Provisions

Built Blocking formulae with pseudo calculations, complex data mappings

Mapped IFRS consolidated data to Insurance Units along with balance carry over functionality

Involved in building Technical category scenario version for the data management from the existing implementation

Category Scenario: Account Management, account families, flow setup, formulae for intermediary calculations and controls for data validations

Achieved break down reporting through Dimensional Analysis configuration and provided breakdown analysis bases on Partner, Share, Maturity and Geography

Involved in building business rules for account transformation

oData extraction from IFRS consolidation (Technical consolidation)

oLegal entity transfers

oData transformation to Walk Category audit ids

oForeign currency conversion into Group currency

oProvisional Eliminations, Intercompany Eliminations, Dividends

oElimination of Investments, Handling investments in JV

oGoodwill and Minority interest reclassification

Designed scope for the portfolio management and organizational structure

Involved in creating input schedules and output reports linked to Enrichment schedules

Created style books for cosmetic and standard reporting structure in schedules

BP Re-Engineering (HCL Technologies) Bangalore, India Jan 2012 - Nov 2012

Role: BPC/BO Consultant

Tools used: SAP BPC 7.5 (NW), SAP Dashboards

HCL Tech has adopted SAP BPC as the reporting solution for consolidation


Maintained dimension members, properties, developing input schedules & reports

Maintained dimension hierarchies, dimension Member formulas, creating and using Scrip logic through default logic

Designed transformation and conversion files to load data from SAP and Non-SAP systems

Designed real time info providers for foreign exchange rates and ownership rates

Maintained process chains and data extractors for SAP transaction data load

Maintained transformation routines including enhancement routines for complex data mapping requirements in BW to filter, pad data for both master and transaction records

Executed account transformation program to verify cash flow statement in LC

Uploaded ownership data of reporting period from flat file in ownership application

Executed Ownership calculation program for required period and verify ownership data

Uploaded exchange rates for the period from BI info provider and verify exchange rates

Customized and implemented reports based on Schedule 6 IAS structure

Involved with management team to gather requirements from Finance controllers and Corporate Leads

Maintained system security to users and user groups by application level security and dimension level security

Supported on Input templates architecture and providing analysis using Quick-Adhoc reports

Interaction with the team, users to get the desired inputs

Designed Work status and process flows with input templates integrated


Created Live office and access database connections

Provided connectivity for dashboard to BW through Open Hub Services

Achieved Maximize option for charts without panel set option

Used components like selectors, cascading prompt, and drill down options

Radio buttons, check Boxes, Image components, dynamic visibility

Achieved data retrieval from multiple tables and sheets in Excel with functions like DGET and other operating formulae

Various charts, single valued displays, Alerters, containers

Used play selector, Ticker, conditional hiding

GDRS, FINREP & COREP - Lloyds Banking Group London, UK Sep 2010 – Jan 2012

Role: BFC Consultant

Tools used: SAP BO FC, FIM, EAD (Extended Analytics)

Requirements: Group and Divisional Reporting system facilitating the consolidation based on IFRS (International Financial Reporting standards). The Concept of Group and Divisional reporting is to collect the financial information from the Base/Divisional level office which is part of an integral Legal Entity. Consolidation is done at the Group Level and the break down analysis and Data analysis view is visible from the Base reporting Unit.


Dimension builder:

Built dimensions, characteristics and properties involved in reporting

Master data management as per the business requirement &

User defined dimensions, characteristics and properties for granular level of data analysis based on the business requirements

Designed new schedules based on User requirements and enhancements

Change management related to

Restatements & Currency translations

Elimination of intercompany transactions & Consolidation of Investments

Created Dimensional Analysis providing breakdown analysis bases on product, Maturity, Geography and Loan Quality

Category scenario:

Chart of Accounts – Inclusion of new accounts and their maintenance

Account families – Inclusion of new account families and initialization, planned on upcoming project requirements

Flow behavior – flow setup and validation

Controls – if any corrections or requirements in controls/validations

Created new formulae if required with the new accounts or any changes in properties/characteristics related to the existing accounts

Analyzed the organizational structure based on the investments and building the hierarchy with the Scope and setting up reporting units that participate in consolidation

Analyzed and configured the Incoming and outgoing Reporting units in the Scope

Configured the Business level authorization groups for Data Access

Created new DAG filters based on the access level required by the Users providing, read/write option to the system level objects like package and Consolidation

Package Amount Trace maintenance for tracking the deltas

Data Model updates, Incident management, Change management

Transports to other environments

Performance tuning

Archived the logs in regular periods to improve the database performance

Deleted un-used version of consolidations &Task group archiving

Operational cycle

Setting up Reporting IDs, Reporting Units

Package management – Publish and integrate

Master data for RU’s in ICS for IC matching & reconciliation

Scheduled the tasks & task groups to automate the consolidation process

Leo Pharma Bangalore, India Jun 2009 - Sep 2010

Role: BPC Associate Consultant

Tools used: SAP BPC 7.5 (NW), SAP BI7, Xcelsius

Requirements: Leo Pharma is a global Pharmaceutical and chemical company which has branches and plants established in over sixty-one countries. Leo Pharma is implementing Excel in financial department as the new budget and planning.


Involved in requirement gathering from client’s super user and financial controller

Understood and Analyzed Business Requirements for Financial Budgeting & Planning

Developed the Application set, Applications, and Dimensions for the planning system

Maintained dimension members, properties and developing input schedules and Reports

Maintained Dimension hierarchies, Dimension Member formulas, creating and using Scrip logic through default logic

In BPC- Excel, Created Budget Input templates for Policy Sales, Channel Expenses, Capital Expenses, Product Expenses, Headcount, Payroll and Project wise Income Analysis template using EVDRE Grids and EVDRE formulas

Developed variance reports for Income, Expenses, Assets, P&L, and Balance sheet, KPI trending analysis report and “What if” analysis and Drill down, Drill through reports

Developed and Configured Business Process Flows and setting Approval processes

Set up system security to users and user groups by Application level security and Dimension level security, Work status settings and linking them to input templates

Data manager functionality and loading data using data manager packages

Maintained the exchange rates in the rate application for currency translation

Implemented currency translations to support for foreign division

Web reporting (Spansion Inc.) Bangalore, India Feb 2009 - Jun 2009

Role: BW/BO Consultant

Tools used: SAP BO 3.1 Web Intelligence, Xcelsius 2008, SAP BI7

Requirements: Spansion Inc. is an American-based company that designs, develops, and manufactures flash memory, microcontrollers, mixed-signal and analog products, as well as system-on-chip (SoC) solutions. Spansion required web reporting tools to meet their market competence. Reporting objectives where to publish trend and analytical information with their internal management team.


Developed offline charts with SWF features

Designed connectivity with Access database via live office and ODBE connections

Developed Charts, Tickers, alerts and Scroll Bars for the graphical presentation of SM Dumps

Projected KPIs related to solution dumps in the Sales and Procurement cycle

Automated the process of data extraction from Business Warehouse to Access database via open hub file services and connect it to Xcelsius

Designed Web Intelligence reports to distribute projections of both Sales and Procurement cycle

Utilized Page formatting, Page breaks, print options, Variance calculations and in sheet formulae etc., to provide better visualization

Developed reports with filters at both report and query level and facilitate Users & administrators to tighten data accessibility

Maintained roles, User profiles and systems & their server partitions, job maintenance in Central Management Console


Bachelor’s degree in Technology - specialized in Electronics and Communication Engineering


Requirement analysis, Project management, Application design, Strategy and planning


SAP Business Objects Planning and Consolidation

Workshop on consolidation and aspects of ICAW, Efficiency and Strategic Planning module

SAP Business Objects Financial Consolidation

Classroom training from SAP on Consolidation, Intercompany, EAD and Financial Information management

SAP BI and SAP BO Web Intelligence, Xcelsius (Dashboards) – Internal Boot Camp

SAP Data Services & SAP FIM – Internal Boot Camp

Modules: Consolidation, Business Planning and Financials, SD.

Presentations: People Process Execution, Presentation on Seven Habits of Highly Effective People

Contact this candidate