Back to Developers
Sugandha Pathak

Sugandha Pathak

Data Analyst

Hyderabad 2+ yrs exp 90 · Outstanding

About

Data Analyst with 2+ years of experience in reporting, data analysis, dashboard creation, and business intelligence. Proficient in Advanced Excel, SQL, Power BI, and data visualization. Experienced in transforming raw data into actionable insights, automating reporting processes, developing KPI dashboards, and supporting business decision-making. Strong analytical and problem-solving skills with exposure to hospitality and e-commerce operations.

Skills & Expertise (15)

Advanced Excel Advanced
7.8/10
2
Years Exp
Pivot Tables Advanced
7.5/10
2
Years Exp
Data Cleaning Advanced
7.5/10
2
Years Exp
Power Query Intermediate
7.2/10
2
Years Exp
XLOOKUP Intermediate
7.0/10
2
Years Exp
SQL Intermediate
7.0/10
2
Years Exp
Microsoft Office Intermediate
7.0/10
2
Years Exp
Power BI Intermediate
6.8/10
2
Years Exp
KPI Dashboards Intermediate
6.5/10
2
Years Exp
Joins Intermediate
6.5/10
2
Years Exp
Aggregate Functions Intermediate
6.5/10
2
Years Exp
Conditional Formatting Intermediate
6.5/10
2
Years Exp
Interactive Visualizations Intermediate
6.0/10
2
Years Exp
Data Modeling Intermediate
6.0/10
2
Years Exp
Subqueries Intermediate
6.0/10
2
Years Exp

Work Experience

Operations Executive – Data Analyst

Flipkart(Futurz First)

Feb 2026 - May 2026

Analyzed operational and purchase order datasets to support business processes and improve tracking accuracy. Automated recurring reports using Excel-based automation and reporting workflows, reducing manual effort and improving efficiency. Utilized Advanced Excel functions including Pivot Tables, XLOOKUP, CEILING, and Power Query for data cleaning, transformation, and reporting. Conducted data validation and quality checks to ensure accuracy and compliance across operational datasets. Generated KPI reports and operational performance summaries for business stakeholders.

Assistant Manager – Data Analyst

Greenpark Hotels

Jan 2025 - May 2025

Developed weekly and monthly business reports using ERP and PMS data to monitor occupancy, revenue, and operational performance. Extracted and analyzed business data using SQL to support management reporting and decision-making. Automated reporting processes in Excel, improving reporting efficiency and reducing manual effort. Performed trend and variance analysis on key business metrics including occupancy, ARR, revenue, and costs. Collaborated with cross-functional teams to ensure reporting accuracy and data consistency.

Management Trainee – BPM Department

Greenpark Hotels

Jun 2023 - Dec 2024

Prepared daily, weekly, and monthly MIS reports to support business operations and management reviews. Analyzed occupancy, ARR, revenue, and operational KPIs to identify trends and performance gaps. Worked with multiple departments to validate business data and improve reporting accuracy. Supported ad-hoc analytical requests and process improvement initiatives through data-driven insights.

Business Analyst Intern

Precision Business Insights

Dec 2022 - May 2023

Conducted market research and contributed to client-facing analysis reports. Assisted in data collection and visualization across multiple sectors. Utilized pre-built Excel tools with macros and used PowerPoint templates for reporting.

Education

Post Graduate Diploma in Management - Business Analytics - Siva Sivani Institute of Management

2021 - 2023 · Afghanistan

B.Sc. - Science - Bhavans Vivekananda College

2017 - 2020 · Afghanistan

Certifications

Business Analytics

Harvard Online · 2022

Business Intelligence Fundamentals

· 2022

Master Excel for Data Science

· 2022

Interested in this developer?

Profile Score Breakdown

📷 Photo 10/10
📄 Resume 10/10
💼 Job Title 10/10
✍️ Bio 10/10
🛠️ Skills 20/20
🎓 Education 10/10
⏱️ Experience 10/15
💰 Rate 0/5
🏆 Certs 5/5
Verified 5/5
Total Score 90/100

Profile Overview

Member sinceJul 2026

Availability Details

Relocation

Not Open to Relocation