Anjali Thakur

Data Analyst
Gurugram, IN.

About

Detail-oriented Data Analyst with over 2 years of experience in leveraging SQL, Power BI, and Excel to transform complex datasets into actionable business intelligence. Proven ability to design impactful dashboards, uncover critical customer behavior insights, and drive data-driven strategies, as demonstrated by optimizing client outcomes for 200+ Google Hotel Partners and improving business growth by 50%.

Work

VACO BINARY SEMANTICS LLP
|

Analyst (Client – Google)

Gurugram, Haryana, India

Summary

Analyzed web traffic and performance data for over 200 Google Hotel Partners, delivering critical insights and driving significant business growth for Google Hotel Ads.

Highlights

Analyzed and validated web traffic data for over 200 Google Hotel Partners, ensuring data integrity and accuracy for critical business decisions.

Developed and maintained comprehensive data reports and interactive dashboards to monitor key performance metrics, enabling data-driven decision-making.

Designed and implemented data-driven A/B testing strategies, optimizing client outcomes and enhancing product performance.

Managed and resolved client escalations through root cause analysis (RCA), directly contributing to a 50% improvement in business growth over the last year.

Leveraged expertise in SQL databases, ETL processes, and data validation tools to ensure robust data pipeline management and quality.

CODTECH IT SOLUTIONS
|

SQL Intern

Gurugram, Haryana, India

Summary

Gained practical experience in relational database management and collaborated on generating data-driven insights for business decision-making.

Highlights

Gained hands-on experience in relational database management, specifically with MySQL and PostgreSQL, for efficient data storage and retrieval.

Collaborated with senior analysts to develop and generate dashboards and reports, providing critical insights for strategic business decision-making.

Assisted in writing and optimizing SQL queries for efficient data extraction, transformation, and reporting processes.

Education

University College, Kurukshetra
Kurukshetra, Haryana, India

Master of Science

Engineering Physics

University College, Kurukshetra
Kurukshetra, Haryana, India

Bachelor of Science

Physics, Chemistry, Math

Certificates

Google Data Analytics Professional Certification

Issued By

Coursera

Statistics for Data Science

Issued By

Simplilearn

SQLite Made Easy

Issued By

Udemy

Business Analysis Basics

Issued By

Simplilearn

Advanced Excel Mastery

Issued By

IDigitalpreneur

Create Dashboards with Tableau

Issued By

OpenClassrooms

Skills

Database Management

SQL, MySQL, PostgreSQL, Relational Databases, Optimized SQL Queries.

Data Analysis & Visualization

Power BI, Excel, Tableau, PLX, Crowd Compute, Dashboard Design, Data Reporting, A/B Testing.

Data Engineering & ETL

ETL Processes, Data Validation, Data Extraction, Data Transformation.

Business Intelligence & Strategy

Business Metrics, Customer Behavior Analysis, Actionable Insights, Root Cause Analysis (RCA), Performance Metrics, Business Decision-Making.

Project & Stakeholder Management

Client Escalation Management, Cross-functional Collaboration, Problem Identification, Solution Execution.

Projects

Sales Data Analysis of Monday Coffee

Summary

A personal project focused on analyzing sales data for 'Monday Coffee' using SQL, Excel, and Power BI to derive actionable business insights and optimize sales strategies.