Data Architect Engineer

Stephen Lauzon

*******.******@**********.*** 253-***-**** LinkedIn.com/in/stephenlauzon/

PROFESSIONAL SUMMARY

Data Architect – Senior Database Engineer –Database Developer – DBA – App Developer

T-SQL – MSSQL Server 2000-2022 – Data Modeling – SDLC – SSIS – ETL – Azure SQL Database

EMPLOYMENT HISTORY

Tiber Creek Consulting, Inc., Data Architect

Army MODS Contract, Fairfax, VA, remote from WA 2023-2025

Serving as Data Architect for MODS, (Medical Operational Data System,) the authoritative database for comprehensive medical readiness data, including immunizations, physical profiles, dental status, and other medical information to ensure soldiers are fit for duty; worked to migrate MODS from legacy mainframe system to MSSQL Server in Azure, using Stored Procedures and Server Integration Services (SSIS) packages.

• Translated 10s of 1000s of lines of legacy COBOL code to modern, efficient T-SQL stored procedures

• Led efforts to consolidate legacy servers from 11 to just 3, to save processing, license, and maintenance costs

• Created SSIS packages to replicate legacy processes to extract, transform, and load (ETL) medical data

GFIM-OE Contract, (subcontracted to BigBear.ai) Wash., D.C., remote from WA 2021-2023

Serving as the Data Architect of the Global Force Information Management (GFIM) Objective Environment (OE), laid the data foundations for an enterprise-level information technology capability that will fundamentally transform how the Army coordinates and synchronizes global force management (GFM) across all levels of war to man, equip, train, sustain, deploy, and redeploy forces in support of national objectives.

• Met online with subject matter experts (SME) from across the Army to identify, discuss, and refine requirements; spent hundreds of hours researching Army publications, from novice to SME in under 6 months.

• Created 100s of OLTP tables to model and implement GFIM-OE requirements GFIM will subsume 12+ systems

• Created Organizational Force Structure Construct (OFSC) subject area that abstracts the Army’s hierarchies allowing any two nodes, (soldiers, organizations, or equipment,) in the hierarchy to be related in one of several ways and each node of the hierarchy to participate in multiple relationships with other nodes—all OLTP & fast

• Implemented Global Unique Identifiers; Implemented Department of Defense Instruction (DoDI) 8320.03; requires all DoD GFM DI EFS data elements to be tied to a unique Global Force Management ID (GFMID), a globally unique, two-part identifier: the 1st part being a managed, granted seed and the 2nd being a locally-generated uniquifer; GFMIDs uniquely identifying DoD orgs also implements OUID mandate of DoDI 8260.03

• Gave frequent online crash courses to new incoming developers, bringing them up to speed on the fundamental requirements of GFIM-OE and the data structures they were required to access

Database Developer, Tacoma Public Schools – Tacoma, WA 2019-2021

Plan, design, develop, build, test, implement, and maintain databases written in Microsoft’s BI stack, especially Microsoft SQL Server, to meet the needs of District staff, students, and the community. Participate in the architecture, security, and tuning of enterprise data warehouse. Meet department goals and District objectives.

• Designed and built database schema for Parent Application; facilitates parents’ secure access to student data

• Designed, built, and populated data audit operational data store, wrote 100s of queries to raise data errors and tie them to data entry personnel, identify training gaps, and facilitate data quality issue correction

• Implemented Master Data Management using Microsoft Master Data Services, created models, entities, and attributes, stored procedures for model population, business rules for data validation, and subscription views

Agency Data Architect and Data Services Lead, WDFW – Olympia, WA 2011-2019

Agency Data Architect and Data Services Lead at the Washington Department of Fish & Wildlife. Highest authority in the agency in the IT specialty area of data architecture. Provide expert consultation and analysis, design, and development services agency-wide. Promoted to Data Services Lead, in recognition of leadership.

• Shepherded major development efforts, working at times as, PM, BA, DB Developer, and Data 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 development staff to be able to deliver, procedures are optimized to run in under 1 second; customers satisfied

Adjunct Faculty, Lecturer I, Saint Martin’s University – Lacey, WA 2017-2018

Teacher of baccalaureate students in the Computer Science program at St. Martin’s University

• Taught CSC 423 – Implementing a Data Warehouse & CSC 310 – Database Design

Database Administrator/App Dev, 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 reduced RPO days to hours & RTO days 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

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

Served 6 years as a Communications/Computer Systems Programmer (3C072), Database Specialist/App Dev in the U.S. Air Force, this 6-month period was at the end of this 6-year enlistment; 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 technical expertise in Oracle’s PL/SQL to improve database operations. Cleared TS/SCI, SSBI.

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

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

• 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

AppDev using Oracle in the Java/Tomcat/Apache stack to develop various weather and climate applications.

• 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

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

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

Developer DBA/AppDev, as a design/build shop, 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

• Cut design time 20% on app; tracks Certificates to Operate on ACC network—68 tables & 204 error-free SPs

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

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