I am pursuing data analytics through the MSDIA program at UW–Madison.
My work blends Python, SQL, cloud computing, process automation, and data visualization to solve real-world analytical problems across healthcare, manufacturing, transportation, real estate, HR, and more.
| Category | Tools |
|---|---|
| Languages | Python, SQL |
| Cloud | AWS (S3, EMR, Redshift, SageMaker) |
| Databases | Snowflake, Redshift |
| Analytics | Pandas, NumPy, Matplotlib, Seaborn, Scikit-Learn |
| Process Mining | PM4Py, Directly-Follows Graphs, Heuristic Miner |
| Automation | Zapier, AI Agents (rule-based & LLM-powered) |
| Visualization | Tableau, Looker Studio, Google Sheets |
| Other | Data modeling, ETL pipelines, data warehousing, ERD design, reproducible workflows |
| Project | Description |
|---|---|
| Redshift Customer Data Warehouse | Star schema warehouse built in AWS Redshift with dimension/fact tables and analytical queries |
| EMR Taxi Data Analysis | Large-scale taxi trip analysis using Apache Spark on AWS EMR |
| SageMaker House Value Prediction | ML regression model trained and deployed on AWS SageMaker to predict housing prices |
| S3 + SageMaker AI | End-to-end ML pipeline using S3 for data storage and SageMaker for model training |
| Redshift Final Project | Capstone Redshift project covering schema design, data loading, and complex SQL analytics |
| Project | Description |
|---|---|
| Healthcare Analytics | BMI, readmission risk, and patient outcome analysis using Pandas and Matplotlib |
| Healthcare Ad Spend Analysis | Predicts sales from TV, radio, and newspaper ad spend using linear regression |
| Real Estate Valuation | Regression analysis of property value drivers including age, location, and amenities |
| Garment Industry Analysis | Manufacturing productivity analysis with feature engineering and statistical modeling |
| Scooter Rental Analysis | Demand forecasting for scooter-sharing using linear regression and usage pattern analysis |
| Taxi Cab Analysis | Profitability assessment of cab vs. rideshare using trip data and statistical tests |
| Printer Warranty Probability | Warranty claim probability modeling using Poisson and Binomial distributions |
A complete progression from fundamentals to advanced analytics:
| Project | Description |
|---|---|
| First SQL Statements | Foundational queries against the TPCDS_SF10TCL database |
| Basic SQL | SELECT, filter, sort, and aggregate queries on TPCH_SF1 and HR databases |
| Joins & CASE | Advanced joins and conditional logic on the CENSUS database |
| Subqueries & CTEs | Nested queries and common table expressions for layered analysis |
| Window Functions | Ranking, running totals, and partitioned aggregations |
| Optimization & Transformation | Query performance tuning and data transformation techniques |
| Final SQL Project | Capstone project synthesizing all SQL skills on a real-world dataset |
| ERD Modeling | Entity-relationship diagrams and schema design using LucidChart |
Applied data warehousing across diverse real-world domains:
| Project | Description |
|---|---|
| Module 1 — Streaming Services | Snowflake warehouse setup and SQL analytics on streaming service subscription data |
| Module 2 — Fitness Gym | Warehouse design and analytics on gym check-in and membership data |
| Module 3 — Electronics Sales | Snowflake analytics on electronics sales and warranty data |
| Module 4 — Advanced Warehousing | Advanced Snowflake data warehouse design and SQL analytics |
| Module 5 — Food Trucks | Food truck sales analytics using window functions, running totals, and Looker Studio dashboard |
| Module 6 — EV Charging | Snowflake analytics on EV charging network data with Cortex AI sentiment analysis |
End-to-end RPA course covering process analysis, scripted automation, AI agents, and workflow integration:
| Project | Description |
|---|---|
| Process Mapping | Swim lane process map and stakeholder analysis of a SaaS onboarding workflow to identify churn drivers and competitive gaps |
| Scripted Automation | Python automation scoring and ranking U.S. counties as clinical trial site candidates using 2020 Census demographic data |
| Workflow Integration | Zapier workflow that automatically extracts, summarizes, and logs mortgage call transcripts using AI, Google Drive, and Google Sheets |
| Process Mining | Insurance claims process mining using Python and PM4Py to discover workflow patterns, detect anomalies, and visualize the claim lifecycle |
| Coding Agents | NimbusPay fraud detection system using rule-based transaction risk scoring and AI-assisted code generation |
| General Agents | AI general-agent workflow for commercial real estate quarterly reviews, analyzing leases, inspections, and tenant communications |
| Final Project | Bolt Socks order-to-cash consulting project: swim lane process map, PM4Py process mining on SAP event data, and Zapier invoice automation |
| Project | Description |
|---|---|
| Tableau Traffic Analysis | Interactive Tableau dashboard analyzing traffic patterns and incident trends by time and location |
| Tableau Public Dashboard | Published Tableau Public visualization showcasing KPI design and data storytelling techniques |
| Looker Studio Dashboard | Google Looker Studio report with KPI cards, trend charts, and drill-down filters |
| HR Analytics (Google Sheets) | Workforce analytics dashboard built in Google Sheets with pivot tables, charts, and conditional formatting |
| Course |
|---|
| Applied Analytics |
| Python Fundamentals |
| Prescriptive Modeling and Optimization |
| Predictive Modeling |
| Experiments & Causal Methods |
| Pitfalls, Ethics, Communication, and Leadership in Analytics |
| Text Mining and Generation for Analytics |
Email: taranschlichtmann@gmail.com
I'm actively looking for data analytics, data engineering, data science, and BI roles. Open to collaboration and new opportunities.