SQL
JUAN PACHON
Business Analyst
Mississauga,Ontario
Summary
Business Analyst and Process Consultant with over four years of experience in digital transformation, process optimization, and data analysis in sectors of supply chain, insurance, and e-commerce. Expert in designing supply chain solutions by applying facility design concepts and analytical leadership to meet customer needs. Advanced skills in SQL, Python, R, Power BI, and agile methodologies. Committed to continuous improvement and delivering sustainable value, working collaboratively with cross-functional teams to ensure project success. Seasoned collaborator experienced in meeting needs, improving processes and exceeding requirements in team environments. Diligent worker with strong communication and task prioritization skills.
Overview
3
3
years of professional experience
Work History
Instructor, Project Manager
Los Andes University
1 2022 - 12.2023
- Developed and delivered courses on decision support systems to over 120 students per semester.
- Developed a predictive model for a construction machinery company, reducing late deliveries by 7% and improving forecast accuracy, which led to an 11% decrease in the Mean Squared Error (MSE).
- Led a data mining project for an insurance company, utilizing machine learning algorithms to achieve a 96.36% accuracy and a 96.96% F1-score with the CatBoost model, significantly enhancing the company's predictive capabilities.
- Created a Python script for procurement data analysis using the Levenshtein theorem, reducing manual processing time by 50% and achieving a 1.16% error reduction, saving the company approximately $169,786.
Process Analyst
Seguros Bolivar
02.2020 - 02.2021
- Spearheaded the deployment of process automation projects using Google Apps Script, resulting in a 15% increase in operational efficiency and reducing manual labor equivalent to 10 FTEs within six months
- Collaborated with cross-functional teams to identify and resolve process bottlenecks, leading to a 12% improvement in service delivery times and a notable increase in customer satisfaction
- Coordinated deployment projects based on lean principles for service areas relaassignmentes, locksmith services, and transportation within the insurance sector, resulting in a reduction of 50% in assignation time.
Analytic Consultant
Rappi
06.2019 - 12.2019
- Developed and implemented a skill-based assignment model using Python, leading to a 30% reduction in operational costs within the Consumer-Packaged Goods (CPG) sector
- Conducted comprehensive analyses of domiciliary operations across 200+ cities in Latin America, leveraging SQL and Python to identify inefficiencies and optimize delivery routes
- Designed and deployed data-driven dashboards in Redash for 15 major retailers, enabling real-time insights and improved decision-making, which contributed to a 20% increase in operational efficiency.
IT intern
Jeronimo Martins
01.2018 - 08.2018
- Implemented TMS (Transport Management System) software to optimize the store’s delivery process, reducing transportation costs by 2%
- Trained and supervised WMS (Warehouse Management System) processes in SAP.
Education
Graduate Certificate - Business Analysis And Process Management Program
Sheridan College Institute of Technology And Advanced Learning
Oakville, ON 05.2001 -
Master of Science - Industrial Engineering
Los Andes University
Bogotá 05.2001 -
Bachelor of Science - Industrial Engineering
Los Andes University
Bogotá 05.2001 -
Skills
Data Analysis
Public Speaking
Critical Thinking
Statistical Analysis
Machine Learning
Class Instruction
Strong Communication Skills
Data Visualization and Presentations
Business process improvement
Project Management
Software
C#
Python
Visual Basic
Github
R Studio
DAX
Languages
English
Full Professional
Spanish
Native or Bilingual
Accomplishments
- International association for professionals in analytics and operations research participant and exponent (INFORMS 2021).
- Colombian Congress of Operational Research participant and exponent (ASOCIO 2022).
Timeline
Process Analyst
Seguros Bolivar
02.2020 - 02.2021
Analytic Consultant
Rappi
06.2019 - 12.2019
IT intern
Jeronimo Martins
01.2018 - 08.2018
Graduate Certificate - Business Analysis And Process Management Program
Sheridan College Institute of Technology And Advanced Learning
05.2001 -
Master of Science - Industrial Engineering
Los Andes University
05.2001 -
Bachelor of Science - Industrial Engineering
Los Andes University
05.2001 -
Instructor, Project Manager
Los Andes University
1 2022 - 12.2023
Similar Profiles
Camil MartínezCamil Martínez
Industrial Engineering Professor at Los Andes UniversityIndustrial Engineering Professor at Los Andes University
Zaide MontesZaide Montes
Doctoral Student, Biology at Lund UniversityDoctoral Student, Biology at Lund University
Santiago Andrés Rodríguez MoyaSantiago Andrés Rodríguez Moya
Tutor at University of "Los Andes"Tutor at University of "Los Andes"