Design Lead
Keywords
Skills
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
Project history
09/2019
-
09/2019
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
Solution Architect - Cost and Revenue Planning
Capita BPC S/4 Embedded Project
* 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
Consultant - BPC Optimized for S/4 HANA
ALDI
* 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
BPC Solution Lead Consultant
National Air Traffic System
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
BW Consultant
Manchester Airport
* 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
SME (BPS Replacement Project)
NATS
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
SME and Data acquisition Lead (P2P)
Unilever
03/2012
-
10/2012
BW Lead in an upgrade Project
NATS
06/2011
-
02/2012
BW (Integrated Planning) Consultant
County Council UK
06/2010
-
05/2011
BW/IP (Integrated Planning) Consultant
BP
11/2008
-
05/2010
Design Lead in BW Finance Project
BP
10/2007
-
11/2008
BW/IP Consultant
BP
Local Availability
Only available in these countries:
United Kingdom