Dhruv Sharma
New Delhi
Summary
Data Analyst who translates SQL datasets into clear reporting, pattern detection, and practical business recommendations. Works across SQL querying, ETL optimization, and customer segmentation, optimizing 9+ queries to improve inventory planning, reduce manual research effort, and support marketing decisions. Delivers analysis that helps teams move faster on revenue, growth, and conversion priorities.
Overview
5
5
Certifications
1
1
year of professional experience
Work History
Data Analyst Intern
S O Infotech (P) Ltd
02.2026 - 04.2026
- Analyzed 12,500+ transactions using SQL to identify consumer purchase patterns and optimize inventory allocation decisions
- Built automated Power BI dashboards processing 800k+ global records, improving reporting efficiency by 22% by optimized ETL
- Tracked and visualized 6+ critical KPIs (Revenue, Growth, Conversion) to enable faster stakeholder decision-making
- Optimized SQL queries and data pipelines for 7,500+ records, reducing manual research effort by 18%
- Developed insight models to identify high-value customer demographics, supporting targeted marketing and acquisition strategies
- Driving Sales Growth through Advanced Data Analysis
Digital Marketing Analyst Intern
Aviox Technologies Pvt. Ltd.
05.2025 - 07.2025
- Analyzed 15000+ daily data points across Meta, Instagram and LinkedIn to optimize campaign Reach and CTR
- Identified high-performing content patterns that drove a 22% increase in engagement and reduced CPC by 10%
- Monitored KPIs across 5+ marketing projects and delivered weekly insight reports, accelerating decision cycles by 35%
- Segmented 3,000+ user datasets to refine targeting strategies, resulting in a 12% improvement in conversion rates
- Built automated ROI tracking models in Advanced Excel, cutting manual reporting time by 25%
- Scaling Brand Engagement and Marketing ROI
Education
Bachelor of Business Administration - Business Analytics
Jaypee Institute of Information Technology
Noida, Uttar Pradesh07-2023
Class XII - commerce
Bal Bhavan Public Sr. Sec. School
New Delhi, India05-2023
Skills
SQL
Python
Power BI
Tableau
Advanced Excel
Data cleaning & transformation
Exploratory data analysis
Statistical modeling
Trend analysis
Forecasting
KPI reporting
Dashboard development
Data visualization
ETL workflows
Stakeholder reporting
Certification
Data Analyst Professional Course | DUCAT, Noida
Timeline
Data Analyst Intern
S O Infotech (P) Ltd
02.2026 - 04.2026
Digital Marketing Analyst Intern
Aviox Technologies Pvt. Ltd.
05.2025 - 07.2025
Class XII - commerce
Bal Bhavan Public Sr. Sec. School
Bachelor of Business Administration - Business Analytics
Jaypee Institute of Information Technology