The recession is here…
And the cost cutting season has begun. We know the drill: across the board budget cuts, new projects delayed, the organization chart de-layered, voluntary retirement packages and, of course, reduction in force and severance packages.
This is not just an exercise in reigning in escalating costs. The more agile organizations also take such opportunities to align their corporate workforce to the new realities of their business and acquire new employees with the skills that are more suited to their core competencies and evolving business focus.
This brings into focus the need to retrieve and analyze information about employee performance, learning, compensation, benefits, payroll, time management, and recruiting. As with most modules, there are plenty of pre-built HR Analytic applications like Oracle Daily Hr Intelligence, Oracle BI Applications (Siebel Analytics) – HR Analytic module, Cognos Performance Applications, Business Objects HR Analytic Application, to name the leading few. However, more often than not, you will find that these applications work very well if you haven’t customized your HR application (be it Oracle HRMS or SAP R/3 HR module). They will lack some of the most critical information of your business that you have carefully stored in the customizations of the ERP application as I am experiencing while analyzing an Oracle HRMS implementation at one of my clients. After careful evaluation and cost-benefit analyses, we decided to build a custom data mart, rather than buying a pre-built BI application from Oracle or BO. I will focus this series on building the HR data mart from Oracle eBusiness Suite, based on this recent experience.
Building a HR data mart is considerably more difficult than building other common data marts like a Sales data mart or Finance data mart.