San Diego Community College District (SDCCD)

San Diego Community College District (SDCCD) is a public community college district based in San Diego, California. It provides a vibrant instructional environment complete with contemporary classrooms, labs, and recreational facilities. It also promotes student success through a variety of academic programs, including associate degrees, certificates, and transfer pathways to four-year universities. SDCCD is also noted for its commitment to diversity, equity, and inclusion, which fosters a friendly and inclusive environment for all students.

CHALLENGE:

San Diego Community College District’s primary goal in reaching out to Solidan was to stabilize their PeopleSoft production DBA services and receive PeopleSoft development support for Campus Solutions and PeopleSoft Financial Aid.

San Diego (SDCCD) faced the following challenges:

Complex and time-consuming financial aid processes, especially with FAFSA, led to delays in processing and increased error rates.

Projects were often delayed due to a lack of skilled personnel or inefficient allocation of resources.

  • Frequent system downtimes, database performance issues, and lack of scalability in PeopleSoft Campus Solutions.
  • Limited functionality and outdated features in Campus Solutions, coupled with recurring technical issues, hindered user experience and productivity.

SOLUTION:

Solidan began the engagement with SDCCD by ensuring systematic, efficient, and user-focused implementation of the solutions.

Solidan’s methodology:

  1. Assessment & Analysis
  2. Planning
  3. Implementation
  4. Testing
  5. Implementation

 

  1. Database Support for PeopleSoft Campus Solutions
    • Assessment & Analysis: Solidan conducted an in-depth analysis of existing database performance, identifying bottlenecks and areas for improvement.
    • Planning & Strategy: Solidan worked with SDCCD to develop a database optimization plan, focusing on load balancing, indexing, and partitioning to improve performance and scalability.
    • Implementation:
      • Solidan identified regular maintenance schedules were established for database optimization.
      • Automation tools for monitoring and early detection of potential issues were implemented by Solidan and the SDCCD team.
      • Scaled database architecture was deployed to accommodate increased demand.
    • Testing & Validation: Solidan along with SDCCD teams rigorously tested database updates and optimizations in staging environments before production deployment.
    • Ongoing Support: Continuous monitoring and support to resolve any emerging database issues was conducted by Solidan.
  1. Functional Support for Financial Aid, FAFSA Simplification, and Reporting
    • Requirements Gathering: Solidan collaborated with financial aid teams and stakeholders to identify pain points in the existing FAFSA process and reporting tools.
    • Design & Development: Solidan and SDCCD redesigned the FAFSA workflow to reduce complexity and improve user experience.
      • Developed automated workflows to streamline processing and reduce manual errors.
      • Built enhanced reporting tools to provide real-time insights and compliance tracking.
    • Testing & Feedback: Solidan conducted extensive testing of the new processes, gathering feedback from key users to ensure alignment with institutional needs.
    • Training & Documentation: Solidan provided comprehensive training to the financial aid team on using the new tools and workflows.
    • Post-Launch Support: Solidan delivered ongoing production support to handle any issues or changes needed post-launch.
  1. Quick Deployment of Resources for Projects
    • Resource Pool Creation: Solidan and SDCCD developed a resource pool of skilled professionals with expertise in PS Campus Solutions, database management, and financial aid functions.
    • Agile Project Management: Solidan used agile methodologies to ensure rapid deployment and iteration in response to project requirements.
    • Cross-Training & Flexibility: Solidan ensured that team members were cross-trained to provide flexibility, allowing for faster resource allocation.
    • Monitoring & Evaluation: Continuous monitoring of resources to ensure allocation efficiency and adjusted as needed to maintain project timelines.
  1. Development and PeopleSoft Support for Campus Solutions
    • User-Centered Needs Assessment: Solidan conducted a thorough assessment with end-users and administrators to identify gaps in functionality and pain points.
    • Custom Solution Development: Solidan developed custom features and enhancements based on user feedback, ensuring that the new capabilities aligned with the institution’s operational requirements.
    • Rigorous Testing: Utilizing a test-driven development approach, Solidan ensured new features were thoroughly vetted before deployment.
    • Continuous Integration/Continuous Deployment (CI/CD): Implemented CI/CD pipelines to streamline the development process and allow for faster delivery of updates and patches.
    • Post-Implementation Review & Optimization: Solidan conducted regular performance reviews post-implementation to ensure new features met user expectations and made adjustments as needed.

Result:

With Solidan’s help, SDCCD successfully stabilized their PeopleSoft production DBA services and successfully updated and implemented de PeopleSoft development support for Campus Solutions and PeopleSoft Financial Aid.

  • Database Support for PeopleSoft Campus Solutions (CS):
    • Delivered consistent and reliable database support for PeopleSoft Campus Solutions focusing on customization, system upgrades, and feature enhancements over a five-year period.
    • Ensured stability and performance of the system for an entire academic institution.
    • Specialized in database management, maintenance, and issue resolution to ensure smooth system performance.
  • Functional Expertise in Financial Aid:
    • Provided expert functional support for financial aid, including enhancements to the FAFSA simplification process.
    • Streamlined financial aid workflows, simplified the FAFSA process, and improved data accuracy. Reporting tools were enhanced for better financial aid tracking and compliance, ultimately speeding up financial aid disbursement.
    • Developed comprehensive reporting solutions and provided ongoing production support for financial aid-related projects.
  • Agile Team Deployment:
    • Demonstrated the ability to quickly assemble and deploy specialized teams for critical projects.
    • Ensured project teams were staffed with the right expertise, enabling rapid project initiation and delivery.