DIPTI KUMARI

I’m a data analyst who turns messy loan and transaction data into clear business reporting. I work across SQL and Python to clean, validate, and model datasets, then translate findings into dashboards stakeholders can act on.

In my Data Analyst Intern experience at Arth (Link Tools and Technologies), I developed business funnel reports for Onboarding → Sanction → QC → Disbursed using SQL features like CTEs, DISTINCT ON, DATE PART, and EXTRACT. I also automated recurring workflows in Python to deliver insights into loan disbursal trends across 18 branches.

I improved reporting reliability by collecting, cleaning, validating, and standardizing raw loan datasets with SQL and Pandas, resolving 15% inconsistencies. By automating daily and weekly master reports, I saved the team 10+ hours of manual data entry per week and increased reporting accuracy.

Across my projects, I’ve applied exploratory data analysis and visualization to support risk assessment and decision-making—using Python (Pandas, NumPy, Matplotlib, Seaborn) and building interactive Power BI dashboards. I’m especially driven by work that combines ETL-minded data preparation, strong analytical thinking, and practical communication through dashboards.