Jim P.

## BIO Jim R. Patterson                                                                                                                                                                         RESUMÉ CONSULTANT, PROGRAMMER, DEVELOPER PROFESSIONAL SKILLS: 18 Years experience in Public Transit Systems  CLIENT LIST:                          Applied Materials                         EndWave                         Pacific Bell                          Pharsight                         SIEMENS                         Maxtor (MMC Technology)                         Farmers Insurance                         ENTEX Information Services                         Lake Tahoe Community College                         Satellite Marketing                         Gemological Research CONSULTING PROJECTS: I have built several major applications including programs that; 1.       Track maintenance calls for users that are having computer hardware problems (Call Tracking System). This program was integrated into a web Intranet site and was used by 65 branch locations. The database was an ODBC connection to an ORACLE database. 2.       Track new assets that were being purchased and installed throughout the             state of California by Pacific Bell. Total volume of assets tracked was in             excess of 80,000 separate components 3.       Point-and-Click Report generating program for end-users. This program             allows department managers to create reports in Access without needing to know             how to use Access 4.       Enterprise Reporting System. I worked as the senior Access programmer             on a team of six. We developed a reporting system that combined data from two AS400 computers and stored the data in an ORACLE data-warehouse. I developed the           GUI interface, report templates, security, data integration and revision control modules. 5.      Tied together an Access database and the web using ASP, ADO, XML and             CSS. This database is used to collect information from customers and to make             that information available to all company departments in order to provide a             project quote for services that the customer is requesting. 6.      Tied together a web site that provided marketing information. This site is state-of-the-art. It uses Exchange 2000, SQL Server 2000 and Outlook 2000 and Digital Dashboards. WORK EXPERIENCE LAKE TAHOE COMMUNITY COLLEGE (May 2002 – Present) Programmer and Research Analyst FARMERS INSURANCE (Jan 2002 – April 2002) Contract Access Programmer / consultant MMC Technology (May 2001 – November 2001) Contract Access Programmer / consultant Design consultant for a very complex Access to SQL Server upsizing project. This project involved redesigning the clients test data collection process. The existing process consisted of over 140 Access databases located throughout the facility. I redesigned the process to incorporate all information in SQL Server 2000. Eliminated complex data collection processes and provided detailed reports, performance tuning, application design and detailed design documentation. ENDWAVE (March 2001 – May 2001) Contract Access Programmer / consultant Short term contract as a design consultant for an Access to SQL Server upsizing project. This project involved streamlining an existing manufacturing shop floo ## Area of Expertise 14 years experience Computer / WEB Programmer - Analyst Expert Knowledge of Microsoft Office products including; Excel, PowerPoint, Word, Outlook and Internet Explorer including Office 2000, SQL Server 2000, Outlook 2000 and Exchange 2000, VISIO and Project. WEB Design, including HTML, DHTML, ASP, XML, VBScript, JScript, VBA, CSS Microsoft NT administration. Administrated a multi-server network containing both Novel and NT servers Novel Certified Netware Engineer   (CNE) Knowledge of PERL, CGI, PASCAL, FoxPro, dBase, IIS, SQL Server, PL/SQL, T-SQL, Interdev, TCP/IP, Access, Outlook, Exchange, Delphi, VBA, VBScript, Jscript, Oracle, JAVA, Excel, ASP, VBA, Call management programs including, REMEDY , DPU and ASTEA Computer Field Technician certified on many hardware components including Compaq servers