Summary
Overview
Work History
Education
Skills
Projects
Timeline
Generic

Harshdeep Gandhok

Edmonton,AB

Summary

Results-oriented and detail-driven data analytics professional with a proven track record of contributing to end-to-end data analytics initiatives. Skilled in data extraction, analysis, visualization, machine learning, and crafting insightful presentations tailored for executive consumption. Natural problem-solver possessing strong cross-functional understanding of information technology and business processes.

Overview

4
4
years of professional experience

Work History

Data Analyst/Data Management Specialist

BIS Safety Software
Sherwood Park, AB
07.2022 - Current
  • Conduct data mining, data modeling, and statistical analysis.
  • Created visually impactful dashboards in Excel and Tableau for data reporting by using pivot tables and XLOOKUP.
  • Automated manual reporting processes by developing scripts in Python or R.
  • Translated raw data into meaningful information using statistical techniques.
  • Leveraged SQL queries to extract, transform and load data into databases.
  • Reviewed and organized records, addressing duplicate records, ensuring chronological order, and meeting consultation requirements within the request scope.
  • Accountable in building and maintaining new Business Intelligence & Alignment dashboards to provide leaders consistent, accelerate insight to make strategic business decisions.
  • Worked with internal teams to understand business needs and changing strategies.
  • Create digital forms (Using HTML, CSS, JavaScript) and data reports.
  • Testing software bug fixes, online course files (SCORM) and new feature cases for accuracy.
  • Provide beginner to frontend coding for clients.
  • Investigating and troubleshooting the issues raised by clients and helping the customer experience team.

Store Manager

Kurves Brow Bar
Edmonton, AB
06.2020 - 06.2022
  • Developed strategies to maximize sales and profitability.
  • Established customer service standards and monitored staff compliance.
  • Resolved customer complaints in a timely manner.
  • Recruited, trained and supervised new employees.
  • Prepared sales reports of merchandise and personnel matters.
  • Maintained company standards for store displays, signage, testers, and cleanliness.
  • Set daily and monthly targets fo each employee and explaining sales strategies.
  • Updated POS system with new products and promotional offers.

Education

Bachelor of Science - Information Technology And Mathematics

Concordia University of Edmonton
Edmonton, AB
04-2022

Skills

  • Technical Analysis
  • Project Management
  • Data Validation
  • Attention to Detail
  • Strong Communication
  • Team player
  • Multitasking
  • SQL
  • Advanced MS Office
  • Tableau
  • Microsoft Visio
  • Power BI
  • SAS, SAP HANA
  • LMS 360
  • Web Design and Development
  • Python, R, C, C , ReactJS, Javascript

Projects

Data Filtration and Analytics

  • Filtered and organised raw data of more than 1 million users of a company based on the provided criteria (industry, job title, income, supervisors etc.).
  • Worked on the exceptions (Same first names, last names, date of birth, etc).
  • Updated data into the system software and assigned courses to each user.

Website

  • Created a website for a marketing firm to help build their catalogs using html, CSS and JavaScript for designing.
  • Interlinked web pages and linked social media accounts.
  • Created and attached forms with backend coding.

Timeline

Data Analyst/Data Management Specialist

BIS Safety Software
07.2022 - Current

Store Manager

Kurves Brow Bar
06.2020 - 06.2022

Bachelor of Science - Information Technology And Mathematics

Concordia University of Edmonton
Harshdeep Gandhok