Results-oriented Analyst skillful in managing and breaking down large volumes of information. Proactive at heading off issues in operations, workflow and production by uncovering trends affecting business success.
Overview
3
3
years of professional experience
5
5
years of post-secondary education
1
1
Language
Work History
CPFR analyst
L’oreal Paris
01.2019 - 01.2021
Preform a suggested biweekly sourcing to Olimpica customer, considering the levels of
inventory, monthly and average of sales and catalog alignment
From there, calculate the days
of inventory and fill rate of the client and analyse them vs KPIS, follow internal inventory to
assure availability for the client
Goals:
Preparation of the suggested calculation base on the variable: daily average sales,
inventory, inventory in transit, customer ABC catalog, safety stock and minimum and
maximums of stocks by sku and store
Assure minimum of amount for each purchase order
3% of Impact on fill rate due to catalog alignment
Developed a report in power bi that allowed trade, commercial, and supply team to have
an analysis of SISO and days of inventory of our five top clients
This report also permits
us to have tracking of our KPIS (Days of inventory – out of stock levels) with historical
data.
Sales Force Analyst
GlaxoSmithKline
07.2019 - 11.2019
Loading information in veeva, preparation of reports and dashboards that generate visibility f
the process executed and planned
Support to the expert marketing and shopper area
Goals:
Acid analysis in the frequency to improve the decisions in the route planning, with a
better performance of 2% in the KPI
Developed a report in power bi about coverage of area by supervisor, which
allowed us to have information in real time and had an historical data of the
compliance of the KPI´s
Improvement of the process in veeva, impacting in three business days
Permanent panel analysis to improve the execution of visits.
Demand planning intern
GlaxoSmithKline
, C.
06.2018 - 06.2019
Develop tools for the correct preparation of the forecast, evaluate the behavior of the sell in
(SI), sell out (SO) and stock in trade, monitor the KPIS’s of FAC (Forecast accuracy) and FBS
(Forecast bias)
Goals:
Development of a tool that allows to have control over the generated SKU’s
Deep understanding of the inventory game and its impact on planning
Preparation of the trainings for the continuous improvement of the process
Improvement of the tool that allowed us to analyze the SI and SO behavior vs the
projected.
Education
BBA - Supply Chain
Universidad Del Rosario
Bogotá, Colombia
02.2015 - 11.2019
Skills
Teamworkundefined
Affiliations
Knowledge in Supply Chain Management (SCM), with experience in demand planning and
CPFR, focus on strategic thinking and decision making. Management of office tools and basic
knowledge in Power Bi.