Archive

Archive for the ‘Systech Corner’ Category

Science of Profitability

August 6th, 2010

Today’s competitive environment and challenging economic conditions make it imperative for businesses to be cognizant of actionable opportunities and potential pitfalls. More than ever before, companies need to identify initiatives that positively impact the bottom-line, given the unprecedented budget and performance pressures.

How can you make more money from your existing businesses without long drawn out and costly new initiatives? This question is both a challenge, and an opportunity.

This report educates management and IT of the significance of understanding Profitability and its levers as a means to achieve this goal

Register here to request the white paper.

Systech Corner

Netezza Migration to improve results and compete better in todays dynamic markets

July 1st, 2010

Background

Nationwide Financial Services, Inc., (NFS) together with its subsidiaries, provides long-term savings and retirement products in the United States. The company operates in three segments: Individual Investments, Retirement Plans, and Individual Protection offering a variety of investment products including annuity products, income products, and investment advisory services and investment life insurance products. All three segments were run on the Teradata platform.

NFS seeked a solution that helped them compete in a shifting global market, and to ensure that the IT infrastructure was as cost effective and as operationally efficient as possible on a long run.

Systech was selected for the conversion project to migrate the Data Warehouse platform from the existing Teradata platform to the newly acquired Netezza Data Warehouse appliance, to leverage a proven, functionally rich technology. The project involved moving the data itself as well as “re-wiring” all Data integration, reporting, application interfaces and any other systems which touched the existing data warehouse.

Challenges

  • The complexity of multiple data source systems and identifying all components of an alternate solution that require design change due to conversion and identifying the impact of those changes
  • Incomplete documentation in existing processes such as data load, reporting and interface processes
  • In-flight project management (Keeping development going on existing infrastructure while converting and managing the integration process)
  • Database “re-modeling” and having to isolate and confirm data Model re-usability and potential issues
  • Confirm Re-usability of existing approach and/or alternate strategy
  • Ability to generate a balanced test plan that meets critical test criteria in allotted budget and service hours available
  • Testing in this project represents a major and complex element as the end result of the project interconnects so many technologies, addresses a significant amount of data across the organization and impacts a wide group of end users

Solution

Systech executed a managed conversion scope of the entire Nationwide Financial Data Warehouse environment. The financial data is now stored in a staging area and in various data marts. The migration of “ETL” which constitutes the application code and processes moves the data on an ongoing basis into the data warehouse and various data marts. The migration of the connected reporting environments and applications interfaces to the data warehouse.

The change of database platform from Teradata and Netezza has impacts on the physical structures of the database schema, ranging from naming standards, column data types and object functionality such as writing into a table through a view. The design took into account all such factors in arriving at an alternate schema design that would be completely supported by Netezza and at the same time provide the exact same functionality as the current Teradata environment.

The processes that perform data movement across the systems use Teradata specific functionality to perform bulk loads, faster exports or some specific data transformations. A host of such functions and functionalities were identified as part of design phase and an alternate solution was designed to provide the exact same functionality in the new Netezza environment.

The reporting applications interact with the Teradata environment through a series of reporting tools and technology. The interaction of these tools with the Teradata environment happens in a number of ways, some tools offer semantic layers to mask the underlying database schema with a business definition, As far as reporting applications are concerned the two major design factors that were implemented are Netezza specific functions used and Connectivity mechanism.

Results & Benefits

Systech’s Success at NFS was implementing cost savings and performance improvement. Reporting performance improvement in Business Objects was substantially a 65% reduction in processing time. Systech completed a seamless database backup to the Netezza DR database. Systech went in with a very complete approach and methodology around conversion that managed a very complex scope. The attitude and teamwork displayed contributed to the team’s accomplishment to enhance the current reporting capabilities and greatly enhances NFS’s ability to achieve competitive advantage through actionable data analytics going forward.

Despite disruptions for many reasons, the Systech dedication and project management really was apparent. The teams worked incredible hours to make deadlines and complete the project. Systech’s assistance with organizing the numerous technical challenges and helping NFS keep track of backup copy of data for comparison. We accomplished an amazing amount of tedious testing through teamwork.

“This was a very challenging project which required an enormous amount of collaboration across business units, technical disciplines and our vendor partners. The attitude and teamwork displayed by Systech was awesome. Their accomplishment not only enhances our current reporting capabilities, but even more importantly, greatly enhances Nationwide Finance’s ability to achieve competitive advantage through actionable data analytics going forward.” -Tim Lyons, Vice President, NF – Business Solution Services, Nationwide Financial Services

Systech Corner , , , ,

Data Foundation and Category Management

May 27th, 2010

Background

A major home video distribution company sought Systech’s assistance to bolster their category leadership for the DVD category in the retail scenario. They required retailer specific solutions and comparable insights across many retailers and markets.

Objective

The objective of the Category Management project is to provide the data foundation, both strategically and technically, for the overall Category Management Application and subsequent releases, the better forecasting and allocation of new releases, and fixture level assortment planning and merchandising. The approach targeted the most influential variables within a category manager’s span of control: Adjacencies, Aisle Flow, Planogram Configuration, and SKU Assortment in an effort to simplify the consumer shopping experience.

