SANTIAGO DÍAZ MEJÍA
Sydney,NSW
Summary
Versatile and results-driven engineer administrator with expertise in data analytics, financial modeling, and process optimization. Experienced in gathering, analyzing, and interpreting complex datasets to support strategic decision-making. Proficient in advanced Excel, SQL, and Power BI for data visualization and reporting. Strong background in financial analysis, credit product evaluation, and export logistics, with a proven ability to enhance operational efficiency. Skilled in coordinating cross-functional teams and ensuring compliance with industry regulations. Adept at identifying patterns, forecasting trends, and implementing data-driven solutions. Committed to continuous learning and adapting to evolving business needs, bringing a proactive approach to problem-solving and innovation in dynamic work environments.
Overview
4
4
years of professional experience
Work History
Air Conditioning
ChillCo Air Conditioning
Sydney, Australia
06.2023 - Current
- Communicated with suppliers to negotiate pricing, delivery schedules, and stock availability.
- Conducted routine inspections to identify system malfunctions and troubleshoot potential issues before escalation.
- Managed procurement of materials and spare parts, ensuring timely availability to support ongoing projects.
- Forecasted weekly material requirements based on project schedules and past consumption patterns.
- Assisted in installing, maintaining, and repairing residential and commercial HVAC systems, ensuring optimal functionality and efficiency
- Transported tools, equipment, and materials to work sites, ensuring safe handling, and proper storage.
- Worked closely with senior technicians to install ductwork, compressors, and refrigerant lines for various air-conditioning systems.
Finance Data Analyst
Connor Investment
Medellín, Colombia
10.2022 - 02.2023
- Collected, cleaned, and analyzed financial data from multiple sources to identify trends, discrepancies, and opportunities for improvement
- Created detailed reports and visual presentations using Power BI to communicate financial insights to key stakeholders
- Automated data extraction and analysis processes using SQL and Excel to improve efficiency and accuracy
- Developed and monitored dashboards tracking the evolution of credit product usage and compliance with budget targets
- Analyzed key financial indicators to assess credit placement, usage patterns, and overall product performance
- Assisted in forecasting financial trends by evaluating historical data and market behaviors
Export Analyst LATAM
Sofasa - Renault
Envigado, Colombia
07.2022 - 10.2022
- Coordinated demand reception and consolidation for exporting parts from local suppliers to Renault Group assembly plants
- Analyzed and extracted symmetrical demand data to optimize inventory and supply chain processes
- Placed consolidated orders with local suppliers, ensuring timely procurement and delivery scheduling
- Coordinated delivery appointments with suppliers to align with Renault's logistics protocol and service rate requirements
- Linked purchase orders to monitor delivery compliance and ensure adherence to predefined logistics conditions
- Processed export invoices using SAP while verifying documentation accuracy and compliance with international trade regulations
Credit Product Data Analyst
Flamingo Stores (Retail)
Medellín, Colombia
07.2021 - 07.2022
- Conducted data analysis and modeling to assess financial performance and customer credit behavior
- Monitored and analyzed the effectiveness of commercial campaigns to optimize marketing strategies and credit offerings
- Evaluated credit application results to identify trends and improve approval and risk management processes
- Analyzed customer behavior patterns related to credit product usage to enhance financial forecasting and business decisions
- Developed Power BI dashboards to track credit product evolution and compliance with budgetary targets
- Forecasted credit product usage to support marketing strategies, risk assessment, and financial planning initiatives
Credit Origination Intern
Flamingo Stores (Retail)
Medellín, Colombia
01.2021 - 07.2021
- Monitored and analyzed daily credit sales reports to evaluate business performance and customer engagement
- Tracked the flow of credit applications, identifying bottlenecks and areas for process improvement
- Generated reports on credit placement, customer balances, and financial risk assessments for management review
- Assisted in optimizing credit application processes to improve efficiency and reduce customer wait times
- Created indicators to enhance application tracking and ensure better traceability of customer financial data
- Supported the financial team in analyzing credit trends and preparing strategic recommendations for senior management
Education
Foundations of Business Intelligence -
Google
Online03.2025
Certificate IV in IT -
Australian College of Business Intelligence
Sydney09.2024
Upper Intermediate English Course -
National College of Vocational Education
Sydney02.2024
Bachelor's Degree - Administrative Engineering
Universidad Pontificia Bolivariana
Medellín10.2021
Corporate Finance Course -
Universidad Pontificia Bolivariana
Medellín05.2021
Skills
- Data Analytics
- Statistical analysis
- Financial Modeling
- Advanced Excel
- SQL
- Power BI
- Team Collaboration
- Business Vision
- Pattern Analysis
- Trend Analysis
- Decision-Making
- Data Insights
- IBM Modeler
References
Will be available upon request.
Languages
- English
- Spanish
Timeline
Air Conditioning
ChillCo Air Conditioning
06.2023 - Current
Finance Data Analyst
Connor Investment
10.2022 - 02.2023
Export Analyst LATAM
Sofasa - Renault
07.2022 - 10.2022
Credit Product Data Analyst
Flamingo Stores (Retail)
07.2021 - 07.2022
Credit Origination Intern
Flamingo Stores (Retail)
01.2021 - 07.2021
Foundations of Business Intelligence -
Google
Certificate IV in IT -
Australian College of Business Intelligence
Upper Intermediate English Course -
National College of Vocational Education
Bachelor's Degree - Administrative Engineering
Universidad Pontificia Bolivariana
Corporate Finance Course -
Universidad Pontificia Bolivariana
Similar Profiles
MITCHELL MAERZMITCHELL MAERZ
HVAC Technician at Quality Air/Fintastic Air ConditioningHVAC Technician at Quality Air/Fintastic Air Conditioning
Avonpreet SinghAvonpreet Singh
HVAC Installer at Perfect Air Heating & Air ConditioningHVAC Installer at Perfect Air Heating & Air Conditioning
Eric LongtonEric Longton
Heating and Air Conditioning Service Technician at Air Doctor Air Conditioning & HeatingHeating and Air Conditioning Service Technician at Air Doctor Air Conditioning & Heating