NYC Operational Risk & Trend Analysis
Nov 2025 - Current (10 months)
Strategic Public Safety Audit (2015-2024) Conducted a full-stack audit of 22,000+ municipal records to optimize budget allocation for city operations.
🛠 Technical Implementation:
• Python (Pandas): Engineered an automated ETL pipeline to sanitize raw logs, handling negative integer outliers and regex cleaning.
• Advanced SQL: Utilized Window Functions (Rolling Averages, Pareto Analysis) to identify a permanent shift in daily risk baselines.
• Geospatial Intelligence: Mapped 54 "High Priority" zones that account for 50% of total risk exposure.
🚀 Outcome: Delivered a strategic recommendation to Executive Stakeholders to increase overtime capacity by 30% and reallocate resources to high-density clusters.