Juan Pablo Herrera Email and Phone Number

- Reponsible of design and negotiaion of distribution agreements within Central America, Caribbean and Andean region to optimize distribution for our business unit.- Control and supervise that the commercial relation with the partners is under the limits of the designed agreements.

Full time options and stocks trader. Passionate about the markets and sharing knowledge to lead people to financial freedom.

In charge of managing employee cost and supervise rest of OPEX for 4 brands, supporting the transition to the new cluster in France.

Responsible of managing the budget for Global Support OPEX for Aramis and Designer Fragrances, and Lab Series Brands.Annual budget planning, monthly forecast, month closing and actuals and forecast reconciliations.

Responsible of all financial operation of the Panama branch of Zara and all 7 brands and 10 companies that hold INDITEX operation in the country.Year budget, monthly forecast and actuals reviews, OPEX and CAPEX, people and project management.

Responsible of region reporting, controlling of SEM company of our holding group, and support on regional controlling for Trade Alliance Corporation, owner of INDITEX franchises accross 5 LA contries (Colombia, Ecuador, Panama, Peru and Paraguay).• Re-design of regional reporting tool, getting automation of data checks and reconciliations vs. Budget for management reporting.• Financial analysis for regional initiatives, with the objective of getting maximum efficiency in the execution of projects such as the bicile program for stores, regional re-lamping an re-design of recruiting department for our stores.• Leader of Expenses Comitee from Innova project in which, with an external consultant team, we seek maximum efficiency for the organization regarding exoenses and headcount. This includes the decision of creating a Shared Service Center (SSC), and the factibility analysis to choose the best location to establish the SSC getting a cost-efficient structure without compromising the processes.• Elaboration of 2019 budget for the SEM company of our holding group.• Representation of our company in the AmCham commission of transnational companies, aimed to work with government officials on the reglamentation of laws affecting the transnational companies based in Panama.• Creation of organic sales report, which enabled the analysis of stores accross different countries, by isolating the variables that are controllable by our direction.• Creation and control of regional expenses policies (for example, travel) with the objective of reaching an efficient operation regarding expenses and administrative processes.

Responsible of price setting, costing and monitoring portfolio profitability in more than 25 geographies throughout the territory of Central America and the Caribbean for the categories of Pet Care Dry, Pet Care Wet, Pet snacks and Litter.• Designed and analyzed value chain on large bags for Guatemala and Panama (key SKUs on our portfolio) to decide the new strategy of prices and retail margins in our distribution chain to re-activate the sales on our distributors.• Created the GPPC classification, which is simplifying the pricing strategy design and execution throughout the region. This has reduced significantly the time to invest when reviewing price lists on each of our markets.• Design and execution of analysis of Pallets vs. Slip-sheets, to determine the size of the prize if we could get all of our distributors to move our product in slip-sheets instead of pallets. This in order to determine if we could offer an incentive to our distributors to move to this new modality, sharing the benefit.• Design and implemented the Commercial Alignment Model, in which we can analyze the value chain on each of our markets to optimize our price and margin strategies with each of our distributors and retailers. This has also enabled us to react with better visibility to the threat of parallel imports in the Caribbean markets.

In charge of consolidation, reporting and analysis of P&L forecast for Latin America North (LAN) Territory. Representing LAN on global projects and interaction with global teams.• Redesigned the process and tool for measurement of pricing as source of incremental sales on every seeds business unit. Also created a standard process to align monthly sales volume for Corn and Sorghum. These two achievements improved the measurement of the sources of sales variation, which enabled better visibility for these variables on time, accurately and without additional resources. With this improvement we were able to enhance our pricing strategy in Mexico vegetables by 10%.• Designed the Pricing and Gross Profit Simulation Tool (PGP Tool). Led and supervised the offshore supplier in charge of programming and executing the tool. This tool allowed to anticipate in 10% the time to get the first view of Forecast at Gross Profit level, which enabled the possibility of adjusting the sales and supply plans of the territory.• Led the planning and forecasting team in the calculation and correct execution of financial adjustments on our monthly sales plan process for seeds, with the goal of ensuring that the Sales and Gross Profit forecasts were aligned with the year targets. This reduced to zero the errors on the forecast transmission and reduced by 25% the time of the transmission on the last 6 months.• Successfully covered the position of Finance Business Partner for Central America and the Caribbean, in charge of advising the Commercial Unit Head in the financial decisions. Support to this commercial unit in Financial decisions of Function Expenses and Sales Rebates.

Monthly forecast elaboration of Income Tax and Other Income and Expenses for all countries and business units in Latin America. Advisory to brands and Market Development Organizations on business impact of decisions from a tax stand point.• Trained more than 50 people in the finance and non-finance community on P&G business model and tax essentials. Additionally, represented Latin America in the Global Tax Simplification project. These two achievements led to sharing of best practices among business units and regions, and better business understanding, which reduced the consulting time in about 40%.• Designed the income tax simulator and let its execution with a trainee in charge. Additionally, designed and created a process and tool for the measurement of pricing in all business units from our region. These two tools allowed better visibility on the sales and income tax impact on our business decisions and allowed our business units to have sharper strategies and results.• Redesigned the process of forecasting and calculation of FBCSI (direct responsibility to IRS). This process simplification led to better visibility of the business impact of this tax component, reduced in 75% the invested time on review with the business units and all maintaining the data quality on delivery to IRS.

Design and supervision of execution of market research studies with offshore external suppliers. Analysis of results and support on business decisions to Brand Operations Team.• Elaborated an analysis that determined the correlation between market penetration and household loyalty from P&G brands. This enhanced our goal setting model on the marketing team.• Established the market penetration and loyalty goals for P&G brands in Andean cluster to reach the volume goals for 2010. This was the first time that loyalty was included as a potential source of volume, which led to more precise plans and enabled decision making to increase loyalty in P&G households, as this was too a source of sales.• Designed and coordinated market research studies with several suppliers across the region, to determine the potential for conversion of new users in P&G marketing trial activities. This also allowed the estimation of the ROI of such marketing activities, which enabled us to invest higher amounts on the activities with higher conversion potential and ROI.• Created the Andean Trial Database, which was a tool that helped us estimate the potential of conversion of the marketing trial activities in the cases in which we could not afford a market research study. This allowed us to estimate the potential of conversion and ROI of 100% of the trial activities.