Yousuf Farooq

Experience

• 

  Candler Schiffahrt GmbH

  Jun 2019 - Dec 2019

  • Extracted the operational data of vessels to calculate the most frequent ports at which vessels re-fueled and used Pivot Tables to cluster the data in to regions. • Used Data Modelling in excel to develop a potential supplier database for each region, compiling data such as products offered, product prices, and contact details. • Prepared and conducted an online survey with over 70 suppliers in 20 ports to access availability, product specifications, and compliant fuel costs. • Met with the suppliers to discuss new products and their pricing. • Independently operated all operations of a vessel, including planning and discharging operations in a timely manner. • Increased accuracy of ETA estimates by planning routes using Netpas. • Communicated with crew to prepare storage plans using AutoCAD. Show less

  • Intern in Operations Department

    Oct 2019 - Dec 2019

  • Intern in Technical Department

    Jun 2019 - Sept 2019
• 

  Candler Schiffahrt GmbH

  Feb 2020 - Feb 2021

  Data Analyst

  • Collected 8 years of vessel historical data and implemented statistical techniques with Python to optimize fuel consumption.• Built dashboards in Power BI that analyze supplier data to assess optimum re-fueling ports.• Used SQL to combine engine data, part manufacturing data and location data, to calculate KPIs. • Conducted a diagnostic analysis of vessel CO2 emissions using Power BI.

• 

  NICKIS

  Feb 2021 - May 2022

  • Used Matillion ELT, AWS Technologies, and Python to extract and transform data from different marketing platforms. • Built a marketing attribution model, using SQL and Python, to analyze the contribution of online and offline channels.• Created dashboards in Qlik that monitor marketing KPIs to steer marketing decisions.• Developed complex SQL models using dbt to personalize marketing and generate sale leads on Zendesk (CRM Tool).• Analyzing user website behavior with Google Analytics and presenting the insights via visualizations, funnels and path explorations. • Investigating and visualizing bottlenecks in production process using advanced SQL and Qlik to decrease the lead time. • Formulated the business logic for pricing and discounting using Python. Show less

  • Business Intelligence Manager

    May 2021 - May 2022

  • Business Development

    Feb 2021 - Apr 2021
• 

  Audibene

  May 2022 - now

  • Taking ownership of marketing spend and strategically allocating budgets across marketing channels to maximize ROI. • Defining clear targets for marketing channels and collaborating with channel managers to drive the projects in order to meet these targets. • Designing and implementing KPIs to monitor the entire marketing funnel and ensure high-quality customer acquisition. • Collaborating closely with cross-functional teams including sales, MarTech, and product to steer marketing and implement data-informed decisions. Show less

  • Marketing Planning and Steering

    Jun 2023 - now

  • Marketing Data Analyst

    May 2022 - Jun 2023