Stefano Leone

Background

About Stefano Leone

Summary- Data Analyst with 6+ years of experience and financial background working full-time in the FinTech industry- Experienced in building and maintaining ETL pipelines, integrating APIs, and enabling client-facing teams with actionable data- Proven track record of improving data quality, automating workflows, and ensuring accuracy and efficiency across Finance and Operations functions- Proficient at translating complex datasets into clear, business-ready insights that support strategic growth and investor engagement- Holding a MSc in Data Analytics and a MSc in Corporate FinanceTechnologies- SQL: Experienced in writing, optimizing, and validating complex SQL queries and views in PostgreSQL, Microsoft SQL Server, Amazon Redshift, and MySQL. Skilled in data extraction, transformation, and validation for analytics and reporting pipelines- Python: Extensive experience using Python for data analysis, cleaning, and transformation, leveraging libraries such as pandas, numpy, and matplotlib. Proficient in building data pipelines and automation scripts for preprocessing and integration tasks. Designed and deployed web scraping projects to collect and structure data from multiple online sources - finalized successful Python web-scraping projects shared on Kaggle at Tableau & PowerBI: Created visualizations for trend analysis, performance tracking, and financial reporting. Collaborated with stakeholders to translate generic business requirements into clear data-driven solutions- Excel: Strong experience with Accounting and Finance data, including pivot tables, data validation tools, and advanced formulas- DBT: Developed and maintained dbt models to transform raw data into analytics-ready tables, improving data reliability and transparency- VBA: Developed VBA macros to automate repetitive Excel tasks and let macro users have control of relevant parameters.