OBJECTIVE

Programmer/Analyst seeks work that will allow me to use my skills to provide solutions for today’s problems.

SKILLS

• Project development
• Problem Solver
• Cost analysis
• Financial management
• Application development
• Worked with new business development projects involving Engineering, Environmental, Aerospace, Transportation, Legal, Wholesale, and Retail businesses.
• Proficient developer in MS Access, Excel, VBA, SQL, Visual Basic, VB.Net.

WORK HISTORY

Confidential,
Consultant
March 2009 to July 2012

• Developed various MS Access projects with Access 2007 and 2010. Projects involved transportation, sales, non-profit, Mining and Environmental.
• Set up tracking system using MS Access for wildlife activities at wind generating facilities for Montana and Wyoming.
• Most recent project tracks Environmental Water Quality for mining industry.
• Developed reporting system of field and lab data meeting standards of state environmental agency for Catena Consulting .

Confidential,
September 2007 through January 2009

• Using tools developed with MS Access, performed IOC & IAPS Mapping of NDO (Network Data Object) Identifiers from LRU’s (Line Replaceable Unit) to Data Concentrator Unit.
• Performed data integration of Binary and Discrete data following ARINC 429 protocols. Located and repaired data errors in various Avionics programs.
• Contributed to the development of best practice documents. Met with staff weekly.

Confidential,
Programmer/Analyst (Contract)
December 2006 through August 2007

• DevelopedPrediction Analysis tool based on PRISM protocols using MS Access 2003 and 2007 to calculate and store the reliability and failure prediction rates of electronic parts used in Military and Aerospace Systems.
• Failure rate requires the calculation of 10 to 12 Pi Factors for each part category (of 12 categories).
• Modules built to Calculate Operating Hours Before Failure (MTBF) performed on 109 different part types using the PRISM Prediction Model.
• More than 32,000 lines of VBA and SQL code in 680 procedures were developed for this tool. Tool provides user with ability to input actual environmental parameters for individual parts used in a System’s electronic circuit.
• A fully automated project data import process was provided with additional utilities for maintenance and file linking.

Confidential,
Programmer/Analyst (Contract)
July 2006 through September 2006

• Redesigned and upgraded MS Access 97 application to MS Access 2003 that is used to manage hiring processes. Previous application lacked required speed and functionality.
• Upgrade provided additional functionality and automation through the use of VBA code and SQL statements.

Confidential,
Programmer/Analyst
March 2003 to April 2006

• Developed and maintained Access databases for various departments within SYSCO Montana.
• Wrote and maintained queries on AS400 for extraction of data to populate reports.
• Created reports using either MS Access or Business Objects and also used Business Objects to create pass through queries for use in Access databases.
• Wrote SQL statements, normalized tables, created forms and menu systems for automating database functions using VBA code modules to accomplish tasks and database functions.

Confidential,
Consultant
April 2001 to March 2003

• Owned and operated a consulting business administering computer networks, repairing and building computers, and performing relational database design and development.
• Built Access databases for lawyers, tax consultants, engineers, and other small businesses and government agencies. These databases stored and tracked data for mail logs, faxes & other communications, document automation, project information, and client data.

Confidential,
Systems Administrator
Feb. 1999 to Apr 2001

• Developed a relational database using Access 97 to track a nationwide client base and provided a system of automated document generation for response to various state and federal tax agencies.
• Configured and administered an Ethernet Network running NT 4 on an HP Server.
• Performed maintenance on this system including RAID 5 on SCSI hot swap drives.
• Maintained a backup system using DAT drives and supervised the storage of data both on and off site.
• Conducted training classes for staff in Microsoft Office in preparation for their MOUS certification.
• Wrote and developed code modules using Visual Basic, VBA, and SQL statements for report generation, document automation and storage of electronic documents and client data.

Confidential,
Web Master/Programmer (Contract)
Sept. 1998 to Jan. 1999

• Developed and maintained a website for a national marketing program of specialized videos and printed materials.
• Developed an Email and Direct Mail campaign for a national marketing program
• Developed an Access Database to track contacts with prospects and clients and to track orders and shipments.

Confidential,
Consultant
Oct. 1996 to Sept. 1998

• Performed off-site investigative work and tracked people and assets using resources found in public records and on the internet.
• Conducted interviews of witnesses and recorded their statements using audio and video equipment for later use in legal proceedings.
• Developed an Access database for tracking and cross referencing various criminal elements involved in criminal investigations.

Confidential,
Consultant
Oct 1992-Sept.1996

• Developed MS Access system to track income and expenses for truckload owner operators in the transportation industry.
• Provided graphical interpretations of operator’s historical data.
• Consulted with owner operators developing Excel scenarios to make financial decisions based on historical data.

EDUCATION

Mechanical Engineering