Felipe Mendes

Experience

• 

  Johnson & Johnson Consumer Health

  Jan 2014 - May 2015

  Finance Intern

  Responsible for supporting the regional marketing team as the Financial partner evaluating new product launches in LatinAmerica focused on the pharmaceutical OTC market (over-the-counter). Also consolidated Latin America's financial results,development of reports for the global structure, commenting the quarterly variations for the investor relations reportMain Achievements:• Development of the new Business Contract for the launch of new LatAm products. Consolidation of regional information in asingle spreadsheet and preparation of the analysis template. Resulting in a clearer process and with fewer errors of manualconsolidation;• Participation of a cycle in the payments SOX team; Show less

• 

  Enjoei

  Jun 2015 - Jan 2017

  Business Intelligence Analyst

  Responsible for supporting the company BI Datawarehouse based on Postgresql database. It was sourced by Pentaho’s ETL andwith data visualization on Tableau Dashboards. Responsible for creating the data analysis for multiple stakeholders such as theMarketing, Curation, Media, CRM and Promotion Team.Main Achievements:• Google AdWords – Restructure and automation of Enjoei’s account via scripts that integrate the business rules and use thereal data of the operation. 140% increase in total investment with an improvement of 111% in YoY ROI• Preparation of forecasts for the areas of Curatorship and Customer Service, guiding the improvement of the organization ofteam scales, adaptation of the headcount and more precise control of the ticket evaluation and response backlog• Deliver specific and timely insight to the marketing team, ensuring better promotions and media actions. Show less

• 

  Johnson & Johnson Consumer Health

  Jan 2017 - May 2021

  Lead the Food Channel as their main finance partner. Responsible for increasing the profitability of Key Account and Cash & Carryprofitability by reducing the on and off invoice trade investments while enhancing the channel portfolio on high growth customers.Main responsibilities were to increase profit by the most efficient trade funds expenditure with the Trade-Marketing team.Main Achievements:• Increase in channel profitability despite pandemics circumstances• Implemented tech tools using Alteryx and Tableau and replacing Excel files to increase business analysis and data consistency.• New rebates policies and processes implemented driving accountability, more visibility and less compliance issues. Show less Led the System Area for the Consumer Health Care sector for Latin America. Acted as the main contact for both and IT team on data related topics, enhancing the financial planning processes. My main responsibilities were support end-users on the planning tool (TM1) and increase data availability and consistency through the region. With a Finance Assistant reporting to me.Main Achievements:• Development of cross-sector companies of global tools such as Compensation and Benefits• Increase in Data Quality and visibility of the systems complexities to the leadership team.• Development of automation and visualization tools with Alteryx and Tableau such as PVM Analysis Show less In charge of the Financial Planning Tool (TM1) and acting as the go-to person for technology topics. Responsible for integratingthe IT and Finance team on the business requests for a more consistent and agile data flow from the SAP/BI system to the FDW.LATAM responsible for the reporting phase with BRAVO related technologies.Main Achievements:• Increased visibility of the systems landscape within the Financial Teams• Creation of the SG&A Tool with direct contact with the IT Team and the Agile Methodology• Increased user experience for the TM1 with the creation of new functionalities from the users feedback.• Successful implementation of BRAVO Reporting Tool for planning. Show less

  • Key Account and Cash & Carry Lead

    Oct 2019 - May 2021

  • System Lead

    Oct 2018 - Sept 2019

  • Financial Analyst

    Jan 2017 - Sept 2018
• 

  Booklub

  Jun 2021 - Jun 2022

  Co-Founder

  Co-founder and CEO of Booklub, a group of Book Clubs with three tutors (Business, Spirituality and Law).Responsible for the operation and brand management with 3 direct subordinates.Main Achievements:• Created and manage the company from 5 to 250 monthly subscribers.• Partner up with three experts to develop their own book clubs.• NPS of 70 and churn below 5%

• 

  Hypera

  Aug 2022 - Aug 2023

  E-Commerce BI Lead

  Structured and led the BI area for the E-Commerce team at Hypera Group, leveraging tools such as Power BI, Pyspark, and Pandas to deliver insights critical to the success of the business.Created a customer clusterization strategy with the CRM team that allowed the communications to be more efficient and improve customer retention.Developed an inventory rationale that significantly reduced overstock of slow-moving items and minimized the risk of out-of-stock situations for our best-selling products. Show less

• 

  Johnson & Johnson

  Sept 2023 - now

  Finance Data Analytics Coordinator