Challenges

Data

  • Highly disparate sources of data made it difficult to get a holistic view
  • Lack of visibility into financial performance, channel sales and inventory across 13 territories outside US

Incentives

  • Category management functions between the retailer and the distributor across the globe was not aligned
  • Different promotions and plannogramming at various retailers across different locations made it difficult to perform an efficient analysis

Process

  • Standardization of master/reference data across multiple categories
  • Required definition of goals, metrics and incentives

Technology

  • Required timelines and quality of analysis on large volumes of granular data
  • Needed access into significant number of resources to crunch data, gather insights and make it actionable

Solution

Systech worked with the client to develop Enterprise Data Architecture to Integrate Data and applications residing in 13 different sources across many countries. Informatica was configured for the ETL process to extract data from source & populate the data mart. Systech’s seamless data exchange through automation, resulted in minimal manual intervention. Conversions and interfaces were also built from existing and legacy systems to a flexible platform, and migration was managed without any disruptions to the users. To make the deployment efficient, Systech adopted a Phased Approach (by territory)

Systech also designed, developed & implemented the data warehouse, the reporting & Dashboard applications to provide information on Sales, inventory, promotion, assortment planning, merchandizing, market share by retailer, by SKU, by time, by region using MicroStrategy. Defining key business drivers and KPIs to achieve deeper insights into the product was also facilitated.

Product-specific configuration principles were developed to be implemented when new DVDs were introduced into the strategic assortment structure. In addition, Systech developed a fully automated assortment tool that integrated configuration principles with market forecasting to optimize space allocation on an account level.

The category management application was developed in an onsite – offshore model.

The underpinning category strategy set by Systech was to increase footfall into the category, by improving relevance, as well as to simplify the customer shopping experience, through improved layouts, product range segmentation and product presentation.

Results & Benefits

Assortment Planning and Merchandising

  •  Assisted in determining which products should be in distribution at specific stores during specific time frames
  •  Assisted in determining which, and when, to discontinue an item
  •  Helped the buyer determine which assortment of products will best maximize and capitalize on seasonal changes and events like holidays.
  •  Matched consumer demographic and psycho-graphic traits to store level assortment
  •  Determined incremental gain obtained thrrough cross selling synergy, or diminished sales resulting from cannibalization
  •  Helped understand correlations between qualitative activities, such as fixtures and displays, and quantitative results such as sales dollars and unit sales
  •  Helped understand cross-merchandising patterns and opportunities, such as selling DVD’s near DVD players
  •  Assessed planogram performance in maximizing store sales and/or category profits

Market Share Analysis

  •  Assisted in determining the performance of retailers and products across different geographic areas such as the West coast, Midwest, Los Angeles, etc.
  •  Evaluated the performance of retailers and products across different channels such as grocery, mass merchant, specialty
  •  Assisted in ranking and assessing the performance of vendor sales for specific products across retailers
  •  Helped compare the retailer’s sales performance against another part of the market, or across the market as a whole.
  •  Assessed the opportunities of expanding the retailers’ footprint into new markets, categories, or channels.
  •  Evaluated Market Share across studio, brand, genre, format, top selling DVD

Sales and Inventory Analysis

  •  Assisted in analyzing POS sales performance based on product, vendor, store, division, or time frame
  •  Evaluated sales, profit, and distribution share across the retailer categories
  •  Assisteded in ranking, contrasting, and evaluating the sales, profits, and related performance of specific products across brands or franchises
  •  Helped understand how to maximize sales performance based on the physical store layout and store type
  •  Assisted the retailer in managing out-of-stocks, as well as assessing opportunity cost
  •  Helped the retailer manage inventory capacities at both the warehouse and store level
  •  Assisted in planning initial forecasts, as well as replenishments order requirements
  •  Evaluated the impact on category profits by analyzing shrink and loss prevention
  •  Helped better manage the inventory process by monitoring the product movement

Promotion and Event Analysis

  • Assisted in determining increases or decreases in sales resulting from promoting two or more items together
  • Evaluated the sales, profit, or distribution or a new item launch or re-priced item
  • Determined the impact to product and category performance in conjunction with the price elasticity
  • Assisted in assessing the performance of specific retail promotional tactics and combination of Ad Price, Display, Price Points, etc.
  • Assessed the performance of special events such as a sporting event tie-in, celebrity store signing, etc.
  • Determined the performance of special pack configurations, such as dual packs, premium packs, special editions, limited editions, etc.
  • Understood the impact and value add of promotional themes and circular themes
  • Assessed the impact of product placement in an advertisement or Sunday circular
  • Compared and analysed retailer promotional price point against competitor promotional price points

The majority of concepts developed through this project have been implemented by retailers, leading in all cases to double digit improvement in performance for both the DVD category as a whole, and the whole DVD distribution enterprise.

Systech Corner , , , , ,

Smarter Integration

March 31st, 2010

Quest to enhance customer relationships – Are you holding the right cards?

