Senior Software Engineer

William Michael Sawvel

360-***-**** / ***********@*****.***

http://www.linkedin.com/in/wmsawvel

== SUMMARY ==

*Information Systems Consultant performing duties ranging from those of Programmer/Analyst to

Project Manager, including Database Administration.

*Over 10 years of experience developing, designing, installing full-scale proprietary software

systems for major business applications.

*Proficient with Visual Studio 2010 / ASP.NET using C## / SQL Server 2008 and MS SQL

*Designed and Created SQL Databases including the writing of stored procedures.

*Excellent organizational abilities and strong decision-making skills.

*Proven talent for adapting to new situations while under stress.

*Readily develop new skills and knowledge.

== PROFESSIONAL EXPERIENCE ==

## Information Systems Consultant ##

Washington State Department of Corrections

August 2000-September 2012 (12 years 2 months) Olympia, WA

Conducted feasibility study to replace a legacy Warehousing System.

*Analyzed processes and User utilization of existing system.

*Developed comprehensive estimate and work plan.

*Utilized SharePoint to store documents developed and gathered during study.

*Converted legacy MSA System to ASP.NET as a proof of concept.

Created a Consumable Inventory System database using SQL Server 2008.

*Developed Database Structure including a comprehensive Data Dictionary.

*Created several support programs to validate and extract data from legacy system.

*Developed procedures to convert, and load data into CIS database.

Developed a Consumable Inventory System with Visual Studios 2010 ASP.NET using C#

*Created N-Tier Consumable Inventory Visual Studio Solution.

*Wrote several Web Controls to standardize and secure data entry.

*Created several Stored Procedures and Full Text Search indexes.

*Worked closely with the Users to insure system performed as required.

Developed new and replacement reports, using MS SQL Server Reporting Services.

*Developed reports for such systems as Consumable Inventory, JBRS, Escapes, and DNA Draw.

*Designed and Created SQL Server Databases including Stored Procedures to support reports.

*Used XML Schemas and BCP to load Report Databases with data extracted from legacy mainframe.

Redesigned, rewrote and supported OBTS-HS, a multi-module Visual Basic GUI system that provides

an interface to the Health Services section of the Offender Based Tracking System.

*Developed method to automatically update OBTS-HS throughout the state when user logs on

*Wrote a Medical Encoding System within OBTS-HS to replace an old MS DOS base application

*Replaced DAO database access methods with ADO in preparations for a .NET conversion.

*Converted Health Services legacy system to VB.NET as a proof of concept.

*Converted OBTS-HS VB6 forms to Winforms as part of a VB.NET conversion.

*Insured converted OBTS-HS complied with industry OOP fundamentals and concepts.

Managed several projects to support the requirements of the Health Services Department.

*Developed a TB Appointment Scheduling System to track inmate PPD testing and reading.

*Created and implemented a new OBTS-HS Dental Waiting List system

*Gathered requirements and created proposal for a Hepatitis C Case Management System.

Provided support as needed for a Server based Correctional Institution Pharmacy System.

*Developed process to feed the front end of CIPS with inmate demographic data.

*Supported ODBC process to collect Pharmacy data from CIPS Servers.

*Created database to monitor trends, changes, and insure Rx Service provision policy compliance.

Designed and automated FTP and SFTP data exchanges between DOC and other agencies.

*Developed a system to request and store inmate mental health information from DSHS/MHD.

*Automated system to send notification of data receipt, via email, to CCO or Prison Counselor.

*Created system to notify DSHS of inmates, receiving mental health care, impending release.

Provided support for an Offender Based Tracking System.

*Solely responsible for change management system using CA-Endevor.

*Developed several DYL280 applications to identify and correct IMS database problems.

*Corrected Victim/Witness, Prison/Work Release, and Field Supervision system problems.

*Modified MSA Inventory system and rewrote Focus Inventory Reporting system.

## Information Sytems Consultant ##

Procedure Products Research

August 2000-December 2008 (8 years 5 months) Vancouver, WA

Managed IT Department reporting directly to PPR CEO.

*Designed user network, purchased hardware, acquired staff, and assigned tasks.

*Maintained house written software package known as EASYMED.

*Purchased and installed DHCP server.

*Developed disaster recovery plan.

*Created interface with UPS Worldship

## Information Sytems Consultant ##

Oregon Department of Transportation

March 1998-April 1999 (1 year 2 months) Salem, Oregon

Y2K Tools Acquisition

Y2K Compliance Certification

## Information Sytems Consultant ##

Northwest Natural Gas

January 1997-March 1998 (1 year 3 months) Portland, Oregon

Y2K QA Testing

## Information Systems Consultant ##

California Federal Bank

March 1996-December 1997 (1 year 10 months) Sacramento, California

Branch Re-Engineering Project

## Information System Consultant ##

Standard Insurance

May 1995-March 1996 (11 months) Portland, Oregon

Commission Migration Project

## Additional Consulting Projects ##

10/94-04/95 Test Management Facility / California Federal Bank

07/94-10/94 Warehouse Management Project / Pope & Talbot

04/94-07/94 AFS Conversion Project / US Bank

01/94-04/94 Pension System Maintenance / Associated Administrators

03/92-01/94 Shaw Conversion Project / First Interstate Bank

07/91-02/92 Bank Control Expansion Project / First Nationwide Bank

04/91-07/91 Inter-CPU Comm Interface / REI

02/90-02/91 Corporate Payroll Conversion / Hughes Aircraft

10/88-10/89 Health Care Service Request / Blue Cross of Washington

== EMPLOYMENT HISTORY ==

02/90-Pres. Sawvel & Associates / Information Systems Consultant

07/86-01/90 Computer Task Group / Senior Software Engineer

07/84-07/86 Devel Software / Senior Software Developer

02/79-07/84 Clark County/Vancouver / Systems Programmer III

12/77-02/79 Blue Cross of Oregon / Programmer Analyst

11/75-12/77 Standard Insurance / Programmer Analyst

08/74-11/75 International Paper / Programmer Analyst

07/73-07/74 Avco Financial Services / Programmer

08/71-07/73 Pacific Standard Life / Systems Programmer

== EDUCATION ==

1999 File-Aid/RDX (Compuware)

1999 Version Merger (Princeton Softech)

1999 Xpediter (Compuware)

1992 Shaw Consumer Loan System (Shaw System Associates)

1991 Marshall & Ilsley Deposit System (Software Alliance)

1987 Cortex Internals (Computer Task Group)

1984 VSAM for the Systems Programmer (Software Information Services)

1983 CICS/VS Internals (On-line Software International)

1980 CICS Installation and Tuning (IBM)

1978 Structured Systems Development (Improved Systems Technologies)

1977 Principles of Life Insurance (Life Office Management Assn.)

1974 VSAM & OS JCL (IBM)

1971 Business Data Processing (Chabot College)

Contact this candidate