Summary
Overview
Work History
Education
Skills
Websites
Projects
Languages
Timeline
Generic

Gurwinder Parhar

Calgary,AB

Summary

Data Analytics / Engineering Professional Brings in both technical and people skills with over 10 years’ experience in multiple industries (transportation, IT, production, retail) in both private and public sectors. Effective and clear communicator. Expertise includes: Analyzing Data | Problem Solving | Planning and Prioritizing | Data Entry | Detail Oriented | Quality Focused| Troubleshooting software and data issues

Overview

13
13
years of professional experience

Work History

Train Operator

CALGARY TRANSIT
01.2023 - Current
  • Operating rail transit vehicles to ensure passenger safety
  • Observing signals at crossings, arrivals, and departure points
  • Proficiently managing the opening and closing of doors on the designated platform side
  • Additionally, demonstrating proficiency in basic troubleshooting in emergency and fault situations and executing evacuation procedures during major emergencies
  • Diligently reporting any delays, malfunctions, or accidents to the control unit for immediate action.
  • Operated trains within established speed limits, maintaining a safe environment for both passengers and employees while minimizing delays.
  • Conducted post-trip inspections after each run, identifying any necessary repairs or maintenance required for optimal train performance moving forward.
  • Supported training initiatives for new hires, providing real-world experience as an experienced mentor in the field of train operations.
  • Managed emergencies effectively by calmly executing appropriate safety protocols during critical situations.

Data Analyst (Volunteer)

CALGARY TRANSIT
01.2022 - Current
  • Gathered Calgary Transit data and performed qualitative and quantitative analysis of field surveys, onboard checks, and computer-based passenger counting/ automatic vehicle tracking system
  • Implemented rigorous data quality checks and processes to ensure data accuracy
  • Visualized meaningful data into useful patterns for managerial decision-making
  • Thesis focused on predictive analytics using Python to extract insights from Calgary transit databases
  • Hands-on experience in Power BI, SQL, and statistical analysis for developing reporting infrastructure and dashboards
  • Proficient in data analysis, programming, and project management, equipped to plan, implement, and track data management strategies.
  • Produced monthly reports using advanced Excel spreadsheet functions.
  • Utilized data visualization tools to effectively communicate business insights.

Relief Training Officer

CALGARY TRANSIT
01.2019 - Current
  • Coordinated and conducted comprehensive training program which consisted of classroom presentations, on-line instruction, on-board instruction and daily coaching and evaluations of up to 30 trainees
  • As Training Officer, I coordinate class schedules and instructed new hires on transit syllabus, including basic scheduling principles, and other variety of tasks within designated timeframes
  • Presented information in a compelling manner, drawing on practical experiences and real-life applications
  • Trained new employees to provide positive and accessible public transit service throughout the city in a time-sensitive manner, while representing the city in a positive light
  • Helped recruitment team in screening new applicants and throughout the selection process
  • Trained employees to prepare for different routes utilizing transit software and on-line maps
  • Modelled for trainees how to respond to customer information needs, such as schedules, routes, directions, and transfer points
  • Reported employee collisions or other traffic disruptions to transit control and prepared reports.
  • Identified training needs and planned classes accordingly.
  • Balanced multiple responsibilities simultaneously in a fast-paced environment, prioritizing tasks effectively to meet deadlines without sacrificing quality of workmanship or attention to detail.
  • Assessed skill gaps for employees and developed training courses to meet identified needs.
  • Optimized resource allocation for each training session based on participant needs analysis.

Operational Clerk

CANADA POST
08.2016 - 01.2021
  • Created and organized data manifests for drivers which saved drivers and organized their work
  • Investigated the correct address to dispatch lost parcels from Canada Post database containing customer information and maintained integrity of system
  • Completed reports and documentation on SAP, handle, follow-up and resolve complaints with tact poise.
  • Utilized strong multitasking skills to manage multiple priorities and tasks, ensuring timely completion of each assignment.
  • Interacted with customers by phone, email, or in-person to provide information.
  • Provided quality clerical support through data entry, document management, email correspondence, and overseeing operation of office equipment.

