Todd Matson

Work History

Advanced Industrial Modeling – Santa Barbara, California July 2006 to Present

• QuickOptimizer: I am the project manager for an application which models the operation of an oil refinery. This project contains several challenging requirements, including the application of linear algebra, real time data management, and sophisticated reporting. (VB.NET)

Westmont College – Santa Barbara, California Oct. 2004 to Present

• OLAP Reporting Tool: I created a data warehouse and OLAP reporting tool for the Admissions department. (Datatel Colleague, SQL Server, MS Access)

• Data Validation App: I created a data validation tool which monitors the ERP database and looks for data entry errors and data consistency errors. (Datatel Colleague, SQL Server, MS Access)

• Scholarship App: I created an application to manage college scholarships. This application allows personnel to monitor the status of scholarships and generate mailing lists of both donors and recipients. (Datatel Colleague, MS Access)

• Reporting Tools: I’ve created several reporting tools and automated data interfaces for Admissions, Human Resources, and the Advancement Office. (Datatel Colleague, MS Access, SQL Server)

• DBA Services: I advise Westmont on the creation of views and stored procedures. (Datatel Colleague, SQL Server)

West Coast Stainless – Los Angeles, California Apr. 2008

• Database Maintenance: I was brought in to debug and restore a mission-critical database application which had failed. (SQL Server)

Davies Communications – Santa Barbara, California Nov. 2001 to June 2007

• Contact Management App: I created a contact management application which keeps detailed, up-to-date information on tens of thousands of county residents. This is a multi-user application with heavy transaction processing activity. (SQL Server, MS Access)

Veeco Instruments – Goleta, California Oct. 2004 to Feb. 2006

• MRP Application: I created an MRP application which collected order information from the corporate ERP system and produced the daily manufacturing plan. (MS Access, Pointman)

• Product Database: I created a product database which manages all sales and marketing data. This is a multiuser database used by several people at various locations. (MS Access, Pointman)

• Product Catalog: I produced several editions of the Veeco Probes product catalog in both print and electronic form. To do so, I created an application which automatically generated catalog pages, with images, from the product database. (MS Access, Adobe Acrobat)

• Corporate Website: I was fully responsible for the Veeco Probes website. During my management of the site, we completely overhauled the site, updating the look & feel, and adding dynamic content generated from the product database. (ASP, Windows Server, SQL Server)

• SAP Implementation: I prepared the Veeco Probes division for the transition from Pointman to SAP. I was responsible for converting data from the Pointman data model to the SAP data model. I was also responsible for training employees on the new business procedures. (SAP)

• Data Analyses: At Veeco, I was responsible for producing ad-hoc data analyses requested by various departments. In that capacity, I contributed to the Probe division’s long-term strategic plan. I also produced weekly metrics used to monitor the performance of the operations and marketing departments.

• Six Sigma: I participated in a Six Sigma project designed to improve the yield for a specific product. The project was successful and I earned Six Sigma certification.

County of Santa Barbara – Santa Barbara, California June 2002 to Jan. 2005

• File Management: I designed and built a file management system for the department of the County Counsel. This multi-user application catalogs thousands of legal files for the county. (MS Access)

UC Santa Barbara Extension – Santa Barbara, California Mar. 2001 to May 2004

• Data Modeling Instruction: I taught the course Data Modeling and Relational Database Design. The course covers entity relationship diagramming in depth and touches on database design using Oracle Designer. (Oracle, Oracle Designer, ERWin)

• MS Access Instruction: I taught a series of MS Access courses called Developing Applications in MS Access. The courses covers topics ranging from relational database design through front-end programming. I created the entire curriculum, including all lectures, notes, and exercises. (MS Access)

• Visual Basic Instruction: One of my courses, Programming in Access, is actually a Visual Basic course. Course topics include programming theory, form design, Active X controls, object oriented programming, using the Data Access Objects, and using class modules. (VBA / Visual Basic 6.0)

Senior Safety, Inc. – Marina del Rey, California Jan. 2003 to April 2004

• ERP Application: I made numerous improvements to a custom accounting / inventory management system. This multi-user application is used to maintain all information on customers, products, and subscriptions. My contributions included performance improvements, bug fixes, and the implementation of several contact management features. (MS Access)

The Leadership Group – Santa Barbara, California Aug. 2003 to Oct. 2003

• Client Management Application: I designed and built a client management system. The main feature of this application is a reminder feature which automatically sends emails to clients in accordance with user defined rules. (MS Access)

ASI / Silica – Woodland Hills, California Feb. 2001 to July 2001

• MRP Application: I designed and created an MRP application. The program automatically schedules part procurement activity based on projected future inventory levels and the manufacturing plan. (SQL Server, MS Access)

Charles Schwab – San Francisco, California Feb. 1997 to Dec. 2000

• Activity Based Costing Analysis: I designed and created a cost accounting database used to quantify and forecast company-wide project costs. This analysis was used to quantify the benefit of embracing the online brokerage model. (MS Access)

• Time Tracking Application: I created an application to monitor employee hours. This application used Oracle for the back-end. (Oracle, MS Access)

• Human Resources Reporting: I created ad hoc reports for the HR department. To produce these reports, I built an interface to the PeopleSoft Human Resources database. (Crystal Reports, Visual Basic 6.0)

• Project Report Cards: I created an application which collected project status information from all project managers. To submit their information, managers were able to use a simple Excel interface. (MS Access, MS Excel)

UC Berkeley Extension – Berkeley, California Mar. 1998 to Nov. 1999

• MS Access Instruction: I created and taught UC Extension’s main series of MS Access courses. I produced 12 full-day classes, including 4 days of instruction in Visual Basic programming. (MS Access, VBA)

Macy’s – San Francisco, California July 1996 to Feb. 1997

• Accounting Database: I designed and developed an accounts payable database for the Visual Merchandising department. This database was specifically designed to deal with new demands created by Macy’s acquisition of May Department Stores. (MS Access)

• Automated Data Processing: I wrote programs to automate several data processing tasks which had previously been performed by hand. (MS Access)

PC World – San Francisco, California Oct. 1996 to Jan 1997

• Laboratory Results Database: I created a database to manage laboratory test data. (MS Access)

Age Wave – Emeryville, California Oct. 1996

• Contact Management Application: I customized an off-the-shelf contact management database for an event-management company. (MS Access)