Josh Johnson

Independent at AURABLOX

Freelance Software Developer & Business Advisor · St. Louis, MO · Sep 2026 – Present

Build custom software for clients — full-stack development across TypeScript, React, Node.js, Python, and cloud data platforms.
Advise businesses on software strategy and practical AI adoption — helping teams move from exploration to production with LLMs, agents, and automation.
Push AI advocacy and learning in public — sharing hands-on patterns for building with AI tooling through real projects and writing.

Beghou Consulting

Assc. Manager, Consulting · Evanston, IL · 2021 – Aug 2026

Serve as a client-facing consultant and data architect for emerging and established pharma clients, translating commercial needs into ETL pipelines that ingest, consolidate, and modernize data on Databricks and Snowflake.
Delivered ~12 client engagements spanning pre-revenue to $100B market-cap organizations — primarily data warehouse builds and maintenance, reporting support, MDM, migration efforts, and QC builds; on several, served as a forward-deployed engineer standing up pipelines that transitioned into a consultant-led onshore/offshore support model.
Launch readiness is my specialty: across four product launches, stood up fully scheduled reporting environments delivering daily data and 96% job run success that field and commercial teams relied on from day one.
Post-launch, advise client stakeholders on reporting services, documentation, and omnichannel data aggregation — demand, HCP CRM engagement, and marketing — into a single source commercial teams act on.

Medline Industries

Manager, IT Applications · Northfield, IL · 2019 – 2021

Managed 20-person engineering and PMO team supporting a $7B+ distribution business, achieving 98% project delivery on time and budget.
Delivered 25+ lightweight enterprise applications using OutSystems, SQL, and .NET, generating $2M+ in aggregate annual cost savings.

Medline Industries

Senior Buyer / Supervisor, Inventory · Northfield, IL · 2018 – 2019

Automated procurement operations for a 15-person purchasing team managing $75M+ weekly spend through SQL reporting and VBA macros, enabling the same headcount to absorb significantly greater volume.
Drove optimization of supply network planning, material requirements planning, and safety stock across high-velocity SKUs using SAP and SQL Server stored procedures, improving inventory positioning and reducing excess stock exposure.

Medline Industries

Supply Chain Analyst → Senior Analyst, Inventory · Northfield, IL · 2015 – 2018

Accumulated $50M+ in annual cost avoidance through root-cause analytics and SAP-driven supply chain optimization across a $7B+ distribution operation.
Established master data governance framework for SAP MRP/SNP systems, improving forecast accuracy by 25% and reducing stockouts by 40%.
Built advanced reporting dashboards that improved demand-supply alignment and reduced inventory carrying costs by 15% through optimized safety stock rules.

01

4 Pharma Product Launches

Architected the ETL pipelines and reporting environments behind four pharmaceutical product launches — purpose-built on Databricks and Snowflake and ready for commercial teams from day one.

02

Launch-Ready Reporting from Day One

Built fully scheduled commercial data reporting environments on Databricks and Snowflake — with daily deliveries, 96% job run success, and high-SLA infrastructure that field and commercial teams relied on from the moment a drug launched.

03

$50M+ Supply Chain Cost Avoidance

Accumulated $50M+ in annual cost avoidance at Medline Industries through root-cause analytics, SAP MRP/SNP governance, and demand-supply optimization across a $7B+ distribution operation.

04

$2M+ in Aggregate IT Savings

Led a 20-person engineering and PMO team at Medline Industries delivering 25+ lightweight enterprise applications on OutSystems (with SQL and .NET) — generating $2M+ in aggregate annual savings through automation and process elimination.

05

Procurement Automation at Scale

Automated supply network planning, MRP, and safety stock operations for a 15-person purchasing team managing $75M+ weekly spend — enabling the same headcount to absorb significantly greater volume through SQL and VBA tooling.

start with the workflow listen to the operator name the constraint map the handoffs find the failure points make the work visible

ship the smallest useful system design for recovery verify in production measure what matters document the why stay through adoption

automate the repeatable keep judgment human build for the next operator reduce the maintenance burden leave a clear trail improve from real use

AI Orchestration & Integration: LLMs (Claude, ChatGPT, Gemini) · Agents (Codex, Claude Code, OpenCode, Pi, Hermes) · MCP
Data Engineering & Cloud: Databricks · Snowflake · PySpark · Python · SQL · Delta Lake · GCP · dbt
Commercial & Pharma Analytics: HCP Targeting · Field Force Analytics · Omnichannel Strategy · Reporting · Master Data Management
Development & DevOps: TypeScript · React.js · Node.js · Git · GitHub · Docker · VS Code · Databricks · Jira