Anurag Virsen

Entry-Level Junior Analyst

Nagpur, India 0+ yrs exp 60 · Good

About

Entry-Level Junior Analyst with hands-on experience in Microsoft Excel, SQL, and Power BI, focused on collecting, cleaning, and validating data to support business reporting and decision-making. Standardized 6,336+ operational records into reporting-grade tables, tracked KPIs and operational metrics through star-schema Power BI dashboards, and performed data validation and quality checks before publishing reports for stakeholder review. Comfortable working independently in a remote environment, translating business questions into structured analysis.

Skills & Expertise

No skills listed yet

Work Experience

Data Analyst Intern

Renu Sharma Healthcare & Educational Foundation

Aug 2026 - Sep 2026

Built a sales performance dashboard in Excel with PivotTables, charts, and formulas, condensing 3,001 raw sales rows into summary views used for management reporting. Overhauled a raw dataset in Python (Pandas, NumPy), resolving missing values, duplicate rows, and inconsistent formats, then documented a before/after data-quality comparison. Analyzed a movie ratings dataset in Python (EDA), producing 5+ visualizations covering genre distribution, average ratings, and release-year trends.

Data Analyst (Internship)

Atliq Technologies

Jul 2026 - Aug 2026

Validated 6,336 attendance records with Power Query, Excel, and SQL for data accuracy; standardized employee IDs, dates, names, and status codes into a 6,208-row reporting table. Developed Power BI reports using DAX and dimensional data modeling to track attendance, WFH, leave, work mode, and workforce KPIs — mirroring operational-metrics reporting. Designed an insurance dashboard spanning 7 dimensions — revenue, customers, policies, sales modes, age groups, cities, and settlement trends — for executive reporting.