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.)