What does Data Integration mean to a successful organization in the gaming, entertainment & hospitality industry? It means everything if it’s done right! The comparison of these industries is important as the event (occupancy) is time bound and there is a cost attached to its expiry.

Every single day, the gaming & hospitality industry faces a new and growing challenge. Consumers are demanding more from businesses. They are seeking relevance and customization.

I have tried to relate, collaborate and identify the key requirements of this industry from two perspectives: as a customer and as a data integration architect. This article describes data integration as the underpinning service that can take advantage of the information embedded in the data, and play many interesting roles in predictive analytics.

Let me present few examples to delve into this:

Challenge 1 – Does your organization suffer from poor data integration?

Customer’s dilemma: I travel by air quite regularly. I do my own reservations. Every time I book the ticket, the airline prompts me to get my own seat- in spite of my traveling many times on the same airline, with a preference for a particular seat, say 1A (Even when the seat is not taken!). I would be a very happy customer if they knew their loyal customer’s (My!) preferences.  Is it too difficult for the airline to track my preferences in one place?

Architect’s perspective: This is a classic example of data integration not designed well. The answer is NO; it isn’t difficult to remember the customer’s preference. In such a scenario it is essential to architect and design a system that will capture the relevant data; in this case, store information about the customer’s profile with preferences.  Preparing data to accommodate these analytics is essential to success.

Challenge 2 – Increasing the effectiveness of data access and analysis

Customer’s dilemma: I am a creature of habit. I know when exactly I want to take my time off to go my favorite vacation spot -Las Vegas.  What interests me the most in Vegas? Casino games, good food and some rest & recreation with my friends.  The irony is that I am invited to shows that I don’t go to, to games that I don’t ever play and least of all, asked to visit them in a season that I have never gone in. The bottom line is – my ‘favorite’ casino never understood my needs!

Architect’s perspective: This is an ideal scenario to perform customer profiling. It’s critical for the design of a data integration strategy to be governed by the reports that the casino could use for their email campaign. It is always crucial to remember how data is relevant to how it’s being used. Systems can be designed to understand ROI for these campaigns by tracking conversion ratios.

This illustrates the need to consolidate additional information to help maximize value; get data from different sources to create a total view for segmentation. Only when you construct this single view, can you analyze and profile your customer and know what you want to offer each of them.

Some of the different sources of data could be;

  • The different spend on each category at the hotel – measure, analyze and report on gaming vs. non-gaming activities (such as hotel, spa, entertainment etc.)
  • Integrate financial information and measure level of success/failure at gaming.
  • Integrate financial metrics with customer satisfaction feedback to measure likelihood of retention/loyalty.

A consolidated analysis can identify your best (most profitable) customers, their preferences, their customer satisfaction scores, their response to promotions and resultant loyalty/visits and spend.

Challenge 3 – Getting the big picture

Customer’s dilemma: My friends do not play the tables, but they hone in on the slots.  A few spend time in shopping and a few in an extravagant spread at a fancy restaurant.  I, on the other hand like to do it all.  Well, may be a little less on shopping. To be honest, I expect comps when I spend a lot of money at the table. And ‘when’ I get comped lies in the hands of people who are taking note of what I am playing, how frequently I play and of course how often I win. Case in point, on my last trip to Vegas, I had to write an unhappy note to my casino host who said I did not play enough for him to comp me, but finally had to succumb to the pressure of losing me altogether to another casino. It is pretty sad that they could not see my contributions to their revenue and profits in one single view.

Architect’s perspective: To understand what the consumer’s interests and activities are, it is important to build a comprehensive method for rating the consumer across gaming and hospitality. It would add a tremendous value to design a system that provided the host with the details of the customer’s expense and ratings, both past and current. With such a system in place, the host can address what it takes to retain the right customer.

For this, we as data integration architects need to understand and identify the KPIs that could impact the business.

Smarter Integration- Holy Grail of Business Intelligence

Data Integration gives you access to a unified view of each customer of your organization. It enables a “360-degree view”. This is the key to unlocking the potential value stored across the numerous data sets and reports floating around the organization. Customer analytics enables a business analyst to gain greater insight into historical customer activity and enhance ongoing customer interactions. Assessing customer profiles can drive decisions based on predictions of customer behavior. Clearly, data integration is critical to this process since you must have access to all the information about a customer along with the customer’s history to build customer analytics.

The design of a good data integration process often may not seem economical at first, but a bad solution having the upfront savings are often quickly lost as demands on resources increase. A well-designed data integration strategy ensures consistency and unanimity of the enterprise data architecture. It ensures that there is common business language and uses the same semantic definitions.  It includes capabilities such as metadata integration, ongoing updates and maintenance, access to a wider variety of data sources, and design and debugging options.

I see this as both an art and a science to design effective data integration architecture.  And to provide this information real time would empower even the line employees and supervisors with the information necessary to impact business.

In this era of cloud computing when there is potential data prevailing in reservations, point of sale, gaming floor data, slots data, sports booking data, financial data, customer service, customer loyalty, campaign data, web logs, mail, email, media and social networking, it is a good gamble to bet on service oriented data integration strategy to keep the momentum going. Turn all the glitter into gold!

