Miles Lucey Email & Phone Number

Santa Monica, California, Us

• Spearhead analytical initiatives to enhance the company's constrained optimization model responsible for product assignments in beauty subscription boxes• Conduct A/B tests to evaluate changes in voluntary churn pre and post algorithm updates, investigate the impact of similar and repeat products on customer experience, and assess the correlation between measured algorithm success and customer satisfaction• Maintain Tableau dashboards and corresponding analytics Python and SQL codebase for company’s merchandising, customer care, and operations teams• Automated freight invoicing process across ten shipping carriers using Python, SQL, and Tableau, enabling company to gain needed visibility on incremental shipping costs across a variety of subscription, e-commerce, and promotional programs, quickly reconcile billing errors with freight carriers, and track monthly expenses with Tableau visualizations and a robust accruals process

Santa Monica, California, Us

• Automated company's freight invoicing process for company's three largest shipping carriers (~95% of monthly shipping volume) using Python (Pandas, NumPy, and PySpark) and SQL; Project enabled the company to gain needed visibility on incremental shipping costs across a variety of subscription, e-commerce, and promotional programs, quickly reconcile billing errors with key stakeholders, and ensure on-time payments• Automated the monthly freight cost accrual process for the company's largest subscription business (~3-4 million monthly shipments across 4-6 shipping carriers) and brand incubator (four brands) using SQL and Python (Pandas, NumPy, and PySpark)• Developed Tableau dashboard to track fulfillment, delivery, and sales of ecommerce orders from BFA's four Shopify stores; Dashboard enabled Operations team to ensure vendors meet service-level agreements, swiftly resolve issues with 3PL providers and shipping carriers, and anticipate potential fulfillment bottlenecks before they happen• Developed Tableau dashboard to track the root cause, cost, fulfillment location, and timing of accommodations and refunds orders; Project enabled company's warehouse team to better monitor error rates across multiple 3PLs and customer care team to track sources of accommodations and refunds and respond accordingly

Santa Monica, California, Us

• Provided analytical support for company's shipping and warehouse teams; Developed SQL queries to retrieve needed information and Python and Visual Basic scripts to automate processes• Developed Visual Basic scripts and Excel template to automate allocation of ~3.5 million monthly assembled subscription packages between warehouses for production and project volume of packages that will require additional processing/assembly• Developed Visual Basic scripts and Excel template to execute a monthly inventory transfer of 400-500 SKUs between warehouses based on projected regional demand• Streamlined the company's inventory management process using SQL and Python (Pandas, NumPy, and PySpark) in a Databricks notebook; Automation provided needed warehouse-level and inventory channel-level visibility on SKU volume to prevent overallocation of orders• Led execution of monthly shipping program for ~3.5 million orders (e.g. assigned subscription orders to carriers, hubs, and warehouses, coordinated with carriers and warehouses, monitored production and shipping performance, managed inventory across warehouses, audited freight invoices, etc.)

San Francisco, Ca, Us

• Analyzed compensation data from SEC filings (10-K, DEF 14A, and 8-K), compensation surveys, and proprietary databases to help public and pre-IPO clients make pay decisions• Composed client-ready executive compensation, Board compensation, equity dilution, and ad hoc research reports using PowerPoint and Excel• Assessed large volumes of equity grants of varying types, values, and vesting schedules to ensure executives had sufficient retention hold without adversely affecting shareholder dilution• Led onboarding efforts for all new Associates over two recruiting cycles; created comprehensive training documents in PowerPoint and Excel detailing Compensia's core analyses• Developed Visual Basic macros to automate data cleaning and visualization formatting

San Francisco, Ca, Us

• Collected compensation data from SEC filings (10-K, DEF 14A, and 8-K) and visualized in Excel• Researched financial metrics and industries using Google Finance and annual reports in order to create custom peer groups of 15-25 companies for benchmarking client pay• Formalized Compensia's peer review process by composing comprehensive data set checklists in Excel and instituting the checklists as an additional step in completing project work• Highest billing associate in 2017

Pleasanton, California, Us

• Analyzed documents and legal filings to draft comprehensive sections of expert witness reports for intellectual property, commercial damages, and antitrust litigation cases• Performed industry research and organized large amounts of information in Excel and PowerPoint to help expert witnesses understand industries and key players• Reviewed reports and financial damages Excel models to ensure highest quality of work for clients

Denver, Colorado, Us

• Collaborated with three interns to present Localwise's mission to Bay Area businesses in order to add more companies to Localwise's job board• Presented Localwise's job board platform in lecture halls at UC Berkeley and Berkeley City College to encourage students to use the platform as a tool when applying to positions at local businesses• Distributed 50-100 flyers per week to advertise Localwise's platform• Conducted industry research using online sources and in-person interviews to compose blog entries for Localwise's website and help the company optimize for long tail keywords searches

Berkeley, Ca, Us

• Formatted Excel spreadsheets to ensure Stata scripts load data accurately and efficiently• Uncovered and summarized 3-5 academic journal articles per week for graduate students’ literature review• Created data set summary statistics tables in Stata for graduate students' PhD thesis

• Presented Roonga's mission to hotel receptionists and successfully obtained manager contact information for 77 Bay Area hotels• Arranged meetings with hotel managers through emails, cold calls, and in-person pitches to encourage managers to use Roonga's platform to donate hotel goods/inventory to homeless shelters• Launched recurring donation partnerships between Roonga and five major Bay Area hotels

Master'S Degree, Computer And Information Technology (Mcit), Computer Science

Bachelor Of Arts (B.A.), Economics

Certificate, Data Analytics Bootcamp