Jesus Fabian Lopez; Ph.D, Certified Analytics Professional (CAP). US Citizen

acq08t@r.postjobfree.com Mobile: 210-***-**** (SAT). 011-521-818-***-**** (Mexico) http://mx.linkedin.com/pub/jesus-fabian-lopez-ph-d/6a/275/798/

Subject Matter Expert for Business Analytics & Optimization at SINTEC (from 2012)

Director of Supply Chain Planning. Embotelladoras ARCA Coca-Cola (1999 to 2012)

Research & Consulting Professor at UANL from 2002 & Texas State Univ. from 2013 Profiling:

(1) My strengths:

a. 27 years of experience in Supply Chain Optimization & Business Analytics for 8 different industries. Implement complex math optimization / predictive analytical models from business requirements to address inefficiencies b. Integrate Advanced Analytics techniques on DMAIC-Six-Sigma projects for process optimization on manufacturing and supply chain projects. Conducts multi-disciplinary projects to improve profitability & utilization of resources.

c. More than 15 years acting as a consulting & IT liaison with multiple business functional areas.

(2) Experience on Predictive Business Analytics & Optimization: a. Location – Allocation Analytics: network & territory design, store location & set covering. b. Supply Chain Analytics: multi-echelon inventory optimization, production & transportation Scheduling c. Resource Analytics: cutting, picking, routing, timetabling, multi-period crew scheduling. d. Real Time Analytics: Manufacturing (PLC), Transportation (GPS) and predictive maintenance. e. Retail Analytics: Basket-Recommendation, Cross Selling, Category & Planograms Optimization. f. Pricing & Revenue Optimization (RGM)

(3) Experience on Business Process Consulting & IT Project Management: guidance on technology issues but also on process & system's needs. More than 20 projects executed on last 4 years. a. SAP based project implementations on Warehousing-WMS, Manufacturing, Supply Chain Planning APO, Transportation-TMS, Sales & Distribution-SD, etc.

b. Supporting DMAIC & six sigma projects focused on cost savings: manufacturing-OEE, packaging, warehousing, order picking, transportation, distribution and route to market. c. Operating & supporting complex operations > $1 billion USD. Management of Supply Chain & IT budgets >

$25M USD yearly (manufacturing, warehousing, supply chain & transportation)

(4) Experience by Industry:

a. Beverage & Consumer Products: Coca Cola Company (Femsa-KOF, ARCA, Andina-Chile); Pepsico b. Retail: Chedraui, Femsa OXXO, Price-Shoes, Farmacias Benavides. c. Manufacturing: FAMOSA-Crown; British American Tobacco. d. Steel Metal Mechanic: Altos Hornos de México (AHMSA), Caterpillar. e. Oil-Gas & Utilities: Petroleos Mexicanos (PEMEX); Alestra AT&T. f. Transportation & Logistics: Transportes Senda

g. Food Industry: Bachoco (poultry), Uniban (Banana’s in Colombia) h. Bank: Banco Compartamos, Banco Colombia

(5) Skills on problem solving (Operations Research Modeling and Predictive Analytics techniques): a. Predictive Analytics: Multivariate Analysis, Cluster Analysis, Factor Analysis, Decision Trees, Random Forests, Robust Regression, Structural Equation Modeling, Neural Networks. b. Simulation & Optimization: Linear Mixed Integer Programming, Genetic Algorithms, Scheduling, Routing, Timetabling, Workload-Balancing, Game Theory.

(6) Computer & technical skills:

a. Predictive Analytics: SAS, Revolution-R, SAP-Predictive Analytics, Rapid-Analytics, SPSS-Scripting. b. Optimization: IBM-CPLEX, FICO-XPRESS, GUROBI, AMPL-GAMS, Llamasoft Supply Chain Guru, Logic-Net. c. Advanced Simulation Programming: FlexSim, Promodel, Math-Lab d. General Analytics: SQL, VBA, VB.NET, C++, Pyton, Mapinfo, MS-Access, PLC Programming.

(7) Scientific Publications: 2 Operations Research Books, 10 Indexed Journal Papers. (USA & Germany)

(8) Education History:

a. SNI Fellow Level 1 (2005-2015). Highest country-wide distinction granted by Mexican National Council for Science and Technology. (www.conacyt.gob.mx)

