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
Argentina12.2020
Bachelor's Degree - Business Administration and Management, General
Universidad de Morón (Oficial)
Argentina01.2016
Skills
- Business analytics
- Data visualization
- Reporting and analysis
- Strategic Insights Analysis
- ETL Processes
- Tableau
- Power BI
- Excel
- SQL (MySQL, Dbeaver, SQL Server)
Websites
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)
Similar Profiles
ERWIN VERSOZAERWIN VERSOZA
Country Manager at Rhino Rack PhilippinesCountry Manager at Rhino Rack Philippines
James ButlerJames Butler
ACT Sales Manager at Rhino-Rack AustraliaACT Sales Manager at Rhino-Rack Australia
Courtney DrageCourtney Drage
Product Coordinator at Rhino Africa SafarisProduct Coordinator at Rhino Africa Safaris
Tenzin DolmaTenzin Dolma
Emergency Department at Northern Beaches HospitalEmergency Department at Northern Beaches Hospital
Michaela FarmerMichaela Farmer
Yacht Stewardess at CHAPMAN,SASSY, AFLIE AND CO, TERRAFERMA,AHOY CLUBYacht Stewardess at CHAPMAN,SASSY, AFLIE AND CO, TERRAFERMA,AHOY CLUB