SSM Taps Into PDW for Big Performance and Productivity Gains
SSM Health Care, a Catholic, not-for-profit health system that operates in four Mid-western states, was experiencing poor data warehouse performance that was resulting in important analytical reports taking way too long to complete or not even completing at all. SSM also needed to fix several data consistency issues they were experiencing that were impacting the quality of output. SSM source data was coming from their EPIC EMR/EHR system and their ETL/SSIS process was tied to SQL 2008. SSM reached out to Scalability Experts to design and implement a higher performing and more scalable data warehouse environment.
CHFS Migrates Off Oracle to SQL Server Platform
The Cabinet for Health and Family Services (CHFS) is home to Kentucky’s human services and health care programs. This includes Medicaid, the Department for Community Based Services, and the Department for Public Health. When CHFS needed to reduce their licensing and operational costs, improve performance and scalability and enhance the manageability of their database operations they turned to Scalability Experts (SE) for advice and a solution.
Scalability Experts Provides Needed Solution for Match.com
When Match.com realized that they needed a better way to deal with the tremendous amount of data that the website collected and generated on a daily basis, they turned to long-time partner Scalability Experts, specialists in data management and business intelligence, to assist them in finding a solution to the data management and analysis needs.
Major Mortgage Company
SQL Server 2000 Upgrade
This company is a full-service professional mortgage banker licensed to provide residential mortgages across the nation. They are an emerging leader in the mortgage industry and a preferred lender for consumers and mortgage professionals across the country. They operate through three loan production channels: retail, wholesale and correspondent.
County Solves Security Risks with Database Migration, Saves $280,000 in Upgrade Costs
The County of San Diego values a secure, reliable IT infrastructure that helps employees provide efficient services to residents. However, it faced security risks with several business applications running on an unsupported Oracle 8i database. Instead of upgrading to the latest version of Oracle, the county migrated the applications to Microsoft SQL Server 2008 Enterprise, saving money, improving reliability, and ensuring optimal employee productivity.
Global Investment Firm
Migration from Sybase to SQL Server 2008
This company is a global investment and technology development firm with more than 1,300 employees; approximately $19 billion in investment capital as of January 1, 2011; and offices in North America, Europe, the Middle East, and Asia. Since its organization in 1988, the firm has earned an international reputation for financial innovation, technological leadership, and an extraordinarily distinguished staff.
Poor Performance and Scalability: When the company, one of the largest hedge fund companies in the world, started to experience poor transaction data performance, mission-critical availability issues and concerns with scalability, they called on Scalability Experts (SE) to assess their environment, design a new architecture and migrate their operations to a higher performing platform.
Heterogeneous Environment: The company had an inefficient heterogeneous environment (mixed bag) that included large Sybase databases running on Solaris and SQL 2005 running on HP servers that were underperforming. They also had multiple and different SLA’s to contend with that made their environment costly to manage and maintain. To eliminate issues of complexity, costs and performance SE recommended standardizing on Microsoft’s SQL 2008 Enterprise platform. SE also recommended a unique three tired reference architecture approach that provided a framework to cost effectively match up the criticality of the databases in order to not over engineer the support costs for lower priority applications.
Movie Theater Company
Migration and Consolidation
The Company is the largest theatrical exhibition company in the world in terms of revenues and one of the largest motion picture exhibitors in the United States in terms of the number of theater screens operated. The Company runs more than 250 theaters with 2,800 screens in 23 states. As an industry leader in the development and operation of multi-screen cinemas, the company was experiencing double digit growth each year.
Home Mortgage Company
The Company in this case study is the largest online retail home mortgage lending firm in the US, according to National Mortgage News. The company is comprised of several divisions including a loan division, a title company and a settlement services provider. Founded in 1985 the home mortgage company employs more than 3,500 people.
Big Four Accounting Firm
Architecture Design Review and Consolidation
The Company is one of the world's largest accounting firms. The accountancy has some 770 offices in 149 countries around the world, providing clients with services in three lines of business: Assurance (including financial and regulatory reporting), Tax and Advisory. The umbrella entity is one of accounting's Big Four.
Scalability and Performance Analysis
This client success story involves one of America’s largest airlines that serves 172 cities in over 40 countries with more than 2,600 daily flights. The company has more than 60,000 employees and is in business to provide safe, dependable, and friendly air transportation to the customers, along with numerous related services.
National Home Retail Company
Consolidation and Virtualization
This customer is one of the largest retail companies offering more than 40,000 different types of products and services for the home (furnishings, appliances, building materials, etc.). Due to their rapid growth and expansion over the years, the company has a very decentralized IT operation and has been experiencing server sprawl, low utilization rates and escalating IT costs to maintain their data center infrastructure. The customer requested Scalability Experts to conduct a Consolidation Analysis and a Proof of Concept to gain insight and recommendations on how to pursue a more centralized and virtualized shared-services computing environment.
Large Automotive Manufacturer
Migration, Consolidation and POC
This customer is one of the largest automotive industry companies in the world. The company wants to evaluate changing their Oracle environment to SQL Server to reduce total cost of ownership (TCO). The customer requested Scalability Experts to conduct a Migration Assessment and a Proof of Concept (POC) to gain insight and recommendations on how to transition to a more centralized shared-services computing environment that would also reduce their IT maintenance and licensing costs.
SE Helps Leader Scale Smart Meter Solution
BI and Predictive Analytics Case Study
This customer is a global provider and pioneer of metering, data collection and utility software solutions for the Power & Utility industry. The company hired Scalability Experts (SE) to help them improve the scalability, availability and performance (scale up to 2 million customer meters per day) of their Microsoft based BI software product suite. The product provides software tools and predictive analytic capabilities critical to realizing the benefits and value of Smart Grid technology. An operator using predictive analytics to manage their Smart Grid operations helps them to:
- Improve energy conservation
- Aggregate multiple supply sources of alternative clean energy
- Enable consumer empowerment so that the end-user can lower their monthly usage costs
- Reduce equipment failure and outages
The customer was skeptical at first if the Microsoft BI platform stack could effectively scale to significantly higher data volumes and with them being behind on their development schedule they considered other platform options for their product. With several Utilities already using an early version of the product, they decided to further investigate the capabilities of the Microsoft BI platform and called in Scalability Experts to evaluate the architecture and to make changes to their product.
Migrating from Oracle to SQL Server?
Headed into the cloud?
Extend your SQL Server 2008 Management Data Warehouse (MDW) with Scalability Experts Smart™
“Without the knowledge and leadership skills of Scalability Experts, we would have never been successful at migrating our vital data from Oracle to SQL Server. They have tremendous resources at their disposal and shared their knowledge as they worked with our team to complete a smooth migration across our entire global network on time and within budget.”
– Chief Information Officer
Global Investment Bank