Bpc10.1 Lead Solution Architect Resume
Santa Clara, CaliforniA
PROFILE:
- SAP BPC 10.1/BI/BPS/IP Senior Consultant with over 17 years of IT experience, 15 years in SAP, 4 years in BPC and with an overall Software Experience of 30 years.
- Strong in budgeting, planning and forecasting areas
- Proven experience in both Functional and Technical areas of FI, COPA, PS, GL
- Multiple end - to-end implementation experience in BPC, BI, BPS, and IP from requirement gathering, Blue Print, Design, development to Go-Live.
- Extensive experience in defining and executing multiple SAP BPC roadmap based solutions for financial planning
- Experienced in all areas of BPC, HANA, BW, BI, BPS, MAP, IP - Proof of Concept, Modeling, Development, Extraction, Reporting, Performance tuning.
- Experience in consolidations activities such as balance carry forward, journal entries and validation, and inter-company eliminations.
- Familiar with Tax provisioning based on USGAAP, IFRC, and FERC
- Versed in BPC Financial Planning in areas such as cash flow, budgeting, liquidity, etc.
- Extensive experience in BEx Analyzer and working knowledge of WEB Reporting
- Industry experience: Beverage, Public Sector, Heavy Industries, Consumer Goods, Utility, Retail, Media and Entertainment, Electronics, Semiconductor Chips and Electronic Equipment, Pharmaceutical and Hospitals
- Experienced in Project management of complex software projects
- Experienced in both Agile and Waterfall frameworks
- Utilized successfully Scrum methodology for Agile frameworks
- Team Lead in both Functional and Technical Areas of BPC, SEM-BPS, BW, BI, IP, and MAP
- Experience in SAP EPM 10.1 (Standard and Embedded models), SAP BPC 10, SAP BPC 7.5 NW and 7.5 MS, 5.1 MS Versions
- Expertise in trouble shooting, MDX/Script logic performance related improvements
- Expertise in the Design and creation of Application Sets, Applications, Dimensions, Members and Properties, Drill-through to different sources, and Automatic distribution or bursting of reports.
- Worked on Transformation and Conversion files to perform data transformations.
- Experience in executing Data Management Packages to load data into applications.
- Used Worksheet Logic, Dimension Logic, Script Logic, and Business Rules to perform various calculations and foreign currency translations.
- Developed complicated input schedules and reports
- Experience in using EPM functions for input schedules and reports
- Designed and developed Balance Sheet, P&L, Trial Balance, forecasting with variances reports
- Involved in analysis and reporting. Worked with the functions like EvDRE, EvSND, EvGTS. EvHOT, and EvCOM in BPC for Excel.
- Worked on 2004S implementation, BI-IP, Web application designer (WAD), Query Designer
- Experienced in SEM-BPS with complicated FOX functions in Liquidity, Cost Center, Financial, and HR planning
- Completed in 5 BPC, 4 SEM-BPS, 3 BI, 1 IP, and 1 MAP end to end implementations
- Experienced in all areas of BW and BI - Modeling, Extraction and Reporting
- Expertise in working with BW Business Content as well as developing custom solutions
- Extensive Business Process Knowledge of R3 in the areas of FI, CO-PA, and MM
EXPERIENCE/PROJECT WORK:
Confidential, Santa Clara, California
BPC10.1 Lead Solution Architect
Responsibilities:
- Conducted workshops and gathering business requirements for HR, Opex, and Capex budgeting solution
- Conducted workshops and gathering business requirements for Gross Margin Planning
- Responsible for designing Gross Margin and Cost Center models (Standard and Embedded)
- Designed BPC10.1 security
- Defined integration specifications for ECC/BW/BPC interfaces and in additional multiple non-SAP interfaces
- Completed blueprint for GM and CC planning models
- Developed EPM based Input schedules and Reports
- Developed complex cell based and dynamic range input schedules and reports
- Develop Functional Unit and integration tests with planning scenarios
Confidential, California
BPC10 Lead Solution Architect
Responsibilities:
- Conducted workshops and gathering business requirements for Cost Center budgeting solution
- Conducted workshops and gathering business requirements for Gross Margin Planning
- Responsible for designing Gross Margin and Cost Center models
- Designed PC10 security
- Defined integration specifications for ECC/BW/BCC interfaces
- Completed blueprint for GM and CC planning models
- Developed EPM based Input schedules and Reports
- Developed complex cell based and dynamic range input schedules and reports
- Develop Functional Unit and integration tests with planning scenarios
Confidential, California
Project Manager and BPC10 Solution Architect
Responsibilities:
- Managed the PC10 team for Blueprinting and implementation for Gross Margin application
- Conducted workshops and gathering business requirements for CCA budgeting solution
- Responsible for running the project and delivering Blueprint and design documents
- Responsible for designing Gross Margin models
- Designed PC10 security
- Worked with the team as a lead to design OPEX, CAPEX, HCM models
- Responsible for identifying Dimensions and Models for the project
- Responsible for Data Integration with BW
- Responsible for new 7.3 BW installation
- Completed Blueprint and signed off by client
- Extensively used EPM functions and EPM reporting formats
- Developed Input templates and financial reports
- Developed IS, P&L, and Financial Statement, Trial Balance reports
- Defined and Designed integration, transformation, and BADI specifications for ECC/BW/BCC interfaces
Confidential, Michigan
Project Manager and BPC10 Solution Architect
Responsibilities:
- Worked on RFP and obtained the PC10 Planning project
- Managed the PC10 team for Blueprinting and implementation
- Conducted workshops and gathering business requirements for budgeting solution
- Responsible for running the project and delivering Blueprint and design documents
- Responsible for designing Revenue/Gross Margin/NOIE models
- Designed PC10 security
- Worked with the team as a lead to design OPEX, CAPEX, HCM models
- Responsible for identifying Dimensions and Models for the project
- Responsible for Data Integration with BW
- Responsible for new 7.3 BW installation
- Completed Blueprint and signed off by client
- Designed and developed Gross Margin and Revenue model
- Extensively used EPM functions and EPM reporting formats
- Defined and Designed integration, transformation, and BADI specifications for ECC/BW/BCC interfaces
Confidential
Project Manager and BPC10 Solution Architect
Responsibilities:
- Part of SAP Canada Architecture team for blueprinting EPM10 BPC Planning project
- Conducted workshops to develop data integration business requirements
- Developed Scope and design document
- Designed DM package, Allocation BAdi’s, and functional calls
- Identified and designed all data integration points
- Designed the EPM10 Security model based on client’s requirements
- Designed the EPM10 landscape based on standalone system requirements and with their current BW system
- Completed the playbacks and final sign-off on data integration blueprint
Confidential
Project Manager and EPM/BPC Solution Architect/Lead
Responsibilities:
- Successfully managed BPC project and team and delivered on schedule
- Conducted workshops to develop business requirements
- Developed Scope and design document
- Configured the BPC system and developed appset/applications
- Created ETL packages to load data from Oracle DB into BPC for GL and Labor summary and detail data
- Created Input schedules for budget and labor related drivers
- Developed script logic for run default logic while loading and Inputting data
- Created custom reports using EvDRE, EvHot, EvGet, EvSnd,etc
- Developed solution for Bursting or automatic distribution of reports based on Cost Center or LOB
- Developed queries for drill through to various transaction data sources
- Improved performance on data loads and running of scripts
- Developed Business Objects Universe connecting to BPC cube in order to create reports
- Worked with SAP America development team to get fixes on BPC product issues
Confidential, CA
Project Manager and EPM 10/HANA Solution Architect/Lead
Responsibilities:
- Created roadmap to transition from BI-IP to BPC
- Conducted workshops to develop business requirements
- Developed Scope for Prototype based on new capabilities of EPM 10
- Mapped objects from BI-IP Into BPC 10.0
- Developed Part of P&L Planning application (Depreciation planning)
- Developed Script logic for calculations on depreciation planning
- Managed IP Project and team in the transition
Confidential, Erlanger, KY
BPC Solution Architect/Project Manager
Responsibilities:
- Provided solution and roadmap based on new BI and BPC products
- Conducted workshops to gather requirements
- Developed SOW
- Completed architecture and Blueprinting
- Worked with and trained employees on BPC
- Worked on transformations, process chains for automatic loads of master and transaction data
- Developed script logic for summarized project systems data to be stored in a different application for management reporting
- Created models based on client’s current TM1 and Hyeperion models for consolidation and planning
- Developed Prototype and handed over to client for further development
- Defined and Designed integration, transformation, and BADI specifications for ECC/BW/BCC interfaces
Confidential, Springfield, IL
Project Manager and BPC Solution Architect/Lead
Responsibilities:
- Gave presentations on BPC NW 7.5
- Provided solution and roadmap based on BI and BPC
- Conducted workshops to gather requirements
- Developed SOW
- Completed architecture and Blueprint
- Worked on transformations, process chains for automatic loads of master and transaction data
- Created models based on client’s current excel based models of consolidation and planning
- Defined and Designed integration, transformation, and BADI specifications for ECC/BW/BCC interfaces
Confidential, Cincinnati, OH
Project Manager and BPC Solution Architect/Lead
Responsibilities:
- Provided roadmap and solution based new MS 7.5 BPC releases
- Upgraded BPC system from 5.1 MS to 7.5 MS SP4
- Modified dimensions and logic files to meet 75 MS requirements
- Modified DTSx pacakages to meet SQL 2008 Server and 75 MS requirements
- Tested upgraded system with business users and got sign-off
- Worked with SAP development teams (Asia/Europe/US) to provide solution on query performance improvements
- Successfully executed the project on budget
- Improved performance on data loads and running of consolidation script logic
- Supported BPC application issues for more than a year
