Talita Ranea

Junior Strategic Intelligence Analyst @ InterCement

About

I am a professional with experience in the areas of market intelligence, information quality, data processing and database marketing with knowledge in the following activities: - Construction of dashboards in Excel and processing of information; - Preparation of management reports; - Creations and presentations in PowerPoint; - Analysis of sales information to aid in targeting and decision making; - Daily monitoring of the area's KPIs, analysis of indicators, correction of sales prices; - Visualization and interpretation of BI data (Qlikview); - Support to the commercial area; - Experience in attendance in Spanish via Skype; Main results: - Time optimization by automatically triggering submissions (Macro/VBA). - Automation of information in Excel to update individual and managerial reports; - Optimization of the KIT registration process through the creation of a model spreadsheet with calculation of the percentages of price representativeness per product; Projects: - Monitoring of sales campaign from sending goals to results; - Preparation of material for real estate consultants with sales data indicators and presentation to them; - Conducting a Spanish course and assisting clients in Latin America in order to support the international expansion of the business. I have English and Spanish at an intermediate to advanced level. Knowledge in Office Package: PowerPoint, Word and Advanced Excel. Postgraduate in Business Administration from Universidade Presbiteriana Mackenzie.

Country

Brazil

City

São Paulo

Industry

Financial Services

Skill

Serviços bancários, Requisitos de negócio, Redação de propostas, Processos empresariais, Levantamento de requisitos, Resolução de problemas, Marketing comercial, Microsoft Excel, Capacidade analítica, Microsoft Word, Comunicações de marketing, Marketing digital, Segmentação de mercado, Marketing de banco de dados, PowerPoint, Microsoft PowerPoint, Adobe Audition, Adobe Premiere Pro, Excel, QlikView

Experience

Junior Strategic Intelligence Analyst

InterCement

2022-1 - Present · 4 yrs 8 mos

São Paulo, Brasil

- Preparation of management reports and submission to management; - Acting in the commercial planning of the company; - Support in strategic intelligence and revenue management; - Analysis of sales information and automation of reports.

Market Intelligence Analyst

Credimorar

2021-7 - 2021-12 · 6 mos

São Paulo, Brasil

- Crossing and processing of data between spreadsheets, creating pivot tables for creating management reports, automating data for optimization and better visualization; - Monitoring of sales campaign: assembly of kits (Excel spreadsheets with goals and transfers from consultants); - Sending kits by e-mail and assistance to the marketing area in sending e-mails to customers; - Preparation of dynamic material in Excel for consultants facilitating the macro visualization of sales performance and the breakdown by customer for decision making; - PowerPoint presentations to consultants; - Participation in meetings with the management to plan the actions of each area of the company with the board.

Quality and Information Analyst

Mtrix - Uma Empresa NIQ

2013-5 - 2021-7 · 8 yrs 3 mos

São Paulo, São Paulo, Brazil

- Daily consultations with KPIs in the area; - Analysis and treatment of data inconsistencies, analysis of sell in and sell out volume and fractionation of prices according to the unit of measurement; - Monitoring and segmentation of points of sale; - Conducting queries to information from databases through queries (SQL); - Quality control of BI data and sending to customers; - Participation in meetings and good relationship with distributors. - Main results and projects: assistance in Spanish, assistance in the creation of process manuals in the area, participation in the validation of the company's application (going to points of sale to check products), participation in an internal system update project: validation and tests performance.

Data Analyst

Mtrix - Uma Empresa NIQ

2012-5 - 2013-5 · 1 yr 1 mo

São Paulo, São Paulo, Brazil

- Responsible for the initial contact with the distributor's IT area to send instructions and layout for development of files in TXT format; - Conducting the analysis and validation of these files and requests for corrections to the distributor; - Completion of the process of integrating the distributor with the supplier so that the information is sent daily; - Participation in a project to approve merchandising action photos from the company Reckitt Benckiser.