Case Study Archives - mLogica

Building Maintenance Services Company – IBM Db2 to Oracle 12c Migration

The Customer is an American Fortune 1,000 public company that provides residential and commercial services to restore homes and businesses after water, fire and mold damage. They were running JD Edwards E1 on Db2 without customizations, and were facing performance and scalability challenges with this legacy system, including operational problems of dwindling support, scarcity of resource availability and escalating costs.

Government Organization – Modernization of the Strategic Database and Applications

The Customer is a government entity that manages tax, income and pension information. This organization manages a massive social service system that interacts with other government systems, including federal and regional organizations, communal institutions, social security, banks and hospitals.

Government Agency – Migration of All Z/OS Applications to an Open Environment

The Customer is a government organization with over 45,000 employees. The organization provides assistance to unemployed citizens and helps them find jobs, as well as supporting them with financial aid. The organization was founded in 2009 as a merger of government agencies.

E-Health Solution Provider – Migration of Administrative E-Health Solution to Java JEE Architecture

The Customer provides digital health solutions to healthcare organizations including hospitals, clinics, and healthcare facilities, providing high-tech systems to support their clients’ administrative, logistical, and pharmacy processes. The goal of the organization is to improve coordination and performance of different departments from care teams to payers, helping them deliver higher-quality healthcare, improve population health management and improve efficiencies across all organizations.

Mutual Health Insurance Organization – Cost Reduction of Old Applications

Our Customer is a leading mutual health insurance organization that protects millions of employees working across a wide array of industries including healthcare, education, sports and culture. This organization has over 10,000 employees and provides a range of care and support services through their medical, social and dental organizations.

Government Agency – Modernization of All Strategic Applications

The Customer is a national public sector agency that provides diverse forms of social security payments to more than ten million beneficiaries in their country. These include subsidies for housing, family and childcare support, educational allowances and more.

Multinational Financial Services Company – IBM Db2 to Oracle Database and FIS Application Migration

One of the top twenty-five U.S. financial holding companies in North America, the Customer offers business and retail banking as well as wealth management services. The Customer was experiencing issues stemming from a legacy IBM AS/400 Db2 database environment running Fidelity Information Systems (FIS), and had migrated hardware from IBM PureScale 9.8 to Oracle. However, they needed expert help to securely migrate their database from Db2 to Oracle.

US Government Health Agency – Migrating Analytics to the Cloud

The Customer is a United States government health agency charged with ensuring the well-being of the American people with respect to public health, medicine and social services. Headquartered in Washington D.C., this agency handles highly sensitive personal data at eight divisional, ten regional and hundreds of branch offices throughout the US.

Global Investment Company – Oracle Database Escalation Support

With thousands of worldwide employees and an equally large and dispersed IT infrastructure, this global technology conglomerate turned to mLogica for immediate and long-term solutions. mLogica’s team of experts identified and removed recurring issues and improved operational efficiencies without diverting internal resources from their primary duties, enabling the Customer’s internal database team to work on system improvements and more strategic IT initiatives.

Healthcare Provider – Oracle SNAP Clone and RMAN Backup Optimization

Check out how mLogica helped a regional, US healthcare provider keep pace with company growth by overcoming poor system performance and backup speeds. By tuning system components and applying best practices, mLogica optimized data backups, alleviated disaster recovery concerns and dramatically improved overall business system performance and stability.

Beverage Manufacturer – SQL Server Performance Analysis

Optimizing application performance for one of the largest coffee manufacturers in the Americas was more complicated than expected. After a “comprehensive” server performance analysis by a competitor failed, mLogica provided immediate and ongoing solutions to ensure operational efficiencies that matched, and accelerated the company’s phenomenal growth.

Public Service Provider – Oracle RAC Database Environment Migration

When this regional provider of water and waste management services needed an entire infrastructure upgrade, leadership could only think of its 400,000 residential customers. So, they called on mLogica, whose dedicated team of database architects and migration experts turned an aging legacy system into a modern, high-performance IT asset – maintaining uninterrupted application access, data integrity and security throughout the engagement.

Oracle WebLogic Support Services

One of the largest mobile phone service providers in North America required Oracle WebLogic support services to supervise their production deployment and to help manage and document their environment. Traditionally, the WebLogic Platform is used for developing and deploying multitier distributed enterprise applications. The Customer uses their WebLogic servers to centralize application services, such as web servers and common business application components that provide access to backend enterprise database systems.

Media Publisher – Microsoft SQL Server Migration Services

The Customer is a leading provider of advanced, cross-media publishing and communication services in industries ranging from residential housing, book publishing to cancer care. With combined expertise in content generation, real-time data integration and business process management, the Customer was stretching its IT infrastructure to deliver valuable, industry-specific solutions.

Global Clothing Manufacturer and Retailer Amazon Redshift Re-Architecture

Latency = delay. Also referred to as a ping rate, it is the amount of delay (or time) it takes to send information from point to point. Latency is usually measured in milliseconds. In retail and e-commerce, it can represent the difference between success and failure.

International Restaurant Chain SQL Managed Services

