Home About
About
Cancel

About

Download CV in PDF

Ramon Roldan de Lara

Portifolio | +55 (041) 98458-8355 | roldanramon83@gmail.com |
Ramon Roldan de Lara | github.com/RoldanRamon | IBM Badges

Educational Background

I have a degree in Bachelor of Business Administration - Positive University - 12/2016
Pos graduate in Lean Six Sigma: Green Belt - Catholic Pontiff University - 07/2022
Pos graduate in Design Thinking, Continuos Improvement - Cruzeiro do Sul Virtual - 10/2022
Pos graduate in Data Science - Catholic Pontiff University - (Scheduled for start in 03/2023)

Summary

I have + 4 years of experience with data science, working daily with R, SQL, Excel, VBA, Power BI, Tableau and Python.

Are part of my daily life practical activities a such as automated data collection (SQL and Web Scrapping), data preparation and analysis (Tidyverse / Pandas / DAX), professional visualizations with web applications and dashboards (BI / R / Tableau), statistical modeling and develop models machine learning (Tidymodels).

With my experience in procurement, lean six sigma certification and using design thinking, my goal is bring innovative solutions to improve the customer experience.

Expertise:

  • Procurement and Strategic Sourcing
  • OOP (Project Oriented Programmin) in R, SQL, Python and VBA.
  • Statistical Modeling, Web Scraping, Machine Learning, RPA.
  • Data Visualization and Dashboards: Excel, Power BI, Tableau, Flexdashboard, Rmarkdown, Shiny, Google Data Studio
  • Project Management, Team Management, methodology agile, Six Sigma, Scrum, Kambam

I knowledge in:

  • Windows, Linux (Includind CMD and Bash)
  • Microsoft Office (Outlook, Excel, Word, Power Point, Teams, Flow) and Google Suit (Gmail, Drive, Data Studio, Analytics)
  • Data Visualization, Dashboards and Web Application Development.
  • ERPs: Benner, SAP and TOTVS.
  • Statistical Modeling, Web Scraping, Machine Learning, Text Mining
  • Git, GitHub, Git Actions, LaTeX, Markdown, HTML, Ruby, Jekyll, RPA, Docker, API
  • Rstudio, VScode, MySQL, Minitab
  • Cloud-computing, Clean Code, SQL, NoSQL, Microservices, SOLID

Languages:

  • Fluent in Portuguese, Spanish and intermediate level in English.
    Obs.: English - B2 Upper Intermediate according to the Common European Framework of Reference - CEFR.

Professional Background

Marista Group - Senior Strategic Planning Analyst - Since Dec/2019 until Now

  • Develop procurement KPIs with quantitative methodology;
  • Development of statistical spot reports to support the board in real-time decision-making;
  • Responsible for managing the budget and financial accounts of the procurement area;
  • Provide support to buyers in negotiations with strategic sourcing & TCO methodology;
  • Process mapping and design for continuous improvement (Six Sigma);
  • Participation to build procurement policies and procedures;
  • Project implementation of the global level purchasing portal in the Marista Group;
  • Benner ERP parameterization to help Shared Services Center (SSC) stakeholders.

    Achievements:
    1- Participation to implement a project using the continuous improvement methodology (Six Sigma) in the Cajuru Hospital, in COVID-19 time, the main goal is mapping and redesign process to reduced bed sheet consumption in 10%.
    2- Participation to update the procurement policy, this project has the main goal update points:
    • Update the SLA Procurement rules;
    • Update of rules number of quotes per value range;
    • Definition of rules for drafting contracts and commercial agreements;
    • Update of rules for the use of technical advice;
    • Update of rules value ranges approval, cost centres, for purchase requests.

Independent Consultant & Expert on Excel - Since Mar/2019 until Dec/2019

  • Process automation and development of professional dashboards;
  • Excel teacher from basic to advanced;
  • Programmer for VBA and R languages;
  • Study of time series and quantitative application in the financial market;
  • Continuous improvement consultant for small and micro companies;
  • Study of data science: web scraping and machine learning techniques.

Madeira Madeira - Comercial and Purchasing Supervisor - Since Oct/2016 until Mar/2019

  • Monthly Campaigns: Negotiation the cost and development of the sale price together with the marketing strategy;
  • Supplier Assessment: Selection and development of new suppliers aiming at better price / quality / delivery;
  • Private Label: Development of new products, and exclusive products, with latent market demand;
  • Commercial support to the logistics team, registration team, and sales team; pricing;
  • Ensure the level of logistics delivery service (SLA) above 95%;
  • Constant search for innovation and improvement in the procurement area.

    Achievements:
    1- Private Label champion: Development of exclusive products with latent demand by the market that became sales champions. Above R$1 Million per month.;
    2 - Growth of purchase and sales volume of all suppliers of the portfolio, and maintaining the SLA logistics delivery service above 95%.

Mondelez International - Buyer of MRO (maintenance, repair and operation) - Since Nov/2015 until May/2016

  • In the MRO portfolio, I was responsible for the replenishment of spare parts in all warehouses in Brazil.

    Achievements:
    1- Participation in the implementation of the Coupa system that manages local purchases. This system reduced 70% of the time spent on analysis of low value-added purchases and increased the overall purchasing policy by 30%;
    2 - Development of a spreadsheet that partially replaced the Ariba system, used for quotations, this brought improved management in procurement contracts for indirect material in the 17 LATAM countries and automated the process.

Mondelez International - Procurement Intern - Since Sep/2013 until Oct/2015

  • Update of KPIs of travel category for 17 countries in Latin America;
  • Support in sourcing strategy with national and international suppliers, analysis of contracts with airlines, hotel and rental car;
  • Support to ensure formalization of signatures in contracts and agreements of confidentiality with the legal, supplier and purchasing sector;
  • Develop KPIs with VBA language to calculate the productivities of the negotiations, and support for validation with the financial sector;
  • Support the procurement team with vendor registration.
  • Support the procurement team with weekly meetings organization, reporting and presentations in PT, and reporting when necessary.

    Achievements:
    1- Support in implementing the travel cost reduction project that brought a saving of R$4 MM per year in Latin America;
    2- Development the KPIs Dashboard, and support in the implementation for LATAM, improving the portfolio management by country;
    3- Support to implementation of projects in travel: rental-car for Brazil, regional-airlines-bid, global-hotel-bid for the world.

EMATER - Intern - Since Mar/2012 until Sep/2013

  • Support for the 33 metropolitan area offices with payment for electricity, water, internet; and purchase of office supplies and tonners;
  • Support to the regional team with meeting scheduling, distribution of pouch, file, preparation of account installments, and point sheet elaboration;
  • Fixed Assets: support in the conciliation of patrimonial, and support in the other activities of the Coordination of Patrimony;
  • Regional Warehouse: Control of entries and exits, conference of invoices, organization and evaluation of stock obsolescence.

Udo Heuer - CNC Lathe Operator - Since Jul/2010 until Mar/2012

  • Machining of ferrous and non-ferrous materials according to the technical drawing guaranteeing the quality in the finished products.

Caixa Econômica Federal (CEF) - Intern - Since Jun/2008 until Feb/2010

  • Regional Warehouse: Control of entries and exits, conference of invoices, organization and evaluation of stock obsolescence.

Diplomas:

Data Science Academy (DSA)

IBM:

DataCamp:

Udemy:

Linkedin:

Recently Updated