Oracle Visual Basic

Paul A. Hackney

*** ******** **.

Greer, SC *****

Email: ********@********-***.***

Home: 864-***-****

PROFILE:

Dedicated, passionate and inventive engineer, with a can-do, professional attitude, and more than two

decades of experience designing, implementing and adapting technically sophisticated software solutions

using a broad range of programming languages, architectures and hardware platforms. Proficient in

several software languages including C, COBOL, SQL, Oracle PL/SQL and Visual Basic amongst others,

several architectures including Windows and OpenVMS, and Software Development Life Cycle

management.

PROFESSIONAL SKILL SET SUMMARY:

Note: All stated experience years are noted in cumulative time rounded to the nearest year. Times

are concurrent for skills needed to complete a single project.

Operating Systems :

Windows 95/98/NT/2000/XP 6 years

Windows CE 1 year

VAX, Alpha OpenVMS 22 years

Sun OS 1 year

HP-UX Training

Databases :

Oracle & RDB 13 years

SQL Server 2000 6 years

SQL Server CE 6 years

Access 5 years

Powerhouse 7 years

Languages :

Oracle RDB SQL 12 years

Oracle RDB SQLMOD 12 years

Oracle PL/SQL 6 years

Oracle Pro*C 3 years

Oracle Pro*COBOL 2 years

Visual Basic 4 years

Visual C/C++ 4 years

C 16 years

COBOL 10 years

FORTRAN 8 years

DEC/VAX Assembly 8 years

Oracle Stored Procedures 1 year

Embedded Visual Basic 1 year

DEC/FMS 1 year

Winbatch (Scripting Language) 1 year

Visual Basic.NET 1 year

Borland Delphi 6 1 year

ASP.NET 1 year

IIS 1 year

Development Tools:

FOCUS 12 years

Oracle SQL*Forms 3 years

Powerhouse 7 years

Oracle Developer 2000 1 year

Crystal Reports 1 year

ChartFX 1 year

Industries:

Chemical Manufacturing

Textile Manufacturing and Finishing

Pre-Press Publishing

Food Manufacturing

Transportation Management

Public Utility

Commercial Software Development

Tire Sales/Retread

PROFESSIONAL HISTORY:

ONSITE / Telecommute Contract Client: Ryder Transportation Management, Novi, MI -

(transportation management)

Employer: Techmage, Inc.

Dates: March 2005 through June 2013

Position: Senior Systems Analyst

Responsibilities:

• Performed Business Process Analysis for Ryder customers and created application design

and modification to fit the customer’s needs. Additionally, I liaised with customers to

determine their reporting needs and developed data acquisition and verification methods

as well as reports.

• Mentoring developers in Ryder best standards and practices.

• Leading small teams of developers (2 to 3) in project development and serving as design

architect for some projects.

• Optimizing application level performance of Oracle RDB database access for the most

efficient data retrieval, processing, and storage.

• Designed and implemented tables, indexes, and triggers as applying to application

development, application support and reporting.

• Assisting in the design and implementation of a full testing system for Ryder’s Freight Bill

Audit and Payment multi-platform and multi-database application. The testing system

encompasses unit and system regression testing for the entire application.

• New development and maintenance of Ryder’s Freight Bill Audit and Payment multi-

platform and multi-database application..

• Liaising with customers on a regular basis to determine root causes of issues and

developing strategies to correct customer issues in application, data, and reporting issues.

Database, Languages, and Platform:

• Oracle RDB

• Oracle RDB SQL, Oracle RDB SQLMOD, Embedded Oracle SQL, C, COBOL, FOCUS, DCL.

• VAX (OpenVMS), VAX Alpha (OpenVMS), Charon VAX (OpenVMS) (Virtualized), PC (Windows

2003) (Virtualized).

ONSITE Contract Client: H&R Block, Dublin, OH - (tax preparation / filing)

Employer: Techmage, Inc.

Dates: October 2004 – March 2005

