Years Experience Software

Employment R sum

GREGORY MELLE

Address: #** **** **** ****** ****, Surrey, BC V3W 5Y4 Canada

Email: abpil8@r.postjobfree.com

Home and message phone: 604-***-**** Cell phone: 778-***-****

OBJECTIVES AND STRENGTHS

I seek a challenging position analysing, designing and developing useful software.

My 25 years of computer experience includes employment in both Canada and the USA.

I emphasize accurate database creation, effective user interfaces and intuitive reporting systems.

My attention to detail is backed with creativity and technical knowledge.

I have good writing skills and enjoy creating help systems and documentation.

My personal Internet projects have been online more than 15 years. They receive several thousand

daily page views. Recent development used AJAX: HTML5, Javascript, CSS 3 and JSON.

Recent education:

2008 to 2010: Completed eleven Athabasca University courses including Systems Analysis, Database

Management and Java programming. Additional courses include English Composition, Creative

Non-Fiction Writing, Modern History and Heritage Resource Management.

SUMMARY OF COMPUTER LANGUAGES AND APPLICATIONS

Oracle PL/SQL programming and education more than 4 years employment

Have programmed PL/SQL stored procedures, functions and triggers

Studied and practised the creation of fast, efficient and well-tuned code

Official Oracle Education includes several SQL and PL/SQL courses, seminars and training sessions

Other SQL experience includes IBM s DB2/400, Microsoft SQL Server and Access SQL

Skilled using Toad for Oracle and SQL Navigator development tools

IBM iSeries / System i / AS/400 Mid-Range computers 3 years employment

Includes RPG IV / RPG400 / ILE, COBOL, DB2 SQL, DDS, DB2 Queries and CL programming

Contract work in 2006 brought skills back up to date with new versions including V5R4 of System i5

Also, maintained similar IBM System/36 RPG II programs 1 year experience

Borland Delphi versions 1, 2, 3, 5, 6, 7 and Developer Studio 2006 10+ years experience

Expertise using QuickReports, ReportBuilder, Rave, InfoPower and FirstChoice components

A 20 month contract involved production control software for truck and auto assembly

Contracts in 2003 and 2005 included recent Delphi versions and SQL Server development

Work in 2007 to 2009 included development in recent versions of Delphi and Oracle

Internet programming and development 12+ years development experience

HTML5, Java, Active Server Pages (ASP), JSON, VB.Net, VBScript, JavaScript, jQuery

Designed, developed and maintain several busy web sites

Microsoft Office Applications and Tools

Have worked with several Microsoft Office versions over more than a dozen years

Strong knowledge of Word and Excel applications. Self-taught in Microsoft Project

Have done application automation using VBA, OLE, DCOM and Activex

Borland Paradox for Windows versions 4, 5 and 7 2+ years experience

Year 2000 (Y2K) Conversion Analysis and programming 3 years experience

C Programming: VMS C, Pro C and Borland C Builder 1 year experience

dBase versions: II, III, III+, IV and dBXL 3 years experience

PICK Basic, Revelation and Advanced Revelation 2 years experience

DETAILS OF SOFTWARE EXPERIENCE

Wellington Financial Management

Dates: OCTOBER 2009 TO MARCH 2010

Part-time online Delphi and Oracle programming work for a New Jersey financial corporation

Finney-Taylor

Client: 5D / HAEMONETICS SOFTWARE Edmonton, Alberta Canada

Dates: NOVEMBER 2007 TO FEBRUARY 2008

Delphi and Oracle contract software development. Also documentation tasks converting a

large project to US FDA and Department of Defence standards

Software is used for tracking and control of blood donations and transfusions

CSI Consulting Inc.

Client: BC LIQUOR DISTRIBUTION BRANCH (BCLDB) Vancouver, BC Canada

Dates: JULY 2006 TO JANUARY 2007

Six-month contract involved software development, testing and debugging

for the installation of packaged applications for ETL and store inventory data analysis

Used TOAD development tools to write scripts and convert Oracle 9i PL/SQL procedures

Did business analysis and created documentation using Excel and Visio

S.i. Systems Ltd.

Client: BC HYDRO FLEET SERVICES Surrey, BC Canada

Dates: APRIL TO JULY 2006

AS/400 (iSeries) software contract involved RPG programming and development

Debugged many inter-server communication issues

Project supervision was outsourced to Accenture

Client: WESTERN FOREST PRODUCTS Duncan, BC Canada

Dates: FEBRUARY TO MARCH 2006

AS/400 RPG ILE and embedded DB2 SQL development.

Analysed databases, programmed reports and used CL command language

Client: BC LIQUOR DISTRIBUTION BRANCH (BCLDB) Vancouver, BC Canada

Dates: JUNE TO OCTOBER 2005

Helped in the schema conversion and version update of scripts for a large Oracle database

These scripts used DB-Links to handle much of the data conversion and data transfer

between different versions of the database

Made changes to Delphi compiled batch applications

Self-Employment: (2004 to 2006)

Did small business consulting, software development and some non-computer employment

3Log Systems Inc. Richmond, B.C. Canada

Client: DOMTAR INC. Woodland, Maine USA

Dates: OCTOBER 2003 TO JANUARY 2004

