Austin Scott Email & Phone Number

Irving, Texas, Us

Hanover, Md, Us

- Designed framework for new medallion architecture data warehouse to reduce environment of 6k+ tables to <50- Streamlined KPI reporting in Power BI for senior leadership, reducing model from 100+ separate data tables to ~12- Scripted new staging- and reporting-layer fact/dimension tables using PySpark in Microsoft Synapse

Boston, Ma, Us

- Rewrote foundational SQL (BigQuery) procedure reducing code by 77%, daily runtime by 58%, and annualized cost by $10k+- Facilitated CM engagement with via 14-member SME group and led 3 trainings for 500+ attendees to ensure org-wide education and buy-in on Cost solutions and processes- Led 2 org-wide cost sprints involving progress visualization, win recognition, and team-building activities for 300+ CM's, resulting in 100%+ achievement in 2 weeks- Developed SQL script to flag top SKU's missing discounts for upcoming major promotion, increasing discount coverage by over 10% in 6 days- Communicated daily with 100+ SRM’s to flag business critical insights e.g., cost increases, expired discounts, or uncompetitive pricing

Cincinnati, Oh, Us

- Supported launch of 20+ new items at retail through Excel/Power BI reporting, proactively identifying opportunities/issues to achieve 90%+ ACV in 6 weeks- Flagged pricing errors in real time through ETL processes and automated reporting, ensuring errors could be addressed in <24 hours and saving $100k's in potentially lost sales- Established new data pipeline process leveraging SQL, DAX/PowerQuery, knowledge sharing, standardized templates, and Power BI to reduce manual work of CIM's by 83%

Cincinnati, Oh, Us

- Rolled out new reporting program in 9 months leveraged by 700+ users & 21 Kroger divisions including creation/coordination of 20-user Center of Excellence and 9 offsite trainings- Eliminated 20+ manual legacy reports and saved hundreds of labor hours and $10k's annually via automation through Power BI, SFTP, and SQL- Developed new corporate scorecard providing visualization of value added to 80% of customers unreached by previous solutions- Evangelized new standard of excellence for leveraging data in customer relations which was adopted as SOP for 100 CSM's across all departments- Established new processes giving autonomy to division-level users, increased utilization of platform over 10x- Drove adoption of data-based culture by training 100+ users on new reporting tools and analytical techniques- Hired, trained, and managed 1 business intelligence analyst who then backfilled my role

- Arranged therapeutic placement options for 150+ children in state care by coordinating with 40+ programs statewide- Developed plan to more effectively divide coverage across 12 counties in our region which was still in use after leaving- Trained 3 new placement coordinators, led regional team of 3

Downers Grove, Il, Us

- Led shift between managers and closers, delegated end-of-night tasks to closing clerks - Trained 4 new produce clerks, supervised total team of 8

Master Of Business Administration (Mba)

Bachelor Of Arts (Ba), Music, Psychology