J. Ian Wilson
5117 Parkerwood Dr
Knightdale, NC  27545
919-906-5015
jefferyianwilson@yahoo.com

--Objective
  To apply my broad technical skills, creative talent,
    and love of problem solving to help improve the way
    organizations do business and present information.

--Education
NC Wesleyan College
 Aug 2001 - Apr 2004
 Rocky Mount, NC
Bachelor of Science
* Computer Information Systems
* GPA 3.66, Magna Cum Laude

NC State University
 Aug 1993 - May 1999
 Raleigh, NC
Some Course Work (left in good standing)
* Computer Science and Education (left in good standing)
* Enrolled in Air Force ROTC, Attended bootcamp at Lackland AFB


--Skills
* Visual Basic 6.0 & .NET
* MS Access
* MS SQL
* Gnu Emacs
* C++ in UNIX
* Windows XP/2000/NT/98
* MS Office
* Relational database design
* Adobe PhotoShop
* JavaScript / Web Design
* Dreamweaver MX
* Flash MX (with Actionscript)


--Experience

Applied Environmental
 Mar 2007 – Present
 Raleigh, NC
Database Application Developer
* Contracted position nearing end of term. Hired
   to augment and debug existing applications,
   in addition to creating new ones as needed.
   Total Microsoft shop. Database back-ends:
   MS-SQL, internal front-ends: Access Projects,
   external interface: ASP.NET web-pages. General
   scope of projects: accreditation testing for
   members of that industry. Some testing was
   administered thru an online interface.
* Created an Access database with form interface
   to document and report on a survey given to
   clients.
* Debugged and augmented a large database that
   tracks shipments of test samples (related to
   bio lab work) and results and reports on
   results.
* Debugged and augmented a large database similar
   to above except this test was administered
   online and results captured online.
* Both major applications were heavy on Stored
   Procedures and Table Triggers.

General Parts Inc. (Carquest)
 Mar 2006 - Mar 2007
 Raleigh, NC
Database Application Developer
* Full life cycle development of applications in
   VB and VBA in Access that connect to Access
   databases and Oracle databases.
* A part of a group that creates custom ad hoc
   applications for the company's corporate
   headquarters.
* Primary project assigned to a group that
   collects and validates data to feed the
   company's "Next Generation Catalog Project"
* Projects cover raw data manipulation and
   validation, and custom applications for data
   presentation and analysis.
* Help shape policy and procedure, and trained
   new hires for the primary project.

Postal Innovations at IBM
 Jul 2004 - March 2006
 Raleigh, NC
Tier 2 Help Desk Analyst / Asst Database Admin
* Diagnose and solve most computer issues remotely on the
   world's largest Windows Active Directory network.
* "Sensitive" level Federal security clearance with the
   US Postal System.
* Level Two issues for point-of-sale computer systems require
   strong customer service and "outside the box" problem
   solving skills.
* Designed and created databases and applications for the
   Help Desk. (see "Projects" below for details)
* Authored HTML documents for the Help Desk Knowledge Base.

Security Engineering
 Feb 2002 - Jun 2004
 Raleigh, NC
Asst Branch Manager
* Responsible for building and maintaining multiple high
   volume customer and vendor relationships.
* Responsible for purchasing, cash receivables, analyzing
   inventory levels, receiving, data entry of product, vendor,
   and customer information.
* Assist in the commercial or residential design of security,
   fire, home theatre, intercom, and CCTV systems for customers.

Stage/AV Technician
 Dec 1995 - Feb 2002
 Raleigh, NC
Self-employed / Freelance
* Designed and engineered lighting and sound systems for
   concerts, theatrical productions, etc.
* Supervisor at NCSU's Stewart Theatre and currently an on call
   supervisor.
* Responsible for interfacing with clients and managing crews
   of up to ten technicians covering all aspects of stagework.
* This line of work has provided me with the experience of
   competently leading small teams under high pressure,
   high stress situations; and has refined my sense of design
   and aesthetics.


