Brian Prestwood
Software Architect
Summary
Experience…
- 20 Years Industry Experience
- 15 Years Microsoft Software Development Toolset Exprerience
- 10 Years as Technical Lead (Architect) on Multi-User N-Tier Projects wth the Microsoft Toolset
Provides the technical expertise required to deliver large business systems. Responsibilities include requirements analysis, architecture, design, development, deployment, user documentation and training.
Work History…
Tech Lead, Distributed App, California Department of Education, Sacramento, CA, 9/04 – 3/05
Tech Lead, Terminal Server App., California Department of Forestry, Sacramento, CA, 1/01 – 8/01
Trainer, Microsoft Certified Solution Developers, New Horizons, Sacramento, CA, 1/00 - 10/01
Tech Lead, Intranet App., California Department of Health Services, Sacramento, CA, Started 1/99
Tech Lead, Desktop App., California Department of Education, Sacramento, CA, 4/97 – 1/99
Tech Lead, Distributed App., Hewlett-Packard Consulting, Roseville, CA, 3/97 – 9/98
President, Sacramento VB Users Group, Sacramento, CA, 1/97-2006
Sr. P/A, Distributed App., Vision Service Plan, Sacramento, CA, 12/94 – 3/97
P/A & Sr. SE, TransAmerica, Los Angeles, CA, 3/94 - 12/94
P/A, ARCO Products Division, Los Angeles, CA, 11/92 - 1/94
Sr. SE, Veatch-Carlson, Los Angeles, CA, 4/92 - 11/92
SE & P/A, DeScribe Inc., Sacramento, CA, 5/91 - 4/92
SE & P/A, ACS Computers, Sacramento, CA, 5/89 - 5/91
Computer Operator, Intel Corporation, Folsom, CA, 2/88 - 5/89
Technical Illustrator, AeroJet ASRM Division, Sacramento CA, 7/87 - 2/88
SE, Western Farm Credit Bank, Sacramento CA, 5/87 - 7/88
Tools…
Development: Visual Studio .NET, Visual Studio 6, Embedded VB and Crystal Reports
Internet: IIS, ASP.NET, Javascript, AJAX, XML, XSL, CGI, HTML and DHTML
Database: MS SQL Server (including MSDE and CE versions), Oracle Server & Microsoft Access
Operating Systems: Windows (NT, 2000, XP, Server 2003 & CE), Terminal Server, MTS and MSMQ.
Business: Microsoft Office Pro, Visio & Microsoft Project
Project Phases…
Requirements: research, write and present: proposals, feasibility studies and requirements.
Architecture: qualify resources, including: technical staff, tools, methodologies and standards.
Design: develop database schema, write coding standards and design system infrastructure.
Development: code system infrastructure and iterate through the unit code/test cycle
Deployment:- facilitate user acceptance testing, write end-user documentation and train the trainers.
Industries…
Education, consulting services, insurance, medical, financial, petroleum, legal, law enforcement, commercial software and electronics
Experience
Sr. Programmer/Analyst, Conveyent Software Inc., Sacramento, CA, Started 2/02
Pocket PADI DiveLog is a commercial Pocket PC 2002 (Windows CE) application for logging SCUBA dives. Version 1.0 Architecture: N-Tier logical, Embedded VB front end, Embedded VB middle tier and Pocket Access back end. Version 2.0 Architecture: Replaced front end and middle tier with Visual Basic .NET Smart Device Extensions. Replaced back end with SQL Server CE.
Technical Lead, California Department of Forestry, Sacramento, CA, 1/01 – 8/01
The California Department of Forestry maintains high levels of fire fighting preparedness statewide. The Respiratory Protection Program application is a turnkey system. It tracks the respiratory equipment certification status of the fire fighters in the state. Architecture: 2-Tier physical hosted on Terminal Server, N-Tier logical. Visual Basic 6 clients that access in-process COM business objects. Business objects access data services objects that manages an Oracle Server 7.3 backend. Methodologies: JAD requirements, top down analysis, structured & object oriented design and RAD development with structured & objected oriented programming. Technical Team: a project manager, a technical lead, a DBA, a systems engineer and two senior programmer/analysts.
· Gathered & Documented Requirements
· Designed & Documented Technical Specification
· Created Schema
· Coded Application Framework
· Tested Application
· Deployed Application
Instructor – University of California Extension, Sacramento, CA, 9/01
Prepared materials and taught Data Access with ASP course.
Technical Trainer –MCSDs (VB Track), New Horizons, Sacramento, CA, 1/00 - 10/01
New Horizons is an international private technical training school that is authorized by Microsoft to deliver technical education center courses (ATEC). The Microsoft Certified Solution Developer (MCSD) track, VB specialization, prepares programmers to lead desktop, enterprise and internet projects using Visual Basic and Visual InterDev with the Microsoft enterprise tools (SQL Server, IIS, MTS & MSMQ). Class Preparation: read all materials, do all practices, do all labs, pass course exam and setup classroom. Taught Microsoft Certified Solution Devloper (MCSD) Courses.
· 2071 (2X) – Querying MS SQL Server 2000 with Transact SQL
· 833 (2X) – Implementing a Database on Microsoft SQL Server 7.0
· 1298 (2X) – Mastering Distributed Application Design and Development Using Microsoft Visual Studio 6
· 1016 (4X) – Mastering Enterprise Development Using Visual Basic 6
· 1013 (5X) – Mastering Microsoft Visual Basic 6 Development
· 1303 (2X) – Mastering Visual Basic 6 Fundamentals
Technical Lead, California Department of Health Services, Sacramento, CA, Started 1/99
The Primary Care and Family Health division of the California Department of Health Services awards 300 million in contracts to its 300 client agencies annually. The Contract Management Information System (CMIS) application is a turnkey contract management system. It generates budgets and contracts then tracks invoices against contracts and budgets for all branch contracts. Team: a project manager, a technical lead, a senior programmer/analyst a lead business analyst and two business analysts. Phase I deployed to 20 users. Phase II deployed to 150 users.
· Gathered & Documented Requirements
· Designed And Documented Technical Specification
· Created Schema
· Coded Application Framework
· Lead Development Team in Implementation of Framework
· Created Test Scripts
· Deployed Application
· Wrote User Docs
· Trained Users
Phase II Architecture: Split business servers up, one per business entity. Removed all state from business servers. Replaced VB front end with ASP front end. Prototyped .NET Framework middle tier replacement for COM framework.
Phase I Architecture: N-Tier (Microsoft Solution Framework), Visual Basic 6 clients that access COM business object (via MTS). Business objects access data services objects that manages a SQL Server 7.0 backend.
Technical Lead, California Department of Education, Sacramento, CA, 4/97 – 1/99
The California Department of Education handles the apportionment of $12 billion in educational funds to the 1000 California school districts.
The K12, J29 and J18/19 Applications are turnkey data entry system for gathering legislated revenue limits, tax and attendance data from the 1000 California school district offices. K12 Architecture: N-Tier, dual GUIs (rich VB6 & pure HTML) access business objects (via COM or IIS 4.0 w/ ASP). Business objects access data services objects which manages a JET database backend. J29 Architecture: VB 4 GUI on Windows (3.1X and 95) workstations with a JET database backend. J18/19 Architecture: VB 4 GUI on Windows (3.1X and 95) workstations with a custom written light database engine back-end. Methodologies: JAD requirements, top down analysis, structured & object oriented design and RAD development with structured & objected oriented programming. Team: a manager, a technical lead, a programmer/analysts and a senior business analysts and a business analysist.
· Gathered & Documented Requirements
· Designed and Documents Technical Specification
· Coded Custom Database Engine
· Coded Form Management Framework
· Coded Formula Engine
· Coded Validation Engine
· Lead Development Team in Implementation of Framework
Technical Lead, Hewlett-Packard Consulting, Hewlett-Packard Corp., Roseville, CA, 3/97 – 9/98
Hewlett-Packard Consulting is the technical consulting division of Hewlett Packard.
Insight is the consulting engagement management system for Hewlet-Packard Consulting. Architecture: VB 4 GUI on Windows (95 and NT 4.0) workstations, Open Environment Computing (OEC) over TCP/IP middleware, Oracle 7 SQL Server data warehouse backend. Methodologies: JAD requirements, top down analysis, structured & object oriented design and RAD development with structured & objected oriented programming. Team: a project manager, a technical lead, a senior programmer/analysts, a DBA and a business analysts.
· Lead Currency Exchange Rate Enhancement Release
· Coded Visual Interdev Admin App For Managing Currency Exchange Rate Tables
· Coded DCOM Admin Application For Managing Third Party Expenses
· Coded Cost Projection, Product Line Analysis (OLAP) And Frozen Projection (OLAP) Modules
· Coded CGI Application For Submitting Knowledge Base Files Via HTTP
· Coded Targeted Profit Modules
· Coded DLL Verification Module
· Implemented MS Visual Source Safe (Source Code Control)
· Implemented MS Anomaly Tracking System (Defect Tracking)
President and Web Master, Sacramento VB Users Group, Sacramento, CA, 1/97-1/07
The Sacramento Visual Basic Users group hosts monthly discussion groups.
· Chaired meetings
· Developed and maitained dymanic (database driven) website
· Presented “Programming with Microsoft Visual Basic .NET” series from Microsoft 2373 Course of same title
· Presented “Programming the Document Object Model” series
· Presented Windows CE Development with Embedded VB
Senior Programmer/Analyst, Vision Service Plan, Sacramento, CA, 12/94 – 3/97
Vision Service Plan. is a vision care HMO that services 50K client organizations through 3K member doctors and 300 member labs.
The Managed Eyecare Delivery System (MEDS) processes 35K medical claims per year. It is the prototype for the HMO system that will process 2M claims a year. Architecture: VB 4 GUI on NT 3.5 workstations, TCP/IP (via Ethernet) middleware, NT SQL Server 6.5 and CA/IDMS (mainframe) back ends. Methodologies: JAD requirements, top down analysis, structured & object oriented design and RAD development with structured & objected oriented programming. Team: manager, two senior programmer/analysts, six programmers, a DBA, two data processors and four business analysts.
· Converted Working Storage from JET Tables to SQL Server Temporary Tables And Stored Procedures
· Converted Non-Standard Interface to Windows GUI Standard
· Debugged Dr. Watsons
· Coded Error Wizard
· Coded Automated Stress Testing Engine
· Tracked Defects with SQA
· Set up PVCS (source code control)
The Electronic Doctor Communication (EDC) system linked the doctors and labs through the VSP Host to allow real time transfer of 1M prescriptions per year. Architecture: VB 3 GUIs on Windows 3.11 workstations, TCP/IP (via internet) middle ware, CA/IDMS and VSAM (mainframe) back end. Methodologies: JAD requirements, top down analysis, RAD development with structured programming. Team: a manager, lead, three Senior Programmer/Analyst programmers and two business analysts.
· Prototyped JAD Team and Workflow Interface Requirements
· Coded Data Access SQL modules
· Coded Barcode Reader Interface modules
· Created Crystal Reports
· Coded Macro Recorder and Transaction Log modules
· Documented Design And Wrote Maintenance Manual
· Started and Chaired Vision Service Plan VB Users Group
· Set up PVCS
Programmer/Analyst & Senior Systems Engineer, TransAmerica, Los Angeles, CA, 3/94 - 12/94
The Living Benefits Division of Transamerica handles all aspects of selling and maintaining living benefit annuities.
The Non-Qualified Tax Sheltered Annuity Module (Non-Qual TSA) of the DivTrack 2000 system processes 30K living benefit tax sheltered annuity payments per year. Architecture: VB 3 GUIs, TCP/IP (via ethernet) middle ware, NT SQL Server 4.2, MDI DB2 SQL Gateway and Mainframe Navigator (screen scrapping engine) back end. Methodologies: JAD requirements, top down analysis, RAD development with structured programming. Team: manager, two senior programmer/analysts, two programmer/analysts, two programmers, senior systems administrator, systems administrator and three business analysts.
· Coded Mainframe Navigator Screen Scrapping Engine
· Coded MFS to Mainframe Navigator Converter
· Lead Non-Qual TSA JAD Sessions
· Wrote Non-Qual TSA Requrements
· Coded Non-Qual TSA System
· Set up PVCS
· Member Of The SMC ES/1 Switching Bridge-Router Installation Team
· Automated Network Status Reporting With Bindview
· Upgraded Servers From Netware V3.11 To V3.12
· Co-chaired TransAmerica VB Users Group
Co-Author - PC Alive, SAMS Publishing, Carmel, IN, 1/94 - 3/94
SAMS Publishing is a technical publishing division of Prentice- Hall. PC-Alive covers all aspects of multi-media. Wrote the 300 pages that covered multi-media hardware.
Systems Engineer, Hughes Aircraft, Los Angeles, CA, 1/94 - 3/94
The Corporate IS Dept. (CorpIS) of Hughes Aircraft provided technical support for the 1,100 workstations and the associated network in the corporate headquarters.
· Setup workstation test/configuration area
· Setup monitors, keyboards & cables
· Installed Microsoft Office admin installation on the network for unattended installation
· Configured boot diskettes to attach to the network and download all necessary files
Programmer/Analyst, ARCO Products Division, Los Angeles, CA, 11/92 - 1/94
ARCO Products Division provides back room support to approximately 1,400 ARCO AM/PM Gas Stations and Smog Pro retail outlets.
The Macintosh Migration project converted 400 Macintosh work stations to Windows work stations in the corporate headquarters. Methodologies: JAD requirements, top down analysis, RAD development with structured programming. Team: two managers, two programmer/analysts and six data processing specialists.
· Developed And Documented Batch Mode Conversion Procedures
· Re-Hosted Carrier Insurance Certificate Tracking System From FileMaker To MS Access
· Re-Hosted Workers Compensation Analysis System from Reflex To MS Access
· Re-Hosted Customer Service Application from Panorama To MS Access
· Re-Hosted Tanker Truck Maintenance Tracking System From Panorama To MS Access
Senior Systems Engineer, Veatch-Carlson, Los Angeles, CA, 4/92 - 11/92
Veatch-Carlson is an eighty employee law firm specializing in personal injury defense.
The Annex Office project consisted of setting up and piloting a 20 user Netware V3.11 network as a working test bed for the 60 station network in the main office. Documented computer resource requirements. Setup the Annex Office network. Provided day to day support.
· Set Up Workstations
· Installed Wordperfect Office
· Set Up PC-Dial Up Communications Servers
· Installed Legal Industry Specific Software
· Set Up Document Imaging Work Station
Systems Engineer & Programmer/Analyst, DeScribe Inc., Sacramento, CA, 5/91 - 4/92
DeScribe is a fifty employee company that develops and markets an OS/2 & Windows based word processor.
The corporate sales department handles large corporate clients.
· Coded Custom Features for Large Corporate Customers in Describe Macro Language
· Wrote Technical Bulletins (White Papers) On Describe, OS/2 and Windows,
· Provided Technical Support for the Field Sales Staff and Corporate Customers
· Administered the Sales Department’s Netware V3.11 Token Ring Network
· Administered the Server Based 60K Record Corporate Customer xBase Database
· Provided On-Site Trouble Shooting for Corporate Customers
· Taught the DML for Programmers Course
Education and Training
Training/Certificate Programs
Passed Microsoft Certified Solution Developer (Tech Lead) Exams
· 70-100: Analyzing Requirements & Defining Solution Architectures
· 70-029: Implementing a Database Design on Microsoft SQL Server 7.0
· 70-175: Designing & Implementing Distributed Applications with Microsoft Visual Basic 6.0
· 70-176: Designing & Implementing Desktop Applications with Microsoft Visual Basic 6.0
Completed Microsoft Certificate Courses:
· 2373 – Programming with Microsoft Visual Basic .NET
· 2071 – Querying MS SQL Server 2000 with Transact SQL
· 833 – Implementing a Database on Microsoft SQL Server 7.0
· 1298 – Mastering Distributed Application Design and Development Using Microsoft Visual Studio 6
· 1017 – Mastering Web Application Development Using Microsoft Visual InterDev 6
· 1016 – Mastering Enterprise Development Using Visual Basic 6
· 1013 – Mastering Microsoft Visual Basic 6 Developement
· 1303 – Mastering Visual Basic 6 Fundamentals
Attended Visual Basic Insiders Technical Summit (VBITS):
· Los Angeles 1994
· San Francisco 1998
Misc. Certificate Courses:
· Netware V3.11 Service & Support (CNE Course)
· Netware V3.11 System Administration (CNE Course)
· Netware V3.11 Advanced System Administration (CNE Course)
Computer Science Major, California State University, Sacramento, CA
Completed one hundred semester units toward a BSCS, Completed courses include:
· Pascal For Engineering Students
· Data Structures, File Organization & Management
· Graphics Software Design
· Survey Of Programming Languages
· C Programming In The Unix Environment
· Structured Programming With BASIC