Position: Systems Analyst

Responsibilities:

• Performed analysis, development, and maintenance of H&R Block nationwide client/server

tax preparation and validation application. Modification of application to support annual

federal tax code changes. Modification of application state specific modules to incorporate

annual state tax code changes.

• Analysis and development of H&R Block interface to the IRS e-filing system to

encapsulate changes in data requirements and format.

• Worked in two person team in a pilot project to port the client side of the tax preparation

and validation application from the Windows OS platform to a SUSE Linux platform.

Database, Languages, and Hardware:

• Oracle, MySQL

• C, DCL

• PC (Windows XP Pro, SUSE Linux), VAX Alpha (OpenVMS)..

OFFSITE Project Client: Schiffkey Consultants, Inc., Altamonte Springs, FL - (consulting services)

Employer: Techmage, Inc.

Dates: May 2004 – August 2004

Position: Project Developer / Analyst

Responsibilities:

• Performed analysis and recoding of C and COBOL modules in production system for a

migration from VAX platform to VAX ALPHA.

Hardware and Languages:

• VAX (OpenVMS), VAX ALPHA (OpenVMS)

• C, COBOL, DCL.

ONSITE Contract Client: Tire Centers, LLC, Duncan, SC - (tire sales / retread)

Employer: TEKsystems

Dates: September 2003 – March 2004

Position: Systems Analyst

Responsibilities:

• Designed and developed the Tire Retread Process Management Pocket PC application for

data collection and data synchronization with server database using wired and wireless

TCP/IP. (Visual Basic.NET, SQL Server 2000, SQL Server CE)

• Redesign, development and coding of European fleet tire inspection application for use in

the United States using Pocket PC 2002 and Pocket PC 2003 PDA handheld devices,

cellular wireless TCP/IP, and wired TCP/IP. (Embedded Visual Basic 3, Visual C/C++)

• Redesign, development and coding of server side application for receiving inspection data

from PDA devices, storing it in an Access database, generating Adobe PDF documents,

and emailing the documents to clients. (Visual Basic.NET, Visual Basic 6, Borland Delphi

6, Access)

• Created a web interface for above server side application database to facilitate data entry

of customer information. (ASP.NET, IIS)

• Redesign, development and coding of client application to generate and display charts and

reports of fleet tire inspection data. (Visual Basic.NET, Visual Basic 6, Crystal Reports,

ChartFX)

Hardware and Languages :

• PC (Windows XP Pro, Windows 2000), HP/Compaq iPAQ (Windows CE), Intermec 700C

(Windows CE).

• Embedded Visual Basic 3, Visual Basic.NET, ASP.NET, IIS, Visual Basic 6, Visual C/C++, Borland

Delphi 6, Crystal Reports, ChartFX, SQL Server 2000, SQL Server CE, Access.

OFFSITE Project Client: RTFM Consulting Services, Inc., Greer, SC - (consulting services)

Employer: Techmage, Inc.

Dates: January 2003 – July 2003

Position: Project Developer / Analyst

Responsibilities:

• Performed design, coding and database development of Pocket PC application for data

collection for environmental analysis. (Embedded Visual Basic 3)

• Created report generation system using data from an Access database and inserting data

into a Microsoft Word document template. (Visual Basic 6, Microsoft Access 2000)

Hardware and Languages :

• PC (Windows NT, Windows 2000, Windows CE)

• Visual Basic 6, Embedded Visual Basic 3, Microsoft Access 2000.

ONSITE Contract Client: Ryder Transportation Management, Ann Arbor, MI - (transportation

management)

Employer: Techmage, Inc.

Dates: September 2001 – January 2003

Position: Systems Analyst

Responsibilities:

• Analysis, new development, and maintenance of the company’s primary business application

freight bill auditing and payment system. (C, COBOL, FOCUS, DCL, RDB SQL, RDB SQLMOD,

Embedded SQL)

• Analysis and development of system for creation and delivery of email with MIME encoded

