American Express - An Oracle DB Conversion Case Study

Oracle database conversion of the Serve product led to cost savings

Client
Challenge Convert Oracle databases to MySQL
ResultNearly $100K in Savings
TagsOracle, .NET, Big Data, Financial

Serve, American Express's reloadable account product, has been a game-changing success for the company. It was originally built on an Oracle database, but management realized that transitioning to MySQL would yield substantial cost-savings.

Unfortunately, AmEx lacked a way to handle the continuous integration of MySQL database changes throughout their many IT environments. TaylorMade Software developed the technical “glue” by creating a pure SQL-based testing tool with dynamic SQL in MySQL to automate the running of unit tests against and within the database system itself.

By our estimates, this automation solution saved the client at least $100K per year in manual labor costs.

Related Case Studies

HD Supply - A Snowflake Case Study Highlighting Security, Governance and Compliance via RBAC Automation

Snowflake enterprise roadmap for RBAC, governance, disaster recovery, and SOX compliance

Tags: Snowflake, Big Data, GCP, Energy & Transport

Building a Snowflake Pipeline for Citi

Self-service Snowflake automation portal with GitOps provisioning and onboarding workflows

Tags: Snowflake, AWS, Big Data, Financial, Java

Hertz - AWS Mobile and Web App Modernization Case Study

Modernized multilingual mobile and web apps in AWS, improving booking speed, UX, and developer efficiency with React

Tags: AWS, JavaScript & TS, Java, C++ & Embedded, Mobile, Retail

American Airlines - A Case Study in Snowflake Data Lake Modernization

Automated Snowflake RBAC, workspace provisioning, and lifecycle management for enterprise users

Tags: Snowflake, Big Data, Azure, Python & AI, Energy & Transport

Bank of America - CoAdvantage HR Rewards Tax-Shelter Platform

Engineered HR-linked BofA card platform to automate cashback deposits into tax-free 401(k), HSA, and 529 accounts.

Tags: .NET, Oracle, Financial