SUMMARY:

• Seasoned and Subject Matter Expert in SAP BW / BPC HANA with over 16 years of experience in SAP BW / BI, HANA, BPC and BO. Subject Expert and Proficient in using SAP BPC, BW/HANA, BI Reporting Tableau, BO and Power BI, WEBI, BO and HANA Reporting, SAC and Embedded Analytics.
• SAP BPC SME, having a 16 year of experience in Finance, Strategy & Technology consulting.
• Helping organizations strategize and implement finance planning and consolidation framework for regulatory & disclosure reporting and Reporting Strategies and Architecture
• Experience in implementing multiple BPC projects (9 full life cycles) over 15 years on BPC NW, RTC.
• Experience on BCS and ECCS.
• Managed multiple system conversions from Hyperion BCS, ECCS applications to BPC
• Strong finance knowledge having worked in FI, CO GL, configuration and completed Rice University FP&A program in 2018, To be certified in 2020
• Expertise in Data provisioning using different methods like SLT, BODS, DXC, SDA(Smart Data Access and SDI) into SAP HANA database.
• Extensive experience with HANA Modeling including creation of HANA Attribute views,Analytical views, Calculation views, Analytical Privileges
• Roll out of Reporting Strategies for the Clients with BW/4 HANA, S4 HANA and others with BO tools like AO, SAC, WEBI, Tableau, and Power bi
• Experienced in extracting (ETL) data from SAP R/3 (FI/CO, MM, SD, APO) and BW using different extraction structures such as CO - PA, LO Cockpit, and generic extractors, LSA++ in BW/4 HANA

SKILLS:

SAP BW/BPC

HANA Modeling/CDS view/Flow Graphs

Dashboards/BO/Tableau/WEBI/BODS

S4 HANA / SAC/Embedded Analytics

FICO/PM/PS

Confidential Experience

Project Management

Energy/Utilities Industry

Cost Center, Capex, Income Statement, Cashflow,Revenue,Profitability, HR Planning, Budgeting, forecasting /Financial close

PROFESSIONAL EXPERIENCE:

Confidential, Oregon

Principle SAP BPC Architect

Responsibilities:

• BPC/ BW upgrade from 7.4 to 7.5
• Migration of database to HANA.
• Month end support of Confidential consolidation close.
• Enhancements of Journal Entries and EPM critical reports for financial statements.
• BW BPC integration of data sources and data staging layers.
• Remapping of company codes to legacy codes

Confidential, San Diego

Principle SAP S/4 HANA Reporting and Planning Specialist

Responsibilities:

• Delivered finance transformation project with roll out of legacy reports into WEB reports, in addition to driving the smooth implementation of HANA modeling in S4 HANA under strict deadlines and heavy workload.
• Rolled out BPC optimized planning application for monthly, master and forecasting process for Confidential North America Division.
• Constructed HANA 2.0 modelling for financial reporting out of S4 HANA tables and leveraged views in Webi and AO reporting tools.
• Integrated and Migrated Planning Scenarios to SAC and developed applications for Confidential.

SAP S/4 HANA/ BPC Developer/ Reporting Lead

Confidential, Houston, TX

Responsibilities:

• Working on enhancements to Capex reporting and HR Benefits Planning using AO Input forms, rsplan functions, and fox formulas.
• Support of monthly consolidation close in BPC 10.1 and parallel implementation of group reporting/RTC
• Setting up and configuration of master data of FS items, Breakdown Categories, Hierarchies, Transaction Types, Master data for consolidation Fields, Currency Translation and other activities for RTC consolidation.
• Establishing connections for data imports, data retrieval, security set up and integration of planning features.
• Support of existing planning forecasting process using process chain loads, planning functions, data slice locking, running allocation process in BPC, maintaining the roles.
• Worked with currency conversion, business rules within BPC.
• Implementation of HANA modelling and Dashboard in Power BI
• Developed and Architect the solution of HANA 2.0 for engine health business using enterprise HANA, Power BI
• Worked with SDI, SDA and establish connections between HANA,S4 and SQL databases through enterprise HANA
• Well Versed with POWERBI app and developed dashboard with various functionalities including tool tip, tables, charts, pie charts etc.
• Support of Consolidation closing in EPM BPC 10.1 classic

SAP S/4 HANA BPC Architect