attachments through VAXMail to Internet email. (C, TCP/IP, SMTP, DCL)

• Development and maintenance of PC based application interface and process automation to PC

MILER software. (Visual Basic 6)

Hardware and Languages :

• VAX, Alpha (OpenVMS), PC (Windows 98, Windows 2000).

• C, COBOL, Visual Basic 6, FOCUS, RDB SQL, RDB SQLMOD, Embedded SQL, DCL, FTP.

ONSITE Contract Client: Accenture / Dow Chemical, Southfield, MI - (chemicals manufacturer)

Employer: Techmage, Inc.

Dates: February 2001 – September 2001

Position: Software Developer / Analyst

Responsibilities:

• Formulated and presented a training course for Accenture development teams in “Best Coding

Practices & Standards in Pro*C”.

• Assisted team performing upgrade from Oracle 7 to Oracle 8 by resolving issues when Pro*C

programs would not compile or behaved in unexpected ways under Oracle 8. (Oracle Pro*C,

Oracle PL/SQL, Oracle Stored Procedures)

• Design review and performance tuning of new and existing financial data collation and reporting

applications. (Oracle Pro*C, Oracle PL/SQL, DCL, Oracle Stored Procedures)

• Design, coding, and implementation of a log file parsing and analysis application. (Visual C/C++)

Hardware and Languages :

• Alpha (OpenVMS), PC (Windows NT)

• Oracle Pro*C, Oracle PL/SQL, Oracle Stored Procedures, DCL, Visual C/C++.

OFFSITE Project Client: RTFM Consulting Services, Inc., Greer, SC - (consulting services)

Employer: Techmage, Inc.

Dates: March 2000 – May 2000 (after hours and weekends)

Position: Software Developer / Analyst

Responsibilities:

• Design and coding of an application to parse computer generated system analysis reports in text

format and store parsed data in an Access database. (Winbatch, Microsoft Access 2000)

Hardware and Languages :

• PC (Windows 98, Windows NT)

• Winbatch, Microsoft Access 2000.

ONSITE Contract Clien: Avondale Mills, Aiken, SC - (textiles manufacturer)

Employer: Techmage, Inc.

Dates: July 1999 – November 2000

Position: Software Developer / Analyst

Responsibilities:

• Design, coding, and implementation of a cloth booking system including user interface, data

collection, data storage, and peripheral device communications (weight scale). (Fortran, FMS,

DCL)

• Design, coding, and implementation of an inventory transfer system including user interface, data

collection, data storage, and peripheral device communications (bar code scanner). (Fortran,

FMS, DCL)

• Assisted vendor company Bailey Controls in integrating their process control Tenore product into

Avondale Mills existing process control data collection software. (C, Fortran, DCL)

Hardware and Languages :

• Compaq VAX, Alpha (OpenVMS)

• FORTRAN, C, FMS, DCL.

ONSITE Contract Client : The Kellogg Company, Battle Creek, MI - (Food Processing and Packaging)

Dates : January 1999 – May 1999

Position : Applications Programmer / Analyst

Responsibilities :

• Conversion and upgrade of Oracle Forms 3.0 (VMS based) forms to Oracle Developer 2000

forms (Client / Server). (Oracle Developer 2000, Oracle Forms 3.0, DCL)

Hardware and Languages :

• Compaq Alpha (OpenVMS)

• Oracle Developer 2000, Oracle Forms 3.0, DCL.

ONSITE Contract Client : Ameritech Advertising Services, Troy, MI - (Pre-Press Publishing)

Dates : October 1998 – January 1999

Position : Applications Programmer / Analyst

Responsibilities :

• Investigation and repair of pre-press publishing system for Y2K compatibility. (Oracle Forms 3.0,

COBOL, Pro*COBOL, C, Pro*C, DCL)

Hardware and Languages :

• Compaq Alpha (OpenVMS), Compaq VAX (OpenVMS)

• Oracle Forms 3.0, COBOL, Pro*COBOL, C, Pro*C, DCL.