--Projects
*Projects at Applied Environmental:
 + Created an Access database with form interface to document
    and report on a survey given to clients.
 + Debugged and augmented a large database that tracks
    shipments of test samples (related to bio lab work) and
    results and reports on results.
 + Debugged and augmented a large database similar to above
    except this test was administered online and results
    captured online.
 + Both major applications were heavy on Stored Procedures
    and Table Triggers.

*Projects at General Parts Inc. (Carquest):
 + Primary Project: A rather complex Access application that
    imports raw catalog part data from vendors, validates data,
    reformats data, generates reports based on the data.
    Application has 23 tables, 106 queries, and 3500 lines of
    code.
 + An Access application that allows a certain department to
    categorize and organize car parts into a hierarchy.  Users
    wanted a treeview interface, and wanted the ability to
    re-arrange the hierarchy and add meta data to each "leaf"
    on the tree.
 + A basic application that reforms character delimited text so
    that the delimiting characters line up vertically when
    viewed with any text editor.  User has option to pick
    delimiting character, column width, and text editor.
 + A custom application installer: moved and unzipped files
    with one click from the user.  The application monitored
    its own process and notified the user when the process was
    complete.

*Professional web design:
 + Designed from scratch http://www.pcmlawncare.com/
    (site might be down, client went out of business)
 + Complete ground-up build of this 80 page site
    http://www.ccml.org/
    Pages contain JavaScript powered DHTML, and fully take
    advantage of CSS.  This site meets W3C standards.
 + Apprenticeship with Magnetude Media:
    http://www.magnetude.com/
 + My own website with Flash http://furycelt.freeshell.org/
 + A list of vendors: http://furycelt.freeshell.org/kiltList.html

*Visual Basic 6.0 Projects for work:
 + Profit margin calculator that I use at work.  Capable of
    showing simultaneous margin levels and can do reverse margin
    calculations.
 + Cash calculator for assisting in managing a cash drawer.
    Inputs are number of coins/bills of each denomination and
    ledger amount.  Outputs are cash total and comparison with
    ledger amount.  This application features automatic focus
    advance for ease of use.
 + Intranet Chat program.  Security issues at my current job
    prevented the use of Same Time, Yahoo Instant Messenger and
    the like.  I made a similar program from scratch that was
    tailored to Help Desk needs. This application was developed
    with testing phases, used a MS Windows worthy installer, had
    full error trapping, version sensing, and took advantage of
    the MS Winsock OCX over TCP.  User options persisted over
    sessions; messages were archived locally; data files were
    updated and backed up automatically; multiple instances were
    prevented; code was tweaked to minimize network resources;
    and the GUI was steamlined for ease of use.
 + Created a database in MS Access to store and analyze employee
    evaluations.  Evaluations were given to management in the
    form of an HTML file.  An application was created to parse
    the HTML dump the data into the database.

*Visual Basic 6.0 Projects for personal use and school:
 + Basic time calculator with addition and subtraction for
    minutes/seconds or hours/minutes.
 + An image display program that aids in the visualization of
    how an image will look if cropped to certain ratios.  I use
    the application in my photography.  I can select standard
    print size ratios or input custom dimensions.  The
    application will superimpose lines to show the
    "rule-of-thirds" for better artistic evaluation.  I found
    this task to be cumbersome in Adobe PhotoShop which is why
    I created this application.

*MS Access and VBA for school and volunteer work:
 + I volunteered my skills to and organization that supports my
    home town county library.  I took an Excel spreadsheet
    containing 500 records containing name, address, phone
    information and donation amounts and members status.  I
    created nested switchboards to access a series of
    comprehensive reports, mailing list labels, and queries,
    and to access forms and macros for controlled end-user input
    and database maintenance.  The code behind the main form and
    sub-forms validates and anticipates user input.  This
    application allows the organization to now track donation
    history of members and provide a better view of their
    organization's standing.
 + My senior project was to take a fictitious company that had
    no computing technology and bring them into the modern
    IT/IS world. This company was a shopping mall with 85
    tenets, game room, movie cinema, security force, maintenance
    staff, daycare, and health club.  All aspects of these
    departments had to be tracked in a database (worker, member,
    patron demographics, payroll, revenue, fixed expenses,
    variable expense, landlord duties, etc.).  The 20 table
    database was built in MS Access with VBA coding.