Data Architect

Stephen Lauzon

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

PROFESSIONAL SUMMARY

Data Architect Current Secret Clearance Database Architect Database Dev DBA AppDev T-SQL MSSQL Server 2000-2022 & Azure ETL / SSIS AZ-900, AZURE207x, Databricks Certified EMPLOYMENT HISTORY

Data Architect, Tiber Creek Consulting, Inc.

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 cloud-native 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.

• Collaborated with Army subject-matter experts (SMEs) to identify, discuss, and refine requirements; invested 100s of hours of research into Army publications, accelerated expertise 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

• Coached incoming developers, bringing them up to speed on the fundamental requirements of GFIM-OE Database Developer, Tacoma Public Schools; Tacoma, WA 2019-2021 Serving as Database Developer planned, designed, developed, built, tested, implemented, and maintained databases written in Microsoft’s BI stack, focused on Microsoft SQL Server, to meet the needs of staff, students, and the community. Led the architecture, security, and tuning of EDW to meet all dept & District objectives.

• Spearheaded database schema for new 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

• Pioneered 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 BI Data Architect, CHI Franciscan Medical Group; Tacoma, WA July 2019-Dec 2019 Designed/developed/tested/maintained data warehouse of core financial data to facilitate decision support.

• Lead the development of SSIS Packages for integrating, aggregating, consolidating, and distributing data

• Modernized manual process that occupied three FTEs for days, with an automated one that runs in seconds Agency Data Architect and Data Services Lead, WDFW; Olympia, WA 2011-2019 Serving as the Agency Data Architect at the Washington Department of Fish & Wildlife, as the highest authority in the agency in the IT specialty area of data architecture. Provided expert consultation and analysis, design, and development services agency-wide. Promoted to Data Services Lead, in recognition of strong leadership.

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

• Created new capabilities tying land ownership data & document management with spatially enabled application to create self-service access to 100+ years’ of land transaction documents saved 100s of staff hours

• Gained buy-in of change-averse staff, tactful approach showed reluctant colleagues how changes would transform their business; once-reluctant staff turned evangelist; staff sold our state’s system to other states

• 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 Served as a 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 & Rating Bureau; Seattle, WA 2006-2011 Serving as DBA/AppDev at WSRB, an independent, a not-for-profit, public service organization that helps insurers and their customers manage risk by providing objective data on multiple risk factors; maintained dozens of Microsoft SQL Server databases across multiple servers. 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 dozens of ETL packages to ingest data, saved 100s of hours of manual data input and shaved errors

• Delivered 100s of stored procedures, across dozens of databases, 10s of 1000s of lines of efficient SQL Communications/Computer Systems Programmer Craftsman, Database Specialist/App Dev 2000-2006 U.S. Air Force, primarily at Langley AFB, VA & Air Force Combat Climatology Center, Asheville, NC Served as Developer DBA/AppDev in a design/build shop; everything from requirements gathering, to design, data modeling, implementation, testing, and delivery of world-class enterprise database development projects.

• Headed database dev of Learning Management System for USAF-wide Network Control Centers, spawned tests, tracked training & certs of 1200 network operators, ensured security of 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

• Piloted 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 Served as Rapid Prototype App Dev, leveraging Oracle GCCS training, developed database products written in PL/SQL on the Java/Tomcat/Apache stack to develop various statistical and analytical weather & climate apps.

• Awarded Air Force-wide 2004 Zimmerman Award for best application of climatology; AFCCC Web Team

• Optimized data production time; from 15 hours to 75 minutes; enabled rapid response to 200+ DoD units

• Modernized web app that calculated and graphically presented extremes & percentiles of 100+ years' worth of worldwide weather data to support the development of numerous multi-million-dollar weapons systems For a one-year period, was hand-picked to serve as Point Analyst to fill branch shortfall; direct support of war fighters and intelligence units, as a Staff Sergeant in a Master Sergeant position, I leveraged technical expertise in Oracle’s PL/SQL to transform database operations, greatly improving response times. 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 Non-Commissioned Officer of the Quarter for Oct-Dec 2004 - for “strong technical skills” 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