Kishor Singh

Experience

• 

  ICARE Eye Hospital

  May 2013 - Sept 2024

  1. MIS Reporting & workflow assessment 2. Daily dashboard management 3. Practical experience in handling various data and reporting 4. Generate MIS report on daily and monthly basis, analyzing the cases study in excel sheet with dashboard, pivot table, power pivot 5. Prepare reports on excel using different reporting tools and formulas (VLOOKUP, Xlookup, DGET, IF, OR, AND, Index, Index Match, Pivot table and chart) •Make all kinds of bills (OPD and IPD) through TCS and Lekhi HMIS software • Resolve customers' service or billing complaints • Solve the patient’s problem and explain the process • Accesses and update the medical records of patient • Analyze problems and discover the best ways to solve them. • Practical experience of case summary, medical certificate and all other necessary certificates• Daily MIS reporting 1. Type all reports (case summary, medical & other certificate)2. Update data on ERM (HMIS) 3. Sent report to manager on daily basis4. daily MIS report5. feedback report on monthly basis

  • Executive Front Office

    Oct 2021 - Sept 2024

  • Assistant Billing

    Oct 2016 - Sept 2021

  • Data Entry Operator

    May 2013 - Sept 2016
• 

  Samsung Electronics

  Oct 2024 - now

  Senior Executive (Reporting & Data Analysis)

  Key Responsibilities:-Data Extraction and ETL Processes> Extract data from SAP and other software systems.> Perform ETL operations to cleanse, transform, and prepare data for analysis and reporting.Dynamic Dashboard Creation>Develop and maintain interactive dashboards in Excel to visualize key performance indicators (KPIs) and trends.>Implement automation in dashboards to update data dynamically for recurring reporting needs.Report Generation> Produce accurate and timely daily, weekly, 15-day, and monthly reports to support management decisions.>Use Excel formulas, charts, and Pivot Tables to present data comprehensively.Data Analysis and Insights> Analyze large datasets to identify patterns, trends, and actionable insights.> Communicate findings clearly through dashboards and reports.Excel Automation and Advanced Functionality> Leverage advanced Excel functions, such as VLOOKUP, INDEX-MATCH, Power Query to optimize reporting workflows.Quality Assurance and Validation> Ensure the integrity and accuracy of data by conducting thorough quality checks.> Troubleshoot discrepancies and errors in data and reports promptly.Ad-Hoc Reporting and Support> Create ad-hoc reports and dashboards to meet specific business requirements.> Adapt to changing business needs by updating templates, dashboards, and processes. Show less