Toronto (www.cpas.com ) Performed analysis and coding (from specifications) of pension/health plan calculations and user entry logic (e.g. banking information, claims adjudication, termination & death payments) as well as screen configuration using PL/SQL (packages, stored procedures), triggers, views) for release to client. Wrote batch process for enrolment, payroll, outside payments using internal development IDE (utilizing interface to PL/SQL) IAN ALEX Worked on various bug fixes and enhancements for clients carrying the live system product including additional Java modifications (adding ancillary methods) in affected classes. Implemented periodic builds (applying CVS deltas and merging with template) for internal development as well as installation on remote client site.
Markham (www.ggsi.ca ) Performed coding and implementation of user remittance screens and Excel file uploading for remote clients. Environment: Java, HTML, JavaScript Wrote business logic and screens for pension transaction handling GUI used for withdrawals, inter-fund transfers and terminations in accordance with user specifications. Environment: Java, HTML, JavaScript Developed browser input screens and PDF output displays for various back-end UNIX report modules. Environment: Java, HTML, JavaScript Designed and implemented JSP-based system for client table and user based translations on database. Researched, coded and tested drill down menu system for pension reports. Environment: Java, HTML, JavaScript * Enhanced interface with clients by writing an EDI system for reconciliation / editing / reporting of contribution /earnings information based on ASCII load/transfer from UNIX, dial-up FTP, MAPI and FAX. Environment: VC++ / MFC Improved office efficiency through re-writing internal time-entry system from UNIX character-based to Windows GUI. Environment: VC++ / MFC Coded specialized (add-on) UNIX-side reports and calculation modules in ESQL/C (UNIX-C with embedded SQL) for defined contribution and defined benefit UNIX character based pension administration system. Selected examples of modules and reports: actuarial valuation, yield, order response, income calculator, RRSP report, PIN validation, surplus calculator, SIN/plan change, non-regulated plan. Identified and resolved needed bug fixes and provided module/class maintenance for character-based and web pension administration systems. System tested modules written by other developers for release on UAT