Yashraj Singh

Data Analyst | Business Intelligence Specialist

LinkedIn | GitHub | Email | Phone

[email protected]

+918178217267

Gurugram, IN

About

Highly analytical and results-driven Data Analyst with an M.Sc. in Physics, specializing in leveraging Power BI, SQL, and Python to transform complex datasets into actionable business intelligence. Proven ability to optimize marketing campaigns, drive revenue acceleration, and reduce operational costs by delivering data-driven insights and automating reporting processes.

Work Experience

Analyst - Growth & Marketing

Pravis Growth Partners | Permanent

Aug 2024 - Present

Gurugram, Haryana, India

Drove data-driven growth and marketing optimization through advanced analytics and reporting for diverse campaigns.

  • Analyzed performance of over 20 marketing campaigns using Google Analytics, Google Ads, and YouTube API data, generating continuous insights to optimize campaign strategies.
  • Developed and maintained 3 automated ad-level reports in Looker Studio, reducing manual reporting time by 50% and improving data accessibility.
  • Leveraged SQL and Python (Pandas, Numpy) to analyze large datasets, automate data extraction scripts, and deliver actionable, data-driven insights.
  • Executed A/B testing on marketing campaigns, identifying critical performance trends and informing data-backed decisions for optimization.

Summer Intern

Indian Institute of Information Technology Allahabad

Jun 2022 - Jul 2022

Allahabad, Uttar Pradesh, IN

Conducted research in Survival Analysis, gaining expertise in handling censored and truncated data under Dr. Savitri Joshi.

  • Conducted in-depth research on Survival Analysis, acquiring practical experience in analyzing complex censored and truncated datasets.
  • Applied R Programming Language for comprehensive data analysis and manipulation, developing proficiency in statistical computing.
  • Developed statistical models and visualizations to interpret survival data, contributing to research project objectives.

Education

Physics

NIT Rourkela

Aug 2021 - May 2023

Rourkela, Odisha, India

Projects

Business 360 - Brick & mortar and ecommerce

Apr 2024 - Apr 2024

Developed a comprehensive Power BI dashboard to analyze sales trends for AtliQ hardware across global markets, integrating data from multiple sources.

Product Insights – Banking Domain

Jan 2024 - Jan 2024

Spearheaded a critical project for Mitron Bank, developing actionable insights for the successful launch of a new line of credit cards.

Executive Management - Consumer Goods

Mar 2023 - Mar 2023

Delivered data-driven insights to executive management on 10 ad-hoc business requests, leveraging SQL for querying a million-row database.

Awards

SQL (Advanced) Skill Test Certification

HackerRank

Feb 2025

Achieved advanced proficiency in SQL, validated by HackerRank's rigorous skill test, demonstrating expertise in complex database querying and manipulation.

Top 20 Submission, CodeBasics Resume Project Challenge #10

CodeBasics

May 2024

Recognized among the top 20 submissions for excellence in the CodeBasics Resume Project Challenge, demonstrating strong project execution and data storytelling.

Skills

Data Analysis & Business Intelligence

  • Power BI
  • Looker
  • Google Analytics
  • DAX Studio
  • MS Excel
  • Snowflake
  • SQL
  • Python (Pandas, NumPy, Seaborn)
  • R Programming Language
  • Looker Studio

Statistical Analysis & Modeling

  • A/B Testing
  • Regression Analysis
  • Hypothesis Testing
  • t-tests
  • Chi-square tests
  • Survival Analysis

Data Visualization & Reporting

  • Power BI
  • Looker Studio
  • Figma
  • PowerPoint

Scripting & Automation

  • Python
  • SQL
  • Google Scripts