Data Analyst – Strategic Planning and Collaboration
Ocean Network Express – Richmond, VA
• Performed an in-depth cost analysis investigation using Google Sheet workbooks that utilized VLOOKUP’s, Array Formulas, and dynamic tariff rate tables on three paramount partner terminals; resulting in a total rebate to ONE of $261K+ (2026)
• Created an algorithmic, regular expression, user-friendly Apps Script that scans, sorts, and cleans data; as well as creates unique keys for Terminal Departure Reports from the Vessel Operations email inbox that instantly scans 3.1M+ emails and parses data from 1,500+ TDRs across three Google Sheets and a Data Studio visualization using JavaScript. (2026)
• Terminal Departure Report Email Apps Script utilizes data structures such as hash sets, trees, queues, merge sort, and timsorts. Algorithms in the Apps Script include Linearithmic Time Sorting O(n log n) and Linear Time Processing O(n)
• Terminal Departure Report project resulted in strengthening the relationships of 25+ international terminals with ONE; setting a new, company-wide precedent to track Terminal Departure Reports globally per General Headquarters in Singapore (2026)
• Admitted into ONE Mentorship Program as a mentee; one of 33 applicants selected out of a pool of 110 (2026)
• Appointed to AI Innovation Committee of ONE, overseen by President Takeshi Masuda of North American Headquarters, that sets a region-wide precedent for AI utilization and automation of tasks (2026)
• Architects cost analysis reports and data visualizations in Google Looker Production using LookML to extrapolate data; presents quantitative findings to executive leadership to help department make informed business decisions
• Deploys Google Gemini Technologies to create algorithmic Apps Scripts and Web Applications using JavaScript to automate, instantaneously parse, and sort logistical data; helping departmental teams reclaim hundreds of hours formerly lost to tedious, repetitive data entry