Request for IT Support (REQ4IT) - Requestor:
1995->1999 REQ4IT - "Request for IT Support" - VB3\VB5, ~10,000 lines of code
REQ4IT was developed to allow Telstra staff to report desktop and mainframe "faults" and "requests" via
email as an alternative to making a voice call to our overloaded Helpdesks. The business benefit was to reduce staff costs on our Helpdesks and remove the loss of productivity caused by lengthy phone calls.
- Took over maintenance of a Visual Basic 3 Requestor \ Mail Robot application used only in Victoria.
- Developed REQ4IT in to a three module application consisting of about 10,000 lines of VB3 and VB5 code, and a national user audience of around 30,000. i.e. any Telstra employee with email can use it.
- Worked with two SMS consultants with particular emphasis on corporate security issues. Consequently "Secure Mail" and digital signatures were used to validate data and positively identify request originators.
- Ported the existing VB3 "Requestor" module that used MSMAPI, THREED and GRID VBX's to VB5 for rollout to Windows NT4 desktop platform. Converted mail interface to direct MAPI32 calls (due to bug with Mail OCX) and converted all Win16 \Winsock API calls to Win32 API system calls. Replaced other VBX's functionality with code to minimise compatibility issues with national rollout.
- Took over VB3 "Approver" module, from another programmer, that used a Microsoft Access 2 database and the data control and ported to Visual Basic 5 and rewrote SQL queries to use the DAO 3.5 Object Library and replaced VBX's with MSMAPI32 and MSFLXGRD OCX's.
- Rewrote the VB3 Mail\Drift Robot to cater for a new version of the backend mainframe application. Was involved in various workshops and liaison with mainframe developers and Telstra project mangers. Successfully remediated REQ4IT and completed Y2K compliance.
- The team involved with this project varied but over time it included two programmers, two security consultants, mentor, project manager, deployment manager and a national steering committee.