Challenge

Empowering Education Giants: Chicago Public Schools (CPS), a titan in the Illinois educational landscape, has 640 schools, a thriving community of 400,000 students, and 120 central office departments. With an illustrious workforce of 58 thousand teachers and staff, CPS is committed to delivering top-tier education to every student in every neighborhood. 

The SQL server-based Student Management System faced challenges with data accuracy, security, and accessibility. To address these issues, the system needed to be revamped to improve student data processing and provide administrators with real-time insights. This would allow for timely interventions and personalized educational strategies. 

Digital Transformation in Education: As one of Oracle ERP’s prime public sector patrons, CPS operates a web of databases, including Oracle E-Business Suite, PeopleSoft HR, and a SQL server-based Student Management System. They needed the expertise of skilled DBAs and Administrators to run projects such as application upgrades and support. 

Integrating Oracle EBS into CPS’s systems required aligning business processes, optimizing workflows, and ensuring data consistency. The education sector needed innovative PeopleSoft HR solutions for workforce management, including customized features for staffing, budgeting, and position control. The project also demanded continuous improvement and training to ensure CPS staff could effectively use Oracle ERP. 

Solution

As a trusted partner, we provided a comprehensive range of services to enhance CPS’s database management and application development capabilities. Here are some key highlights: 

Database Mastery: 

  • Provided essential DBA services, from routine database tuning to executing complex upgrades for servers and applications. 
  • Supported development initiatives across the entire enterprise application suite, ensuring optimal performance. 

Strategic Upgrades: 

  • Led a transformative initiative to upgrade ERP applications and data repositories, elevating CPS to high-performing Engineering systems such as Exadata and Exalytics. 
  • Crafted an enterprise-wide strategy for a seamless transition into the Oracle Cloud Infrastructure. 

Application Development Excellence: 

  • Developed Java-based applications utilizing Oracle ADF, JavaScript, and Oracle Applications Framework, seamlessly integrating them with Oracle EBS, Hyperion, and other systems. 

PeopleSoft Prowess: 

  • Deployed the Oracle PeopleSoft Project Manager, business analysts, and technical resources to enhance and support PeopleSoft applications. 
  • Played a pivotal role in the successful implementation of the Oracle E-Business Suite through the expertise of our Oracle Business Analysts. 

Outcome

 Operational Excellence: 

  • Our DBA services ensured consistent and reliable operation of CPS databases, fostering an environment of operational excellence. 

Performance Revolution: 

  • Implemented Exadata, resulting in a remarkable improvement in performance, notably reducing the turnaround time for complex reports from 15 minutes to just 2 minutes. 

Seamless Support Continuity: 

  • Our consultants have provided ongoing, unwavering support for Oracle and PeopleSoft applications, ensuring CPS remains technologically adept in the dynamic educational landscape. 

Meet with us!

Talk to a Krasan Consulting Project Specialist to get started.

Subscribe to our
Get updates about Krasan Consulting in your inbox.
Newsletter
WBENC WBE & WOSB Caltrans DBE SAM Registration for Krasan WMATA DBE National Minority Supplier MBE Illinois CMS WMBE & Good Standing Indiana DBE City of Chicago DBE Virginia WMBE Virginia DBE
Supplier Codes
Applications Software Programming Services, Custom Computer (NAICS, 541511) Computer Software Consulting Services or Consultants (NAICS, 541512) Software Installation Services, Computer (NAICS, 541519) Business Management Consulting Services (NAICS, 541611) Software, Microcomputer (Not Otherwise Classified) (NIGP, 20880) Computer Software Consulting (NIGP, 91829) Computer Network Consulting (NIGP, 91830) Governmental Consulting (NIGP, 91858) IT Consulting, (Not Otherwise Classified) (NIGP, 91871) Management Consulting (NIGP, 91875) Organization Development Consulting (NIGP, 91883) Procurement Consulting, Including Specification Development & Contract Consulting (NIGP, 91887) Quality Assurance & Control Consulting (NIGP, 91888) Strategic Planning & Consulting (NIGP, 91890) Data Conversion Services (NIGP, 92024) Processing System Services, Data (Not Otherwise Classified) (NIGP, 92039) Programming Services, Computer, Including Mobile Device Applications (NIGP, 92040) Software Maintenance & Support Services (NIGP, 92045) Software Updating & Upgrading Services (NIGP, 92046) Support Services, Computer, Includes Computer Warranties (NIGP, 92047) Teaching & Training Materials For Computer Science/Technology (Printed or Magnetically Stored) (NIGP, 92074) Technical Writing & Documentation, IT Services (NIGP, 92075) Website Development (NIGP, 92078) Training, Computer Based, Software Supported (NIGP, 92091) Computer Management Services (NIGP, 95823) Project Management Services (NIGP, 95877)
Applications Software Programming Services, Custom Computer (NAICS, 541511) Computer Software Consulting Services or Consultants (NAICS, 541512) Software Installation Services, Computer (NAICS, 541519) Business Management Consulting Services (NAICS, 541611) Software, Microcomputer (Not Otherwise Classified) (NIGP, 20880) Computer Software Consulting (NIGP, 91829) Computer Network Consulting (NIGP, 91830) Governmental Consulting (NIGP, 91858) IT Consulting, (Not Otherwise Classified) (NIGP, 91871) Management Consulting (NIGP, 91875) Organization Development Consulting (NIGP, 91883) Procurement Consulting, Including Specification Development & Contract Consulting (NIGP, 91887) Quality Assurance & Control Consulting (NIGP, 91888) Strategic Planning & Consulting (NIGP, 91890) Data Conversion Services (NIGP, 92024) Processing System Services, Data (Not Otherwise Classified) (NIGP, 92039) Programming Services, Computer, Including Mobile Device Applications (NIGP, 92040) Software Maintenance & Support Services (NIGP, 92045) Software Updating & Upgrading Services (NIGP, 92046) Support Services, Computer, Includes Computer Warranties (NIGP, 92047) Teaching & Training Materials For Computer Science/Technology (Printed or Magnetically Stored) (NIGP, 92074) Technical Writing & Documentation, IT Services (NIGP, 92075) Website Development (NIGP, 92078) Training, Computer Based, Software Supported (NIGP, 92091) Computer Management Services (NIGP, 95823) Project Management Services (NIGP, 95877)
Supplier Codes
Contact our TOPs team to review the contract with us.
Contract Request
Contact our TOPs delivery team to review the process with us.
Get in touch with the team