Finance Analytics & Planning Architect / Lead
AstraZeneca
Keywords
SAP Cloud
SAP Applications
SAP BI Accelerator
SAP NetWeaver Business Warehouse
SAP HANA
Sap Business Objects
Sap Fiori
Data Management
Advanced Business Application Programming (ABAP)
Agile Methodology
Skills
ABAP, AGILE Project Management, Backend, Programming, Analytics, Master Data, Master Data Management, data flows, enterprise data warehouse, Databricks, frontend, Information Management, Information Model, IT projects, Computer science, Azure, OData, Oracle, PRINCE2, Power BI, Python, SAP ABAP, SAP, SAP Technology, SAP BI, SAP BI, SAP Business, SAP Analytics Cloud, SAP Cloud, SAP ECC, SAP HANA, HANA, BW, SAP BW, SAP systems, SAP UI5, Business Objects, BO, Fiori, SAP Fiori, Single Sign-On, SOLAS, Spreadsheets, TOGAF
Project history
12/2023
-
07/2024
Environment - Axial is the major Transformation program for AstraZeneca to consolidate seven
different ECC instances and few BW instances into a single S/4 instance, Datasphere as the
enterprise data warehouse environment and SAP Analytics Cloud as the Analytics/EPM tool.
My Role - To Lead the Finance team through the discovery phase mapping SAP standard
Analytics & Planning content to Business processes. Identify all custom Analytics & Planning
requirements which are not provided by SAP and map them to different processes. Plan & Lead
the Analytics workshops / working sessions and manage overall Analytics & Planning delivery. I
also led the Datasphere-SAC POC for the architecture sign-off.
different ECC instances and few BW instances into a single S/4 instance, Datasphere as the
enterprise data warehouse environment and SAP Analytics Cloud as the Analytics/EPM tool.
My Role - To Lead the Finance team through the discovery phase mapping SAP standard
Analytics & Planning content to Business processes. Identify all custom Analytics & Planning
requirements which are not provided by SAP and map them to different processes. Plan & Lead
the Analytics workshops / working sessions and manage overall Analytics & Planning delivery. I
also led the Datasphere-SAC POC for the architecture sign-off.
07/2021
-
09/2023
Reporting & Planning Architect, Delivery Lead
BP
Projects: Direct Tax Automation, FSCM.
* Technology:
SAP Analytics Cloud Planning & Reporting,
BW4 Embedded BPC (Planning) on SAC-Live Connection,
BW4 Reporting with SAC-Live Connection
SAC Reporting on HANA DB with SAC-Live Connections
SAC Reporting on S4 with Live Connections.
Usage of SAC Live CORS & Tunnel Connections with SSO.
SAC Augmented Analytics (Smart Discovery, Smart Insight, Search-to-insight etc.),
SAC Digital boardroom, SAC Analytic Designer (basic)
BW4 - Embedded BPC (Planning), Modelling, Query Design etc.
S4 - ABAP, CDS Views etc.
HANA - Calculation views, OData Services etc.
Direct Tax - This is a project to streamline and automate group tax consolidation and reporting
process. This Program will replace current manual activity using Spreadsheets for Group Tax
consolidation and external reporting (Fed to Group Accounts for inclusion), Stock Exchange
Announcement (SEA), Annual Reports and Accounts (ARA). This project integrates all financial
postings from different SAP and Non-SAP systems into a single BW4 instance for consolidation
and then Tax numbers are evaluated. Reporting, Manual Adjustments & User Data Actions like
Tax-Calculations etc. are performed from the SAC frontend via Single Sign-On Live Tunnel
Connections (BW Live & Embedded BPC Live).
FSCM - This is a project to automate Credit Risk assessment for BP's Customers. This project
integrates all SAP and Non-SAP Transactional environments into a central HANA DB instance.
All Internal Customer Evaluations is done in the HANA-DB and then sent to the S4/FSCM
instance. External Agency ratings for Customers come from SAP Cloud Platform to S4/FSCM.
Then a final score is evaluated in S4 for the Customers for Risk assessment. All Reporting like
Exposure, Payment performance etc. are done via SSO Live-Tunnel connections from SAC to
S/4 and SAC to HANA-DB.
My Role - I am the Design and Delivery Lead for both SAC projects, managing 20+ developers
& 100+ User base. Managing budget, hiring etc. for both the projects. I am part of the SAC
platform product council advising different projects on Technical Design, System Performance,
Product roadmap and User concerns. I am part of the BP-SAP central team for development
standards on SAP products. BP is one of the few customers to deploy SSO Live-Tunnel
connection as part of the Direct Tax project and I was involved very much with the SAP product
team for early release June-2022.
* Technology:
SAP Analytics Cloud Planning & Reporting,
BW4 Embedded BPC (Planning) on SAC-Live Connection,
BW4 Reporting with SAC-Live Connection
SAC Reporting on HANA DB with SAC-Live Connections
SAC Reporting on S4 with Live Connections.
Usage of SAC Live CORS & Tunnel Connections with SSO.
SAC Augmented Analytics (Smart Discovery, Smart Insight, Search-to-insight etc.),
SAC Digital boardroom, SAC Analytic Designer (basic)
BW4 - Embedded BPC (Planning), Modelling, Query Design etc.
S4 - ABAP, CDS Views etc.
HANA - Calculation views, OData Services etc.
Direct Tax - This is a project to streamline and automate group tax consolidation and reporting
process. This Program will replace current manual activity using Spreadsheets for Group Tax
consolidation and external reporting (Fed to Group Accounts for inclusion), Stock Exchange
Announcement (SEA), Annual Reports and Accounts (ARA). This project integrates all financial
postings from different SAP and Non-SAP systems into a single BW4 instance for consolidation
and then Tax numbers are evaluated. Reporting, Manual Adjustments & User Data Actions like
Tax-Calculations etc. are performed from the SAC frontend via Single Sign-On Live Tunnel
Connections (BW Live & Embedded BPC Live).
FSCM - This is a project to automate Credit Risk assessment for BP's Customers. This project
integrates all SAP and Non-SAP Transactional environments into a central HANA DB instance.
All Internal Customer Evaluations is done in the HANA-DB and then sent to the S4/FSCM
instance. External Agency ratings for Customers come from SAP Cloud Platform to S4/FSCM.
Then a final score is evaluated in S4 for the Customers for Risk assessment. All Reporting like
Exposure, Payment performance etc. are done via SSO Live-Tunnel connections from SAC to
S/4 and SAC to HANA-DB.
My Role - I am the Design and Delivery Lead for both SAC projects, managing 20+ developers
& 100+ User base. Managing budget, hiring etc. for both the projects. I am part of the SAC
platform product council advising different projects on Technical Design, System Performance,
Product roadmap and User concerns. I am part of the BP-SAP central team for development
standards on SAP products. BP is one of the few customers to deploy SSO Live-Tunnel
connection as part of the Direct Tax project and I was involved very much with the SAP product
team for early release June-2022.
09/2019
-
06/2021
Architect / Delivery Lead
BP
Project: S/4 HANA Transformation (EHS), BW/4 Hana upgrade, SAC Reporting
Environment:
* Technology: BW/4 Hana, S/4 CDS Views, CAQs, SAP Analytics Cloud, Power-BI, Fiori.
* Business Module: EHS - S/4 HANA Transformation program.
This was a S/4 Transformation program to modernize the Health & Safety IT portfolio for BP.
This involves upgrading ECC EHS to S/4 HANA, upgrading BW 7.4 to BW/4 HANA. My Role
is to Lead and Design the Reporting Delivery. Reporting suite was upgraded to BW/4 HANA
with new modelling technologies and SAP Analytics Cloud. Operational Reporting was
delivered using new Technologies like Embedded Analytics (CDS extractors) and SAP UI5.
Environment:
* Technology: BW/4 Hana, S/4 CDS Views, CAQs, SAP Analytics Cloud, Power-BI, Fiori.
* Business Module: EHS - S/4 HANA Transformation program.
This was a S/4 Transformation program to modernize the Health & Safety IT portfolio for BP.
This involves upgrading ECC EHS to S/4 HANA, upgrading BW 7.4 to BW/4 HANA. My Role
is to Lead and Design the Reporting Delivery. Reporting suite was upgraded to BW/4 HANA
with new modelling technologies and SAP Analytics Cloud. Operational Reporting was
delivered using new Technologies like Embedded Analytics (CDS extractors) and SAP UI5.
12/2018
-
08/2019
Solution Design & Delivery Lead
BP
Project: Automation - Cash Collection (custom product)
Environment:
* Technology: BW on HANA, BO, SAP Fiori, ECC, S/4 HANA & SAP Analytics Cloud,
* Business Modules: Finance & Sales.
A Custom Cash Collection Product/Application built for BP. This is used for Cash collection
across all BP Service Centers worldwide. This was built using Core SAP Technologies HANA,
Fiori & ECC. My role was to design a product which was cost effective and fulfilled needs of the
business as compared to the standard off-the-shelf products in the market.
Environment:
* Technology: BW on HANA, BO, SAP Fiori, ECC, S/4 HANA & SAP Analytics Cloud,
* Business Modules: Finance & Sales.
A Custom Cash Collection Product/Application built for BP. This is used for Cash collection
across all BP Service Centers worldwide. This was built using Core SAP Technologies HANA,
Fiori & ECC. My role was to design a product which was cost effective and fulfilled needs of the
business as compared to the standard off-the-shelf products in the market.
10/2017
-
11/2018
Senior BW on HANA Planning Consultant
Glanbia Plc
Project: SOLAS - Design & Implement new BW on HANA (redeployment of old BW)
Environment:
* Technology: ECC 6.0, BW on HANA, Integrated Planning (IP), BO 4.x.
* Business Modules: Finance, Sales & Marketing etc.
Glanbia had the BW-Backend basis upgrade to HANA in 2017, however the BW Reporting &
Integrated Planning (IP) data models were not optimized to run in the HANA environment. The
Project includes assessment and implementation of their Information Model and the data flows
required for the new BW on HANA environment. My Role was to lead the design and
deployment of the new BW system.
Environment:
* Technology: ECC 6.0, BW on HANA, Integrated Planning (IP), BO 4.x.
* Business Modules: Finance, Sales & Marketing etc.
Glanbia had the BW-Backend basis upgrade to HANA in 2017, however the BW Reporting &
Integrated Planning (IP) data models were not optimized to run in the HANA environment. The
Project includes assessment and implementation of their Information Model and the data flows
required for the new BW on HANA environment. My Role was to lead the design and
deployment of the new BW system.
01/2017
-
09/2017
Senior BW on HANA Consultant
BAT
Project: SkyWalker - Build new BW on HANA (redeploy legacy BW 7.4).
Environment:
* Technology: BW on HANA, BO 4.x, ECC 6.0.
* Business Modules: Finance, Sales & Marketing etc.
This project is to redeploy BAT's legacy Oracle/BW 7.4 Reports into to a new BW on HANA
environment. This is a Transformation & Improvement program undertaken by BAT to bring
BAT's SAP landscape in line with SAP Technology roadmap, using SAP's LSA++ architecture.
My Role was to review, design and deploy the BI Reports into the new system.
Environment:
* Technology: BW on HANA, BO 4.x, ECC 6.0.
* Business Modules: Finance, Sales & Marketing etc.
This project is to redeploy BAT's legacy Oracle/BW 7.4 Reports into to a new BW on HANA
environment. This is a Transformation & Improvement program undertaken by BAT to bring
BAT's SAP landscape in line with SAP Technology roadmap, using SAP's LSA++ architecture.
My Role was to review, design and deploy the BI Reports into the new system.
11/2009
-
12/2014
SAP BI-BW Reporting & Planning Delivery Lead
BAT
Project: Multiple projects
Environment:
* Technology: BW on HANA, SAP-BI 7.x, BO 4.x, IP, ABAP, SAP ECC-6.0, SAP EP 7.0 .
* Business Modules: Operations, HR, Finance, Sales, Marketing & Treasury.
Environment:
* Technology: BW on HANA, SAP-BI 7.x, BO 4.x, IP, ABAP, SAP ECC-6.0, SAP EP 7.0 .
* Business Modules: Operations, HR, Finance, Sales, Marketing & Treasury.
08/2006
-
05/2008
Senior BI Consultant
BP (British Petroleum)
This project involved BI-BW implementation in various areas of the business (Sales, Stocks,
OIL, Transports and P2P etc.). I worked as a Senior BI Consultant on Process Fitness -
Marketing & Supply Project.
OIL, Transports and P2P etc.). I worked as a Senior BI Consultant on Process Fitness -
Marketing & Supply Project.
03/2003
-
07/2003
10. SAP BW Consultant
Novartis Pharmaceutical
12/2002
-
02/2003
SAP BW-ABAP Consultant
British Airways
07/1999
-
11/2002
SAP ABAP Consultant
Philip Morris and other Clients
Local Availability
Open to travel worldwide
