Shubham Ranjan

MIS Analyst and Data Analyst with 4.5 years of professional experience in MIS reporting, data analysis, dashboard development, KPI monitoring, data validation, reporting automation, and business intelligence. Strong hands-on experience with Advanced Excel, Power BI, SQL, Power Query, DAX, MongoDB and Python. Experienced in preparing management reports, developing dashboards, analyzing business performance, maintaining data accuracy, automating reporting processes, and converting complex datasets into actionable business insights.

Strong ability to work with cross-functional stakeholders and deliver accurate, timely, and business-focused reporting solutions. Experienced in reporting governance, reporting controls, data integrity, and reporting process improvement.

Business Operations - The Sacred Triangles - Muzaffarpur, Bihar

(2025-08)

• Analyze sales, customer, order, inventory, and product-performance data to support business decisions.
• Build and maintain Excel/Google Sheets-based reporting for sales, inventory, pricing, and operational tracking.
• Monitor business KPIs and performance trends to support product selection, pricing, and customer engagement decisions.
• Manage data-driven business operations across e-commerce, customer orders, product catalog, and inventory.
• Apply analytical and problem-solving skills to improve day-to-day business processes and support data-driven decision-making.

Data Analyst - InsuredMine - Bengaluru

(2023-03 - 2025-07)

• Monitored business and product KPIs for fintech clients using Power BI, SQL, and MongoDB to support management reporting and business decision-making.
• Designed, enhanced, and maintained automated Power BI dashboards and executive reporting, reducing manual reporting effort by approximately 30%.
• Built master datasets integrating data from 100+ agencies and 15 AMS platforms for standardized reporting and analysis.
• Performed data extraction, validation, reconciliation, data cleaning, and quality checks to ensure data integrity, reporting accuracy, and reporting controls.
• Implemented ELT processes using Python and SQL for data standardization and reporting requirements.
• Developed dashboards and analytical reports to monitor business performance, trends, and operational metrics.
• Performed trend analysis and predictive analytics to identify business patterns and support strategic decisions.
• Collaborated with product and business stakeholders to understand reporting requirements, perform UAT for reporting changes and dashboard enhancements, and deliver actionable analytical solutions.

Associate - CPG BPM Services Pvt. Ltd.

(2021-12 - 2023-02)

• Prepared MIS dashboards and analytical reports using Excel and SQL for management review.
• Performed data validation, quality checks, and business analysis to ensure reporting accuracy.
• Supported recurring management reporting and business analysis activities.
• Extracted and analyzed data using SQL to prepare reporting outputs and business insights.
• Created dashboards and summary reports for operational tracking and supported business teams with regular data updates and reporting requirements.

Bachelor of Technology - Computer Science - Maulana Abul Kalam Azad University of Technology, West Bengal