Learn Data Skills
Diego Molina

Diego Molina

Business Intelligence Analyst

Bapcor | Australia

Technologies

My Portfolio Highlights

My New Course

Introduction to Python

My New Course

Introduction to Python

Data sensei, guiding others on the path of analytical enlightenment.

My Work

Take a look at my latest work.

course

Introduction to Power BI

course

Introduction to Python

course

Intermediate Python

course

Introduction to Power BI

DataCamp Course Completion

Take a look at all the courses I’ve completed on DataCamp.

Courses

Introduction to Python
Introduction to SQL
Introduction to Power BI
Intermediate Python

My Work Experience

Where I've interned and worked during my career.

Bapcor Limited | Aug 2025 - Present

Inventory Analyst

Act as the strategic liaison between Bapcor Logistics Services and the Specialist Networks team to optimize demand planning and inventory visibility. Responsible for designing and delivering centralized reporting solutions powered by Bapcor’s enterprise data lake, ensuring accurate, timely, and actionable insights. By streamlining processes and leveraging advanced analytics, I support improved operational decision‑making, stronger collaboration between teams, and enhanced supply chain performance across the network.
Show More

Bapcor Limited | Jan 2025 - Aug 2025

Business Intelligence Analyst

Key Achievements & Responsibilities - Azure Synapse & Power BI Solutions: Model advanced data models on Azure SQL Synapse, powering executive-ready Power BI dashboards and reports for business-wide analytics. - Agile Development: Collaborated in Agile sprints, managing code and documentation via Azure DevOps Git repositories. - Data Integration & Insights: Unified data from multiple business units and ERPs for supply chain and inventory visibility; translated business formulas to SQL for real-time cost analysis. - Category Management: Consolidated and cleansed product category data, supporting unified procurement and analytics. - Power BI Enablement: Trained business users on self-service analytics with tailored dashboards. - Strategic Support: Delivered ad hoc analyses and maintained data models for accurate, timely reporting. Impact: Enabled data-driven decisions and process improvements, empowering Bapcor teams to leverage insights for growth and efficiency. Skills: Business Intelligence · Azure Synapse · Power BI · Agile · Azure DevOps · SQL · Data Integration · Supply Chain Analytics · Category Management

Bapcor Limited | Mar 2022 - Dec 2024

Business Analyst | Data & Insights Specialist

Key Achievements & Responsibilities: Data-Driven Leadership: Acted as the primary liaison for Specialist Wholesale in major group-wide projects, including category management, procurement, and Data Lake consolidation, empowering commercial and strategy teams with actionable insights. Data Lake Implementation & UAT: Led User Acceptance Testing (UAT) for the Data Lake, ensuring accuracy by reconciling calculations with source ERP data. Designed Power BI dashboards as proofs of concept, transitioning validated models into the Data Lake environment. Advanced Analytics & Modeling: Developed DAX-based Price, Mix & Volume (PMV) models to decompose period-on-period variance, enabling leadership to track key revenue, COGS, and gross profit drivers. Structured customer, product, and inventory data from 10+ ERP systems into a centralized Microsoft Fabric semantic model, providing critical insights for decision-making. Category Management Enhancements: Consolidated a unified product category database using machine learning and third-party API integrations, improving procurement efficiency and decision- making. Led data cleansing and maintenance of category hierarchies, ensuring alignment with business needs. Power BI Enablement: Initiated and led the “Lunch and Learn” program to train users on new Power BI dashboards, showcasing features and empowering teams with data-driven capabilities. Delivered executive-ready dashboards and models for category management, procurement, and commercial teams. Strategic Support & Consulting: Supported ad hoc data requests and consultancy projects, streamlining workflows for rebates, category management, and commercial teams. Maintained data models with daily, weekly, and monthly updates to ensure reporting accuracy. Impact: By combining advanced analytics, user engagement, and cross-functional collaboration, I’ve driven data-driven decisions, streamlined processes, and empowered teams to leverage insights for strategic growth.

