Jim Hamer's Resume

JAMES ROBERT HAMER
278 MILLWOOD ROAD
TORONTO, ONTARIO M4S 1J8
(416) 489-3298

BACHELOR OF MATHEMATICS * UNIVERSITY OF WATERLOO
MAJORING IN COMPUTER AND BUSINESS * 4 YEARS
CANADIAN SECURITIES COURSE


EMPLOYMENT EXPERIENCE:

.NET DEVELOPMENT/PROJECT LEAD – DAIRY FARMERS OF ONTARIO (CONTRACT WORK)
Building a web application using ASP.NET and Oracle. Lead the analysis, design and coding.
Creating a web solution for the Diary processors across the province. Developing the user interface, business objects and Oracle packages.
December 2006 to present.

.NET DEVELOPMENT – DAIRY FARMERS OF ONTARIO (CONTRACT WORK)
Developing a framework and front-end for future ASP and VB .NET development.
Assisting in creating the User maintenance user interface, business objects and Oracle packages.
June 2006 to November 2006.

ORACLE DBA SUPPORT - DAIRY FARMERS OF ONTARIO (CONTRACT WORK)
Converting OpenVMS RMS files to Oracle tables. Creating Oracle packages to support the tables. Creating .NET solutions using ODP to test
the packages. Modifying Powerhouse and COBOL programs to use the Oracle tables.
Dec 2005 to May 2006.

DATA RETRIEVAL - GOODRICH LANDING GEAR DIVISION (CONTRACT WORK)
Recovering data from an old VMS machine that had once used Powerhouse.
Captured the data dictionary and several key data files.
March 2005 to September 2005.

MANAGER DAY-TO-DAY OPERATIONS - DAIRY FARMERS OF ONTARIO (CONTRACT WORK)
Managing the distribution of work, guiding and supporting the staff and facilitating their work. Also, engaging the support of other staff
and meeting with senior staff. Reviewing the staff and evaluating their objectives. Reporting to the Director of IT.

September 2003 to November 2005.

SYSTEMS ANALYST/WEB DESIGNER- DAIRY FARMERS OF ONTARIO (CONTRACT WORK)
Enhancing the Milk Truck Inspection Reporting. Building a link between a hand-held data-entry computer (PSION)
and displaying the data on the web by converting and FTPing the data to its destination in a
MS SQL server database. Creating ASP pages to display the data.
February 2003 to August 2003.

WEB MANAGER/SYSTEMS ANALYST/PROGRAMMER - DELOITTE & TOUCHE (CONTRACT WORK)
Developing the Export Contract Exchange, a B2B, e-commerce web site. Using Embperl (embedded Perl) with a MySQL database
on a Linux server. Serving the needs of the users and project manager by maintaining and enhancing
the database and web site. Providing a liaison with the ISP.
November 2000 to April 2003.

SYSTEMS ANALYST/PROGRAMMER - DAIRY FARMERS OF ONTARIO (CONTRACT WORK)
Converting a web site from Perl and MySQL on a Linux server to ASP and SQL Server on an IIS server.
Using Windows 2000 server to host IIS and Visual InterDev for the development. Duties included setting up the server,
the database and converting 80 web pages, making use of code libraries and COM components.
May 2001 to April 2003

SYSTEMS ANALYST/PROGRAMMER - DAIRY FARMERS OF ONTARIO (CONTRACT WORK)
Ongoing support for the Transportation system. Converting Transport Payments to be based on current month data.
Integrating data from RMS files on the Alpha with Excel spreadsheets using a VB interface between Reflection and Excel.
November 2000 to February 2001.

SYSTEMS ANALYST/PROGRAMMER - DAIRY FARMERS OF ONTARIO (CONTRACT WORK)
Develop the Export Contract system. With direction from a steering committee, develop the online maintenance, inquiry, invoicing and payment programs
to implement their policies to ensure export milk complied with the WTO (World Trade Organization) rulings.
October 1999 to October 2000.

