COMPANY OVERVIEW

• One of the largest telecommunication company in Mongolia founded in 2005. They have launched 4G LTE service last year providing high qualified mobile services. Unitel also provides broadband subscription IT television services through Univision.

CHALLENGES/OPPORTUNITIES

• Growing up their business, users and business data are increased. It was affected their billing service.
• After integrated Univision service, batch jobs for billing were faced in abnormal conditions.
• Availability and high performance are very important point at their system especially batch jobs in a billing service.

SOLUTIONS

• Serends provides remote and on-site technical support service
• Provides regular health report and risk point on the Oracle database and Oracle WebLogic servers.
• Training DBA how to do problem tracking and SQL tuning skill.

RESULTS

• After provided technical support from September 2015, many critic issues were cleared.
• With expert service of Configuration and Performance Review, hidden risks were collected and driven availability by enabling proactive troubleshooting.
• Transferring expert knowledge to the DBA, his ability to control their databases were grown up more.

COMPANY OVERVIEW

• One of the world’s leading logistics for the customers in the various fields of industry. Using their network covering 240 countries around the world, Hanjin offers various types of courier services such as transportation, storage, packing, stevedoring, international transportation, and parcel delivery service.

CHALLENGES/OPPORTUNITIES

• Make support services more efficient and improve IT maintenance operations productivity, enterprise wide.
• Accelerate time to diagnose and resolve issues to ensure high database availability, enabling better service.
• More than 60 databases are installed and managed by 6 DBAs.

SOLUTIONS

• Oracle EM 11g
• Serends Remote and On-Site Support Service
• Serends Expert Service

RESULTS

• Delivered Oracle EM11g for monitoring all of the database, they have reduced time to identify possible threats and bugs.
• Enhanced staff expertise and ability to identify areas for future improvement for health checks, patch plans, and patch recommendations, reducing operational costs and business risks.
• For the mission-critical system, Serends has been offering expert service periodically; Serends Performance Review
• Transferring expert knowledge to the DBA, they have enough ability to control their databases by themselves.

COMPANY OVERVIEW

• LG Uplus Corp., is a South Korean telecommunications and mobile phone operator. They launched LTE-A service and introduced Galaxy S4 LTE-A, the world’s first “100% LTE” smart mobile that can utilize data, voice and text with LTE and not fall back to CDMA in 2013.

CHALLENGES/OPPORTUNITIES

• Oracle GoldenGate 11g for real-time replication between the customer relationship management applications and billing and charging databases has dramatically save time and staffing costs.
• Oracle Golden Gate’s replication capability is excellent, but it sometimes slowdown and interrupted of operational databases.
• All of the transactions are treated by Oracle TimesTen In-Memory Database.

SOLUTIONS

• Serends Consulting
• On-Site Support Service

RESULTS

• Serends have consulted Oracle GoldenGate for redesigning replication architecture. After implemented with new architecture, there is nothing slowdown any more.
• For the purpose of emerging problem tracking, Serends engineers are arranged on-site and support 24/7 about Oracle GoldenGate and Oracle TimesTen.
• Enabled real-time replication between Oracle TimesTen and Oracle Database to ensure faster time to revenue.

COMPANY OVERVIEW

• One of the largest telecommunication company in Mongolia founded in 2005. They have launched 4G LTE service last year providing high qualified mobile services. Unitel also provides broadband subscription IT television services through Univision.

CHALLENGES/OPPORTUNITIES

• Growing up their business, users and business data are increased. It was affected their billing service.
• After integrated Univision service, batch jobs for billing were faced in abnormal conditions.
• Availability and high performance are very important point at their system especially batch jobs in a billing service.

SOLUTIONS

• Delivered new billing solution based on Oracle ESL (Embedded Software License) by Serends.
• Redesign and optimize the infrastructure with Oracle EXADATA system advanced on performance and availability.
• Tune long running SQL batched jobs amount of 270 processing billing service.

RESULTS

• Obtained cost effective more than half reduction in Oracle license price by Oracle ESL.
• Batch processing can be finished within 1 hour at night time without any affect to their business; it was took about 8 hours more before.
• Prior to carrying out the project, invoice and payment tasks required a long time process, and UNITEL received more than 300 complaints from their customers every day; now no further complaints have been received any more.