Devesh Ojha

AI & Data Engineer

I build models — and the data infrastructure they depend on. The part most models never survive. Four years inside enterprise operational data, then two building ML systems and full-stack products end to end.

Calgary, AB · authorised to work in Canada · available immediately

Portrait of Devesh Ojha
●  Open to work
AER filings · top mover found
+15.5%
Gibson bitumen output, 2022–24
SLA reporting cycle
3d → 4h
ServiceNow → ADF → Power BI
HR consolidation runtime
12h → 90s
12 validation rules · Streamlit upload
Teams on shipped dashboards
8
stakeholder teams, enterprise ITSM
Selected work

Things that run, not things that ran once

A model is the easy half. What decides whether it survives contact with reality is everything to its left and right — where the data comes from, whether you can trust it, and what metric you actually optimise.

Live in production

The same prescription can cost 3× more one block away.

CheaperRx makes that spread visible — search a drug, see every pharmacy in your city ranked by real price, and get told when a generic equivalent exists. Auth, subscriptions, crowdsourced data and an admin verification queue, running today.

Authorisation lives in the database

Row-level security on all eight tables. A bug in a React component cannot leak another user's medication list — Postgres refuses the row.

Stripe webhooks are the only truth

The client never sets role = 'pro'. Checkout success is a UI event; the webhook is what grants entitlement.

Current state vs. ledger

A unique index guarantees one live price per drug–pharmacy pair, so the hot read path never deduplicates. History is appended separately.

Next.js 14TypeScriptPostgreSQL SupabaseStripeGIN full-text search
scikit-learn · imbalanced-learn

Space Object Classification

Debris massively outnumbers rocket bodies, so a model that always guesses "debris" scores well and is useless. Class imbalance was the whole problem. The jump from linear SVM to RBF says the boundary in orbital-element space is genuinely non-linear.

97.4% Random Forest SMOTE to 8,431/class Per-class metrics
TensorFlow · Keras · VGG19

Pediatric Pneumonia Detection

Triage support for chest radiographs, where a false negative costs far more than a false alarm. VGG19 transfer learning with augmentation and regularisation tuned for a small, imbalanced clinical dataset — recall is the objective, not accuracy.

~88% accuracy Augmentation + BatchNorm EarlyStopping
Python · pandas · Power BI

Alberta Oil Sands Production Analysis

Alberta's regulator publishes ST39 as a document, not a dataset: months run across the page, commodities stack down it. Unpivoting three annual workbooks into one tidy fact table — 9 operators, 36 months, 251 monthly series — is what turns every downstream measure into a one-line aggregation.

Gibson +15.5% (2022–24) May output 13% below mean 12,084-row fact table
Python · pandas · Streamlit

HR Analytics Automation Pipeline

Five inconsistent workbooks, twelve hours of manual consolidation, a report nobody fully trusted. The fix was not a better spreadsheet — it was a 12-rule validation gate that fails loudly instead of quietly corrupting the numbers downstream.

12h → 90s 12 validation rules Self-service upload
Interactive

Don't take my word for the pipeline — use it

Every number below comes out of the fact table my ETL produced from Alberta Energy Regulator ST39 filings. Pick an operator. Monthly crude bitumen production, January 2022 to December 2024.

Crude bitumen production, thousand m³ per month

Source: AER ST39, 2022–2024 · shaded band marks the April–May turnaround window

Two-year change — Monthly average — Weakest month — Strongest month —
Path

Four years inside enterprise data, then two building my own

Independent builds & analytics projects
Sep 2025 — present
Calgary, AB
  • Designed, built and shipped CheaperRx end to end — schema, row-level security model, Stripe billing, SEO and deployment.
  • Built the AER ST39 ETL and Power BI model now published as an open portfolio project, with its findings independently reproducible from the committed dataset.
  • Working toward retrieval-augmented LLM systems: hybrid retrieval, evaluation harnesses, and served inference.
Post-Baccalaureate Diploma, Applied Data Science
Sep 2023 — Sep 2025
Thompson Rivers University · Kamloops, BC
  • Full-time. Machine learning, statistical methods and applied data engineering, with the pneumonia-detection and space-object projects produced during the programme.
Business Analyst
Jan 2020 — Jul 2023
Cognizant Technology Solutions · client: John Deere IT Infrastructure
  • Built a Power BI semantic layer — star schema, DAX, Power Query — adopted by 8 Finance, Ops and IT teams; cut a three-day manual reconciliation to four hours.
  • Engineered Azure Data Factory pipelines ingesting 70,000+ records per cycle across 4 teams, removing 80–150 hours of manual processing every month.
  • Diagnosed a SQL aggregation defect distorting $50M+ investment reporting; rebuilt it with window functions and CTEs, cutting metric variance 50% in 30 days.
  • Designed a 12-rule data quality framework for HR workforce reporting across 5 sources with a 15% error rate, and drove the Python automation that closed it.
  • Authored BRDs, user stories, UAT scripts and training across 6 concurrent Agile projects; post-deployment defects down 40%.
B.Tech, Electronics & Instrumentation Engineering
2015 — 2019
MAKAUT · West Bengal, India
Stack

What I reach for

Languages

PythonSQL / T-SQLTypeScriptDAXM / Power Query

Data & platform

PostgreSQLAzure Data FactorySupabasePower BIServiceNowSQL Server

ML & AI

scikit-learnTensorFlow / Keraspandas · NumPySMOTE · GridSearchCVRAG & LLM patterns

Product & infra

Next.js 14StripeVercelDockerGitStreamlit

Business analysis

Requirements elicitationBRDs & user storiesProcess mappingUATKPI definitionAgile / Scrum

Certifications

Power BI Data Analytics — SimplilearnGoogle Cloud Data Modernization — CourseraAzure AI-900 — Microsoft

Let's talk

Open to AI/ML Engineer, Data Engineer and Senior Analyst roles across Canada. Calgary-based, authorised to work here, available immediately.