VB6/VBA MS Access Developer needed - Remote work
Immediate opening for highly experienced VB6/VBA developer to rebuild existing MS Access database to a fully OO TDD, multi layer architected solution. Successful candidates will have min 5yrs experience with VBA/VB6, ADO, MS Access, using Test Driven Development (will provide instructions for TDD).
Knowledge of aviation maintenance (esp. US Military) a plus.
Existing solution is currently in use by the US Navy and US Marine Corps and was written using procedural programming paradigm that needs to be converted to OO using MVP architecture. Solution imports records (aviation maintenance quality assurance audits) from existing Access database (mandatory use) and performs an Extract, Transform, Load to provide missing functionality including:
Electronic routing of audits through standard and dynamic routing sequences
Audit scheduling
Scanned document attachments
Archival
Trend Analysis reports
...and much more
New solution must be written in MS Access (VBA or VB6 32bit and 64bit compatible) without the use of a SQL server backend to facilitate use by units without internet connectivity (multi user capable by use of shared data file on network share). Solution must be self contained not requiring installation or registration of ActiveX controls.
Phase two will be to create exact same functionality with a web based solution to provide units that will maintain internet connectivity with easier to maintain and more robust solution.
Both solutions should be modular. Planned new features include connecting to other existing databases to ETL and route their documents. Additionally, routing engine should be generic enough that any electronic document can be routed, not just audits or existing records.
Phase 1 is due to be released in April so time is of the essence.
Job is contract to hire with compensation commensurate with experience and job history.
Attention to detail is absolutely required. Please pm with cover letter, resume/experience, and compensation requirements.