Srinivasan Ramaswamy

Srini Ramaswamy is the COO & Co-Founder of Systech Solutions Inc., a LA based Business Intelligence firm specializing in date warehousing & analytics solutions for gaming, entertainment & hospitality industry. He can be reached at srini@systechusa.com or 818-827-5646

Systech Corner , , , , ,

MicroStrategy Implementation

February 23rd, 2010

Background

In this case study we describe how a leading specialty retailer achieved a greater insight into Key performance and Sales metrics through Systech’s MicroStrategy implementation. The MicroStrategy implementation supported business users to analyze sales and inventory to identify key trends and opportunities.

To accommodate their expanding business the client sought a platform to support complex data analysis that is user friendly. Formerly they depended on time consuming and less efficient POS System.

After evaluating several Business Intelligence vendors, they chose Systech Solutions Inc. to meet their needs for identifying the key trends and making informed decisions. Systech Solutions, Inc. was assigned to design an Enterprise Data Warehouse (EDW) for them in this regard.

Challenges

The client required a detailed access into a variety of business data to allow the business community to analyze their data in greater depth. To offer a simplified and integrated solution for a profitable growth Systech had to address certain challenges.

  • To track trends and identify opportunities. Since the data was spread across disparate systems it was a laborious process.
  • To manage overwhelming amounts of data from various sources—and turning it into reliable business intelligence that enabled better business outcomes.
  • To effectively design EDW for consolidated reporting both from in-house applications, JDA and PeopleSoft.
  • To configure and implement a scalable tool to query the EDW and to create reports.
  • To build a system that would distribute reports with in a 24 hour window every month.
  • To provide a platform that could keep up with constantly evolving user requirements.

Solution

Systech Solutions fashioned a business intelligence environment that comprised of a Netezza data warehousing infrastructure, a DataStage ETL environment and a MicroStrategy reporting environment.

The Systech team successfully achieved the extraction, transformation and loading of the source data into a data mart schema through an ETL process. The team made sure that the information was accurate, consistent, and optimally organized for complex analysis. The EDW was effectively designed for consolidated reporting from in-house applications, JDA and PeopleSoft. Since the source data was stored in individual schemas, the transformation strategy included consolidation of information which was common to all source systems. A user-friendly OLAP data model was successfully created to store pre-aggregated data for fast ad-hoc query performance.

MicroStrategy reporting tool was configured to query the EDW and to create reports. The Systech team developed dashboards that included scorecards to allow any type of key performance indicators (KPIs) to be rolled up into a score for a particular application area, overall IT performance, or anywhere in-between. More than 32 to 40 reports were run apart from the templates during the course of the project.

The sales data (KPI’s) was analyzed to:

  • Anticipate the sales margin
  • Analyze the SKU to aggregate (or roll-up) metrics into single overall “score” for IT and the inventory data
  • Visualize store and warehouse inventory
  • Calculate profitability evaluation ratio that analyzes the firm’s ability to turn inventory into cash above the cost of the inventory
  • Study purchase orders and transfers

Result

The MicroStrategy implementation by Systech team provided the client a greater insight into Key performance and Sales metrics.
Systech developed an easy to use BI application to support their data from the users. The data warehouse was architected to support production reporting.
Multiple areas of their business used the data to manage inventory, identify sales opportunity, recognize key performers and review products.
Systech made it possible to provide customizable user experience and provide executive summary reports, analyze sales promotion and study products sales.
Systech created a robust architecture and a flexible platform. This architecture combined right level of access with required functionality and resulted in a positive user experience.

Systech Corner , , , , , , , , , , ,

Data Warehouse Appliance – The Next Generation Appliances

December 17th, 2009

Fast emerging and dynamic global economy have made quick and easy access to information. It has become mandatory that organizations understand and respond quickly and appropriately to unanticipated changes in operations and marketplace. Data warehouse appliances make data warehousing simple and powerful. They enable high performance data warehousing at a lower TCO. Using DW appliances businesses can build BI projects that were previously not possible. Many new data warehouse appliance vendors are now extending their products to support more complex workloads that offer additional capabilities and utilities for BI application and are changing the way that business thinks about data warehousing.

This research paper describes the nature, importance and benefits of “Data warehouse (DW) Appliances” and its use for business intelligence (BI) and data warehousing (DW). It also highlights a variety of other aspects concerning DW appliances such as the differentiators among DW appliance products, Total Cost of Ownership, things to remember while reaching a buy decision for DW appliances etc. The report also includes a note on the future of Data Warehouse Appliances in ever changing, dynamic BI industry.

Register here to request the white paper.

Systech Corner , ,

A white paper: Operational BI

November 4th, 2009

Operational BI represents one of the fastest growing areas of business intelligence. It has the potential to inflate the benefits of BI usage throughout the organization to a user audience that has been unable to benefit from BI technology. It can provide noteworthy benefits, however operational BI must be implemented carefully. It requires a sound and robust underlying infrastructure and database processing environment.

