Offshoring ETL Development in EPM projects

Offshoring ETL Development in EPM projects

1. Introduction

A significant portion of the total effort in EPM (Enterprise Performance Management) projects is concentrated on data acquisition with significant trends in recent times to offshore the development and testing.

2. Subject Clarity

Around 70 % or more of the total effort in PeopleSoft EPM projects is concentrated on data acquisition. A significant trend in recent times is to offshore the development and testing of ETL mappings. ETL (Extract, Transform, and Load) development projects place a particular emphasis on quick turnaround, optimal performance and iterative development. For most EPM initiatives, the data integration effort is always identified as being of key importance. Hence it becomes extremely important that this part executes smoothly and with utmost efficiency, coordination and cost effectiveness.

3. Problem Definition Re-Statement

KNOW-HOW
Most shortcomings in EPM projects arise from the lack of understanding of the end-users experience in the handling of application and data. Better insight into data usage and query performance can lead to faster resolution of performance bottlenecks, significant improvements in service levels and productivity, and reduced data management costs.

COST
The cost savings aspect of offshore sourcing can be irresistible, especially with pressure coming from the top management of the organization to do more with less. This requires the optimum balance of effort between onsite and offshore resources without compromising on the seamlessness of delivery and the quality.

OFFSHORE PERFORMANCE
As companies continue to rely on outsourcing and off-shoring services to third party vendors, managing and monitoring the performance of these vendors and outsourced projects is becoming a top priority. Outsourced services promise a myriad of benefits--cost savings, improved service levels, and extended knowledge base. However in order to achieve these benefits, companies need to monitor their outsourcing vendors and projects to ensure successful relationships and services.

RIGHT-SHORING – Having the ‘Right’ mix
The right mix of offsite and offshore effort delivers high quality results while mitigating risk. The first step is to establish asound development methodology and risk mitigation strategy.

4. Offshoring Challenges

Challenges at Offshore include:

Aggregating data coming from a large number of different sources.
Proper understanding of the end users requirements
Handling Unreasonable timelines
Coordination with Onsite team

Download

Download full paper At
http://www.enjineer.com/forum