SUMMARY

• SAP BI Principal Consultant and Project Manager, with over 18 years of experience implementing integrated planning solutions for Finance planning & Consolidation, Sales & Operation Planning, Production Planning and Detail Scheduling.
• I have implemented over 25 full cycle SAP BI global planning and analytic projects for multinational clients like Confidential, Cadbury, Kraft Foods, Sanofi, Aventis between others, at regional

PROFESSIONAL EXPERIENCE

SAP BI Principal Consultant/Solution Architect/Project Manager

Responsibilities:

• I’m responsible for all activities related to SAP BI projects, covering full cycle Reporting, Planning and Simulation solution implementations, from project estimations, project management, BBP, solution design, team lead and including hands - on participation in the projects, both as functional and technical senior consultant.During this period I have Managed & Participated hand-on in the following projects:

Confidential, Ankany IA

Principal Consultant/Advisor

Responsibilities:

• Analysis and validation of the finance consolidation and planning model been implemented with SAP BPC 10.1 Neweiver version. Review desing, BBP and implementation, propose enhancements and best practices and checking key functionality.
• A finance planning solution based on Olation and Powerolap planning platform, including OLAP data structure, planning functions and formulas, planning layouts and reports. The sol, ution includes moth closing processes, distribution and allocation processes required for actual data.

Confidential, Doylestown PA

Principal Consultant

Responsibilities:

• Analysis, design and development of a finance planning solution based on Olation and Powerolap planning platform, including OLAP data structure, planning functions and formulas, planning layouts and reports. The solution includes moth closing processes, distribution and allocation processes required for actual data.

Confidential

Solution Architect/Developer

Responsibilities:

• Analysis, design and development of a simulation model to simulate and analyze the production capacity and constrains for long term production plans, as part of the Sales & Operations Plan process.
• The model is integrated with SAP R3, as a data source for the Material master data and production roadmap, inventory and other variables requested for the analysis, and rights back the production plan to S&OP and SAP PP.
• The simulation model is also integrated with reporting and analytic tools like Tableau, BO and Qlick View, and includes planning capabilities from Excel write back to a central repository in SQL Server or HANA.
• The simulation model allows the analysis of different production scenarios and safety stock policies identifying stock-out situations, and capacity analysis, Overall Production Efficiency analysis, MAPE Forecast error analysis, between other options.

Confidential

Solution Architect/Developer

Responsibilities:

• Definition and development of a second phase of the simulation model to optimize the river barge transportation logistics, representing the routes and over 17 loading and unloading ports along the mayor waterways from Brazil and Paraguay to Argentina.
• The model developed with Discrete Event and Agent Based methodology to dynamically represent routes, ports, barges, push boats, convoy, navigation delays, gas consumption, river tide conditions, port load and unload delays, costs and tons transported, etc.

Confidential

Solution Architect/Principal SAP BW/IP Consultant

Responsibilities:

• Define and implement a Commission calculation solution, integrated with the POS DM and POS DM Analytics model, as part of an international SAP Team, with specialist coming from SAP AG Germany, USA Canada and Mexico, for the SAP POS DM implementation.
• As one of the largest retail and departmental stores in Mexico, with more than 130 Stores and 3.500 Sales employees, Liverpool required a Commission calculation solution integrated with the SAP POS DM implementation project, covering multiple commission calculation scenarios and reports.
• The solution is based on SAP BW 7.3 and Integrated Planning, running and integrated on the SAP POS DM and POS DM Analytics instance. The model includes Master Data integration with SAP ECC and POS DM, and multiple interfaces with Legacy Systems, SAP R3 (HR and FI) and an existing SAP BW system.
• The model includes multiple transactional and basic cubes, for the daily sales arriving from PIPE and the daily commissions calculations functions, based on multilevel commissions input layouts, maintained by the business user, and daily and on-demand calculation processes developed with IP/FOX and ABAP. System will run on BWA, and Liverpool is analyzing the option to implement HANA.

Confidential

Solution Architect

Responsibilities:

