Yadav Sanket

MIS Analyst

Dhayari, PUNE, Maharashtra, 411041 2+ yrs exp 84 · Excellent

About

MIS Analyst with 4+ years of experience in MIS reporting, workforce analytics, reconciliation, operations reporting, and data management. Experienced in preparing daily, weekly, and monthly MIS reports, attrition and shrinkage analysis, dashboard management, data consolidation, stakeholder reporting, and advanced Excel-based reporting. Proficient in Excel, Power Query, Power BI, and data analysis with a strong focus on accuracy, reporting efficiency, and business decision support.

Skills & Expertise (14)

Advanced MS Excel Advanced

8.0/10

Years Exp

Pivot Tables Advanced

8.0/10

Years Exp

Data Analysis Intermediate

7.6/10

Years Exp

XLOOKUP Intermediate

7.4/10

Years Exp

VLOOKUP Intermediate

7.4/10

Years Exp

Power Query Intermediate

7.4/10

Years Exp

Data Management Intermediate

7.0/10

Years Exp

Power BI Intermediate

6.8/10

Years Exp

Tally ERP Intermediate

5.0/10

Years Exp

Attrition Analysis Workforce Analytics MIS Operations Data Consolidation Stakeholder Reporting

Work Experience

Senior Associate | MIS Analyst

Atos Syntel

Aug 2022 - Apr 2024

Prepare and publish daily, weekly, and monthly MIS reports related to attendance, headcount, attrition, shrinkage, productivity, and workforce metrics. Analyze attrition and shrinkage trends across teams and provide actionable insights to management. Create and maintain operational dashboards for leadership review and business decision-making. Consolidate data from multiple sources and ensure accuracy, consistency, and data integrity in reports. Coordinate with internal stakeholders for data collection, validation, and reporting requirements. Automate reports using Advanced Excel, Power Query, Pivot Tables, XLOOKUP, and reporting tools to improve efficiency. Generate workforce planning and forecasting reports using historical trends and operational data. Prepare management presentations and ad-hoc MIS reports for internal and external stakeholders. Support audit requirements by maintaining accurate reporting records and documentation. Ensure confidentiality and security of business and employee-related data.

Associate | Transaction Processing Team

Atos Syntel

Nov 2020 - Jun 2021

Processed fee setup, maintenance, postings, and reversals for client accounts within defined timelines, ensuring accurate and timely billing. Calculated and validated portfolio fees using market data and client inputs, supporting correct billing and revenue recognition. Managed data entry and updates in G+ application, maintaining accuracy and compliance with process requirements. Supported account setup and configuration based on client-specific requirements, enabling smooth onboarding for new accounts. Performed data verification and quality checks to reduce transaction errors and improve data integrity. Reviewed and validated portfolio fees and related records to ensure correct reconciliation outcomes. Prepared journal entries and reconciliations for GL and sub-ledger accounts, resolving discrepancies for reliable financial reporting. Generated monthly reconciliations, invoices, and MIS reports with variance analysis and break-reasoning notes. Conducted control checks to minimize billing errors and improve reconciliation quality.

Junior Accountant

CA Vaibhav Moholkar and Associate

Jan 2020 - Jan 2020

Used Tally ERP for bookkeeping, invoicing, and bank reconciliations, resolving breaks and mismatches. Reconciled bank statements with Tally entries, investigated cash breaks, and adjusted entries as needed. Prepared journal entries, supported month‑end closing, and assisted in bank audits by verifying balances and reconciliations.