Emmett J. Pratt
Senior Data Warehouse Operations Engineer
At GovCIO, on the Enterprise Data Warehouse for the Department of Justice and the DEA. Before that, a decade of cyber fraud and insider threat analytics for the IRS.
The record
Every figure below is a line off twenty years of resumes — the before, the after, and the thing that closed the gap.
100 hrs → 10 hrs
Year-end analysis package
FDIC via Pragmatics
Automated the whole package with SAS and Microsoft Excel DDE.
80 hrs → 8 hrs
Executive backlog order tracking report
MCI
Rebuilt the reporting path on MS SQL Server.
40 hrs → 4 hrs
Monthly journal-entry close, domestic internet revenue
MCI
DTS packages, stored procedures and Transact-SQL.
8 hrs → 2 hrs
Loss Share test reconciliation review
FDIC via Pragmatics
Automated the reconciliation process in SAS.
8 hrs → 2 hrs
Promotional tracking weekly reporting
America Online
Sybase Transact-SQL, UNIX shell, SAS data step, macro and PROC SQL.
4 hrs → 30 min
Monthly delinquency report delivery
Freddie Mac
UNIX shell scripts emailing program output and logs from inside SAS.
2,000+ hrs
Saved annually on CCMS notes data entry
Quality Oncology
Transact-SQL, batch files, Data Junction and SAGENT automation.
$20M
Unbilled internet revenue identified
MCI
Audit of the monthly billing process across the Arbor billing system.
$4M
Saved for IBM by surfacing billing errors
MCI
An audit database built in MS Access.
50% / 35%
Processing time cut in half, storage down 35%
CMS via CSRA
Materialized views and parallel processing on Oracle and Teradata.
Capabilities
Over twenty years in the IT field, with expertise in database administration and advanced ETL programming. Formulating the strategy, determining the tools, and leading the team that delivers it inside the time and the budget.
Hands-on operational support for an enterprise data warehouse — monitoring 175+ production ETL jobs, keeping SQL Server Agent schedules, alerts and system health green, and carrying the on-call pager for incident response.
End-to-end ingestion pipelines built from the parser up: extraction, transform and load processes, parsing algorithms that turn raw log files into loadable data, and the scheduling around them. Twenty years of it, across federal and Fortune 500 programs.
Backups and restores, replication monitoring, disaster recovery, performance tuning, logins, permissions and roles — plus the schema work underneath: tables, indexes, sequences, triggers and stored procedures with the right permissions attached.
Ten years on the IRS User Behavior Insider Threat program, working alongside fraud analysts to detect fraudulent electronic transactions — building the end-to-end transaction visibility, the log ingestion behind it, and the monthly reporting that assessed data quality.
Moving live federal data off on-prem and onto cloud infrastructure — MariaDB to Postgres, and IRS on-premises network data into the AWS Treasury Cloud.
Taking a process that costs a hundred hours and making it cost ten. Automated reconciliation, self-delivering reports, dynamic scripts that run on any platform, and parameter-driven jobs that stop hard-coded paths from becoming next year's maintenance bill.
Experience
Federal civilian, law enforcement, housing finance, healthcare and telecom — the data has changed, the discipline has not.
GovCIO
Noblis
CSRA
Pragmatics
General Dynamics Information Technology
CGI
Freddie Mac
Aug 2004 — Jun 2005
Database Administrator · Quality Oncology · McLean, VA
Ran SQL Server maintenance, security and the data mart behind fifty cancer case-management web reports.
Apr 2003 — Aug 2004
System Administrator · America Online · Sterling, VA
Sybase administration and the data mart behind one hundred narrowband promotion reports for Marketing Analysis.
May 2000 — Apr 2003
Database Administrator · MCI · Ashburn, VA
Owned the Arbor billing file covering $125M in monthly internet revenue; found $20M unbilled.
Apr 1999 — May 2000
Database Developer · MCI · Ashburn, VA
Built custom invoicing and reporting systems for American Express, CSX Railroad and IBM Audio Conferencing.
Aug 1997 — Apr 1999
Senior Billing Analyst · MCI · Arlington, VA
Revenue reporting and contract audit for a multi-million-dollar IBM account; $4M recovered.
Mar 1995 — Aug 1997
Financial Analyst · Vredenburg · Reston, VA
Built and maintained a logistical database in MS Access for a U.S. Navy program office.
Clearance & credentials
Secret
Issued January 2026, with Department of Justice (DOJ) / Drug Enforcement Administration (DEA) Suitability.
Public Trust — Medium Level
Issued September 2023.
Public Trust — High Level
Issued March 2015. Previously held.
Top Secret / SCI — Full Scope
Successfully adjudicated September 2013.
Bachelor of Science — Economics
Virginia Commonwealth University · Richmond, VA · 1994
Great Learning Education
Certificate Program in Advanced Python: From Analytics to AI (Oct 2025) · Python for Data Analytics · Python for Data Science · Python for Generative AI
Lander Analytics · Reston, VA
Introduction to R · Computing in R · Machine Learning in R
Centers for Medicare & Medicaid Services · Baltimore, MD
SAS Enterprise Business Intelligence (SAS/EBI) · IDR Teradata training
SAS Institute · Rockville, MD
SAS Web Tools: Static and Dynamic Solutions Using SAS/IntrNet Software
MicroStrategy · McLean, VA
Desktop: Reporting Essentials
Learning Tree International · Reston, VA
Java Programming: A Comprehensive Hands-On Introduction
New Horizons Computer Learning Center · McLean, VA
System Administration for Microsoft SQL Server 7.0 (Course 832) · Implementing a Database in MS SQL Server 7.0 (Course 833)
Toolset
Send the requirement over and you will get a straight answer on fit, usually the same day.