Jaggumantri Rohit

Data Analyst

Visakhapatnam, India 3+ yrs exp 88 · Excellent

About

Data Analyst with 4+ years of experience using SQL Server, Power BI, Python, and Excel to analyze operational data and build automated reporting solutions. Experienced in data modeling, KPI reporting, dashboard development, ETL, data quality analysis, and reporting automation for a 3,000+ person multi-vendor workforce. Reduced reporting turnaround by 70%+ and improved data accuracy through SQL-based automation, Power BI dashboards, and data validation workflows.

Skills & Expertise (30)

Power BI Advanced

8.5/10

Years Exp

Power Query Advanced

8.5/10

Years Exp

T-SQL Advanced

8.3/10

Years Exp

SQL Server Advanced

8.3/10

Years Exp

Data Validation Advanced

8.0/10

Years Exp

Data Cleaning Advanced

8.0/10

Years Exp

Data Transformation Advanced

8.0/10

Years Exp

Data Quality Checks Advanced

8.0/10

Years Exp

Reporting Automation Advanced

8.0/10

Years Exp

Excel Advanced

8.0/10

Years Exp

Descriptive Statistics Advanced

8.0/10

Years Exp

Exploratory data analysis Advanced

8.0/10

Years Exp

Data Integration Advanced

8.0/10

Years Exp

Pandas Advanced

8.0/10

Years Exp

Python Advanced

8.0/10

Years Exp

Data Modeling Advanced

8.0/10

Years Exp

KPI Analysis Advanced

8.0/10

Years Exp

NumPy Intermediate

7.5/10

Years Exp

VBA Intermediate

7.5/10

Years Exp

Row-Level Security Intermediate

7.5/10

Years Exp

MIS Reporting Intermediate

7.5/10

Years Exp

DAX Intermediate

7.5/10

Years Exp

Query Optimization Intermediate

7.5/10

Years Exp

Azure SQL Database Intermediate

7.5/10

Years Exp

Git Intermediate

7.0/10

Years Exp

GitHub Intermediate

7.0/10

Years Exp

ETL Intermediate

7.0/10

Years Exp

Matplotlib Intermediate

7.0/10

Years Exp

SciPy Intermediate

6.5/10

Years Exp

MySql Intermediate

6.5/10

Years Exp

Work Experience

Data Analyst

Vishvaja Engineering Works

Aug 2026 - Present

Manage SQL Server and Power BI reporting for workforce, attendance, and operational data, supporting day-to-day reporting. Build KPI dashboards and reporting solutions for engineers, department heads, and project managers. Perform ad hoc analysis and data validation across workforce, attendance, and leave data to support business decisions.

Data Analyst

RK Engineering

Oct 2022 - Jul 2026

Served as the sole Data Analyst for a 3,000+ person, multi-vendor workforce across 30+ contracting partners, managing reporting from data modeling through dashboard delivery. Designed and implemented a centralized SQL Server database for personnel records, replacing paper-based tracking and reducing manual data entry and errors by 50%. Automated Excel-based reporting using VBA and Power Query, reducing reporting turnaround time by 70%+. Used Python (Pandas) for exploratory data analysis, descriptive statistics, and data-quality validation across workforce and attendance datasets. Built Power BI dashboards with Row-Level Security (RLS) for 200+ engineers, team leads, and project managers, enabling role-specific self-service reporting. Designed three core reporting systems covering workforce, biometric attendance, and leave management, supporting workforce and payroll operations.