Shilpita Gope

Shilpita Gope

Data Analyst
India
Full-time Remote

About Me

Data Analyst skilled in SQL, Power BI, Excel, and Python experienced in building dashboards and performing trend analysis on 100K+ datasets to support business decisions.

Experience

Data Analyst

Netoyed · Gurgaon , Haryana , India
Apr 2026 - Present · 3 months

Collaborated with Sports Authority of India(SAI) and 10+ sports federations to collect, validate, and manage athlete participation, tournament, and medal data for audit and compliance reporting. Cleaned and transformed 50,000+ sports records using Excel and SQL, improving data accuracy by 30% and reducing reporting errors during SAI audits. Built interactive dashboards and MIS reports to monitor athlete participation, medal trends, and federation performance, enabling stakeholders to generate insights and reduce manual effort by 40%.

Data Analytics Intern

LAIQA · Gurgaon , Haryana , India
Dec 2025 - Mar 2026 · 2 months

Analyzed health and fitness data by developing SQL queries to generate over 30 metrics across 4 different environments, using advanced techniques such as window functions and date functions on Metabase. Created complex SQL queries to extract insights on users’ medical histories, subscription details, plan-wise metrics, and professional consultations by joining multiple tables. Worked on key performance indicators (KPIs) such as paid users, total users under each dietician and doctor, user weight, and city-wise user counts, driving actionable insights to improve business operations. Utilized Excel for data analysis and reporting, applying advanced formulas like SUMIFS, COUNTIFS, VLOOKUP, and pivot tables to enhance data accuracy and support decision-making processes. Improved reporting efficiency by automating key data processes and generating user-friendly dashboards to provide real-time metrics for various stakeholders.

PROJECTS

Zomato-Data-Analysis

Netoyed · https://github.com/Shilpita-Gope/Zomato-Data-Analysis-Project
Duration : 07-Apr-2026 - 10-Jun-2026

The Zomato Data Analysis Project is a data-driven case study where restaurant and food delivery data is analyzed to generate meaningful business insights. The project involves loading and managing Zomato dataset tables and using SQL queries to explore customer behavior, restaurant performance, order patterns, ratings, and spending trends. Through data cleaning, filtering, joins, and aggregation techniques, raw data is transformed into useful insights that help understand how customers interact with restaurants and how different factors impact business performance. Overall, this project demonstrates strong SQL skills and the ability to solve real-world business problems using data analysis.

Certifications

Coding Ninjas Data Analytics

Coding Ninjas · Gurgaon , Haryana , India · 2025

Skills

Statistics Statistical Analysis System Python Pandas NumPy Matplotlib Seaborn MySQL PostgreSQL MS SQL Server SQL Joins Aggregations Subqueries Window Functions CTEs Power BI DAX Excel Power Query Pivot Tables Communication Data Storytelling Collaboration
Report this Profile?