Results-driven Sr. SAP BPC/SAC EPM Lead Solution Architect with proven success in implementing planning and consolidation solutions at Global Petroleum. Specialized in SAP HANA and data integrity, with a strong focus on user training and stakeholder engagement. Achievements include enhanced compliance and significant improvements in financial reporting and forecasting accuracy.
Overview
12
12
years of professional experience
Work History
Sr. SAP BPC/SAC – EPM Lead Solution Architect (SME)
Global Petroleum
Boston, MA
05.2020 - Current
Implemented SAC with BPC in Hybrid approach for Planning and Consolidation Solutions.
Supported FP&A and Operations Finance teams for budgeting, forecasting, and consolidation.
Led User Acceptance Testing (UAT) including test script creation, execution, and defect tracking.
Coordinated regression testing and validated financial data accuracy.
Supported plan book transformation initiatives.
Delivered go-live and hypercare support.
Supported Workiva setup, integration, and reporting linkage.
Ensured SOX and internal controls compliance.
Created comprehensive training documentation for end-users.
Created Financial Planning for P/L, B/S by Company and Account along with designed and write allocation rules.
Design Input Schedules for CAPEX, OPEX Planning by Cost Center.
Data Integrity across all systems (PDI, BPC,SAC and oracle PBCS) transaction data during period end closing process.
Monitor BW process chain and fix any issue while loading data into BPC from Legacy system.
Production Support resolving Daily Tickets raised in Cherwell System based on Issue Priority.
KT and End User Training.
Global Petroleum is a midstream logistics and marketing company that owns, controls or has access to one of the largest terminal networks of petroleum products and renewable fuels in the Northeast. Global also is one of the largest distributors of gasoline, distillates, residual oil and renewable fuels to wholesalers, retailers and commercial customers in New England and New York.
Sr. SAP BPC – EPM Lead Solution Architect (SME)
Mallinckrodt Pharmaceuticals
St. Louis, MO
05.2018 - 06.2020
As a Lead Solution Architect, working on enhancements and bugs leftover by previous E&Y Integrator.
Implementation of CAPEX, OPEX, Planning at different aggregation levels planning in BPC 10.1.
Rolled out consolidation process for segment reporting.
Led requirement sessions/Workshops and design sessions.
Designed and Configured BPC Reports, Input Forms, Data modeling, Master Data Set up and Automation, BPF's.
Acted as a liaison between business process Owners and IT monthly forecast closing process.
MRP: HANA development on BPC and BW cubes to combine data and perform automated data quality checks and reports in AO.
Created complete blue print document starting at extracting data from project systems and Power Plan to BW virtual/real time cube and Input Queries.
Deployed Currency translation, Unit Conversion functions for Sales/Revenue Planning.
Handled User Management, Roles, and Privileges.
Performance tuning of the HANA Cubes.
Design and develop planning for Production, labor, Inventory, capital, and maintenance.
Developed price & revenue planning use cases with BPC 10.1 embedded, BW 7.5, HANA SP10 and BI 4.2.
Create Fox planning functions, ABAP function types, planning sequences and BEX input ready reports.
Create DSO, AMDP HANA logic.
Advised business stakeholders regarding project benefits, risks and constraints.
Developed Balance Sheet Flux Report, SEC Income Statement, EBITDA Analysis Reports by Entity, Cash Flow Reports.
Data Integration from financial legacy applications Blackline.
Configured Financial Group Reporting and developed Consolidated Financials.
Production Support for phase 1, resolving Daily Tickets raised in Cherwell System based on Issue Priority.
Security, BPC Admin Maintenance.
KT and End User Training.
Prototyping for BPC 11 upgrade in place.
Mallinckrodt Pharmaceuticals is an Irish–tax registered manufacturer of specialty pharmaceuticals (namely, Akhtar), generic drugs and imaging agents, that generated 90% of 2017 sales from the U.S. healthcare system.
Sr. SAP S/4 HANA BI/BW BPC Lead Solution Architect (SME)
FGT
Chicago, IL
01.2016 - 12.2017
Responsible for installing all the BPC Embedded and BW related objects for the S/4 HANA POC project for the Portugal Business Unit.
Activated SAP delivered Technical content bundle for BPC Embedded in the /ERP/SFIN_PLANING namespace including Info providers, Queries, Planning Functions, Planning Sequences and HANA information Models.
Worked on SAP Delivered Planning Templates for Cost Center, Internal Order, Profit Center, Cost of Sales and P&L Planning.
Activated and modified the SAP Delivered Analysis for Office workbooks.
Create Business Process Flows (BPF) as per business requirements.
Educate Users on versatile features of BPC Embedded for S/4 HANA.
Responsible for all the Planning and Forecasting applications on BPC 10.1 Embedded system including OPEX Planning, CAPEX Planning, Sales Planning, HR Planning, P&L Planning, Balance Sheet and Cash flow planning.
Current Client Supports (BNM/NRF): Supporting the Business Process Flows (BPF) for both BPC Planning and Consolidation models.
Supporting Authorization via the DSO upload and RSECADMIN generation of authorization object.
Extensively working with Finance Team during the Close to Troubleshoot issues in BPC and BW.
Supporting the SAP BPC Data Manager Package, using Process Chains.
Supporting the Adjustments of Actual Data through Journals for Group G/L Account Data Mismatches.
Supporting the Web Based Flat File Upload program to load Consolidation data for the Non-SAP entities.
Fulcrum RDS Consolidations for multiple domains.
Sr. SAP BI/BW-BPC Lead Solution Architect (SME)
Baker & McKenzie
Chicago, IL
06.2014 - 12.2015
As a Lead BW/BI-BOBJ SME Solution Analyst/Architect, I have Designed, Developed Baker & McKenzie BW-BOBJ Analytical System and BPC Budgeting requirements at Local/Global Offices.
Conducted User Work Shops part of Requirements Gathering, Business Blue Print Sign Off, Gap Analysis, Sandbox Prototype Design (Proof of Concept), Developing Functional and Technical Specs.
Documented Business Process Flows interacting with Business and Technical Team.
Configured Semantic Infocubes to hold NMEA, ASPAC, Europe, and SA Financial Data with different Org Elements.
Config Custom Extractors for bringing in data from ECC-PS, FI, HR-HCM Modules.
Has written many Transformations/Logics, Script Logics, VB Macros and BADI Programs for Reporting/Planning Templates.
Baker & McKenzie defined the global law firm in the 20th century, and we are redefining it to meet the challenges of the global economy in the 21st century. The firm brings to matters the instinctively global perspective and deep market knowledge and insights of more than 4,000 locally admitted lawyers in 76 offices worldwide.
Education
Post Graduate Diploma - Computer Science
NIIT
B.S -
Osmania University
India
Skills
SAP BPC Expertise:
Data modeling
Planning and forecasting
Reports Building
Business process analysis
User acceptance testing
Consolidation processes
Financial reporting
HANA Models
SAP ECC/ERP Modules:
MM,PP,SD
PS,PM
APO DP
HR/HCM
CRM,SRM,TPM
FI/CO
SAP BI 74
BW-BPS,Integrated Planning
ABAP, FOX formulae
SAP BODS 4x
SAP HANA
Oracle 11i/10g/9i
SQL Server 2008/2012
DB2,MS SQL
SAP Fiori
Programming Languages:
ABAP, Script Logic
SQL, PL/SQL
C,JAVA Script
UNIX Shell Scripting
UI5, HTML5, CSS3
Soft Skills:
Client relationship management
Team leadership
Effective communication
Timeline
Sr. SAP BPC/SAC – EPM Lead Solution Architect (SME)
Global Petroleum
05.2020 - Current
Sr. SAP BPC – EPM Lead Solution Architect (SME)
Mallinckrodt Pharmaceuticals
05.2018 - 06.2020
Sr. SAP S/4 HANA BI/BW BPC Lead Solution Architect (SME)