Developed a major social network website to allow members to interact with each other based on activities that they can enjoy together. Also constructed server-side processes to search the internet and build a database of websites about activities and events. Developed screen scraper tools to extract event based information from the websites. Developed services to interact with Google, Facebook and Twitter. Developed an IPhone application to synchronize a personal calendar.
Documented user requirements from interviews with business clients and regional representatives from Customs ports. Designed a Powerbuilder 5 client-server system for the CANPASS border crossing program for RCCE/Customs. The system included biometric components such as fingerprint and hand-geometry templates; data replication between distributed databases. Designed the interface to request data from the CPIC, PIRS, and NCIC databases for security clearance of applicants and travelers.
Programmed a PowerBuilder/MS SQL Server component to print identification cards on Datacard Printer, and encrypt and encode information on optical stripe on card back.
Gathered requirements and prepared a conceptual design document for the CANPASS Telephone Reporting Centre border crossing program for RCCE/Customs. The system included research into Computer to Telephone Integration (CTI) and Integrated Voice response (IVRS).
Defined the functional requirements in Enterprise Architect and a logical data model in ER-Win for a permanent voters register at Elections Canada. Requirements modeling included interfacing with external data providers, such as provincial health insurance, drivers license and Stats Canada for determining voter address changes.
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.
>Defined a requirements model in UML using Rational Rose 98 for a real property sourcing system at PW/GSC Real Property Systems.
Gathered requirements by interviewing business clients at regional offices across Canada. Carried out a series of Joint Application Requirements sessions with business clients at several stages. Published Rose models in MS Office suite.
Constructed a working prototype in Powerbuilder 7.
Carried out the elaboration phase for the redesign of the AIMIS document tracking system using Rational`s Unified Process (UML, RUP) and the Rational Suite.
Produced the Software Architecture Document from Activity diagrams, Interaction Diagrams, Stakeholder requests from business clients, Use Case Model and Supplementary specifications in Requisite Pro.
Elaborated the use cases using interaction diagrams, activity and state transition diagrams to define the class domain model. Developed a user interface prototype in Powerbuilder.
Produced the Software Architecture Document containing Activity diagrams and Business use cases of the overall process, Stakeholder requests from business clients, Use Case Model and Supplementary specifications.
Prepared technical requirements specifications as principal author for AMPS, EPPS, and G7.
Facilitated JRP and JAD sessions for gathering and confirming business and technical requirements.
Provided design documents to the interdepartmental working committee on data sharing, between CCRA and Immigration.
Carried out the elaboration phase for the redesign of the AMPS monetary penalty system using Rational`s Unified Process (UML, RUP) and the Rational Suite. Elaborated the use cases using interaction diagrams, activity and state transition diagrams to define the class analysis model. Developed the class design model for web-based software architecture on a Weblogic platform.
Provided UML and Rational mentoring support to members of the build teams and carried out design reviews of their detail design documentation.
Developed and presented the conceptual design to the management committee for project initiation approval.
Participated in the preparation of technical requirements for a RFP for sourcing a vendor to provide digital biometrics and integration site services.
Software architect for the Integrated Customs Systems (ICS), assisted in the definition of user requirements and was responsible for the conceptual design and Software Architecture Documents of the Expedited Passenger Processing System (EPPS) and the joint Canada-US Nexus (highway) border crossing programs for travellers.
- Provided UML and Rational mentoring support to members of the build teams and carried out design reviews of their detail design documentation.
- Prepared technical requirements specifications as principal author for EPPS, Nexus and Global Enrolment Business Use Cases and Conceptual Design Documents.
- Facilitated JRP and JAD sessions for gathering and confirming business and technical requirements.
- Participated in the preparation of technical requirements for RFP for sourcing vendor to provide digital biometrics and integration site services.