Shekhar Kumar

• Assisted senior leadership teams in gathering and evaluating MIS data, aiding ongoing performance analysis.
• Handled end-to-end daily transaction reconciliation, mismatch identification, and reporting using MS Excel, ensuring accurate financial and operational data.
• Produced monthly Management Information reports, clearly illustrating data trends to identify growth opportunities.
• Observed the MIS function, performing regular maintenance to ensure optimal performance levels.
• Examined and applied strategic solutions using new technologies to drive process automation and improve the organization’s service delivery.
• Used specialized software to track issues' registration, processing, and resolution to improve operational productivity.
• Determined and managed operational risks, mitigating impacts on business operations and continuity.

• Maintaining the website through updated information.
• Using advanced Excel to perform suitable actions.
• Updating the stock level accordingly.
• Administered physical and digital filing systems, keeping records well-organized and easily retrievable for the team.

PROJECTS

1: High Cloud Airlines.

Project Role: Doing modeling for creating visualizations. Teamsize-7

Project Duration: 3 months.

Project detail: Airlines Analysis.

Understanding the datasets and KPIs.

Data manipulation by using VLOOKUP, formatting, and PivotTables in Excel.

Data manipulations using MySQL (joining two tables).

Prepared the visualization and created a dashboard on different KPIs by using Tableau and Power BI.

2: Domain: Healthcare

Project Name: Dialysis of Patients.

Duration: 3 months.

No. Of People - 7.

Project Details.

Dealing with a large set of datasets.

Understanding the dataset's various KPIs.

Implementation of KPIs using Excel and MySQL.

Implementation of KPIs using Tableau (creating visualizations and dashboards) and implementation of KPIs using Power BI.

Final presentation of the projects.