Manish Mistry

Data Analyst with 5+ years of experience in MIS reporting, data analysis, and business insights across the insurance and operations sectors. Skilled in SQL, Advanced Excel, and Power BI for data extraction, transformation, and visualization. Proven track record of identifying data discrepancies, optimizing reporting workflows, and delivering insights that support data-driven decision-making.

MIS Executive at Clarion Insurance Broking Services Pvt. Ltd. (2021-05 – 2026-01)

• Extracted and analysed insurance data from multiple sources to identify discrepancies and inconsistencies, ensuring data integrity across reports.
• Performed 10000+ records premium comparison analysis between internal systems and insurance companies, flagging pricing mismatches for review.
• Identified and resolved 20% discrepancies across multiple policy categories by coordinating with backend and operations teams.
• Monitored pay-in and payout margins across 500+ policies monthly, detecting discrepancies above the 5% threshold and improving financial accuracy by reducing unresolved variances by 30%.
• Analysed 21+ Insurance companies and internal monthly business performance and revenue trends, delivering actionable reports to management for strategic decisions.
• Prepared regular reports on missing policies, data gaps, and system errors, reducing data quality issues over time.
• Automated monthly and quarterly MIS reporting workflows using Excel macros and advanced formulas, reducing manual effort by ~40% and cutting turnaround time from 3 hours to under 1 Hours.
• Managed and handle ~3 lakh + records datasets from insurance sources and internal systems, ensuring proper formatting and accuracy.

MIS Executive at Outreach Infotech Pvt. Ltd. (2020-11 – 2021-05)

• Generated daily, weekly, and monthly sales and delivery reports for management tracking.
• Built performance dashboardsto provide visibility into key business metrics and operational efficiency.
• Analysed order vs delivery gaps and reported findings to operations teams to improve fulfilment rates.

MIS Executive at Karvy Digikonnect (2017-10 – 2020-08)

• Developed and maintained MIS reports for agent performance tracking and operational analysis.
• Monitored agent-level performance metrics and flagged underperformance to team leads.
• Collaborated with operations teams to provide data support for business decisions.
• Maintained structured datasets and ensured data consistency across reporting periods.

Bachelor of Arts in General Studies – Indira Gandhi National Open University (IGNOU) (2018 – 2022)