SAP BPC Lead Consultant
Resume:
SRI HARSHA K
P: 682-***-**** *************@*****.***
OVERVIEW
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
TECHNICAL SKILLS
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
PROJECT DETAILS
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
Responsibilities:
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.
Responsibilities:
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.
Responsibilities:
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
Responsibilities:
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
Responsibilities:
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.
Responsibilities:
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
Responsibilities:
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
Dashboard
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.
Responsibilities:
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.
Responsibilities:
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.
Responsibilities:
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
QUALIFICATIONS
Bachelor’s degree in Technology - specialized in Electronics and Communication Engineering
ACCOMPLISHMENTS
Requirement analysis, Project management, Application design, Strategy and planning
EDUCATION AND TRAINING
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