Erico M.Data Analyst
Skills
Data Specialist with over twelve years of experience in major retail and service industries, offering a robust foundation in team leadership and commercial planning. Extensive experience as a Supervisor in Sales Front has imparted a broad business perspective and strong leadership abilities. Currently functioning as a Market Intelligence Specialist in a Market Insights cell, leveraging expertise in modeling, ETL, ELT, Big Data technologies, and various data analysis tools to provide valuable insights for executives and contribute to data monetization initiatives. Proficient in SQL (Oracle), HQL (Hive), Alteryx, Tableau, Excel, and Python.
Data Scientist
6/1/2023 - Present
Worked on educational geo-hub expansion using statistical analysis, geographic analysis, predictive models, clustering, and classification. Consolidated market data and Higher Education Census (Mec), processing and modeling this data for dissemination via Power BI dashboards. Monitored external data and competitive movements to generate insights with preventive and predictive value for tactical and strategic actions, including offers, pricing, and value-added services. Interfaced with suppliers and partners to gather valuable educational data inputs, leveraging sources such as Edu Market and Educa Insights. Conducted price elasticity studies for higher education courses to enhance enrollment conversion and profitability.Market Intelligence Specialist | Market Insights | Data Analytics
7/1/2021 - Present
Handled Anatel market data and developed reports and insights. Monitored external data and competitive movements to generate actionable insights. Identified benchmarks and success cases. Consolidated market data from Anatel, carried out data processing and modeling, and disseminated information through dashboards. Interfaced with suppliers and partners to gather valuable inputs and data for the business. Monitored and analyzed Ookla SpeedTest data, conducted studies on broadband test data, and correlated findings with performance and market data.Commercial Planning Consultant
3/1/2017 - 11/1/2021
Responsible for surveying and monitoring new projects and strategies in the commercial area while building synergy indicators for residential unit products. Conducted diagnoses and planning for risks and opportunities, mapped and prioritized leads, and performed portfolio analysis to gauge the impact of commercial strategies including credit policies, offers, ARPU, commercial acquisition cost, and HeadCount sizing. Created dashboards to track channel performance, evaluate offers, counter competition, and strategize improvements.Commercial Intelligence Analyst
3/1/2016 - 3/1/2017
Led the construction and development of the commercial intelligence area, providing critical information and diagnostics for decision-making at local levels. Applied geomarketing studies and conducted quantitative and comparative analyses of commercial indicators. Excelled in sales planning (S&OP), forecast elaboration, and trend curve analysis, as well as managing direct and indirect channel systems such as NeoGrid, Accera, and BI. Translated sell in and sell out data into actionable insights, identifying risks and opportunities for sales channels. Spearheaded the development of new sales processes and implemented effective remuneration metrics.Sales Supervisor
1/1/2014 - 2/1/2016
Led a sales team and sales promoters, managing a portfolio exceeding 800 clients. Developed expertise in negotiation and prospecting while servicing the self-service and cold retail channels. Oversaw key sales team indicators including volume, contribution margin, profitability, billing, numerical distribution, return, delinquency, turnover, and productivity. Implemented and monitored daily objectives to ensure team performance and alignment with strategic goals.Sales Planning Supervisor
1/1/2012 - 1/1/2014
Gained expertise in supporting the sales team by performing in-depth analysis of channels, categories, brands, and products. Developed and presented results that informed strategic decision-making for the operation and commercial teams. Skilled in calculating goals for variable compensation, ensuring alignment with performance objectives. Responsible for controlling and strategizing the pricing policy to optimize revenue and market competitiveness.Market Indicators Analyst (Resellers)
4/1/2011 - 1/1/2012
Gained expertise in performance analysis and routine operations across Brazil, focusing on key indicators for AmBev resales. Developed comprehensive reports and created detailed books and spreadsheets for the Resale Directorate to provide national visibility of performance metrics. Actively contributed to projects aimed at restructuring the sales area, including the development of tools for incorporating operations, resulting in improved efficiency and streamlined processes.Junior Productivity Analyst
7/1/2010 - 3/1/2011
Managed key indicators focused on sales force productivity, including coverage, positive rates, net journey, and product per point of sale. Prepared comprehensive performance reports featuring a ranking of all operations nationwide, enhancing visibility into sales effectiveness and operational efficiency. Demonstrated strong analytical abilities and proficiency in performance tracking tools, contributing to improved strategic decision-making and sales strategies.Accounts Audit Analyst (Telecom)
6/1/2010 - 7/1/2010
Focused on auditing accounts in the Telecommunications sector and providing comprehensive IT consulting services. Developed and refined expertise in consulting with clients, delivering robust support, and managing relationships with telephone operators under power of attorney. Utilized auditing tools and frameworks to ensure accuracy and compliance, while leveraging industry-specific knowledge to optimize account activities. Enhanced skills in client communication, problem-solving, and strategic relationship management.Billing and Account Dispute Analyst
8/1/2008 - 1/1/2010
Acquired expertise in analyzing accounts, managing discounts, and validating or invalidating billing requests. Developed proficiency in data manipulation using SQL to ensure accurate and contract-compliant billing practices.
Business Administration at Presbyterian University Mackenzie
2004 - 2008Data Science at Comunidade DS
2022 - 2022
Data Science at Comunidade DS
2/1/2022Tableau at Udemy
1/1/2020GREENBELT at SETEC - CLARO
3/1/2018
Erico is available for hire
Hire Erico M.All Howdy Candidates are vetted for skills and english proficiency.