BENNIE JAY GUEVARRA
SAP BPC/BW Consultant
Summary
•
•
•
•
•
•
High performing and logical-thinking professional/freelancer with more than 11 years of Techno - functional experience in
SAP BPC, for versions (5.0/7.0/7.5/10.0/10.1) in both NW and MS.
Worked on multiple end-to-end SAP BPC implementations including Project Preparation, Blueprint, Configuration, Testing,
Go-live and Support.
Expertise in architecting SAP BPC Classic with EPM BPC Environments, Models, Dimensions, Dimension Properties, Reports,
Input schedules, VBA/Macro Development, DM packages, Security setup, Journal Setup, Work Status Setup, Controls setup,
Business Rules, Advanced Script Logic, Currency Conversions, Intercompany Eliminations and Allocations using Logic Script.
In short, has expertise in almost all areas of an SAP EPM BPC implementation.
Intermediate knowledge in design, development, configuration, testing and deployment of SAP BW data models.
Intermediate knowledge in design, development, configuration, testing and deployment of SAP ECC ETLs using Views and
function module.
Excellent problem-solving, analytical skills and communication skills (verbal and written).
Professional Experience
INTELLYTICS, INC., Makati, PH (May ‘16-Present)
SAP BPC/BW Consultant
• Leads SAP BPC Implementations and Application Maintenance of Intellytics, Inc.
• Responsible for timely delivery of SAP BPC developments.
• Builds the SAP BPC skill set both for Dubai and Manila team.
Projects:
SM PRIME HOLDINGS, INC.
Industry: Property and Development
Implementation/Support Scope: Budgeting
Platform/Application Implemented: SAP BPC 10.1 NetWeaver
• Documentation deliverables: Blueprint, Training Manuals and Configuration Manual
• Design the ETL programs sourcing data from ECC.
• Design and developed BW Data Models that are used as source data in BPC.
• Developed custom VBA programs in Excel that are used in BPC Reports and Input Schedules.
Implementation/Support Scope: Legal Consolidation
Platform/Application Implemented: SAP BPC 10.1 NetWeaver and SAP Disclosure Management 10
• Overall Team Lead for the project
• Design and developed the overall Environment structure of SAP BPC
• Developed and configure IC matching Business rules and Logic Script.
• Design and developed the SAP DM application for 17Q and 17A reporting packages
• Conduct trainings and technology transfer for the end users and consolidators
• Documentation deliverables: Blueprint, Training Manuals and Configuration Manual
• Worked closely with the BW consultant in developing the ETL programs for sourcing data from ECC.
• Design and developed additional BW Data Models for additional adjustments via flat file.
• Developed BW transformation routine for transfer of P&L accounts to Retained Earnings account when moving
to the next fiscal year.
• Helped clients with reconciliation of balances for ECC vs BPC.
• Provides post Go Live implementation support.
Skype: benniejayg
LinkedIn: https://www.linkedin.com/in/kayoyama
Upwork: https://www.upwork.com/freelancers/~01080df0e-a8
SAP: https://people.sap.com/benniejayfguevarra
BENNIE JAY GUEVARRA
SAP BPC/BW Consultant
INTELLYTICS FZ-LLC, Dubai, UAE (Aug ‘14-Apr ‘16)
SAP BPC Consultant
• Leads SAP BPC Implementations and Application Maintenance of Intellytics’ clients both for Dubai and Manila.
• Responsible for timely delivery of SAP BPC developments.
• Builds the SAP BPC skill set both for Dubai and Manila team.
Project:
YUM Sales Forecast Model (In house Project)
Industry: Fast Food and Restaurant
Implementation/Support Scope: Sales Weekly and Monthly Forecasting
Platform/Application Implemented: SAP BPC 10.0 Microsoft
• Design and set up of models for weekly and monthly sales forecasting
• Developed input and report templates using EPM Add-in version 10
• Created custom Data Manager (DTSX) packages for master data and transactional data upload
• Developed the allocation and custom FOREX translation logic
COLUMN5 CONSULTING, PHILIPPINES, Makati, PH. (Aug ‘12-Jul ‘14)
SAP BPC Consultant
• Responsible for the implementation and support of SAP BPC / EPM software.
• Primary responsibilities include development of dimension, business rules and script logics
• Guide fellow BPC Consultants during project implementations
Projects:
MANILA ELECTRIC COMPANY
Industry: Electric Distribution Utility
Implementation/Support Scope: Annual Budgeting for Manpower, OPEX & CAPEX and Five-Year Forecast & Regulatory Reset
Platform/Application Implemented: SAP BPC 10.0 NetWeaver
• Responsible for architecting of models for Planning, Finance, CapEx, HR and Consolidation, Rates and Ownership
• Responsible for configuring the business rules and developing script logic for Consolidation
• Developed input templates using EPM Add-in version 10.
• Setup Journals, BPFs, Work Status.
• Setup Security (Users, Teams, Task Profiles, Data Access Profiles)
GLOBE TELECOM, INC
Industry: Telecommunications
Implementation/Support Scope: Legal Consolidation
Platform/Application Implemented: SAP BPC 10.0 NetWeaver
• Responsible for setting up of models for Consolidation, Rates and Ownership
• Responsible for configuring the business rules and developing script logic for Consolidation
• Developed reports and input templates using EPM Add-in version 10
• Created Transformation files and Conversion files for data upload
• Create BPF Process Templates
• Setup Journals
• Setup Security (Users, Teams, Task Profiles, Data Access Profiles)
Skype: benniejayg
LinkedIn: https://www.linkedin.com/in/kayoyama
Upwork: https://www.upwork.com/freelancers/~01080df0e-a8
SAP: https://people.sap.com/benniejayfguevarra
BENNIE JAY GUEVARRA
SAP BPC/BW Consultant
DIMENSIONSOFT, INC., Makati, PH. (Aug ‘08- Jul ‘12)
SAP BPC Consultant
• Designed and implemented SAP BPC 5.1 to 7.5 version for Microsoft (MS) and SAP BPC 7.0 to 7.5 version for NetWeaver (NW)
for clients in various industries.
• Developed applications, dimensions, business rules, script logic, security, reports and input schedules, using EVDRE, for
financial/operational/statistical reporting and budgeting.
Projects:
PHILIPPINE LONG DISTANCE TELEPHONE COMPANY
Industry: Telecommunications
Implementation/Support Scope: Annual Budgeting - Enhancement
Platform/Application Implemented: SAP BPC 7.0 NetWeaver
• Enhancement for Planning Application
• Developed a streamlined Consolidation for Budgeting
• Developed business rules and script logic.
• Create reports and input templates using EVDRE
MANILA WATER COMPANY
Industry: Utilities
Implementation/Support Scope: Legal Consolidation and Management Reporting
Platform/Application Implemented: SAP BPC 7.5 Microsoft
• Developed script logic
• Create reports and input templates using EVDRE
DEL MONTE PHILIPPINES, INC.
Industry: Fast Moving Consumer Goods
Implementation and Support: Plantation Planning and Information
Platform: SAP BPC 7.0 Microsoft
• Create AppSet and Defining Application to be used and Structuring of Dimension.
• Setting up the application parameters, AppSet parameters, audit report, live reporting and work status
• Security setting: Creation of users/teams/task profile/member access profiles.
• Create Input Schedules and Reports using EVDRE and other EV functions.
• Script logic and MDX.
• Trained the user on how to use build in reports and how to build input schedules and report using EVDRE.
• Support to all users for their queries and any concern on the SAP BPC
METRO PACIFIC INVESTMENTS CORP.
Industry: Investments
Implementation and Support: Legal Consolidation
Platform: SAP BPC 5.1 Microsoft
• Definition and set up of dimensions.
• Modify and maintain the Security and Task Profile.
• Developed templates for their Financial Reports, both Input Schedules and Reports.
• Configured consolidation Business Rules
Skype: benniejayg
LinkedIn: https://www.linkedin.com/in/kayoyama
Upwork: https://www.upwork.com/freelancers/~01080df0e-a8
SAP: https://people.sap.com/benniejayfguevarra
BENNIE JAY GUEVARRA
SAP BPC/BW Consultant
Freelancing Experience
SAP BPC CONSULTANT
TECO ENERGY (SEP ’18-MAR ‘19)
Industry: Electric & Gas Utilities
• Provided remote support in Script Logic and Template trouble shooting.
ACE HARDWARE (JUL ‘18)
Industry: Hardware Stores
• Provided remote support in troubleshooting SAP BPC MS ETL Connections.
GMA NETWORK INC. (OCT ‘14-AUG ’15)
Industry: Broadcasting Company
Implementation and Support: Legal Consolidation
Platform: SAP BPC 10.1 NetWeaver
• Design and develop the Legal Consolidation application structure
• Developed and configure Legal Consolidation, IC matching Business rules and Logic Script.
• Conduct trainings and technology transfer for the end users and consolidators
• Documentation deliverables: Blueprint, Training Manuals and Configuration Manual
• Design the ETL programs with the BW consultant for sourcing data from ECC instances
ENERGY DEVELOPMENT CORPORATION (JAN ‘14-MAR ’14)
Industry: Electricity, Energy, Power & Water
Implementation: Legal Consolidation
Platform: SAP BPC 10.0 NetWeaver
• Design and develop the Legal Consolidation, Budgeting and Forecasting
• Developed and configure Legal Consolidation, IC matching, Currency Translation, Carry Forward Business Rules,
Script Logic, Reports and Input Schedules.
VBA DEVELOPER
Upwork (Jun ‘17-Present)
• Various VBA/Macro Projects for Excel and Access
• Web Scraping Projects using HTML scraping, API and IE Automation
• Google Sheets Automation
Education
BULACAN STATE UNIVERSITY Bachelor of Science (BS) Computer Engineering (2008)
Description
• SAP BPC 7.0 Certification
• SAP
BPC
10.0NW
Administration
Trainings and Certifications
Institution
Location
SAP Philippines
Makati, Philippines
Column5
Makati, Philippines
Date
Jan 2011
Aug 2012
Technical Skillsets
Ability to quickly acquire proficient skills in new technologies. Advance skills in SAP BPC Script Logic, Business Rules, Report Building.
Intermediate skills in SAP BW Modeling and ABAP Coding. Advanced skills in Excel, Access & VBA. Advance skills in creating Stored
Procedures and DTSX packages. Web development (HTML, PHP, CSS).
Skype: benniejayg
LinkedIn: https://www.linkedin.com/in/kayoyama
Upwork: https://www.upwork.com/freelancers/~01080df0e-a8
SAP: https://people.sap.com/benniejayfguevarra
