Company:
Albaugh. Your Alternative

2015-2019
Location: Iowa, US Crop Protection – Industry: Crop Protection
Project: Global Planning & Consolidation Solution

Design and Implementation of a Global Planning & Consolidation Solution for
Albaugh LLC, and afiliate companies in USA, Europe, Mexico, Brazil and Argentina,
based on SAP BPC, SAP BW/IP, SAP EPM, SAP BEX & SAP Lumira, developing the
following business models: Sales/Demand Planning, Dynamic Forecasting, S&OP,
MRP Production & Purchase Planning, RCCP, Income Statement Planning, Balance
Sheet Planing, Inventory Management, Financial USGAAP Consolidation, and
Venture Analysis & Simulation. We are currently running a pilot program with SAP
and AWS, testing the solution on BPC on HANA on AWS Cloud Services.



Company:
Perfection Pet Foods

2018-2019
Location: California, US – Industry: Pet foods industry
Project: Production Simulator model combined with Multi-objective Optimizer
The goal was to optimize the detail scheduling production steps and satisfy the weekly
demand.

In order to accomplish the goal, we designed a multi steps model, with different
strategy planning options, in order to find the best approach to maximize use. We
also included restrictions and constrains within these strategies. The model will
then run an optimizer to find the best trade off solution to satisfy demand in the
chosen scenario. The model output is a detail schedule plan for each extruder
and packline for the weekly production.



Company:
CMPC

2018
Location: Santiago de Chile – Industry: Sanitary goods
Project: Strategic Simulation Model to Optimize ROA in a 8 countries network
The goal was to optimize the production network, defining where and when to
produce each SKU according to the demand.

As a first step the model needed to simulate the production of hundreds of SKU in
each country with an unlimited capacity to calculate the production and lo-
gistic costs in different scenarios for a 8 countries demand. Once all production,
warehouse and logistic cost for different scenarios were calculated, we move
rhrew a matrix of increase benefits to find the optimized result.



Company:
Lupin

2015-2016
Location: Baltimore, US – Industry: Pharmaceutical
Project: Simulation Model for New Product Launch
The goal of this tool was to estimate the potential gain of market share, in diffe-
rent marketing scenarios.

Once calculated the potential gained pool of consumers of both population,
model estimated a projection, gross and net revenues expected within market
share. It also runs a sensitivity analysis, to detect which of the marketing variables
have a larger influence in the results (with a tornado graphs), and also runs
Montecarlo, in order to quantify the risk.



Company:
Conaprole

2014
Location: Uruguay – Industry: Diary & IceCreams
Project: Implement a Production Simulation Solution for IceCreams factory
Based on a simulation model template developed by our company, using Discre-
te Events, Agent Based and System Dynamics methodology, adjusted to the Ice
Cream production process and business rules at Conaprole. The production si-
mulator allows the analysis and optimization of different production scenarios,
taking in account the 12 month rolling demand plan, initial inventory, target inven-
tory, production rates, production routes, batch sizes, equipment capacity and
OEE, forecast errors (MAPE), etc. and provides an optimized production plan eli-
minating stock-outs, minimizing inventory & warehouse costs while maximizing
the shelf-life of the products. The model is been integrated with SAP master data
and PP, and is also integrated with the S&OP process, and provides detail analytic
options with the existing reporting tools used by Conaprole.



Company:
InterBarge

2014 – 2015
Location: Argentina, Paraguay & Uruguay – Industry: Fluvial
Project: Implement a Logistic Simulation Solution, for Barges and Push Boats

The goal of this tool , was to evaluate all the possible scenarios of the in land
waterway operation suggesting to push boats which contracts to choose. As
output is gives a propose routes plan for each push boat, where to allocate
barges, using as a parameter the highest net voyage revenue, how to build the
convoy. It considers all prt delays, all navigation times and possible delays, as
well as levels of water and weather conditions, to plan the commitment to con-
tracts for the whole year. It is used as well as an analysis tool, to be able to sug-
gest the best contracts freight price in each port and route.



Company:
Liverpool

2014
Location: Mexico City – Industry: Retail
Project: AP POS Data Management Implementation Responsable for the SAP
Integrated Planning Area

Responsable for the SAP Integrated Planning Area within the project, defining
and implementing a Sales Commission Calculation & Reporting Solution, to be
integrated with SAP’s retail industry solution, POS Data Management and POS
Data Management Analytics BW model at Liverpool, DF, Mexico City.



Company: Novartis Institutes

for Biomedical Research

2010
Location: Boston, US – Industry: Pharmaceutical
Project: Global Finance Dashboard and Planning Solution
Analysis and redefinition of the Management Solution based on SAP BI Platform.



Company:
Cadbury

2011-2012
Location: Mexico DF
Project: Regional SAP BI Management Reporting, Demand Planning and Finance
Planning Solution for Cadbury NOLA (North of Latin America, including Mexico
and countries of Central America and the Caribbean)

SAP BI project implementation and coordinate the integration with SAP ECC pa-
rallel implementation, design the solution based on SAP BW and Integrated Plan-
ning and participate hands-on in the implementation.



Company:
Novartis

2008
Location: Basel, Switzerland – Industry: Pharmaceutical
Project: Global Finance Reporting and Submission System

Finance Reporting and Submission System, implemented for 155 Novartis Coun-
try Units, for the monthly P&L Reporting and Submission process, developed for
the Finance Headquarters in Basel, Switzerland
Management and hands-on participation, for the implementation of the Global
Web Reporting & Planning Solution, built on SAP BW, IP, Web Templates, Queries
and Reports, for the Outlook P&L planning & submission process for all Novartis
Affiliates.



Company:
Arcelor Mittal

2006
Location: Brazil & Argentina – Industry: Metal
Project: Project: SAP BW/SEM/BPS implementation, as an integrated planning solution for
Sales, Purchase, Production, Transportation, Variable and Fixed Costs, HR, Indus-
trial Costing, Balance, Cash-Flow, P&L, Macro Economic indices based on SAP BW
– WAD – BEX – SAP SEM – BPS.



Company:
Cadbury

2009-2010
Location: Argentina – Industry: CPG
Project: Project: SAP BI implementation, for a Management reporting & finance Planning
and simulation solution, for the South-Cone region (Argentina, Uruguay, Para-
guay & Chile), based on SAP BW – WAD – BEX – SAP SEM – BPS and Powersim
(Simulation Tool)



Company:
Repsol

2008
Location: Argentina & Spain – Industry: Oil & Gas
Project: Upstream ABC costing, monthly closing and annual planning processes,
that supported Repsol & YPF activities in Spain and Latin America, based on SAP
SAP BI Platform.



Company:
Coca Cola

2004
Location: LATAM – Industry: Beverages
Project: Regional Balance Scorecard for Finance developed with Arcplan
Definition, design, development and roll-out of the solution for the Coca-Cola’s
Latin American Division headquarter in Argentina.



Company:
Sanofi

2004-2005
Location: France & UK – Industry: Pharmaceutical
Project: Global Finance Cockpit for Sales, Marketing & P&L KPI´s based on SAP BW
– SAP SEM – CPM

Definition and Implementation of the Corporate Performance Management
Cockpit Solution, for the finance and controlling division, for Sanofi-Aventis UK,
as part of a Global SAP Solution implemented in France for more than 25
European Countries.



Company:
Sanofi

2003
Location: Italy & Spain – Industry: Pharmaceutical
Project: SAP BW and Arcplan implementation, as a Management Information
System solution for Sales and Finance, including management dashboards.
Definition, coordination and implementation of the MIS solution for Aventis
Pharma (today Sanofi) in Italy based on SAP BI Platform.