Andrew Robinson

Lead an amazing team of ML engineers, economists, data scientists, software engineers, and data engineers, responsible for a hitting the most financially impactful data topics at Shopify. A few examples: Building a cutting edge ensemble and its customized component methods (ranging from "traditional" statistical methods to more recent Deep Learning-centric models) to forecast Shopify's Gross Merchandise Volume (GMV), the most important input into Shopify's P&L, in turn unlocking a large array of scenario analyses for the Finance Team. Building dynamic causal inference pipelines (largely Double Debiased Machine Learning-focused) to estimate the indirect benefits of Shopify Capital and other product offerings to our merchants, and in turn incorporating those into investment algorithms. Building LLM-based tools and related UIs to allow R&D credit opportunity identification amongst Shopify's various documentation (e.g. GitHub repos, internal websites, etc.), prioritization scoring, and CRA form drafting. Enhancing commercial marketing Lifetime Value (LTV) models to provide more accurate and granular estimates, allowing for proper financial discounting (largely XGBoost-based models).

Building the future of AI/ML in Finance! Lead and coordinate the product roadmap for our Team of the Future. This includes working across data science, data engineering, product engineering, and finance. Major projects led or contributed to: -Leveraging machine learning to automate forecasting of our P&L, scenario-generation, confidence intervals, monthly variance analysis, and key strategic financial decision optimization. -Working to align our meta data enhancement strategy with Google's roadmap to facilitate natural language querying and automated dashboard generation. -Implementing anomaly detection and general engineering rigor across our data architecture, with emphasis on our externally reported metrics and key business KPIs. -Creating and leading training that covers SQL, Looker, Python, Machine Learning, and Econometrics for our team to constantly upskill. -Process automation via systems integration, API management, and Python training for individual teams. -Ad hoc analysis regarding our macroeconomic environment, 5-year capital structure, growth opportunities, and review of LTV:CAC forecasts.

Selected by CFO to lead Corporate FP&A, in large part in effort to bring data science and data automation to Shopify FP&A. Worked to develop forecasts of various aspects of Shopify's P&L using several machine learning methodologies (e.g. FbProphet, XGBoost, more "traditional" econometrics time-series) and ensembles thereof. Supported a broader "Finance Automation" workstream to maximize the availability of high granularity finance data. Led more "traditional" Corporate FP&A activities of forecasting, reporting, and special projects including capital structure planning, supporting corporate restructuring, supporting major acquisitions/diverstitures, and more.

(See previous role!)

Lead team of former strategy consultants and investment bankers responsible for 5-year strategy, strategic research, and long-term financial modeling of Shopify Fulfillment Network. Got to pair my finance background with my data science background by aligning my team's competitive strategy work with Network Design efforts performed by the Operations Research Team to frame SFN's long-term go-to-market and operational strategies, as well as long-term product roadmap and related research. Based on this framing, work closely with Product Acceleration (Corporate Development) on all acquisitions, investments, and strategic partnerships for SFN, from target identification, investigation, due diligence, and integration. Support Shopify Corporate FP&A and related teams (e.g. Control, Capital Markets) in Shopify's broader capital planning and structuring decisions. Examine financial strategies where applicable for SFN (e.g. real estate and equipment financing arrangements). Responsible for working with Investor Relations and SFN product leadership to support all Shopify Earnings and Board updates.

Promoted early to Associate Director. Built team that worked to inject sophisticated data science (e.g. machine learning, econometrics, and operations research) methods into Wayfair's algorithms. Examples include: Dynamic algorithms to quantify cost-speed trade-offs in delivery selection/inventory placement, leveraging beta-binomial-centric regression metrics to fuel pricing algorithms that dynamically listed low return/CLV-negative SKUs, applying GBM methods to lead-time estimation, and creating more rich ensembles for demand/capacity forecasting.

Led a mixed team of data scientists and MBA (former consultants) that attacked data-intensive problems, starting with Lost-in-Transit, but moving quickly to SKU delistment. A few other examples include: LTL Truckload selection algorithms Customer service response threshold tuning Small Parcel carrier services (e.g. FedEx and UPS) pricing and integration

Consultant in BCG's Boston Office, focused on Private Equity Due Diligence and Commercial strategy. Case work included: -Multiple Commercial and Vendor Due Diligences in industries including Pharmaceuticals, Consumer Finance, and Transportation -Quantum Computing Market Study and Real Option Valuation -Industrial Goods Total Shareholder Return for Fortune 100 Company -Growth and Financial Strategy for Consumer Technology company -Organizational Redesign and Cost Savings for Education Technology company

Completed 1-year MBA program at Kellogg School with a focus on Finance, Analytics, and Healthcare.

Senior Consultant in Deloitte's Public Sector Strategy and Operations Practice specializing in strategy, analytics, and design thinking. Work includes: -Reframing strategy, redesigning analytics architecture (statistical and technology), designing performance incentives, and drafting service line implementation strategy for Public Sector Healthcare entity, including business and clinical quality metrics. -Designed customer-centric payer-provider interface for Public Sector Healthcare Payer. -Conducted benchmarking study and developed Lean and Gamification solution for US Government adjudication agency. -Lead author of research study regarding successful trends in US Government activities in developing nations. -Developed social utility-adjusted framework for portfolio analysis of US Government acquisition agency.

Lead military planner for Governance and Economic Development in Eastern Afghanistan. Policy and strategic planning covers infrastructure, economic incentives, alignment of USAID programs, integrated civilian-military planning, agricultural development, rule of law, statistical assessments, and governance mentorship programs.

Deputy Secretary of the General Staff of the 1st Cavalry Division and Speechwriter for the Commanding General, Major General Daniel Allyn. Selected over approx. 1,800 junior captains and lieutenants to work at division level in order to study higher level decision-making of senior leaders. Managed taskings and internal processes of the Division Staff for the Chief of Staff.

Leader of a Mechanized Infantry Platoon of 43 soldiers. Responsible for the leadership, missions, training guidance, and all other requirements of the unit. Assumed leadership of platoon mid-deployment. Conducted combat operations in Baghdad, Iraq as part of Operation Iraqi Freedom. Also conducted civil affairs missions.

Received Merv Shalowitz Healthcare Enterprise Management Scholarship to study. Major in Finance, with coverage of M&A, LBO, Restructuring, and Derivatives. Dean's List.

Attended as Gates Cambridge Scholar, one of approximately 40 US students chosen for fully-funded study at Cambridge each year. Completed graduate program with highest attrition rate at University of Cambridge. Advanced coursework in Econometrics and Development Studies.

Distinguished Honor Graduate (top 5% in academics, military leadership, and physical fitness). Credit Hours: 154.5. Battalion Commander, one of eight cadets chosen to command units of 500 cadets in their senior years. Brigade Soldier of the Quarter, best soldier in a class of cadets not in its final year.