We provide IT Staff Augmentation Services!

Sap Bpc Project Manager / Solution Architect Resume

2.00/5 (Submit Your Rating)

SUMMARY:

  • 21 Years of IT experience with 18 years supporting/managing SAP on premise ECC solutions, Cloud and SAP Analytics Products
  • Strong hands on functional and technical experience in SAP ECC (FI/CO, HCM), SAP BW, SAP BPC, SAP Business Objects, SAP HANA, SAP Fiori, SAP Confidential Analyzer, SAP Analysis for Office, SAP ABAP, HTML5 and Java Applications
  • 5 years of working experience as Corporate Vice President / Director level.
  • Expert in agile SAP Project Methodology, Post Implementation Support and Incident Management.
  • Expert in understanding technical details, functions of multiple applications/complex systems and their integration.
  • Ability to understand multiple complex business processes and serve as a subject matter expert
  • Ability to work with business and technical teams in assessing and providing technology support
  • Ability to design strategic solutions and provide recommendations to meet challenging business needs
  • Ensure industry and technology best practices are followed in projects with product implementation
  • Create and execute test scenarios to ensure the quality of deliverables to meet business requirements
  • Conduct & participate in business meetings for identification and resolution of project and/or production issues
  • Ability to evaluate potential system enhancements and upgrades and provide recommendations into system roadmap
  • Technical experience connecting SAS solutions, security protocols, certificate management, reverse proxies.
  • Excellent critical analysis, trouble shooting and problem solving skills. Strong understanding of SAP solutions. Comfortable with data and processes
  • Proactive, dedicated, self - directed, out of the box thinker
  • Flexible in business and technology priorities and changing expectations.
  • Willingness to ask questions, take instructions and responsibilities.
  • Excellent Communication Skills with good listening skills and great work ethics.
  • Great Individual Contributor as well as an Excellent team player

PROFESSIONAL EXPERIENCE:

Confidential

SAP BPC Project Manager / Solution Architect

Responsibilities:

  • As SAP BPC Project Manager, owns the delivery of planning solution, which includes discovery, scope, defining project phases and budget for initial build & on-going support
  • Facilitate & lead (if necessary) designing of planning solutions to solve business problems and needs using SAP BPC HANA
  • Review design recommendations to ensure quality and consistency across the footprint
  • Facilitate & lead business requirement definition sessions
  • Facilitate & lead (if necessary) fit-gap analysis via discovery by engaging with business units and other corporate systems team members such as BPC, BI, Security, Basis, SAP FICO
  • Review and/or participate in solution build and test activities on BPC implementations, rollouts, or upgrade projects
  • Understand processes in SAP BPC such as EPM, BADI, script logics and computations
  • Advise on solution roadmap for BPC projects taking into account current Microsoft and Netweaver footprint
  • Business engagement leader by owning relationship at leadership & operational level
  • Demand management for supports and projects for the area of responsibility
  • Resource planning, develop team skill matrix and team work load management
  • Conduct comparative research and recommend strategies for migration from BPC Microsoft to Netweaver and platform consolidation
  • Collaborate with peers in the Corporate systems to apply best practices to integrate between SAP applications (ERP, BW, BO and BPC)
  • Represent expert voice of the Corporate systems with other IT groups in envisioning sessions
  • Become the trusted internal advisor for key business users
  • Assist in troubleshooting production support issues
  • Enhance expertise in the area of SAP products relevant to Enterprise Performance Management, by keeping abreast of literature, participating in webi/seminars, industry and SAP events as necessary
  • Assist in managing the Net Cash Flow & Free Cash Flow planning processes for all estimates, budgets, and long-range plans. This includes consolidating and analyzing key elements such as CAPEX, working capital, and other components of the walk from OCF to FCF
  • Perform analysis for all planning cycles - requiring understanding of business submissions, identifying risks and opportunities and summarizing performance in pitch presentations to senior management
  • Report and analyze actuals and communicate variance drivers and key working capital components and trends
  • Implement Actuals vs Plan reporting
  • Manage and maintain automated reporting for actuals, pacing and planning including prior year and forecast for key components of Net Cash Flow and CAPEX
  • Headquarters Cash Flow planning and reporting
  • Manage and maintain pacing and planning system for Cash & CAPEX (SAP BPC)
  • Identify opportunities and implement process improvements for automation of planning processes, trend analysis and reporting actuals

