Summary
Overview
Work History
Education
Skills
Timeline
Generic

Jaspreet Singh Hora

Scarborough,ON

Summary

A self-starter, quick learner, dynamic, and seasoned professional thriving to work in a challenging and fast-paced environment, leveraging my current skills in data modeling, manipulation, and analyzing data. Skilled in analyzing trends, generating and publishing reports while managing complex data analysis responsibilities with advanced proficiency in all aspects of Excel, SQL, Power BI.

Overview

4
4
years of professional experience

Work History

Data Analyst

Wyse Meter Solutions Inc.
Toronto, Ontario
04.2025 - Current
  • Assist in gathering data from various energy metering systems.
  • Support the preparation of regular and ad-hoc reports on energy usage and meter performance.
  • Help identify trends and anomalies in the data, developing insights to improve data quality.
  • Assist in maintaining data accuracy through routine checks and troubleshooting.
  • Assist in responding to tickets from stakeholders regarding data-related issues.
  • Help communicate findings and provide data insights as part of a team.

Data Analyst

Etraveli Group
Mumbai, Maharashtra, India
12.2023 - 05.2024
  • Manage internal and external stakeholders to collect reporting requirements, and ensure the quality and accuracy of the data delivered.
  • Collaborate with different teams in Customer Service to gather requirements related to dashboard creation and updates.
  • Support in reporting customer service performance and KPI reports.
  • Create and maintain dashboards of key areas related to customer service to enable insights and showcase operational performance.
  • Enabling data for multiple departments based on the requirements.
  • Coordination with multiple stakeholders to deal with data requests.

Distribution Data Analyst

Estee Lauder Companies
Toronto, Ontario
06.2022 - 06.2023
  • Initiate the development of computer-based integration tools and systems used to automate repetitive work processes through Excel, Power BI, Python, SharePoint, and SQL Server.
  • Satisfy the analytical needs of the Planning and Inventory Control departments by mining and deep-diving into large data warehouses and data lakes, and extracting the relevant information using SQL joins, subqueries, CTEs, window functions, query-optimization, etc.
  • Working with management to identify areas for potential improvement.
  • Understanding the problem statements, translating business requirements, and converting them into meaningful insights suitable for both technical and non-technical audiences. Generate ad-hoc reports, map processes, and publish reports on the Power BI service.
  • Developing gap analysis to deliver action plans to support ongoing improvement, integration, and the elimination of waste.
  • Developing possible, potential creative solutions (process and system).
  • Presenting solutions to the management team, and implementing solutions.
  • Maintenance and validation of current tools, scorecards, and reports, such as dashboards, productivity tools, and databases, to monitor performance.
  • Perform inventory cycle counts, and report the discrepancies to the supervisor.
  • Perform any of the required functions in the Distribution Area to ensure that all daily requirements are met.

IT Business Analyst

Symtech Innovations Ltd.
Richmond Hill, Ontario
09.2021 - 04.2022
  • Perform business system analysis for moderate projects or sub-tasks of large projects.
  • Work with IT and business partners to understand business processes, to enable accurate business requirement specifications.
  • Create business requirements documentation in support of projects, production support, etc.
  • Work with other IT functions (infrastructure, database, etc.) in a fast paced environment to support IT driven process change.
  • Critically evaluating information gathered from multiple sources, designing, and developing reports for business stakeholders using SQL and Power BI.
  • Providing reports and presenting Quarterly Business Reviews (QBRs) to Executive Leadership.

Education

Master of Engineering - Mechanical Engineering

University of Windsor
Windsor, None
06-2021

Skills

  • Data visualization
  • SQL querying
  • Power BI
  • Data analysis
  • Statistical modeling
  • Dashboard creation
  • DAX
  • Power Query
  • VBA
  • Automation
  • Microsoft SharePoint
  • Microsoft Power Automate
  • Microsoft Excel
  • Data Modelling and transformation
  • Jira
  • Confluence
  • Genesys
  • Qualtrics
  • Python
  • Star Schema
  • Linear and Logistic Regression
  • Hypothesis Testing
  • Data Warehousing
  • Query Optimisation
  • Inventory Control
  • Warehouse Optimisation

Timeline

Data Analyst

Wyse Meter Solutions Inc.
04.2025 - Current

Data Analyst

Etraveli Group
12.2023 - 05.2024

Distribution Data Analyst

Estee Lauder Companies
06.2022 - 06.2023

IT Business Analyst

Symtech Innovations Ltd.
09.2021 - 04.2022

Master of Engineering - Mechanical Engineering

University of Windsor

Similar Profiles

CREATE PROFILE
Jaspreet Singh Hora