Sumit Kumar
Sumit Kumar

Data Analyst

Actively looking · Member since 29 Oct 2026
Location
Mathura, India
Desired salary
Unspecified
Work preference
Remote Only
Experience level
Junior

About

Professional summary

I am a results-driven Data Analyst with hands-on experience in data analysis, data cleaning, dashboard development, and business reporting. I work with SQL, Power BI, Python, Excel, and Google BigQuery to convert raw operational data into actionable insights.

I have experience developing interactive KPI dashboards and automated MIS reports for project operations, client queries, maintenance requests, billing metrics, procurement, and vendor analysis. My work supports timely, data-driven decision-making across business teams.

I am skilled in cleaning, validating, and transforming large datasets using Excel functions, Power Query, SQL, and Python. I use techniques such as joins, aggregations, window functions, exploratory data analysis, and data modeling to ensure data is accurate and useful.

In my current MIS Analyst role, I manage centralized trackers and reporting systems for construction projects. I have improved reporting accuracy, reduced manual reconciliation work, and helped management monitor project status and operational KPIs.

I have also built analytics projects using Google BigQuery, Power BI, and Looker Studio, including real estate market intelligence and construction management analytics. These projects involved querying data, calculating KPIs, and building interactive dashboards for stakeholders.

I am eager to grow as a Data Analyst and contribute analytical, reporting, and visualization skills to solve business problems through data.

Skills

24 capabilities

Tech stack & tools

Working toolkit

Data Stores

Development

Experience

Career history

MIS Analyst Jain Infra Group Pvt Ltd

Develop interactive MIS dashboards to monitor project progress, client queries, maintenance requests, billing metrics, and operational performance across multiple construction projects.

Maintain centralized trackers for CRM, client query management, maintenance PMS, and lead management. Standardize and validate datasets using Excel, XLOOKUP, Power Query, and Pivot Tables, reducing manual reconciliation effort by 35%.

Build automated visual reports for project status, pending requests, and operational KPIs, supporting faster management decisions across more than eight active projects.

MIS Intern Arush Switchgears LLP

Built procurement analytics dashboards to monitor vendor pricing, material costs, and purchasing trends, supporting cost-effective procurement decisions.

Cleaned and transformed large operational datasets using Excel and Power Query, improving data quality and consistency across more than 50,000 records.

Automated recurring MIS reports and procurement trackers, reducing manual reporting effort by 40% and improving reporting efficiency.

Education

Learning history

GL Bajaj Institute of Technology & Management, Mathura

B.Tech, Artificial Intelligence & Data Science

Bachelor of Technology in Artificial Intelligence and Data Science. Achieved 65%.

This professional hasn’t added portfolio projects yet.

This professional hasn’t listed any services yet.

Jobs Talent AI Tools Salaries
Menu