Experience 6.9 Years in Data Managment/ MS OFFICE (word, Excel)
MS Excel: Using advanced formulas like, Match , Index, Index + Match formula, User define function formulas, Pivot Table, Power Query, Power BI, VLookup, Fuzzy look up, HLookup, 2D Vlookup, Sumifs, Countif, Flash fill, Text to Columns and MIS Report in different ways, Consolidated sheets in advanced ways using some advanced formulas, Advance sorting and Filtering Data, Basic usage of VBA Macros using developer TAB,
MS Word: Urdu and English Typing, Typing Speed 40 wpm, Using Excel formulas in Ms Word, Mail Merging, Usage of Hyperlink in advanced way, Using Page layout in advanced way, Paper typing with pictures and graphics using in MS word 2013, 2016, 2019 and other some advanced feature can use in Ms Word.
Data Analyzing: Using analyzing software and manual analyzing in excel with advance filtering, sorting, Power query, VBA macros and Pivot table.
Accounts Work:ÃÂ Can Properly Operate Accounts Software, Bank Reconciliation, Monthly Expenditure Report BPV, JVS, BRV and Stocks maintaining.
Consolidate the daily nutrition data from the field staff and enter into NIS for weekly reporting. Maintain Files and Office Administration Record. Documentation of Reports. Manage the Stock record in Hard and Soft Copy. Establish relative databases and analytical templates for other data entry, summary, and presentation. Check the quality of the data to be entered and inform the immediate supervisor of any problems. Manage all aspects of the Nutrition Information System (NIS) (critical functions and issues include format designing, scheduling and frequency of reporting) and random tracking of children on treatment and those who completed the treatment. Support the collection and review NIS and health related information (DHIS), identifying potential gaps and inconsistencies, through supportive supervision to field teams and regularly data review and feedback meetings with nutrition sites/health facility/district staff. Closely collaborate with supervise the field staff collecting nutrition and health related data and coach on the process of collection and analysis of health and nutrition related data. Providing feedback to the 1st line supervisor and technical supervisor in issues related to the discrepancy in data. Develop standard reports and documents based on NIS data from the nutrition sites and district. To supervise and monitor the recording of NIS data nutrition sites/district. Follow up with nutrition sites/district and generate reports on nutrition and medical supplies for re-ordering. Close coordination with DNC at district and Manager (NIS) at head office for updates of Nutrition project.
Any other tasks as assigned by Supervisor / Technical Supervisor.
Data Entry, Manage Payroll of All Staff. Petty cash Handling, Manage Store Stock record and fixed asset record. Daily Donation Record, Bank Reconciliation, Monthly Expense report, Manage Balance Sheet, Documentation and filing of all records and other administration Work.
Manage HR Record, Student Data entry on Web Portal, Fee Record, Documentation of All Records, Manage Record in Hard and Soft Copy, Staff Payroll and Daily Petty cash Handling, Reconciliation of Bank Statement and Account Ledger, Entries of Daily Vouchers, Payment and receipt voucher and journal vouchers.
Data Entry On Web Portal, Documentation of All Records, Working on MS Excel