Case Studies

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

Chief Information Officer, PA Department of Community & Economic Development

LGUDA 2.0 – A better system

History

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.

January, 2017

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

 

February 2017

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.

 

Deliverables

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.

Technologies

Microsoft stack including C#, ASP.NET, MVC, Framework 4.x, Angular JS 2.0, HTML, XML, ETL, MS Access, Access Basic, MS SQL Server

Value

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.

PITTSBURGH OFFICE
2026 East Carson Street
Suite 200
Pittsburgh, PA 15203
Phone: 412.712.1070
Fax: 412.712.1033
info@sigma-resources.com

HARRISBURG OFFICE
Strawberry Square
320 Market St.,  Suite 473B East
Harrisburg, PA 17101
Phone: 717.614.0605
jbriel@sigma-resources.com

WASHINGTON DC OFFICE
11654 Plaza America Drive
Suite # 218
Reston, VA 20190
Phone: 703.268.3924
AKnispel@sigma-resources.com