CTO - Data, Automation, and AI SystemsI design software that turns complex operations into elegant systems.
I am a CTO with a background in data engineering, automation, business intelligence, and applied analytics. I build ETL pipelines, AI-enabled workflows, and internal platforms that turn operational complexity into clear, high-leverage systems.
System Signal
FocusAutomation + Data Systems
SpecialtyETL, integrations, reliability
ApproachOperational software with premium UX
PythonNext.jsPostgreSQLSQL ServerAutomationETLData ReliabilityAPI IntegrationsSystems DesignInteractive UI
Selected Work
Real-world systems, presented with a product-grade visual layer.
Slab ETL Nexus
Production ETL that blends SQL Server, shop-floor Excel logs, and PostgreSQL into a trustworthy reporting layer for operations.
Defensive deduplication, slab-level enrichment, atomic exports, and freshness checks that reduce operational friction and data drift.
PythonPostgreSQLSQL ServerETLOperations
Moraware Sync Engine
A multiprocessing sync engine that collects fabrication, CAD, and install activity and restructures it into analytics-ready records.
Parallel processing, resilient logging, notes normalization, and vendor resolution to surface cleaner business signals from noisy source systems.
PythonPostgreSQLAPI SyncConcurrencyMonitoring
Ops Board Bridge
A data bridge that transforms operational status into structured task cards and visible execution layers for the team.
Less manual coordination, clearer priorities, and a software layer that connects field activity with visual workflow management.
PythonSQLiteAutomationDashboardsSystems Design
Applied Analytics
A separate analytics layer that adds forecasting, BI, visualization, and graph-driven case work.
Predictive Model for Residential Construction Activity in Texas
A forecasting-focused thesis project designed around construction permits, planning uncertainty, inventory timing, workforce decisions, and commercial readiness.
Frames Esteban as someone who can connect time-series analysis with operational planning and business value.
ForecastingTime SeriesPlanningBusiness Context
Cycle-Time and Rework Optimization for a Custom Manufacturing Operation
An applied analytics case centered on cycle-time prediction, rework risk, process mining, and KPI-driven operations improvement for a custom manufacturing business.
Adds predictive and operations-oriented depth without overlapping the current ETL and automation portfolio.
Operations AnalyticsML StrategyKPI DesignProcess Improvement
Executive BI Dashboard for Commissions, Market, Pareto, and Traders
A multi-page Power BI project covering commissions, market participation, Pareto logic, decomposition views, and trader-level reporting.
Shows that Esteban can translate data into managerial dashboards, not only backend systems.
Power BIExecutive ReportingMarket AnalysisDashboards
Build Philosophy
I care about systems that work under pressure and still feel refined.
01Signal first
I start by finding where data breaks down and which decision the software must make easier for the team.
02Reliability by design
Deduplication, traceability, fallbacks, and safe writes keep the automation resilient in real environments.
03Presentation matters
Internal engineering work still deserves interfaces that are clear, elegant, and satisfying to explore.
Capabilities
Strong backend foundations, expressive visuals, and operational focus.
Robust ETL pipelines
API and ERP integrations
Multi-source data synchronization
SQL analytics and data modeling
Operational automation
Business intelligence dashboards
Machine learning and predictive analytics
Interactive frontends for complex systems
Resources & Contributions
Useful public downloads, packaged cleanly and safe to share.
Free UtilityOutlook Attachment Extractor
A Windows-based OST attachment extraction utility with GUI and CLI workflows, designed to browse Outlook data files, filter messages, and export attachments in a structured way.
Sanitized public package with source code only.
No client data, extracted mail content, temporary mailboxes, or build artifacts included.
Useful as a practical download for teams that need OST attachment extraction workflows.
Public Source BundleLive Data Integration Lab
A curated package of sanitized integration scripts covering Moraware, RFMS, Microsoft Graph, Samsara, and Excel-based ingestion patterns.
Built from real operational automations, rewritten to remove secrets, internal IDs, private paths, and raw business data.
Useful for demonstrating ETL, API authentication, batch backfills, desktop automation, and schema-shaping patterns.
Safe to share as a public engineering sample without exposing the original `livedataproj` workspace.
Resume Snapshot
A concise professional summary, not just a project gallery.
Professional SummaryCTO - Data, Automation, and AI Systems
CTO, data engineer, and automation specialist with a multidisciplinary background spanning civil engineering, data science, business intelligence, and operational systems. Experienced in building ETL pipelines, analytics layers, AI-driven automations, dashboards, and backend workflows that improve decision-making, reduce manual work, and create reliable infrastructure for growing teams.
Currently operating at CTO level, leading technical direction across data, automation, and AI-driven systems.
Built production ETL pipelines connecting SQL Server, Excel-based shop data, PostgreSQL, APIs, and operational platforms.
Designed synchronization workflows for manufacturing, CAD, installation, finance, and vendor intelligence.
Experienced with Power BI, Python, SQL, machine learning, and automation-first system design.
Able to bridge technical execution, strategic thinking, and multidisciplinary business contexts.
Latest PositionChief Technology Officer (CTO)
Leading technical strategy across automation, AI, business intelligence, and data systems while shaping solutions that improve operational visibility, efficiency, and decision-making.
2024 - PresentData Engineer | AI-Driven Automation & Business Intelligence Specialist
Designed and implemented ETL pipelines, API integrations, reporting systems, and AI-enabled automations for a U.S.-based client, connecting platforms such as Moraware, RFMS, Slabsmith, Samsara, and production machine logs.
2022 - 2023Data Scientist, Data Analyst, and Financial Modeling Roles
Worked across hydroelectric, photovoltaic, construction, and water system projects, applying data analysis, forecasting, financial modeling, and feasibility studies to support strategic decisions.
EducationCivil Engineer + Master's in Data Science and Business Intelligence
Blending engineering discipline with analytics, machine learning, business intelligence, and applied data strategy to solve real-world operational problems.