Biking
Dhiraj Sharma
Data Analysis
Pune City
Summary
Detail-Oriented Data Analyst experienced in data analysis and reporting. Delivered actionable business insights through SQL, Microsoft Excel, and Power BI, ensuring data accuracy and reliability. Focused on enhancing business intelligence initiatives and supporting data-driven decision-making.
Overview
5
5
years of professional experience
Work History
Data Analyst
Kiam Intl Pvt. Ltd.
08.2025 - Current
- Extract, clean, transform, and organize data to support accurate reporting and business analysis.
- Use SQL queries to retrieve and analyze relevant data from structured data sources.
- Developed and maintained Power BI dashboards and reports that tracked key performance indicators and business metrics.
- Perform data validation and reconciliation to identify inconsistencies and improve the reliability of analytical outputs.
- Collaborate with business stakeholders to understand reporting requirements and translate them into analytical deliverables.
- Collaborated with business stakeholders to clarify reporting requirements and translate them into actionable analytical deliverables.
- Develop and maintain Power BI dashboards and reports to track key performance indicators and business metrics.
- Investigated data discrepancies and coordinated with relevant teams to resolve issues, enhancing data integrity.
- Developed analytical reports or dashboards that improved visibility into key business performance indicators.
- Improved reporting accuracy and reliability through data validation and quality checks.
- Delivered actionable insights that supported business planning and operational decision-making.
- Reduced manual reporting effort through process optimization or automation.
MIS Executive
Credence Resource Management
11.2021 - 03.2024
- Prepared daily, weekly, and monthly MIS reports to monitor debt collection performance, collection efficiency, and operational productivity.
- Consolidated and analyzed data on collection agents, recovery targets, payment performance, and outstanding accounts to provide actionable insights.
- Used Microsoft Excel functions, PivotTables, lookup formulas, and data validation techniques to generate accurate operational reports.
- Developed and maintained Power BI dashboards and visual reports to track key performance indicators (KPIs), collection trends, agent productivity, and target achievement, where applicable.
- Developed and maintained Power BI dashboards to track key performance indicators (KPIs) and collection trends.
- Monitored collection performance against targets, identifying gaps and trends to inform operational improvements.
- Automated and streamlined recurring reporting activities using Excel and other available reporting tools to improve efficiency and reduce manual effort.
- Performed data reconciliation and quality checks to identify discrepancies, duplicate records, and inconsistencies across reports.
- Automated and streamlined recurring reporting activities using Excel and other tools, enhancing accuracy and reducing manual effort.
- Ensured the accuracy, confidentiality, and timely delivery of operational reports in accordance with company procedures and applicable data-handling requirements.
- Key Achievements
- Improved the accuracy and consistency of MIS reports through structured data validation and reconciliation.
- Supported collection performance monitoring by providing timely reports on recovery trends, productivity, and target achievement.
Education
Bachelor of Computer Science (BCS) - Computer Science
Pune University
Pune, India05-2018
Skills
SQL optimization data analysis
Excel data reporting
Power BI: Interactive dashboards, data visualization, KPI reporting, data modeling, and report development
Data insight generation
Statistical reporting
Advanced Excel
Dashboard design
Structured Query Language
Data quality assurance
Relational databases
Data-driven decision making
Predictive analytics
Database querying optimization
Dimensional modeling
Data integration
Database administration
Agile methodologies
Analytical reporting
Business report generation
Data lineage tracking
Data storage solutions
Interests
Timeline
Data Analyst
Kiam Intl Pvt. Ltd.
08.2025 - Current
MIS Executive
Credence Resource Management
11.2021 - 03.2024
Bachelor of Computer Science (BCS) - Computer Science
Pune University
Exploring New Places on Bike
I enjoy exploring new places, wandering through nature reserves and forests, and visiting ancient temples to appreciate their history, architecture, and cultural significance.