Big Picture Hub

Objective

‍To consolidate multiple fragmented applications into a single, unified portal, establishing a consistent design standard and a shared database to remove operational bottlenecks and licensing constraints.

Audience

‍Agency contractors requiring an efficient data submission process and internal data analysis teams responsible for reporting.

Design & Development Process

‍The project was initiated as a strategic architectural shift to address a fragmented ecosystem where various applications, originally built in the Microsoft environment, lacked consistent design standards and a common database. This fragmentation increased maintenance complexity and created significant licensing barriers for contractors.

Moving away from the Microsoft ecosystem, the development began with the setup of a shared SQL database as the central data source. By building directly within the JetAdmin no-code environment without external design mockups, I focused on solving the challenge of creating complex data-entry forms. These forms featured hierarchical and grouped layouts, as well as connected and dependent fields that required thoughtful structuring to ensure data integrity. To maintain workflow efficiency, I utilized JetAdmin’s internal tools to build automated notification processes that ensure timely communication across teams.

Outcomes & Achievements

• Unified the user experience for contractors by providing a single point of access, significantly reducing the time spent navigating disparate systems.
• Enhanced data analysis capabilities, allowing the team to process reports more effectively due to the standardized data structure.
• Simplified maintenance by standardizing how applications are built and managed using the same technology stack.
• Removed licensing constraints, providing the agency the flexibility to scale the solution for other clients without being tied to specific software requirements.