Rafael Junqueira Email & Phone Number

• Missão: Report dos resultados das ações e promoções de CRM e indicadores de clientes para apoiar a empresa na tomada de decisão.Responsabilidades:
• Realizar análises de dados para apuração de resultados de promoções, campanhas e ações pontuais de Marketing/CRM/Digital;
• Responsável pela construção, manutenção e atualização dos books de indicadores e relatórios da área;
• Responsável pela construção de análises de comportamento do cliente.

Rio De Janeiro, Rio De Janeiro, Brasil

Responsável pela construção das metas, apuração dos resultados de vendas e remuneração variável dos colaboradores (mecânica, cálculo mensal, processo e análises).

Brazil

• Main responsibilities in the TIM+C6 Bank partnership:
• Budget (volume, revenue and cost);
• Monitoring of the partner's assessment (fee and equity);
• Controls of KPIs of the Partnership Contract (milestones, payments made and pending);
• Specific Analysis (reported sales x API x bank database).

Rio De Janeiro, Brazil

• Responsible for Special Projects:
• Partnership with TIM and C6 Bank: design of management reports, constant interface with the bank for corrections and evolution of data to allow new reports and analyses;
• Contact Management: consolidation, classification and analysis of all contacts (messages and calls) that TIM made with its customers through its own means and external suppliers, enabling the design and monitoring of.

Rio De Janeiro Area, Brazil

• Main responsibilities:
• Construction of executive reports to monitor business KPIs (eg: Executive Migration Report for the Top Offer - volume and quality);
• Leadership of ANATEL's Lean Six Sigma Complaint Reduction Project (Prepaid Credit) and Green Belt certification. Team: 5 Customer Service and Marketing employees;
• Application of the DMAIC methodology.Results - Comparison between before the start of the project (Jan/18-Feb/19) and after (Jun-Dec/19):
• Displacement of the mean: 36% reduction in the complaint rate (from 0.1182 to 0.0755);
• Standard deviation: reduction of 7% (from 0.01848 to 0.01723);

Rio De Janeiro Area, Brazil

• Main responsibilities:
• Reference Books (Pre, Post and Control) with the main Base, Use, Migration, Segmentation, Research and Competitive Scenario indicators (monthly);
• Implementation of the Marketing Campaign Results area (NBA, Massive, E-mail etc), supporting the Consumer segment areas (Pre, Post and Control) and executives in decision-making with reports and analyzes (mainly.
• Participation in the Pre CRM Performance Desk Project (100-day Plan) with the creation and generation of the daily Executive Report detailing the performance of migrations to TIM Pre Smart (volume and quality).

Rio De Janeiro Area, Brazil

• Main responsibilities:
• Customer base projection:--- Monthly view: preview generated weekly of the current month;--- Budget (quarterly, annual and triennial): every 3 months the remainder of the year was projected and, at the end of the year.
• Development of mobile line cancellation projection models, aligned with business needs (examples: Organic/Early for evaluating sales quality and Base per Plan to refine revenue projection);
• Leadership of two people for the development of the works.

Rio De Janeiro Area, Brazil

• Main responsibilities:
• Projection of pre revenue and by Services Revenue Forecast report.
• Design and implementation of the new Pre-Revenue projection model per offer, regional and considering the new mechanics of the offers (eg: charging per call/day of use of the service).

Rio De Janeiro Area, Brazil

• Main responsibilities:
• Management of integration projects to launch new services (interface with IT, Network, Integrator and Content Providers).
• Reformulation of project management: (1) Project Control; (2) Review of Processes; (3) Documentation and (4) Automation.

Rio De Janeiro Area, Brazil

• Main responsibilities:
• Outcall actions (Cross/Up Selling area): definition of the target, creation of the script, operationalization of the action with a third-party CRC (including training and generation/sending of the SAS mailing) and.

Rio De Janeiro Area, Brazil

Rio De Janeiro Area, Brazil

• Main responsibilities:
• Implementation of pre/post-regional report with complete analysis of local markets: commercial performance, competitive scenario, commercial actions and communication strategies.
• Development of a mathematical model to support the choice of football teams to be sponsored. Beginning of the strategy that culminated in the Infinity Fan offer.
• Conduction of periodic shoppers throughout Brazil at TIM's and competitors' POSs to assess the local scenario, especially the sales pitch.
• Presentations of the Consumer Director (Annual Marketing Plan and important events).

Rio De Janeiro Area, Brazil

• Main responsibilities:
• Geographic analysis using GIS technology, combining primary (corporate), secondary (market) and cartographic data. Main analyses: coverage (comparative; potential locations), performance (market indicators) and micro.
• Management of TIM coverage and competition information (GSM, EDGE, 3G and STFC).
• Monthly performance report for the individual mobile voice segment based on official data from ANATEL and players' strategy (offer and communication).

Rio De Janeiro Area, Brazil

• Main responsibilities:
• Development of reports, analysis and competition monitoring tools by region with a focus on performance and prices of chips and handsets (supported by six regions).

Rio De Janeiro Area, Brazil

• Management of several projects focused on Marketing activities, such as brand awareness, customer relationship and market research/study. The management experience with a team of 12 people stands out.

Rio De Janeiro Area, Brazil

• Participation in a business plan for the opening of a Spa in Arriyal do Cabo/RJ.
• Participation in an internal customer relationship project and presentation as a success story in two meetings of junior companies and an entrepreneurship event.

Rio De Janeiro Area, Brazil

• Organization of the event I Marketing Week at CEFET/RJ.
• Participation in two strategic planning and seven academic events.

Master Of Business Administration - Mba, Data Science & Analytics

Bachelor, Production Engineering

Projeto Final - Título: Análise da Relação Entre Marketing e Logística nas Organizações Orientador: Rafael Paim Cunha Santos