Starschema

General Electric Lighting

• Gathering and integration of business data into the European and North American Data Warehouses
• DWH and Report solution development, support and operation
• Call Center Reporting
• Development and operation of ETL frame system
• Support of all GE reporting systems; report design, development and support for Finance, Sourcing, Manufacturing, EHS, Sales, and CRC

• ORACLE Data Warehouse (source systems: SAP R3, Avaya, Siebel, Excel, web applications)
• Business Objects Data Integrator
• Informatica
• Business Objects 6.5 (EU) and XI (NA)

  This activity is usually supported by 1-4 developers.

• By continuous synchronisation of SAP/R3, Oracle DWH and the reporting system we ensure the reliability and consistency of all information delivered to the Management and to the Analysts.
• Automation of waste management reporting according to REACH directives. By using our solution GE was able to minimize manual data loading processes to a 0 error level.
• We made GE able to measure Helpdesk workforce performance by loading Helpdesk process data into DWH and defining KPI-s based on that.
• Source to Target Mapping – With Starschema’s own developed solution we mapped the source data (ORACLE DWH) through ETL processes with Business Objects Data Integrator, and drained it to the report fields in SAP Business Objects. In case of a new BI project the lead time of an impact analysis on reports was reduced form the average 3 days to 1 hour.
• Starschema’s software solution made possible an 85% cut of operations costs of Business Objects Data Integrator Server.
• Based on our projects and its results at GE C&I Starschema Ltd is listed at GE Corporate as „Preferred BI Solution Provider in the EMEA region“ since 2008. Some of our developers working on GE projects have a Six Sigma green belt certification.

Tags: business objects | client reference | general electric | six sigma