• Analysis of the actual production process of the Ice Cream division at Confidential, and the review of the different systems that support the S&OP process and the Production and Purchasing planning and detailed production scheduling, including their actual SAP PP configuration and other systems, in order to identify the effort and benefits of implementing APO (DP, SNP and PPDS) and the ROI estimation of the project.

Confidential

Solution Architect and Developer

Responsibilities:

• Definition and development of a simulation model to optimize the river barge transportation logistics, including the amount of barges, push boats, convoy size, ports of departure and arrival, navigation delays, gas consumption, river tide conditions, port load and unload delays, costs and tons transported, etc. during a simulation period of 5 years, having multiple user variables available to be changed before or during the simulation, in order to evaluate different scenarios.
• And additional Optimization model allows to iterate the 5 year simulation more than 1000 times, in order to find the optimum combination of variables.

Confidential, Locally in Boston, MA

Solution Architect/Senior Consultant

Responsibilities:

• Definition of the new BW Data Structure and ETL processes for the implementation of a new Global Finance Dashboard solution.
• GAP analysis, definition and documentation of the data structure and ETL processes required by NIBR in their new SAP BW environment shared with Confidential Pharma, based on the existing implementation, the new business requirements, the new SAP BO platform and the guidelines of Confidential Pharma project specifications.

Confidential

Project Manager/Solution Architect/Senior Consultant

Responsibilities:

• Regional BI Solution for Management reporting, Demand Planning and Finance Planning based on SAP BW/IP
• Management & hands-on participation, for the Business Blueprint, technical design and implementation of a regional reporting & planning system covering Sales, Finance, Controlling, Logistic and Operations with a total of 155 reports and 12 planning processes, including Demand Planning, P&L, Balance Sheet, Cash-flow, Indirect Cost planning and Cost Allocations.

Confidential

Project Manager/Solution Architect/Senior Consultant

Responsibilities:

• Regional BI Solution for Management reporting, Demand Planning and Finance planning implementation project based on SAP BW/IP
• Management and hands-on participation, for the Business Blueprint, design and implementation of a regional reporting system covering Sales, Finance, Controlling, Logistic and Operation and planning processes including Demand Planning, P&L, Marketing and Indirect Cost planning.

Confidential

Project Manager/Solution Architect/Senior Consultant

Responsibilities:

• Global Finance Dashboard, for research Projects and Expenses, designed to consolidate all research countries including USA, Switzerland, China, etc.
• Management and hands-on participation, and coordination of remote BW resources from Infosys (India), for the implementation of the Global Web Management Solution, built on SAP BI platform including BW, Web Templates, Queries and Reports, together with Integrated Planning functionality.

Confidential

Project Manager/Solution Architect/Senior Consultant

Responsibilities:

• Global Finance planning solution, for monthly P&L planning, submission and consolidation for all Confidential CPO’s (Approximately 150 Countries and regions), based on SAP BW/IP.
• Management and hands-on participation, for the implementation of the Global Web Planning Solution, built on SAP BI platform including BW, IP, Web Templates, Queries and Reports, for the Outlook P&L planning & submission for all Confidential Affiliates.

Confidential

Project Manager/Solution Architect/Senior Consultant

Responsibilities:

• Management reporting solution for sales and finance areas, including P&L reporting and sales planning, indirect cost planning and P&L planning. Cost center and profit center Allocation, distributions and retractions to R3 functionality was also part of the project.
• Management and hands-on participation, and coordination of remote BW resources from Infosys, for the implementation of a Management Solution, built on SAP BI platform including BW, Web Templates, Queries and Reports, together with BPS Planning functionality.

Confidential

Project Manager/Solution Architect/Senior Consultant

Responsibilities:

• Design and implementation of a business planning solution, for short-term and Long-term planning, including Sales Volume, Price, Costs, Mark-up, Discounts, Other direct costs, distribution and storage costs, indirect costs, P&L, Balance & Cash-flow planning, based on SAP BPS, together with a system dynamics simulation model
• Based on Powersim, for strategic and tactic simulations, including macro-economic scenarios with Inflation, Exchange Rate, GDP variables, between others, in order to evaluate the impact in this scenarios, and the variation analysis of the market demand, volumes, prices, costs and the P&L lines, for different country and business units. This model is integrated with the BPS model.