👋 Hello, I’m
Rajat
Hadaliya
Fit for: Data Analyst
I turn data into product, business, and operational decisions, and I lead the teams that deliver it. 5+ years of analytics, experimentation, and Agile delivery.
- 70%less manual reporting
- +11%revenue from A/B tests
- 40%faster data processing
- 3 moearly delivery of a data warehouse modernization
About me
I’m an analyst and analytics project lead with 5+ years of experience. The work is the same in any industry: gather requirements (BRD/FRD), build the data pipelines and dashboards, run experiments and forecasts, and lead Agile teams to deliver on time. I’ve done it in hospitality and financial services, using SQL, Python, Tableau, Power BI, Snowflake, and AWS, and I partner with senior leadership on pricing, planning, and risk decisions. I’m looking for analyst or project management roles in any industry, including technology and IT companies. I use Claude and other AI tools in my analysis and coding work.
What I bring to a team
Product analytics and experiments
A/B tests on a mobile check-in flow and upsell strategies, measured by adoption and revenue.
+28% adoption, +11% revenue
Business analysis and requirements
BRD/FRD requirements turned into KPI reporting that supports pricing, planning, and risk decisions.
Reporting for senior leadership
BI and dashboards
Tableau and Power BI dashboards that leaders use to track performance and act on it.
Real-time dashboards for trade performance and fraud alerts
Data pipelines and platforms
AWS Glue and Snowflake pipelines and migrations, with data governance and GDPR compliance built in.
70% less manual reporting, 40% faster processing
Forecasting and machine learning
Prophet demand forecasts, RFM customer segmentation, and a fraud detection model built with SQL and ML.
±4% forecast error, +9% account activation
Project and team leadership
Led a 7-member Agile analytics team, working in Jira and Confluence, from requirements to delivery.
Delivered 3 months ahead of schedule
My skills
💻 Languages and analysis
- Python
- Pandas
- NumPy
- Scikit-learn
- Prophet
- SQL
- R
- Bash
- Excel (Power Query, Power Pivot)
📊 Visualization and BI
- Tableau
- Power BI
- Looker
- Superset
🗄️ Databases and warehouses
- Snowflake
- BigQuery
- Redshift
- PostgreSQL
- MySQL
- MS SQL Server
- MongoDB
⚙️ Pipelines and cloud
- Airflow
- dbt
- Fivetran
- AWS Glue
- AWS (S3, Redshift, Athena)
- GCP
- Azure Data Factory
- Docker
- Git
🔮 Analytics methods
- Time-series forecasting
- A/B testing
- Clustering
- RFM segmentation
- Fraud detection
- Data governance
- KPI reporting
- RevPAR and ADR
🧭 Project and product
- Agile delivery
- Jira
- Confluence
- BRD/FRD requirements
- Stakeholder reporting
- A/B testing
- KPI reporting
- Data governance
🤖 AI tools
- Claude
- ChatGPT
- Microsoft Copilot (Excel, Power BI)
- GitHub Copilot
- Tableau Pulse
- AI-assisted SQL and Python
- Prompt design
- Validating AI output
Projects
Hospitality Revenue Analytics & Business Intelligence Platform
January – June 2026 · KTK Hospitality
An end-to-end analytics solution for hotel booking, revenue, occupancy, and cancellation trends, from raw data ingestion to business insights. It includes reusable KPIs (ADR, occupancy, cancellations) and Python forecasts that feed revenue management recommendations.
- AWS S3Raw storage
- AWS GluePrepare data
- SnowflakeWarehouse & SQL
- Power BIDashboards
Python builds the ETL workflows and forecasts. Excel supports the analysis.
- Built Python and AWS S3/Glue ETL workflows and Snowflake/SQL data models with reusable KPIs (ADR, occupancy, cancellations).
- Built Power BI dashboards and Python forecasts, turning findings into revenue management recommendations.
- Python
- SQL
- AWS S3
- AWS Glue
- Snowflake
- Power BI
- Excel
Work experience
- Feb 2025 – present
Data Analyst
KTK Hospitality Inc. · San Diego, CA
- Built a centralized reporting system with AWS Glue, Python, and S3, cutting manual reporting time by 70%.
- Designed Tableau dashboards tracking RevPAR, occupancy, and guest satisfaction for senior leadership, to guide pricing and the guest experience.
- Developed a Prophet demand forecasting model with ±4% MAPE, improving staffing and inventory planning.
- Led A/B tests on mobile check-in and upsell strategies, raising adoption by 28% and revenue by 11%.
- Set up data governance practices that improved data quality, GDPR compliance, and reporting accuracy.
- Feb 2017 – Aug 2021
Project Manager – Data Analytics Lead
Kotak Securities Ltd. · Ahmedabad, India
- Led a 7-member Agile analytics team delivering real-time Power BI dashboards for trade performance and fraud alerts.
- Spearheaded a Snowflake migration, redesigning 100+ legacy tables and cutting data processing time by 40%.
- Built an RFM customer segmentation model for targeted campaigns, lifting new account activation by 9%.
- Delivered a data warehouse modernization 3 months ahead of schedule.
- Developed a predictive fraud detection system with SQL and machine learning, earning the Kotak Innovation Award 2020.
My education
M.S. Data Analytics
Alliant International University · San Diego, CA
October 2024
M.S. Information Systems & Technology
Alliant International University · San Diego, CA
March 2023
B.Com (Commerce)
Gujarat University · Ahmedabad, India
April 2016
Certifications
Understanding Basic SQL Syntax
Coursera
February 2026
Preparing Data for Analysis with Microsoft Excel
Microsoft
February 2026
Let’s connect
I’m open to analyst and project manager roles in any industry, including technology and IT, and open to relocate. Email me or connect with me on LinkedIn.