Role/ Responsibilities:
? Automation of the reports using VBA, MS Access, MS SQL Server
? Creating Automation projects to help different processes.
? Creating and modifying Management Dashboards
? Knowledge of DAO/ADO connectivity from Excel to Access or SQL.
? Creating Relational Tables, Querying, Sub Query, Grouping, Sorting, Joins in MS Access and SQL
? Outlook Automation using VBA
? Creating Triggers, Store Procedures, Views and enforcing Data Integrity in SQL
? Working Knowledge of Tableau