Candidate with Experience in MIS Automation& Reporting analysis with VBA Macros, SQL server, MS Access & Advanced Excel.
Required Skills set:
Individually developing VBA automated reports/dashboards & Macros using MS Office tools like MS excel, Access & Word
Strong knowledge in VBA, SQL, MS office , especially MS Excel [Hyper link, Pivot table, macros, Excel formulas and pivot chart], VBA, Power Point Presentation.
Data Base managing using MS Access, SQL server to store and extract Historical data as per the present and Adhoc requirements
Experience in Creating Templates, User forms for collection of Data from the Circles all over India which should be directly get updated in the Server data base (Access , SQL)
Creating MIS/ Dashboard report and presentations
Design reporting formats to provide accurate information in a clear and concise manner
Expertise in presenting the reports in various formats by using Microsoft Office Suite (Excel, Word, PowerPoint & Access
Develop and apply cross-checks and other types of testing methods to assure accuracy in data processing operations
Automating the Regular reports.
Produce and support existing reports and processes
Documentation of Automated reports procedure.
Should be strong in communication.