Experience

Augme Capital

• Brazil
• Investment Management
• 1 - 100 Employee

• Data Analyst (Operations)

  • Nov 2022 - Present

  Job Description: Daily analysis of investment portfolios, looking for errors or variations outside the expected range, making process improvements using programming, and showing daily portfolio information to the investment team. - Portfolio publication time reduction of 40 minutes by automating common error resolutions using Excel formulas and VBA. - Saved over 7 hours of manual work per week through automation using Python data manipulation libraries (incl. Pandas) and SQL. - Made custom Microsoft Power BI dashboards to show the investment team daily, weekly, and monthly variations in new investment portfolios. - Reduced portfolio reprocessing by 50% by identifying common human errors and extensively negotiating with the broker to have their analysts make corrections before we received the portfolios in the morning. Show less



L.E.K. Consulting

• United States
• Business Consulting and Services
• 700 & Above Employee

• Business Strategy Analyst

  • Nov 2020 - Nov 2022

  Job Description: Acting in strategic cases for large Brazilian and American companies, working with data analysis (Excel modeling, Tableau, surveys, etc.) and qualitative sources of information to answer key questions from clients and make market predictions. - Constructed a strategic roadmap detailing how a major pharmaceutical company could gain up to 500 MM BRL on the sales of a high-cost biological drug using Excel modeling. - Managed research, interviews, and analysis for a 5M USD commercial due diligence covering the Latin American operations of a life sciences company. - Conducted a market study detailing 30-50M USD opportunities for an American diagnostic company looking to enter Mexico, including predictive modeling. - Researched and analyzed ~200M BRL tech opportunities for a leading tire manufacturer to diversify its business in Brazil, as well as a roadmap to maximize value creation. - Tools used in day-to-day work included Tableau for data analysis, Excel for doing market models, and Python for clustering; for data presentation, the main tools used were PowerPoint with Think-Cell and Tableau visualizations. Business Analyst Intern - Managed research, interviews, and analysis for an anti-fraud company focusing on new business and international expansion. - Sourced qualitative data and assisted Excel modeling for a diversification project to a leading pipe company looking to enter new markets. Show less



Poli Consulting Club

• Brazil
• Non-profit Organizations
• 1 - 100 Employee

• Analyst

  • May 2020 - Jan 2021

• Trainee

  • Mar 2020 - May 2020



Projeto Jupiter

• Brazil
• Aviation & Aerospace
• 1 - 100 Employee

• Member

  • Apr 2018 - Sep 2019