Confidential, Mobile, AL

Responsibilities:

• Successfully designed and developed BW Modelling, Hana Modelling, AO Reports and Input Templates, BEX Queries, RSPLAN Workbench activities for Capital Budgeting, Annual Planning and Forecasting for Ingalls Corporation
• Designed and created HANA Native information models (Attribute/Analytic/Calculation) used temporal joins as per the requirement
• Performed Implementation of Annual Operation Plan for Ingalls Corporation in embedded IP. Activated business content and system configuration in S/4 HANA
• Worked on implementing SAP HANA views-based solution for Project systems and Earn Value reporting
• Wrote SQL Script procedures to flatten hierarchies for WBS, CostCenter, Account and populate view from ACDOCA, COPS, COSS tables
• Designed, architected and developed the implementation for HANA views and provisioned data in the clients using the SDI flow graphs and SDI Replicators
• Replicated EVM, PS related tables using SLT and enhanced data sources.
• Built HANA views on ACDOCA, COSS, COSP for Earn Value Management/ PS postings and projections and leveraged the virtual providers for planning and reporting using Analysis for Office
• Built complex reporting models in HANA for PS and Earn value management using existing standard and custom ABAP reports as sources
• Created Input Parameters, Variables and mapping them with AO reports
• Designed, developed and deployed ADSOs to stage data from SAP, Open ODS for Non-SAP field mapping from Mainframes and IBM Congos and Composite providers for reporting requirements.
• Worked on SAP and non-SAP systems to provision data using ETL tools like BODS and ODP

SAP BW / BI / BPC HANA Developer

Confidential, Houston, TX

Responsibilities:

• Led global forecast and consolidation project implementation in BPC.
• Rolled out 30 business segments from excel into BPC for profitability planning.
• Rolled out consolidation process for segment reporting. Led requirement sessions/Workshops and design sessions
• Helped customer to handle multiple currency conversion solution.
• Designed and Configured BPC reports, input forms, data modeling, master data set up and automation, BPF’s, script logic,data manager.
• Acted as a liasion between business process owners and IT monthly forecast closing process
• Designed managment consolidation solution in BPC replacing Hyperion.
• Consolidated 20 Businesses and 5 Segment for Segment reporting for Cash Flow, Income Statement and Balance Sheet Reporting.
• Reduced the forecasting and consolidation closing cycle from 11 days to 6 days.
• Configured business rules, allocation, currency translation, eliminations, journal posting, equity pick up, ownership managment, carry forward, acquistions, cons of investments,BPF
• Created of Semantic DSOs, delta enabling data sources, custom user exits, start/end/Expert Routines, ABAP, Bex/AO/Webi report objects, HANA Information views, Info cubes and Multi providers
• Designed and developed Info cubes, DSO, Extractors, Process chains from PCA data into BPC
• Created HANA attribute views, Calculation views and analytical view for management reporting group
• Implemented preparatory OSS notes for HANA implementation
• Responsible for BW system migration from Oracle to HANA data base
• Migrated BPC classic to HANA database
• Updated all the functionality to run on HANA
• Used ADP’s to automate and convert, aggregate the data into BPC
• Developed BEX report and AO report
• Designed and developed management reporting solution in BPC and BW for corporate finance reporting team

SAP EPM Solution Architect

Confidential, Oklahoma City, OK

Responsibilities:

• Responsible for overall delivering of OGE budgeting and forecasting solution in BPC 10
• Conducted workshops, interviews, business requirement gathering sessions, gap analysis
• Worked on BPC 10 system requirements, software installation guidance, system readiness check.
• Delivered business blueprint, functional and technical design document
• Identified end to end process of budgeting, input templates, report roster for labor planning and Capex budgeting
• Provided solutions to number of complex problems in the design related to WBS design
• Designed and extracted project costs, cost center, HR payroll, CATS, activity rates, statistical key figures into BW and then to BPC
• Developed EPM BPC reports and input forms for capex and HCM labor planning, rolling forecast etc.
• Configured and implemented HCM, capex models, dimensions, properties, script logic, lnput forms, reports, business process flows, work status
• Developed data manager packages, transformation and conversion rules for master data and transaction data load automation
• Wrote ABAP program to automate WBS master hierarchy based on the business logic
• Wrote UJD ROUTINE, UJD CUSTOM Confidential for calculation of HCM costs, moving of data from HCM to CAPEX, settlement and assessment cycle run
• Extracted settlement rules, assessment rules of CO module into BPC for use in cost settlement process

