Revenue Insights in Hospitality Domain
Summary
Analyzed hotel booking and revenue data to uncover critical patterns, trends, and anomalies within the hospitality sector.
About
Highly analytical Technical Business Analyst and Data Analyst with 3+ years of experience in translating complex data into actionable insights and strategic solutions. Proven expertise in data mining, transformation, and visualization across cloud platforms, delivering impactful dashboards and robust data pipelines. Adept at functional requirements documentation, stakeholder collaboration, and ensuring data quality to drive significant improvements in conversion rates and customer retention.
Work
Pillir
|Data Analyst
Remote, US
→
Summary
Led data analysis and visualization initiatives for a cloud-based platform, driving significant improvements in data integrity, stakeholder self-service capabilities, and business performance.
Highlights
Designed and deployed 10+ interactive dashboards using Power BI and Tableau, visualizing critical KPIs (CAC, CTR, ROAS) and reducing ad-hoc data requests by 35%.
Integrated diverse performance data from Google Analytics, Facebook Ads, and internal sources, boosting conversion rates by 22% through comprehensive analysis.
Developed automated data pipelines with SQL and Databricks, enhancing data transparency and optimizing business processes through detailed functional workflow documentation.
Constructed data models in Snowflake to support churn prediction and targeted email strategies, contributing to an 18% increase in customer retention.
Executed advanced data cleaning on 10M+ rows in Excel and Google Sheets, significantly improving data integrity and accuracy for downstream analytics.
Collaborated with engineering and QA teams to define and validate test cases for marketing data integrations, elevating pipeline accuracy by 30%.
Presented data-driven insights to senior stakeholders, influencing key budget reallocations and shaping marketing strategy.
Translated complex business requirements into functional specifications, user stories, and KPI tracking dashboards, ensuring alignment across technical and business teams.
Education
Anna University
Chennai, Tamil Nadu, India
Bachelor of Engineering (BE)
Computer Engineering
Dublin City University
Dublin, Leinster, Ireland
Master of Science (MSc)
Data Analytics
Languages
English
Certificates
Google Professional Data Analytics
Issued By
Microsoft Azure Fundamentals
Issued By
Microsoft
ECBA - Entry Certificate in Business Analysis
Issued By
IIBA
Skills
Programming & Scripting
Python, SQL, PL/SQL, XML, JavaScript (basic).
Data Analysis & Visualization Tools
Power BI, Tableau, Oracle Analytics, Excel, Google Sheets, Matplotlib, Seaborn, DAX.
Databases
Oracle, Snowflake, MySQL.
Big Data & ETL
Hadoop, Spark, Databricks, Airflow (DAG), API-based Data Ingestion, ETL Workflows.
Cloud Platforms
Azure Cloud, Amazon S3.
Machine Learning & Statistics
R, SPSS, Pandas, Scikit-learn, NLP (TF-IDF, Sentiment Scoring), Anomaly Detection, Pattern Detection.
Business Analysis & Project Management
Functional Requirements, User Stories, Test Case Design & Validation, Business Process Documentation, Data Mapping & Transformation, Data Modeling (Snowflake, Oracle), Integration Testing, Dev/QA/Ops Collaboration, Jira, GitHub.
Soft Skills
Clear Communication (Verbal & Written), Presentation Skills, Team Player, Stakeholder Management, Cross-functional Teamwork, Analytical Thinking, Data-Driven Decision Making, Problem Solving, Works Well Under Pressure, Meets Deadlines, Self-Starter.
Projects
British Airways Review Analysis
Summary
Conducted an in-depth analysis of over 15,000 British Airways customer reviews to understand sentiment and identify key areas for service improvement.
Semantic Analysis of Amazon Review (Thesis)
Summary
Thesis project focused on applying machine learning techniques to analyze Amazon reviews for anomaly and pattern detection, specifically for fraud prevention.