Suraj Chourasia

MIS and Data Analyst

L&T Technology Services • Freelance

Mar 2018 - Mar 2025 • 7 yrs

Data Analyst & MIS – MS Excel Specialist I worked as a Data Analyst & MIS professional, specializing in "MS Excel, data management, reporting, analysis, and dashboard development". My key responsibilities included: * Collecting, organizing, cleaning, and maintaining large volumes of business data. * Preparing **daily, weekly, and monthly MIS reports** for management and different departments. * Creating **interactive Excel dashboards** to track KPIs, sales, performance, productivity, and business trends. * Using advanced **MS Excel formulas and functions** such as XLOOKUP, VLOOKUP, INDEX-MATCH, SUMIFS, COUNTIFS, IF, IFERROR, and other analytical formulas. * Performing **data cleaning, formatting, sorting, filtering, merging, splitting, and validation**. * Analyzing data to identify trends, discrepancies, performance gaps, and important business insights. * Preparing **management reports and automated reporting templates** to reduce manual work and save time. * Creating Pivot Tables, Pivot Charts, Slicers, Charts, and interactive reporting sheets. * Consolidating data from multiple Excel files/sheets into a single structured report. * Maintaining accurate and up-to-date databases and MIS records. * Converting raw and unstructured data into **clean, organized, and easy-to-understand reports**. * Checking data accuracy and resolving inconsistencies or duplicate records. * Working closely with management and other teams to understand reporting requirements and deliver customized Excel reports. This experience helped me develop strong expertise in **MS Excel, Data Analysis, MIS Reporting, Dashboard Creation, Data Cleaning, and Business Reporting**.