Job Responsibilities:-
• Responsibility for maintain MIS and create report on daily basis.

Make Flow chart monitoring sheets (FMS) and Project Monitoring sheets (PMS) on Google sheets.

Manage Multiple Google FMS Sheet, IMS Sheet, PMS Sheet

Depth knowledge of advance functions like - Pivot table, Array, Query, V-lookup , H-lookup, Mail merge, import range other advance functions in Excel and Google sheets. Google forms and dashboard.
• Maintain Google Sheets, Stock audit reports, Procurements report, Variance Analysis, Target Achievement reports, charts and presentation as required by the Directors.
• Automation of the all reports or daily work of operations to make it easier and smooth for team.
• Ability to think differently and incorporate suitable changes on existing reports.
• Ability to convert raw data in to statistical data which can be presented to the higher management
• Ability to plan and organize when faced with multiple tasks
• Create monthly, weekly and daily reports from various databases
• Analyze data to ensure correctness of reports created.
• Handle the Database on SQL & provide data to client.
• Automation report vba/macro writing on daily bases
• Daily MIS floating and coordination concern department.

Key Skills :-
• Google Sheets, Forms, Dashboard and Integration of google sheets with external dabases like Oracle, MySQL. Also understanding of PL/SQL.
• Advanced Excel (VLOOOKUP,HLOOKUP, INDEX,MATCH,PIVOT TABLE ,SUMMIF, COUNTIF,ROUNDUP, ROUND, ROUNDOWN,PROPER, TRIM,CONCATNENATE,CHART, CONDITIONAL FORMATING,MAIL MERGE ,etc