SQL Server Custom Report

The estimated reading time for this post is 0 minutes

uobUOB Centre of Excellence Sdn. Bhd. is establish and operate an Business Process Outsourcing (BPO) center rendering in Back end operations support for the UOB Group’s financial services and products andContact centre supporting the UOB Group’s inbound services. The main challenges for auditors were having custom and accurate reports from the Verex Access Control System for further investigations.

 

Key Points:

  • All reports are dynamic based on custom queries and functions.
  • The reports can be generated from Microsoft Excel for more flexibility.
  • Additional feature such as user data modification tracking has been added.
  • The report generation process takes less than 3 seconds.
  • The reports are about Authority Groups, Area, Schedule, Users, Logs, Events and Activity.

 

 

Hamid J. Fard

I am SQL Server Data Platform Expert with more than 9 years’ of professional experience, I am currently Microsoft Certified Master: SQL Server 2008, Microsoft Certified Solutions Master: Charter-Data Platform, Microsoft Data Platform MVP and CIW Database Design Specialist. I also do Pig, Hive and Sqoop development regarding Hadoop Big Data platform. After a few years of being a production database administrator I jumped into the role of Data Platform Expert. Being a consultant allows me to work directly with customers to help solve questions regarding database issues for SQL Server.

More Posts

Follow Me:
FacebookLinkedIn