OPEN TO OPPORTUNITIES

HI, I'M
ANUJ PATIL

GIS DATA SCIENTISTTRANSIT ANALYTICS & GEOSPATIAL ENGINEERING

"Turning Transit Operations Problems into Data Systems"

I build the data backbone for public transit — GTFS pipelines, service KPIs, and the spatial models underneath them. Currently running the geospatial and data systems for transit across five counties in northern New York, from a $4/month realtime pipeline to microtransit zone design. Working across transit analytics, geospatial engineering, machine learning, and cloud data pipelines.

VIEW MY WORKLET'S TALKRESUME

FEATURED PROJECTS

10 projects
TRANSIT2025
In production, $8/month

SLC Transit GTFS-RT Validator

Automated GTFS Realtime validation for St. Lawrence County Transit on a single $8/month EC2 instance. Terraform-provisioned, Docker-packaged, scheduled to service hours, with SNS alerting on critical feed errors and S3 report history.

GTFS-RTAWSTerraform+3
VIEW CODE
GEOSPATIAL2024
Delivered to 3 counties

A2A Corridor Roadkill Analysis

Identified wildlife–vehicle collision hotspots using kernel-density and penalized regression. Analyzed 1,000+ collision records with traffic, land cover, and environmental data. Impact: Planner-ready mitigation layers delivered to 3 counties.

ArcGIS ProGeoPandasscikit-learn+2
Client work — code not public
TRANSIT2024
Deployed for St. Lawrence Transit

Cost-Efficient GTFS-RT Pipeline

Deployed Lambda+S3 GTFS-RT pipeline ($4/month) with 30-day history for service and on-time performance analysis. Unified GTFS static/RT/Flex with automated QA. Architecture presented at MobilityData Conference 2024.

AWS LambdaS3GTFS+3
Client work — code not public
TRANSIT2024
Trip-level demand patterns

NYS Taxi Trips — Big Data Inspection

Explored large-scale NYC taxi trip records with datetime decomposition and spatial-temporal visualization to surface demand patterns across time of day and pickup zone.

PythonBig DataMobility Data+1
VIEW CODE
MACHINE LEARNING2024
10M+ records analyzed

Climate Risk & Emissions Prediction

Analyzed 10M+ environmental audit records across US/EU/CA/IN and built Random Forest predictors for organizational emissions risk to inform carbon policy interventions.

Pythonscikit-learnML+2
VIEW CODE
TRANSIT2024
Interactive visualization

GTFS Transit Analysis StoryMap

Created interactive ArcGIS StoryMap showcasing transit network analysis and service patterns. Visualized route performance, ridership trends, and accessibility metrics.

ArcGIS OnlineStoryMapGTFS+2
Client work — code not public
TRANSIT2024
Deployed for VTC

Microtransit Zone Design

Designed zone-based microtransit service areas using demand analysis, travel-time modeling, and service constraints. Optimized zone boundaries for efficiency.

ArcGIS ProPythonNetwork Analysis+2
Client work — code not public
MACHINE LEARNING2023
88.3% accuracy

Hotel Booking Cancellation Prediction

CatBoost model achieved 88.3% accuracy predicting cancellations. Used feature importance and partial dependence to explain impact of lead time, ADR, and past cancellations.

PythonCatBoostML+1
VIEW CODE
GEOSPATIAL2023
Top 5% risk segments identified

NY Road Network Safety Analysis

Unified crashes, traffic counts, pavement ratings, and environmental data into a single geodatabase. Computed segment-level features and a composite risk score to prioritize the top 5% of segments for intervention.

ArcGIS ProPythonPostgreSQL+2
VIEW CODE
MACHINE LEARNING2022
1M tweets processed

Cyberbullying Detection (NLP)

Classified toxic content at scale using classical NLP (TF–IDF + linear models) and deep learning. Preprocessed 1M tweets with class imbalance handling and confusion-matrix analysis.

PythonNLPTensorFlow+2
VIEW CODE

