Jack Macdorman Email & Phone Number

Los Angeles, Ca, Us

Los Angeles, California, United States

• Engineered a dynamic OTIF reporting platform in Palantir Foundry, allowing various stakeholders from Inventory, Production, and Logistics to understand, in detail, areas of success and failure resulting in an increase from a 50% OTIF score in December 2023 to a 85% OTIF score in September 2024• Lead the integration of EU inventory data into Palantir Foundry by facilitating collaboration between EU SIOP leadership and Palantir Engineers, keeping both parties accountable to necessary tasks and timelines• Executed a complete revamp of Supply Chain KPI reporting systems using Palantir Foundry to integrate multi-source data into dynamic dashboarding systems, allowing Supply Chain team leaders to receive real-time, actionable insights• Conducted SKU performance analysis to categorize products by financial and operational impact, allowing leadership to make directional decisions toward profitability regarding product mix, marketing efforts, and production planning• Developed a sales forecast vs actuals Excel model to evaluate the effectiveness of historical demand forecasting passes, allowing the Director of SIOP to communicate potential areas of risk with the sales and production teams• Carried out data validation exercises for 3PL warehouse inventory ingestion into Palantir Foundry, identifying and correcting several attributes across all sites including health status bucketing, UOM conversions, and expiry checks• Supports all Supply Chain team members with ad hoc analysis projects across all verticals of Supply Chain (Inventory, Production, Procurement, Logistics, etc.)

Los Angeles, California, United States

Founding team member of a “for students, by students” quick commerce tech start-up that operates exclusively in college markets using electric scooters to provide 10-minute deliveries of convenience goods to town residents (YC W20)• Oversaw the P&L for the second largest storefront, USC, where monthly revenue increased 2X in six months• Implemented end-to-end operations, including weekly employee schedules, supply chain management (ordering, 3-way financial matching, restocking, supplier relations), marketing, risk mitigation, and overall store maintenance• Managed 50+ employees, including hiring, training, safety, progressive discipline, and career mobility• Improved SOPs for all storefront processes reducing out-of-stock by 20% and late deliveries by 10% in six months• Redesigned company SRM spreadsheet to align all stores’ SRM strategies, reducing time wasted in this area by 30%

Los Angeles, California, United States

• Compiled investor data decks to secure a $12 million Series A round at a $33 million valuation, led by Volition Capital• Evaluated company tests/ideas to optimize processes & features for growth, operational efficiency, and profitability• Price Elasticity of Demand: used A/B price testing for various products & categories, in order to optimize pricing of specific SKUs which increased the total profit of those SKUs by 15% and reduced total store labor by 10%• Employee Labor Model: analyzed employee efficiency & satisfaction indicator metrics to revamp the employeewage model, reducing total labor costs by 25% while maintaining employee satisfaction & safety levels• Produced data tools for other departments to use in order to increase efficiency and come to actionable conclusions• Scheduling Matrix: table generated each week that projected the number of employees needed at each store by hour & day of the week based on seasonal trends as well as the previous month’s WoW order growth rates• Constructed new database schema analytics tables to increase biweekly development cycle capacity by 50%

Los Angeles, California, United States

• Learned SQL, the Duffl Production database, and how to use BI tools like Metabase for data visualization• Identified & defined departmental validation metrics to create relevant dashboards, alerts, and reports

Los Angeles, California, United States

• Established & managed the UCLA Dyeislife Instagram account achieving a reach of 1,500+ views per feed post

Los Angeles, California, United States

• Co-founded a houseplant growth & sales business marketed to college students surrounding the UCLA campus area • Managed operations including supply chain, cultivation labor, packaging materials, and pick-up/delivery fulfillment• Utilized the basics of HTML to design & build a dynamic 3-page website with product & contact information• Built the database diagram & mySQL database to record all aspects of the business (transactions, labor, materials, etc)

San Diego County, California, United States

• Organized, coached, and supervised various sports, crafts, and educational activities for children (ages 4-13) at Knock Around Summer Camp UCSD• Developed both leadership and interpersonal skills with co-workers and children, as well as honed my ability to work collaboratively with people of all ages, backgrounds, and developmental levels

Bachelor'S Degree, Economics, Graduate

Activities and Societies: Honors College - Letters and Science, Sigma Phi Epsilon - VP of Member Development

Graduate

Activities and Societies: National Merit Finalist, Varsity Soccer, Varsity Badminton, Link Crew - New Student Orientation Leader