Confidential, New York

SAP BPC Director / Corporate Vice President

Responsibilities:

  • As an SAP BPC Director, successfully designed and implemented the next generation SAP Planning technology of Simple Finance on HANA, with the Integrated Planning with Planning Application Kit, embedded BW and BPC components, on HEC Platform.
  • Directly managed a 12-member team, and indirectly 50+ consultants.
  • Facilitated / Conducted workshops, gathered the business requirements and created the Blueprint, Functional and Technical specifications for the Integrated Business Planning project implementation for Cost Center Planning, Sales Planning and Financial Planning.
  • Extensively used RSPLAN functions; Aggregation Levels, Filters, Planning Functions, Planning Sequences.
  • Deep IP experience with Input Ready Queries and Planning functions using FOX and ABAP Exits
  • Successfully designed and developed the HANA based real-time Reporting, Planning & Budgeting solution, with the help of HANA Live content and Custom HANA views built.
  • Proposed and Implemented Fiori Apps for SFIN applications and Reports, greatly enhancing the user experience, provisioning smart devices.
  • Designed and Implemented Data Model for IBP / Embedded BW/BPC 10.1 based Planning and Consolidation solution for Financial Planning & Budgeting Application, Cost Center Planning and Revenue Planning applications
  • Designed Data and application Migration process from existing Hyperion based Planning and Consolidation solution to IBP/ Embedded BPC 10.1 NW based BPC / BI-IP Solution, with Analysis for Office as the Front End
  • Helped implementation teams with troubleshooting the performance issues with the extensive experience in developing and debugging FOX Coding logic for custom planning functions
  • Architected the SAP HR Component integration with SuccessFactors components, keeping payroll on the on-premise SAP systems.
  • Architected and implemented SF, Boomi to SAP connectivity, through on premise DataPower layer for Security.
  • Offshore Liaison for regular monitoring of the system with the offshore team as well as for Architecting and implementing further system enhancements

Environment: ECC 6.0 EHP7, IP with PAK, SFIN 2.0/1.0, BW 7.4, HANA 1.0, BOBJ WebI, Crystal Reports, BEx Analyzer, IA, Analysis for Office 2.0/1.4, BOBJ Design Studio, SuccessFactors, Boomi, DataPower.

Confidential, Radnor, PA

SAP BW/BPC/Planning Systems Director

Responsibilities:

  • Conducted workshops, gathered the business requirements and created the Blueprint, Functional and Technical specifications for Reporting Performance improvement, Planning and Consolidation system migration from Hyperion to EPM 10 projects
  • Designed and Developed BW report performance improvement methodologies successfully
  • Proposed a detailed implementation plan on upgrade BWA 7.0 to BWA 7.2 /HANA as to further improve the Data Manager read time, with the Analytical Index, Composite Provider and Hybrid Provider
  • Designed Data Model for EPM 10 based Planning and Consolidation solution for Financial Planning & Budgeting Application, Cost Center Planning and Revenue Planning applications
  • Designed Data and application Migration process from existing Hyperion based Planning and Consolidation solution to EPM 10 NW based BPC Solution
  • Developed and supported transformations from BW to BPC cubes, BPC data loads using process chains
  • Extensive experience in developing and debugging script logic for custom planning functions
  • Offshore Liaison for regular monitoring of the system with the offshore Deloitte team as well as for further system enhancements

Environment: BW 7.3/7.1, BWA 7.0/7.2, ECC 6.0, WAD, BEx Analyzer, SD, MM, FI, PP, CO-PA, Oracle 10.2

Confidential, Woodcliff Lake, NJ

SAP Financial Systems Director

