Albaugh. Your Alternative
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.
Perfection Pet Foods
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
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.
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.
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 inﬂuence in the results (with a tornado graphs), and also runs
Montecarlo, in order to quantify the risk.
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.
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.
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, deﬁning
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
Location: Boston, US – Industry: Pharmaceutical
Project: Global Finance Dashboard and Planning Solution
Analysis and redefinition of the Management Solution based on SAP BI Platform.
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.
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
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.
Location: Argentina – Industry: CPG
Project: Project: SAP BI implementation, for a Management reporting & ﬁnance 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
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.
Location: LATAM – Industry: Beverages
Project: Regional Balance Scorecard for Finance developed with Arcplan
Deﬁnition, design, development and roll-out of the solution for the Coca-Cola’s
Latin American Division headquarter in Argentina.
Location: France & UK – Industry: Pharmaceutical
Project: Global Finance Cockpit for Sales, Marketing & P&L KPI´s based on SAP BW
– SAP SEM – CPM
Deﬁnition and Implementation of the Corporate Performance Management
Cockpit Solution, for the ﬁnance and controlling division, for Sanoﬁ-Aventis UK,
as part of a Global SAP Solution implemented in France for more than 25
Location: Italy & Spain – Industry: Pharmaceutical
Project: SAP BW and Arcplan implementation, as a Management Information
System solution for Sales and Finance, including management dashboards.
Deﬁnition, coordination and implementation of the MIS solution for Aventis
Pharma (today Sanoﬁ) in Italy based on SAP BI Platform.