Summary
Overview
Work History
Education
Skills
Certification
Timeline
Generic

Jasmeet Singh

Brampton,ON

Summary

Oracle Certified Professional and Data Analyst skilled in advanced SQL, Business Visualizations, Software Development and Database Management. Self-directed and proactive professional with 10 years of experience across various industry domains. Natural leader and problem-solver with strong cross-functional understanding of information technology and business processes.

Overview

10
10
years of professional experience
1
1
Certification

Work History

Senior Data Analyst | Team Lead

Geotab
05.2018 - Current
  • Leading the technical team on Data Procurement and Business Intelligence
  • Representing Department as AI champion and RBAC champion.
  • Actively working on Geotab's Generative AI project
  • SME for Global Operations' Big Data and Automation Solutions
  • Hiring and mentoring data aspirants for different data-related roles
  • Writing efficient queries and tuning complex SQL queries on Google BigQuery
  • Creating data pipelines and ETL activities on Apache Airflow and Google Cloud Console (GCP)
  • Documenting stakeholder requirements, developing functional specifications and report automation
  • Developing Interactive Redash and Superset Visualisations
  • Designing and implementing Geotab’s Global Operations' Big Data Roadmap
  • Undergoing PIA for sensitive data points (PII) on customer data projects
  • Analysing Federal Data for US Government Projects
  • Understanding geospatial data (lat lon and geohashes) and projecting it into a user-friendly format for the end customers

Projects:

1. Global Top 20 Countries:

  • Developed and deployed a streamlined user interface (UI) for Geotab leadership by leveraging Apache Superset
  • Recognized with a Geotab KUDOS award for this
  • Provided a comprehensive view of KPIs by incorporating all the relevant metrics to enable informed decision-making

2. Shipping Metrics:

  • Developed a powerful dashboard by calculating and consolidating critical business metrics into a single UI for the Shipping and Fulfilment department
  • Enabled effective control and monitoring thereby streamlining operations and improving the delivery performance by 63%
  • Recognized with a Geotab KUDOS award for this achievement.

3. Active Devices By Country Real Time:

  • Developed a setup for global tracking and monitoring of GO devices by effectively communicating device locations on an interactive world map
  • Implemented real-time tracking capabilities for efficient telematics device management

4. Churn Analysis Reports:

  • Collaborated with diverse data sources, utilised technologies to analyse and gain deep insights into customer churn
  • Generated insightful churn rate metrics and actionable recommendations for business leaders

5. Telematics Device Failure Rate:

  • Conceptualized the term failure rate and identified crucial indicators for computing failure rate
  • Delivered comprehensive insights to enhance device performance and reliability and mitigate failure risks

Business Analyst - Data Science

MRI Software, Walmart International
Toronto
10.2017 - 04.2018
  • Configured and developed Scorecards and Tableau Dashboards for Walmart International's Real Estate Leadership teams globally
  • Forecasted revenue and capex values by applying Python algorithms based on financial metrics, and created visualization reports using Tableau
  • Supported ETL mappings, detailed documentation, and data validations
  • Collaborated with stakeholders to define features, integrations and partnerships.

Data Scientist

Verizon
09.2013 - 05.2017
  • Recognized for improving customer experience and elevating profitability by 13% through valuable insights obtained from applying advanced Analytics techniques on target datasets
  • Resolved real-time critical Regional Operations Control (ROC) tickets, reducing ticket inflow volume by 80% (from 70-80 to 25-20 per day), and recognized with Verizon Spotlight Award

Projects:

1. Supply Chain Management - Determining Reusability of Defected Set Top Boxes:

  • Data collection: Sourced and manipulated large volumes of data
  • Data cleaning: Identified and removed non-necessary and repetitive data
  • Feature engineering: Identified useful features and developed new significant features
  • Modeling: Utilized decision trees, random forest, and gradient boosting using R
  • Generated statistical reports, metrics, and graphical plots, presenting them to stakeholders for discussions

2. Online Visitors - Conversion of Prospective Customers on Digital Channels

  • Studied prospect behavior and applied unsupervised algorithms on it
  • Provided valuable recommendations and insights supported by comprehensive reasoning
  • Presented findings through interactive reports using Tableau
  • Conducted knowledge transfer sessions on product attributes for new joiners.

Education

Diploma - Computer Engineering

Thapar Institute of Engineering and Technology
2010

Bachelor of Engineering - Information Technology

SLIET, Deemed University
2013

Executive Program For Young Managers - Data And Marketing

Indian Institute of Management Calcutta
2016

Skills

  • SQL
  • Google BigQuery
  • Power BI
  • Business Intelligence
  • Oracle SQL
  • MS SQL Server
  • ETL
  • Apache Airflow
  • Apache Superset
  • Redash
  • Jira
  • Tableau
  • Power BI
  • Python
  • Machine Learning
  • Core Java
  • SAS
  • DevOps
  • Requirements Analysis
  • Workflow Analysis
  • Critical Thinking

Certification

  • Oracle SQL Fundamentals (1Z0-051) | Licence# 281548682 | Oracle University

Timeline

Senior Data Analyst | Team Lead

Geotab
05.2018 - Current

Business Analyst - Data Science

MRI Software, Walmart International
10.2017 - 04.2018

Data Scientist

Verizon
09.2013 - 05.2017

Diploma - Computer Engineering

Thapar Institute of Engineering and Technology

Bachelor of Engineering - Information Technology

SLIET, Deemed University

Executive Program For Young Managers - Data And Marketing

Indian Institute of Management Calcutta
Jasmeet Singh