ONSITE Contract Client : Milliken and Company, Spartanburg, SC - (Textile Manufacturing)

Dates : June 1998 - October 1998

Position : Applications Programmer / Analyst

Responsibilities :

• Investigation and repair of textile manufacturing data collection system including real-time

systems for Y2K compatibility. (C, FORTRAN, COBOL, DCL)

Hardware and Languages :

• Compaq Alpha (OpenVMS), Compaq VAX (OpenVMS)

• C, FORTRAN, COBOL, DCL.

ONSITE Contract Client : Ryder Integrated Logistics, Ann Arbor, MI - (shipping logistics)

Dates : October 1996 – June 1998

Position : Applications Programmer / Analyst

Responsibilities :

• Analysis, new development, and maintenance of business primary software tool freight bill

auditing and payment system. (C, COBOL, DCL, RDB SQL, RDB SQLMOD)

• Development of scripts to automate sending and receiving of EDI data files. (DCL, FTP)

• Assisted in development of standards for software version control, production implementation,

and program coding.

Hardware and Languages :

• DEC VAX cluster (OpenVMS).

• C, COBOL, RDB SQL, RDB SQLMOD, DCL, FTP.

ONSITE Contract Client : Ameritech Advertising Services, Troy, MI - (pre-press publishing)

Dates : August 1995 - October 1996

Position : Applications Programmer / Analyst

Responsibilities :

• New development and maintenance of multi-platform pre-press publishing system. Data storage

and access coordination on VMS platform. (C, COBOL, DCL, FTP, Pro*C, Pro*COBOL, Oracle

PL/SQL, Oracle SQL*Forms, Postscript) Image conversion and color separation on Sun Unix

platform. (Unix script, FTP)

• User support and production run troubleshooting.

Hardware and Languages :

• DEC VAX cluster (OpenVMS), Sun workstations (Sun Unix).

• C, COBOL, DCL, Oracle SQL, Oracle Pro*C, Oracle Pro*COBOL, Oracle PL/SQL, Oracle

SQL*Forms, Postscript, FTP.

ONSITE Contract Client : BASF, Wyandotte, MI - (chemical manufacturing)

Dates : September 1994 - August 1995

Position : Applications Programmer / Analyst

Responsibilities :

• Development of system administration support applications. (C, DCL)

• Jr. Systems Administrator operations and user support.

Hardware and Languages :

• DEC VAX cluster (OpenVMS)

• C, DCL.

ONSITE Contract Client : Detroit Edison Fermi II, Monroe, MI - (nuclear power plant)

Dates : February 1994 - September 1994

Position : Applications Programmer / Analyst

Responsibilities :

• Development and maintenance of administration applications including union approved overtime

tracking and security force plant access database. (Powerhouse QUICK, Powerhouse QUIZ,

Powerhouse QTP)

Hardware and Languages :

• DEC VAX cluster (OpenVMS)

• Powerhouse QUICK, Powerhouse QUIZ, Powerhouse QTP

ONSITE Contract Client : BASF, Wyandotte, MI - (chemical manufacturing)

Dates : October 1992 - February 1994

Position : Applications Programmer / Analyst

Responsibilities :

• Development of system administration support applications. (C, DCL)

• Development of automated report parsing and distribution system. (DCL, TPU)

• Development and maintenance of chemical research applications. (DCL, FORTRAN)

• Jr. Systems Administration operations and user support.

Hardware and Languages :

• DEC VAX cluster (OpenVMS)

• C, FORTRAN, DCL, TPU.

WRB Associates, Inc., Troy, MI - (Software Vendor)

Dates : January 1989 - December 1991

Position : Applications Programmer / Analyst

Responsibilities :

• New development and maintenance of Programmable Logic Controller support application. (VAX

Assembly, DCL)

Hardware and Languages :

• DEC VAX cluster (VMS)

• VAX Assembly, DCL.

Contact this candidate