The Customer is a renowned chain of restaurants operating all across the United States and in over fifteen international locations. The Customer required active Database Run-Operate-Maintain support for their Microsoft SQL Server database environment. mLogica was approached to provide Level II and Level III support on a 24*7*365 basis, including 24*7 helpdesk services to resolve issues to the Customer’s database environment.

Department Store Chain – PowerBuilder, EAServer and Java Services

The Customer was in the process of porting an Invoice Match Application from SAP PowerBuilder 7 running on Jaguar (predecessor to EAServer), a setup which caused operational roadblocks due to unsupported development environments and operating systems, to PowerBuilder 12 running on EAServer. The application also required our application project team to assist in Java elements, including coding and packaging into JARS. The ultimate goal was to create a fully supported environment to improve operational efficiencies of the Invoice Match Application.

Oil and Gas Multinational – Oracle RMAN Integration with ArcServe Backup/Recovery Software

The Customer, one of the world’s largest oil field service companies, needed to integrate their Recovery Manager (RMAN), an Oracle-based data backup and recovery manager, with ArcServ Backup/Recovery software. The aim was to achieve high availability and disaster recovery as part of a database backing-up and recovering process.

Global eCommerce Platform Provider – Legacy Migration to Amazon Redshift

Large retail companies require Order Management Systems for tracking customer orders from creation to delivery. These systems are quite complex as they involve order tracking, stock level maintenance, packaging and shipping, and even synchronizing orders across multiple channels (e.g. if a customer orders online and picks up the item in a store). The market for Order Management Systems (OMS) is expected to grow from 1.46 Billion in 2018 to 2.44 Billion by 2023, reflecting the rapid growth in retail and e-commerce.

Live Nation – Oracle E-Business Suite (EBS) Optimization on AWS Cloud Environment

Live Nation is the largest live entertainment company in the world, connecting over 570 million fans across concerts and ticketing platforms in approximately 44 countries.

Global Investment Management Firm – SAP ASE and Replication Server Expert Services

The Customer is a leading quantitative investment management firm that manages assets for high net worth individuals globally, including corporate and public pension plans, foundations, endowments, and sovereign wealth funds. The Customer was running SAP (Sybase) ASE 12.5, and a backup server using SAP (Sybase) Replication Server v12.6 for “warm stand-by”. Being on older database versions, the Customer experienced problems of scalability, speed, and data performance challenges. They decided to migrate to the latest SAP ASE 16.0 database, and also upgrade and configure their backup server to SAP Replication Server 15.7 for “warm stand-by”.

Global Telco – IBM Db2 to Oracle 12c Migration

The Customer is one of the world’s largest telecommunication service providers that delivers fixed line, broadband, DTH, voice, data connectivity, cloud and digital solutions, as well as, enterprise services. Their legacy DB2 database platforms and associated applications had scalability and availability limitations that resulted in serious performance challenges impacting their business growth prospects. In addition, maintenance and upgrade costs on DB2 were continuing to rise amid decreasing technical support. The Customer turned to mLogica for a workable solution that would cause minimum operational and business disruptions.

Leading National eCommerce Company – Legacy Commercial DB to Aurora PostgreSQL Database Migration on AWS Cloud

The Customer is a leading software company that offers cloud-based commerce platform solutions and services for retailers, manufacturers, and brands. Looking to expand their growing internal infrastructure, the Customer sought to migrate their applications running on legacy commercial databases environment onto Aurora PostgreSQL, within an AWS cloud environment. This migration strategy was to take advantage of AWS’s proven architecture, reliability, data integrity, robust feature set and considerable extensibility.

Major Global Biotech Company – Accelerated understanding and adoption of AWS RDS for Oracle Database Services

The Customer is the largest independent biotechnology company reaching millions of patients around the world, and developing a pipeline of medicines with breakaway potential. Facing major growth restraint as a result, they chose to move datacenter servers running Oracle databases onto their more dynamic and flexible Relational Database Service (RDS) for Oracle on the Cloud offered by Amazon Web Services.

Global Financial Services Company – IBM Mainframe Migration to Oracle Exadata

The Customer is a leading global financial services corporation with the need to migrate database and data from their existing legacy Db2 mainframe platform to Oracle Exadata 12c to achieve better operational efficiencies and business outcomes. The Customer elected to migrate to Oracle Exadata for reliable database performance, scalability, and reliability.

Transportation Company – SAP Sybase ASE Server and Sybase Replication Server Migration and Upgrade

The Customer is a transportation firm, operating nationwide. They were facing operational challenges in their database environment due to resources constraints in handling growing volumes of data. They were aware that a major upgrade of their existing IT infrastructure was required to handle the data growth and turned to mLogica for assistance.

TicketSocket – Microsoft SQL Server and Mongo Database on Azure to Amazon Aurora

TicketSocket, an Independent Software Vendor (ISV), is transforming the way companies use ticketing, with a white label software platform that any business can use to integrate into their website or application, enabling it to sell and redeem tickets, and as well as process registrations and credit card transactions with total control. Additionally, TicketSocket is providing their customers with AWS based data analytics and reporting. TicketSocket also provides their customers with the ability to perform deep, Artificial Intelligence-based, social analytics of their customers’ end users, business influencers and movers, and key social/business metrics for competitive intelligence to better enhance their business.

