Data Sap
Resume:
GENERAL SUMMARY
SAP BPC projects as lead, consultant, SME (Subject Matter Expert), has eleven (11) years of experience with Projects range from OutlookSoft 4.2 to the latest version named BPC 10.1 and BPC on Hana Embedded.
Responsible for Data packages moving data from SAP ERP to staging area in BW to BPC. User Interfaces, Input Schedules, Reports, Packages and schedules. Step by step instructions and User Acceptance go live. Interfaced different BPC modules like HR, Sales, Production as aggregations into the general planning model.
Data validation, import and reconciliation from a myriad of systems. (mapping, conversion and transformation) files, loading data writing Data Packages and links, SAP ERP, BW.
Build several PoC’s (Proof of Concepts) on BPC 7.0 Microsoft and BPC 10 Netweaver platforms and presented successfully. Kraft wanted to immediately use the PoC in production.
Designed input schedules and reports for a wide range of users in the different BPC versions and Excel add ins like EvDRE, EPM and Analysis for office using BEx. Used Visual Basic and extensive formulas in Excel, local members dynamic references and tuples in EPM
Used the know-how of Excel in combination with BPC to give the finance department the first line clients a knowledgeable feeling about BPC, and used the same techniques to show management the value of the project.
TECHNICAL SKILLS
BPC skills in the NetWeaver and Microsoft platforms:
Functional and technical knowledge: Scoping, Architect, Design, Dimension builds, Hierarchies and attributes, Data conversion, Data transformation, Data packages and links, User facing input schedules and Reports (EPM, Analysis and EvDRE, all Excel add-ins), Security, Script Logic and Business Rules, Excel Logic, Business Process Flows (BPF), administrative functions, security.
SAP:
SAP IBP (Integrated Business Planning) knowledge, BW (Business Warehouse), BEx (SAP’s Business Explorer), SAP BusinessObjects Analysis for Office, MPR (Merchandise Planning for Retail), APR (Assortment Planning for Retail), SAP BusinessObjects Cloud.
EDUCATION
MBA Business Administration Finance/Accounting, Leidsche Onderwijs Instellingen, Leiden, The Netherlands
Bachelors of Information Technology, Programming, system architecture, databases, Stichting Exin, Utrecht, The Netherlands.
Certifications:
MICRO SOFT: MS Office Expert
SAP: BPC, ASAP, SolMAN
KRAUTHAMMER, Switzerland, Management and Sales
OSTERIO GROUP: Managing Successful Business Processes
OPEN SAP: Introduction to Software Development on SAP HANA, SAP Business Suite 4 SAP HANA in a Nutshell, SAP S/4 HANA Deep Dive, Driving Business Results with Big Data, Transformation to Hybrid Landscapes, SAP Business warehouse powered by SAP HANA, High Availability and Disaster Recovery with the SAP HANA Platform, Developing Web Apps with SAPUI5, SAP HANA Cloud Platform Essentials. Software Design for Non Designers, Implementation of SAP Business Objects Cloud, Experience SAP Hybris Solutions, Extending SAP S/4HANA with SAP HANA Cloud Platform, Application Integration Made Simple with SAP HANA Cloud Integration, SAP Digital Boardroom in a Nutshell, Enabling Entrepreneurs to Shape a Better World, Find Your Path to S/4 HANA., Introduction to SAP Personas, Getting started with Data Science, Extending SAP S/4HANA with SAP HANA Cloud Platform, Be Visual! Sketching Basics for IT Business, Getting Started with SAP BusinessObjects Roambi, SAP Business ByDesign Financials.
Hubertus A. Burm
903 W 145TH Way
Westminster
CO 80023
****.****@*****.***
“Huub Burm has proven his worth! This top-notch consultant helped built a solid application which increased the closing time considerably”
-Matthew Sprong
Minneapolis MN
“Huub has been one of the most helpful consultants I ever met. Always willing to put in the time needed to finish the project, always helpful to take the time to explain and teach us. Found some astonishing ways to do our allocation and found double budgeting for over 3 million Pounds. Found ways to integrate the HR application seamless into the budgeting app.”
-Gaunt Russel
Aberdeen, Scotland
PROFESSIONAL WORK EXPERIENCE Hubertus Burm
GLOBAL EFFICIENCY, Westminster, CO Jan. 2017- Present
Skin Concepts Inc. Jan 2017 - Present
Contribution:
Responsible for set-up accounting system and reporting, ongoing monitoring.
BEYOND TECHNOLOGIES, Montreal, Canada Sep. 2016 – Nov. 2016
PLANNING SAP Consultant (General and Retail) Sep. 2016 – Nov. 2016
Contribution:
Responsible for SAP BusinessObjects for Cloud Proof of Concept. Complete set-up of a cloud system calculating gross profit using occupancy, # of rooms, average price, fixed and variable costs.
Responsible for SAP IBP (Integrated Business Planning) interface to MPR and APR (Merchandise Planning for Retail and Assortment Planning for Retail).
Moved data from IBP’s original board directives into the retail planning applications both build on the SAP HANA platform using the CAR interface.
Used SAP BPC 10.1 on HANA to access data and report through BeX and Analysis for Office (Fox and SQL scripts)
Accomplishments
PoC was presented client kept the in-house Excel option since cloud computing was determined to be too high of an investment for the hotel chain. The integration from BPC into the MPR and APR was adapted by the in-house team together with the suggestion and examples of adapting the User Interface to be more user centric and friendly, parts were implemented into an in-house demo.
GLOBAL EFFICIENCY, Westminster, CO Oct. 2015- Feb. 2016
SAP CANADA, Vancouver, Canada Oct. 2015 – Feb. 2016
Independent Subject Matter advisor
Contribution:
Responsible for Steering the development of the Cloud for Analysis with concepts, comments on already existing user interfaces like reports to make them more consumable and friendly, coming up with ideas how to move long term plan, to budget into forecast.
Came up with innovations how to handle the help function, come up with ways to minimize complexity for the ETL part of the program (Extract data from homogeneous or heterogeneous sources,
Transformed the data in the proper format or structure for the purpose of querying and analysis and Load the data into the final target database.
Accomplishments
Most of the suggestions that were common sense were implemented in the reports and input schedules, like titles, possible sub-totals, and possibility to have sub-headers where used dimension members are mentioned on which reports are based. In addition the concept of importing data was completely revised and a template was used to streamline all the different data sources.
AL MUHAIDIB, Dammam, Saudi Arabia October 2015 – February 2016
Trouble shooter BPC Consolidation platform (independent consultant)
Contribution:
Solve intercompany eliminations, automation of journal entries from one period to another, see to it that balances are copied correctly from one period to the next period.
Enhance Cash Flow design to include two different categories.
Different reporting problems certain data does not foot, look into selection problem, locking of periods, data life cycle.
Accomplishments:
Problems were solved, since the architecture of the consolidation was a little off we also had to change some of the dimensionality, attributes and had to re-write some of the reports.
ITELLIGENCE, Cincinnati OH Jul. 2013- Sep. 2015
UNIFRAX LLC, Tonawanda, NY June 2014 – September 2015
Sr. SAP BPC Consultant
Contribution:
Responsible for data validation import and reconciliation from a myriad of systems. (mapping and transformation) files, loading data writing Data Packages, SAP ERP, BW.
Responsible for front end user interfaces report and Input schedules data management, Cash Flow reports and set-up.
Responsible for Dimensions, hierarchies, design, implementation, Learning materials, step by step instructions. Script-Logic for intercompany, consolidation, Cash Flow (Business rules), Allocation, move data between applications, Security, Client interface/project discussions and User Acceptance and Go Live.
Responsible for data reconciliation between disparate systems, different points in time for imported data and intercompany reconciliation with reports already published out of legacy systems.
Communication with off-shore consultants
Accomplishments:
Although the consolidation received data from more than 10 different systems (each needed its own data package) the time frame for the consolidation was decreased from 15 working days to 3 working days after month end close.(3rd working day after month end). In addition, the consolidated multi-currency cash flow became available in the same time frame as well as specific requested management reporting.
ELO TOUCH Solutions, Milpitas, CA October 2013 – June 2014
Sr. SAP BPC Consultant
Contribution:
Responsible for bandage solution using existing consolidation application for management reporting.
Additional applications to accomplish yearly budget process for Human Resources and Profit and Cost Centers that communicate with each other and use the same data feeds to take over the management and in house reports.
Responsible for E2E consolidation and Planning plus HR plan, Design and architecture, Script-logic and business rules, Dimensionality, Hierarchies, change time dimension from months to weeks, Security set up, Users, Roles, Application and hierarchy access, functional access.
Responsible for Data packages moving data and calculation of functional HR costs, from SAP ERP to BW to BPC. User Interfaces, Input Schedules, Reports, Packages and schedules, Step by step instructions and User Acceptance go live.
Accomplishments:
In first instance we had to come up with an bandage solution for the already running consolidation package. After that we were able to tackle the budget/forecast process with the inclusion of an Human Resources module that transferred aggregations to the general forecast model. We used the same data packages to write to the consolidation and forecast model in order to keep both applications in sync. In addition we wrote reports to reconcile the two systems to ensure this. In the HR module we calculated the loaded costs per employee per month, using the original hire date to increase salary, replacing the labor template excel sheet. The monthly forecast cycle was cut from 6 days into 2 days and the yearly budget cycle from a 3-month cycle into a 2-month cycle cutting the actual man hours into half.
Itelligence, Cincinnati, OH (Remote, in house project) July 2013 – October 2013
SAP BPC Consultant
Contribution:
BPC10 NetWeaver, in house basic Budget/Forecast interfacing with SAP’s New Financials.
Organized weekly status meetings with consultants on the bench.
The model was used for sales purposes and ready to install for smaller companies.
Accomplishments:
The model was used by the sales team as a ready to use budget system for midsize companies that already used SAP ERP
SAP AMERICAS, Newtown Square, PA Jan. 2006 – Jul. 2013
TELUS Inc. Edmonton, Canada May 2013 – July 2013
SAP BPC Consultant
Contribution:
BPC architecture for the consolidation model, dimensionality, attributes and hierarchy.
Responsible for Logic, business rules and investment percentages for the consolidation manager
Written ad-hoc reports and input schedules.
Tested of the settings and re-adjustments,
Loaded data and set up Business Rules.
NEWMONT Mining, Denver, CO March 2013 – April 2013
Sr. SAP BPC consultant (Subject Matter Expert)
Contribution:
Project was to complete BPC 10 NetWeaver loading historical data and advice the company on the functionality and set-up of the planning application and consolidation model.
Responsible for writing reports, explain and document steps on the use of conversion and transformation, the use of BPC in general for planning.
Accomplishments:
Gave pointers to speed up running of reports and the saving of data from Input schedules. Implemented best practice for data loads.
ALUMINIERE ALOUETTE, Sept-Iles, Canada Sep. 2012 – Mar. 2013
Lead SAP BPC consultant
Contribution:
BPC10 NetWeaver, Budget and Forecast applications for production and Human resources resulting into a general Planning application/model.
Responsible for Scoping, Blue printing, Project management and client interface, Data import using ERP data moved into SAP BW staging into SAP BPC, Input schedules, reports, Logic and HR value calculations, Interface between HR, Production and general app.
Customer/User Acceptance on the end to end implementation and KPI calculations and reports.
Responsible for communication with off-shore consultants, writing BadI’s and reports. Giving them the lay-out and check the end result to be compliant with clients wishes.
Accomplishments:
Wrote Blue print and implemented the same for the production application, the general planning application and the payroll/HR application. Used different techniques, BADI’s (written by offshore programmers) to calculate production fixed and variable costs, Script Logic to calculate allocations in the general budget, and partly Excel Logic on the payroll/HR application to calculate loaded personnel expenses. New planning was embraced by the company and made it possible to also put in drivers to do what if calculations.
CONOCO PHILLIPS, Aberdeen, Scotland March 2012 – September 2012
Sr. SAP BPC Consultant/SME (Subject Matter Expert)
Contribution:
BPC NetWeaver 7.5. Going live support for the end to end implementation of a Forecasting Budgeting system with an integrated Manpower/Contractor forecasting for the upstream side of the business, monitoring and fine tuning the 5-tier allocation process.
Responsible for live support, after shadow run for 2 months by client, Mass-import of data from systems spreadsheets and other sources, User Interface input templates and reports, Design for manpower and interface to budgeting application. User acceptance and going live and After care.
Replaced script logic for the 5-tier allocation with flexible input schedules which brought down the running time from 8 hour to a total of half an hour.
Found million-dollar budgeting mistakes from the past due to the controls in place and the centralized way of reporting, instead of Excel linked spreadsheets.
Accomplishments:
During the customer acceptance, we had to re-write the allocation process and moved it from script logic which took 8 hours to run into Excel Report/Input schedules decreasing the runtime to 1 hour and giving back the control to the power user. Solved several problems with the application that calculated manpower expenses. Manpower was partly in house and from third party sources. Some of the manpower had to be charged directly to a certain platform and other personnel expenses were general. We also found inconsistencies in certain Excel spreadsheets used and wrongly linked in the tune of approx. 3 million British pounds. In addition, the month end closing and invoicing to the shareholder partners of the platforms decreased from 20 days to 5 days, whereby the explanation of differences was integrated in the reports.
Kellogg’s Battle Creek, MI November 2011 – February 2012
Sr. SAP BPC Consultant / SME (Subject Matter Expert)
Contribution:
BPC 7.0 NetWeaver Health Check and reports assessments.
Determined root causes of reporting problems, recommended and advice on best practices and initiated example templates to work from.
Input and Report templates to be used.
Best practice instructions on the use of EvDRE and the rest of add-ins
Accomplishments:
Investigated dimensionality, several reports, Script Logic and proposed changes to have reports done according to a certain best practice template. Put script logic in Nassi Shneiderman diagrams to make them understandable and find un-structured programming.
Conoco Phillips, Aberdeen, Scotland Aug 2011 – November 2011
Sr. SAP BPC Consultant
Contribution:
Responsible for BPC 7.5 NetWeaver, Design and architecture, implementation of forecasting/budgeting system to manage oil platforms including Human resources for employees and contractors.
Responsible for Blue Print and design review, Dimensionality, Hierarchies, Attributes, Script Logic and Business rules applied and testing.
Accomplishments:
Finished the first part of the budget forecast-reporting phase, whereby the dimensionality, attributes, script logic, Input schedule and report lay-out was established and given to the company to do testing and find shortcomings that had to be solved in the second phase user acceptance.
Arizona Chemicals, Almere, Netherlands August 2011 – August 2011
Sr. SAP BPC Consultant / SME (Subject Matter Expert)
Contribution:
BPC 7.5 NetWeaver Functional Health Check
Determined root causes of problems
Recommended on ways to approach future projects and best practices.
Accomplishments:
Finished the advisory task for future approaches in a report that was implemented by client
SOLAE St. Louis, MO May 2011 – Jul. 2011
Sr. SAP BPC Consultant
Contribution:
The project was for BPC 7.5 NetWeaver, Demand Planning application resulting in production Budget and forecast. Including manpower.
Responsible for Scoping, Blueprint, Architecture, User Interfaces reports input schedules, data packages/links, Script logic, Dimension, hierarchies administrative, Security, Foreign exchange.
Responsible for testing, User Acceptance and going live after shadow run.
Was lead and managed 3 other consultants.
Accomplishments:
Initial project was split into two first one was the original budget/forecasting project but since the driver of the business was the sales the second project was to determine to be done first using the marketing influences and historic sales to calculate the estimated production, that drove the different production cost centers, manpower etc. In addition some of the reports the client wanted to use BEx to tap directly into the BW databases and cubes.
SAP customer Eastman Chemical, Kingsport TN April 2011 – May 2011
Architect and Main Designer
Contribution:
BPC 7.5 Microsoft platform. Scoping and Blueprint review
Responsible for Scoping, Blue print,
Identified the different stages of the Forecasting/Budgeting cycle and advice on architectural design of the cubes dimensions etc.
Accomplishments:
Delivered the blue print as a joint effort and established the dimensionality of the cubes.
Chevron Oil, Houston, TX October 2010 – March 2011
Sr. SAP BPC Consultant / Architect and Main Designer
Contribution:
Responsible for BPC 7.5 Microsoft platform, strategic planning for Supply Chain Management.
Responsible for Blue print, Realization, go live support and Full life cycle implementation.
Found a way to make the reporting flexible so client could pick and choose base members and or Hierarchy members through drop down for Ad-Hoc reporting.
Responsible for Testing and User Acceptance.
Accomplishments:
This project was completely done by myself, delivered the Blue Print, dimensionality, script logic, calculations, Input schedules and reports. Delivered ad hoc possibilities in a system that is not geared to it using macro content in MS Excel whereby the EvDRE add-in was used to extract free user choices on the dimensions used on the X-and Y-Axis in the reports, further comparing different categories. In free choice time slices.
J. CREW, New York, NY September 2010 – October 2010
Sr. SAP BPC Consultant / Architect and Main Designer
Contribution:
BPC 7.5 Microsoft platform, Planning and Consolidation Proof of Concept.
Responsible for PoC (Proof of Concept) on Planning Budget and forecast.
Needed drill down and drill through in reports. Reports needed to be user flexibility (click and drop capabilities).
PoC needed to work on clients own accounting data feeds.
Corrected data from the client that had the transactions they wanted to report on.
PoC should be transportable to the NetWeaver platform.
Accomplishments:
Client wanted a Proof of Concept (PoC) build on the actual data of the company whereby the possibility of free and ad-hoc choices of certain dimension members and or hierarchies had to be flexible. We competed with another supplier of budget/forecast software and won the bid.
ARMOUR ECKRIDGE, Cincinnati OH (Remote) September 2010 – September 2010
SAP BPC consultant
Contribution:
Project was for BPC 7.0 Functional Health Check.
Determined the root cause of the reporting problems, made recommendations and advised on best practices, new hierarchies and optimized master data.
Accomplishment:
Decreased running time of reports from 5 minutes to 30 to 45 seconds.
CUSHMAN WAKEFIELD, New York, NY January 2010 – September 2010
Team member / lead developer
Contribution:
Responsible for technical support and report writing.
BPC 7.0 NetWeaver. Started off and cranked out 36 reports, changed hierarchies to accommodate reports and helped out with some of the Input schedules.
Taken up the responsibility of team lead during the project and changed the architecture of the cubes.
Designed processes and helped the company to steer the requested changes. Was instrumental helping the company to achieve its goals to implement new processes and reporting tools.
Accomplishment:
As the sub-contractor of Coopers & Lybrand, I delivered the dimensionality, reports and input schedules within the allotted time.
CEMEX, Monterrey, Mexico October 2009 – December 2009
Project lead and Main Designer
Contribution:
Project was for PoC (Proof of Concept) for production forecasting.
Lead the discovery team during the first week on the Blue print process and aligned the expectation of client, sales and design team.
Accomplishments:
Together with the SAP Mexico team and another Mexican integrator we delivered the PoC to Cemex which they adopted worldwide. Was successful to align expectations of all parties involved, which resulted in the addition of BPC in the total package SAP could propose to the client
NB Power, New Brunswick, Canada (Partly Remote) September 2009 – November 2009
Consultant
Contribution:
Responsible for Rapid Blue printing for forecasting, to be built on existing budget application. Health check review on budget application.
Diving deeper into the budget application couldn’t find any documentation and the NB Power did not receive anything.
Re-use whatever could and build in the forecasting app.
Accomplishments:
Proposed two options to NB Power. The first one was to redo the whole installation since there was no documentation available from the integrator they used. The second one was to use the install as it was and to build the forecasting on top while trying to explain the extensive coding that was done and document and revise what was necessary. Client went for 2nd option.
KRAFT FOODS, Chicago, IL July 2009 – September 2009
SAP BPC Consultant Developer
Contribution:
Project was for Proof of Concept for a Cost Center HR Budget system
Created a payroll model that allowed the client to use drivers to be used company or country-wide with possibilities of cost center overwrites to budget a large employee base for salary & related benefits.
Designed input schedules and reports for a wide range of users in BPC 7.0 for NetWeaver. Proof of concept mimicked an existing system to be retired. Kraft wanted to immediately use the PoC in production.
Accomplishments:
In the PoC we used extensive attributes to trigger certain manpower calculation. These calculations could be influenced by hierarchies, geographies, functions and two or three other dimensionalities. As stated above we only build the PoC for a certain number of triggers so the PoC could not be implemented on a corporate scale. SAP won the bid and implemented accordingly
TECH DATA, Fort Lauderdale, FL June 2009 – June 2009
Developer/Trouble shooter
Contribution:
Responsible for optimization of Input schedules and reports
Decreased the response time of several reports and input schedules on the BPC 5.1 platform
10 reports were investigated of which 4 decreased with 50% response time, 3 with 40% and 2 with 30%.
Accomplishments:
Client was satisfied after the faster run time of reports.
BROWN Shoes, St. Louis, MO. March 2009 – June 2009
Designer and Developer
Contribution:
Implementation of BPC as part of a total FI, HR and ASF install of SAP products
Was instrumental in the Blue print process and had an advisory and hands on task building the input schedules and reports as well as the security.
Advised on the dimensions and was instrumental in building the BPC cube.
Solved problems in the User Acceptance phase and the first week after going life.
Accomplishments:
Client is still using a very heavy detailed forecasting system, exactly as they wanted it. Although we advised against it since the data retrieval and writing is top heavy. Brown Shoe is happy with the delivery since all data is centrally stored, one of the main concerns they have and is within reasonable response time.
Cincinnati Children’s Hospital (CCH), Cincinnati, OH April 2009 – May 2009
Developer/BPC Specialist
Contribution:
Responsible for Budget Design, Reimbursement, Capital, Weekly Forecast.
BPC 5.1 Microsoft. Installation, data modeling and security.
Oversaw reporting and input schedules requirements using innovative ways of multidimensional cubes.
Worked in a team of 3 SAP consultants and 5 Budget office employees to have the 4-month assignment done within the budget and time frame.
Found an innovative way to check total 40Hrs budget total personnel
Accomplishments:
The integration of the forecast for the nurses/doctors working in different departments of the hospital with different patient classifications was solved by the use of different applications whereby the forecast of the total number of weekly hours for the nurses had to be monitored. In the end, CCH was very pleased with the different applications using different security settings for departments and personnel, that moved data seamless from one application into the other. It reduced the closing time with 5 working days on a monthly basis and the yearly budget cycle was more structured and manageable.
USDA (United States Department of Agriculture), Alexandria, VA
Developer
Contribution:
Project was for Proof of Concept for an HR budgeting and forecasting.
Responsible for BPC 5.1 Microsoft. Salary and Benefit Projection Model for FSA (Farm Service Agency) and a reporting system for actuals plus commitments against budget for FSIS (Food Safety Inspection Services) with functional and technical documentation.
Accomplishments:
Learned a lot and solved the data loading conversion and transformation from different systems.
T-MOBILE, Seattle WA Jan. 2008 – Jun. 2008
Developer
Contribution:
Budget-Forecast management reporting application
Responsible for BPC 7.0 Microsoft. Input Schedules, Reports, Data, EvDRE, Excel add in etc.
Accomplishments:
Learned to listen to the clients requirements, had a really good coach and after the learning curve became a master in reporting and Input schedules. Implemented a company-wide template that could be used for all user interfaces.
SAP Customer National Semi Conductor, San Jose, CA Nov. 2007 – Dec. 2007
SAP BPC Consultant
Contribution:
Helped with configuration and functional front end BPC 7.0 NetWeaver.
Responsible for Training power users on Input Schedules and Reports.
GLOBAL EFFICIENCY, Westminster, CO Oct. 2015 – Feb. 2016
T-Mobile regional office/bridge, Denver October 2003 – Dec. 2006
Independent Consultant
Started off as a financial analyst with the specific request to look into the building and upgrading of cellular towers since a lot of the allotted budget of the Western regions was not used. Through the use of downloading of data from corporate before month end we could determine budget not used and tried to allot the funds to the mountain region by starting tower upgrades and building, since the assignment of the funds was done as soon as the region could prove that the work on the tower had been started. I used for this a repository of SQL Server, and MS Excel as a front end. Later we investigated to make sure that the work was equally distributed under the contractors used, since we received a request like that from the corporate office.
QWEST COMMUNICATIONS, Denver, CO Jul. 1999 – Sep. 2003
Started off as a financial analyst working for the IT department, responsible for monthly reporting, variance investigations.
Automated most of reports with variance) thresholds so most of the reports were semi-automated.(had to load delta data manually on a daily basis) Since the investigation of the detail took a lot of time I started to download the detail in a database repository, replacing aggregated entries with detail entries.
Semi-automated the data gathering into a SQL Server for 10 different cost centers and wrote standard Excel reports whereby the 10 financial analysts could choose the cost center, variance thresholds, time frames etc.
Received a couple of recognitions doing this and in the end helped to write a program that replaced all the automation I worked on, resulting in my lay-off during a reorganization.
Contact this candidate