Joao Vitor De Alvarenga Ferreira

Data Analyst Intern

TopBuild Corp. (BLD)•  May 2024 - August 2024•  Daytona Beach, FL

- Automated data collection for public construction data using the Census API and Python, improving process speed by 95%. - Created an interactive Power BI report on New Residential Construction data tailored for senior leadership use. - Developed and published a semantic model to allow the finance department to use public construction data in their reports. - Managed FP&A workspace in Power BI, setting automated refreshes, managing user roles, and training workspace members.

Financial Analyst - FP&A

TopBuild Corp. (BLD)•  January 2022 - August 2023•  Daytona Beach, FL

- Managed Income Statements for 11 Mergers and Acquisitions using Excel, extracting data via OneStream. - Coordinated with over 120 branch managers to monitor and report Residential Insulation Units and Sales. - Developed an Excel report for C-suite to track regional performance based on residential insulation units. - Consolidated data from three databases for quarterly 10-Q and 10-K revenue reporting by product line. Assisted the VP of Investor Relations to equip Senior Management with accurate information for quarterly calls. - Analyzed monthly housing metrics from Census and other sources, enhancing managerial insights.

Pricing Analyst

Arthur J. Gallagher & Co. (AJG)•  November 2019 - January 2022•  Brownsville, TX

- Led 12 software change requests, improving system functionality, and overseeing quality tests. - Identified and coordinated the resolution of 30+ system issues in collaboration with IT. - Assisted in implementing 4 rate changes, to ensure rate competitiveness, sustainable growth, and compliance. Crafted a Tableau report to validate in-system pricing, decreasing turnaround time by 35%. - Automated data collection processes using Python and Selenium, reducing data acquisition time by 90%. - Utilized advanced Excel functions to generate custom reports directed to senior management.