Digitization of PD Onboarding & Approval Process

 

Our Cal State LA Senior Design team is working closely with the Los Angeles County Office of the Public Defender as liaisons. The goals of this software project have shifted over the course of the 2020-2021 academic year. 

 

The project's focus has been twofold:

 

(1) (Initial) Migrate PD legacy repositories in DNN and FileMaker to Salesforce architecture.

- This initially entailed some weeks of research on the Salesforce platform via the Trailhead educational portal.

Gained an understanding of Salesforce's capacities for platform development, data modeling, data management, data security, and building apps using cloud technologies.

 

(2) (Current) Digitize and automate the onboarding process and approval workflow for PD employees and contractors.

- Currently, employee/contractor internet service requests are handled in a somewhat elaborate manner. For example, employees/contractors may need to request social media access (Facebook, Twitter, LinkedIn) on their work accounts. At the moment, employees/contractors complete these requests by filling out individual PDF forms, noting the type of internet service requested, and then forwarding them to the department. This may entail completing several forms depending on the type of service requested. These forms are then manually forwarded to various parties for signing/approval.

- Our team’s solution involves migrating the request process into a more user-friendly, intuitive one using a web form. With this, contractors and employees would simply enter the relevant information one time on our clear and minimal form rather than having to parse through some of the technical jargon on the PDF files themselves. We will automate the PDF generation process using the web form so the Public Defender still gets populated files at the end.

- Importantly, upon submission, the approval/signing process would be automated as well. Relevant parties (the employee, manager, security officer, etc.) would receive emails in the appropriate order to sign the required fields on Adobe Sign.

- To meet the requirements of this software project, we have assigned team members to build the Front-end system, Back-end system, Admin functionality, and PDF population functionality. Our roles have shifted throughout the academic year according to the project's needs.

- The Front-end system is built in Angular. It displays the web form and sends the user's data to the Back-end system.

- The Back-end system is built using Spring Boot and Hibernate. It receives employee/contractor data from the Front-end, stores it in an SQL database, and interfaces with the Adobe Sign API to populate PDFs and automate the signing process.

 

System Diagram

 

Team Leader - Javier Garcia

Section Leads:

Front End Development - Rawad Moussa, Tabassuma Torosa, Adrian Palomares, Paul Clef Ube
Back End Development - Audelia Valdovinoz, Javier Garcia
Documentation - Pierce Wei, Marlito Refuerzo, Christopher Rodriguez
PDF Mapping - Christopher Rodriguez, Pierce Wei, Rawad Moussa

 

Member Github Profiles:

Adrian Palomares - https://github.com/adrianpalomares

Tabassuma Torosa - https://github.com/rtiare

Audelia Valdovinoz - https://github.com/avaldov

Paul Clef Ube - https://github.com/PaulClefUbeCoding

Rawad Moussa - https://github.com/rawadmoussa

Pierce Wei - https://github.com/pierce-the-wei

Chris Rodriguez - https://github.com/Chrisr8195

Marlito Refuerzo - https://github.com/mrefuerzo001

Javier Garcia - https://github.com/jgarc659

Student Team
  • Javier Garcia
  • Rawad Moussa
  • Adrian Palomares
  • Marlito Refuerzo Jr
  • Christopher Rodriguez
  • Tabassuma Torosa
  • Paul Ube
  • Audelia Valdovinoz
  • Pierce Wei
Project Liaisons
Faculty Advisors