o Segmented customers using RFM method enhancing communication impact through CRM.o Created a propension model rating the probability level representatives had to register for selling products of the sister company (Natura and Avon).o Dashboard creation for exploratory data analysis and report.o ETL process / data preparation.Tools: Sales Force Marketing Cloud, PySpark, AWS Redshift, Jupyter Notebook, Power BI.

o Consolidated and automated the CRM monitoring processes for three Markets in Latam Region, saving ~60h of monthly labor, using Python, Postgres and Sales Force Marketing Cloud.o Improved and automated CRM's lift calculation process for three Markets in Latam, reducing monthly laboro Built out dashboards for CRM monitoring and lift calculation, enabling journeys’ errors early correction, exploratory data analysis and insights.o Presented CRM' s campaign results with insights, adhoc analysis and recommendations.

Worked in the squads of Sales Force e Development:- Created and implemented squad's OKRs and KPIs.- Created Tableau dashboards.- Performed analysis to help squads undestanding existing features and prioritize new ones.Principais ferramentas: Google Analytics, Data Studio, Tableau, SQL.

o Developed BI solution for managing finance of a residential condo: P&L, budget, expenses and receivable control.o Created a web scraping project to collect online real state information using Python and Pandas (https://github.com/glaubercss/aldeia_realestate)

o Intelligence Hub is a small Brazilian Bureau to Support Decision – Market Intelligence and consultancy services.o Researched and understanded strategic and competitive outlook of the Auto insurance segments in Brazil for a german insurer (HDI), finding business opportunities.o Market research on regulatory trends and analysis on value proposition, product market fit and benchmarking.o Built a BI (dataviz) tool for exploratory data analysis of the entire industry, delivering data analysis on competition, industry trends, geography and P&L.

. Full development and management of two points of sale located at São Paulo-SP and Santana de Parnaíba-SP. . Branding, digital marketing, partnerships, finance, HR, production, P&D, operation management.. Elected the second most favorite gelato place at Alphaville and region ahead of Le Bottheghe di Leonardo and Freddo.https://www.vero.com.br/favoritos-2019-5-lugares-para-tomar-sorvete-em-alphaville-e-regiao/

o Hypera Pharma is Brazil’s largest pharmaceutical company in net sales. It’s present in all relevant segments of the retail pharmaceutical sector in Brazil, with leadership in several product categories.o Reported to the business support director, managing a team of 5 analysts in charge of market / business intelligence for the pharmaceutical division.o Developed a Business Intelligence and Analytics solutions and performed analysiss for Marketing, Trade Marketing, P&D and Commercial teams.o Product performance and market share analysis (PMB and MDTR), demand forecasting, distribution channel and point of sales analysis (Distribution Study), prescription market share (CloseUP Marketing and Targeting).

o Reported to the Strategic Planning and Marketing Director managing a team of 4 employees.o From Analyst to M.I. Manager in 7 years, structured the Strategic Planning, Market and Competitive Intelligence functions from scratch.o Developed strategic studies with Mini Harvard methodology for business and opportunity assessments, which resulted in entrance in Agents and Direct to Consumer businesses.o Created an group life insurance market model used identify potential locations for new branches and adequate established sales team according to market size. Used Map info, company data from Labor Ministry, Statistics Bureau and Insurance Regulator.o Performed ad-hoc analysis, competitor profiles, market monitoring, product benchmarking, primary research and M&A support.

. Reported to HR process manager.. Developed and automated the production of HR management reports and activities, such as Bonus calculation for over 140 stores and 14K employees, headcount and HR related expenses, employees historic performance for promotion appraisal and employees demography / turnover.. Was the internal leader for the development of intranet reports with payroll vendor.

. Reported to the Interchange Manager as a chargeback analyst at first and then got promoted to MIS for fraud prevention and detection.. Prepared report and analysis regarding fraud behavior.. Enriched credit / debit card transaction information by automating the confrontation of information provided by Mastercard with internal ones through connecting to mainframe and extracting.. Identified opportunity to improve the process of online adjustment for debit card invalid transactions, resulting on a very significant reduction of chargeback fees and customer complaints.. Developed a system to automate the process for the chargeback process registration, direct mail and input of establishments answer.. Received the Quality Excellence Award of Citigroup.