I'm currently building Abacus, an internal web application that presents an intuitive interface for exploring timeseries data collected from test rides. Abacus has a React front end with a Python FastAPI back end hooked up to SRAM's Databricks data lake. Each component of the application is wrapped in a Docker container for ease of development and deployment.
At the start of my internship, I was given a folder filled with over 4 years of monthly sales report spreadsheets from SRAM's 3rd party online retailer partners. The spreadsheets contained similar information, but each retailer formatted their reports differently. Additionally, as with any data set, not all of the data was valid.
My job was to develop a program that would automatically parse, clean, and export the data in a format that could be ingested into SRAM's sales database systems. I created a Python console application that used pattern matching and a suite of data validation methods to process the reports, outputting a CSV file containing clean data. After extracting the data, I built a Power BI dashboard to enable members of the sales team to explore the new dataset.
Graphic design is a skill I learned through game user interface development. I had the opportunity to apply those skills as a student employee at UCCS for most of my time in school. I was in charge of the Commode Chronicles, a community ad publication distributed around campus every two weeks. The job was a combination of custom ad design, working with community members, and upholding UCCS brand standards. I primarily worked with Adobe Illustrator and Adobe InDesign.