Leonardo Gai Email and Phone Number

Developing insights through data analysis, mainly using Microsoft Packages such as Power BI, SharePoint, Power Query, and Excel.Working closely with the marketing team and decision-makers, extracting, transforming and loading (ETL) the data from diverse data sources to track the trends in acquisitions and improvements in customer retention strategies.Building and maintaining reports and dashboards in Excel and Power BI to monitor the marketing strategies, trends, and financial KPIs, with a keen eye on the data quality and performance.Developing scripts in Python with Selenium and Pandas libraries to automate and streamline the processes of data extraction and data cleaning.

Analysis and carry out with demands from the Conduct Supervision sector. Developing and enhancing dashboards from scratch, using raw data to extract valuable information from external surveys.Developed a risk model using statistics to monitor and classify the Insurance Undertakings on a conduct supervision basis.

Developed the stock exchange trading desk, advising clients on the creation of a portfolio anddiversification of investments. Close liaison with clients helping them allocate assets in the stock market and derivatives. Also, helped with the risk management of portfolios, agricultural and foreign exchange hedging for individuals and corporations; as well as foreign exchange operations. I met the demands of hundreds of customers, on several different issues.

Participated in the capture and development of economic and financial viability projects for companies,obtaining improvements in the quality of projects; economic and financial expertise; financial management consultancy for SMBs, and market research. Participated in consultancy in reducing bureaucracy for micro and small companies in 13 municipalities in the MS (State of "Mato Grosso do Sul").

Development and improvement of reports related to the labor market, foreign trade, confidence indicators, elaboration of extraordinary studies, as well the conduction of an Industrial Survey in Mato Grosso do Sul (BR), where I gathered information by phone calls and e-mails, attaining a significant (3x) increase in response rate.

Project “Characterization of economic agents in the corn agro-industrial system in the state of Mato Grosso do Sul";Study referring to the corn supply chain in the State of Mato Grosso do Sul, covering all stages from planting to designation.

Production and monitoring of financial reports;Monitoring and control of the cash flows of the administration and the execution of works;Preparation of reports for payroll payment.