kumar rajujnf

MIS Executive & Data Analyst

Hyderabad, Telangana 2+ yrs exp 91 · Outstanding

About

MIS Executive & Data Analyst with experience in MIS Reporting, Excel Reporting, SQL, Power BI, Dashboard Development, KPI Monitoring, Data Reconciliation, Data Validation, and Management Reporting. Skilled in transforming raw data into actionable business insights through reporting automation, analysis, and visualization.

Skills & Expertise (38)

Excel Advanced

8.3/10

Years Exp

Power BI Intermediate

7.8/10

Years Exp

SQL Intermediate

7.5/10

Years Exp

Power Query Intermediate

7.5/10

Years Exp

Data Analysis Intermediate

7.5/10

Years Exp

Data Cleaning Intermediate

7.5/10

Years Exp

Dashboard Development Intermediate

7.0/10

Years Exp

Management reporting Intermediate

7.0/10

Years Exp

Tableau Intermediate

6.5/10

Years Exp

DAX Intermediate

6.0/10

Years Exp

MySQL WorkBench Intermediate

5.0/10

Years Exp

Dashboard Reporting Interactive Reports Data Modeling Data Preparation MIS Reporting Business Reporting KPI Monitoring KPI Tracking Report Scheduling Data Reconciliation Report Automation Advanced Formulas XLOOKUP VLOOKUP Countifs SUMIFS Pivot Tables Macros Data Validation Conditional Formatting IFERROR Index Match Query Optimization Window Functions CTEs Joins MS Office

Work Experience

CA Course Incharge | MIS Reporting & Data Management

Master Minds for CA

Jul 2025 - Present

Generated daily, weekly, and monthly MIS reports for management using Excel and Power Query, ensuring data accuracy checks and reconciliation of student and fee records. Built Excel-based reports to track fee payments and student status for 500+ students. Improved reporting accuracy by 20% through structured data cleaning and validation processes.

Data Analyst (Internship)

ExcelR Solutions

Jan 2024 - Dec 2024

Presented reports to management and cleaned 50,000+ records using SQL and Power Query, reducing data inconsistencies by 30%. Developed 5+ KPI dashboards in Power BI to track revenue, churn, and conversion metrics for stakeholders. Identified a 15% decline in Q3 sales during analysis and presented findings through Power BI dashboards. Automated reporting workflows, reducing manual effort and improving reporting turnaround.

Customer Support Associate

Skill Lync

May 2022 - Aug 2022

Analyzed customer data for 200+ accounts to identify high-value segments, improving follow-up efficiency by 15%. Generated weekly reports tracking customer engagement and response patterns across 100+ interactions.

Customer Service Executive

CEAT PVT LTD

Oct 2021 - May 2022

Maintained and validated customer data for 300+ records in Excel, ensuring 100% data integrity across records. Analyzed service data to identify trends, contributing to a 10% improvement in operational processes. Collaborated with internal teams to streamline data entry workflows, reducing errors by 20%.