Summary
Overview
Work History
Education
Skills
Websites
Languages
Timeline
Generic

Juan Alejandro Otalora Castro

Calgary

Summary

Dedicated and driven Business Analytics student with a passion for leveraging data-driven insights to solve complex business problems. Proficient in data analysis, statistical modeling, and visualization, with hands-on experience using Python, RStudio, and SQL. Skilled at extracting meaningful insights from diverse datasets to drive informed decision-making. Seeking opportunities to apply my expertise, collaborate with industry professionals, and contribute to impactful solutions.

Overview

3
3
years of professional experience

Work History

Parts Sales Specialist

Northwest Acura
05.2023 - 09.2023
  • Assisted customers in finding appropriate parts promptly.
  • Completed sales and service documentation for customer and business records and provided receipts of purchase.
  • Organized parts storage and stocked inventory according to established guidelines.
  • Inspected parts for defects, removing damaged parts, and replacing with new ones.
  • Adhered to company guidelines for performance and compliance.
  • Identified specific replacement parts to meet customers' needs, making accurate suggestions with confidence.
  • Handled all customer service issues quickly to maintain high satisfaction levels.

Summer Student Intern

Acden Facilities / CNRL
06.2022 - 08.2022
  • Assist full-time personnel with minor and major repairs and maintenance as required.
  • Perform general laborious duties.
  • Attend safety meetings as scheduled.
  • Actively participate in the shop safety program and maintain adherence to OH&S guidelines.
  • Perform other duties that fulfill the mandate of providing excellent service to the client company.

E-Commerce Personal Shopper

Save on Foods
08.2020 - 08.2021
  • Carefully selected and packaged fragile, non-fragile, and perishable merchandise for pick-up
    to support safe and intact delivery of requested products.
  • Completed required paperwork, logs, and other documentation according to internal
    policies to accurately track sales and delivery metrics.
  • Verified quality and accuracy of picked items, prioritizing both customer order accuracy and
    product delivery excellence.
  • Solicited feedback from customers to discern service weaknesses and positively direct any
    future service interactions.

Education

Bachelor of Commerce - Major: Business Analytics, Minor: Physics

University of Calgary
Calgary, AB
05-2025

Skills

  • Effective at completing
    tasks individually and as
    part of a team
  • Great Communication
    Skills
  • Predictive modeling
  • Power BI - Storytelling with
    Data Experience
  • Proficient with Microsoft
    Excel and Microsoft Access
  • R programming experience
  • Python programming experience
  • SQL programming experience
  • Ability to adapt to new
    environments
  • Strong sense of
    Accountability,
    Responsibility, and
    Transparency
  • Business solutions development
  • Visual data representation

Languages

English
Spanish

Timeline

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, Minor: Physics

University of Calgary
Juan Alejandro Otalora Castro