SUMMARY

• SAP BPC 10.1/BI/BPS/IP/HANA Architect and Senior Consultant with 6 years in BPC and with an overall Software Experience of 30 years.
• MDM and Data Governance Project Manager with over 17 years of IT experience and 15 years in leading, managing, architecting using SAP and Informatica tools.
• Strong in Master Data Management and Data Governance
• 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 MDM, 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 MDM, 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 MDM, 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

PROFESSIONAL EXPERIENCE

Confidential, Redmond, Washington

BPC 10.1 Solution Architect & SME

Responsibilities:

• Working as BPC SME and business analyst on enhancements
• Working as Principal BPC architect and BPC program manager
• Developed functional and technical specifications for a new Expense model
• Developed functional and technical specifications for COGS model modifications
• Developed functional and technical specifications for Margin model to include Gaming & Live LOB requirements
• Created Unit and SIT test scripts and coordinated SIT and UAT test cycles to completion
• Responsible for multiple enhancement releases from start to go-live
• Coordinated and managed Confidential and SAP development teams to resolve EPM issues for new releases *SP25, SP25 Patch 1, Patch 2, and Office 2016 32 and 64 bit versions)
• Developed Transformation and conversion files for new expense model
• Developed unit tests and coordinated SIT and UAT to release to production
• Coordinated and managed Confidential and SAP development teams to resolve EPM issues for new releases *SP25, SP25 Patch 1, Patch 2, and Office 2016 32 and 64 bit versions)
• Implemented and went live on COGS model modifications and Expense models

Confidential, Modesto, California

BPC 10.1 Lead Solution Architect and SME

Responsibilities:

• Worked on migrating BPC application from MS7.5 to MS10.1
• Completed migrating 7.5MS reports (EVDRE) to 10.1MS reports utilizing new EPM functions
• Migrated DLP (Data Link Packages) from 7.5MS and 10.1 MS versions
• Trained business users on developing BPC input schedules and utilizing new EPM functions
• Streamlined daily data loads to improve data load times
• Developed Functional Unit and integration tests with planning scenarios for migrated reports

Confidential, Santa Clara, California

BPC 10.1 and MDM Lead Solution Architect and Technical Manager

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
• Developed Functional Unit and integration tests with planning scenarios
• Defined scope, Managed and delivered Informatica MDM/ETL solution for six finance data domains including master data, standard and external hierarchies
• Developed with team Data Governance to create, modify, and approval process for six finance data domains
• Created and managed COE, Process Council, and steering committee teams for ongoing Data Governance
• Conducted workshops and gathering business requirements for Cost Center, Profit Center, Managerial Country, Physical Location, Product Line, VP hierarchy nodes, and GL Account
• Conducted workshops on data profiling for 7 data domains
• Developed logical Finance Data model and key design recommendation for 6 data domains
• Worked with team on data design and created business glossary for 6 data domains
• Worked with COE team on Role definition and security
• Delivered integration specifications for MDM/ETL/ECC/BW/BPC interfaces and in additional multiple non-SAP interfaces
• Coordinated and executed Functional Unit, integration, and User Acceptance tests
• Integrated MDM solution to portal for easy access with better user interface for finance analysts

Confidential

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
• Developed Functional Unit and integration tests with planning scenarios

Confidential, Electronics, 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

Project Manager

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

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

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

Project Manager

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

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

Project Manager

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

Project Manager

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

Confidential

BPC NW 7.0 Solution Architect

Responsibilities:

• Gathered requirements form their existing Hyperion planning model to map into BPC.
• Lead the ‘blueprint’ phase to deliver a ‘Business Process Design’ document for consolidations in SAP BPC by implementing ASAP methodology
• Designed and assisted in identifying apsets, dimensions, and logic.
• Resolved server configuration issues.
• Worked on 7.0 version of BPC

Confidential

BPS Project Manager and Technical Lead

Responsibilities:

• Led 7 members of BPS/BI/BPC on both functional and technical side of 9 existing applications.
• Designed and configured for two new applications (liquidity planner and Plant Maintenance) in BPS.
• Provided roadmap and plan to transition from BPS to BPC. .
• Successfully transitioned development and support activities from previous to current SAP vendor.
• Successfully transitioned knowledge transfer on 9 BPS applications and delivered functional documents on all of them.

