Database Developer

Stephen Lauzon

University Place, WA

*******.******@**********.*** 253-***-****

PROFESSIONAL SUMMARY

Database Developer - Data Architect - Database Administrator - Application Developer

T-SQL - MSSQL Server 2000-2012 - Data Modeling - SDLC

Authority on data architecture at WDFW - Designed and built statewide inspection system at WSRB

Air Force-wide Zimmerman Award at AFCCC - Promoted to Staff Sergeant in 3 years at ACC Comm Gp

EMPLOYMENT HISTORY

Data Architect, Washington Department of Fish and Wildlife – Olympia, WA 2011-Present

Data Architect at the Washington Department of Fish & Wildlife. Highest authority in the agency in the IT specialty area of data architecture. Provide expert consultation and specialized analysis, design and dev services agency-wide.

• Improved new development by creating database development standards for all developers to follow

• Produced dozens of database models for new, existing, and legacy systems speeding dev efforts

• Shepherded major development efforts, working at times as, PM, BA, DB Developer, and Architect

• Developed new capabilities tying land ownership data with spatially enabled application to create self-service access to 100+ years’ worth of land transaction documents saving 100s of staff hours

• Delivered to developers numerous T-SQL stored procedures that were deemed too complex for the developers to be able to deliver, procedures are optimized to run in under 1 second; customers satisfied

Database Administrator, Washington Surveying and Rating Bureau – Seattle, WA 2006-2011

Database Administrator/Application Developer at the WSRB, maintained dozens of Microsoft SQL Server databases across multiple servers. Part of the IT department in a not-for-profit business, performed myriad tasks as the sole dba.

• Improved by developing SQL-backed web app inspection turnaround time from 4 weeks to 2 days

• Introduced regular backups and disaster recovery/failover reducing RPO to hours and RTO to minutes

• Eliminated 100s of outdated business rules, simplified dev efforts, saved 1000s of hours in app dev

• Produced 10s of ETL packages to ingest data, saved 100s of hours of manual data input and errors

• Delivered 100s of stored procedures, across dozens of databases, 10s of 1000s of lines of efficient SQL

• Generated dozens of ER diagrams for new and legacy databases saving 100s of hours in app dev

• Delivered documentation supporting SDLC, insight into IT architecture saved 100s of hours in app dev

Rapid Prototype App Dev, Air Force Combat Climatology Center – Asheville, NC 2005-2006

I served 6 years as a Communications/Computer Systems Programmer (3C072) in the U.S. Air Force, this 6-month period was at the end of my 6-year enlistment, I served as an application developer supporting numerous enterprise application development efforts.

Point Analyst, Air Force Combat Climatology Center – Asheville, NC 2004-2005

For a one-year period, was hand-picked to fill branch shortfall in direct support of warfighters and intelligence units, used my technical expertise to improve their Oracle database operations.

• Increased analysis production 38%, by leveraging expertise to simplify production reporting

• Delivered data retrieval, 120 geo-referenced graphics in minutes, vital to PACOM exercise Terminal Fury

• Produced 50k classified profiles; 99% delivered on-time, aided OIF/OEF intelligence gathering

• Improved product turn-around 19%

• Awarded unit NCO of the Quarter for October-December 2004 - awarded for strong technical skills

Rapid Prototype App Dev, Air Force Combat Climatology Center – Asheville, NC 2003-2004

Spent one year as an application developer, working with Oracle in the Java/Tomcat/Apache stack to develop various weather and climate applications to create visual representations of tabular historical weather data.

• Awarded AF-wide 2004 Zimmerman Award for best application of climatology AFCCC Web Team

• Decreased db production time from 15 hrs to 75 minutes; enabled rapid response to 200+ DoD units

• Delivered wind display program, equipped PACOM staff, whose area of responsibility includes over 1/2 earth's population, to be prepared for the potential use of nuclear, biological, or chemical weapons

• Delivered 15 software implementations, providing production tools to analysts 750+ analyses created

• Produced web app that calculated and graphically presented extremes and percentiles of 100+ years' worth of worldwide weather data to support the development of many multi-million dollar weapons systems

Applications Programmer, Air Combat Command Comm. Group – Langley AFB, VA 2003-2003

Spent about three months working as a web application developer, even in this short time, made significant contributions to development efforts.

• Delivered 1st ever flight and element intranet capability, in first month as a web app programmer

• Reduced design time by 6 months for HQ Air Combat Command/Inspector General's web site

Database Administrator, Air Combat Command Comm. Group – Langley AFB, VA 2000-2003

Served first three years in the Air Force as a Developer/DBA, as a design/build shop, we did everything from requirements gathering, to design, to implementation, testing, and delivery of world-class enterprise database development projects.

• Delivered automated testing application for Air Force-wide Network Control Centers, tracks training and certifications of 1200 network operators, ensuring the security of a vital command weapon system

• Produced cutting-edge system to web-enable the Air Combat Command awards board process that saved the Air Force over $70K in travel costs, and 180 personnel-days during its very first year in use

• Produced 1st-ever web-based Joint Dissimilar Air Combat Training ad board, system allowed combat units to easily arrange air combat training exercises between the 5 military services

• Increased operational awareness, established secure network server crucial data disseminated 200x faster, in support of operations Noble Eagle and Enduring Freedom

• Contributed to development of $14.5M payroll system trained 2 new personnel upgrades corrected payroll deficiencies for 950 DoD employees

• Saved 200 hours in program redesign efforts by identifying four key technical errors in the design of the ACC Technology Portfolio database

• Reduced design time by 20% on application to track Certificates to Operate on ACC network designed 68 database tables and developed 204 error-free stored procedures

EDUCATION

M.B.A., Business Administration, St. Martin's University

Bachelor of Science, Computer Science, St. Martin's University

Associates, Computer Science Technology, Community College of the Air Force

Associates, Drafting & Design Technology, NW Mississippi Community College

Contact this candidate