INFORMATION SYSTEMS × AI x ANALYTICS

PORTFOLIO / 2026

I build systems that make data useful.

I’m Ishan Mishra, a Carnegie Mellon Masters in Information Systems student with a concentration in AI Management. I graduated from the University of Wisconsin-Madison with majors in Information Systems and Data Science. I work with data pipelines, analytics, and machine learning, with a focus on making data easier to use and understand.

PITTSBURGH, PA · DATA / ANALYTICS / AI SCROLL TO EXPLORE

01 / SELECTED WORK

Projects with a purpose.

Projects in data engineering, analytics, and machine learning, with notes on the tools, decisions, and results behind each one.

01

Data engineering · Analytics

CivicPulse Data Platform

A pipeline for collecting and analyzing New York City 311 service requests, with data quality checks built into the workflow.

PythonNYC 311 APIPostgreSQLSQLdbtApache Airflow (in progress)
318K+ records in 30-day backfill Read case study
02

Computer vision · Deep learning

RealWaste Image Classifier

Compared transfer-learning models for classifying waste images across nine categories.

PythonPyTorchCNNsTransfer learningModel evaluation
89.19% reported InceptionV3 accuracy Read case study
03

Cloud data engineering · Machine learning

Bankruptcy Prediction Pipeline

A cloud workflow connecting data processing, warehousing, and model training for bankruptcy-risk classification.

PythonAmazon S3AWS GlueAmazon RedshiftSageMaker
80% reported processing-time reduction Read case study
04

Business intelligence · Analytics

Sales Opportunity Dashboard

A Tableau dashboard built on Snowflake data to explore sales activity and highlight potential opportunities.

SQLSnowflakeTableauData visualization
10K+ transactions analyzed Read case study
05

Statistical modeling · Data science

Drug Use Prediction Analysis

Compared classification approaches on a survey dataset to understand which model best predicted the selected outcome.

PythonPandasscikit-learnLogistic regressionModel evaluation
1,885 survey respondents Read case study
06

Web development · Firebase

PSC Website

A lightweight website using vanilla JavaScript and Firebase for authentication, data storage, and hosting.

HTMLCSSJavaScriptBulmaFirebase AuthFirestoreFirebase Hosting
3 core Firebase services used Read case study

02 / EXPERIENCE

Systems that people depend on.

At University Health Services, technical work had to fit real clinical workflows. I worked on access controls, reporting, and process improvements used by staff.

2023 - 2026

University Health Services

Informatics Analyst Intern

Worked with clinical systems and reporting, using Python, SQL, and Tableau for audits and analysis. I also helped maintain templates and questionnaires, reviewed access permissions, and coordinated technical support requests.

  • ↗ Delivered 25+ SQL reports monthly and explained insights to non-technical stakeholders.
  • ↗ Reduced provider onboarding time by about 50% by standardizing user and inherited permissions.
  • ↗ Automated master data and operations audits in Python, cutting preparation time by 85% while meeting HIPAA compliance standards.
2025 - 2026

Wisconsin School of Business

Data Analyst, Faculty-Sponsored Research

Supported faculty research on how school digital policies and other factors relate to student learning outcomes and academic performance across all 50 U.S. states. I built the data pipeline behind the analysis in Python and SQL, ran hypothesis tests in R, and documented the whole workflow so the rest of the team could pick it up and reuse it.

  • ↗ Engineered end-to-end ETL/ELT pipelines in Python that pulled in and cleaned data from 500+ public sources.
  • ↗ Ran paired t-test hypothesis testing in R to evaluate how digital policy relates to student grades and performance.
  • ↗ Documented pipeline, transformation logic, and built reproducible scripts so other team members could take it over.

03 / TOOLKIT

Tools for the whole process.

This list includes tools I have used in projects and work, along with a few I am actively learning. Airflow is currently in progress as part of CivicPulse.

01

Languages & software

PythonSQLROOPJavaScriptHTMLCSSBeautifulSoup
02

Data engineering

dbtETL / ELTData modelingGit / GitHubDockerGitHub ActionsApache Airflow · learning
03

Databases & cloud

BigQueryPostgreSQLAmazon RedshiftSnowflakeAWS S3AWS GlueGoogle CloudSageMakerMySQLMariaDBOracle SQL DeveloperFirebase
04

Analytics & AI

TableauExcelPandasHypothesis testingA/B testingscikit-learnPyTorchCNNsModel evaluation
05

Governance & health data

HIPAA complianceEHR systemsData governanceMetadata managementData quality assurance
06

Systems & process

Red Hat LinuxUbuntuAgileWiresharkPuppetChef

04 / GET IN TOUCH

Working on a data problem?

I’m looking for roles in data analytics, data engineering, and applied AI. I’m especially interested in work that combines reliable data systems with practical analysis.

Get in touch