Alan Mello Email & Phone Number

Rio De Janeiro, Brasil

Rio De Janeiro, Brasil

TIM Brasil is one of the largest telecommunications operators in the country, offering mobile phone, internet, and pay-TV services. It is the leading operator in 5G coverage in the country, with an annual net service revenue exceeding R$ 20 billion.- Annual growth of contracted revenue by 26% in Digital Channels and 12% in Physical Channels, responsible for detailed financial modeling for the economic evaluation of new Post-Paid acquisition offers, directly impacting profitability projections and return on investment- Development of Business Plans, including monitoring and projection of revenue and costs (Opex and Capex) for cash flow analysis of new projects, based on strategic assumptions and inputs from various departments of the company- Development of a segmentation model for contracted revenue results for the Postpaid product portfolio, and ex-post analysis of strategic decisions- Proposition of strategic actions/improvements based on data analysis, developing models to support business decision-making, indicating trends and preventive actions.- Support the Commercial and Marketing teams in strategic pricing, with strong interaction, communication, and teamwork- Construction of pricing models, P&L analysis- Preparation and analysis of presentations, dashboards, and monitoring reports for the company's key financial indicators- Capture, analysis, and interpretation of large volumes of data, using advanced knowledge in SQL, Python, Power BI, Excel

Rio De Janeiro, Brasil

YDUQS is a Brazilian publicly traded holding company with a focus on higher education. It is the second-largest higher education company in Brazil in terms of revenue.- Annual growth of 24% in acquisition, with involvement in supporting the Sales and Marketing team in developing strategies with result insights, identifying business opportunities, with strong interaction, communication, and teamwork- Monitoring and real vs. budget analysis of company sales results, indicating trends and preventive actions- Preparation and analysis of presentations, dashboards, and monitoring reports of the company's key commercial indicators- Presentation to the board outlining the direction and commercial indicators- Development of dynamic reports for sales results indicators, utilizing advanced programming (Power BI, SQL/Oracle, DAX, Alteryx, Excel, and VBA)

Rio De Janeiro, Brasil

- 15% increase in Net Revenue levels through the implementation of improvements in short-term financial forecasting processes, resulting in greater transparency and accuracy in financial reporting- Responsible for monitoring the Prepaid Revenue results of the company (Gross Revenue ~ R$500mi/month)- Development of financial modeling to create scenarios for monthly preview results, with dynamic business and geographical breakdowns, based on strategic assumptions and inputs from various areas of the company, utilizing advanced SQL and VBA programming for Excel- Monitoring and analysis of actual vs. budget- Development of dashboards, management reports, and executive presentations- Development of dynamic reports for KPI analysis, calculating the impacts of each indicator on the result, using advanced programming in SQL, VBA for Excel, and Power BI- Support to the Accounting department in the monthly closing process, with strong interaction, communication, and teamwork- Optimization of Revenue consolidation processes in SQL database- Support to the Service Creation department in analyzing the impacts of new projects on the result calculation process- Presentation of results to internal and external clients (auditors)- Experience in technical team leadership

Rio De Janeiro, Brasil

- Annual growth of 24% in Net Revenue and a 26% improvement in Operating Costs (Opex), responsible for detailed financial modeling to develop long and short-term planning for the International Roaming business- Development of financial modeling for short and long-term projections of Revenue and Operating Costs for Interconnection and Roaming services, based on strategic assumptions and inputs from various areas of the company- Development of a detailed Forecast/Budget model for Roaming across more than 250 operators and services (Voice, SMS, and Data), aiming to explain volume deviations and/or changes in volume mix (in minutes) and price- Support to internal clients, conducting result and forecast analyses, indicating trends and preventive actions, with strong interaction, communication, and teamwork- Financial analysis of International Roaming contracts- Preparation and analysis of presentations, dashboards, and monitoring reports of the company's key financial indicators, including calculation of the financial impact resulting from any deviations in each KPI- Optimization of information flow processes in the area, using advanced programming in SQL, SAS Guide, and VBA for Excel- Experience in working with large volumes of data/information

Rio De Janeiro, Brasil

- Responsible for the analysis and control of the company's Prepaid financial results- Analysis of business performance indicators and customer profile with the aim of explaining and projecting the company's financial results- Development of dynamic tracking reports (dashboards) for financial indicators with various business breakdowns- Support the Marketing department with insights, indicating trends on the performance of new monetization strategies/actions, and providing managerial reports, with strong interaction, communication, and teamwork- Preparation and analysis of presentations and monitoring reports of the company's key financial indicators- Support the Network Planning department by providing managerial reports on the quantity of minutes and gigabytes trafficked- Development of a projection and analysis model for the quantity of minutes and gigabytes trafficked in each DDD to support the Network department, according to the needs of new business strategies- Structuring and implementation of SQL Database organizing the information analyzed/disseminated by the department- Optimization of information flow processes in the area, using advanced programming in SQL, SAS Guide, and Visual Basic for Excel- Experience in working with large volumes of data/information

Rio De Janeiro, Brasil

- Responsible for analyzing the financial results of the company's Fixed Telephony products- Customer-by-customer analysis to identify action opportunities and understand deviations in financial results- Preparation of Revenue Budget for the Corporate Business Unit- Preparation of Budget and Results management reports- Preparation of dashboards, management reports, and executive presentations- Automation of the area's processes flow, organizing all output from each product projection model into a single database- Development of analytical tools, using advanced programming in VBA for Excel and SQL- Implementation of projection models

Rio De Janeiro, Brasil

- Sizing of direct marketing campaigns- Customer-by-customer database manipulation aimed at extracting and analyzing information for defining marketing campaigns- Automation of the marketing campaign return analysis process through the development of proprietary tools- Analysis of campaign returns

Master Business Petroleum (Óleo/Gás E Transicão Energética)

Engenharia De Produção

Master Of Business Administration - Mba, Gestão De Investimentos