John W. Christman, Jr 5219 Sandy Grove Kingwood, TX 77345 C: 713.582.6516 Jchristmanjr@embarqmail.com
JOHN CHRISTMAN JR.
EXPERIENCE:
October 1996 to Present Independent
Consultant
PROJECTS:
Shell
Oil Houston,
TX 07/30/07 – Present
Contract Programmer
Created
several pass-thru queries.
Weatherford Int Houston, TX 05/01/07 - 06/11/07
Contract Database
Programmer
· Enhanced secured Elastomer Database created in Summer of
2005
· Enhanced secured Packer Database created in fall of 2005
· Updated web application using C# & vb.Net
· Environment: Windows XP, Access 2003, & Excel 2003
Capital One Bank New Orleans, LA 04/02/07 – 04/23/07
Contract Database
Programmer
Safe-Way Driving Centre 01/15/07 – Present
Contract Programmer
Service Corporation
International 07/05/06 – 12/22/06
Contract Programmer
Treasury Division
Tax Division
1.
Import data from a spreadsheet using VBA
2.
Update data
3.
Print Reports or export specified data to a spreadsheet
4.
Used VBA to format spreadsheet
data using Access
and exporting the updated data to a spreadsheet.
Using VBA code to formatted the data in spreadsheet.
·
Designed Access
database to import text delimited data using VBA code.
·
Complete a data
search, create an exception report, Export to text delimited data to a
location.
· Environment: Windows XP, Office 2003, Excel, Crystal Reports 11, SQL 2005, & Access 2003
Exxon Mobil 5/15/06 – 06/09/06
Contract Programmer
·
Designed and modified
spreadsheets using macros to pull data from other spreadsheets.
Shell Oil Company 02/08/06 – 04/28/06
Contract Programmer
Tax Division
·
Using Access 2000
and Oracle, designed Application that allowed users to select analyze specific
data from designed query’s to generate specific reports.
·
Designed Web App using C# and ASP. Net, allowing
user to search for a specific company within Shell Oil organization and display
specific information.
·
Designed application
with Access2000 and Oracle. This application imports data from one of Shell Oil
divisions and exports the data to the Corp Tax division using designed query’s
and reports.
·
Environment: Windows
2000, Office2000, Oracle, VBA, C#, ASP. net, & Visual Studio.net
Weatherford Int. 11/01/04 – 12/13/05
Contract Programmer
§
Updated Access 2003 front end. Modified forms by adding text boxes,
combo boxes, & associated VBA code.
§
Redesigned data input forms and reports (Invoice and Parts Request)
and changed sub reports from the Invoice Report.
§
Created Access DB to retain chemical test data. This data gave the chemical
engineers the ability to define test criteria.
§
Updated VBA code from Access97 version to Access 2003.
§
Moved Access 2003 database backend to SQL 2000.
§
Moved Access front end to VB.net,
C# and tested. (to eventually move Access front end to intranet)
§
Updated Access queries to SQL stored Procedures.
§
Imported data from web database using xml.
§
Created Access Database to track molds, setup import of XML data from
JD Edwards accounting package into Access Database and developed reports in
Excel spreadsheet.
§
Created Access database to track Packers (this object is inserted
into an oil well after the well is drilled to aid in extracting oil from the
well). This database will contain Packer test data.
§
Environment: Windows 2000
& XP, Access 2000 & 2003, Excel , Macros, VBA code, ADO, Stored Procedures, ActiveX, SQL 2000,
VB, VB.net, C#, JavaScript, VBScript,
& XML
Rowland – Ballard Gymnastics 10/13/04 - 11/01/04
Contract Programmer
§
Design website for the school of Gymnastics
and Ballet (www.RowlandBallardSchool.com)
§
Environment: Windows XP and Server 2003,
Dreamweaver Java, JavaScript, VS.net, C#,& VB.net
Kingwood Association Management 02/12/03 - 11/01/05
Contract Programmer
§
This
company manages 24-association accounts receivable/payable using a Dbase
application.
§
Maintained
networking system.
§
Responsible
for maintaining Access forms, query’s, Reports, VBA code, & Stored
Procedures.
§
Environment::
Windows 2000, Windows XP, Access 2002, SQL 2000, ADO, Stored Procedures &
VBA
Trifusion 06/28/04 – 07/30/04
Contract Programmer
§
Designed several screens that were used to track type and quantity of
components used in building servers and desktops.
§
Utilized an Access 2000 front end.
Added several screens.
§
Designed and modified Stored
Procedures to link SQL tables to access screens.
§
Updated Intranet, added Human Resources content.
§
Environment: Windows 2000, Access 2000,
SQL 2000, Stored Procedures, & Office 2000
ATOFina Chemical 10/15/03 - 12/31/03
Contract Programmer
§
Upgraded Access97 Applications that tracked old parts and engineering
of new parts to Access2000 Company wide.
§
Repaired VBA code errors, such as code that was not compatible with
Access 2003.
§
Designed Access 2000 Computer Equipment Inventory Database, to track
Desktop & Laptop Hardware and Software.
§
Environment: Windows
2000, Lotus Notes, Access97, Access2000, & VBA
MGM
Services 08/01/03 – 10/01/03
Contact
Programmer
§
Designing
a two-tier interface in VB that links WCTP wireless to SQL.
§
Designed
Stored Procedures that move data from SQL to Access App. Setup Network Server
to receive and send wireless data.
§
Environment: VBA, SQL2000, Stored
Procedures, Server 2003, & WindowsXP
Xnet Systems 07/15/03 – 08/01/03
Contract Programmer
§ Designed Access Interface
application, track employee’s time on project, parts used on project, and
client information and automatically fax invoice to client.
§ Environment: Access
2002, VBA and Windows XP
Autobysite 01/05/03 – 07/13/03
Contract Web Architect / Programmer
§
Upgraded
database from Access 2000 to SQL 2000.
§
Wrote
several Stored Procedures to move data.
§
Added
several ASP pages to Autobysite web application. (www.Autobysite.com)
§
Created
reports using Crystal Reports used for Auto Invoices, Several Loan reports.
§ Environment:: ASP, VBScript, JavaScript, Dreamweaver
MX, Access 2000, & SQL 2000
Altech Controls 10/05/02 –
12/31/02
Contract Programmer
§
Modified
Pascal application to run on a Windows 2000 & XP
§
Changed
ALTECH CONTROLS web site (Interface) by change the way data was presented.
§
Environment: Windows 2000 & XP, Pascal, VB,
ASP, VBScript, & JavaScript
Saunders Group 03/05/02 – 09/03/02
Contract Programmer
§
Designed
Access2000 Database application for Saunders Group
§
Environment: Access 2002, Windows 2000, XP, & ADO
Wilsher Co. 01/10/02 – 02/23/02
Contract Network Engineer
§
Setup Router and switch box for Internet connection
to all workstations, Setup server and 20 workstations.
§
Environment:
Windows2000, D-Link routers
Access-EC 05/29/01 – 11/29/01
Contract
Programmer
§
Responsible
for mapping new EDI input and maintained EDI system.
§
Designed
Web Application for Construction industry, generating Purchase
§
Orders
and Invoices with the option of quick payment of invoices.
§
Environment: Windows2000, WindowsNT4, SQL7, Access97 & 2000, VB6,
VBScript, JavaScript, Java, ASP, HTML, Visual Inter Dev, SourceSafe, &
Crystal Reports
Eagle Logistic Group 04/06/01 – 05/18/01
Contract Programmer
§
Responsible
for the support of the MMA Tracking System. This consisted of
troubleshooting data and report issues.
§
Upgraded
tracking system from Access97 to Access2000 and move data to SQL 2000.
§
Environment:
Windows2000, SQL2000, Access2000, Office2000,
VB6, Visual Studio, VBScript, & JavaScript
Compaq Computer Corporation 11/01/00 – 03/31/01
Contract Programmer
§
Responsible
for the Support and Enhancement of a mission critical planning and forecasting
tool, all reports were created in Excel with VBA or Crystal Reports.
§
Designed
web application tool to aid Client in request of enhancements to planning and
forecasting tool
§
Environment: Windows 2000, NT, 98, 95, Excel (VBA), Access 97, VB6, ODBC,
COM, SQL7, ASP, HTML, VBScript, Jscript, & ActiveX
Baker Petrolite 01/05/00 –
08/17/00
Contract Programmer
§
Designed
Asset Tracking Application for the Web to aid account managers in tracking
containers. This system replaced a client /server system, which was, slow and
limited account manager usage.
§
Modified
Data Logger Application, which is uploaded into Hand, held Bar Code readers.
§
Environment:: ASP, HTML, VBScript, JavaScript, MS SQL7, ADO, ACTIVEX, COM, VB
6, True DB Grid, Crystal Reports, Front Page, Visual Studio Home, Site, Cold
Fusion, SQL 7- Coded Procedures, Views, & Triggers
Tellepsen Corporation 08/10/99 – 12/31/99
Contract Programmer
§
Designed
a Time Sheet application for managers using a Palm Top Handheld Computer.
§
Setup
SQL Server to receive data from Palm Tops
§
Environment:: Client/Server, Novell 4.1, Windows NT, SQL 7, MS Office 97, VB
6 &, Y2K Windows CE Toolkit for VB
Merichem Company 01/12/98
– 06/01/99
Contract Programmer
§
Worked
for the Design Engineering Group
§
Upgraded
all Applications from Paradox for DOS to Access97 using. Designed Logistic
Application using VB 5 front end.
§
Worked
for the Feedstock Transportation Group
§
Upgraded
all Applications from Paradox for DOS to Access 97 and SQL Server.
§
Designed
Transportation Module to track Barge and Rail Car movements and generate
invoices, which were automatically transmitted to clients.
§
Developed
Forecasting Application from Lotus Model, which was used to determine how much
oil waste they would be able to accept for the next several years.
§
Environment: VB5 and Access 97 with
Reports in Excel 97 Client/Server, Novell4.1, Windows NT, SQL 6.5, MS Office
97, VB 5, Paradox for Dos, Y2K, Excel 97 & Lotus
October 1989 to October 1996 Christman Consulting
Network Administrator Houston,
TX
§
Maintained and Designed small networking
systems.
§
Environment: Windows3.1, 95,98,2000, Novell
October 1973 to
October 1989 Recognition Equipment
Computer Hardware Technician Dallas, TX
October 1963 to
October 1973 Grumman
Aerospace Corp.
Aircraft
Electronics Technician Bethpage,
LI, NY
1984 to Present North
Harris Community College
Instructor
Course Schedule
includes the following:
§
Intro to Computers- Word, Excl, Power Point, Access, Computer
Hardware, & Front Page
§
Access database
§
PC
Operating Systems, Intro to Computers including Windows 2000, Word, Excel,
Access, & Power Pt
§
Networking- Microsoft, Novel, & CISCO
§
Computer
Hardware and Computer Troubleshooting (A+)
§
Designed Windows NT (Server & Workstation) & Windows 95 for
Community Education.
§
Designed
PC Upgrade Course for Community Education
§
Designed
Visual Basic 4 course
§
C++,
JavaScript, VBScript, HTML, & VB6
§
Visual
Basic 6 – Corporate Instructor
§
Access
2, 95, & 97
EDUCATION:
University of Houston Houston,
TX
Bachelor of Science in Information Systems
References:
Roger Saunders - Clinical Psychologist
O: (936) 539-2225
C: (936)718-5035
Jeanne Walker - Owner Safe-way Driving Centre
O: (713) 468-1313
Debbie Banta - Manager Weatherford Int.
O: (713) 983-5310