Esteban Montesinos
15+ Projects

Portfolio

Selected Projects

A showcase of impactful projects demonstrating expertise in automation, AI integration, system architecture, and full-stack development. Each project reflects a strategic approach to solving complex business challenges with measurable outcomes.

Featured Work

Solairus Aviation

Month-End Reporting Transformation

Took ownership of a failing, undocumented enterprise reporting process and transformed it into a robust, scalable automation. Reconstructed missing logic, migrated legacy components to modern Chrome-based automation, and optimized Excel automation stability via framework tuning.

AutomationExcel AutomationProcess Re-engineeringChrome Automation

Key Outcomes

  • Reduced runtime from ~2 weeks to ~6 hours (~98% improvement)
  • Delivered urgent production run within 12 hours during refactor
  • Created fully documented, supportable system

Solairus Aviation

Certify Feed Report Pipeline

Redesigned a critical daily financial reporting pipeline to dramatically improve speed and reliability. Replaced legacy Excel dependencies with API/database-driven architecture, built failover mechanisms, and implemented automated FTP uploads with stakeholder notifications.

AutomationREST APIsSQLFTP AutomationData Pipelines

Key Outcomes

  • Reduced runtime from 10-15 minutes to ~40-55 seconds
  • Eliminated manual bottlenecks and increased system resilience
  • Delivered scalable, modernized reporting pipeline

Solairus Aviation

Flight Log Verification System

Engineered a mission-critical automation for validating aviation flight logs, ensuring compliance, accuracy, and synchronization across operational systems. Diagnosed and resolved a critical stack overflow issue by re-architecting recursive logic into optimized structures.

AutomationAvianis IntegrationAPI-driven ArchitectureCompliance Systems

Key Outcomes

  • Eliminated execution failures and recursion risks
  • Increased throughput for compliance-critical workflow
  • Ensured consistent and auditable verification processes

Solairus Aviation

HR Identity Integration Pipeline

Engineered a scalable integration pipeline to synchronize HRIS and identity systems (Paycom to Okta). Designed handling for 6 distinct exception classes and replaced inefficient logic with indexed filtering algorithms to solve performance bottlenecks.

AutomationOkta APIPaycom IntegrationData Transformation

Key Outcomes

  • Reduced runtime from 6-7 minutes to ~30-45 seconds
  • Improved compliance and downstream data quality
  • Created reusable integration architecture for HR systems

Solairus Aviation

MFA Testing Automation

Designed an automated framework to test and monitor MFA compliance organization-wide. Built a randomized selection algorithm ensuring equitable departmental coverage, collected and analyzed results to identify risk patterns, and architected the system to run securely on a dedicated VM over VPN.

AutomationSecurity TestingRisk AnalyticsVPN InfrastructureRandomization Algorithms

Key Outcomes

  • Established scalable, unbiased MFA testing framework
  • Improved organizational security posture and training insights
  • Successfully validated through internal testing - ready for deployment

Technical Approach

Data Architecture

API-driven data pipelines with robust error handling

Process Automation

Intelligent workflows reducing manual intervention

Security & Compliance

Secure infrastructure with audit-ready processes

Business Impact

Solutions delivering measurable ROI and cost savings

Other Projects

Solairus Aviation

Benefits Billing & Reconciliation Engine

Built a precision-focused automation to eliminate reconciliation errors and improve financial oversight. Compared provider invoices with Paycom reports, flagged discrepancies, and automated exception routing for targeted resolution.

AutomationPaycomFinancial Reconciliation

Solairus Aviation

Fatigue Meter Safety Analytics

Developed a data-driven automation enhancing operational safety by proactively identifying fatigue risks across flight crews. Integrated with Pulsar FatigueMeter API for real-time risk analysis and generated actionable reports for leadership.

AutomationPulsar APIPredictive Analytics

Solairus Aviation

Reflective Process Cost Optimization

Led a critical system migration that directly reduced operational costs and improved data integrity. Built peer-to-peer FTP architecture, resolved UUID mismatches across systems, and automated user lifecycle management.

AutomationFTP ArchitectureUUID Resolution

Solairus Aviation

Taleo to ICIMS Migration

Executed a high-pressure, large-scale data migration (~100K records) under extreme time constraints. Processed thousands of compressed files, reconstructed datasets, cross-referenced attachments, and implemented tracking for data integrity.

AutomationData MigrationFile Processing

Solairus Aviation

Conformity Search Document Engine

Built a scalable automation to perform high-volume, structured searches across aviation documentation. Automated Adobe Acrobat workflows, extracted results into structured CSV outputs, and enabled parallel processing for multi-file handling.

AutomationAdobe AcrobatDocument Intelligence

Spark Byte Solutions

Business Process Automation Suite

Built scalable, production-grade automation and AI-powered solutions for enterprise clients. Focused on workflow optimization across finance and operations, delivering measurable ROI through strategic technical implementation.

RPAAI IntegrationPython

Deloitte

RPA Sales Demonstration Platform

Developed a compelling automation demonstration that showcased RPA capabilities to potential clients. The demo contributed to nationwide adoption and helped secure significant client engagements.

AutomationUiPathProcess Automation

Western Colorado University

Robotics System Architecture

Led a team of 5 engineers in designing and delivering a complete robotics system. Oversaw architecture decisions, integration testing, and project management from concept to deployment.

C++Embedded SystemsRobotics

Water Check EC

IoT Data Collection Platform

Built an end-to-end IoT system for real-time environmental data collection. The full-stack application integrated hardware sensors with a user-friendly web interface for data visualization and analysis.

JavaScriptIoTFull-Stack

Personal Project

Automated Virtual Assistant: Codec

Developed a voice-activated virtual assistant in Python leveraging natural language processing (NLP), speech recognition, and text-to-speech technologies. Integrated multiple APIs to automate tasks such as email handling, web navigation, real-time weather retrieval, YouTube content streaming, and Wikipedia data extraction.

PythonNLPSpeech Recognition

Enterprise Solution

Tax Automation Robot

Engineered an RPA-style automation solution to dynamically retrieve and process tax documents from enterprise systems, including ERP platforms such as SAP. Implemented multi-format data handling and workflow automation to reduce manual intervention and improve accuracy.

RPASAP IntegrationData Processing

Aviation Tools

Flight Helper & Crosswind Calculator

Built a full-stack web application using HTML, Bootstrap, and Python Flask to support flight log management and aviation-specific calculations. Developed a crosswind and headwind component calculator to improve flight planning and situational awareness.

PythonFlaskHTML

Autonomous Systems

Computer Vision Lane Detection

Designed and implemented a real-time lane detection system using Python and OpenCV, applying advanced computer vision techniques. Developed a full perception pipeline including image preprocessing, Canny edge detection, ROI segmentation, and Hough Transform for lane identification.

PythonOpenCVComputer Vision

Interested in seeing more?

These are just highlights. Get in touch to discuss specific solutions for your business challenges.

Discuss a Project