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.
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
- Javier Garcia
- Rawad Moussa
- Adrian Palomares
- Marlito Refuerzo Jr
- Christopher Rodriguez
- Tabassuma Torosa
- Paul Ube
- Audelia Valdovinoz
- Pierce Wei
- Backend Source Code (.zip)
- Enrollment Application Info (.pdf)
- Enrollment Forms (.zip)
- Fall Presentation (.pdf)
- Fall Presentation (.pptx)
- Fall Presentation (YouTube)
- Frontend Source Code (.zip)
- Installation Guide
- PDF Form Mappings (.xlsx)
- Project Report (Spring 2021) (.docx)
- Project Repository
- Software Design Document (Fall 2020) (.docx)
- Software Design Document (Spring 2021) (.docx)
- Software Requirements Document (Fall 2020) (.docx)
- Software Requirements Document (Spring 2021) (.docx)
- Spring Presentation (.pdf)
- Spring Presentation (.pptx)
- System Diagram