b. Post-Doct at Texas State University. Doctorate Degree (Ph.D.) in Management Science at Univ. Nuevo Leon. c. Two Master Degrees: (1) Business Administration. (2) Industrial Engineering at Monterrey Tech d. Three Engineering BA’s: (1) Computer Science, (2) Mechatronics, (3) Telecommunications

(9) Professional Certifications:

a. Certified Analytics Professional (CAPs – INFORMS) March, 2015 b. Predictive Analytics Certification from SAP, Mexico City Sep, 2013 c. Rapid Miner Analyst Certification, Dortmund Germany May, 2013 d. Certified in Production & Inventory Management (CPIM). American Prod. & Inv.C. Society (APICS) e. Full SAP-APO Academy (DP, SNP, PP/DS, TPVS, GTP) 2005 Professional Experience:

ITEM (1 of 8). May 2012 to date

Company: SINTEC (Consulting on Customer & Operations Strategy) www.sintec.com Position: Director / SME for Business Analytics & Optimization (BAO). Last 2 years Achievements: Fuller (2015). Catalog sales product. Decision Tree implemented as a Classification Meta-Model for Demand Prediction. Decision Tree uses alternative forecasts from several multiple regression and support vector machine models. Chedraui Stores (2014). Third largest Super-Market Branch in Mexico. Open to Buy optimization. Predictive models to forecast demand on stores. Optimal assignment, purchase & distribution of products to stores subject to a constrained budget. Market Basket Analytics Model for customized real time promotions to customers. Bachoco (2014). Largest Fresh Eggs & Chicken Supplier in México. Solution Architect for advanced predictive Model for fresh eggs & chicken forecast supply. 6500 stations around 120 farms. Jugos del Valle (2014). Largest juicy-drinks manufacturer in México. Advanced Price & Revenue Optimization model applied for modern channel. Real time inputting data from Sell-out demand (600 stores & 150 SKU’s). FAMOSA-Crown (2014). Largest glass-bottle manufacturer in Mexico. implementation of optimal production scheduling; service-level vs cost of service (250 machines, 200 skus, 50 routing sheets, etc) Coca Coca Andina KA (2013). Largest soft-drinks manufacturer in Chile. Solution Architect for optimal mix sku-pallet configuration for multi-picking orders on distribution centers. Banco Compartamos (2013). Largest Micro-Credit Financial Bank in Mexico. Led implementation for Location-Allocation modeling. Stochastic modeling for prediction of new customer’s. Optimal location of branch offices. Optimal Allocation of customers to branches for territory design and networking optimization. Pepsico (Mexico, 2013). Largest Snacks & Cookies manufacturer in the world. Solution Architect for a Network Design solution. Transportation, Cross-Docking and Inventory Optimization across Plants & DC’s. Coca Coca Femsa KOF (Venezuela, 2012). Largest soft-drinks manufacturer in the world. Senior Consultant for optimal Timetabling on Transportation Network Scheduling due to new government policies on labor hours Altos Hornos de México AHMSA (2012). Largest steel manufacturer in Mexico. Model solution to obtain optimal production scheduling & minimizing inventory levels (250 machines, 60000 skus, 100 routing sheets, etc)

(2012-2013). Sports Analytics. TIGRES Sinergia Deportiva (Largest Soccer Football club in Mexico) www.tigres.com.mx

(2008-2010). Petróleos Mexicanos PEMEX. Mexican State Oil Company. Production & Exploration Division. www.pemex.com ITEM (2 of 8). Dec-1999 to May-2012

Company Embotelladoras ARCA-Continental (3rd Coca-Cola Bottler World-Wide) (Beverages) Position Director of Supply Chain Planning & Business Analytics www.arcacontal.com Achievements +25 M.USD annual cost savings in Manufacturing, Packaging, Warehousing & Transportation 1. Network Infrastructure Optimization (6 mergers): cost reduction (+12 M.USD / year) a. 42 Plants, 214 Distribution Centers, Total Fleet 14000 Vehicles. 2. DMAIC & 6-Sigma Projects. Manufacturing and Transportation Cost reduction (+3.5 M.USD/ year) 3. Plants & DC’s Costs Optimization: Inventories (-12%), Energy reduction (+$6 M.USD/ year) 4. Route to Market & Vehicles Optimization to end-customers (8% cost reduction)