DREW
ERNST.

Data Analyst  //  Full-Stack Engineer

I engineer full-stack applications and data pipelines that solve real business problems—turning raw requirements into reliable, production-ready systems.

01 // Strength

Data Analysis

Cleaning, structuring, and analyzing complex datasets to extract actionable business insights.

02 // Strength

Backend Engineering

Building reliable APIs and robust database architectures using Python, FastAPI, and PostgreSQL.

03 // Strength

Frontend Development

Creating responsive, accessible, and high-performance user interfaces with React and Next.js.

Data Integrity
Full-Stack Systems
Behavioral Tech
Systems Engineer
PostgreSQL
React 19
Python / Pandas
DTE Solutions LLC
Data Integrity
Full-Stack Systems
Behavioral Tech
Systems Engineer
PostgreSQL
React 19
Python / Pandas
DTE Solutions LLC
Data Integrity
Full-Stack Systems
Behavioral Tech
Systems Engineer
PostgreSQL
React 19
Python / Pandas
DTE Solutions LLC
Data Integrity
Full-Stack Systems
Behavioral Tech
Systems Engineer
PostgreSQL
React 19
Python / Pandas
DTE Solutions LLC
Principal Architecture //

Flagship Builds.

ExpressTypeScriptPWA

Pulse-AI Behavioral Finance

A behavioral finance SaaS equipped with an AI coach (Nova), a real-time stress index, Plaid streaming, and behavioral pattern detection for deep financial insights.

System Deep Dive
Next.jsAES-256HIPAA

PCSP Assistant Pro

A specialized compliance documentation tool for state case managers. It securely encrypts user data locally in the browser using AES-GCM 256-bit encryption to ensure HIPAA compliance before saving.

System Deep Dive
PostgreSQLAnalyticsWindow Fns

Advanced Analytics Case Study

A comprehensive data analysis project using advanced PostgreSQL queries. I utilized CTEs, window functions, and joins to analyze e-commerce datasets and extract key business metrics like customer retention and sales trends.

System Deep Dive
React 19Claude AISEO

ResaleIQ

AI-powered resale assistant that generates optimized listings and pricing intelligence for luxury goods.

System Deep Dive
The Systems Portfolio //

Systems Archive.

Ecosystem
2026

DTE Solutions HubDTE Solutions Hub

The central entry point for my suite of applications, demonstrating cross-app navigation, consistent UI design, and scalable deployment practices on Vercel and GitHub Pages.

Next.jsReact 19Ecosystem
MW Properties
Real Estate Portal
2026

MW PropertiesMW Properties

A marketing and lead-generation website built for a real estate investment group. Developed with React and Vite for fast load times and a custom contact form integration.

React 19Vite
Deterministic AI
2026

SetLogicSetLogic

A fitness tracking application that logs workout metrics and provides data-driven coaching feedback using a React frontend.

React 19Claude AITelemetry
Interactive Audio
2026

Keys BeatsKeys Beats

An interactive promotional website for an audio producer, featuring real-time visual effects built with the HTML5 Canvas API and Web Audio API.

Web Audio APICanvas 2DArchitecture
Enterprise Fintech
2026

NestLegacy ShellNestLegacy Shell

A landing page concept for an enterprise financial technology product, highlighting modern UI design principles and responsive layouts.

React 19Architecture
Performance Analytics
2026

FluffFluff

A golf application designed to map and analyze GPS and biometric data for personal performance tracking.

IoT SyncGeospatial
Commercial Aesthetics
2025

Pro DipPro Dip

A business website for an automotive detailing company. Built with vanilla JavaScript and CSS Grid to showcase their services without heavy framework dependencies.

PostgreSQLAnalyticsWindow FnsVanilla JS
Commercial UI
2026

Tony's LandscapingTony's Landscaping

A service quote generator and informational website for a commercial landscaping business.

GSAPArchitecture
Interactive Media
2026

SiKnight HubSiKnight Hub

A portal for a web-based game, featuring a real-time leaderboard and user progress tracking.

React 19Game Design

My// Identity

My work sits at the intersection of backend architecture and user experience—where structured data, predictive analytics, and real-world usability come together.

I specialize in creating end-to-end systems that transform raw data into meaningful insights, whether in financial behavior, clinical workflows, or business operations.

Philosophy

  • Deterministic Architecture: Systems should be reliable, predictable, and built on strong data integrity.
  • Signal Clarity: Data should be structured and presented in a way that makes decisions obvious - not overwhelming.
  • Analytical Precision: Every system should produce measurable, meaningful outcomes using behavioral and operational data.

Connect & Collaborate.

Available for strategic engineering partnerships and high-fidelity data systems development.

Download DossierDownload Dossier

Quincy, IL — Available Remote // © 2026 DTE Solutions LLC