SAP BPC / BI Consultant

Confidential, New York, NY

Responsibilities:

• Conducted interviews, workshops with corporate division and delivered blueprint and functional design documents
• Migrated consolidation solution from legacy consolidation
• Identified the report, dashboards to be created in Xcelcius and WEBI for Financial Statement reports
• Configured BPC business rules, currency conversion, ownership hierarchy, carry forward, minority interest calculation, eliminations, journal entries and others
• Designed the BW solution with identifying the reports, start schema’s, extractors, business content info cubes, data sources, DSO and loading plan for financial reporting
• Developed EPM reports for financial statements and validations of consolidation process

SAP BPC Solution Architect

Confidential, New York, NY

Responsibilities:

• Conducted project assessment for rush BPC initiative
• Conducted kick off meeting and interviewed executive leadership to identify project objectives, business case, key deliverables and milestones
• Evaluated and proposed a phased roll out for budgeting solution for business units, consolidated financial reporting and dash boarding for corporate office
• Delivered project charter document with project plan, scope, key milestones, future design, number of reports, input schedules, assumptions, constraints, high level risks, cost resource, roles and responsibilities
• Proposed time, cost and resource requirements to complete project with a detail bottom up estimation

SAP BPC / IP Implementation Lead

Confidential, Houston, TX

Responsibilities:

• Managed end to end implementation of budgeting system in SAP BPC and BW reporting for downstream refinery plant maintenance
• Conducted multiple workshops for 12 downstream refinery plant managers to determine project objectives & requirements
• Managed the project plan, budget, resources and delivery of complex solution and coordinated between business units, support organizations and delivered key presentations to executives
• Developed functional and technical specifications for 40 reports and input schedules
• Designed and provided guidance to BW/BO blueprint and build with detail process flow of info cube, DSO extractors data loading and process chains strategies
• Created ABAP routines using classes and methods, Confidential ’s, fox formulas for various data streams like planning costs, simulation costs and order header extractors, validations, business calculations in budgeting and inflation calculations

SAP BPC / IP Lead

Confidential, Jersey City, NJ

Responsibilities:

• Managed the implementation of financial planning and forecasting solution in SAP BPC for different business areas and corporate headquarters at Confidential
• Created and Managed schedule, scope and cost plans for build, test & cutover phases
• Designed and configured data model, application sets, applications, input templates for balance sheet planning, P&L, cash flow planning, capital planning, revenue planning, operating expense planning
• Implemented business process flows, work status and locking versions within BPC
• Developed multi hierarchy dimensions for cost centers, internal orders and wbs, extracted master data into BPC dimension member
• Used advanced script logic for fx currency conversions and dimension logic for net income and other cash flow line item calculations
• Troubleshooted and recommended several solutions to BPC 7.0 software issues

BPC Consolidation Lead

Confidential, Augusta, ME

Responsibilities:

• Designed BPC application to automate consolidation of subsidiaries for monthly, quarterly and yearly close
• Configured Inter unit eliminations, account transformation, carry forward rules, validations based on the business and GAAP rules
• Automated data loading of entities/foreign subs from legacy systems
• Developed inter unit eliminations of account receivables/payables, revenues/expenses for both management and legal consolidations
• Developed methods to calculate retained earnings, carry forward, goodwill, cash flow calculations, for operating, investing and financial activities
• Produced and published financial reports of BSP&L and CF in BPC
• Configured ownership rules and used purchase, equity methods to calculate minority interests.
• Developed custom menus on input schedules and reports using vb macros based on the business needs
• Extensively used EVDRE, EVPRO, EVTIM, custom menus to develop input schedules and various complex reports

SAP BW/FICO Senior Consultant

Confidential, Los Angeles, CA

Responsibilities:

• Built and deployed new planning system for entire corporation
• Integrated revenue, Opex, Capex and HR planning solution with income statement planning
• Built and deployed BW system to support planning and reporting
• Coordinated across functional teams for key dependencies
• Implemented complex allocation functionality and plan assessment cycles in FI-CO
• Developed multiple reports in BW front end tool