Manohar Kumar

Data Analyst

Omnisoft Systems Pvt Ltd

Jun 2024 - Present

Built a Power BI dashboard suite tracking 15+ KPIs across 5 business teams — decreased reporting and planning cycle time by 35% and gave leadership a single source of truth for weekly decisions. Automated data pipelines using Python (Pandas) and SQL that cut manual reporting effort by 40% and lifted data accuracy to 99% — the ops team went from spending hours on reports to spending minutes reviewing them. Wrote and maintained 60+ complex SQL queries (joins, CTEs, window functions, stored procedures) across 6+ integrated data sources for extraction, transformation, and validation. Identified operational bottlenecks through deep-dive analysis of process and performance data, delivering recommendations that boosted overall efficiency by 25%. Built an HR birthday automation tool in Python — deployed to UAT — that sent personalised email notifications to all team members automatically, replacing a manual HR process entirely. Collaborated with 8+ stakeholders across 4 business units to define KPIs, gather requirements, and iterate on dashboards — adoption went up 45% within two months of launch. Set up scalable data infrastructure on AWS (S3, EC2) that lowered data retrieval latency by 20% and kept reporting pipelines running at 99.9% uptime. Created 7+ executive-level reports and presentations in PowerPoint and Word for client and leadership meetings — translated technical findings into clear business narratives for non-technical audiences, contributing to a 30% faster sign-off on strategic decisions.