Ramandeep Brar

System Integration Analyst @The Essential Baking Company

Seattle, WA, US

Led cross-functional analytics initiatives to improve production throughput, delivery performance, and return trends, driving strategic changes that resulted in $500K+ in annualized operational savings.• Designed and maintained 15+ SQL views and Power BI dashboards, automating performance tracking across inventory, finance, and operations reducing manual reporting workload by 70% and cutting data delivery time from days to minutes.• Developed custom KPIs (Fill Rate, Return %, Delivery Lag) with production and logistics teams, enabling performance benchmarking and contributing to a 20% increase in on-time deliveries.• Built an early warning system for shelf-life risks, allowing proactive staging and rerouting of perishable goods reducing spoilage by 17% over 3 months.• Created a return rate prediction model in Python (Pandas, scikit-learn), enabling leadership to anticipate high-return rate accounts and products and adjust procurement accordingly.• Partnered with executives to analyze customer and product-level profitability, influencing repricing of unprofitable SKUs and identifying low-margin accounts, contributing to a 35% boost in product-level profitability.• Drove end-to-end data governance across ERP and reporting systems, ensuring data consistency for mission-critical dashboards used by finance, operations, and supply chain teams.• Acted as a strategic bridge between technical teams and business leaders, translating stakeholder requirements into scalable, maintainable analytics solutions.

Green River College

Associate of Science - AS

University of Washington

Information Technology