LDC hired Direct Technology to evaluate the current APEX POC and determine if to proceed with expanding the current POC or start with a fresh APEX application.

The project engagement was to migrate and expand the existing MS Access application to an APEX 5 .1 application. The new application will retain previous information and expand to allow district office to request work online. Also the new application will import 15 years of historical data into the system. We worked LDC DBA to set up test and production APEX environment and 12c database. We designed and developed an on-prem application which included: 1) Online submittal form for District Offices to submit work requests; 2) Ability to create reports with stored data; 3) Setup Active directory Sign on; 4) Migrate historical data to new application; 5) Create security roles that allow selective access to certain areas of the application to certain roles; and 6) Store submitted PDF’s in database.

Direct Technology tested the environment; provided: user documentation, support after go live, BAS’s standard documentation (requirements/design/testing documentation), and knowledge transfer to LDC staff.