Emerio - Data Warehouse Management and Support

Finance Information Management is a separate repository that stores data from heterogeneous source systems. The repository is then used for management reporting and end-user reporting.
Production support, deep technical support, production fixes, enhancements and new module development
Global support from Singapore followed by offshore to Chennai, India
24x7 support
SLA based delivery

Challenge		Our delivery approach

Multi-vendor Data warehousing technologies (legacy and new generation technologies)		Built a multi skilled team of resources by tapping into Emerio's resource pool
Global user base (North America, Europe and Asia Pacific)		Established a flexible operational model to address the needs of the users across various time zones
Semi-automatic data loading process and manual data reconciliation. High data volume.		Analysed and implemented automations
Reduce cost of operations		Evaluated possible offshore locations which ensured quality of services

Technology

Platform		Application

HP 3000, JCL, Image Database, Cobol		Financial application
SQL Server, Informatica, Java, Brio, Web tools and HP Ux		Datamart for generating information
Oracle, Informatica, Power Centre, C++, HP Ux		Connector between Data warehousing and the EIA backbone
HP Ux, Redbrick, MS Access		HRM–Data warehouse with multiple repository
BP Ux, Redbrick, Brio, Web Technologies		Reporting solution
MS Access, Visual Basic		Reconcile data from multiple source system
Visual Basic, SQL Server, ASP, Brio		Data cleansing
HP 3000, Cobol, Suprtool, JCL, Saint, Salut, Turbostore/Hiback		Financial Applications
Oracle 9i, PL/SQL, Informatica		Datamart