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.
In-House Guest List & Housekeeping ETL Pipeline (Python, Pandas, OpenPyXL):
Architected an automated data transcription pipeline to parse legacy Visual Matrix
PMS exports into structured tabular datasets, applying date-range business logic to
automate action triggers and streamline guest management workflows.
Multi-Period Revenue & Operations Analytics Platform (Python, Streamlit, Pandas, Plotly):
Engineered and deployed custom Python/Streamlit data analytics applications to process and
visualize hotel operations and Visual Matrix PMS revenue data,
automating multi-CSV time-series analysis, dynamic KPI metrics, and
seamless Excel export workflows for hotel leadership.
Experimental Research Professional
University of Colorado Denver Behavioral Neuroscience Laboratories | 2015 – 2024
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.
Professional Research Assistant
University of Colorado Boulder Institute for Behavioral Genetics | 2012 – 2015
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.
Undergraduate Researcher
University of Colorado Institute for Behavioral Genetics | 2009 – 2012
Experimental Execution:
Applied molecular biology techniques to analyze genetic variations in mouse models,
focusing on nicotinic receptor differences in knockout strains.
Data-Driven Phenotyping:
Conducted systematic cross-breeding and behavioral testing to generate reliable datasets for phenotypic characterization.
High-Volume Data Pipeline:
Managed continuous data collection across a colony of 20 unique mouse strains and hundreds of subjects with rigorous record-keeping.
Management
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.
Communication
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.
Leadership
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.
Collaboration
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.
SELECTED PROJECTS
Hotel Revenue Intelligence Dashboard With AI Query System
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
Dynamic Group Matching Analysis with PySimpleGUI
Developed a PySimpleGUI desktop application to analyze and optimize group assignments
from Excel data, preserving cage mate pairing.
Evaluated all possible group combinations, calculating metrics such as means,
absolute differences, and the smallest mean difference between groups.
Automated data export to Excel and visualized results using Matplotlib,
producing line plots that highlight optimal group assignments and minimal variance.
Delivered actionable insights to improve decision-making in experimental setups
through comprehensive analysis and visualization.
Automated Wheel Running Data Analysis Tool
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.