EXPERIENCE

  1. GIS Data Scientist

    IN SERVICEDec 2023 – Present

    Volunteer Transportation Center (VTC)

    St. Lawrence and Jefferson County Public Transit, NY

    • Own the geospatial/data backbone – turn rider needs and ops constraints into GTFS, analytics, and tools used by planners, dispatchers, and the public.
    • Built cost-efficient AWS pipelines ($4/month) for GTFS-RT with 30-day history, reducing manual data processing by 50% and enabling real-time service analysis.
    • Unified service design across modes. Aligned fixed-route, FMLM, and zone-based microtransit using demand, travel-time, and OTP analysis for 5 counties.
    • Co-developed microtransit zones/windows and shipped LLM assistants for fixed-route operations, improving dispatch efficiency by 30%.
    • Standardized agency transit KPIs (ridership, on-time performance, coverage, access/equity) and unified GTFS static/RT/Flex behind automated QA.
    • Selected speaker at MobilityData Conference, Montréal (Oct 2024) - presented on cost-efficient GTFS-RT pipeline architecture.

  2. GIS Intern

    Jul 2023 – Dec 2023

    Clarkson University CEM Consulting Group (C3G)

    Potsdam, NY

    • Delivered GIS for Complete Streets and urban planning; updated municipal geodatabases and parcel/transport layers for 10+ municipalities.
    • Supported A2A Wildlife Connectivity Study: analyzed 1,000+ collision records using spatial joins, kernel-density, and hotspot modeling to produce planner-ready mitigation layers delivered to 3 counties.
    • Built and maintained ArcGIS Online web apps and data products for public engagement, serving 5+ planning projects.

  3. Research Assistant

    Mar 2023 – Aug 2023

    Vestibular Lab, Clarkson University

    Potsdam, NY

    • Streamlined VR/EMG data collection workflows to improve trial throughput by 20% while maintaining quality controls.
    • Developed R/Python/MATLAB models (incl. CNN/RNN baselines) for incident detection; improved classification accuracy by 25% compared to baseline methods.

  4. Graduate Assistant

    Aug 2022 – May 2023

    Clarkson University

    Potsdam, NY

    • Analyzed 10M+ environmental audit records across US/EU/CA/IN to surface carbon policy insights.
    • Built Random Forest predictors for organizational emissions risk and delivered the supporting analysis.

  5. System Administrator & Data Analyst

    Jun 2021 – Jul 2022

    Delonix Society's Baramati College

    Baramati, Maharashtra, India

    • Managed IT infrastructure and systems administration for college operations.
    • Performed data analysis and reporting to support administrative decision-making.
    • Maintained databases and ensured system reliability and security.

SKILLS & TOOLS

TRANSIT & MOBILITY DATA

Daily, in production
GTFS StaticGTFS RealtimeGTFS FlexOTP AnalysisRidership & Coverage KPIsMicrotransit Zone DesignNetwork Analysis

GEOSPATIAL

Daily, in production
ArcGIS ProArcGIS OnlineArcPyExperience BuilderQGISGeoPandasPostGISGDALH3FME

ML & MODELING

M.S. Applied Data Science
scikit-learnCatBoostRandom ForestTensorFlow / KerasCNN / RNNPenalized RegressionStatistical ModelingNLP

DATA ENGINEERING & CLOUD

Shipped and maintained
PythonSQLRMATLABETL / ELT PipelinesAWS LambdaAWS EC2S3RedshiftSnowflakePostgreSQLMySQLAutomated Data QAMonitoring & Alerting

ENGINEERING & DELIVERY

How the work ships
GitGitHub ActionsDockerTerraformJupyterC / C++TypeScriptReactNode.jsHTML / CSS / JSHighchartsFigma

WHAT I BRING

  • ›End-to-end data pipelines — from raw ingestion to production dashboards
  • ›Cost-conscious cloud architecture (AWS) with real cost savings track record
  • ›Geospatial analysis and visualization that tells compelling stories
  • ›ML models deployed in production, not just notebooks

BY THE NUMBERS

5counties
Transit service designed and analyzed across St. Lawrence, Jefferson, and neighbouring counties
$4/month
Running cost of the GTFS-Realtime pipeline behind on-time performance reporting
10M+records
Environmental audit records analyzed for emissions-risk modelling
88.3%accuracy
CatBoost cancellation model, cross-validated hyperparameter search

EDUCATION

M.S. Applied Data Science

Clarkson University

Potsdam, NY•2023 – 2024•GPA 3.53 / 4.00

B.E. Computer Science

Savitribai Phule Pune University

Maharashtra, India•2017 – 2022•GPA 7.9 / 10

CERTIFICATIONS

  • MOOC CartographyEsri
  • MOOC Modern GeoAppsEsri
  • OpenCV BootcampOpenCV University
  • Data ScienceInternshala
  • Social & Behavioral ResearchCITI Program
  • C ProgrammingSeedInfotech

ACHIEVEMENTS

MobilityData Conference

Presented GTFS-RT pipeline architecture

MontréalOct 2024

Phalanx Service Award

Distinguished service and leadership

Clarkson U.2023

Secretary of the Treasury

Friends of India Association

Clarkson U.2022–23

Technical Head

E-Cell Club

SPPU2019

Cost Optimization

$4/month AWS pipeline, 90% cost reduction

VTC Transit2024

GET IN TOUCH

OPEN TO NEW OPPORTUNITIES

Looking for full-time roles or contracts as a Transit Data Analyst, GIS Data Analyst, Data Engineer, or Data Scientist.

Based in Potsdam, NY · Open to remote and willing to relocate

EMAIL

contact@arpatil.xyz

PHONE

+1 (315) 603-7772

LOCATION

Potsdam, NY

SEND A MESSAGE