Alok Kannoujia Advance excel ( MIS)
No reviews yet

I have 5 years of experience in Advanced Excel, with a strong command over both basic and advanced Excel functionalities. Over the years, I have developed a deep understanding of Excel’s various tools and features, such as formulas, VLOOKUP, pivot tables, macros, data analysis, charts, and dashboards. I am skilled in using Excel to automate tasks, manage large datasets, and generate reports that offer valuable insights for business decision-making.

Currently, I am working as an MIS Professional at a delivery company, where I am responsible for handling critical data related to operations, including the performance metrics and payouts of 600+ riders. In this role, I use Excel to generate detailed reports, perform data analysis, and provide insights that help management optimize processes and improve operational efficiency. I work closely with different departments to ensure that data-driven decisions are made based on accurate and timely information.

Key skills and areas of expertise include:

Advanced proficiency in Excel functions such as SUMIFS, INDEX/MATCH, and Array Formulas.
Creation of dynamic dashboards for real-time data tracking and decision-making.
Data visualization techniques, including the use of charts and graphs.
Data cleansing and transformation using Excel’s powerful tools to ensure data accuracy and consistency.
Expertise in report generation that provides insights into business performance, highlighting trends and areas for improvement.
Working with large volumes of data, performing complex analysis, and offering strategic recommendations.

Subjects

  • MIS (Management information system) Beginner-Intermediate

  • Data cleaning, visualisation, validation, mining and analysis Beginner-Expert

  • Excel (Advanced) Intermediate-Expert

Experience

  • MIS (Jul, 2023–Present) at Fresh To home food Pvt Ltd.
    In my current role as an MIS Professional, I am responsible for reporting and analysis of multiple key performance indicators (KPIs) related to the performance and payouts of 600+ riders. I work closely with the management team to generate comprehensive reports that provide actionable insights from the company’s data.

    Key Responsibilities:

    Manage and analyze the rider payout system, ensuring accurate calculation based on multiple parameters.
    Generate detailed reports that offer insights into rider performance, payout trends, and operational efficiency.
    Collaborate with management to provide data-driven recommendations for improving processes and decision-making.
    Utilize advanced Excel and reporting tools to automate data analysis and streamline reporting tasks.

Education

  • B.com (Jul, 2019–Aug, 2022) from Veer Bhadur Singh Purvanchal university

Fee details

    ₹300–800/hour (US$3.47–9.26/hour)

Reviews

No reviews yet. Be the first one to review this tutor.