Dron Goyal

Data Analyst | Data-driven Problem Solver

Bahadurgarh, IN.

About

Highly analytical and data-driven problem solver with hands-on experience in data analysis and visualization, leveraging SQL, Excel, and Power BI to extract actionable insights. Proven ability to identify critical trends, optimize business metrics, and develop interactive dashboards that informed strategic decisions and generated significant revenue (e.g., ₹1.25Bn, ₹8.18L). Eager to contribute robust analytical capabilities to a forward-thinking team that values data-guided decision-making and continuous professional growth.

Work

Metaverse India LLP

|

Business Development Intern - Data & Market Research

Bengaluru, Karnataka, India

→

Summary

Directed market research and data analysis initiatives to inform strategic marketing and business development decisions for India's event industry.

Highlights

Led an independent market research project on India's event discovery landscape, developing the methodology and constructing a validated dataset of 107 respondents, effectively resolving missing and inconsistent data entries.

Utilized SQL and Excel to extract, organize, and analyze internal business data, identifying key trends and patterns that informed strategic marketing and business decisions.

Performed comprehensive competitor analysis across 11 distinct platforms, synthesizing comparative data into actionable recommendations for strategic positioning.

Streamlined HR operations by supporting recruitment and onboarding processes for new hires, managing documentation and employee forms.

Education

Thapar Institute of Engineering and Technology (TIET)

Patiala, Punjab, India
→
Bachelor of Engineering Electronics & Communication Engineering Grade: CGPA: 7.00

Languages

English

Skills

Data Analysis

Microsoft Excel (Pivot Tables, VLOOKUP, Formulas, Data Validation), SQL (Joins, Aggregation, Filtering), Power BI (Data Modelling, DAX, Dashboards).

Core Competencies

Data Cleaning & Validation, A/B Testing, Exploratory Data Analysis, Statistical Analysis (descriptive stats, survey metrics), Business Intelligence, Data Visualization.

Other Tools

Git (Basics).

Projects

SQL Pizza Sales Analysis

Summary

Conducted a deep dive into pizza sales data using MySQL to uncover performance trends and revenue drivers.

Sales Analysis Dashboard

Summary

Developed a comprehensive sales analysis dashboard using Microsoft Excel to identify key business trends and optimize operational metrics.

E-commerce Sales Analysis Dashboard

Summary

Developed an interactive Power BI dashboard to analyze e-commerce sales data, revealing product, category, and regional trends.