Data Leadership
IT Capstone Course – Data and Communication Manager
Directed data strategy for a year-long capstone project, establishing data governance protocols and transforming complex datasets into executive-level dashboards that drove organizational decision-making.
- Architected a comprehensive data pipeline that reduced reporting latency by 72% through Azure Data Factory automation and optimized SQL stored procedures
- Developed machine learning models in Python (scikit-learn) that predicted project risks with 88% accuracy, enabling proactive mitigation strategies
- Engineered a Power BI data model with 15+ related tables that became the organization's single source of truth, eliminating $25k in duplicate reporting costs
Power BI
SQL Server
Python
Azure
DAX
Predictive Analytics
Fenwick Library Modern Checkout System
Revolutionized library operations by developing a data-driven checkout system with embedded analytics that transformed 3 years of historical data into actionable intelligence for resource optimization.
- Implemented an ARIMA time series model that predicted daily checkout volumes within 7% accuracy, enabling perfect staff-to-demand alignment
- Built a Python-based recommendation engine using collaborative filtering that increased patron engagement by 42%
- Automated data cleaning processes that reduced preparation time from 8 hours/week to 45 minutes through custom Python scripts and Power Query transformations
Python
Power BI
SQL
Pandas
Statsmodels
Inventory Intelligence
Smart Inventory Management System
Designed an AI-powered inventory solution that reduced carrying costs by 28% through advanced demand forecasting and real-time analytics integration across 5 warehouse locations.
- Developed a Prophet forecasting model that reduced stockouts by 63% while decreasing excess inventory by $150k annually
- Created geospatial heatmaps in Power BI that identified optimal stocking locations, reducing picking time by 52%
- Implemented real-time Azure Stream Analytics that processed 500+ IoT sensor events per second, enabling live inventory tracking
Power BI
Azure
Python
Prophet
SQL