Mohamed Abdul Rahman Shafi

SAP BW / BPC/ IP Specialist

Short Profile

Years of Experience :

15 years

Functional Domain :

  • Corporate Financial Reporting

  • Consolidation & Reporting

  • Management Reporting

  • Financial Planning

Technical domain :

SAP BW (version 3.5 till BW/4 HANA), Planning Technologies such as Integrated Planning , Business Planning and Consolidation (Embedded and classic) and SAP Analytics Cloud.

Specialty :

Business Planning Analyst solutions for Corporate and Management Financial forecasting

Industry Domain :

Pharmaceuticals and Healthcare

Roles experienced :

  • Senior Reporting Manager

  • Planning Architect

  • Reporting Manager

  • Project Leader

  • Developer

  • Stakeholder Management

  • User Training and Onboarding

Technical Skills

SAP BW4HANA SAP BPC10/11 ABAP Power Query

Analysis for Office Integrated Planning Web Dynpro PLSQL

Query Designer SAP BPC Embedded AMDP/C++

BO Dashboards SAP Analytics Cloud Java Script VBA Macros

Qlik Sense SAP Security Fox Formulas SharePoint


Functional Skills

Financial Reporting

  • IFRS based Reporting for Income statement, Cash flow, personnel cost and FTE

  • Operational reporting based on SAP modules such as Logistics, FICO, CCA and PCA

  • Sales Price Volume reporting and Consensus reporting

  • Intercompany Elimination and consolidated COGS calculation

Financial Planning

  • Latest Outlook, Latest Estimates, Budget Planning, Strategic Financial Planning, Intercompany elimination, Weekly sales forecast and Spot landing

  • Sales & Sales deduction planning, Cost center Planning and Internal Order Planning


Professional Experience


Senior Reporting Manager

Management Reporting Group

Novartis AG, Basel

Feb 2021 - Current

Roles & Responsibilities

  • Ensuring continuity of Operations for the Financial closing reports and presentations

  • Identify and improve the reporting process for financial closing, with a goal to produce closing reports at the earliest

  • Has been leading the Financial reporting transformation program to redefine the reporting processes, solutions and system to enable user friendly and flexible reporting which can add value to the financial community

  • Performed data integration from various financial systems to provide one stop shop for financial reporting

  • Have been an accessory in the internal transformational initiative to redefine the focus of financial governance and performance based on geography

  • On boarding financial community on new cloud based reporting solutions such as Qliksense for dashboarding and SAP analytics cloud for Forecasting and comments collection


Planning Architect / Business Analyst

Digital Data & Tools, Global Business Planning Analyst

Novartis AG, Basel

Mar 2019 - Jan 2021

Roles & Responsibilities

  • System architect for BPA owned BPC/BI and SAP Analytics cloud applications, responsible for the Operation, enhancement and delivery of financial reporting and forecasting application for the Global Finance community

  • Customer management such as request for new requirements, new solutions and effective communication by receiving and providing feedback and frequent Q&A sessions

  • Team management activities such as onboard and set up of support teams in Barcelona, Rome and India based on requirements in the pipeline

  • Stake holder management to keep other downstream /Upstream customers informed of changes, downtimes for upgrades by frequent communication and collaboration

  • Technology Exploration to explore cloud-based solutions such as Qlik sense, SAP analytics cloud to bring all the latest technological offerings to our user base

  • Content Management established a portal for the team to share and communicate information and also manage information related to applications, user and upcoming enhancements

  • Business Analysis and Process simplification of the key Income statement and Cash flow processes

  • Key enabler in adapting existing applications to the current ongoing digital transformation of our team which involves slide less presentations, Artificial intelligence driver forecasting and real-time forecasting

  • Driving the migration to agile project management methodology culture into the team to cope with the rapid changing business requirements

  • Technology evaluation of SAP analytics cloud as a potential reporting and forecasting application complementing the AI based forecast prediction.


Reporting Manager

Financial Reporting Analysts

Novartis AG, Basel

Jun 2018 - Feb 2019

Roles & Responsibilities

  • Responsible for the financial reporting solutions for technical Operations, managing requirements, planning and delivering enhancements

  • Impact assessment, planning and managing the migration of users from BEx reporting into Analysis for office for analytical reporting and into BPC for formatted reporting

  • Automation of Month end Closing related loads, its validation and Deck Generation for every iteration

  • Analysis and improvement of the existing Balance sheet review process simplifying the efforts of the customers and also the load on the system

  • Pitching system-based solutions for manual processes in the team thus enabling efficiency of our customer and also increasing the reliability of our services provided to them


Team Lead

Project Lead / Solution Expert/Developer

Novartis AG, Basel

Jun 2007 - may 2018

Roles & Responsibilities

  • Promoted the onboarding of the BPC as a planning and reporting solution, by conducting workshops and business case demos

  • Designed and developed the P&L and balance sheet forecast application

  • Have rolled out the same application across various divisions in the client organization

  • Have played a pivotal role in understanding the requirements of the business and tailor finishing the delivered solution to meet the various needs of the business

  • Application migration to BPC primarily as a reporting solution with Custom architecture suitable for BPC as a reporting layer

  • Designed and developed the Weekly sales forecast application, P&L forecast Application and Cost Planning application based on internal order and cost center.

  • Developed an Internal Time sheet application using Integrated Planning to track resource efforts and automate billing.

  • Was the Project manager for the rollout of Cost Planning application for all European markets

  • Served as the single point of contact for IP based application support in the Client landscape

  • Have developed Webi reports based on BI data with supporting dashboards based on BO dashboards

  • Proposed and Implemented WAD based cockpit for IT, to manage, Monitor and trigger data loads from the Web

  • Worked on the BW 3.5 platform to develop BW data model and reporting solution for the P2P module

  • Worked on custom and standard extractors to extract data from ECC and then have them transformed to provide insightful info using BW reports