Inventory Controller (Problem Resolution Desk)

HOME DEPOT
02.2016 - 08.2016
  • Interpreted data, analyzed results using statistical techniques and provided ongoing reports
  • Developed and implemented databases, data collection systems, data analytic and other strategies that optimize statistical efficiency and quality
  • Acquired data from data sources and maintain data systems
  • Filtered and cleaned data by reviewing computer reports, printouts, and performance indicators to locate and correct code problems
  • Worked with management to prioritize business and information needs
  • Located and defined new process improvement opportunities.
  • Completed daily cycle counts to maintain accuracy of records.
  • Completed physical inventory counts each month.
  • Developed comprehensive reports on inventory levels, turnover rates, and sales trends to inform business decisions.
  • Performed root cause analysis of discrepancies between physical inventory counts and system records, taking corrective actions where necessary.

Network Administration (Intern)

ADITYA TELECOM SOLUTIONS
01.2011 - 08.2011
  • Planned and designed networks
  • Helped with infrastructure building and project deployment
  • Performed network optimization, BSS installation, expansion, and consulting service.
  • Supported staff members in their daily tasks, reducing workload burden and allowing for increased focus on higher-priority assignments.
  • Gained valuable experience working within a specific industry, applying learned concepts directly into relevant work situations.
  • Sorted and organized files, spreadsheets, and reports.
  • Gained hands-on experience in various software programs, increasing proficiency and expanding technical skill set.

Education

M.Sc. Data Science -

Liverpool John Moores University
12.2023

Certificate in Human Resource Management -

Fanshawe College
London, ON
01.2013

Bachelor’s in engineering -

IK Gujral Punjab Technical University
01.2011

Skills

  • Python Libraries – NumPy, Pandas, Matplotlib, Seaborn
  • SQL – Different joint displays and Complex Querying with SQL, NoSQL
  • Tableau and Power BI
  • Hastus
  • Coding: C, Python, R
  • SAP, HRIS, Microsoft Office Suite (Word, Excel, Outlook, PowerPoint)
  • Safety Protocols Adherence
  • Emergency Management
  • Train Operation Expertise
  • Passenger Assistance

Projects

E-commerce – Inventory, The company had faced some recent losses and wanted to manage their inventory better so as to reduce any unnecessary costs that they might be bearing. In this project, the inventory cost of this e-commerce company was managed by using EDA, Data Visualization, Market base analysis, Dash boarding and PPT. Bank Data Analysis (EDA) And Airbnb Analysis, Exploratory data analysis for a bank (EDA) with help of Python libraries and SQL to check who should be eligible for loan and who will pay back on time after cleaning the data. In addition, recommendations as to what kind of interest rate should be given were made. Project on Bike Sharing and Developing a Linear Regression Machine Learning Model, Worked on a Bike Sharing initiative for transportation industry (SQL, Python libraries and Tableau) to find out which locations were busiest as per time and season, and provided recommendations to increase supply, presenting with use of Jupiter file, PDF report and PPT. Project on RSVP Movie, Created different tables with use of SQL complex queries to check sales, popularity, revenue generated, etc., after joining different tables.

Languages

English
Full Professional

Timeline

Train Operator

CALGARY TRANSIT
01.2023 - Current

Data Analyst (Volunteer)

CALGARY TRANSIT
01.2022 - Current

Relief Training Officer

CALGARY TRANSIT
01.2019 - Current

Operational Clerk

CANADA POST
08.2016 - 01.2021

Inventory Controller (Problem Resolution Desk)

HOME DEPOT
02.2016 - 08.2016

Network Administration (Intern)

ADITYA TELECOM SOLUTIONS
01.2011 - 08.2011

M.Sc. Data Science -

Liverpool John Moores University

Certificate in Human Resource Management -

Fanshawe College

Bachelor’s in engineering -

IK Gujral Punjab Technical University
Gurwinder Parhar