Bill Currie's Resume - Microsoft Access Database Developer

For the past five years I have focused on building database solutions. The solutions were implemented using either SQL Server or Microsoft Jet back ends. The user interfaces were created using Microsoft Access Data Project tools (.adp) or Microsoft Access architecture (.mdb). I have a working knowledge of all aspects of the database development cycle. Experience includes requirements analysis, database design, upgrades, ongoing maintenance and support. I make extensive use of SQL and Visual Basic for Applications (VBA). The finished solutions have incorporated conditional processing, robust error handling and the ability to read from and write data to other applications

EMPLOYMENT HISTORY:

Client: Solutions IQ
Database Development Consultant

Bellevue, WA
10/03 to Present

	Tools used: Access 2003 and 2002, VBA, Excel, ADO, DAO, SQL Server 2000, Siebel 4.0 and Win XP
	I develop user interfaces and tools using MS Access. These tools provide the ability to process data and upload the results to the Siebel and SQL Server databases. I work as a member of a team responsible for uploading marketing data into a Siebel CRM database. The data is generated from information entered on web sites created to generate product interest or from surveys filled out by participants at live events. Metrics on the current disposition of each lead in the processing pipeline is uploaded to a reporting database hosted on SQL Server.

Client: Comcast Corp.
Database Developer

Bothell and Everett, WA
1/00 to 10/00
9/02 to 1/03

	Tools used: Access 2000 and 97, VBA, Excel, ADO, DAO, Win NT and 2000
	Developed a system to evaluate and report on the accuracy of order entry at call centers. The system reviews individual orders for specific errors and provides reports to management. On peak days over 2000 orders are processed. This automated system replaced a manual system that, in an 8-hour shift, could review only 5 percent of the work orders processed in an average day.
	Created a trouble ticket database for an IT and Telephony Systems Help Desk.
	Developed a database to manage circuit information for voice and data at a call center. The "voice and data circuit" database stores all of the information for each telecommunication circuit or line used in western Washington. The facilities covered include two large call centers and several remote sales offices.

Client: Hinds-Bock
Database Developer

Redmond, WA
11/00 to 3/01 and
Additional 8 weeks in 2001
Additional 5 weeks in 2002

	Tools used: Access 2002 and 97, VBA, Excel, Outlook, ADO, DAO, Win XP, Win 2000 and Win NT
	Created a Design Criteria Database for a manufacturer of custom food processing equipment. The database provides a central place for Sales, Engineering and Production to store and refer to over 100 items of information on each project. Revisions to the design criteria are logged and staff members are informed of the revisions via email.
	Created a scheduling database for the engineering department that is used as a tool for managing the priorities of each staff member and logging the time spent on each task. The program monitors changes in individual task scope and calculates release dates. Projects that are in jeopardy of not being completed by the ship date are flagged.

Client: AT&T Fixed Wireless
Database Developer

Redmond, WA
6/01 to 8/01

	Tools used: Access 2000, VBA, Excel, ADO, SQL Server 7.0 and Win NT
	Created an automated reporting system to track critical milestones for Base Station deployment nationwide. Used a Microsoft Access Data Project (ADP) front-end linked to a SQL Server back-end. The system determines and indicates which milestones are in jeopardy. This system replaced an Excel method that consisted of collecting spreadsheet information from 5 internal departments and pasting together a semiweekly report.

Client: Seattle TM Program
Database Developer

Seattle, WA
5 weeks 2002 to 2003

	Tools used: Access 2002, VBA, Excel, ADO, Outlook, Win XP
	Created a database to track member and donor information for a non-profit organization. Email address information stored and updated in the Access database can be transferred into Outlook with the click of a button. Excel was used to clean the data and transform the data from flat table to relational table form.

Client: Travis Industries
Database Developer

Kirkland, WA
3 weeks 2001 to 2003

	Tools used: Access 2000 and 97, VBA, DAO, ADO, SQL Server 2000, DTS and Win 2000
	Added automated functions to existing Access databases. Redesigned queries to improve their performance. Developed a DTS (Data Transformation Services) package that used VB Script to filter and transform data as it was moved between two databases.

EDUCATION:

MBA, Maharishi University of Management

BS, University of Maine
Major: Electrical Engineering