Bennie Jay Guevarra

SAP EPM BPC
More than 11 years of SAP BPC experience, both Microsoft and NetWeaver from version 5 - 10.1. Highly skilled architecting the dimensions, models and environment for SAP BPC, writing Script logic, configuring Business rules for Consolidation and creating Report and Input Templates using EPM add-in. In short, has expertise in almost all areas of an SAP EPM BPC implementation.

SAP BW/ABAP
SAP BW skills include the following:
Standard Data Flows
Generic Extractors
Custom Extractors (Using Table, Views or Function Module)
Data sources
Data Transfer Processes (DTPs)
DSO
Info cubes
Info objects
Info packages
Process Chains
Transfer Rules
Update Rules
Custom ABAP Coding:
Start & End routines
Custom Function Module for Extraction

*VBA/ Macro/ Google Spreadsheets
Develop automations using Visual Basic for Application (VBA) in Excel, Access, Word and PowerPoint based on business/ client requirements. Past projects include Email sending automation, extraction of image from Excel to file, creation of user forms, text splitting, database integration, creating Access queries, Access forms, data extraction from web using with or without API. Also has inadept experience coding Google Script for Google Spreadsheets because of its almost similarities with VBA.

MSSQL
Advanced level of proficiency MSSQL queries and Stored Procedures, used in database integration. Intermediate knowledge in creating SSIS packages used in moving of data in MSSQL.

Web Scrapping/Extraction
Has experience in creating web scrapping/ extraction programs using Excel VBA and phyton3. I’ve scrapped mostly cryptocurrency websites, company and product information websites.