Oracle EBS R12 Implementation and Database Solutioning By Averon

Success Story

Masco Cabinetry

The Customer

Masco Cabinetry manufactures three nationally recognized cabinetry brands, KraftMaid®, Merillat® and QualityCabinets®. Masco Cabinetry LLC manufactures and markets cabinetry solutions for home improvement and new home construction markets. It serves builders, dealers, distributors, and home centers through manufacturing plants and branches/service centers located across the United States. Offering an unmatched selection of stylish, high-quality products at a variety of price levels, Masco Cabinetry brands are favored by builders, dealers, distributors and home centers throughout North America. A leader in environmental stewardship, Masco Cabinetry products have been granted an Environmental Stewardship Program certificate by the Kitchen Cabinet Manufacturers Association.



The Challenge

As a known challenge in the industry, performance efficiency is one of the major sort out constraint even at Masco for a 2TB/OLTP/1200 UB/ASCP Database. Heavily customized ASCP application, high availability, Data Security, Large Data transaction Volume are among the top most concerns for this North America based company that have many distributed warehouses across the United States. Adopting to the trending technologies and bringing onboard tremendous background knowledge on Oracle Applications Implementations, Srinivas Mandipudi and the team of DBAs have worked towards the instance go-live. Oracle applications with OEM databases having 8 Node Application Cluster and 2 Node RAC was a successful implementation and went live in the month of Mar-2010.

The Solution

However, with the growing data for the critical ASCP system, performance improvements are still in the park. While the system is efficiently implemented with shared APPL_TOP, Load Balancing of the Database Nodes, Data Guard for High Availability and Disaster Recover, RMAN for scheduled encrypted backups, Srinivas as a production support/enhancement DBA, provided extensive tuning using JVM Tuning, PCP, Partitioning and Partition archiving, working in collaboration with Oracle Support to identify and implement indexes, utilizing tuning for ASCP performance improvement, Parallel Concurrent Processing and many other solutions as required.

In addition, to the regular maintenance activities during 2 and half Years of his tenure at Masco Cabinetry, Srinivas has acted as a primary DBA for various standalone Oracle Databases and Oracle application Instances as well.
Our Database Architect is proud to state that Success owned by the client Masco Cabinetry is an effort achieved collaboratively, with a well-rounded architecture and best practice implementations.

Testimonial

Masco Cabinetry

""

How can we help You?

Learn How We Can Transform Your Business?

Get in Touch