ADMS-OPD
Solutions

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
• Technology Partnership with Oracle, Microsoft and other industry leaders
• Vast experience in supporting clients with multiple geographical locations

ID Solutions

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 / Installation 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