ADMS-OPD Solutions

ADMS OPD Solutions

Client Overview
cloud based solutions

Client is one of the most popular and successful automobile brands in the Middle East boasting of a strong line-up ranging from popular passenger cars to powerful 4x4 series and commercial vehicles. In its quest to closely understand the local needs of its customers, our client set up a regional Middle East head quarters in Dubai.

Engagement Overview
Client One of the largest automotive company in the world
Industry Automobile
Project Start Date 2006
Project End Date/ Status 2008
Project Locations Dubai,UAE
Number of current Users 150 users across Middle East
ID Team Size Onsite: 3
Offshore: 2
Technical Details Oracle Developer Forms 6i/10g, Oracle database 9i, Oracle 10g Real Application Cluster,
Oracle 10g Rel2 Application Server Cluster, Redhat Linux Enterprise, MS Windows 2003 Cluster,
IBM Blade and Storage
Integration EDI, SAP Financials, BI


client's IT scenario-before Id Associations

Client was using manual processing for inventory management, order management, Logistics, Re-invoicing for the transactions between the client, Japan HQ and client distributors in various locations. Flow of information amongst Client, Japan HQ and Client distributors, involved high levels of human intervention and hence the processes were time consuming, resource intensive and prone to errors. Absence of a centralized and versatile IT system also meant that lot of limitations in terms of forecasting, resource planning, adhering to local standards, etc

why/How ID was chosen

Our client being a quality conscious company with Mission Critical systems uses rigorous methods to evaluate and select the right technology partner. The company chose ID for the following value propositions

  • Proven expertise in product development and life cycle management
  • 15 years of ID ’ s and its SMEs ’experience at both domain and technology levels
  • ID Relationship with client since 1997 in various projects
  • Technology Partnership with Oracle, Microsoft and other industry leaders
  • Vast experience in supporting clients with multiple geographical locations

ID Solution

er. Implementation was successfully completed as per Oracle best practice document and tested with various test cases for Fail over and Load balancing. As second stage, Application was migrated to Forms/Reports 10g and deployed with Oracle 10g Database incremental backup update. Entire migration was carried out using following Industry best methodology,

  • Project Initiation and Study
  • Low level Design System design for Database and Middleware
  • Application and Database bench marking for testing
  • Prototype for Database and Application Migration
  • System and UAT Testing against Bench Mark reports
  • Enhancements and Bug fixes
  • Production Database migration
  • Production Application Migration
  • Documentation and Project closure

Client also uses ID ’ s Tours/Holidays System “eXplore” to manage their Holiday Operations.


Implementation Challenges

  • Collaboration with various stake holders in various locations
  • Transforming partners and business users to a web based system from rich client server architecture.
  • Heterogeneous DB connectivity with oracle and SQL for BI reports
  • Withdrawal of Oracle Rule Based Optimizer technology and De-support for this issues during migration to Database 10g
  • Limitation of Oracle Forms 10g for building seamless interface with client OS for printing and File I/O.

Client Benefits

  • Centralized and versatile system with the ability to meet and adapt to business challenges and requirements
  • Automated System Administration with Oracle 10g Database
  • Highly improved performance with Oracle Database and Application Server 10g.
  • Real-time Status
  • Shipment Tracking
  • Quick turnaround
  • Cost effective
  • Seamlessly integrated with SAP Finance
  • Quick Data access across distributors increasing business efficiency
  • Business rules based Alerts helps client/distributor to manage pro actively