Responsibilities:

  • Gathered the business requirements and created the blueprint and project plans for KPMG Integrated Business System (IBS) CRM Account Planning project with CRM, SEM BPS & BI-IP implementations
  • Designed and Implemented Data Model for CRM BPS Integrated Account Planning & Reporting system using SAP BI 7.0 EHP1 / 7.31 SP4 & CRM 7.0, involving Plan (Real-time) cubes, Summary (Standard) Cubes and Multi Providers, integrating with CRM 7.0 Account Planning component
  • Designed and Implemented Data Model for EPM 10 based Planning and Consolidation solution for Financial Planning & Budgeting Application
  • Designed and Developed Process Chains for BPC data loads, Input Forms and Reports for Planning and Consolidation application
  • Designed and Developed BW transformations to get the Actuals data loaded into the summary cubes from the COPA Engagement cubes and CRM Opportunity Cubes, for the Account Planning System implementation purposes
  • Developed BPS Planning Areas, Planning Levels, Planning Packages, Planning functions (Standard as well as FOX formula, Exit functions), Manual Layouts and grouped the needed planning components in a Planning Profile Group to carryout the CRM - BPS integration
  • Designed and Implemented very innovative CRM BI-IP integrated Account Planning system to accommodate the need for Comments and Person Responsible to be added to plan data at the run time, which could not be achieved in CRM-BPS
  • Developed BI-IP Aggregation Levels, Filters, Planning Functions (Standard functions like: COPY, Delete, Distribution by Reference, Re-valuation, FOX and EXIT functions), Planning Sequences & Web Application Template(s) to build the needed BI-IP Application
  • Extensively used all the features of BW BPS, SEM BPS, BI IP to meet the user requirements like WAD based Application Development, Reference Characteristics in FOX coding, Java customization, Complex Input ready query building using Constants and Hidden Rows/Columns
  • Created Simple as well as Complex Aggregation levels, Filters, Standard Functions, Planning Sequences, Input Ready Queries, FOX functions involving calls to the function modules, and newest features of FOREACH loops
  • Used extensively WAD to integrate different templates (layouts) as per the user requirement using tab structure web item
  • Used extensively binding variables so that Admin functions can be run from the web application developed
  • Designed and Implemented complex reporting like Actuals vs. Plan, Trend Analysis
  • Designed and Lead the team to implement BWA 7.0 (BW Accelerator) with the latest patch implementation across different global member firms, with Alert Server, High Availability and DB Fallback configuration in place
  • Implemented upgrade from BWA 7.0 to BWA 7.2 with the SAP BW upgrade from 7.1 to BW 7.3
  • Designed and developed BI user exits needed to implement the very user friendly Reporting and planning applications interfaces where all advantages of the existing characteristic relationships are taken into consideration
  • Designed and Implemented performance oriented BW reporting and Planning applications catering to the needs of 30000 reporting and 1200 planning users, with BWA implementation and efficient Data modeling to utilize the BWA capabilities
  • Extensively involved in the design and implementation of BW, BPS and IP security using the Analysis Authorization model
  • Designed and developed portal interface for the end users to access to the BW, CRM-BPS & CRM-IP applications for the integration testing
  • Developed the Design documentation, Technical Specifications documents and train the trainer documents
  • Trained the trainers on the usage of the application
  • Extensively supported the users with the issue resolution during the Integration Testing, UAT, during and after go-live
  • Created developer documentation that would help the client developers team to get to the issue resolution quickly

Environment: BW 7.3/7.1, BWA 7.0/7.2, ECC 6.0, CRM 7.0, WAD, BEx Analyzer, SD, FI, CO-PA, HR, MRS, CRM Clients & Opportunity, CRM Marketing & Campaigns modules, MS SQL version 10.5

Confidential, Waltham, MA

Sr. BW / BI IP/ SEM Consultant / Solution Architect

