Alexandre S.

Data Analyst

Intern
3/1/2021 - 12/1/2021

Developed automations in R, VBA, and Python to aid partners in decision-making and business management. Generated monthly reports for clients utilizing Excel and RMarkdown. Created dashboards and reports to visualize data effectively. Conducted market trend monitoring to identify short- and long-term investment opportunities.

Controller
3/1/2020 - 12/1/2020

Managed various financial processes including bank reconciliation, exchange rates, control of receipts, and customer billing. Developed advanced automations using VBA and Excel to streamline data processing. Monitored dollar trends to identify opportunities for gains through currency fluctuation analysis.

Intern
4/1/2019 - 3/1/2020

Gained expertise in adapting spreadsheets through the developer tool by creating and improving macros in VBA, incorporating processes in Excel and Power Query. Conducted comprehensive research on market trends and optimized query operations using databases, followed by developing detailed reports through Power BI. Contributed to automated project development utilizing R, facilitating the comparison of Excel documents and the creation of dynamic charts.

Human Resources Analyst 1
10/1/2022 - Present

Developed expertise in creating procedures for data processing using SQL and designing Views for integration with Power BI. Demonstrated proficiency in building dashboards by aggregating data from multiple sources, including SQL, Excel, and SharePoint. Automated various processes through the application of VBA, R, and Python to analyze OKRs and other performance indicators.

Electrical Engineering at Fluminense Federal University
2016 - 2022