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
Market Analysis
NYC Airbnb Market Analysis Dashboard
Developed an interactive Power BI dashboard analyzing 50,000+ NYC Airbnb listings to uncover pricing trends, availability patterns, and neighborhood performance metrics for optimal rental strategy.
- Identified Manhattan entire homes command 128% price premium over shared rooms through comprehensive price distribution analysis
- Created geospatial visualizations revealing Brooklyn private rooms as most available (42,150 days/year) while maintaining 85% occupancy rates
- Implemented dynamic pricing benchmarks showing optimal rates by neighborhood/room type, helping hosts maximize revenue by 15-22%
- Discovered seasonal demand patterns showing 35% higher rates in summer months with 12% longer average stays
Power BI
DAX
Power Query
Data Modeling
Data Visualization