Confidential

Senior consultant, BI

Responsibilities:

• Responsible for BI Go-Live with 9 BI reports and setting up the process for post BI Go-Live.
• Responsible for defining and designing MAP layouts.
• Responsible for defining and implementing Fox functions.
• Responsible to lead BI and MAP technical leads
• Achievements:
• Worked with Business users to define the requirements and provided solutions to the team on flash and other BI reports
• Led 15 team members (client/SAP employees) for a successful BI Go-Live and MAP development

Confidential

BI/IP Project Manager and Technical Lead Consultant

Responsibilities:

• Responsible for completion of Cash Flow planning using BI and IP.
• Responsible for conducting workshops and to gather requirements.
• Responsible for data modeling and completing Proof of Concept and Blue Print.
• Designed and Created infocubes, infoobjects, Aggregation levels, filters, and planning functions.
• Developed queries using Query Designer.
• Developed Portal based IP using Web Application Designer

Confidential

SEM Manager/BPS Team Lead

Responsibilities:

• Responsible to Lead a team of 5 SEM-BPS employees and consultants.
• Responsible for design, configuration, development, and realization of Liquidity Planning (Cash Flow and Foreign exchange) project using Liquidity Planner.
• Designed and Created infocubes, infoobjects, layouts, fox functions and guided on exit routines.
• Developed and guided exit variables to accommodate different fiscal year calendars for different company codes
• Developed to be used thru a portal and in excel.
• Gathered user requirements and completed Blueprint.
• Also responsible to manage two offshore resources in testing for NW2004S upgrade

Confidential

Project Manager

Responsibilities:

• Responsible for the Design, Development and Testing of a Sales Planning application and Cost Center Planning application in SEM-BPS.
• Gathered requirements from the Core Team (users) for understanding the planning scenario/functionality they currently have in R3 for Cost Center Planning.
• Also understand the business (planning) processes.
• Created the required BW Objects for the BPS Planning environment. Based on the actual R3 SD Data model in BW.
• Activated the SEM-BPS related Business Content in SEM-BW, based on the requirements gathering and also the existing Cost Center Planning Reporting solution in BW
• Design BPS Planning Environment architecture with area, levels, and packages.
• Worked in the areas of Capital Budgeting, Labor Costs, and Overheads etc.
• Designed the Planned application based on a reference model, for enabling the users to plan based on Actuals extracted from R3 into BW.
• Designed and Developed Layouts, End User Interface (Planning Folders) and also Architected Top Down planning.
• Designed and Developed Planning functions such as Copy, Distribution etc.
• Developed functions using FOX formulae. Architected a Top Down planning.

Confidential, Electronics, CA

Project Manager and Senior BW Consultant

Responsibilities:

• Involved in design, development and testing of a procurement solution based on R3 Purchasing Module.
• Customized the Purchasing Extract Structures in Logistics Extraction Cockpit for Purchase Orders, Items and Schedule Lines.
• Enhanced the Extract Structures in R3. Developed an Extraction strategy for Purchasing data.
• Scheduled extract jobs with BW Scheduler and monitored transfer/update of data loads into InfoCubes with BW Monitor.
• Extensively used process chains to automate the process of loading data into data targets.
• Worked closely with Users created custom queries using BEx Analyzer

Confidential

Senior BW Consultant

Responsibilities:

• Tasks include studying the Business Process and Designing the Architecture for the desired Reporting solution.
• Involved in design, development and extraction from Non-SAP Databases thru flat file to BW.
• Performed various tuning techniques (aggregates, statistics and partitioning) to optimize the query performance.
• Developed flexible queries using filters, navigational attributes, variables, calculated key figures, restricted key figures, exceptions, conditions in BEx analyzer to facilitate data analysis in a drill down or summarized way to give detailed level of information.
• Developed Reporting system on web using web application wizard.
• Created Custom Info cubes/objects for the accommodating the global data available across the organization including data from SAP and Non-SAP data