AJAY SARIN available


Design Lead, Consultant - BPC Optimized for S/4 HANA, BPC Solution Lead Consultant

Profileimage by AJAY SARIN Design Lead, Consultant - BPC Optimized for S/4 HANA, BPC Solution Lead Consultant from
  • Freelancer in
  • Graduation: not provided
  • Hourly-/Daily rates:
  • Languages: k.A.
  • Last update: 05.09.2019

You need an account to view this information.

SAP Analytics, S4 Hana, R/3, BW, SAP HANA, Core, OLAP areas of SAP, BPC, Interface, UAT, HANA, Interfaces, Microsoft Dynamics, CRM, ABAP, requirement gathering, extractors, test scripts, Data warehouse, P2P, SAP, CSC, Embedded, BPC 10.0 Simplified, BPC 7.5, (IP), BPS, Data Staging & Extraction (BW 3.5, 7.0, 7.1, BW 7.4 & BW 7.5, Authorizations, SAP BW, BEx, Web Reporting, Office for Analysis, Data Warehousing, SAP HANA Studio, ERP
  • 09/2019 - 09/2019

  • Design Lead
  • BAE maritime services: S4 HANA, BW 7.5, BPC 10.1 Embedded Implementation for Business Resource Planning (2018-01: 2018-11). Role: Design Lead * Participated in Blueprint Sessions within the area of Demand and Supply Planning * Produced Blueprint document, Functional and Technical Specifications * Design Data flows for master and Transactional Data Interfaces from Microsoft Dynamics (CRM) using Business Object Data Services. * Extract, Transform and Load from various S/4 modules such as PS, PP, QM and HR. * Integration of Actuals and Plan data into monthly Forecast, Plan and Scenario Versions * Configure/Built Input Templates to provide planners an ability for updating Forecast and Plan data * Key functionalities such as Period Movement, Volume Percentage Change, Change Classification provided to model various scenarios in the area of Demand Planning were provided within the Input Templates * Ability to apply of Joiners and Leavers (Gains and Losses) assumptions on the existing employees (in SuccessFactors) to generate forward projection was provided in the Supply Planning area via ABAP Based Planning Function * Designed and built Demand Vs Supply Reports using toolset such as AFO and Lumira.

  • 12/2018 - 07/2019

    • Capita BPC S/4 Embedded Project
  • Solution Architect - Cost and Revenue Planning
  • * Design and build solution to transform project into a financial plan * Interface with Commercial Project Management for RA (Revenue) & Costs * Interface with RAR Module (Revenue) * Build Attribute, Analytical and Calculation views to generate transactional and master views of the data to embed into Composite Provider for further analysis and planning. * Adjustment of Cost via AFO Input templates * Generate P&L, Balance Sheet and Cashflow components for feeding into Financial Plan * Components such as A/R, A/P, Bank (Cash Paid, Received), Accrued Income/Expense generated based on Billing, Revenue and Expense Line using FOX Code * Built Version Management functionality for generating Forecast Versions from prior versions * Ability to reconcile Source and Target Version via AFO Reports * Configure Business Process Flows (BPF) to approve data, prior to submitting * Configure Work Status / Data Slices to lock forecast version * Design Security Roles and Data Authorizations to allow access to specific functionality. * Participate in show and tell sessions as part of the Evolutionary development process. * Enhance configuration and migrating into UAT System

  • 09/2017 - 12/2017

    • ALDI
  • Consultant - BPC Optimized for S/4 HANA
  • * Configure and present proof of concept in P&L Planning (Rolling Forecast and 5 Year Plan) during blue-print phase. * Remodelling Financial Models in S4 Hana to cover various scenarios as outlined in Requirements. * Configure the Financial planning templates delivered in BPC optimised for S/4 HANA * Distributing GL data at Cluster Level based on Previous Year * Plan at GL Group (disaggregate the plan value to GL Account Level) * Adjustment to Plan Data * Applying percentage on Actuals to generate Projections * Setting up Rolling Forecast Template * Build AFO queries that allow users to: * Analyse Actuals * Compare Plan vs. Actuals * Compare Plan vs. Actuals YTD

  • 01/2017 - 08/2017

    • National Air Traffic System
  • BPC Solution Lead Consultant
  • Planning Role: BPC Solution Lead Consultant * Responsible for project execution across the complex landscape * Responsible for budget management including the identification of estimates * Responsible for people management on the project including schedules and interim assessment of the progress. Providing key inputs to PMO for preparation of Month End Management Review meetings * Actively engaged with the business for requirement gathering and writing blueprint to manage Demand and Supply for ATC Operational Staff at NATS * Involved in writing technical specification to build the solution * Driver based Planning was delivered that would maintain the Gain and Losses Assumptions the AFO Input templates * An ability to generate Demand Plan based on data sourced from Activity Plan and Master data attributes * Analysis Reports to provide gaps and provide balancing between Demand and Supply Planning tool * An ability to generate and compare scenario plan to perform what-if analysis based on changes to the scenario assumptions were also provided * Actualisation process was also developed to integrate BW Actuals into the planning process while generating a rolling forecast * Involved in building and executing the cutover plan and smooth transitioning to the offshore team. .

  • 04/2016 - 12/2016

    • Manchester Airport
  • BW Consultant
  • * Build and Design of various Planning Models such as Operational Staff Cost, Operational Non-Staff Cost and Revenue. * Designing and building Models, Composite Provider, Workbooks, Custom Planning Functions and Input Templates * Built data flows for Project Costs to load Actual and Budget (using 0CO_OM_WBS_6 and 0CO_OM_WBS_6 extractors), New GL Balance (using 0FI_GL_12), New GL Item (using 0FI_GL_14), FTE (using 0HR_PA_1), Payroll (using 0HR_PY_1), Account receivable (0FI_AR_4, 0FI_AR_6). * Involved in building complex reports using AFO in AR, Finance, Passenger and Car Park Information. * Involved in performing testing activities including building and executing test scripts * Work with end user on completing the UAT

  • 01/2015 - 02/2016

    • NATS
  • SME (BPS Replacement Project)
  • Planning Role: SME (BPS Replacement Project) * Part of blueprint phase of the project, running workshops, gathering requirements and writing key sections of the blueprint for one of the main planning areas * Formulated Proof of concept in variety of Planning Areas (Activity, Headcount, Asset Depreciation, Workforce Planning and Service Lines) during the BluePrint Phase * I was involved in setting design & development standards and directing planning team members on various aspects of Planning * I was involved in prototyping, developing and configuring Input templates, Workbook & Custom Planning Functions (for Service Line Allocations and Currency Conversion / Translation) and guiding team in their areas of work. * I undertook the SIT Management of the whole project, few of my responsibilities included management through daily meetings, developing plan of action for the team and reporting stake holders on the progress.

  • 11/2012 - 12/2014

    • Unilever
  • SME and Data acquisition Lead (P2P)

  • 03/2012 - 10/2012

    • NATS
  • BW Lead in an upgrade Project

  • 06/2011 - 02/2012

    • County Council UK
  • BW (Integrated Planning) Consultant

  • 06/2010 - 05/2011

    • BP
  • BW/IP (Integrated Planning) Consultant

  • 11/2008 - 05/2010

    • BP
  • Design Lead in BW Finance Project

  • 10/2007 - 11/2008

    • BP
  • BW/IP Consultant