Ivanchapman6@gmail.com
This collection of projects reflects my expertise in SQL, Microsoft Office, Power BI, R, and HTML, with a focus on turning complex datasets into meaningful insights and practical solutions.
Bilingual (English/Spanish) professional with 8+ years of experience in fast‑paced, high‑pressure environments. Certified in Google Data Analytics and HTML, with technical skills in SQL, Excel, Tableau, and R. Recognized for adaptability, rapid learning, and a collaborative approach to problem‑solving. Strong interpersonal and communication abilities support effective teamwork and the delivery of clear, actionable insights.
Ivan Chapman
Hotel Revenue and Trends
This dashboard provides a comprehensive view of hotel performance by combining revenue analysis, guest behavior patterns, discount utilization, and operational needs such as parking. With dynamic filtering by time period and hotel type, stakeholders can quickly identify trends, diagnose issues, and make data‑driven decisions to optimize operations and maximize revenue.
Custom Payroll Sheet
I built a streamlined Excel tool that automates server tip payroll by tracking each employee’s credit and cash tip contributions, calculating department tip‑outs, and determining final server earnings for each shift. The sheet also computes hours worked and generates key KPIs like hourly averages and total earnings, giving managers a fast, accurate, and transparent way to run payroll.
Bike Share Dashboard
This report provides a comprehensive view of revenue performance, profitability, and rider demographics, offering a clear understanding of both financial outcomes and customer behavior. Its interactive design allows users to dynamically filter the data by Rider Type, Seasons, and specific time frames, making it easy to drill into patterns, compare segments, and uncover insights tailored to any operational or analytical need.