Institute of Data | Feb 2022 - Jan 2023

Data Science Assistant Instructor (Part Time)

Collaborated with the lead lecturer to plan and implement the program curriculum. Delivered coaching sessions in Python programming, Statistics, Machine Learning, and Artificial Intelligence. Developed course materials and resources tailored to the cohort's needs. Provided individualized feedback on student progress and project development. Mentored students on storytelling, data visualization, and essential soft skills for a career in data science. Impact: Contributed to the successful delivery of a comprehensive data science program, equipping students with the technical and interpersonal skills required to excel in the industry.

Ozwide Tools | Jan 2020 - Mar 2022

Business Analyst

Role Overview: Evaluated company processes, identified inefficiencies, and proposed strategic and structural changes to enhance profitability and operational efficiency. Key Projects & Achievements: Pricing Process Optimization: Redesigned pricing and landing cost calculations using an Excel Macros- based calculator, ensuring gross profit targets were met to achieve annual revenue goals. Staff Performance Metrics: Developed a Python-based KPI tool to analyze staff workloads and turnover. This tool enabled equitable workload distribution and calculated monthly sales and performance bonuses based on individual metrics. Revenue Growth Projects: Conducted in-depth analyses for business optimization, including marketing, social media, and email campaigns, driving a 10% annual revenue increase. Stock Forecasting Model: Designed a Python-based stock forecasting tool, reducing freight costs by 20% annually. The model ensured optimal stock levels while minimizing logistics costs, directly enhancing gross profit margins. Customer Support: Provided technical support tailored to customer needs, specializing in timing, transmission, injection, and suspension tools. Leveraged expertise in EPC manuals and mechanical systems for a wide range of Australian vehicle makes. Side Projects: 3D Modeling for Manufacturing: Designed and modeled 3D parts in SolidWorks to improve tools tailored to the Australian vehicle market, supporting overseas manufacturers. Content Creation: Edited and produced videos for Ozwide Tools' YouTube channel to enhance brand visibility and customer engagement.

Suzuki Australia Pty Limited | Nov 2018 - Dec 2019

Parts interpreter

Role Overview: Managed and resolved motorcycle and vehicle parts inquiries by leveraging technical automotive knowledge and utilizing parts manuals and Electronic Parts Catalogues (EPC). Delivered excellent service and support to Suzuki dealers across Australia. Key Responsibilities: Provided expert advice on parts interpretation, stock availability, and delivery ETAs. Addressed and resolved backorder cancellations and general supply chain- related queries. Supported inquiries through multiple channels, including email, web portals, and inbound phone calls, ensuring a seamless experience for dealers. Maintained strong, professional relationships with Suzuki dealers nationwide, fostering trust and collaboration.

AGLOMA Germany LTD | Oct 2018 - Nov 2018

English-Spanish Translator

Role Overview: Translated guidebooks and documents from English to Spanish to support KIA Motors' global coaching program, focused on the automotive sector, particularly service managers. Key Responsibilities: Delivered accurate and contextually relevant translations tailored to the aftersales business. Ensured content was clear, easily understandable, and included familiar terminology for the target audience. Contributed to the success of a training program designed to enhance the capabilities of service managers worldwide.

Central motor ltda | Aug 2017 - Mar 2018

Service Manager

Develop FORD brand after-sales business to make it more profitable in all its channels (maintenance, collision, spare parts), optimize the operation through strategies that increase productivity and turnover, guarantee a quality service that impacts on customer satisfaction, lead and execute investment projects within the sales channels, lead and supervise the work team in the fulfillment of objectives set by the brand and investors. ACHIEVEMENTS - Certification of after-sales area in management and operation processes under the FORD total service standard. - Type A dealer qualification, due to goal achievement of customer satisfaction and management of recalls. - The opening of exclusive FORD collision workshop in Bucaramanga city. - Management KPI design for each member of the team who measures the performance of their tasks. - 8th place in T17 FORD contest, which awards the best technician in the country.

