Dharmendra Kumar

About Dharmendra Kumar

Improved reporting efficiency by 85%, reduced SQL query time by 55%, and accelerated decision-making speed by 75% by building scalable data systems and real-time dashboards across high-volume operations.I’m a Data Analyst with 1+ year of experience turning raw, unstructured data into reliable reporting systems and actionable insights. I work across the full data stack — from data extraction and cleaning to modeling, optimization, automation, and visualization.Core strengths:Advanced SQL | Python | Power BI | Looker Studio | Excel | DatabricksI enjoy solving messy data problems, building systems that scale, and working closely with stakeholders to translate data into decisions. Solved 200+ SQL problems across platforms such as LeetCode, HackerRank, and StrataScratch, and completed the 100 Days of SQL course by Ankit Bansal.Resume: https://bit.ly/Resume_Dharmendra_Kumar_IITKGPPortfolio : https://dharmendra121199.github.io/my-portfolio/Open to Data, Business, and Product Analyst roles where I can contribute to building efficient, data-driven organizations.

Experience

1. Data Analyst

   Jspt Consultants Pvt. Ltd

   Feb 2025 — Present · Patna, IN

   Optimized database performance by implementing indexes and refining SQL logic, significantly reducing query execution time by 60% for high-volume datasets and enabling faster, more efficient data processing across all operations• Created automated Google Apps Scripts to efficiently split large datasets by district and block into separate sheets and tabs, export reports as PDFs, and manage permissions — improving data accessibility for multiple teams• Performed advanced data cleaning and fuzzy matching in Python to accurately standardize district, block, panchayat, and village names, ensuring consistently high data accuracy across millions of records collected from field forms• Designed & deployed real-time Power BI & Looker Studio dashboards for Jan Suraaj Parivar Laabh Card (PLC) Campaign, integrating PostgreSQL data to track district, team, and canopy level KPIs, reducing manual reporting effort by 80%• Engineered a data pipeline to ingest, clean, transform large-scale Google Sheets data into a MySQL environment using Python (SQLAlchemy) — enabling seamless daily synchronization & eliminating duplication across millions of records.• Engineered and deployed recursive CTE-based SQL queries with indexed hierarchy joins and optimized aggregation logic, significantly enhancing performance, scalability, and reporting accuracy in the PLC project’s data pipeline.• Automated & efficiently managed web scraping workflows using Selenium, BeautifulSoup and Pandas to extract nomination details and structured data from government websites, with robust built-in error handling

Education

• Indian Institute of Technology, Kharagpur

  Master's degree, Integrated Chemistry (5years)

  2019 — 2024