It is important to remember, that most operational BI applications do not call for close to real-time operations, and to facilitate most users would be quite happy if action times can break the 24-hour barrier and help them make intra-day decisions.

Hence a well selected operational BI project will perk up the responsiveness of the organization, whereas at the same time it will also deliver measurable results that produce a sound return on investment.

Register here to request the white paper.

Systech Corner , , , , , , , ,

Improving Behavioral Health Processes and Outcomes

September 4th, 2009

An interview with Suresh Bangara, MD, CEO of Hippocrates Gate, LLC.

President Obama’s support for electronic medical records is one of the key efforts of healthcare. “This will cut waste, eliminate red tape, and reduce the need to repeat expensive medical tests” said Obama. “It just won’t save billions of dollars and thousands of jobs — it will save lives by reducing the deadly but preventable medical errors that pervade our health care system” quoted Obama in reference to computerizing all health records within five years to boost the quality of health care for all Americans.

AccessHSI helps HealthCare Providers (HCP’s) and Managed Care Organizations (MCO’s) to manage the administration of mental healthcare. The application enables clinicians to quickly capture complete case information, verify diagnoses, check level of care guidelines in advance, and generate a full report that demonstrates medical necessity. It has been estimated that 80% of healthcare administrative costs can be eliminated by the adoption of improved and automated technologies for data collection, sharing, and decisioning. AccessHSI is designed to help providers improve operational efficiencies, quickly document cases, support diagnoses and suggest level of care.

The application was built by Team Systech collaborating with Medical domain experts from Hipppocrates Gate, LLC. The team was headed by Ramakrishnan Rangananthan acting as the Lead Architect – while the development was headed by Venkataragavan from Systech India. Dr Suresh Bangara captured the essence of multiple years of treating and administering the treatment of mental healthcare – and provided the subject matter expertise for the application.

Dr. Suresh Bangara has more than 20 years of experience in health care industry especially in mentally health. He has worked with mentally ill patients both in public sector as well as private sector. He has been in charge of partial hospitalization programs across the country. Dr. Bangara has also been involved in the start up of a HMO a director for Pro-health plans and has deep understanding of individual, group and hospital practice. For the past 2 years he has been a professor and currently he is the Senior Medical Director at Cigna.

In this BI Insight, we feature an interview with Suresh Bangara, CEO of Hippocrates Gate, LLC. The interview examines his company’s latest application that could potentially revolutionize the health care industry by providing an efficient and cost-effective solution.

BI Insight: What is AccessHSI and what is its role in Behavioral Healthcare?

Dr. Bangara: AccessHSI is a secure web-based decision support application with a reporting tool for Level of Care. It reduces administrative time and denials for mental health and substance abuse inpatient and outpatient cases. It enables clinicians to quickly capture complete case information, verify diagnoses, check level of care guidelines in advance, and generate a full report that demonstrates medical necessity in less than 10 minutes—compared to the 45 minute norm. This allows MCOs, and other health planners to automate most routine care management processes, thereby allowing care managers and Medical Directors to focus on complex and specialty cases. Also it is easily accessible and user-friendly .

BI Insight: What do you think are the core problems with healthcare today?

Dr. Bangara: Lack of proper and complete documentation is the root cause for an expensive and prolonged health care process. Also, there is a huge administration burden on clinicians as they have to also act as care managers and provide all authorizations.

How does your application help overcome these problems?

Dr. Bangara: The reason for most denials is lack of proper documentation or that document does not support the claims of the doctor. Our software recommends objective and accurate healthcare at the right level and at the right time. This will save hospitals most of the administration cost. In addition to efficiently providing complete clinical documentation, our software demonstrates to MCOs, a hospital’s ability to self-manage. Thus it increases reliability and efficiency of the operation. AccessHSI standardizes the diagnosis and suggested level of care.

BI Insight: How does AccessHSI provide consistent care and accommodate a variety of patient conditions?

Dr. Bangara: AccessHSI software asks specific questions across different domains which can be mapped to 7 diagnostic domains covering a 360° view of patient status. These domains are Symptom Severity, Lethality, Psychosocial Support, Functional Impairment, Medical Conditions, Patient Resources and Provider Resources. These questions are answered by the patient or patient’s care takers. Thus, patient’s clinical status is quickly documented across the 7 diagnostic domains and a diagnosis can be verified by a care provider in less than 10 minutes. We allocate a level of care based on a logic that uses information from all 7 domains.

BI Insight: What role did Systech play as a technology partner?

Dr. Bangara: Systech played a key role in automating the process to increase efficiency and lower cost. This enables providers in completing initial patient clinical record and generates a complete report in less than 10 minutes; updates to a record can be completed in less than 3 minutes. Traditionally, 60-80% of the administration costs went to gate-keeping functions which are eliminated by AccessHSI. This reduces millions of dollars spent on gate keeping and makes healthcare affordable for all.

BI Insight: What reporting services and analysis did Systech enable for the application?

