Ashok Kumar Sharma Excel, Data Analytics, Power BI
No reviews yet

I am an Excel expert who specializes in helping individuals and organizations how to effectively use Microsoft Excel and complete assignments on time, a spreadsheet program used for organizing, analyzing, and presenting data.

I can also teach students, and working professionals on Excel.

I can also attend the organizational capacity-building seminars

I can develop automated dashboards in Excel as well as Power BI for organizations with online and offline data.

I can share my knowledge in a way to understand the logic behind the function I used so that the same function may be used in other datasets to analyse the data.

I will make the dashboards with SOPs so that the dashboard can be used easily by anyone who has access to it.

Subjects

  • Excel Beginner-Expert

  • Microsoft Power BI Beginner-Expert


Experience

  • M&E Officer (Dec, 2021Present) at John Snow India, New Delhi
    1. Develop and update data entry tools for the recording of data related to different assessments like data quality assessments and another component of the program.
    2. Develop National Immunization Dashboard (RI Coverage analytics, National Fact sheet, State-specific feedback, Graphs, Maps & Charts) on a monthly basis
    3. Develop RCH Dashboard based on Registration and RI coverage on a monthly basis
    4. Develop a presentation on key immunization indicators for National level officials
    5. Prepare & maintain immunization data repository (State / District) for the last several years based on reported and evaluated data
    6. Prepare new vaccine coverage data & analytics presentations on a monthly basis
    7. Development and maintenance of google sheets for smooth data collection of different programs / Campaigns like MI / IMI / JE / Covid-19 Vaccination.
    8. Update & maintain the database of State / District immunization officials
    9. Regular updating and providing support to the states for Coverage monitoring tool
    10. Prepare monthly report based on some key RI indicators
    11. Designing and revision of data collection formats and analysis tools using Excel Macro Programming.
    12. Compile COVID vaccination data on daily basis like Coverage, Vaccine Wastage, etc.
    13. Prepare COVID vaccination report for Health Minister’s Office & Prime Minister’s O office daily
    14. Liaise with states to validate all incoming data and to ensure correctness and completeness in data and summarized data analysis.
    15. Ensure weekly, monthly and annual deliverables related to data in the form of reports, presentations, feedback, etc. are prepared as per timelines.
    16. Provide support in the development of IT Tools like U-WIN
    17. Develop tools and strive to automatize data analysis processes at the national level for improved efficiency.
    18. Participate in state UIP Reviews to assess data quality and suggest improvement activities, data analysis of UIP Reviews.
    19. Any other official work assigned by the supervisor or senior management of ITSU aligned to organizational or unit objectives.
  • M&E Associate (Apr, 2019Nov, 2021) at John Snow India, New Delhi
    1. Preparing a national immunization Dashboard shared by MoHFW to the states every month.
    2. Preparing a national presentation on key RI indicators.
    3. Preparing the State dashboards for high-priority states with an analytical presentation shared with states by MoHFW every month.
    4. Capacity building of the state officials during state TOTs for various activities planned by the GOI.
    5. Participating in different studies and strategies for straightening routine immunization in the country.
    6. Developed the Immunization coverage monitoring tool which can be used at the National, State, and District level.
    7. Preparing google sheets for national, state, and district-level covid-19 reporting.
    8. Report the covid vaccination coverage to the MoHFW 4 times a day with other different requirements from the ministry.
    9. Preparing and sharing PMO and HFM reports daily.
    10. Preparing covid-19 immunization data as and when required by the supervisor/team lead.
    11. Calculating vaccine wastage of covid-19 immunization drive.
    12. To develop systems to monitor, compile and analyze Routine Immunization surveys, coverage, and monitoring data at District, State, and National levels.
    13. To develop systems to monitor, compile and analyze data related to UIP, AHS, and other surveys.
    14. To design and develop various application tools at National and sub-national levels.
    15. To assist in designing and revision of data collection formats and analysis tools using Excel Macro Programming and STATA to fasten the process for the M&E team.
    16. Liaise with states to validate all incoming data and to ensure timeliness, correctness, and completeness in data and summarized data analysis.
    17. Ensure timely preparation/compilation and dissemination of data, maps, indicators, presentations, reports, and bulletins related to immunization to meet the ongoing requirements of the ITSU Team and MoHFW.
    18. Ensure timely reporting of JE campaigns to MoHFW.
    19. Preparing reports and analytical presentations of new vaccines (Rotavirus and pneumococcal conjugate vaccine).
    20. Support supervisor/team lead in collating data from various sources including HMIS, RCH Portal, WHO/ NPSP Concurrent Monitoring, and others for preparation of Immunization Monthly Dashboards.
    21. Taking initiatives to develop different tools for ease of analysis of the data at the District/State or national level.
  • Administrative Assistant (Jul, 2009Mar, 2019) at World Health Organisation (WHO), Shahjahanpur
    1. To manage the entire unit including field monitors and external monitors in terms of administration and finance.
    2. To liaison with District Officials for different activities held in the district.
    3. Preparations of district-level meetings with data support.
    4. Preparation of technical part of the meeting and workshops at the district level.
    5. Refine and analysis of the data received from field units (Blocks and planning units)
    6. Develop & maintain a database of reporting networks Block-wise.
    7. Maintain records for AFP (Acute flaccid paralysis) cases sent for expert review, obtain hospitalization and other clinical records.
    8. Assist SMO in preparing documentation for obtaining and fixing up appointments for NCV / EMG.
    9. Collect and report all case details in Case Investigation Form (CIF).
    10. Provide administrative assistance to the SMO in the management of the program.
    12. Maintain accounts, cash book, and bank reconciliation, and assist in preparing reports as per the administrative and financial guidelines of NPSP.
    13. Coordinate incoming correspondence, information and data, travel, and general logistics arrangements.
    14. Maintain inventory of unit equipment and assets.
  • Field Monitor (Nov, 2005Jun, 2009) at World health organization WHO, Shahjahanpur
    1. To strengthen the Surveillance Network, the inclusion of new informers with the consultancy of surveillance Medical Officer.
    2. Micro planning and management of human resources at block level for better performance in Supplementary Immunization Activity Rounds.
    3. To get in touch with all the block officials of the health department e.g. Dy. CMO, MOIC, SDM, BDO, CDPO, etc. for better coordination.
    4. To help in Routine Immunization Activity, monitoring of Routine sessions.
    5. To collect data, micro- analyses of the same to improve the quality of work.
    6. To figure out the drawbacks and corrective actions from this data.
    7. Reporting the suggestions and analysis to block officials as well as SMO.

Education

  • Master of Public Health (Jul, 2016Jun, 2018) from Himalayan University, Itanagar, Arunachal Pradesh
  • Master of Social Work (Jul, 2012Jun, 2014) from SHIATS University, Allahabad
  • Bachelor of Science (Jul, 1993Jun, 1998) from Gandhi Faiz-e-Aam College, Shahjahanpur
  • Higher Secondary (Jul, 1991Jun, 1993) from SDBB Ram Inter College, Pilibhit
  • Secondary (Jul, 1989Jun, 1991) from Public Inter College Puranpur (Pilibhit)

Fee details

    1,0002,000/hour (US$11.7923.58/hour)

    Complexity of the work


Reviews

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