Jeffrey S. Benson
88125 Ruby Jean Ln
Veneta, OR 97487
[Send email to request phone number] 10-4189
[Send email using form at bottom]
Professional Experience Summary
Experienced in analysis, design, development, and implementation of applications
and databases. Have 12+ years experience with relational databases and object
oriented programming applications. Areas of database experience includes
triggers, stored procedures, views, design, tuning, connectivity, backup,
security, DTS, and administration. Also have 12+ years experience with
Powerbuilder (including PFC), 2+ years experience with Visual Basic, 4+ years
experience with ASP, Jscript, and HTML, and 2+ years experience with .NET.
Computer experience includes 15+ years with PC hardware, networking,
backup/recovery, and tech support.
Software
RDBMS Languages
SQL Server (all versions) Powerbuilder 5.0 11.5
Oracle 7.3/8i ASP, ASP.NET, JScript, HTML
Sybase ASE and ASA (all versions) Flash MX 2004, 2008 (some experience)
Operating Systems Professional Applications
Windows, MS-DOS, UNIX MS Office
Hardware
IBM Compatible Personal Computers, Servers, and Networking Equipment
Work Experience
August 2007 Present
Senior Software Engineer/Database Developer Contract at the Oregon Department
of Health Services through NextSource Consulting, Inc. and Purple Squirrel
Services, Inc.
Overview:
Design and development of the CAPS upgrade project on the OACCESS application.
This application is used throughout the state of Oregon to provide health
benefits and services to seniors with disabilities. The upgrade project
included, among other things, a wizard window that dynamically displays questions
based on answers from previous questions to determine the level of eligibility
the client will obtain.
Also developed various tools and functions to be used by administrators to
manage highly sensitive areas of the OACCESS application and database, created
object level security, and created various reports and forms.
Database: Sybase ASE
Application: Powerbuilder 9.3/11.5
September 2005 August 2007
Senior Software Engineer/Database Developer Contract at the Washington
Department of Health through AETEA, Inc.
Overview:
Design and development of various applications used to support the WIC
department at the Department of Health. These applications are used to track and
process benefits for struggling parents who need assistance from the state.
Created an application used to encrypt sensitive data in databases so that they
may be taken off site for development at home.
Also created a secure ASP based site for reports used by departments throughout
Washington, a banking management system to process, analyze, and track WIC check
financial transactions, and redesigned a check management system to allow for
more efficient investigating of financial anomalies.
Database: Sybase ASA 9
Application: Powerbuilder 9.3/10.5
March 2004 May 2005
Senior Software Engineer/Database Developer Contract at Salt River Project
through Advantage Professionals, Inc.
Overview:
Design and development of the Transmission & Generation Interchange Schedules
(TGIS) application/database. This is a system that handles electricity sales and
usage across power plants and transmission lines. Created dynamic datawindows
for variable result sets from database along with a process that compresses and
stores/restores exported PSR reports. Also created a dynamic treeview used to
navigate the majority of the application.
Database: Sybase Server 12 (using Unix VI)
Application: Powerbuilder 9.0
August 2002 November 2003
Senior Software Engineer/Database Developer Continental Promotion Group, Inc.
Overview:
Maintained the Prism application/database. This is a system that keeps track of
rebate transactions and promotions between the consumer and the promoting
corporation. This system also handles billing information, custom reporting, and
consumer and customer information.
Database: SQL Server 6.5/7.0/2000
Application: Powerbuilder 6.5/7.0/8.0
November 2000 August 2002
Senior Software Engineer/Database developer Phelps Dodge
Overview:
Re-engineered and maintained the Land Administration Management System (LAMS) -
LAMS is an application/database that is used to keep track of property
information for Phelps Dodge. The system also keeps a general ledger and tracks
legal contracts with counties throughout the U.S. Re-wrote the application into
a fully functional secure enterprise application from a completely non-working
state.
Maintained the Capital Appropriations Consolidation System (CACS) - CACS is an
application/database that is used to forecast budgets for proposed projects. The
system tracks paper trails for projects in the budget approval process and is set
up to track over many years.
Maintained the Exploration Operations Data Consolidation System (EODC) - EODC is
an application/database that keeps track of results when the Phelps Dodge
exploration team goes out to sites and drills for core samples for copper mining.
The system tracks the location, the success, and the budgeted amount for
drilling.
Maintained the Phelps Dodge Order Entry System (PDOE) PDOE is an
application/database used to keep track of copper sales, inventory, and
transportation methods/schedules for the PD mines and the purchasing customers.
Created interactive web site using ASP for surveys within the corporation.
These web pages were secure and connected to a SQL Server 2000 database.
Database: Sybase Server 10/11, SQL Server 2000
Application: Powerbuilder 6.5/7.0/8.0, ASP
June 1997 November 2000
SA/DBA/Database Developer/Software Engineer Acxiom
Overview:
Created and maintained the MBNA Job Tracking System (JTS). The JTS is an
application/database that tracks the progression of jobs through data comparison
processes and is used by approximately 70 associates. Also implemented trend
analysis systems, sizable reports and graphs, and a billing system that processes
revenue at a multi-million dollar level. The JTS has been responsible for
eliminating the need for working overtime hours within the team.
Designed and implemented a new Dell server and successfully migrated the JTS
database over to the new server.
Created the PDO (Paid Days Off) Tracking System. This system is used to submit
any leave of absences. This application/database also keeps accurate balances of
all time accumulated and time taken off. This was used by approximately 200
associates.
Database: SQL Server 6.5/7.0
Application: Powerbuilder 6.5/7.0/8.0
January 1997 June 1997
Software Engineer/Database Developer Data Dimensions
Overview:
Created a customer tracking system. This application/database tracks customers
and requests for development of instruction manuals for companies such as
Honeywell and Boeing. Also built a server for the application/database that
hosts a network of approximately 40 clients.
Database: SQL Server 6.5
Application: Powerbuilder 6.5
May 1996 January 1997
Software Engineer/Database Developer DeVry Institute of Technology
Overview:
Created an application/database for the Veterans Administration Student Loan
Program. This application/database keeps track of students benefits and G. I.
Bill benefit amounts. This system also evaluates students grades to determine
eligibility of future benefits.
Database/Application: Microsoft Access
August 1987 January 1994
Military Enlistment in the Army
Medical discharge date: 12/31/1993
Veteran status: Disabled veteran
Professional Reference's
Mr. Tom Holland, Database/Application Engineer, Oregon Department of Health
Services
Salem, OR
PHONE: (503) 339-4796
Mr. Rob Lotze, Database/Application Engineer, Washington Department of Health
Tumwater, WA
PHONE: (360) 236-3644
Mr. Rick Lowther, Database Developer, SRP, Inc.
Scottsdale, AZ
PHONE: (602) 236-6437
|
