The Overview
Services: Oracle APEX Development Team Coaching and Augmentation, Consulting
Industry: Public Sector
This county is located in a large metropolitan area in the United States and meets the needs of 1.3 million residents by employing over 15,000 workers. The county’s IT group serves over 45 departments. It has long recognized the value Oracle APEX brings to its organization and has been developing applications with APEX for several years. Its IT team includes 10 full-time APEX developers and together they have built over 100 APEX applications. The county is therefore a mature user of Oracle APEX.
The Challenge
The county IT department needed to deliver several APEX application development projects of varied scope. At the same time, it wished to streamline the evolution of its existing applications.
Its APEX development group was self-taught and untrained in some of the Oracle best practices required for these new projects. They needed help from an experienced APEX consulting firm with a proven track record in APEX development. The selected partner would need to coach them, help complete the projects, establish best practices, and ensure future applications’ quality and performance.
The county chose Insum for the job.
The Solution
Insum collaborated closely with the county in the upgrade, maintenance, and enhancement of their existing applications through:
- Debugging, testing, troubleshooting, diagnosis, issue resolution, and support
- Software upgrades, performance tuning, utilities and management software, maintenance, documentation, and reporting
- Implementation of data models/database designs/ data updates
Insum also guided the county in the creation of new applications. This included:
- Needs analysis, requirements definition, design, development, enhancement
- Integration and change management of data from various sources with the APEX applications
- Data/commercial off the shelf (COTS) integration
- Software/data conversion and migration
- Project management, training, script creation, job scheduling, interfacing.
The Approach
Each county department has its unique combination of application complexity and developer skill levels. Applications are usually assigned to a dedicated developer who creates and maintains them.
As part of this application development project, Insum needed to uplift the county’s development team skills and knowledge to meet user needs more efficiently and thoroughly.
Through one-on-one coaching and group work sessions, Insum instilled best practices on essential skills including:
- How to ask business process questions
- Coding and formatting
- Structuring repositories for the code
- Building data models
- Refining development practices
Insum developed a shared knowledge base of best practices to improve productivity. It includes Insum-prepared guide documents on:
- Migration from early versions of APEX to 20.2
- How to implement the universal theme and create universal components
- Debugging APEX
- And more
Technology Used
The technology involved in the project was almost exclusively Oracle APEX. It also spanned a large portion of the application development platform’s history. APEX versions ranged from 4.2 to the recent version 20. A significant part of the work involved moving early versions of applications to APEX 5.1, then migrating these to version 20.2. APEX’s excellent backward compatibility kept these migrations virtually problem-free.
The Results
Insum provided the county with everything necessary to complete the described projects and come away with a solid base for internally generated quality APEX development and maintenance. County developers have improved their skills, collaboration, and productivity.
The code repository within the shared knowledge base has dramatically helped developer organization and made the implementation manager’s life much easier.
Daily morning scrums have enhanced communication between developers, as well as between developers and management.
Since the beginning of Insum’s work with the county, some 80 applications have gone into production. Insum supplies ongoing architecture and infrastructure advice throughout this continuing contract.
“Insum’s help in our adoption of best practices was crucial to our successful implementation of several new applications.”
-The county’s Director of IT Services
Work with Us
We appreciate your interest in learning more about Insum.
We want to learn about how we can work with you.
Do you have any questions or need more info?
Fill out this form, and a member of our
team will connect with you. Let's talk!
Some of our other case studies
Enhancing Laboratory Solutions with Oracle APEX and OCI
Learn more about how Agilab, a leader in laboratory informatics, leveraged Oracle APEX and Oracle Cloud Infrastructure (OCI) to deliver a scalable SaaS platform. Learn how innovative development, secure cloud infrastructure, and tailored solutions transformed pharmaceutical R&D operations.
Transforming Shipping Operations with Oracle APEX at Nidec Leroy-Somer
Discover how a leading manufacturer improved its shipping operations by integrating Oracle APEX with Oracle E-Business Suite, reducing processing time and increasing efficiency with a modern, real-time shipping interface.
Modernizing ERP for Construction with Oracle APEX and OCI
Discover how CGSI modernized its ERP solution, iXbat, for construction and public works using Oracle APEX and OCI. Improved scalability, security, and efficiency with rapid development and real-time analytics.
AP Automation with Oracle APEX and Document Understanding
Trailcon Leasing, a top transportation company in Canada, struggled with inefficient and error-prone manual invoice processing. Insum implemented an Oracle AI-powered solution to automate invoice parsing, reducing processing time from 30 minutes to 5 minutes. This automation improved accuracy and operational efficiency, allowing Trailcon’s finance team to focus on strategic tasks.
Banking on a Customer Application
Discover how an international banking group improved operational efficiency, reduced customer duplication errors, and enhanced data security through a custom Oracle APEX application integrated with Oracle EBS.
Creating a Supplier Portal with Oracle APEX
Learn how Insum replaced an inefficient and cumbersome Excel spreadsheet and implemented an Oracle APEX-based Supplier Portal that revolutionized data handling, increasing efficiency and accuracy for a global electronics manufacturer.