Dr. Bangara: Being well equipped in resources and experience to provide Analytics in healthcare, Systech played a key role in developing reporting services and analysis. The output generated by AccessHSI application generates a comprehensive report containing text, domain graphs, DSM. Graphical Display of Severity Index in Seven Domains and helps care managers and providers focus on the domains with high severity for targeted interventions. These outcomes can be measured. The case tracking provides visibility of the changes and improvements in patients, over time and over sessions or in comparison with others.

BI Insight: And how does Systech play a role in Predictive modeling?

Dr. Bangara: Use of Systech’s analytics capabilities enabled Predictive Modeling for us. Predictive modeling in healthcare has the potential to identify cases with increased risk for re-admission. We can compare output of an individual profile across the 7 domains and to profiles of other patients in the database; we determine the level of care that is required. Systech’s ability to help in improving efficiency is widely accepted and Obama administration has stated that they are looking at IT in helping with reducing the costs for providing health care.

Patient information confidentiality is very important in healthcare, how does your application ensure patient confidentiality?

Systech played a very critical part in ensuring that the software is in full compliance with HIPAA guidelines. This is very crucial to keep the data confidential and secure. We chose Systech as our technology partner because we needed an IT partner who understood the importance and criticality of data we gather. Systech is an expert in arranging database administration, design, development and maintenance. Patient module in our software has very sophisticated security privileges. Systech has done a great job in designing and coding this application.

BI Insight: How and why did you choose the name “Hippocrates Gate” for your company?

Dr. Bangara: One of my co-workers brought that up. Hippocrates is the father of modern medicine. AccessHSI is a health status indicator. Health and illness are in continuum; we are able to watch and measure these domains. One of the domains is AccessHSI. Whether you are healthy or ill or severely ill, we constantly measure it. It maps to whatever level of care you need. It is therefore a gateway to different aspects of health. If you are looking at integrated health, you get an insight into diagnostics, predictive modeling, and levels of care. AccessHSI is a bridge- and a gateway to various outcomes of health. That is why we thought it would be apt to call it Hippocrates Gate.

Systech Corner , , , , , , , , , , , ,

BI in Healthcare

June 30th, 2009

Abstract

Healthcare delivery in the United States has been undergoing major changes. Move towards Market driven healthcare, internal and external restructuring of healthcare delivery systems and increasing sophistication of information technology are all key drivers for accelerating the pace of change in recent years.

All players in the Healthcare value chain – Patients, Providers and Payers are impacted by these forces. Today healthcare faces additional challenges, of escalating pharmaceutical costs, labor shortages, questions surrounding quality of care, compliance with regulations (such as HIPPA).

In this paper, we will primarily focus on the issues relevant to Health Provider Organizations and how BI technology and analytics would meet the challenges of regulations, privacy and data volume of healthcare.

Introduction

According to Health Leaders, a health industry publication, more than 150 Provider Organizations across the United States have gone bankrupt or closed in the past ten years due to financial instability. Many more will meet the same fate unless steps are taken immediately to get a better handle on financial performance and improve operational efficiency substantially.

Healthcare Value Chain

1

To meet the challenges and to ensure the long-term viability, Provider organizations require well-designed, efficient, and integrated clinical, administrative, and financial processes, and the ability to make “informed” decisions. The key to designing effective and efficient processes and to making sound decisions is the availability of high quality, integrated information delivered when and where it is needed, in a manner useful to knowledge workers, decision makers, and healthcare consumers.

Opportunities for cost savings in US Healthcare Industry ($ billion)

2

Business Intelligence systems can help Provider Organizations face these challenges

To proactively and more effectively manage information, the provider organizations require a more comprehensive framework – system and processes, than the traditional IT systems. We believe the answer is Business Intelligence. The Gartner group defines Business Intelligence as the process of transforming data into information, and through discovery, transforming that information into actionable knowledge. Thus BI is not a specific technology, or a single data warehouse, or a single analytical application. Business Intelligence is the process that is supported by people, information, and technology for improving the effectiveness and efficiency of an organization.

We have outlined a Business Intelligence Framework for Provider Organizations. BI systems will enable provider organization track utilization, monitor costs and revenue, and develop and live within fixed budgets. Reports and analysis from the business intelligence system will help identify cost trends, patterns and abnormalities and pinpoint financial weak spots. Leadership is then empowered with the knowledge and information to directly influence the performance and bottom line of the organization. A recent survey of senior executives from Healthcare Organizations revealed that Business intelligence systems are primarily used in financial analysis, but increasingly assisting in clinical research, performance measurement, physician profiling and other clinical and operational analyses

Business Intelligence Framework

3

What are Business Intelligence systems used for in your organization?

  • Financial Analysis
  • Operational Analysis
  • Budgeting
  • Cost Accounting
  • Clinical Research
  • Program Development
  • Market Research & Analysis
  • Disease Management
  • Case Management
  • Clinical Reengineering
  • Physician Profiling
  • Supply Chain Management
  • Analytical Customer Relationship Management
  • Physician Profiling
  • Performance Management
  • Case Management
  • Operational Analysis
  • Budgeting
  • Market Research
  • Clinical Reengineering
  • Customer care Analysis
  • Protocol development
  • Risk Management

