Public Sector, State Government
Agile Development solution
.Net Architecture & SQL Server
Local Government Unit Debt Act (LGUDA) database gets modernized
The local government unit debt act (LGUDA) provides the procedure for Pennsylvania’s local government units to issue debt and tax anticipation notes.
This information was originally managed thru a legacy database system implemented in Access 2.0 and Oracle RDBMS. After years of working with this ever-aging platform, DCED made the decision to bring this important application up to their otherwise modern standards.
“Modernizing this critical application makes us more efficient, saves staff time and enables us to respond more quickly to our customers. Having this application re-engineered to the current state of the art Microsoft tools is important for us to assume support and continue innovation. We are looking forward to similar efforts with other legacy systems we have in use today.”Erich Loych
LGUDA 2.0 – A better system
Late in 2016, DCED approached Sigma regarding the migration and re-development of a legacy Access database system. This system, known as LGUDA, is primarily used for the tracking and management of financial articles (loans, grants, etc.) to qualified Commonwealth municipalities for the purposes of Community and Economic development activities. This system had been deployed years earlier and after at least one other attempt had not been successfully mitigated to include new client requests. Sigma met with DCED and the appropriate client/end-user personnel and arrived at a solution proposal for DCED consideration. In December, 2016, Sigma’s proposal was accepted and planning began.
The project kicked off in late January with a full-time development resource, a part-time lead architect and a part-time Project Director/Manager. A work plan was developed and approved with tactical work beginning immediately following kickoff.
Flexible delivery helps overcome challenges
An issue surrounding referential integrity was uncovered causing the change order process to be enacted. A change order to mitigate orphan records and solve several other cardinality issues was approved by DCED. Sigma was flexible in our delivery model and was able to re-level some tasks in order to essentially make up the project time and keep the overall effort on-track.
Typical project deliverables are included such as status reporting, communications plan, work plan, architectural diagram, process flow, user stories and test cases. To date, all deliverables have been met according to plan.
Microsoft stack including C#, ASP.NET, MVC, Framework 4.x, Angular JS 2.0, HTML, XML, ETL, MS Access, Access Basic, MS SQL Server
The client realizes significant benefit by performing this project. Besides the upgrade from a legacy, unsupported technology set, the resulting system will have scalability, adherence to industry and Commonwealth standards and be far more usable overall. The end state of this platform will allow for increased security, data integrity and an ability to integrate that did not exist in the prior version. Future plans for the system may include mobilization, cloud hosting, as well as other unplanned enhancements.