- Gatineau, CA
- £7 /hr
- Available now
Information technology analyst and programmer for 12+ years working on a variety of system projects for the government. Expertise is programming, business analysis, andmore...SUMMARY
Information technology analyst and programmer for 12+ years working on a variety of system projects for the government. Expertise is programming, business analysis, and data analysis.
College: Algonquin College, Graduated 1997, Computer Programmer
University: Carleton University (2 years of a 4-year program), Bachelor of Commerce
Databases: Oracle (all), SQL, PL/SQL, SQL Anywhere (Sybase), SQL Server, MS Access (all)
Operating Systems: UNIX, DOS v6.0, Windows (all versions)
Languages: English (spoken, written), French (spoken)
Supply Management System, Election Result System, Elections Canada October 2007 • Present
•Develop, design, and test enhancements, database changes, and new development
•Provide ad-hoc reporting for specific client requests
•Resolve end-user identified problems and determine feasibility of future improvements
•Provide full supporting documentation of all work performed
Tools used: PowerBuilder v 10.5, Oracle v 10g
Fleet Management System (Web), DND
Jan 2003 • October 2007
•Integral part in converting the existing client server PowerBuilder application to a consolidated centralized web based application. This involved converting a base installation of 60 + stand alone Sybase databases to one central Oracle database.
•Maintain and enhance new web version of the application, which includes enhancing the GUI interface (ASP.NET) with the associated data and business layer components as well as maintaining and enhancing the back end database components of the application ( Oralce 9i ).
•Maintain and enhance legacy PowerBuilder application during the conversion process to the new system.
•First point of contact for all base administrators across the country and deployed operations.
•Fix various data issues as they come up and either fix or escalate any application related issues.
•Responsible for year-end treasury board required reports on usage, fuel consumption etc.
•Responsible for any reporting that falls outside the capabilities of the application.
Tools used: ASP.Net, Oracle v 9i, PowerBuilder v 10.5
Fleet Management System (Client Server), DND
July 2000 • Jan 2003
•Responsibilities were to incorporate enhancements into the current PowerBuilder application. This involved initial analysis, design and code development. He was also responsible for implementing database changes and testing.
•Responsible for developing data transfer module, which incorporates external data into the application. Transfer module developed in PowerBuilder.
•Other duties include resolving any problems identified by end users, aid management on determining technical feasibility of future enhancements as well as provide full documentation of all work performed.
•Responsible for incorporating a new fuel tracking system into the current application. Involves coordination with third party companies to get all systems to exchange data properly. Interface between applications was developed in PowerBuilder.
Tools used: Oracle v 8.3, PowerBuilder v 6.5, Sybase (SQL Anywhere)
Information System Specialist
Revised Pay System for the Reserves (RPSR), DND
December 1997 • June 2000
•Maintain, analyze, and design and implement fixes to the revised pay system for the reserves which is a customized PowerBuilder application.
•Resolve problem tickets, and design and incorporate enhancements into the system
•Create design specifications, develop test plans, implement changes, and perform impact analyses
•Maintain GUI and reports using Powerbuilder for RPSR quality control and enhancements
•Provide documentation for any maintenance or enhancement work performed
Tools used: Oracle v 7, PowerBuilder v 5.0
Minasu Information Systems
July 1997 • December 1997
•Develop application for associations to track members, and organize meetings and committees
•Design functions, analyze and modify modules, and design and develop new ones (PowerBuilder)
Tools used: PowerBuilder v 5.0, Sybase (SQL Anywhere)
Support and Help Desk Technician
Applications Management Services (AMS), Public Works
July 1996 • July 1997
•Create Lotus 123 schema of measures to use in monitoring departmental projects and initiatives
•Automate final spreadsheet (macros) to be used throughout the pilot project period
•Support clients of Electronic Payment Authorization system for purchasing materials and printing
•Assist users, answer queries, provide support, and clear errors flagged by the system (Oracle)
Application Tester and Project Administrator
Information Systems Management Corporation
September 1992 • December 1995
•Test application for the Department of Transport written in PowerBuilder with an Oracle database
•Test various modules and quality assurance functions including document control and accuracy
•Assist with monthly revenue and resource forecasting, and month-end actual revenue recognition
•Gather forecasting data for all ongoing projects, and create custom automated spreadsheets for this
•Track financials of two large projects, including month-ends, payables, invoicing, and ad hoc reports
•Establish time-recording system to monitor time, resources, and revenue for ISM’s accounting
•Produce resource time management, planning, and forecasting reports, and reports for client review
•Manage hardware and software acquisitions, project procurement, inventory, costs, and schedules
•Create and maintain project schedule by deliverables and resource assignment
•Ensure accuracy, timeliness, and billing of all contract amendments and deliverables
•Develop various spreadsheets to handle inventory, time recording, and financial data
Area Covered: Ottawa, Ontario, Gatineau, Quebec