We will outline below some key areas where Business Intelligence systems will provide direct impact in improving financial and operational performance.

Negotiating Adequate Capitation Rates

Often health plans give physician organizations a monthly per-member fee (capitation fee) for providing care for their members. Health plans also delegate to these groups the responsibility of spending the money, deciding on care, and making payments to physician members. Some industry experts believe that root of provider organizations failure is inadequate capitation rates set by health plans. But, many provider organizations lack the information needed to pinpoint this issue and negotiate better terms with health plans.

Business Intelligence solutions with complete financial and operational data and analytic capabilities can help these organizations to understand the level of contracting and capitation rates at which they will achieve desirable economies of scale and profitability. This will empower the management to negotiate appropriate contract terms with health plans.

Controlling Operational Costs

With escalating healthcare costs, it’s important for provider organizations to understand their flow of expenses and how to control them. Prescription drug prices have gone through double-digit percent increases; Health professionals are in short supply and substantial increases in salary, benefits and bonuses are needed to lure and retain them. Administration of complex health plan contracts necessitates high overhead and administrative costs.

In this environment, it’s more important than ever for provider organizations to monitor their costs closely. Business Intelligence systems will enable the organization to track cost patterns over time and identify areas for reduction for controlling the budget. This is a vital part of financial management and if handled inappropriately, the organization can quickly become financially over extended.

Curtailing Unnecessary Losses

Provider organizations must protect themselves from unnecessary losses, such as treating patients not covered by their group or health plans and having extensive out-of-network referrals to specialists. This cost could be substantial and usually have to be absorbed by provider organizations. Streamlining authorizations, eliminating duplicate claims and preventing treatment of ineligible patients can help save the provider groups large amount of unnecessary losses.

Here again Business Intelligence system will help identify the extent of these losses and bring management attention to these issues. It will help identify the risk group of patients based on historical data and predictive analysis. It can track physicians who are likely to refer out-of-network specialists extensively and allow management to take needed action.

Sharing the Risk with Health Plans (Payers)

Health Plans also realize that their success depends on the survival of well-run provider organizations. Whenever provider organizations go bankrupt and close, all the players in the value chain – patients, physicians, insurers and regulators are all affected as they scramble to ensure the delivery of care. This is a costly proposition to Health Plans. Hence, Health Plans and Managed Care organizations are always concerned about long-term viability of the Provider Organizations that they deal with. They are willing to share the risk with provider groups that have a proven track record of success with these risk-based contracts. They are more committed to paying actuarially sound rates that reflect the actual costs of care to these provider organizations.

A provider organization, with a sound business intelligence system and analytical capabilities that can track costs and control budgets, has a better chance of gaining confidence and trust from health plans, which in turn, paves the way for sharing the risk with them. As a result, provider organization can negotiate better terms and lower the overall financial risk to the organization.

Providing Incentives for High Performers

For the provider organization to succeed, it must motivate individual provider members to control costs and improve on utilization while achieving quality outcomes and high levels of patient satisfaction. How can an organization achieve this objective? It must develop appropriate incentive programs and provide a financial stake to the physicians in improving care, quality, and outcomes while controlling costs. The compensation plan should be structured to encourage physician behaviors that ultimately achieve the organization’s objectives and allow for members to be liable for the same risks as the organization.

Without a properly defined data repository with historical data and analytical system, organizations will be unable to track physician performances over time to implement such a compensation plan. Business intelligence system will provide the data required and the tools needed to analyze and develop appropriate incentive plans and help track the adherence of these plans by individual members.

Alert System for Early Detection of Financial Risks

The recent sudden failures of many provider organizations have shown that these groups did not have early warning system to detect potential risks and take immediate measures. Through business intelligence system, set of key performance measures and metrics could be tracked over time and reported periodically to the CFO and other senior management. These reports could be sent automatically to the designated management members and alerts can be triggered if performance metrics fall below certain threshold values.

Tracking Clinical Outcomes of Different Treatments

We have primarily focused so far on the key financial and operational efficiency improvements that could be achieved by health provider organizations in rapid time frame with the implementation of a sound business intelligence system. But the value of this system is not limited to the financial performance alone. Business Intelligence systems can also help track clinical outcome of different treatment options through historical patient record analysis and provide physicians with the means to better understand the effectiveness of these treatment options. Although treating any one patient will involve a unique combination of complex decisions, aggregating patient populations and examining variations in physician decision-making will yield valuable insights for practitioners.

Customer Relationship Management

The government and patients are demanding that health providers create and improve internal systems to provide better service, minimize errors and improve clinical outcomes. Patients are pushing back at provider systems for accurate and comprehensive record keeping. A healthcare system overwrought with inconsistencies and errors can prevent even the best organization from developing strong relationship with its patients. A business Intelligence system that integrates patient data across the enterprise and make it available at the point-of-service will help provider organizations to improve customer service, reduce medical errors, improve productivity and enable patient-centric processes- the prerequisite for improving the care delivery process.

