10 years Finance & Accounting process consulting, including planning & forecasting, finance/controlling, regulatory rate making and reporting, enterprise performance management, and finance transformation
Technical skills and experience include configuring, modelling, scripting and developing in SAP Business Planning & Consolidations (BPC), SAP Business Warehouse, Business Objects (BOBJ), SAP ECC Finance & Controlling (ECC FI/CO)
Min 3 full lifecycle experience for implementing SAP BPC Solution as a Solution architect or BPC lead
Excellent communication and client handling skills
Functional and process knowledge in below areas:
Financial planning, rolling and continuous forecasting:
Financial consolidation and forecasting in the areas of: cash flow, cash flow automation, balance sheet, income statements, revenue and gross margin, statistical methods, driver based planning, scenario planning, headcount and payroll distribution, cash reserves, variance reporting, enterprise consolidation, elimination entries, intercompany data flows, equity capture, contribution distribution, cash available for distribution, foreign currency translation, multi-company experience (multiple entities and ownership structures)
YieldCo accounting, cross company revenue sharing, ownership share percentages,
Establishing master data, creation of planning versions, definition of hierarchies for accounts, cost center, company codes and profit centers
Various forecasting techniques including what-if scenario planning, predictive analytics, cognitive, machine learning, robotics, blockchain, etc.
Preparation of ready to file regulatory rate case documents
Calculates retail separation factors, rate class and functional level cost of service
Planning ledger forecasting methodologies developed to assist in forecasting at detail FERC/GAAP Accounts
Translation of business requirements into technical solution and hands-on configuration, data modelling, BPC scripting experience, HANA stored procedures, calculations and report writing