Rafael Schettini Email & Phone Number

State Of São Paulo, Brazil

São Paulo, Brasil

• Led the data intelligence and media operations department, directly managing a team of 7 professionals. Constructed and implemented all processes in both areas, and structured key deliverables for clients.
• Ensured that all business and media data from campaigns was processed and presented as insights to clients through dashboards or reports.
• Integrated tools from the media/marketing ecosystem, including DSPs, DMPs, SSPs, and social media, to achieve a more synergistic and efficient approach.
• Engaged closely with clients to understand their genuine needs through the use of Retail Media, translating them into project specifications and aligning priorities with the company's business vision.
• Established robust and efficient processes and recruited and developed an excellent team that successfully kept pace with the company's growth, contributing to a revenue increase of 2x.

São Paulo, Brasil

• Pioneered the data department, creating and implementing all data engineering processes, including ETL processes for retail transaction data, ensuring it was ready to be leveraged in media campaigns.
• Developed client-facing dashboards to present campaign results and insights.
• Created a comprehensive campaign measurement methodology to evaluate performance and effectiveness.
• Recruited and selected two analysts to build and strengthen the data team.
• Played a key role in integrating data processes with overall business strategy, ensuring alignment and efficiency.

São Paulo, Brasil

• Led data engineering and web analytics teams to address client business challenges and optimize their marketing strategies.
• Architected and implemented Media Mix Modeling (MMM) solutions to optimize communication investments and increase sell-out for Seara.
• Developed attribution models to measure the effectiveness of offline campaigns and managed the construction of dashboards with business analysis.
• Transformed the organization towards a data-driven approach, delivering analytics solutions such as dashboards, algorithms, and in-depth analyses.

São Paulo E Região, Brasil

• Supervised the tracking and reporting of marketing campaigns to map the entire customer conversion journey within the digital ecosystem.
• Developed and maintained data pipelines to clean and process raw data from multiple sources, ensuring it was ready for detailed analysis.
• Conducted price elasticity analysis using data from Nielsen and Scanntech and tracked the impact of actions with digital influencers for Seara.
• Implemented processes to treat and clean retail transaction data, preparing it for use in media campaigns.

Rio De Janeiro

• Developed algorithms in Python to optimize product inventory in stores.
• Created business intelligence solutions using natural language and voice recognition to solve business problems.
• Built a multi-functional BI team to automate reports using Tableau and Power BI and led the Data Mart project with market data from Nielsen and GFK.

Rio De Janeiro

• Worked in commercial intelligence, generating insights and producing dashboards and analyses for the core business of the major retailer Lojas Americanas.
• Acted as a requirements analyst, gathering client needs and designing tools, collaborating with the product owner of the squad and utilizing agile methodology.

Rio De Janeiro

• Supported contract planning, implemented tools and methodologies, developed schedules and histograms, and prepared monthly progress reports for projects.

Rio De Janeiro

• Operated Oracle Primavera P6, performed administrative tasks, and supported contract planning and the implementation of tools and methodologies.

Rio De Janeiro

• Developed schedules and updated project progress using Primavera P6, monitored physical vs. financial progress, tracked critical project construction and supplies, and produced cost reports and forecasts.

Montreal E Região, Canadá

• Conducted scientific research on consumer behavior, analyzed questionnaires, and authored a scientific article based on the research findings.

Rio De Janeiro E Região, Brasil

• Organized logistics services and prepared routine reports.

Pós-Graduação, Inteligência De Negócios

Engenharia De Produção

Industrial Engineering

Visiting Student in Industrial Engineering, two academic semesters completed in December 2013.