Team: Cliff.json

Team Participants:

  • Joseline Ly
  • Justin Karbowski
  • Jose Flores
  • Jacob Acosta
  • Jean Paul Collazo Arguedas
  • Seonghoon Cheon

“Instead of spending time, our users earn time back. Our product gives our users back 6 weeks of time per year by eliminating the drudgery of downloading, analyzing, and manually auditing 7,000 expense reports per quarter.”

Problem

The team aimed to mitigate financial risk for the CSU system by automating the ingestion of expense reports, identifying policy violations, tracking spending patterns, and creating reports for management and budgeting purposes. The existing manual process of downloading, analyzing, and auditing 7,000 expense reports per quarter was time-consuming and inefficient.

Technical Solution

The team developed a web-based platform that streamlines the expense report auditing process. The solution leverages AWS services like Lambda functions, S3 buckets, Glue, DynamoDB, and API Gateway. It automates the ingestion of expense reports, cleans and formats the data, and provides interactive dashboards for easy analysis. The dashboards display policy violations, spending patterns, and reports tailored for management’s needs.

Showcase

Presentation RecordingA recording of AI Summer Camp students presenting their project.
SlideshowThe accompanying slides shown in the video.
Source CodeAll of the code and assets developed during the course of the AI Summer Camp.

About the DxHub

The Cal Poly Digital Transformation Hub (DxHub) is a strategic relationship with Amazon Web Services (AWS) and is the world’s first cloud innovation center supported by AWS on a University campus. The primary goal of the DxHub is to provide students with real-world problem-solving experiences by immersing them in the application of proven innovation methods in combination with the latest technologies to solve important challenges in the public sector. The challenges being addressed cover a wide variety of topics including homelessness, evidence-based policing, digital literacy, virtual cybersecurity laboratories and many others. The DxHub leverages the deep subject matter expertise of government, education, and non-profit organizations to clearly understand the customers affected by public sector challenges and develop solutions that meet the customer needs.