Responsibilities:

  • Gathered the business requirements and created the blueprint and project plans for BI IP project implementation
  • Designed and Implemented Data Model for data warehouse centric Integrated Reporting and Planning system using SAP BI-IP component available in SAP BI 2004(s) version 7.0, Service Pack Stack level 19, involving Plan (Real-time) cubes, Summary (Standard) Cubes and Multi Providers
  • Designed and developed IP based Cost Center, Capital, Revenue, Financial Statement, Consolidations Planning systems
  • Worked with 3 SAP Platinum Consultants and also lead the client’s developer team of 3 people, and 2 independent consultants and acted as a bridge between all the team members in a total team size of 9 people
  • Designed and Developed BW transformations to get the actuals data loaded into the summary cubes from the PCA, CCA and FI Cubes, for the Planning System implementation purposes
  • Designed and developed BI user exits needed to implement the very user friendly planning application interface where all advantages of the existing characteristic relationships are taken into consideration
  • Designed and Implemented performance oriented IP applications catering to the needs of 600 planning users
  • Extensively involved in the design and implementation of BI and IP security using the Analysis Authorization model
  • Designed and developed portal interface for the end users to access to the IP applications for the integration testing
  • Involved in the BI portal interface design for the UAT for IP applications access
  • Extensively used all the features of BI IP, like WAD based Application Development, Reference Characteristics in FOX coding, Java customization, Complex Input ready query building using Constants and Hidden Rows/Columns
  • Created Simple as well as Complex Aggregation levels, Filters, Standard Functions, Planning Sequences, Input Ready Queries, FOX functions involving calls to the function modules, and newest features of FOREACH loops
  • Used extensively WAD to integrate different templates (layouts) as per the user requirement using tab structure web item
  • Used extensively binding variables so that Admin functions can be run from the web application developed
  • Designed and Implemented complex reporting like Actuals vs. Plan, Trend Analysis
  • Developed the Design documentation, Technical Specifications documents and train the trainer documents
  • Trained the trainers on the usage of the application
  • Extensively supported the users with the issue resolution during the Integration Testing, UAT, during and after go-live
  • Created developer documentation that would help the client developers team to get to the issue resolution quickly
  • Designed and Developed an BI-IP based Flash (estimating actuals) application for Services division of FMCNA

