Project Name : DMRO and One view Dashboard
Client : UHC (Dec 2012 – Aug 2015)
Technology : VBA, Excel, SQL and Access
Team size : 3
Role : Developer
DMRO is the span of 12 teams. and the Dashboard provides the all the teams data in one view Like production data, quality data , Net utilization..etc..
● Created and provided User form to enter data.
● Developed MS Excel applications using Excel user form for the front end and Access Database in the back end.
● Created Tables in Access database to maintain the data
● Developed MS Excel User form to get the data from Access Database
● Writing or Inserting SQL queries in VBA code to export data from Databases like MS Access etc…
● Developed Multiple Macro tools to automate the reports and process.
● Analyze problems and discover the best ways to solve them
● Developed and implemented strategies to achieve organizational goals.
● Communicating to supervisors and provide the analyze data and explained inputs to developing the Macro tools.
● Creating user forms, tables in Access database and pull and retrieve the data from databases like SQL server and Access etc…
● Supported and completed various projects, automation and standardization efforts.
● Provide the required information, reports and schedules to the auditors.