Looking for a job

Leonardo Schmoll

@leonardoschmoll

Message

I turn operational and business data into clear dashboards and actionable insights.

Portugal

Message

What I'm looking for

I'm looking to apply my SQL, dashboarding, and analytical skills to real-world business challenges, turning operational data into clear insights that support data-driven decisions and continuous improvement.

I've used data analysis at Pestana Hotels Group to identify guest-behavior patterns, analyze booking trends, forecast occupancy, and improve reporting accuracy through reliable PMS data.

Previously at Casino Club S.A., I analyzed daily betting data and financial reports while automating employee-record processes with Excel pivot tables and VBA, reducing processing time by 75%. I also build interactive Power BI and Tableau dashboards and work with SQL, MySQL, PostgreSQL, Excel, and DAX.

Experience

Work history, roles, and key accomplishments

Receptionist/ Night Auditor

Pestana Hotels Group

Jul 2024 - Jun 2025 (11 months)

Leveraged data analysis to identify monthly patterns in guest behavior and operational performance. Maintained and optimized the Property Management System (PMS) and analyzed booking trends to forecast occupancy rates.

Data Analysis Property Management Systems Forecasting Reporting

Treasury Assistant / HR Assistant

Casino Club S.A.

Jan 2008 - Dec 2016 (8 years 11 months)

Monitored and analyzed daily slot machine betting data to support revenue calculations. Prepared financial reports on cash flow and liquidity, and managed employee records systems using Excel pivot tables and VBA scripting.

Excel VBA Pivot Tables Financial Reporting Data Analysis