Environment: BI 7.0, ECC 6.0, WAD, BEx Analyzer, FI, PCA, CCA modules, DB6 (Db2

Confidential, IL

Lead BI IP/ SEM Consultant

Responsibilities:

  • Gathered the business requirements for BI IP project implementation
  • Jumped in the last stage of the project and steered the users and developers towards a direction to get the project implemented successfully
  • Designed and Implemented Data Model for IP project implementation involving Plan (Real-time) cubes, Summary (Standard) Cube and Multi Providers
  • Designed and Implemented IP based Employee, Non Employee and Other Expenses Planning systems
  • Extensively used all the features of BI IP, like WAD based Application Development, Reference Characteristics in FOX coding, Complex Input ready query building using Constants and Hidden Rows/Columns
  • Created Simple as well as Complex Aggregation levels, Filters, Standard Functions, Planning Sequences, Input Ready Queries, FOX functions
  • Used extensively WAD to integrate different templates (layouts) as per the user requirement using tab structure web item
  • Used extensively binding variables so that Admin functions can be run from the web application developed
  • Designed and Implemented complex reporting like Actuals vs. Plan

Environment: BI 7.0, ECC 6.0, WAD, BEx Analyzer, FI, HR modules

Confidential, Bridgewater, NJ

Sr. BI/ SEM-BPS Upgrade Consultant

Responsibilities:

  • Involved in Successful Upgrade of LDSE and GDSE systems as a technical and functional BI/BPS resource
  • Created test scripts by understanding the existing business processes
  • Gathered all the test scripts for the required functional area to be tested thoroughly for BI upgrade
  • Worked as a part of technical team, fixed BI/BPS defects that as a result of upgrade
  • Fixed the upgrade issues with BSP applications about fonts & comments in layouts and file upload applications
  • Implemented the new Lock Server changes corresponding to the old concept
  • Involved in successfully testing the portal changes by understanding the new federated portal concept
  • Involved in testing Crystal reports and publishing crystal reports with the new roles\
  • Fixed the issues related to Unicode changes
  • Worked on Bravo Consolidation Reporting business process and took the process through upgrade
  • Worked in multiple functional areas: FI reporting, Sales Reporting, Cost Reporting, Bravo - Financial Consolidation Reporting
  • Raised OSS messages to SAP to report the issues resulted in BI upgrade
  • Involved in three testing cycles and executed the test scripts to check the functionality of BI upgrade system and documented with the screenshots that compare the current landscape with the new landscape
  • Created Load runner test scripts and scenarios to stress test the BI upgrade systems
  • Extensively checked the BI Analysis authorization for security issues
  • Created well defined documentation for the Change Controls opened and also created the corresponding Technical Design documents

Environment: BI 7.0, ECC 6.0, BEx Analyzer, SD, MM, PP, FI-CO, CO-PA

Confidential, Bridgewater, NJ

Sr. BI IP/ SEM Consultant

Responsibilities:

  • Gathered the business requirements and planned for the BI IP project implementation
  • Designed and Implemented IP based Cost Center and Sales Planning
  • Designed and Implemented BW reporting solution for SD, MM, PP and FI/CO modules
  • Designed and Implemented various Planning Functions both standard and custom based on ABAP and FOX to enable the functionality required by the various levels of planners at Cephalon
  • Designed and Implemented BW/SEM Data Model for Enhanced BCS Reporting performance improvement
  • Designed and Implemented Web Based On Demand BCS Loads scheduler application using SEM-BPS layout and Exit Function, where users can schedule the BCS Enhanced Performance reporting loads on their own
  • Designed and Implemented Integrated Planning Applications by which various planners would implement the Annual and Outlook Planning (Rolling Plan)
  • Worked to enable the Outlook/Monthly/Rolling plan, complex input enabled layouts are designed and implemented using the Multi Cube, which will combine the data from both the Actuals Cube and Planning Cube (real-time cube), without the need to copy the actuals into the Planning Cube
  • Configured the system mainly performance and functionality into consideration
  • Configured Planning Area, Levels, and Packages with reference to avoiding locking
  • Configured Aggregation Level and Filters with reference to the efficiency and to avoid locking
  • Wrote Variable Exits, Exit Functions, Formula Functions to support the various elements of the business process for planning
  • Used Copy, Distribution, Revaluation, Repost, Exit & Formula functions extensively
  • Combined Actuals and Plan seamlessly into Planning Layouts using Dynamic Characteristics and Variables
  • Designed and developed complex GUI and Web queries, Dash Boards on the BPS & BW reporting Multi Cubes
  • Designed and implemented configuration changes for both load performance and query performance optimization
  • Handled post product support and performance issues

Environment: SAP NetWeaver 04, ECC 6.0, BEx Analyzer, SD, MM, PP, FI-CO, CO-PA

Confidential, Piscataway, NJ

Project Lead

Responsibilities:

  • Lead the implementation of BW/SEM NW2004s Upgrade Project
  • Analyzed the new features of NW 2004s like Integrated Planning, Improved Reporting features, and define the use cases for the business
  • Led current BW/SEM applications support required by the business, with a 7 member team, with hands on experience
  • Assigned tasks to the team to get the various projects implemented on time
  • Led the APO DP system enhancement project
  • Gathered the business requirements and plan for the project implementation
  • Led the effort to get the American Standard NW2004s system upgrade from 3.0b version to NW2004s for BPS Cost Center Planning, Sales Planning, Marketing Planning application, BW Logistics, CO-PA, FI/CO and APO-DP reporting
  • Led the development effort of new Web Reports
  • Led the development of Enterprise Portal as part of Net Weaver 2004s upgrade
  • Led the effort of utilizing Solution Manger for the Change Requests
  • Led the post production support issues
  • Led the training effort for the end users
  • Led the effort to get the BI system utilized for various functional areas of the organization

Environment: SAP NetWeaver 2004s, XI, MDM, ECC 6.0, BEx Analyzer, SD, MM, PP, FI-CO, CO-PA, CRM 5.0

Confidential, Chicago, IL

Lead BW/ BWA/ SEM BPS/CRM-TPM Consultant

Responsibilities:

  • Designed and Implemented BW Data Model, Web Based SEM-BPS Marketing and Finance Planning, Sales Planning, using Net Weaver ’04, integrated with CRM Trade Promotion Planning
  • Implemented BW Upgrade as part of the team, from version Net Weaver 04 to Net Weaver 2004s
  • Led the complete implementation of BW and SEM for the applications required by the business, with a 7 member team
  • Implemented BWA 6.2 successfully to improve the Query performance
  • Activated Business Content, did GAP analysis, then Designed and Developed enhancements to the standard content, custom InfoCubes, ODS objects, InfoObjects, InfoSources, Transfer Rules and Update Rules
  • Designed and Developed BEx queries, web templates and dash boards using BEx Analyzer and Web Application Designer
  • Involved in the requirements gathering and writing detailed functional specifications
  • Designed and Implemented complex Planning Layouts, Web Interfaces, Planning Folders enabling planners to create plan data
  • Implemented CRM/TPM project from the SEM BPS side using Advanced Planning Services and proficient in configuration aspects of the CRM /SEM integration
  • Implemented Account Planning and Brand Planning using SEM-BPS
  • Designed and implemented various Planning Functions both standard and custom based on ABAP and FOX to enable the functionality required by the various levels of planners at Wrigley’s
  • Designed and Implemented Planning Folders, by which various planners would implement the Annual and Outlook Planning (Rolling Plan).
  • To enable the Outlook/Monthly/Rolling plan, complex layouts are designed and implemented, which will combine the data from both the Actuals Cube and Planning Cube, without the need to copy the actuals into the Planning Cube
  • Configured the system mainly performance and functionality into consideration
  • Configured Planning Area, Levels, and Packages with reference to avoiding locking
  • Written Variable Exits, Exit Functions, Formula Functions to support the various elements of the business process for planning
  • Used Copy, Distribution, Revaluation, Repost, Exit & Formula functions extensively.
  • Combined Actuals and Plan seamlessly into Planning Layouts using Dynamic Characteristics and Variables
  • Designed and developed complex GUI and Web queries, Dash Boards on the BPS & BW reporting Multi Cubes
  • Designed and implemented configuration changes for both load performance and query performance optimization
  • Handled post product support and performance issues.

Environment: SAP Net Weaver ’04, BWA 6.20, XI, SAP R/3 4.7.2 Enterprise, BEx Analyzer, FI-CO, CO-PA, SD, CRM 5.0

Confidential, Hershey, PA

Senior SAP BW/SEM-BPS Consultant

Responsibilities:

  • Designed and implemented BW Data Model, Web Based Marketing and Finance Planning, and Sales Planning, using Net Weaver ‘04
  • Involved in the requirements gathering and writing detailed functional specifications.
  • Designed and Implemented complex Planning Layouts, Web Interfaces, Planning Folders enabling planners to create plan data
  • Designed and implemented various Planning Functions both standard and custom based on ABAP and FOX to enable the functionality required by the various levels of planners at Hershey Foods
  • Designed and implemented Planning Folders, by which various planners would implement the Annual and Outlook Planning (Rolling Plan)
  • Configured the system mainly performance and functionality into consideration
  • Performed run the BPS statistics before live and followed the ASAP methodology to improve the performance of the system
  • Configured Planning Area, Levels, and Packages with reference to avoiding locking.
  • Wrote Variable Exits, Exit Functions, Formula Functions to support the various elements of the business process for planning
  • Used Copy, Distribution, Revaluation, Repost, Exit and Formula functions extensively
  • Combined Actuals and Plan seamlessly into Planning Layouts using Dynamic Characteristics and Variables
  • Designed and developed complex GUI and Web queries on the BPS reporting Multi Cubes
  • Designed and implemented configuration changes for both load performance and query performance optimization

Environment: SAP NetWeaver ’04, XI, SAP R/3 4.7.2 Enterprise, BEx Analyzer, FI-CO, CO-PA

We'd love your feedback!