Sep 2024 – Dec 2025 — Buffalo, NY
Data Engineer — Operations Lead
University at Buffalo
- Designed and maintained a normalized database schema (people, inventory, transactions) with validation rules and data quality checks that ensured 100% transactional integrity.
- Reduced query runtime by 40% by building real-time KPI dashboards with advanced SQL — window functions, CTEs, aggregations — and optimizing the underlying queries.
- Engineered a production resource allocation pipeline using SQL window functions and time-series decomposition, validating business logic directly with stakeholders.
- Improved asset utilization efficiency by 25% through ETL query refactoring and schema redesign.
- Standardized and documented ETL pipelines for stock tracking, adding data quality gates and error-handling protocols that cut ingestion errors by 30% and shortened refresh cycles.