● Open to Work

Gaurang

Data Analyst | Market Research & Business Analytics Specialist
Sector 20, Noida

About Me

Data Analyst with three internships turning raw, messy datasets into decisions, including a 25% lift in stakeholder adopted recommendations through root cause analysis. Hands on with SQL, Python, Power BI, Tableau, Excel, and SPSS, plus AI assisted workflows (Claude) to speed up analysis and reporting. Strong data governance instincts, built from validating primary and secondary research end to end.

Skills & Technologies

SQLPythonPower BITableauExcelSPSSGoogle AnalyticsAI Assisted AnalyticsRoot Cause AnalysisData CleaningData ValidationData GovernanceDashboardingReportingTrend AnalysisMarket AnalysisHypothesis TestingQuantitative ResearchQualitative ResearchClaude (AI tool)

Work Experience

Data Analyst Intern

Oshodata
May 2026Jul 2026

Built Power BI and SQL dashboards to transform market and behavioral data into actionable BI, cutting weekly reporting by 20%. Applied SPSS and Google Analytics for data validation, reducing discrepancies by 15%. Designed surveys and used Python to detect behavioral trends adopted in reports. Leveraged AI tools including Claude to accelerate data structuring and insight generation, reducing analysis time by 18%, enhancing stakeholder engagement and cutting ad hoc reporting by 22%.

Research & Business Analytics Intern

Younglabs
May 2025Sept 2025

Performed root cause analysis on funnel and behavioral data identifying 10+ systemic data gaps; stakeholder adoption of recommendations raised outcomes by 25%. Standardized data collection and cleaning using SQL and Excel, improving data reliability. Produced concise summaries for cross-functional stakeholder decisions, speeding insight delivery.

Market Analyst Intern

Therapez
Jan 2025Apr 2025

Refined audience segments using market intelligence and competitor benchmarking, improving campaign targeting efficiency by 12%. Cross validated primary and secondary research to enhance market sizing accuracy and stakeholder confidence. Presented analytical reports and trend analyses directly to stakeholders for faster decision alignment.

Projects

Pre vs Post COVID Market Transformation Dashboard

Built an interactive Power BI and Excel dashboard consolidating multi-year datasets into a single comparative model, providing a clear, side-by-side view of market trend shifts pre and post COVID. Used Claude AI to accelerate data cleaning, structuring, and narrative drafting, significantly cutting build time.

Power BIExcelClaude

Placement Cell Outreach Optimization

Redesigned and streamlined the placement cell outreach process to recruiting companies, reducing outreach-to-response time and saving significant hours. Leveraged Claude AI to draft and refine outreach templates and prioritization logic, accelerating redesign.

Claude

Departmental Research Publications Database

Designed and built a searchable database cataloguing department's published research including paper details, authors, and contributors, currently in active use. Utilized Claude AI to structure the database schema and automate data entry and formatting for faster setup.

Database designClaude

Education

Bachelor of Arts (Hons)

Business Economics

Amity University, Noida2023 - 2026

Senior Secondary (Class XII)

Commerce with Mathematics

Somerville School, Noida2021 - 2023
Gaurang - Data Analyst | Market Research | HiringAnt