Esteban Loetz

Longmont, CO

(303) 548-0325

estestyle@gmail.com

estestyle.com

linkedin.com/in/estestyle

github.com/EsteBot

B.A. Molecular, Cellular, & Developmental Biology (2012)

Languages & Analysis: Python, SQL, Pandas, Matplotlib, Jupyter

App Development & BI: Streamlit, Tableau, Interactive Dashboards, Excel/Sheets

AI & Productivity: Gemini / LLM Integration, LangChain, AI-Assisted Development, Prompt Engineering

Housekeeping Live Dashboard (Python, Streamlit, Pandas, Google Sheets): Built real-time multi-device tracking app; digitized PMS data via dynamic ETL pipeline to sync room turnover across departments.
Hotel Intelligence Assistant & Analytics App (Python, Streamlit, LangChain, Gemini 2.0, SQLite, Altair): Engineered an AI-driven SQL analytics dashboard using Gemini 2.0 LLMs to query relational PMS database metrics via natural language, featuring dynamic trend visualization, automated data aggregation, and real-time KPI tracking.
PMS ETL Pipeline & Revenue Analytics Platform (Python, Pandas, Streamlit, Plotly, OpenPyXL): Designed Python ETL scripts and custom Streamlit web applications to process raw Visual Matrix PMS files, automating time-series revenue tracking, automated guest management triggers, dynamic KPI dashboards, and Excel export workflows.

Optogenetic & Chemogenetic Implementation: Pioneered chemogenetic techniques and launched optogenetic protocols at CU Denver, expanding research capabilities for advanced neural circuit analysis.
Hardware Control & Automation: Taught myself MedState code to program Med Associate operant behavior hardware, automating drug schedule delivery and managing high-volume data collection.
Scientific Data Pipeline & App Development: Applied Python data manipulation libraries (Pandas, NumPy, Matplotlib) to replace legacy data processing methods, constructing standalone GUI and mobile applications that eliminated data entry errors and enabled rapid statistical analysis.

Genotyping & Molecular Analysis: Determined genotypes of multiple mouse strains using PCR, gel electrophoresis, and molecular imaging to ensure genetic profiling integrity.
Database Management & Auditing: Managed and streamlined a multi-lab animal database for a pathogen-specific facility, conducting ongoing census audits and cross-referencing inventories to resolve discrepancies.
Precision Instrumentation: Operated micro-sampling systems and executed quantification protocols to maintain high-quality experimental data collection.

Project Coordination: Collaborated with multiple Principal Investigators to manage overlapping projects, aligning diverse teams with experimental objectives and varied timelines.
Operational Oversight: Coordinated inventory management and ensured regulatory compliance across experimental endeavors, facilitating smooth and efficient project execution.

Research Presentations: Delivered clear and engaging oral presentations of research findings to academic peers, colleagues, and public audiences, including at major neuroscience conventions like the Society for Neuroscience.
Scholarly Publishing: Co-authored peer-reviewed papers across various scientific domains, effectively translating complex data insights into accessible language.

Mentorship & Training: Continuously mentored undergraduate students, researchers, and post-doctoral fellows, enhancing team skills and fostering professional growth.
Guidance: Provided leadership and guidance on professional conduct for newcomers.

Fostered Collaborative Environment: Worked closely with a multidisciplinary team and contributed to experimental designs that informed broader research objectives.
Spearheaded Multidisciplinary Initiatives: coordinated cross-disciplinary projects to meet shared research goals.

Built automated data pipeline with SQLite database storing hourly snapshots of hotel metrics, eliminating 2-3 hours of daily manual aggregation
Created dynamic KPI dashboard tracking 8+ critical metrics (occupancy rates, ADR, RevPAR, sold-out pressure) withcustomizable date ranges and time-scale views
Integrated Google's Gemini LLM with LangChain enabling plain-English queries (e.g., "Which month had highest arrivals?") that automatically generate SQL and visualize trends
Delivered production web-based dashboard reducing analysis time from hours to seconds while democratizing data access for non-technical staff

Developed a dynamic web application using the Tomorrow.io API to provide real-time weather insights tailored for golfers.
Enabled users to customize "golfable" parameters, including minimum temperature, maximum wind speed, and precipitation limits.
Designed a dashboard to display metrics such as temperature differences, wind variance, and precipitation likelihood, along with total golfable hours.
Created interactive visualizations using Matplotlib, highlighting optimal golfing windows throughout the day and the next four days.
Delivered an intuitive, data-driven solution to inform ideal golfing conditions, enhancing planning and decision-making for users.

Developed a Python-based application with a user-friendly interface to analyze millions of data points from running wheel experiments logged in Excel files.
Automated identification of valid running bouts (≥3 revolutions/min) and categorized activity by light and dark phases, significantly reducing manual processing time.
Consolidated raw data into a summary sheet with detailed metrics, ensuring efficient data organization and accuracy.
Enabled users to generate phase-specific bar graph visualizations, providing actionable insights into exercise behavior and activity patterns.
Delivered a robust, scalable solution that streamlined workflow, accomplishing tasks in seconds that previously required hours.