Summary
Overview
Work History
Education
Skills
Certification
Timeline
Generic

Jaspreet Kaur

Mississauga,Canada

Summary

Results-driven Data Analyst with 6+ years of experience leveraging advanced analytical, statistical, and programming skills to drive business insights and data-driven decision-making. Proficient in Power BI, SQL, Tableau, and Python, transforming complex data sets into actionable insights. Collaborative team player skilled in optimizing business processes and enhancing performance metrics.

Overview

8
8
years of professional experience
1
1
Certification

Work History

HR Administrator (Contract)

CHICK-FIL-A INC.
Mississauga, Canada
10.2023 - Current
  • Ensured accurate record-keeping by conducting regular audits of personnel files and HR databases, identifying discrepancies, and implementing corrective measures to maintain data accuracy.
  • Handled onboarding process for newly hired employees, which included distribution of all paperwork.
  • Oversaw hiring, staffing, and labor law compliance.
  • Managed FMLA leave requests, balancing employee needs with organizational requirements for productivity.
  • Improved employee satisfaction and performance with targeted training initiatives.
  • Enhanced employee retention by developing and implementing comprehensive onboarding programs.
  • Planned, monitored, and appraised employee work results by training managers to coach and discipline employees.
  • Improved office efficiency by effectively managing internal communications and correspondence.

Data Analyst

HCL CANADA
02.2021 - 07.2023

Client: Microsoft.

  • Enhanced data mining and segmentation techniques to increase the usefulness of analytical reports. Managed output and dashboards for effective reporting on key business intelligence.
  • Utilized the Microsoft Azure platform to deploy technical services and resolve incidents, resulting in an enhanced customer experience.
  • Analyzed large datasets to identify trends, patterns and correlations for business insights.
  • Implemented forecast pipeline in Azure Data Factory to ensure accurate processing of adjustments and volume data updates.
  • Utilized Python and MySQL to ingest and transform data from multiple sources, enabling efficient utilization of Power BI tools
  • Identified opportunities to develop forecasts, statistical models, segmentation schemes, and data-driven analyses to drive business efforts.
  • Designed and developed complex workbooks, dashboards, and parameter-based calculations using Tableau server as a front-end and Microsoft SQL Server as the back-end database.
  • Analyzed anomaly detection in Power BI by comparing volume data behavior of previous years with current years across all Consumer Planning Categories
  • Managed data migration workstream within the established project budgets and advised the project manager of potential deviation.
  • Demonstrated expertise in extracting raw data from multiple sources
  • Created and reviewed NRE Adjustments in Excel to normalize volume data and detect changes for all planning categories
  • Launched query in SQL server to delete and insert new adjustments, update training windows if needed, and verify forecast status
  • Generated customized dashboards by retrieving and analyzing Kusto data in Power BI Desktop, tailored to client specifications.
  • Worked closely with stakeholders to build and deploy various initiatives within the data platform.
  • Implemented the creation of a specialized graph using Neo4j, designing numerous nodes and establishing relevant connections based on client requirements.

Data Analyst (internship)

HCL CANADA
07.2020 - 12.2020

Client: Microsoft

  • Developed proficiency in manipulating and analyzing large datasets using SQL, Python, and Excel.
  • Conducted data analysis and gathered requirements, working alongside cross-functional teams to achieve business objectives.
  • Conducted exploratory data analysis on customer segmentation data, identifying key patterns and trends that informed targeted marketing strategies.
  • Collaborated with senior data analysts to design and execute A/B tests, analyzing the results to inform marketing campaign optimization.
  • Created reports on Power BI and validated data on SQL management.

Junior Web Developer(part-time)

DESIGN2WEB IT INC
08.2019 - 01.2020
  • Developed and maintained websites using HTML, CSS, JavaScript, and PHP.
  • Created custom WordPress themes from scratch or modified existing ones.
  • Monitored website analytics tools, such as Google Analytics, for insights into user behavior patterns.
  • Maintained detailed documentation of coding processes for future reference.
  • Increased productivity in Amazon Canada operations through consistent and effective product data entry

Data Analyst

CAPGEMINI
03.2017 - 04.2019

Client: Chubb Insurance.

  • Acquired proficiency in SQL, Python, and Excel for efficient manipulation and analysis of extensive datasets
  • Optimized decision-making by incorporating accurate data analysis and visualization techniques.
  • Generated reports and obtained data to develop analytics on key performance and operational metrics.
  • Ensured data integrity and accuracy through cross-functional collaboration resulting in informed decision-making.
  • Supported strategic initiatives by presenting comprehensive reports and dashboards with actionable insights
  • Managed large-scale databases to ensure timely access to critical information for key stakeholders.
  • Filtered and cleaned data, and reviewed computer reports, printouts, and performance indicators to locate and correct code problems.
  • Streamlined the integration of varying data sources by utilizing ETL processes, resulting in improved analytic capabilities.
  • Developed and maintained data warehouses and data marts to support business operations.
  • Designed data models for enhancing decision-making frameworks.
  • Performed data entry, data cleaning, and data coding for analysis.

Education

Post-baccalaureate certificate - data analysis

UNIVERSITY OF THE FRASER VALLEY
12.2020

BSc - Information Technology

UNIVERSITY OF MUMBAI
04.2016

Skills

  • Reporting Tools: Power BI, Tableau, Grafana, Kusto, Neo4j, SSRS (SQL Server Reporting Services)
  • Programming Language: Java, Python, C
  • Web Technologies: HTML5, Javascript, CSS3
  • Database: MySQL, Oracle, DB2
  • Tracking tools: Jira, ServiceNow
  • Methodologies: Scrum, Waterfall, SDLC, Kanban
  • Project management Tools: ETL, Quality Center, Sharepoint
  • IDEs: Visual Studio, Eclipse
  • Operating Systems: Windows, Unix, Linux, IOS
  • Agile Project Management
  • Microsoft 365 products and Google Suites
  • Data Analysis and Statistical Analysis
  • A/B Testing
  • Hr Policies & Procedures

Certification

  • Microsoft Power BI Certificate
  • ISTQB Certification
  • Agile Fundamentals
  • SCRUM study Agile Master Certification
  • Cloud Networking

Timeline

HR Administrator (Contract)

CHICK-FIL-A INC.
10.2023 - Current

Data Analyst

HCL CANADA
02.2021 - 07.2023

Data Analyst (internship)

HCL CANADA
07.2020 - 12.2020

Junior Web Developer(part-time)

DESIGN2WEB IT INC
08.2019 - 01.2020

Data Analyst

CAPGEMINI
03.2017 - 04.2019
  • Microsoft Power BI Certificate
  • ISTQB Certification
  • Agile Fundamentals
  • SCRUM study Agile Master Certification
  • Cloud Networking

Post-baccalaureate certificate - data analysis

UNIVERSITY OF THE FRASER VALLEY

BSc - Information Technology

UNIVERSITY OF MUMBAI
Jaspreet Kaur