Spending on information technology has been historically low in the healthcare industry and especially so with provider organizations. But, as we noted earlier, provider organizations are facing great challenges than ever before now. Status-qua will only speed up reaching financial dire straits sooner. Provider organizations need to act quickly and invest in appropriate information technology that can immediately help them in identifying financial weak spots and implementing cost control measures. Business Intelligence System has proven to be the key enabling technology that will take all the raw data that is collected in these organizations and turn them into actionable information to empower the leadership to directly influence the bottom-line of the organization.

Systech Corner , ,

Systech’s Outlook on Outsourcing to Emerging India

May 27th, 2009

“Systech’s outlook on Outsourcing to Emerging India”, a BI Insight Interview with Maruthu Pandian, VP Operations India, Systech India Pvt. Ltd.

Although things look gloomy for the larger global economy, in an economic downturn, cost will trump value considerations. Many organizations that are not outsourcing will consider or move aggressively to outsource their IT or business processes to focus on their core business.

In such a state of fierce competition in outsourcing, what is the Mantra that Systech India is adopting to stay a Strategic leader in Offshore Development? This interview with Maruthu Pandian, Vice President India-Operations, Systech India Pvt. Ltd. discusses Systech’s priorities and expectations in offshore development and Outsourcing to India.

BI Insight: What specifically are your roles in Systech India?

Maruthu: My focus is to encourage innovation, quality management and stream line operations right from identifying talent, developing skill sets to forming project teams. I am also responsible for customer experience and employee satisfaction.

BI Insight: How organized is the Outsourcing Model in Systech India?

Maruthu: Our outsourcing model is built on the three pillars; Integration, Intelligence and Innovation. I call it the 3Is. These are bunch of initiatives that are aimed to help our client achieve their BI strategies.

Integration – we have well structured strategies to efficiently execute processes that provide a seamless platform with the required collaborative tools. This enables all the stake holders; onsite, offshore and our customers to get interconnected and efficiently handle project scenarios particularly those that require some level of collocation.

Intelligence – in this stream we focus on our abilities to mobilize the intelligence created within the company over the years and apply it in every project task to attain excellence.

Innovation – we have devised mechanisms to constantly implement change in the way we deliver our project or create significant new efficiencies.

BI Insight: What is unique about Systech’s Offshore Technology? And how do you deal with the competition?

Maruthu: We offer the best customer experience whether it’s new BI application development or support work. Our offshore technology framework is designed after analyzing the processes from both the customer’s perspective and project team delivery point of view.

BI projects specifically have lot of customer touch points even before the start of the project, during the project and even after the implementation. Our technical consultants handle every touch point with good understanding of the business process that helps to interpret the data and speak customer lingo. This helps them to have a successful handshake at every point.

BI Insight: What are the advantages that Systech’s clients get by using Offshore Technology Center?

Maruthu: One, High success ratio, we have a meticulously designed mechanism that enforces process discipline among offshore project team; this helps us to achieve predictable outcomes.

Two, Ability to scale up, we hold a pool of specialized BI talent across the verticals which help to accelerate the project pace when required.

Three, Uninterrupted Service, proven frameworks like on-demand resource pool and structured transition methodologies help us to provide transparent and round the clock service.

And four, Cost Saving, Utilizing global talent helps us to reduce cost Example, Offshore 2.5 to 1 employee

BI Insight: In reference to outsourcing to India, it is said that the Indians are executers and not creators, how do you like to defend that?

Maruthu: The advantage I see India have is that it is both an executor and a creator depending on the opportunity presented.

As Economies grew, the immediate business opportunities were more of service in nature than innovation. When the outsourcing opportunities sprouted, India Inc. entered the market right on time and delivered IT and ITES services across the globe; being an early bird enabled to position itself as the market leader in global offshore services.

Having picked all the low hanging fruits, India Inc. has already started moving towards innovation track; driven more by market demand than by choice, I would say. Nano car is a classic example of demand-driven innovation.

BI Insight: How do you respond to the changing market conditions?

Maruthu: We are much focused and have a flat organizational structure that gives us the advantage to quickly respond to demanding market conditions.

The recent trend in offshore market is that clients require greater specialization and a clear view of what offshore consultants do. Our expertise enables us to provide analytics for every business function which is more customer specific than industry specific. Using collaborative tools systems (MS SharePoint and Wiki) and application sharing software provides greater visibility to our process.

BI Insight: Please elaborate on how Vtrain has helped serve Systech’s offshore development center (ODC)?

Maruthu: Vtrain is an in-house built web-based application that helps to identify resource for project deployment, monitor the training programs and organizational talent development. Vtrain Analytics help ODC to align talent development with sales pipeline and forecast.

BI Insight: How different is the outsourcing market now compared to when you started in 1996?

Maruthu: Earlier, companies were looking for offshore service provider to manage non-core operations at low cost. Now it’s much more than moving some functions to lower-cost locations. It’s about rethinking how a company has to organize itself to support the business. I think the current trend is to retain functions that require substantial costs to implement, like R&D and manufacturing and move functions that will realize positive return on investments more quickly such as IT and ITES services.

Systech Corner , ,