Summary
Overview
Work History
Education
Skills
Websites
Certification
Languages
Personal Information
Languages
Timeline
Generic

Pedro Durand

Dee Why,Australia

Summary

I am a skilled analyst with over a decade of experience collaborating with companies across diverse industries, including streaming, entertainment, fashion, sports, and retail. During this time, I have actively participated in, and led, various projects. I earned my certification as a data analyst from DIGITAL HOUSE, one of the largest technical schools in Latin America. Additionally, I have completed courses in key tools such as Tableau, Power BI, and SQL, applying this knowledge in my roles at The Walt Disney Company, Stryker, and Rhino Rack. Currently, I work as a Business Intelligence Analyst at Rhino Rack, where I apply Power BI and Excel to drive data-driven decision-making, and optimize business processes. I am passionate about transforming data into valuable insights that drive business success and create a competitive edge. In today's data-driven world, I believe that leveraging data effectively is crucial for businesses to thrive and innovate. I'm committed to helping organizations unlock their data's full potential and stay ahead of the curve. Thank you for taking the time to learn more about me.

Overview

13
13
years of professional experience
1
1
Certification

Work History

Business Intelligence Analyst

Rhino-Rack
Sídney, Australia
04.2024 - Current
  • Primary Business Analyst for the Operations team, while also contributing to high-impact projects across Finance, Marketing, and Sales by delivering actionable insights through cross-functional data analysis and strategic collaboration.
  • Acted as the main point of contact with a consulting company, executing ETL processes for a supply chain study, ensuring data accuracy and streamlined operations.
  • Led a comprehensive network analysis using Microsoft Excel, identifying key efficiency drivers across warehouses and brands; delivered actionable insights to optimize operational performance and resource allocation.
  • Acted as the lead data analyst partnering with the Finance team to develop the company's first Global Pricebook, enabling standardized pricing and supporting competitive positioning across international markets.
  • Acted as project manager for multiple cross-functional initiatives, leveraging Smartsheet to build clear, structured project plans that ensured deadlines were met and stakeholder expectations were aligned.
  • Developed automated dashboards in spreadsheets using Power Query for ETL, facilitating real-time data analysis and reporting.
  • Created a cost model in collaboration with the finance team to validate the financial viability of different projects.
  • Conducted comprehensive freight analysis, identifying the most efficient methods to save costs during a brand integration process.
  • Created a monthly dashboard for the operations team, enabling informed decision-making during regular monthly meetings.
  • Designed an Operations infographic, providing critical insights to company directors.

Data Analyst

Stryker
, Australia
07.2023 - 04.2024
  • Led a collaborative initiative for the marketing team to develop an interactive Power BI dashboard, transforming the analysis of extensive medical data from the national registry, which was previously manually processed every six months.
  • Took a leading role in the ETL process (using SQL and Power Query) and played a key role in supporting the finance team by creating dynamic and insightful dashboards.
  • Contributed significantly to data analysis involving sales, market shares, products, and competitors, instrumental in the creation of the 2024 Annual Marketing Plan.
  • Implemented and managed manual allocation procedures for diverse product portfolios, ensuring adherence to established processes. Leveraged data and generated reports to optimize inventory allocation to designated customers.
  • Maintained effective communication with stakeholders.
  • Addressed inquiries and provided assistance to Territory Managers (TM) and Market Planning Specialists (MPS) regarding manual allocation processes.
  • Demonstrated expertise in resolving issues and ensuring seamless workflow.
  • Led a comprehensive project to migrate historical data and reports to Power BI, enhancing data visualization and analytical capabilities across the organization.
  • Executed Extract, Transform, Load (ETL) processes using Excel and Power BI for various projects, ensuring data accuracy and integrity.
  • Engaged in proactive communication with key stakeholders to ensure project timelines and budgetary constraints were met, fostering a collaborative and efficient work environment.
  • Conducted in-depth data and reporting analysis to support fundamental projects, contributing valuable insights to enhance overall business strategies.

Senior Financial Analyst

The Walt Disney Company
, Argentina
04.2022 - 01.2023
  • I directed a data-driven initiative leveraging Tableau to optimize internal operations. Through meticulous data analysis, I identified and addressed common errors and complaints within the purchasing process. This strategic approach resulted in a remarkable 30% reduction in inquiries from internal buyers.
  • Coordinated Master Data LATAM (Vendors) team, optimizing task allocation for streamlined operations.
  • Applied Tableau and SQL expertise to redefine and monitor finance KPIs, conducting in-depth analysis for purchase orders and vendor data.
  • Write SQL queries to extract data from various sources.
  • Conducted data analysis to identify operational improvements and addressed routine business queries with analytical insights.
  • Managed project follow-up for business unit integration, ensuring data-driven and smooth transitions.
  • Developed and maintained Tableau dashboards for visualizing and communicating key financial insights.
  • Collaborated with cross-functional teams (finance, payments, tax, and invoice) to ensure data accuracy and prevent payment issues.
  • Conducted forecasting and budgeting analysis, providing valuable insights for strategic decision-making.
  • Compiled and presented quarterly reports on supplier registrations and approved purchase orders, leveraging analytics for regional insights.
  • Created, managed, and presented various data and analytics reports to inform strategic decision-making.

