Saravanan Viswanathan is currently the Head-Internal Systems and Technology at Hexaware Technologies. With more than 26 years of experience in the industry, he has previously worked at Ramco Systems and Blue Star Limited. He works on multiple technologies such as Peoplesoft, Microsoft technologies and other mobile technologies supporting various IT initiatives of the organization.
Hexaware Technologies built a project around centralized datamart and organization-wide dashboards. The objective was to build an exhaustive datamart to bring all the relevant metrics of the organization from different OLTP systems and using this to build multiple dashboards / reports to the user groups.
Each user will have access to a unique set of dashboards/reports based on their role and scope of their role within the organization. These are available on desktops, tablets, and mobiles in a near real-time accuracy. This was implemented with the latest technology and tools of BI on Cloud with graphical views, context-sensitive data, drill down reports and natural language queries.
The clarity on the end deliverables helped in defining the various data items to be culled out of various OLTP systems into the Datamart. This definition, synchronization and normalization of it across the systems was the prime challenge. Based on the role, the metrics roll up to the relevant users and detailed level of drilldown is made available to the user through a single window.
The cloud-based solution ensured more availability and better performance. The project improved the accessibility and quality of various metrics in the organization. This also enabled evolution of new metrics or new processes of managing the business based on the multi-dimensional analysis that was made available.