National Professional Training Provider – Oracle MySQL NDB Cluster Setup and Performance Management

The Customer – a national vocational education and licensing company for the insurance and securities industry – was running an older, unsupported version of MySQL which could not be upgraded despite mounting performance problems. mLogica was brought in to assess and analyze their current MySQL environment, then suggest and implement performance and tuning recommendations.

Global Investment Management Firm – SQL Server Managed Services Support

The Customer is a global investment management firm. They were facing a number of operational and performance issues with their legacy SQL Server environment and had limited resources to support a complex environment of over 500 databases and replication servers that was error prone and slowing down business user performance. Additionally, documentation was missing; and processes and procedures were not established. mLogica was brought in to help remediate these issues and provide 24*7 operational database support.

Global Aerospace Logistics and Supply Chain Provider – AS/400 Db2 to Oracle 12c Cloud Migration

The Customer is the world’s leading independent distributor and provider of supply chain management services to the global aerospace industry, The Customer was using a data warehousing solution running JD Edwards on an AS/400 Db2 platform and required assistance migrating data structures and data to an Oracle 12c Cloud based Data Mart so that they could perform advanced analytics and reporting.

Global Bank – Product-based Migration and Managed Services Program

The Customer maintains 350+ legacy Sybase/SAP servers to operate several of their mission critical applications. Over the years, as the Customer’s resource allocation to their system has grown, Sybase itself has seen its market share – and consequently, support for their product – decrease rapidly, putting at risk the Customer’s ability to manage their critical Sybase databases.

Major Online Retailer – Microsoft SQL Server on Public Cloud Implementation

The Customer, one of the leading online retailers in North America, required mLogica’s assistance to identify and then implement the end-state architecture of their newly acquired Microsoft SQL Server database on their public cloud platform. This would allow them to understand, and fully utilize, the SQL Server’s advanced features such as high-availability, failover clustering, in-memory performance, advanced security, and in-database analytics.

North American Logistics and Transportation Company – Database Managed Services SAP/Sybase Environment

The Customer’s legacy Sybase systems crashed over a weekend; their business ground to a halt and they were, in effect, out of business. They needed mLogica’s help with the triage and troubleshooting of their downed system and bringing it back online as quickly as possible; the mLogica technical team worked non-stop for 48 hours to bring the servers up.

Global Private Bank – IBM Db2 to Oracle Exadata

The Customer, one of the largest private banks in the United States, decided to evaluate and re-platform their Db2 UDB (Universal Database) environment onto an Oracle Exadata to improve performance and reliability. Challenges with the Customer’s existing environment included availability, maintenance, and scalability of the legacy database platform which was leading to serious system performance issues in terms of data loads, aggregations and data “timeliness” across architectural tiers. In addition to this was the rising cost of DB2 resources and infrastructure amid decreasing DB2 market share.

US State Agency – Sybase IQ to Oracle 12c Migration

The Customer is a prominent US state agency providing healthcare and human services within its state boundaries. It was using a data warehousing solution developed about two decades back built on Sybase IQ platform, which was rapidly reaching end-of-life and resulting in major operating challenges. Consequently, the Customer was looking to replace their hardware, upgrade or replace existing software, and migrate data for their Client Services Data Warehouse (CSDW).

Brabble Inc. – MongoDB Migration to Amazon Elastic Compute Cloud (EC2)

Brabble Inc., the creator of the “All-In-One Social Media & E-Commerce App” was facing database and server issues with their application in terms of scalability and performance, Their mobile application was riddled with issues that was creating an unsatisfactory user experience. As a result, adoption was uneven and falling.

A Global Entertainment Company – Oracle E-Business Suite (EBS) Optimization on Amazon Web Services

The Company decided to standardize not only the dev/ops but also all of their mission critical databases and migrate everything to AWS including their Oracle workload.

Global Marketing Agency – SAP IQ Managed Services and Database Optimization

mLogica was brought in to replace existing managed services support for the Customer’s SAP IQ database environment and to streamline its operation. The existing database architecture, in heavy use by their multiple-end customers, was proving increasingly inadequate and expensive; unable to keep pace with the Customer’s operational growth and usage. For example, the database was slow almost on a regular basis, its size in Terabytes growing substantially, rapidly and unsustainably.

Nationwide Healthcare Provider – Teradata to Oracle Exadata

The customer had become increasingly dissatisfied with a costly Teradata platform hindering their ability to meet reporting and business goals related to performance and scalability. There was a reluctance to migrate from Teradata as the environment had received significant customization investment and due to the cost, complexity and scale from previous project estimates, including time to market from five to seven years.

Global Bank – Netezza to Oracle Exadata

IBM has made public that they will be ending support for their legacy Netezza databases at the end of June, 2019 and, at this time, the only migration path which IBM is offering is to Db2. IBM’s future state roadmap for this technology is unclear. These factors understandably compelled this major Global Bank based in United States, to modernize their legacy Netezza environments.