Lucas Ferreira
Toronto, ON · 416-555-0142 · lucas.ferreira@example.com
Open Work Permit, valid until Aug 2028
Summary
Data analyst with six years of experience in retail and banking. I build Power BI dashboards, write SQL to clean and join sales data, and automate recurring reports so business teams get reliable numbers on time.
Skills
SQL ·Power BI ·Excel ·Python (pandas) ·Data cleaning ·Reporting automation ·Retail analytics ·Stakeholder communication
Experience
Customer Service Associate (part-time)
Sep 2025 – Present
Northfield Market
Toronto, Canada
- Handle checkout and customer questions in English and Portuguese at a busy Toronto grocery store.
Data Analyst
Mar 2021 – Jun 2025
Varejo Sol
São Paulo, Brazil
Regional retail chain in Brazil with 120 stores and about 6,000 employees
- Built a weekly Power BI sales dashboard used by 35 store managers.
- Automated stock-level reports with SQL and Python, reducing manual reporting time from 6 hours to 1 hour per week.
- Cleaned and merged point-of-sale data from 3 legacy systems into a single reporting database.
- Analyzed promotion results across 120 stores and presented the findings to the regional marketing team.
Junior Business Analyst
Jul 2019 – Feb 2021
Banco Horizonte
Belo Horizonte, Brazil
Mid-sized Brazilian bank with about 2,500 employees
- Prepared monthly credit portfolio reports in Excel for the risk committee.
- Documented requirements for a loan-approval workflow with the IT and operations teams.
Volunteer Experience
Volunteer Tutor
Oct 2025 – Present
Newcomer Learning Hub
Toronto
- Tutor 4 newcomer adults in spreadsheet basics every week.
Education
Bachelor of Economics
Jun 2019
Universidade do Vale
Belo Horizonte, Brazil
Equivalent to a Canadian four-year bachelor's degree (WES)
Certifications
- Microsoft Certified: Power BI Data Analyst Associate, Microsoft (2023)
Languages
English (Professional working proficiency) · Portuguese (Native) · Spanish (Intermediate)