Financial Analyst

The Walt Disney Company
, Argentina
01.2021 - 04.2022
  • Analyzed and approved purchase orders in adherence to company policies, specializing in Brazil and the United States.
  • Provided comprehensive support to various departments, ensuring accurate and pertinent information on purchase order forms, resulting in significant reductions in approval times.
  • Generated quarterly reports, offering insights into the landscape of created purchase orders, contributing to strategic decision-making.
  • Implemented meticulous expense allocation procedures to guarantee precise posting to the correct ledger accounts, ensuring financial accuracy.
  • Developed and conducted internal training programs tailored for casual buyers, enhancing understanding and compliance with procurement processes.
  • Designed and constructed dashboards to visually represent key business Key Performance Indicators (KPIs), facilitating data-driven decision-making.
  • Employed Tableau to craft and implement reports and dashboards, elevating data visualization and analytical capabilities for informed business insights.

Data Analyst

CENIDOR
, Argentina
07.2019 - 01.2021
  • Analyzed sales data using Power BI, SQL, and spreadsheets to drive cost-saving initiatives.
  • Developed a user-friendly dashboard to identify top and underperforming clothing items across franchises.
  • Achieved a 17% reduction in transportation costs by aligning inventory with actual store sales.

Front Desk Receptionist

Peppers Airlie Beach Australia
Airlie Beach, Australia
10.2018 - 03.2019

Front Desk Receptionist

DUCK INN
Mount Buller, Australia
05.2018 - 10.2018

Accounts Payable Analyst

Buenos Aires Golf Club
, Argentina
09.2015 - 05.2018

Accounts Payable Analyst

Refrigeracion MB SRL
, Argentina
04.2012 - 06.2016

Education

SQL - Data Modeling/Warehousing and Database Administration

Coderhouse
10.2022

Tableau - Data Processing and Data Processing Technology/Technician

Coderhouse
07.2022

The compete SQL bootcamp 2022: go from zero to hero - Data Modeling/Warehousing and Database Administration

Udemy
06.2022

Data Analyst - Data Processing and Data Processing Technology/Technician

Digital House Argentina
Argentina
12.2020

Bachelor's Degree - Business Administration and Management, General

Universidad de Morón (Oficial)
Argentina
01.2016

Skills

  • Business analytics
  • Data visualization
  • Reporting and analysis
  • Strategic Insights Analysis
  • ETL Processes
  • Tableau
  • Power BI
  • Excel
  • SQL (MySQL, Dbeaver, SQL Server)

Certification

  • Advance Excel, Macros, Power Pivot and Power BI
  • Corporate Finance Analyst
  • Data analysis with SQL
  • Economy and tax planning
  • Business IGCSE

Languages

  • Portuguese, Limited Working
  • Spanish, Native or Bilingual
  • English, Full Professional

Personal Information

Title: Data Analyst | Business intelligence | SQL | Tableau & Power BI

Languages

English
Full Professional
Portuguese
Limited
Spanish
Native/ Bilingual

Timeline

Business Intelligence Analyst

Rhino-Rack
04.2024 - Current

Data Analyst

Stryker
07.2023 - 04.2024

Senior Financial Analyst

The Walt Disney Company
04.2022 - 01.2023

Financial Analyst

The Walt Disney Company
01.2021 - 04.2022

Data Analyst

CENIDOR
07.2019 - 01.2021

Front Desk Receptionist

Peppers Airlie Beach Australia
10.2018 - 03.2019

Front Desk Receptionist

DUCK INN
05.2018 - 10.2018

Accounts Payable Analyst

Buenos Aires Golf Club
09.2015 - 05.2018

Accounts Payable Analyst

Refrigeracion MB SRL
04.2012 - 06.2016

SQL - Data Modeling/Warehousing and Database Administration

Coderhouse

Tableau - Data Processing and Data Processing Technology/Technician

Coderhouse

The compete SQL bootcamp 2022: go from zero to hero - Data Modeling/Warehousing and Database Administration

Udemy

Data Analyst - Data Processing and Data Processing Technology/Technician

Digital House Argentina

Bachelor's Degree - Business Administration and Management, General

Universidad de Morón (Oficial)
Pedro Durand