Transmed Eliminates Database Downtime While Accelerating Business Processes with Flexible, Secure, Enterprise Application Infrastructure
 
 

Transmed Eliminates Database Downtime While Accelerating Business Processes with Flexible, Secure, Enterprise Application Infrastructure

Transmed is a regional sales, distribution, and bottling organization, representing major brands, such as Coca-Cola and Procter & Gamble. Transmed operates in Lebanon, UAE, Jordan, and West Africa, with each site acting as a largely autonomous entity and with its own separate IT infrastructure.

Transmed had experienced incidences of downtime and outages due to system stability issues and at the database level. It needed to address this and also to upgrade its enterprise resource planning (ERP) applications to gain the latest functionality, such as support for mobile workforces to ensure it remained at the forefront of a competitive regional sales distribution marketplace.

The company deployed Oracle Database Enterprise Edition 11g and upgraded its existing JD Edwards applications from Oracle to JD Edwards EnterpriseOne 9.0. With its upgraded environment, Transmed has accelerated its sales process, reduced errors, increased customer service quality, and accelerated deliveries. Greater control over pricing has enabled Transmed to attract new customers, while its mobile workforce can now process new orders remotely.

Transmed has also deployed Oracle WebLogic Server 11g, a scalable, enterprise-ready Java Platform, Enterprise Edition (Java EE) application server that enables Transmed to deploy mission-critical applications in a robust, secure, highly available and scalable environment.

 
 

 
 

Challenges

A word from Transmed

  • "Thanks to Oracle, our business no longer suffers the frustrating database downtime that forced us to restart our old servers every day to prevent production systems from crashing. Now, we have the strong, flexible data and resource planning infrastructure that we need to succeed in the region’s highly competitive consumer goods industry." – Samir Harb, Regional ERP Head/IT Manager, Transmed

  • Replace unreliable database responsible for more than 200 gigabytes of transactional data related to consumer goods distribution, and eliminate any possibility of downtime―without disruption to sales and distribution business functions
  • Simplify storage management to eliminate complexity, increase storage utilization and agility, and maximize administration efficiency
  • Accelerate business processes by implementing a more flexible database that handles queries faster, as well as an upgraded ERP system—crucial to a consumer goods company in a competitive market that must deliver products quickly and reliably
  • Increase accuracy of order, stock, and financial data by eliminating manual data entry across all areas of the business, including consumer goods production, sales, and distribution
  • Accelerate sales order processing and invoice creation for clients that include wholesalers, hypermarkets, supermarkets, and grocery stores, as well as healthcare
  • Establish a new mobile ordering system to enable salesmen to process orders and take payments for goods online, accelerating customer payments


Solutions

  • Eliminated the downtime and systems outages and accelerated database query handling by 50%
  • Accelerated consumer goods distribution and sales processes across every department, including logistics, delivery, and warehousing, thanks to increased flexibility and data accessibility
  • Ensured streamlined storage management for database administrators with Oracle Automatic Storage Management, eliminating complexity and increasing storage utilization and agility
  • Established online ordering and invoicing, thanks to JD Edwards EnterpriseOne 9.0 Supply Chain Management’s improved online functionality, increasing efficiency of traveling sales representatives by standardizing mobile ordering processes
  • Reduced processing time for new sales orders from three hours to just seconds by automating workflows
  • Simplified ordering processes by establishing a mobile sales system integrated with JD Edwards EnterpriseOne applications, enabling sales teams to register new customer orders online from any location
  • Reduced sales order processing time from an hour to just seconds, due to increased data availability through Oracle Database, Enterprise Edition 11g and improved workflows with JD Edwards EnterpriseOne Sales Order Management 9.0
  • Accelerated the order-to-delivery cycle by 25% to 30%
  • Enabled the business to grow its average consumer goods inventory by 10%, year-on-year, while eliminating up to two hours of downtime each day
  • Standardized the entire enterprise on JD Edwards EnterpriseOne 9.0 applications to simplify data sharing and reporting

Why Oracle

Transmed demanded a database that would prove more resilient and reliable than its previous database.

“Oracle is in the unique position of being able to supply us with a complete, integrated database solution, applications, and, now even hardware. Rather than having multiple vendors arguing and blaming each other, Transmed Overseas trusts Oracle as a single vendor with a single solution that simply works,” said Samir Harb, regional ERP head/IT manager, Transmed.

Implementation Process

Transmed’s previous experience deploying Oracle Database Enterprise Edition and JD Edwards EnterpriseOne led to a rapid and smooth rollout. This was critical because any delay during the deployment process would augment one of the issues that the new technology was intended to solve―unacceptable loss of business continuity. Transmed originally deployed Oracle Database Enterprise Edition 11g as a replacement to its old database in September 2011. It then deployed the upgraded JD Edwards EnterpriseOne applications. The process took two months and was completed on time and within budget in January 2012.

Partner

Global Technology Solutions s.a.r.l. is Transmed’s preferred IT partner. With the assistance of Global Technology Solutions, Transmed’s new JD Edwards EnterpriseOne ERP upgrade went live in just two months.

“GTS is an Oracle partner, specialized in Oracle JD Edwards deployments and highly experienced in deploying Oracle Database and other key solutions in this region. It’s extremely good at what it does, knows Oracle technology inside out, and it also knows what is expected from it for Transmed deployments,” Harb said.