Programmed custom applications using Delphi and Microsoft SQL Server

Updated, designed, maintained and installed custom software which tracks

the purchasing and weighing of pulp-mill logs and chips

NSP, Inc.

Client: NEW UNITED MOTORS (NUMMI) Fremont, California USA

Dates: JULY 2000 TO MARCH 2002

20-month programming contract at a General Motors / Toyota joint venture

Assisted in automobile and light-truck assembly-line changes required for new vehicle models

Analyzed software requirements, designed and programmed Borland Delphi end-user

interfaces for large Oracle databases. Did some Oracle PL/SQL procedure development

Created some powerful and effective screens and reports.

These managed interactions with embedded software controlling the assembly line

automation. I studied Toyota management concepts for continuous improvement

Programming in VAX VMS Pro C to handle job scheduling

My software was used for the manufacturing control of all Toyota Tacoma trucks and Pontiac

Vibe cars. It displayed the status of every newly-painted vehicle body as they entered the

primary assembly line

SRI SoftSol Resources

Client: LIFESCAN DIVISION OF JOHNSON & JOHNSON Milpitas, California USA

Dates: MARCH 1999 TO JANUARY 2000

Year 2000 software remediation for a manufacturer of personal blood glucose monitors

Followed strict American FDA software change and documentation requirements

Created a database for the QA department using Platinum Software's ERWin design tools.

The final version used an Oracle database with a Delphi Pascal front-end

ea Consulting

Clients: DFS DUTY FREE STORES (San Francisco) and WESTERN DIGITAL (San Jose, California)

Dates: JUNE 1998 TO FEBRUARY 1999

Supported retail sales analysis using RPG at the head office of DFS

Performed Y2K inventory, analysis and software remediation at a division of Western Digital

USA Consulting Inc

Client: VESTA INSURANCE Birmingham, Alabama USA

Dates: OCTOBER 1997 TO JUNE 1998

Contract Year 2000 work was done in Jackson, Mississippi

Conversion team member for AS/400 database and RPG software conversion

Used Microsoft Access SQL to maintain, analyze and combine the data from numerous tables

CTC Computer-Tech Consultants (now part of Ajilon)

Clients: IBM GLOBAL SERVICES and CANADA LIFE Regina, Saskatchewan Canada

Dates: NOVEMBER 1996 TO SEPTEMBER 1997

Worked at a Y2K software conversion factory

Programmed with Borland Delphi and AS/400 COBOL

Did systems and application analysis. Some training was at IBM in Oak Brook, Illinois

Self-Employment: (early 1990 s)

Did software development and some non-computer employment in Okanagan Valley of BC

Azcom Information Systems Inc. (1990)

End-Clients: Blue Cross Insurance and BC Girl Guides Vancouver, BC Canada

Several months of intensive work on the IBM AS/400 for several clients

National On-Line Mortgages Limited (October 1989 to September 1990)

Designed and implemented a fully functioning on-line mortgage approval system

Designed and developed all the software under the PICK System using PICK Basic

Selected, purchased and installed all servers and communication equipment

Group West Systems Limited Burnaby, BC Canada (early 1988)

8 months programming in RPG II on the IBM System/36

EDUCATION

Athabasca University Athabasca, Alberta Canada

Full-Time Studies: APRIL 2008 TO DECEMBER 2010

Completed eleven Social Science, Arts and Information Systems Courses.

Included Java Programming, Database Management, Systems Analysis, Heritage

Management, Art History, English Composition and Creative Non-Fiction Writing.

Corporate Communications Training College Vancouver, BC Canada

Full-Time Studies: APRIL TO JULY 2003

Web Programming and Development Certificate

Database Design, HTML, JavaScript, VBScript, XML, COM+,

Microsoft SQL Server, Active Server Pages (ASP) and Visual Basic (VB.NET)

Vancouver Community College, Downtown Campus (VVI) Vancouver, BC Canada

12 months Full-Time Studies: NOVEMBER 1985 TO OCTOBER 1986

Completed a college Certificate in Computer Programming

Courses included Structured Programming, Program Documentation and Database Theory.

Much of the course work was done using COBOL.

Other courses included Microcomputer Applications, RPG, JCL, BASIC and Systems Analysis

Langara College (formerly Vancouver Community College) Vancouver, BC Canada

Part-Time Studies: 1977 TO 1982

Completed several part-time university courses

British Columbia Institute of Technology (BCIT) Burnaby, BC Canada

Full-Time Studies: 1978 TO 1979

Completed first year of Hotel and Restaurant Management studies that included courses in

Business Communications, Business Math, Credit and Collections, Data Processing,

Economics, Accounting and hotel management

ADDITIONAL PERSONAL HIGHLIGHTS

Maintain a personal web site and am active with social media such as Twitter.

I have a large collection of photographs loaded on Flickr.com

I have enjoyed world travel. I adapt well to foreign countries and foreign situations.

I enjoy meeting and working with a wide variety of people.

I read extensively and enjoy life-long learning.

In a non-computer capacity, I had industrial, railway and hotel employment.

I did industrial first-aid, supervised hotel banquets and learned good customer service.

Additional names, addresses, details and personal references are available upon request.

Contact this candidate