Skip to main content Skip to main navigation Skip to search Skip to footer

Data Ware house for Analytical reporting

Data Ware house for Analytical reporting

Customer

Europe’s leading travel and entertainment services company specializing in last-minute deals.

The Challenge

  • The challenge was to provide the business with analytical reporting facility across all the company’s locales.
  • The company needed a vendor with development, enhancement, and support capabilities for all their service lines—flights, holidays, hotels, car rentals, gifts, theater, restaurants, and dynamic packaging— for all the regions.

HCL’s Solution

  • Took automated feed from seven transactional databases overnight and uploaded into DWH
  • Delivered around 800 business objects analytical reports
  • Provided support to 200 users across locales
  • Developed and enhanced all service lines
  • Enabled porting application to JBOSS using Struts
  • Developed new front-end JHTML pages and modified existing ones
  • Developed and modified the middle-tier dynamo servlets and JAVA classes
  • Used custom-built java tool for content management
  • Developed IVR using VXML and Broca/Nortel IVR
  • Integrated mobile application front-ends with GPS

Value Delivered

  • Introduction of Informatica reduced ETL time from eight+ hours to two hours
  • Multi-site development
  • 99 percent success rate on SLA of report deliveries
  • Management presented with information in addition to data
  • Substantial increase in sales and revenue from the findings of analytical reports
  • Streamlining of the business intelligence area through controlled reporting framework
  • Easy availability of data to business users for their key sales and product profitability decisions

Tools & Technologies

Informix 9.3, Java – J2EE, ATG, Dynamo 4.1, Red Hat Linux 8, JBoss 3.2.3, Tomcat-4.0.4, XML, VXML, IVR (Nortel), PVCS Version Manager 6.7, Perforce, Homesite 4.5, Forte, JBuilder 6, CRT, x2vnc, Informatica 6.2, Business Objects 5.1, Postgress, Oracle9i, MySQL, Informix, Perl, HTML, PL/ SQL, Struts, RUP

DOWNLOAD THE SUCCESS STORY

Contact Us
MAX CHARACTERS: 10,000

We will treat any information you submit with us as confidential. Please read our privacy statement for additional information.

We will treat any information you submit with us as confidential. Please read our privacy statement for additional information.