Summary
Overview
Work History
Education
Skills
Websites
Languages
Timeline
Generic

Juan Alejandro Otalora Castro

Calgary

Summary

Business Analytics student with hands-on experience in data analysis, predictive modeling, and database management. Skilled in Python, R, SQL, and Power BI, with a strong ability to extract insights from complex datasets. Proven track record supporting engineering, operations, and retail teams through data-driven solutions and system optimization. Adept at communicating findings to technical and non-technical audiences and collaborating in dynamic, fast-paced environments. Eager to contribute analytical expertise and problem-solving skills to real-world business challenges.

Overview

5
5
years of professional experience

Work History

Engineering Doc Control

Tridon Communications
05.2025 - Current

As an Engineering Document Control specialist at Tridon Communications, contracted to support Suncor, I am responsible for maintaining and updating engineering data within the Hexagon software environment, integrated with an Oracle database system. My core responsibilities include reviewing engineering packages, verifying technical drawings, and ensuring that all relevant information is accurately reflected in the database.


Key tasks include:

  • Validating and updating asset data and engineering records by analyzing drawings, Scope of Work (SOW) documents, and field photos.
  • Ensuring consistency between submitted packages and internal procedures before uploading to the Hexagon system.
  • Collaborating with Hexagon support and engineering teams to identify and resolve data discrepancies.
  • Utilizing SQL queries to access, audit, and troubleshoot database entries, as well as generate error reports and support system maintenance.
  • Proposing and documenting system improvement suggestions and contributing to ongoing database optimization efforts.


This role has allowed me to combine my technical background with analytical skills to enhance data integrity and support the engineering and operations teams with reliable information systems.

Parts Sales Specialist

Northwest Acura
05.2023 - 09.2023

As a Parts Sales Specialist at Northwest Acura, I provided front-line support to customers and technicians. I contributed to both customer satisfaction and operational efficiency by combining strong product knowledge with attention to detail and high-quality service.


Key tasks included:

  • Assisting customers in selecting the correct replacement parts based on their vehicle needs and service requirements.
  • Completing all sales and service documentation for internal records and customer receipts.
  • Managing inventory organization by stocking and arranging parts according to company standards.
  • Inspecting incoming and outgoing parts for damage or defects, ensuring only quality parts were used or sold.
  • Addressing customer service issues promptly to uphold a high level of customer satisfaction.


This role developed my ability to work in a fast-paced, client-facing environment and strengthened my skills in automotive knowledge, inventory management, and customer service.

Summer Student Intern

Acden Facilities / CNRL
06.2022 - 08.2022

As a Summer Student Intern with Acden Facilities, contracted to support operations at Canadian Natural Resources Limited (CNRL), I worked alongside experienced personnel to assist with a variety of facility maintenance tasks.


Key tasks included:

  • Assisting full-time staff with both minor and major repair and maintenance work across the facility.
  • Performing general labor duties to support day-to-day operational needs.
  • Participating in scheduled safety meetings and contributing to a proactive safety culture.
  • Following all Occupational Health & Safety (OH&S) protocols and actively supporting the shop’s safety program.
  • Carrying out additional responsibilities aligned with delivering reliable and high-quality service to the client organization.


This experience strengthened my understanding of industrial maintenance, safety compliance, and teamwork in a high-standard work environment.

E-Commerce Personal Shopper

Save on Foods
08.2020 - 08.2021

As an E-commerce Personal Shopper at Save-On-Foods, I was responsible for accurately selecting, packaging, and preparing online grocery orders for customer pickup or delivery. The role demanded attention to detail, product quality assurance, and a customer-first mindset.


Key tasks included:

  • Carefully selecting and packaging fragile, non-fragile, and perishable items to ensure safe and intact delivery of customer orders.
  • Verifying product quality and order accuracy, prioritizing both freshness and customer satisfaction.
  • Completing internal documentation, logs, and paperwork to track order fulfillment and sales performance.
  • Gathering and incorporating customer feedback to identify areas for improvement in the e-commerce process and enhance service quality.

This position allowed me to develop strong time management skills, a keen eye for quality control, and a deep appreciation for customer-centric service.

Education

Bachelor of Commerce - Major: Business Analytics

University of Calgary
05-2025

Skills

  • Demonstrated ability to work both independently and collaboratively in team settings
  • Developed data-driven business solutions to support strategic decision-making
  • Maintained a strong sense of accountability, responsibility, and transparency across projects
  • Adapted quickly to new tools, workflows, and work environments
  • Proficient in SQL for querying, troubleshooting, and managing relational databases
  • Programming experience in Python and R for data analysis, automation, computational physics, and modeling
  • Skilled in Microsoft Excel and Microsoft Access
  • Proficient in Power BI, with a focus on storytelling through interactive dashboards
  • Built and deployed predictive models using statistical and machine learning techniques
  • Strong written and verbal communication skills for both technical and non-technical audiences

Languages

English
Native or Bilingual
Spanish
Native or Bilingual

Timeline

Engineering Doc Control

Tridon Communications
05.2025 - Current

Parts Sales Specialist

Northwest Acura
05.2023 - 09.2023

Summer Student Intern

Acden Facilities / CNRL
06.2022 - 08.2022

E-Commerce Personal Shopper

Save on Foods
08.2020 - 08.2021

Bachelor of Commerce - Major: Business Analytics

University of Calgary
Juan Alejandro Otalora Castro