MetroKIA | Jul 2016 - Jul 2017

Field Manager

Advise 13 KIA dealers on the main business areas of the after-sales departments to optimize each of these through strategies related to customer retention and loyalty, guaranteeing a sustainable and profitable operation over time. - Consolidate and analyze the network service database to forecast vehicle flow into the workshops seeking to predict revenue and business opportunities in the dealership network involving spare parts, service, and sales. - Report KIA Motors Company recurring vehicle failures, based on warranty statistics occurring in the country, implement and supervise KIA’s service and customer retention programs, training programs and KPIs, and recall bulletins in the network. - Act as the key communication person between the dealership and KIA Motors Company executing and informing about corporative programs to be implemented in Colombia. - Design and report KPIs for customer retention, loyalty, and sales performance in line with KIA Motors guidelines. - Develop, update, and implement the warranty labour rate scheme for dealership rebates based on customer, purchase, and sales performance, KPI implemented in 2017.

Exito Group | Jun 2015 - Jan 2016

Maintenance Supervisor

Control the maintenance budget expense, guarantee the availability of equipment within the operation of 8 warehouses in Santander department, order management through SAP, hiring and supervising contractors in work carried out in the warehouses. ACHIEVEMENTS - General painting work delivery Éxito Oriental. - Delivery of modernization of Éxito Cañaveral facilities - Delivery of construction work Éxito Paseo del Puente, and start-up of refrigeration equipment.

García Vega | Oct 2014 - Jun 2015

Production Coordinator

Manage and lead metal framework, scaffold and formwork production of a family company through the use of computer-aided design tools as SOLIDWORKS and AUTOCAD to produce cutting, assembling and welding plans based on international measure normativity. Manage production schedules via Excel sheets to control production times, processes and raw materials usage efficiency avoiding waste. ACHIEVEMENTS -Lead the production of an 8 Ton metal reinforcement frame for San Pedro school building -Lead the production of a 4 Ton metal pedestrians bridge for Floridablanca soccer stadium -Lead the production of at least 30 Ton of metal scaffold and formwork -Design and implement schedule program Excel sheet based in VISUAL BASIC -Design and implement scaffold quotation Excel sheet based in VISUAL BASIC

AftechSales | Oct 2013 - Oct 2014

Regional Operations Coordinator

Field implementations of ClearMechanic mobile application in after-sales service workshops, personnel training, development of a virtual tool to organize the collected information by ClearMechanic in a management indicators report, technical support to customers and distributors.

Campesa S.A. | Oct 2013 - Apr 2014

Internship

Evaluate the implementation impact of ClearMechanic in finance, management processes, customer service and human resources areas into Campesa SA dealers, lead the app implementation in four workshops of Campesa SA, train technicians , guarantee analysts, service advisors and workshop managers in the usage of the application, generate management reports describing the progress of the implementation in the named areas.

ING Y MAQUINAS | Jan 2013 - Jun 2013

Internship

Design and run maintenance plans for whole the devices and machines used in the company, design and print a maintenance book with schedule program.

Universidad Pontificia Bolivariana | Jan 2012 - Jun 2013

CAD-CAE Lab Tutor

Provide support to the teacher in the development of computer-aided machine drawing (CAD) subject, solving doubts to students belonging to this course, related to SOLID EDGE and SOLID WORKS software enquires.

My Education

Take a look at my formal education

Data Science & AI, Data ScienceInstitute of Data | 2021
Bachelor of Engineering (B.Eng.), Mechanical engineeringUniversidad Pontificia Bolivariana | 2014

About Me

Diego Molina

I build the layer between messy operational systems and confident decision-making: a single, governed data model with consistent definitions and refresh you can trust.

Powered by

  • Work
  • Courses
  • Experience
  • Education
  • About Me
  • Create Your Data Portfolio for Free