SYSTEMS ANALYST/PROGRAMMER - DAIRY FARMERS OF ONTARIO (CONTRACT WORK)
Lead the re-write of the Transportation system. Working in Powerhouse, COBOL and VB macros in Excel.
January 1999 to February 2000.

SYSTEMS ANALYST/PROGRAMMER - DAIRY FARMERS OF ONTARIO (CONTRACT WORK)
Working in Visual Basic. Assisted in creating a Client/Server system for Fieldstaff. Data was transferred from the Alpha to the PCs and then VB
brought the data into Access. Data access layer was DAO. Data on the screens was bound. Report requests launched Excel with VB macros
to create the user reports. I wrote a VB program for rolling out software and database upgrades.
June 1998 to January 1999.

SYSTEMS ANALYST/PROGRAMMER - DAIRY FARMERS OF ONTARIO (CONTRACT WORK)
Migrating from batch COBOL to online 4GL (Powerhouse) on an Alpha 2100 (OpenVMS).
Assisting in the re-writing and maintenance of Producer, Billing, Transportation, Quota and GL systems.
Used of Microsoft Word macros for user interfaces and form letter merging.
Created routines to launch Host/Client file transfers and email. Taught Internet course focusing on Email, Newsgroups and WWW.
January 1991 to May 1998.

SYSTEMS ANALYST/PROGRAMMER - NORTHERN TELECOM (CONTRACT WORK)
Enhance the PMS system to include JIT functionality. One of a team of five.
My contribution was program specs, test plans, modifying programs, assisting in an integration test, implementation and beta test. HP3000 Series 70 in COBOL.
February 1990 to December 1990

SYSTEMS ANALYST/DOCUMENTER - NORTHERN TELECOM (CONTRACT WORK)
Analyze the Purchasing System and create a System Recovery manual. The objective was to provide the means to
recover data integrity after a failure. Also assisted in two implementations of the system, one on an HP3000 Series 70 and the other on an HP950 (Spectrum).
September 1989 to January 1990

PROJECT LEADER/SYSTEMS ANALYST - NORTHERN TELECOM (CONTRACT WORK)
Re-write of the Purchasing System. One of four team leaders over-seeing a pool of 13 programmers.
Responsibilities were to evolve user requirements into programming specs, supervise programming, testing and
first installation (beta test). Subsystems directly under my care: EDI, Electronic Approvals and Forecasts.
April 1988 to August 1989

PROJECT LEADER/SYSTEMS ANALYST - NORTHERN TELECOM (CONTRACT WORK)
Project Leader of MPS system. With as many as four other team members, we rewrote the MPS system.
Additional duties include support for the dozen divisions with this software installed, the training courses and all implementations.
My mandate was to 1) improve the integrity of the software 2) create programming specs for enhancements that satisfy the user wants
and 3) follow through with implementation of the updated versions.
January 1987 to March 1988

PROGRAMMER/ANALYST - NORTHERN TELECOM (CONTRACT WORK)
HP3000 environment in COBOL. The project was a PMS system
(Manufacturing Standards, Inventory Record Control, Order Handling and MRP).
Emphasis was on online updating while maintaining deferred and batch processes. Third party software used included
Robelle's QEDIT, QHELP, SUPERTOOL and Powerhouse's QUIZ and QUICK.
Extensive use was made of intrinsics, message files, process control, and IMAGE databases and KSAM files.
I spend five weeks Beta Testing at a NTC division in Belleville.
September 1985 to December 1986

PROGRAMMER/SYSTEMS ANALYST - ENCOS DATA PROCESSING INC. (CONTRACT WORK)
Working predominantly on HP3000 in COBOL. Database and sequential update applications.
Well versed in IMAGE, QUERY, VIEW and KSAM files. Major clients were Hydro Electric Commissions. Ongoing work for the clients included systems
for billing and accounting, batch and online updating and inquiries. Some exposure to HONEYWELL LEVEL 6 and DATA GENERAL and IBM hardware.
Another client was the CBC and the work included statistical analysis resulting in the production of broadcast ratings.
Systems Management experience on the HP3000.
July 1983 to September 1985