NYPD Crime Analysis and Prediction

Tech Stack: Airflow, Azure, Snowflake, Power BI, Databricks

• Designed data workflows using Airflow and Databricks to clean and unify 2M+ NYC arrest records, applying anomaly detection and structured transformations for KPI analysis in a scalable big data architecture using Snowflake

• Developed Power BI dashboards with crime KPIs across NYC’s 77 precincts, facilitating 100+ data-driven decisions for law enforcement

• Collaborated on data pipeline refinement to support script evaluations and operational forecasting