Junaid Alam Data Analysis in Excel, Data Management, M&E
No reviews yet

I want to do as a freelance for any type of data work in Excel like data analysis, data typing, pdf to Excel conversion, chart preparation in excel, numric value entry in excel,
I have approx 12 years experience in data management and doucmentation work. specially in excel using like pivot table, data cleaning for analysis and dashboard preparation.
A competent professional with MBA in Human Resource Management with nearly 12 years of work experience in the fields of MIS, Monitoring & Evaluation, Data Management, Data Analysis, Documentation, Employee Relations, Welfare, and General Administration in the Health, Education and Development sectors.

Subjects

  • Excel (Advanced) Beginner-Expert

  • Excel & Research Data Analysis Beginner-Intermediate


Experience

  • MIS- Associate (Oct, 2020Present) at UNFPA, Patna
    • Provide technical and management support to the M&E Officer in close coordination with UNFPA in the development of MIS, Monitoring Activities, Broad Indicators, Reports Documentation, and Recording Formats.
    • Work with agencies/ systems developers to develop the MIS architecture for the project, including technological requirements of Mobile applications and web-based platforms.
    • Ensure Collection, Collation, and compiling data in the required paper-based format, google sheet, and mobile applications on a day-to-day basis for the smooth running of MIS functions.
    • Support uses of Mobile applications by trainer/facilitator/regional coordinator through online/offline training
    • Provide technical support to 205 field-level trainers on mobile application troubleshooting issues.
    • Support the system developer/agency and the implementing partner in designing and develop the dashboards, including mobile applications and web-based platforms.
    • Supervise functions of the MIS unit, and MIS portal and strengthen MIS systems for the project.
    • Manage and Analyze evidence-based MIS data collected and collated through the web, google sheet, and paper formats.
    • Monitor data quality (timely, completely, correctly) in preparation of periodic and annual reports.
    • Provide analyzed and verified data to M&E officer on monthly/Quarterly.
    • Ensure that all documents, Google Sheets, and reports every month received from regional coordinators are properly classified, filed, and stored in Google Drive.
    • Support in designing and providing oversight to MIS capacity-building mechanisms at the level of Regional Resource Centers.
    • Support & develop ppt slides and short videos of different activities and share them with the M&E Officer.
    • Prepare attendance sheet and agenda for Quarterly meeting of regional coordinators.
    • Arrange logistic support for Quarterly meetings of regional coordinators.
    • Prepare feedback on the progress reports & case studies received from the Regional Resource Centers.
    • Monitor of recording/ reporting system/ maintenance of registrars by Regional Resource Centers through field visits and submit visit notes.
    • Review and analyze web-based dashboards and comparison from monthly reports received through offline data.
    • Analyze physical progress reports and recommend measures for improving program performance.
    • Undertake field visits as and when required to assess the progress of the program implementation. Ensure data accuracy to paper-based records and sustainability of activity done by mobile application by different levels of users (like – Class teacher, Trainer, Principal & Facilitator)
  • Executive – MIS/HR (Feb, 2017Feb, 2020) at Pragati Development Consulting Services Ltd. (PDCSL)
    • Instrumental in operational & MIS management.
    • Contract management of approx. 500 consultants.
    • Ensure monitoring and control system for consultants’ attendance.
    • Provide monthly staffing reports.
    • Manage and coordinate all HR related activities including recruitment, selection, insurance, capacity building, staff administration etc.
    • Maintain a database of candidates & Maintain personnel files of all recruited consultants.
    • Provided hand holding support to field staff at the time of report collection and honorarium payments.
  • Sr. MIS Associate (May, 2013Jan, 2017) at Population Services International (PSI)
    • To Maintain DHIS Software on a daily basis as needed with the support of field MIS Staff. Daily Entry Tracking and management of Lead Generation & Sales Data by the Sales Officer entered in the DHIS Android app. Report Generation, analysis, and Chart in DHIS preparation monthly.
    • To Maintain and update the MIS Data and documentation and analyze it in 3SI Project & Packard Programme.
    • Data analysis, invoicing, incentive payment of Paramedic Staff &Providers Payment in Packard Programme.
    • Manage an IT-enabled MIS and generate relevant reports for monitoring impact including supervision of data entry, cross-checking of data, and validation.
    • Maintain BioMatrix details of Front Office Staff and deliver reports on per monthly basis.
    • Ensure and strengthen adequate filing methods.
    • Data Compilation, Data Cleaning, checking duplicate entries, Error correction, Consolidation& Analyzing.
    • Deliver data products in report/presentation format, or verbally to the specific requirements and timelines.
    • Collection of Data in soft /hard format received from the field offices. Compilation and analysis of data. Collated and worked on online Data Entry Work for daily reporting compliance & their solutions.
    • Successfully looked after the overall data entry system, online MIS Entry, Report generation, Analysis, and Feedback.
    • Efficiently handled the overall Data Compilation, Consolidation & analysis, and documentation of Data in soft /hard format received from the field offices.
    • Regularly verifying data to maintain accuracy and correct information. Follow up with district MIS staff to maintain accuracy and support them if they find any discrepancies.
    • Supporting supervisor for various data analysis……
    • Preparing District Analysis reports on a monthly basis for 3 districts (Begusarai, Patna &Samastipur)
    • 1. SO/SR Performance. 2. Enterprises’ Performance. 3. Business Economics Status, 4. Toilet Construction Status. 5. Franchisee P&L Statement.
    • Supporting supervisor in preparing monthly dashboards.
    • I have been dedicated to resolving any issue related to IT on time and also taking the required Outlook backups on time. Supported district staff (AM-BD, MIS Associates., Sanitation Coordinators, and sales staff for any IT-related issues with Laptops/Tablets.
    • I have taken responsibilities assigned the task to me and have performed all my duties with complete ownership of responsibility be it MIS preparation or IT issue resolution.
    • Support Administration & Stock maintenance (Prepare Laptop, Data Card allocation slip, Inventory numbering in all assets)

Education

  • MBA (Apr, 2012May, 2014) from PUNJAB TECHNICAL UNIVERSITY, Kapurthala
  • BBA (Apr, 2008Jun, 2011) from ALAGAPPA UNIVERSITY KARAIKUDI

Fee details

    8001,000/hour (US$9.3611.70/hour)


Reviews

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