Rafael Paes
@rafaelpaes
FP&A Analyst bridging finance and advanced analytics with Power BI, Python automation, and AI-driven reporting across South America.
What I'm looking for
I’m an FP&A Analyst with 5+ years of experience bridging financial planning and advanced analytics. At Cushman & Wakefield (Fortune 500), I support South America’s finance function by delivering Power BI dashboards, executive reporting, and AI-driven process automation across 6 countries—turning monthly performance into real-time visibility for CFO and CEO decision-making.
I combine deep FP&A fundamentals—budgeting, forecasting, variance analysis, and C-suite reporting—with hands-on automation and AI. I’ve built and deployed AI agents in Microsoft Copilot Studio, automated recurring data extraction and Excel consolidation with Python and Power Automate, and trained stakeholders to accelerate analytical workflows while reducing manual effort. Previously, I owned end-to-end Power BI solutions at Theramex and supported market intelligence dashboards at Markestrat using Excel and SQL to deliver forecasting and executive reporting.
Experience
Work history, roles, and key accomplishments
Designed and delivered a regional Power BI Business Review dashboard across 6 South American countries, replacing a manual Excel process and enabling real-time monthly performance tracking for CFO and regional leadership. Automated expense data extraction and Excel consolidation workflows with Python and Power Automate, and built AI agents in Microsoft Copilot Studio to accelerate analytical work
Commercial Excellence & BI Intern
Theramex Brazil
Aug 2024 - Jan 2026 (1 year 5 months)
Owned end-to-end Power BI solutions (data extraction, DAX modeling, dashboard design, and user training), creating a self-service analytics environment for the commercial team. Automated recurring Excel reports and strategic planning tools to eliminate manual monthly consolidation, and analyzed sales force performance and district manager KPIs to support commercial strategy.
Market Intelligence Intern
Markestrat Group
Oct 2023 - Jul 2024 (9 months)
Built and maintained Power BI dashboards for agribusiness market analysis, delivering qualitative and quantitative insights to consulting clients. Extracted, cleaned, and modeled agricultural datasets in Excel and SQL to support market forecasting and executive-level client reporting.
Customer Sucess
MaisTodos
May 2021 - Aug 2023 (2 years 3 months)
Managed client relationships for 100+ medical and dental clinics across Brazil, supporting the adoption and usage of MaisTODOS payment solutions.
▸ Designed and implemented a daily Power BI dashboard to track payment method distribution across all client clinics — replacing a manual, weekly Excel-based process that offered no real-time visibility.
Education
Degrees, certifications, and relevant coursework
FATEC São Paulo
Bachelor of Science, Systems Analysis and Development
2023 -
B.S. in Systems Analysis and Development at FATEC São Paulo (2023–2026), currently in progress.
University of São Paulo
Coursework, Applied Mathematics for Business
2017 - 2021
Completed coursework in Applied Mathematics for Business at the University of São Paulo from 2017 to 2021.
Tech stack
Software and tools used professionally
Availability
Location
Authorized to work in
Job categories
Interested in hiring Rafael?
You can contact Rafael and 90k+ other talented remote workers on Himalayas.
Message RafaelFind your dream job
Sign up now and join over 100,000 remote workers who receive personalized job alerts, curated job matches, and more for free!
