Swastik Tripathy

MIS Analyst

Bengaluru, India 4+ yrs exp 89 · Excellent

About

MIS and Reporting professional with 5+ years of experience in preparing daily, weekly, and monthly business reports, maintaining dashboards, and supporting internal teams with accurate, timely data. Proficient in Advanced Excel, SQL, and reporting tools, with a strong eye for data accuracy and consistency. Experienced in working with finance and operations teams, managing large datasets, automating recurring reports, and delivering insights that help teams make informed decisions. Immediate joiner.

Skills & Expertise (29)

Advanced Excel Advanced

8.1/10

Years Exp

Power Query Advanced

7.5/10

Years Exp

Data Reconciliation Advanced

7.0/10

Years Exp

Data Cleaning Advanced

7.0/10

Years Exp

Data Validation Advanced

7.0/10

Years Exp

Attention to Detail Advanced

7.0/10

Years Exp

stakeholder communication Advanced

7.0/10

Years Exp

KPI Reporting Intermediate

6.5/10

Years Exp

Power BI Intermediate

6.5/10

Years Exp

Tat management Cross-team coordination Finance Insurance Operations Services Aggregations Filters Joins Basic Queries Data Extraction Macros Excel Dashboards Index-match HLOOKUP VLOOKUP Pivot Tables Ad-hoc Reports Report Automation Business Reporting

Work Experience

MIS Analyst

UST International Pvt. Ltd.

Jan 2024 - May 2025

Prepared and maintained daily, weekly, and monthly MIS reports for internal business teams using Advanced Excel and reporting tools, ensuring timely and accurate data delivery. Tracked and reported KPIs across multiple business verticals, helping teams monitor performance and identify trends at a glance. Performed thorough data validation and quality checks on reports before distribution, improving data accuracy by 30% and reducing errors in stakeholder reports. Automated recurring MIS reports using Excel and Power Query, saving 3+ hours of manual effort per reporting cycle and improving consistency. Responded to ad-hoc reporting requests from business teams, delivering customised data extracts and summary reports within agreed turnaround times. Coordinated with cross-functional teams to understand reporting requirements and ensure reports were aligned with business needs.

MIS Analyst

AXA XL

Mar 2022 - Oct 2023

Managed end-to-end MIS reporting for operational and executive teams at a leading global insurance company, covering large datasets of 300K+ records. Prepared structured weekly and monthly performance reports, reducing manual reporting effort by 15 hours per week through process improvements and report standardisation. Automated Excel-based data preparation workflows using Power Query, cutting data preparation time by 75% and significantly reducing human error. Maintained data accuracy through regular reconciliation and validation checks, ensuring all reports met quality standards before distribution. Worked closely with finance and operations stakeholders to understand their reporting needs and deliver reports on time and in the right format.

Data Operations Analyst

Indecomm Global Services

Jul 2020 - Dec 2021

Generated daily and periodic MIS reports for customer and financial data, supporting management with regular performance updates. Developed and maintained standardised reporting templates that improved consistency across teams and reduced time spent on report preparation. Ensured data integrity through regular data validation and reconciliation, flagging discrepancies and following up for resolution. Supported business teams with data insights and summaries, helping them identify trends in customer behaviour and operational performance. Maintained and updated databases and trackers regularly, ensuring data was always current and readily available for reporting.