Summary
Overview
Work History
Education
Skills
Websites
Certification
Hobbies
Additional Information
Languages
Timeline
Generic

Lorenzo Bottarlini

Summary

Data analyst with over 3 years of experience in the industrial metals sector, combining strong technical expertise with a practical understanding of market dynamics and production processes. Skilled in using Excel, basic Power BI and statistical tools to provide insights into sales performance, market trends and supply chain optimization. Proven experience in supporting executive decision making through data modelling, predictive analytics and financial reporting, particularly in relation to international metal markets and hedging strategies using the London Metal Exchange (LME). Skilled in cross-functional collaboration, with a background in both business operations and manufacturing analytics. Graduate in Big Data and Analytics, with a passion for turning raw data into strategic business value.

Overview

9
9
years of professional experience
1
1
Certification

Work History

Data Analyst – Metals Market & Business Intelligence

RMB S.p.A.
01.2022 - Current

Spearheaded the development of a dedicated Market Data Analysis department, leveraging a background in Big Data and Analytics.

Monitored international metal markets using the London Metal Exchange (LME) to assess pricing trends and market dynamics.

Managed hedging strategies via metal futures trading to optimize profit margins and reduce cost risks.

Created dashboards and performance reports using Excel and occasionally Power BI, covering sales performance, customer contracts, and market forecasts.

Conducted statistical analysis on stock levels, production output across multiple sites, and supply chain performance.

Built predictive models to support pricing strategies and logistics planning based on historical and real-time data.

Maintained updated pricing agreements with suppliers, identifying opportunities for cost savings and revenue optimization.

Interpreted technical market charts and provided actionable insights to senior management for strategic decision-making.

Key Achievement: Successfully implemented a data-driven approach to market analysis and hedging, resulting in improved cost control and higher operational margins across the company's trading activities.

Commercial Back Office Assistant

RMB S.p.A.
02.2021 - 12.2021

Managed sales contracts with suppliers and monitored weight losses and commercial adjustments.

Produced detailed reports and analytical models using Excel and PowerPoint to support sales strategies.

Coordinated with the sales and logistics teams to ensure contract compliance and timely data availability.

Production & Quality Assistant

RMB S.p.A.
06.2020 - 02.2021

Gained in-depth knowledge of the entire metal recovery production cycle, from incoming material processing to output management.

Produced detailed yield reports for suppliers, tracking material transformation across various processing stages.

Monitored and documented production flow, ensuring accuracy in stock allocation and process efficiency.

Developed skills in identifying different metal types derived from processing facilities and their commercial value.

Accounting Assistant

Equogas S.r.l.
12.2018 - 05.2020

Managed customer invoicing and delivery documentation (DDT), ensuring accuracy and timely processing using XP and JDE systems.

Prepared and entered sales invoices, monitored order fulfillment, and ensured documentation compliance.

Controlled product compliance and outgoing shipments, maintaining high standards for logistics and documentation.

Maintained inventory records and warehouse stock coordination, ensuring accurate data flow between departments.

Sales Back Office Assistant

Equogas S.r.l.
12.2018 - 05.2020

Supported sales operations by preparing quotations, commercial offers, and managing order entries into company systems (XP and JDE).

Provided after-sales support and customer service, acting as a point of contact for clients throughout the sales process.

Organized and coordinated promotional activities and sales campaigns in collaboration with the sales team.

Handled wholesale and retail sales, both in-person and via direct channels, focusing on client retention and satisfaction.

Played a key role in managing order processing, fulfillment, and customer relationship management.

Administrative Assistant

Centro Gamma Termosanitaria S.p.A.
04.2016 - 10.2017

Assisted with general accounting tasks, including data entry and document verification for both sales and purchase invoices.

Supported the finance team in cash flow monitoring and reconciliation of financial records.

Helped in the preparation and review of payroll documentation, ensuring accuracy and confidentiality.

Education

High School Diploma -

I.T.C.G. Bazoli Polo
Desenzano Del Garda, Italy
07-2018

Bachelor of Science - Statistics And Big Data

University Mercatorum
Rome, Italy
05-2025

Skills

  • Data analysis and visualization (Excel, Power BI)
  • Market trends monitoring (metal commodities and pricing)
  • Forecasting and reporting for material flows and inventory
  • Currently attending an intensive English course to obtain the IELTS B2 certification (expected Summer 2025)
  • Dashboard creation and performance tracking
  • Business Intelligence and data-driven decision making
  • Quantitative analysis and statistical modeling
  • Strong knowledge of industrial processes and plant operations
  • Process optimization and material traceability
  • Proficient in MS Office Suite (Excel advanced functions, Pivot Tables, VLOOKUP, etc)
  • Effective communication with technical and business teams
  • Time management and attention to detail

Certification

  • Power BI – Beginner Level (40-hour internal training)
    RMB S.p.A. – Internal Corporate Course, Completed 2024
  • Excel – Intermediate Level (40-hour internal training)
    RMB S.p.A. – Internal Corporate Course, Completed 2024
  • European Waste Management Regulations – Awareness Course (16 hours)
    RMB S.p.A. – Internal Corporate Course, Completed 2023
  • Workplace Safety and Risk Prevention (24 hours)
    RMB S.p.A. – Internal Corporate Course, Completed 2022
  • IELTS B2 – English Language Certification (in progress)
    Wall Street English / Language School – Expected Summer 2025

Hobbies

Passionate about sport and personal well-being, regularly trains in the gym and runs. Interested in fashion, modern art and cultural experiences. Football enthusiast and avid traveler who enjoys exploring new places and perspectives. Motivated by continuous learning and self-improvement, with a strong interest in acquiring new skills.

Additional Information

  • Currently relocating to Barcelona (residence already secured)
  • Strong adaptability and experience working in cross-functional teams
  • Familiar with industrial and operational environments
  • Native Italian speaker; fluent in English (B1–B2); learning Spanish
  • Open to international and multicultural work contexts

Languages

Italian
Bilingual or Proficient (C2)
English
Upper intermediate (B2)
Spanish
Beginner (A1)
German
Beginner (A1)

Timeline

Data Analyst – Metals Market & Business Intelligence

RMB S.p.A.
01.2022 - Current

Commercial Back Office Assistant

RMB S.p.A.
02.2021 - 12.2021

Production & Quality Assistant

RMB S.p.A.
06.2020 - 02.2021

Accounting Assistant

Equogas S.r.l.
12.2018 - 05.2020

Sales Back Office Assistant

Equogas S.r.l.
12.2018 - 05.2020

Administrative Assistant

Centro Gamma Termosanitaria S.p.A.
04.2016 - 10.2017

High School Diploma -

I.T.C.G. Bazoli Polo

Bachelor of Science - Statistics And Big Data

University Mercatorum
Lorenzo Bottarlini