Bala Shanbhag
- SAP HANA / BW architect
- New York City, NY
- Member Since May 15, 2023
Candidates About
Bala Shanbhag
HIGHLIGHTS
· 15 years’ experience and several full life cycle implementations in BW, HANA, SAP BPC for S/4HANA (formerly IBPF)
· Data modeler – Cubes, DSOs, Hana views, tables, stored procedures and coding
· Coding: ABAP, SQL, Excel-VBA, Python (beginner)
· Reporting – Bex, SAP business objects design studio, WEBI, Tableau
· knowledge of Finance and controlling (GL, AR, AP, CCA, IO, PS), sales, procurement, HR, manufacturing
· Experience working with business owners, managers and executives.
MacMillan(Book Publishers), New York, NY: Sept 2017 - present, SAP S4/HANA, Embedded BPC and BW
· Built new and modified HANA views for management reporting on S4.
· Built model and reporting around AP and AR using ACDOCA offsetting entries of S4 HANA and AO.
· Built EPM reports and organized them in folders, applying security. Did the same for AO reports.
· Worked with finance team and developer to build the allocation of cost center planning data on R01 planning cube.
Tellus (network provider/utilities), Vancouver, CA: May 2016 – August 2017, SAP HANA/BPC consultant
Tools: BW4HANA, SAP BPC for S/4, HANA Hana studio, SLT,BODS designer
• Worked on SAP BPC for S/4HANA. Activated BI content for master data, hierarchies, virtual cube(on ACDOCA table) and real time cube.
• Used workbook for analysis for excel for several planning functions such as copying actuals to plan, deleting a plan, distribution to periods, calculations (qty/value), generate combination etc.
• Gathered requirements, documented, worked with users to demo, train and test the planning solution.
• Copied plan data to ERP for cost center planning. Worked with users to train and test.
• Architecting the B4HANA solution targeting first on billings, followed by AR.
• Used BODS data integration with HANA.
• Built HANA views (Attribute, analytical, calculation) on sales tables. Built a model to report open sales orders, not yet delivered.
• Important extractors: SLT for several ECC tables, 2lis_13*,2lis_11* for DXC extraction
Akzo-Nobel (Paint, Manufacturing), Cleveland, Ohio: July 2015 – Feb 2016, SAP 7.5 powered by HANA 1.0
• Helped transition to the new HANA models for inventory control using advanced DSO
• Further enhanced inventory snapshot reporting to accommodate non-sap systems. Reported in-transit stock using generic extractor on ECC tables.
• Acquired demand data from non-sap systems using data services into BW using BODS designer
• Important Extractors used: 2LIS_04_P_ARBPL, 2LIS_04_P_MATNR,2LIS_04_P_COMP 2lis_03_BX(F)
Fitch Ratings, (Financial services) New York, NY: May 2012 – May 2015, SAP BI Consultant 7.3, Integrated planning, BPC integration, HANA 1.0
Tools: ECC6, SAP BI 7.3 , BEx, ABAP, MM, COPA, Procurement, BPC, IP
• Led the BI development in AR, CCA, IO, GL, PO and IR business area.
• Reports build are used extensively globally. Include:
o AR aging report (a combination of sales orders and the AR sub ledger)
o Currency adjusted aging report, advanced currency neutral PA reports
o COPA reports and modified model for new subsidiary
o Cost analysis reports combing cost centers and internal orders
o PO and Invoice receipts reports by approver, initiator
o Sales/Billings reports
o Asset accounting
o Cost center spend combined with internal orders into a common cube
• Built a solution for transfer pricing using SAP integrated planning.
• Put in processes for post go-live handling of support tickets
• Conducted BW training targeted on specific reports and user groups.
• Important Extractors used: 0FI_GL_10, 0FI_GL_14, 0FI_AR_4, COPA generic, 0CO_OM_CCA_1, 0CO_OM_OPA_1,2lis_02_itm, read_text generic, 0FI_AA_*,2LIS_13*
Akzo-Nobel (paint, manufacturing), Cleveland, Ohio: April 2011 – April 2012, SAP BI, integrated planning
Tools: ECC6, SAP BI7, IP, BEx, WAD, ABAP, APO
As part of the global team worked on USA and Canada implementations.
• As senior SAP BI consultant on a Global project analyzed BI requirements and built functional and technical design documents, tracked and analyzed gaps for go-live of US.
• Built reports for lead times, setup times and execution times by activity types.
• Integrated demand plan from APO for actuals vs forecast reporting in BW.
• Worked on inventory management to create daily snapshot report of inventory data by month to accommodate sap and in-transit inventory. Created generic extractor for in-transit data. Operationalized inventory management content.
• Enhanced manufacturing process orders extractors for work views, material views extractors for US needs. Worked with PP tables for the extractor enhancement.
• SAP BI reporting training and workshops. Bex broadcasting, APD processes.
• Important Extractors used: 2LIS_04_P_ARBPL, 2LIS_04_P_MATNR,2LIS_04_P_COMP 2lis_03_BX(F)
FujiFilm (hardware, manufacturing) New York: June 2009 – March 2011, SAP BI Lead
Tools: SAP BW, BEx, WAD, MRP, Order-to-Cash, Inventory Mgt., Purchasing, GL, ABAP, IP
• Managed and supported the development of a BPS supply chain planning solution
• Created standard operating procedures for BW, as a shared service model, to provide a company-based, secure, scalable and customizable reporting solution. Liaison for JSOX compliance requirements. Responsible for working with IT operations to streamline data loads and build SOPs.
• Provided valuable production support to the business in areas of sales (sales commissions calculations included reporting agent scheduling), billings, finance, integrated planning and forecasting and others.
• Planned and implemented the effect of a company code merge in R/3 on the BW side, when one of Fuji Companies merged with another. Estimated effect in BW, which was mainly financials related, and made the cut-over. Worked with the end-user to resolve all reporting related issues and made changes to queries because of the cut-over.
• Used existing BW content to further enhance reporting functionality.
• Built a tax consolidation solution in SAP BW for SAP and non-SAP companies in the holdings company to produce a consolidated corporate tax return report 1120, in effect consolidating several legal entities. Managed the project from inception to realization.
• Built MRP BI content using 2LIS_03_S194 extractor to report KPIs- safety stock, future issue quantity, future receipt quantity.
Coca Cola: November 2008 – March 2009, Global Business Process Expert
Tools: SAP Bex, WAD, HR,GL, PCA, CCA, IM-PS, COPA, Enterprise Portal
I am a BW business process expert for Bottling Investment Group BI Solution in Finance (Report-to-Report) and HR solutions.
• Requirements gathering, documentation and analysis for bottling investments, reporting and planning. Integrated web-reports with the enterprise portal.
• Documented reporting requirements for the global bottling group to generate financial statements - Balance Sheet, Income Statement, operating expenses, Variance analysis, and Currency neutral reporting.
• Worked with corporate line items such as equity income, interest expenses, capital structure adjustments booked for individual bottlers.
• Worked with reporting team to build consolidated reports from BCS providing a total view of the SAP and non-SAP enabled bottlers.
• Built test scripts and performed acceptance testing in areas of GL, BCS, CCA, PA, Org. management and Time keeping.
Client: M&M Mars Oct 2007- June 2008
Industry: Consumer Packaged Goods
Tools: IP, SAP BW, ABAP
Personnel costs and time planning (G&A) which together with sales, COGS and other income/expense will help generate the complete plan P&L and pro-forma Income Statement and Balance Sheet.
• Led a team of three to design and implement the G&A planning solution using BPS.
• Worked with the process team to identify process gaps and re-engineer the business processes.
• Designed the architecture, did due diligence on process/system gaps, build inventory of new development.
• Developed the G&A planning solution, including headcount planning and other line items.
• Enhanced query performance by a combination of stats, aggregates, design changes, compression and partitions.
Client: M&M Mars
Industry: Consumer Packaged Goods July 2006 - Aug 2007
Tools: SAP – IP, SAP BW, BEX, VBA, FOX, ABAP, Security, OTC, SCM
Built a product for European divisions to plan for inventories, allocate budgets and report operational performance.
• Involved in the entire project from scoping to go-live with extensive involvement in business analysis, data modeling, development and administration.
• Designed the KPI driven data model using BPS cubes and interfaces.
• Developed planning web layouts, planning functions, validation routines and characteristic derivations.
• Built the security model for the product using BPS variables and BW security.
• Integrate reports into a portal. Reported supply and market analytics in BEx and Web reports.
Client: Johnson and Johnson
Industry: Pharmaceuticals Nov 2005 - April 2006
Role: BPS Consultant
Tools used: SAP BPS, SAP BW, FOX, ABAP
Budgeting and planning tool that supports annual planning and monthly forecasts.
• Provided BPS production support during the planning process. Planning process included sales planning, cost center planning and CAPEX. These included reposts, allocations, distributions, copies for backups, manual changes in layouts etc.
• Modified web planning layouts per new planning requirements, created new ones. Implemented Status tracking system (STS) in a team environment.
• Provided the roadmap for financial consolidation initiative by building the necessary data model using PCA in Business Warehouse.
Client: Mead Westvaco
Industry: Consumer packaged goods Feb 2005 – Sept 2005
Role: BCS-BW consultant
BW based BCS consolidation project for both managerial and legal consolidation.
• Worked in a team environment to create the blue print of the consolidation project.
• Designed and built the basis of the financial data (PCA) from R/3 to BW including cube-design, data loads and queries.
• Worked in a team to build the consolidation hierarchy for both managerial and legal consolidations and perform currency translations and intercompany trade elimination postings in BCS.
• Reported the consolidated reports in BW using the virtual info-provider.
Client: GE Advanced Materials
Industry: Manufacturing May 2004 -Dec 2004
Role: BW Project Leader
Tools used: BW, SIS, MDX, Order-to-Cash, COPA
Monitor divisional sales performance. Sales content development in BW. Final dash boarding in a third-party java based portal.
• Led a team of five consultants and been an advisor on BI strategy to the client.
• Selected the sales content (Sales Order header, Sales schedule lines, delivery line items and invoice line items). Built the data model using BW info-cubes and ODS objects.
• Brought the different sales data store objects together in a multi-provider to calculate total sales position in quantities and dollars.
• Enabled calculation of new KPIs, such as “open orders”, “delivered but not billed” etc., by building an innovative relational integrity model using ODS objects.
• Built the COPA extractor and loaded COPA data into a new COPA cube. Built analytical PA reports.
Purdue Pharmaceuticals April 2003 - April 2004
Industry: Pharma Role: Sr. Manager BW
Purdue pharma specializes in pain management with Oxycontin being one of the most successful drugs. In this fulltime position, I was responsible for the entire Business Warehouse and SEM product implementation and support. Areas of BW implementation were PCA, SPL, Procurement and a Physician information database. BPS was focused on Sales planning, Cost center planning, Payroll planning and IO planning. Functional areas: OTC, P2P, SRM, FICO
• Led a team of five to develop and maintain the BPS and BW products.
• Built a corporate BI strategy for reporting and planning.
• Migrated the company from planning in dispersed excel workbooks to an integrated central planning solution using SEM-BPS.
• Design and maintenance of sales accounting and reporting, overhead costs and projects costing system.
• Supported the business during corporate restructurings, re-planning sales, costs and other P&L line items.
• Led a team to upgrade the SAP system technically and functionally.
Client: Florida (CHEP USA)
Industry: Material Handling Nov 2002 - Feb 2003
Role: BW Consultant
Project Scope: BW, CPM, Inventory controlling, MM
Lead a team of two (2) business analysts, one developer and a basis person to help develop the inventory stock cubes. Two basic cubes and a multi-cube were put into production at the end of the project.
• Design of the inventory stock reporting info-cube
• Analyzed custom KPI reporting requirements in Plant stock reporting using various material movement types, batch and other conditions.
• Reported KPIs for Process (customer) stock the custom process stock info-cube.
Client: State Project, Commonwealth of Pennsylvania- KPMG Consulting, Harrisburg, PA
Industry: Government Sector May2002 -Oct 2002
Role: BW Consultant
Project Scope, BW-HR
Integration of the HR business reporting needs in BW in areas of personnel administration, headcount, payroll, and organization management.
• Led the project. Shared BW know-how to bring up the client resources to speed quickly.
• Joined in the project in the design phase right after blue printing. Involved in the sign-off of the blue print for KPMG.
• Prepared data models for the cubes in PA, Payroll and Org. Management.
• Worked with the business users to asses reporting needs and built the reports inventory.
• Built web reports using BW excel interface to integrate with the company portal.
• Managed transaction data loads for the above areas.
Client: Sacramento Municipal Utility District
Industry: Utilities Dec 2001-May 2002
Role: BW Consultant
Tools used: Business Warehouse, Cost accounting, Projects systems, Internal Orders
▪ Introduced Business Warehousing in the organization for BI reporting. Managed a project of five client employees.
▪ Consulted on overhead cost accounting system and Project systems. Configured BW based CCA and PS reporting thereby increasing operational efficiency.
Client: Colgate Palmolive;
Industry: Consumer Packaged Goods Oct 1999 - Nov 2001
Role: ERP process Consultant
Tools used: COPA, OTC, Purchase-to-pay, and OLAP
• Worked in a team environment build the purchase-to-pay reporting system called MRS in BW.
• Provided gross margin analysis reporting analysis in a multi-dimensional reporting model.
• Built and managed several COPA reports.
• Consulted on Sales analytics reporting, purchasing and invoicing system.
• Created a graphic daily flash report to provide daily position.
Rapidigm, Inc., (Currently owned by Fujitsu), Pittsburgh, PA June 1997 – Sept 1999
• Eli Lilly: Consulted for a 5-year $600 M business process re-engineering initiative replacing individual legacy systems with Enterprise-wide ERP implementation.
▪ Performed extensive gap analysis from legacy to SAP for the US implementation.
▪ Programmed reports for Human resource management in Personnel admin, benefits and payroll.
▪ Worked on gap analysis Human resource management areas of Payroll and cost center reporting.
VeriFone, Inc. (Currently owned by HP), Bangalore, India 1996 – 1997
• Developed a product for transaction processing and credit/debit card authorization.
Tata Interactive Systems, Mumbai, India 1995 – 1996
• Built a computer based training product using 3D animations, simulations and math models
EDUCATION
Center for Development of Advanced Computing, India 1994 – 1996
Masters in Computer Science
University of Mumbai, Mumbai, India 1989 – 1993
Bachelor of Science