Ajaybabu

Project -

Project Name              : DMRO and One view Dashboard

Client                          : UHC (Dec 2012 – Aug 2015)

Technology      : VBA, Excel, SQL and Access

Team size                   : 3

Role                 : Developer

Project Description:

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

Responsibilities:

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