Vincent Aboy

Selected work / More internal tools for a data team

More internal tools for a data team

Built during my Woflow role, Mar 2024 to Dec 2025.

  • Flask
  • MySQL
  • Python
  • Excel macros
screenshot coming soon

Overview

Besides the larger tools, I built smaller ones for the people around me, with AI-assisted development.

  • Work-tracking dashboard. A multi-user Flask dashboard that tracks work, compares two reviewers' results, and shows KPIs, error summaries and trends. Teammates used it across my time in the role.
  • Team leader portal. Lets team leaders compare two reviewers' catalog sheets, group mismatches by teammate, save error summaries and download reports. Used by team leaders during 2025.
  • UPC lookup tools. A desktop tool where you paste a list of barcodes and it looks each one up, reads the results with OCR and an AI service, and returns structured product details in the order pasted. A companion watcher opens lookup sites when a barcode is copied. Packaged as Windows programs for teammates.
  • Excel macro workbooks. Earlier Excel versions of the categorization work, with macros that automated word lists, brand lookup and formatting into the catalog layout. Used by me and teammates.

Skills shown

Flask, MySQL, Google Sheets export, charts and KPIs, OCR, desktop apps (Tkinter, PyInstaller), Excel macros, building for the people next to me.