Guilherme Mattos
Rio De Janeiro
Summary
Results-driven Data Analyst with over 4 years of experience in the telecommunications industry. Expertise in extracting actionable insights from large datasets, driving operational optimization, and informing strategic decision-making. Specialized in telecommunications data analysis, Management of digital communication with customers and churn prediction, contributing to enhanced service quality and cost reduction.
Overview
6
6
years of professional experience
Work History
Senior Consultant
TIM Brasil
08.2023 - Current
- Prioritized projects and project tasks depending on key milestones and deadline dates.
- Analyzed problematic areas to provide recommendations and solutions.
- Developed custom solutions based on client's strict requirements.
- Performed deep-dive data analyses to better understand customer behavior and churn performance across regions, plans, customer aging, and partners.
- Build presentations with analysis and insights to support Collection management.
- Partner with multiple areas squads to think and propose action plans to reduce bad debt and churn rate.
- Supported the Customer Relationship Management team with weekly, monthly & quarterly performance reports on what customer behavior is more impacting in Churn.
- Developed strategy classification about motivations that why clients became churn and proposed action plans to reduce churn rate by motivations
Consultant
TIM Brasil
02.2022 - 08.2023
- Analyzed problematic areas to provide recommendations and solutions.
- Liaised with customers, management, and sales team to better understand customer needs and recommend appropriate solutions.
- Collaborated with business partners and internal teams to develop innovative solutions to reduce churn rate.
- Developed Involuntary Churn data structures to aid in the development of insights and strategy.
- Developed analytics Deep dive for Optical Fiber business.
- Conducted business analysis to understand business needs and requirements to translate them into action plans.
Analyst
TIM Brasil
04.2020 - 02.2022
- Identified and resolved problems through root cause analysis and research.
- Recommended process improvements to continually identify, analyze, and fix constraints and challenges.
- Developed and oversaw Billing Key Performance Indicators(KPI).
- Developed the project to update the refund amount due to lack of use by customers.
- Developed and assisted in the implementation of sampling in the billing validation process ( Yellow Belt Certification).
- Analyzed and produced KPI reports allowing to monitor issued invoices closely.
- Design and maintain analytical dashboards, promoting data-driven decision-making about Billing.
- Worked closely with the IT team to address any data inconsistencies and the accuracy of data through systematic quality checks.
Intern
TIM Brasil
02.2019 - 04.2020
- Developed and review Billing operational dashboards to presented it to the management.
- Worked in partnership with IT to indicated problems in issued invoices process.
- Check of issued invoices data in Big Data.
- Developed of the end-to-end billing schedule.
Intern
Dataprev
07.2018 - 01.2019
- Applied statistical techniques and quantitative methods focused on the social area of government.
- Processed and manipulated large dataset about BI and Social Security Statistics.
- Sorted, organized, and maintained files.
- Participation in the publication of the Social Security Statistics Yearbook.
Education
Bachelor of Science - Statistics
Universidade Federal Fluminense
Niterói, Rio De Janeiro, Brazil09.2021
Skills
- MS Office
- SAS Enterprise Guide
- SQL
- Power BI
- Google Cloud Platform
Languages
English
Upper intermediate (B2)
Portuguese
Bilingual or Proficient (C2)
Timeline
Senior Consultant
TIM Brasil
08.2023 - Current
Consultant
TIM Brasil
02.2022 - 08.2023
Analyst
TIM Brasil
04.2020 - 02.2022
Intern
TIM Brasil
02.2019 - 04.2020
Intern
Dataprev
07.2018 - 01.2019
Bachelor of Science - Statistics
Universidade Federal Fluminense
Similar Profiles
Giovanni DrumondGiovanni Drumond
Senior Data Consultant at Tim BrasilSenior Data Consultant at Tim Brasil
Rodrigo Estevam DantasRodrigo Estevam Dantas
Bank Officer at Banco Do BrasilBank Officer at Banco Do Brasil
GRACIMERE SARRAZIM GOESGRACIMERE SARRAZIM GOES
NURSE at EMPRESA SEGEAM DO AMAZONAS -BRASILNURSE at EMPRESA SEGEAM DO AMAZONAS -BRASIL