Yashraj Singh

Data Analyst | Business Intelligence Specialist
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

Pravis Growth Partners
|

Analyst - Growth & Marketing

Gurugram, Haryana, India

Permanent

Summary

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

Highlights

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.

Indian Institute of Information Technology Allahabad
|

Summer Intern

Allahabad, Uttar Pradesh, India

Summary

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

Highlights

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

NIT Rourkela
Rourkela, Odisha, India

M.Sc.

Physics

Awards

SQL (Advanced) Skill Test Certification

Awarded By

HackerRank

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

Awarded By

CodeBasics

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.

Projects

Business 360 - Brick & mortar and ecommerce

Summary

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

Summary

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

Summary

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