ANUJ KUMAR

Data Analyst | Business Intelligence Specialist
Delhi, IN.

About

Results-driven Data Analyst with hands-on experience in SQL, Python, Excel, Tableau, and Power BI, adept at performing statistical analyses to drive process optimization and deliver actionable insights. Eager to leverage analytical skills for data-driven innovation and sustainable development within the research sector, ensuring data integrity, tracking KPIs, and presenting clear findings to cross-functional teams.

Work

Unified Mentor Pvt. Ltd
|

Data Analyst (Internship)

Delhi, Delhi, India

Summary

Collaborated with backend and analytics teams to extract, clean, and transform data, building client-facing dashboards that improved decision-making speed by 20% and ensuring 99% data accuracy.

Highlights

Built and deployed client-facing dashboards using Power BI and Tableau, enhancing decision-making speed for key stakeholders by 20%.

Automated KPI and variance reports with SQL and Python, significantly reducing manual effort and increasing report reliability.

Ensured 99% data accuracy across all reporting layers through rigorous validation and testing procedures, maintaining high data integrity.

Conducted comprehensive ad-hoc analyses to identify operational trends, gaps, and optimization opportunities, informing strategic decisions.

Documented complex logic, metric definitions, and provided clear, stakeholder-friendly explanations to enhance transparency and understanding of financial and operational strategies.

Education

MIET, MEERUT
Meerut, Uttar Pradesh, India

Bachelor of Technology

Computer Science

Grade: CGPA: 7.58

Courses

Data Analytics

DBMS

Business Intelligence

SQL

Python Programming

Languages

English

Certificates

5 SQL

Issued By

Hackerrank

Mastering Data Analytics (Tableau, Advanced Excel, MySQL, & Python)

Issued By

Geeks For Geeks

Data Analytics and Visualization Job Simulation

Issued By

Forage-Accenture North America

Skills

Programming & Databases

MySQL (CTE, View, Window functions, Aggregation), Python (Numpy, Pandas), API Integration.

BI & Reporting Tools

Power BI, Power Query, Tableau, Google Sheets, Advanced Excel (Pivot Table, VLOOKUP, Conditional Formatting).

Data Analysis & Reporting Skills

Data Cleansing, Data Management, Data Modeling, ETL, Data Visualization, EDA, KPI Tracking, Forecasting Reports, Dashboard Creation, Business Intelligence, Report Reconciliation.

Marketing Analytics

Customer Segmentation, Acquisition Metrics, Conversion Rate Analysis.

Communication & Collaboration

Requirements Gathering, Feedback Implementation, Cross-functional Collaboration, Insights Presentation.

Soft Skills

Analytical & Critical Thinking, Problem Solving, Attention to Detail, Teamwork, Adaptability, Ownership Mindset.

Projects

Hospitality Revenue Analysis Dashboard

Summary

Developed an interactive Hospitality Revenue Analysis Dashboard using Power BI & SQL, consolidating data across multiple cities and properties to enable real-time performance monitoring.

Retail Sales & Customer Behavior Analysis

Summary

Delivered monthly sales insights across 50+ store locations using MySQL, helping regional teams reduce inventory mismatch by 20% and optimize inventory management.

ANUJ KUMAR