Jenil Gohel

About Me

The analyst behind the dashboards

Conestoga GPA

3.6 / 4.0

Most dashboards answer the question that was asked.
The best ones answer the question the business didn't know it had.

I'm a Data Analyst who works across the full analytics stack — designing SQL data architectures, building star schema models, writing Python pipelines, and delivering executive Power BI dashboards that actually drive decisions.

My projects span telecom churn risk, transit geospatial intelligence, healthcare ER analytics, and a full UX case study on layoff recovery — each built end-to-end: raw data in, board-ready insight out.

Transit Incidents Analyzed

3.6

GPA — Conestoga College

100%

Data Accuracy at Amazon

Conestoga College

Advanced Diploma — Computer Programming and Analysis

Technical Skills

What I bring to the table

BI & Visualization

Dashboard & Reporting

Power BI DAX Azure Maps KPI Design Executive Dashboards Geospatial Analytics

Data & Databases

Storage & Pipeline Architecture

SQL Server Star Schema ETL Pipelines Data Modeling Power Query Data Cleaning

Programming

Languages & Libraries

Python Pandas NumPy Scikit-learn Matplotlib Jupyter Notebook

UX & Analytics Methods

Research & Techniques

Churn Analysis K-Means Clustering Feature Engineering User Research Information Architecture WCAG 2.1 AA

Work Experience

Where I've made an impact

Customer Service Manager

Walmart

Oct 2025 – Present (Part-time) · Kitchenr, ON

Oversee front-end technology systems including POS terminals, self-checkout kiosks, and payment processing hardware — troubleshooting hardware failures, connectivity issues, and device performance problems while coordinating with external technical vendors for escalated resolutions and maintaining IT asset documentation across all managed devices
Train and support 15+ team members on technology systems and secure access procedures — documenting troubleshooting steps, configuration standards, and operational procedures to ensure consistent, compliant system usage across all service touchpoints

Technical Troubleshooting & Incident Resolution IT Documentation & Knowledge Management User Support & Stakeholder Communication

Cashier

Walmart

Oct 2023 - Sep 2025 (Part-time) · Kitchener, ON

Operated and troubleshot POS systems, payment terminals, and peripheral devices daily — diagnosing hardware and software issues, supporting user access management, and escalating persistent technical failures to the appropriate support team in a timely and professional manner.
Maintained accurate records of device issues and resolutions — demonstrating strong attention to detail, reliable attendance, and the ability to work effectively within structured operational and compliance standards in a fast-paced environment.

Customer Service & Conflict Resolution POS Systems & Technology Operation Team Leadership & Training

Customer Technical Support

TOPS Technologies

March 2023 - Jun 2023 · Ahmedabad, Gujarat

Provided technical support to customers via phone, email, and chat by troubleshooting software, hardware, and account-related issues
Documented recurring issue patterns and resolutions to build an internal knowledge base, reducing average ticket resolution time
Coordinated with development and QA teams to escalate and track critical bugs reported by customers

Technical Support Troubleshooting Customer Service

Projects

End-to-end builds across data & design

UX Case Study

Severance — A Calm Companion for Layoff Recovery

Figma User Research Information Architecture WCAG 2.1 AA

A digital companion for the first 30 days after a layoff — sequenced action, plain-language severance review, runway as a single number, and a graceful exit when no longer needed. 14-week sole-designer build: 10 generative interviews, 5-phase journey map, 9 hi-fi screens. SUS 84.5, 91% task success, 4.4 / 5 trust, WCAG 2.1 AA on every screen.

View Case Study

Data Analysis

CIBC Credit Card Risk & Retention Analytics

Python SQL Power BI DAX

16.52% of 10,000+ CIBC credit card customers are churning — this dashboard shows exactly who, where, and why. Engineered 8 custom features in Python (churn flags, risk tiers, provinces), uncovered patterns across income tiers, card types, and 6 Canadian provinces via SQL & Jupyter EDA, then shipped a boardroom-ready Power BI dashboard with real banking KPIs, CIBC branding, and interactive slicers.

View Project

Data Analysis

TTC Service Delay Analysis

Power BI DAX Azure Maps Geospatial

Analyzed 63,000+ transit incidents and 1M+ delay minutes across Toronto's TTC network. Built a 3-layer executive dashboard covering KPI monitoring, route risk classification, and 3D Azure Maps geospatial hotspot mapping.

View Project

Data Analysis

TELUS Customer Churn Analytics

SQL Server Power BI Star Schema DAX

Designed a 3-layer SQL architecture (staging → core → analytics mart) to model raw telecom data. Identified month-to-month contracts and sub-12-month tenure as strongest churn predictors through structured risk segmentation.

View Project

Data Analysis

Healthcare ER Analytics

Python Scikit-learn K-Means Pandas

Built a complete Python analytics pipeline on ER patient data — from raw ingestion through feature engineering, EDA, and K-Means clustering. Segmented patient visits by age, wait time, and satisfaction to surface peak demand periods and department gaps.

View Project

Dashboard

TD Credit Card Churn Analytics

Power BI DAX Star Schema Churn Risk

TD-inspired executive dashboard analyzing credit card customer churn risk. Applied star schema modeling and a rule-based churn risk engine to segment customers into Low, Medium, and High risk tiers across income and spending profiles.

View Dashboard

Dashboard

Netflix Analytics Dashboard

Python Power BI Star Schema DAX

Netflix-style analytics dashboard built end-to-end using Python for data generation and Power BI for visualization. Star schema modeling with DAX measures tracking watch hours, MAU, revenue, and churn across device types and content genres.

View Dashboard

Software

AI Code Reviewer — VS Code Extension

TypeScript VS Code API LLM Integration Node.js

Published a production-ready VS Code extension on the official Marketplace. Performs real-time AI code analysis, refactoring suggestions, and plain-language explanations using local LLMs — runs completely offline via LM Studio.

View Code

Software

AI Sentiment Analyzer

Python Scikit-learn Streamlit NLP

End-to-end ML web app using Logistic Regression to classify text as positive, neutral, or negative in real time. Includes a full data preprocessing pipeline and interactive Streamlit UI with live prediction visualization.

View Code

The analyst behind the dashboards

What I bring to the table

Where I've made an impact

End-to-end builds across data & design

Severance — A Calm Companion for Layoff Recovery

CIBC Credit Card Risk & Retention Analytics

TTC Service Delay Analysis

TELUS Customer Churn Analytics

Healthcare ER Analytics

TD Credit Card Churn Analytics

Netflix Analytics Dashboard

AI Code Reviewer — VS Code Extension

AI Sentiment Analyzer

Consistent, active, always shipping

Consistent coding across data, analytics & software

Credentials & continuing education

Let's work together

Looking to hire someone who hits the ground running?

Send a message