Lopez Data Works
Data systems built from real operational problems.
I build production-style data pipelines, automation workflows, dashboards, APIs, and analytics tools that make messy business data usable, reliable, and decision-ready.
Operational architecture
From source to decision
Controlled data pipeline
Five connected stages turn fragmented operational inputs into governed, decision-ready outputs.
Ingest
Standardize
Model
Control
Deliver
Control plane
Reliability and traceability across every stage.
Decision layer
The system ends with outputs people can act on.
Operational result
Repeatable execution, visible controls, and outputs designed for the next decision.
Flagship systems
Selected builds that show the full pattern: messy inputs, automation, validation, reporting, and a usable business outcome.
Cloud ETL Platform
Cloud-ready ETL and analytics platform that transforms fragmented OrderTime operational data into governed, analytics-ready datasets for inventory, procurement, and reporting decisions.
Power BI Inventory Dashboard
Power BI semantic model and inventory dashboard suite that turns stock health, replenishment, procurement, velocity, and deadstock analytics into one connected decision layer.
Procurement Intelligence
Procurement intelligence engine that turns fragmented inventory, sales, vendor, pricing, and receipt signals into action-ready replenishment recommendations.
CCC Stateful Insights
Stateful reporting pipeline that detects new and changed CCC quote runs, tracks processing history in JSON state, and refreshes downstream analytics only when operationally necessary.
AI Analytics Copilot
AI-guided analytics workspace that helps users ask operational questions, routes requests through controlled tools, and returns structured answers through a SQL-safe decision layer.
Ops Analytics API
Operational analytics layer that turns KPIs, trends, alerts, and export-ready outputs into a reusable FastAPI backend and an executive-friendly dashboard experience.
PartsTrader Monthly Pipeline
Monthly reporting orchestrator that uses a stage registry, dependency graph, manifests, dry-run planning, and JSON state to run only the work that needs to be refreshed.
Pegasus Scanner
Inventory scanning and cycle-count application that turns scanner input, BIN-based counts, receiver checks, and export-ready audit records into a controlled warehouse workflow.
How I build systems
Every build follows the same discipline: understand the operational problem, engineer the workflow, validate the output, and deliver something people can actually use.
Understand the work
Diagnose
Start with the business problem, the workflow friction, the data sources, and the decision that needs to improve.
Build the system
Engineer
Design the pipeline, SQL model, workbook engine, dashboard, API, scanner flow, or automation layer around the real process.
Make it reliable
Validate
Add checks, audit trails, state tracking, exception handling, and quality logic so the output can be trusted.
Make it usable
Deliver
Turn the system into decision-ready outputs: dashboards, files, alerts, reports, apps, or stakeholder delivery workflows.
Capability map
A practical skill map across Python, SQL, Power BI, APIs, automation, analytics engineering, and the operational domains where those tools create value.
Analytics & BI
Deadstock analytics, markdown logic, and trend comparison workbooks
Deadstock Classification Markdown Recommendation Logic Two-Run Trend Workbooks
Automation
Customer sales analytics and Excel reporting automation
Weighted profitability modeling Excel workbook generation Period-over-period analysis
Analytics & BI
Power BI semantic modeling and operational dashboard design
Multi-page BI design DAX measure engineering Semantic model structure
Analytics & BI
Market analytics, forecasting models, and decision-support dashboards
Financial Data Extraction Forecasting & Signals Interactive Analytics UI
Automation
Webhook API design and event logging
Webhook Receivers Payload Validation Event Persistence
Analytics & BI
Weekly file generation, audit workbooks, and partner-ready exports
Inventory Export Automation Audit-Ready Workbooks Stakeholder Delivery