Led a team of analysts and programmers through the development of a large-scale voter registration system for the Government of Jamaica. The system captures voter information from scanned forms and over-the-counter services and produces Voter Identification Cards and official voters lists. The capture, processing and storage of digital biometrics such as scanned 10-print rolled fingerprints, livescan fingerprint comparison, photographs, and signatures were a particular challenge of this project.
Responsible for all database development in Sybase System 11 which included about 300Gb of data, 600 stored procedures, and the construction of a proprietary replication engine that installs as an NT service and uses a large modem-pool to maintain synchronization between the central site database and 65 remote databases scattered throughout the country. The team also constructed a 60-screen, PowerBuilder program that managed the registration process, and maintained voter data.
Defined Use Case models, Interaction diagrams and object analysis models in Rational Rose. Documented requirements from interviewing business clients. Maintained compliance with contractual requirements in Requisite Pro. Defined logical and physical model in ER-Win. Defined test plans in SQA Teamtest. Constructed stored procedures, and built a stored procedure generator to feed replication service.
Investigated production problems resulting from mistakes made by the prime contractor and prepared a briefing to executives. Maintained software problem tracking.
Constructed load and stress testing tools in stored procedures and DOS, to test critical components of the system such as database replication, and transaction processing. Constructed database administrator utilities in C++, DOS batch, and in stored procedures and using Sybase’s Bulk Copy (BCP) and ISQL utilities to automate the setup and upgrade of production databases and migration of system objects from integration test database. Found a means to encrypt stored procedures. Carried out performance tuning, by analyzing show plans and optimizing stored procedures.