Thomas Olache

Experience

• 

  Arbitrage Web Scraping Analytics

  Jan 2013 - May 2016

  Entrepreneur

  Co-founded business to complete arbitrage on high value used productsFocus: Web-Scraping Automation, Business Development, Negotiation• Developed Python web scraping script to identify arbitrage opportunities• Automated daily script with Microsoft Task Scheduler and stored results in PostgreSQL database• Improved average profit margins to 30% and yearly revenues over $100,000 from 2013 to 2016

• 

  American Airlines

  Jun 2016 - Jun 2020

  Hired to develop new automated staffing model and guide management on the journey to the new solutionFocus: Change Management, Leadership, Process Automation1. Developed first budget staffing model for maintenance warehouses• Developed and scaled the model, automating the data pipeline using SQL, Tableau, and Excel• Gathered support for project, communicating with management at multiple levels• Collaborated with Operations Research team to improve model using machine learning• Model used for 2019-2020 budget, resulting in reallocation of staffing and hiring freeze2. Developed heuristic training scheduler to help schedule 1000+ employees• Gathered requirements from training department• Developed robust Excel VBA solution, allowing user to update constraints as needed• Reduced baseline schedule development time from 24 man hours per schedule to minutes• Scheduler used in production, ensuring all employees received training prior to system cutover3. Identified fallout from inventory system data migration• Extracted data from Teradata data warehouse and Oracle database with SQL queries• Developed R script to extract and clean fallout data• Resolved more than 90% of fallout4. Hired, supervised, and mentored a summer intern through summer 2019• Developed intern job description and interviewed multiple candidates• Developed weekly plan for the intern• Brought intern up to speed on the project and taught her to code SQL queries• Intern's stellar performance led to a job offer following the internship Show less Senior Industrial EngineerFocus: Workforce Planning, Demand Planning, Continuous Improvement1. Improved predictive passenger transaction duration model• Identified two additional features with potential to improve baseline model• Retrained linear regression with all three features• Reduced test SSE, reducing staffing inaccuracies2. Developed staffing model for AA passenger rebooking agents• Extracted historical flight delay and cancellation data from data warehouse using Teradata SQL• Created process maps for current passenger rebooking operations at multiple domestic airports• Conducted time studies to determine transaction time distributions• Created Erlang model in Excel to determine required staffing to achieve SLA3. Supported multiple domestic and international airport master plans• Extracted data from Teradata data warehouse and conducted demand/capacity analysis in Excel• Conducted sensitivity analysis using discrete event simulations in SIMIO• Developed infrastructure layouts in AutoCAD• Implemented multiple layouts across domestic and international airports Show less Junior Industrial EngineeringFocus: Continuous Improvement, Process Automation, Demand Planning1. Developed scalable, low-cost options to improve TSA checkpoint throughput• Collaborated with TSA Innovation Task Force to pilot solutions to reduce TSA checkpoint queues• Tested low-cost options at multiple airports• Pilot results showed a potential throughput increase of at least 10%2. Developed Excel VBA macro, reducing management daily staffing task from 2 hours to minutes3. Supported multiple airport layout redesigns and terminal moves• Extracted data from Teradata data warehouse and conducted demand/capacity analysis in Excel• Conducted sensitivity analysis using discrete event simulations in SIMIO• Developed infrastructure layouts in AutoCAD• Implemented multiple layouts across domestic airports Show less

  • Senior Analyst, Supply Chain Analytics

    Apr 2018 - Jun 2020

  • Analyst III, Industrial Engineering

    Apr 2017 - Apr 2018

  • Analyst II, Industrial Engineering

    Jun 2016 - Apr 2017
• 

  ALDI USA

  Oct 2020 - now

  Team Lead for the Assortment Planning Analytics Team at ALDI USAFocus: Leadership, Strategy, Advanced AnalyticsTeam Lead (May 2022 - Present)1. Stood up Assortment Planning Analytics team• Developed job descriptions and job posts• Developed interview questions• Conducted analyst and intern interviews• Hired 2 analysts and 1 intern2. Direct Leader for Analyst(s) and Intern(s)• Conducted skills gap analysis, acquired funding for training, and executed training plan• Conducted daily standups3. Program Management• Developed 1 year product roadmap4. Team Accomplishments• Developed new divisional product performance dashboard rolled out to 30+ directors• Developed a unified dashboard for item level reportingSenior Data Analyst (Aug 2021 - May 2022)1. Seasonal Product Optimization• Developed the data pipelines, logic, and visualization required to report on seasonal product data• Developed an integer program to identify the seasonal product mix to maximize total season value• Developed an associated Tableau dashboard to communicate the optimal product list to Buying Directors2. Assortment Planning Decision Support Dashboards• Integrated new metrics into unified dashboard to simplify reporting across National Buying Department• Developing more intuitive visualizations by transitioning from a tabular to graphical format3. Brand Reporting• Conducted extensive data quality review and correction of Brand data• Developed the data pipelines, memos, and dashboard for the monthly VP brand count review Show less First employee hired to develop the Assortment Planning capability at ALDI USAFocus: Strategy, Change Management, Process Automation. Support a team of Directors.1. Assortment Planning Strategy• Developed hurdle rates to ensure tested products achieve ALDI’s business goals prior to full introduction• Developed aggregate metric to quantify total product value and facilitate product rankings• Developed distinct product statuses to identify low performing products for potential churn• Developed presentations to convey technical concepts in a simple way. Presented to the Group/Managing Director level. My director presented to the CEO level. Strategies were accepted and now have been adopted across the ALDI USA National Buying department.2. Assortment Planning Decision Support Dashboards• Developed dashboards to support the Buying Department for continuous product performance evaluation• Dashboards viewed by leadership up to VP level3. Piloted, Scaled, and Automated Quarterly Product Assortment Planning Process• Automated data importing and cleaning using R scripts• Simplified communications by developing email templates• Developed a standard operating procedure to ensure transfer of knowledge Show less

  • Manager, Assortment Planning Analytics

    Feb 2023 - now

  • Senior Data Analyst, Assortment Planning

    Aug 2021 - Feb 2023

  • Data Analyst, Assortment Planning

    Oct 2020 - Aug 2021