Project Manager Sql Server

Scott Royer Last Updated:

**** ***** ***., ***** ****, CA 95404 December 6, 2011

Home Phone: 707-***-****

************@*******.*** www.ScottsWebDev.com

Objective: Part-time Web, Microsoft Access, database, client/server applications design and construction.

Main Skills: Microsoft Access, Web design and construction, Dreamweaver, CSS, Microsoft Visual Studio,

ADO (ActiveX Data Objects), ASP (Active Server Pages), VBS (Visual Basic Scripting),

ORACLE PL/SQL, Microsoft SQL Server, DTS & Transact-SQL, Database Warehousing, Data

Analysis for solving data flow and application functional problems, BRIO, UNIX, Informix,

Project Management, Client/Server Application design and construction.

Royer's Computer Programming Services -- Independent Contractor March 2006 Current

National Indian Justice Center, Santa Rosa, CA December 2011 -- Current

Microsoft Access database consolidation, data normalization, new forms and reports.

Blue Ink Mobile Notary, Palo Alto, CA January 2011 -- Current

Web Master helped design and create site. Ongoing monitoring and Search Engine Optimization (SEO).

Bordenave's French Bread, San Rafael, CA October 2010 -- Current

Added new functionality and reports plus fixed some problems in their Microsoft Access application.

Kelly Snow, Santa Rosa, CA March 2010 -- Current

Web Master helped design and create site with Real Estate information emailed to Kelly Snow.

Thermochem, Santa Rosa, CA December 2008 -- Current

MS Access coding for chemical data entry screens. Complicated data relationships with three levels of nested

subforms that needed automatic data lookup, verification and multi-record updating.

Wine Country Mobile Notary, Rohnert Park, CA November 2008 -- Current

Web Master helped design and created site. Ongoing monitoring and Search Engine Optimization (SEO).

Limos America, Sebastopol, CA June 2007 -- Current

Web Master consulting and developing site content. Applying SEO techniques to improve site page rankings.

Petaluma Farms, Petaluma, CA March 2006 December 2006

Added first management level report to MS Access application so ranch manager and owner could determine

egg production trends based on feed formulas.

Hewlett-Packard and spin off Agilent Technologies, Palo Alto, CA June 1981 February 2006

Senior Development and Analysis Programmer Local site: Santa Rosa, CA

Quality Developer, Designer and Data Analyst for global application January 2000 February 2006

Responsible for the analysis and design of major code changes necessary to keep the Agilent GRACES quality

application functioning correctly as the result of new ORACLE ERP and SIEBEL PI implementations. ERP

and PI data caused unreliable results for Agilent business quality metrics. After analysis of the major problems

and implementation of my proposed code changes, metrics were once again accurate for business use.

Implemented monitoring of ERP and PI data in order to establish trends and provide an early warning of

potential problems. Redesigned AWARD (Agilent Warranty and Reliability Datamart) to make it more user

friendly for ad-hoc reporting. Responsible for conversion of APDAAS report summarization process in

COBOL to ORACLE PL/SQL. AWARD and its MS Access APDAAS GUI interface along with BRIO

reports, allowed Agilent users (managers, engineers, manufacturing, marketing, finance, etc.) to determine

product failure rates and which parts were causing those failures. This helped determine where engineering and

manufacturing resources should be assigned for the best return in customer quality improvement and lowered

warranty costs for Agilent.

Customer Support Knowledge Base Co-Project Manager February 2000 April 2000

Developed Web front-end and SQL Server database. Team of 2 had working model in 6 weeks, finished

application in 3 months. Solution provided quick entry and retrieval of support knowledge and experiences for

RFST systems. One actual case allowed support to do a key word search for error message and associated fix.

The field engineer was able to get the system back in operation within 20 minutes instead of the usual 2 days.

Demo Equipment Y2K Project Manager June 1999 December 1999

Took over project management for stalled RAVEN project a year after it began. Application was in

production three months later. Coordinated and helped code the solution involving Visual Basic, MS Access,

SQL Server, and two-way transfers of data with an HP3000 Image database. RAVEN was a demo equipment

scheduling application that replaced a non-Y2K compliant application. New solution was more user friendly

providing more capability in scheduling and reporting of HP demo equipment.

Systems Warranty Information Web Tracking Developer September 1998 May 1999

Originated solution proposal and then designed, coded and implemented. Application used a Web interface to a

MS SQL Server database to capture system and embedded instrument shipment information. This data was

processed by the warranty application and flowed to end-user reporting of system failures. Consolidated

system warranty metrics had never been available to users before this implementation. This allowed users to

see accurate statistics on system failures and which instruments in those system were causing the failures.

Vendor Y2K Compliance Web Tracking Developer July 1998 September 1998

Built Web interface in 40 hrs. Buyers used to enter answers from phone interviews with over 1000 vendors.

Financial Systems Analysis Developer October 1997 April 1998

SQL Server database design and Transact-SQL coding. Application allowed business project managers to track

real-time costs vs. forecast & budgets as opposed to former monthly paper reports. This solution helped

managers control costs, saving the Santa Rosa Systems Division business substantial amounts of money.

Microcircuit Document and Web Linker Project Manager January 1997 September 1997

Project Manager of 3-person team. Designed, coded a MS Access database with Web reporting. Application

allowed users to catalogue and link Microcircuit Manufacturing documents and processes to the assemblies that

Micro built. This allowed Micro users to quickly determine and locate all associated documentation. This was

critical for build or test process changes and then finding and notifying all other associated processes of that

change. This application saved a dozen hours per change as opposed to the former manual paper research.

Group Quality Programmer April 1994 August 1997

Worked with corporate Quality Control Department to develop APDAAS, a warranty MS Access/Informix

reporting application. Added code for Test and Measurement Organization (TMO) Group specific metrics.

After installing in Sonoma County, spearheaded effort in rollout and support of application for all TMO sites.

APDAAS gave warranty users real-time access to warranty data with search driven reports and graphs.

Senior Finance Programmer June 1986 March 1994

Support, development and installation of new applications for financial and R&D systems. Lead division effort

for physical inventory. Active in depart quality and employee / management communications improvements.

Computer Operations Manager April 1984 May 1986

Supervision and training of computer operations staff. Responsible for department budget and assets. Lead

effort to migrate all applications to new generation of Hewlett Packard 3000 main frame computers.

Finance Programmer June 1981 March 1984

Support and development of new features for cost accounting applications.

California Pacific Insurance Services, Novato, CA August 1979 June 1981

Support and transformation of COBOL applications from Control Data Eclipse to IBM 4331 Mainframe.

Seyforth Laboratories, Dallas, TX September 1976 - November, 1978

Independent Lead Distributor, sales.

Church of God the Eternal, Eugene, OR; Church of God Sonoma, CA July 1975 July, 1979

Contributing Writer, Editor of church literature; assistant in ministerial services.

Worldwide Church of God, Pasadena, CA June 1970 June 1975

High School Instructor, Youth Director & Ministerial Assistant. Instructor in math, journalism, religion, sports.

EDUCATION

Control Data Institute, San Francisco, CA June 1979

Certificate of Completion: COBOL, FORTRAN IV, IBM Assembler, RPG/ RPGII Programming.

Ambassador College, Pasadena, CA June 1970

BA, Masters Program: Theology, Speech and Communication, Secondary Education.

Contact this candidate