DesignIt (clients SeaGen and Microsoft), Seattle, WA (6/2020 – 9/2021)
Senior Project Manager, Business Intelligence
- Supported Pharmaceutical client BI Team with Power BI based analytics and reporting, database design and other technical areas (including project management)
- Served as Finance data SME (providing key leadership for multiple global Finance reporting projects)
- Introduced DevOps concepts to the BI Team (including techniques to implement version control for Power BI files)
Senior Data & Analytics Lead
- Built a full-year plan for Microsoft Cloud Marketing Team to manage and measure performance of Microsoft’s products’ blog and social properties
- Identified business process, data collection, reporting and metrics improvement areas
ZAM Apps, Remote (8/2015 – 11/2019)
VP of Operations
- Led the operations and remote development team for a small software company making operations and supply planning software for wineries (delivering features to streamline winery planning and communications)
- Managed and delivered multiple key initiatives across multiple products (including Barrel Planning, Harvest Scheduler, and master data restructuring
- Planned new feature development (from concept to delivery) using Agile as a framework for SQL database design (working directly with end users to transform user requirements into development objectives)
- Served as a business analyst to review client planning and forecasting business processes for transformation into a SAAS platform
- Supported clients with direct access via SQL to EZ demand database and built data visualizations in Power BI
- Managed and coached the daily activities of a globally distributed team of contract developers
- Provided front line customer support for end-user bug reporting and user training
- Oversaw DevOps for the organization
- Maintained 10 Linux and OS X servers, running Apache and MySQL
- Performed code reviews and testing on all code changes and deployed code changes
Slalom Consulting (client T-Mobile), Bellevue, WA (11/2014 – 8/2015)
Technical Project and Delivery Manager
- Managed implementation of SAP supply chain projects for a major telecom client
- Managed requirements gathering, acceptance criteria and dev team
- Provided updates to SVP level stakeholders (including information to obtain approval for future project phases during a phase of budget lock-down at the client)
- Maintained budget, scheduled weekly status reporting and project governance
Freelance Technical Consulting, Remote (4/2014 – 11/2014)
- Implemented server backup jobs and built back-end API for mobile application
- Conducted database design and technical development for web-based supply planning application
- Built a SQL database for a local environmental non-profit to track potential donors
Amazon.com, Seattle, WA (8/2011 – 4/2014)
Senior Program/Project Manager, Supply Chain
- Provided weekly Supply Chain KPI metrics reports (including DEA, concessions, unplanned upgrades and Jackpot)
- Reduced average order time in Jackpot by 3 days (to less than 2 days)
- Implemented Inbound Cross-dock (IXD) in multiple fulfillment centers (including sortable and non-sortable. Project saved $15M in 2012 and $21M in 2013
- Migrated team’s Excel based metrics to MEGA (an automated Amazon internal BI visualization system) allowing the team time to spend time analyzing metrics instead of creating metrics
- Built custom metric reports with Excel and SQL data pulls
Dreyers Grand Ice Cream / Nestle, Various (2000 – 8/2011)
Supply Chain Manager, Seattle, WA (2003-2011)
- Managed the supply chain technology team (including enhancements to Supply Chain Planning software, pulling data and building reports via Oracle SQL and stored procedures)
- Led a distributed project team (including outside consultants) to upgrade critical Manugistics Supply Chain software to the current version. Delivered project on time and at budget
- Acted as project lead for RFID pilot project for Wal-Mart
- Led multiple logistics sub-teams on new product launches and monitored new product performance
- Identified issues with a club store product (which resulted in changes in distribution and saved $90,000 in scrap product)
Production Manager, Union City, CA (2002-2003)
- Proactive in designing and launching a capacity evaluation tool that was integrated with the plant’s labor financial model
- Developed union shift leaders by training them to report their own results to their teams and by completing production reporting immediately following production (rather than at the end of the shift on overtime)
Production Scheduler, Union City, CA (2000-2002)
- Optimized production efficiencies, customer fill rates and balanced overtime production (increasing fill rates to 99%)
- Extended the plant’s planning horizon from two weeks to four weeks (allowing the purchasing group to operate more efficiently)
- Spearheaded effort to interface production recommendations with MRP system; interface developed to enable snack plant scheduling