reset password
Azure Cloud Database Migration & LACPD New Hire Enrollment Process Web Application
Sponsored by Office of the Public Defender, LA County
Albert Chen, Norberto Gomez Rosales, Ryan Lee , Michael Loria, Simon Mai, Shahram Mehri Kalantari, Wilfredo Paz, Joshua Perez, Fabio Quintana, Ismael Valenzuela
Advisor: Chengyu Sun
Liaison: Mohammed Al Rawi, Bridgette Bates, Gratia Dsouza, Mohammad Janjua

Project Description:

PowerApps:

The Los Angeles County Public Defender's office is currently using two applications, PD-GO and Helpdesk. The database is stored in SharePoint lists. Tasked to migrate the database over to Microsoft Azure SQL database.

 

Enrollment App: Process of Enrollment and Approval System

Enrollment Web Application allows users to request custom forms generated via back-end communication with BOX and Adobe API, then saved within BOX after signing. 

Application is built in Angular that helps develop the web form that allows sending the user's data to the back-end system. 

 

 

Role Name email
Faculty Advisor Chengyu Sun

csun@calstatela.edu

Enrollment Sub-Team    
Project Lead Ryan Sean Lee RLee65@calstatela.edu
Backend Developer Norberto Gomez Rosales ngomezr@calstatela.edu
Backend Developer Ismael Valenzuela Ivalen13@calstatela.edu
Adobe-Sign Fabio Quintana fquint11@calstatela.edu
  Joshua Perez  
Power Apps Sub-Team Shahram Mehri Kalantari smehrik@calstatela.edu
  Simon Mai smai4@calstatela.edu
Power Apps Sub-Team Michael Loria mloria3@calstatela.edu
  Wilfredo Paz  
Box Albert Chen achen8@calstatela.edu
Resources
Fall Presentation Slides
Software Requirements Document (Fall 2021)
Software Design Document (Fall 2021)
Poster
Presentation
Spring Presentation Slides
Project Report
Software Design Document (Spring 2022)
Software Requirements Document (Spring 2022)
Enrollment Application Installation Guide
Project Code