Casa Pepe Hostel BoutiqueProcess Engineering Specialist
Mar. 2025 - Apr. 2025Sayulita, Nayarit, MexicoIn my current role, I lead process engineering efforts for the operational and accounting management of multiple hotel properties, with a focus on data integration and strategic visualization.
My core responsibilities include:
- Room attendant assignment based on operational flow analysis.
- Integration of multiple data sources (users, QuickBooks IDs, internal and external sales channels, payment types).
- Data synchronization from cloud systems to QuickBooks.
- Design of the data architecture, including prioritizing key reports, categorizing operational expenses by property and vendor, and segmenting strategic debts.
- Configuration and customization of Klipfolio dashboards, such as:
- Net margin visualization by revenue and property.
- Cash flow and planned vs actual debt tracking.
- Forecast vs real comparisons (via Excel and Klipfolio).
- Analysis of critical vendors vs profitability.
- Development of advanced visualizations like stacked column charts by vendor, UBO margin breakdowns, and customized property dashboards.
- Continuous improvement of document structures in Drive and Excel to ensure clarity and traceability across accounting and management reports.