Halifax, Nova Scotia · Open to work

Sumit Jindal

I work as a Business Analyst

I turn messy operational data into decisions people can act on. SQL to find the problem, dashboards to make it obvious, and BPMN plus a clear requirements document to fix the process behind it.

See my work LinkedIn GitHub Email

7 working projects · SQL & Excel · BPMN process design · Live-data dashboards

01 / About

From a computer science and business degree to analysis work I actually enjoy.

I studied computer science and business at Saint Mary's University and spent a few years in front-line and support roles, where I kept gravitating to the same thing: figuring out why a process was slow, pulling the numbers to prove it, and writing down a fix the team could follow.

These days I work in IT and clinical systems support at Nova Scotia Health, and I am moving deliberately toward Business and Systems Analyst work. To show what that looks like rather than just claim it, I built seven projects end to end: real datasets queried in SQL, interactive dashboards, BPMN process maps with as-is and to-be states, and business requirements documents that tie every change back to a measured finding.

I like the analyst job because it sits between people and systems. You have to listen well, ask the awkward question, and then leave behind something concrete: a number, a diagram, a spec. That is the work in the cards below, and most of it is live and clickable.

02 / Selected work

Seven projects, built to be opened.

Each one links straight to a live demo and the source on GitHub. Filter by what you want to see. Two are live, real-time data apps; the rest cover SQL analysis, process design, and requirements.

Live demo

Flagship · live municipal data

City Pulse

A zero-cost operations command center for New York City's 311 service requests. A scheduled job pulls fresh data every hour, and the page turns it into live KPIs, a Leaflet incident map, a measured 311 process map, a what-if resolution-time simulator, and an auto-populated BRD you can print to PDF.

Hourlylive refresh

$0infra cost

6analytics panels

Live APIChart.jsLeafletBPMNBRDGitHub Actions

Live demo Code

Live demo

Live data · geospatial

SkyTrace

A FlightRadar-style radar that shows aircraft in the sky right now. It refreshes live ADS-B data every eight seconds and dead-reckons each plane between updates so they glide instead of jump. Click any aircraft for callsign, type, altitude, country, and, for scheduled flights, the route and a live ETA. No API keys, no backend.

8srefresh rate

~190country codes

0API keys

Live APICanvasLeafletGeospatialJavaScript

Live demo Code

Live demo

Capstone · HR analytics

TechNova Attrition Analysis

A full analyst case study on employee attrition. SQL on 1,470 employees finds the drivers (overtime staff leave at 30.5% versus 10.4%, first-year attrition hits 34.5%), an interactive dashboard makes it land, and a BRD plus an as-is/to-be BPMN redesign propose a Retention Early-Warning System. The whole chain runs from data to a one-page executive summary.

3×overtime attrition

15user stories

$1.5Mprojected saving

SQLDashboardBRDBPMNHR Analytics

Live demo Code

Live demo

SQL analytics · logistics

Olist E-Commerce Fulfillment

Twelve analytical SQL queries on roughly 96,000 real Brazilian marketplace orders, with an interactive Chart.js dashboard on top. It surfaces a 4.5x regional gap in late deliveries, the direct link between late shipping and review scores, and a 3.2% repeat-customer rate that points straight at retention as the highest-ROI lever.

~96korders

12SQL queries

4.5×late-rate gap

SQLPostgreSQLChart.jsLogistics

Live demo Code

Live demo

SQL + process redesign

Healthcare Patient Intake

Why does one in five patients miss a primary-care appointment? Ten SQL queries on 110,527 real appointment records find the causes (long booking horizons, a single late SMS, a tiny frequent-no-show cohort), and a redesigned digital-front-door intake answers each one. Every BPMN element traces back to a specific SQL finding, with a projected drop from 20.2% to 13.5%.

110krecords

20.2→13.5%no-show target

10SQL queries

SQLBPMNGap AnalysisTraceabilityHealthcare

Live demo Code

Live demo

Systems analysis · process

Loan Approval Redesign

A Systems Analyst package for a retail bank's loan approval workflow. A process narrative and as-is BPMN expose a 9 to 12 day turnaround built on manual credit pulls and serial review. The to-be design adds an automated scoring API, parallel compliance and underwriting, and digital signing to target two days, with a traceability matrix linking every gap to a requirement.

12→2days turnaround

6roles mapped

16requirements

BPMNGap AnalysisRequirementsMermaid

Live demo Code

{ }

Product thinking · hybrid app

Public Benefits Navigator

A screening tool that tells people which benefits they likely qualify for (SNAP, Medicaid, CHIP, WIC, LIHEAP, EITC). The design decision is the point: a deterministic, fully tested Python rules engine makes every eligibility call, and the language model only parses free-text intake and explains the result. It never gets to decide. The rules suite is a hard CI gate that already caught two of my own wrong thresholds.

6benefit programs

22/22eval assertions

0LLM in decisions

PythonFastAPIClaude APIRules EngineEvals

Runs locally Code & setup

03 / Skills & tools

What I reach for.

The bars are an honest read on where I am today, not a sales pitch. Everything here shows up in the projects above.

■ Analysis & data

find it, prove it, show it

SQL (Postgres)strong

Excel (PivotTables, lookups)strong

Power BI (PL-300)working

Python (pandas)working

Dashboarding (Chart.js)working

■ Process & requirements

the analyst core

BPMN (as-is / to-be)strong

BRD authoringstrong

User stories & acceptance criteriastrong

Gap analysis & traceabilitystrong

Stakeholder communicationstrong

■ Tools & platforms

day to day

Git & GitHubworking

JIRAworking

ServiceNowworking

HTML / CSS / JavaScriptworking

MS Accessfamiliar

04 / Contact

Let's talk.

I am looking for Business Analyst, Systems Analyst, and Data Analyst roles, in Halifax or remote. If any of the work above fits what your team needs, I would love to hear from you.

sumitjindal1100@gmail.com

Email me LinkedIn GitHub Download resume