Archive

Posts Tagged ‘profit analytics’

Increasing Operational Efficiency using Profit Analysis

August 6th, 2010

Background

In this case study you would see how a leading wholesale drug distribution company achieved improved operational efficiency through Systech’s innovative and cost effective solution and analysis.

The client had to consolidate data from multiple transactional systems into a single enterprise data warehouse. The data consolidation would provide a single view across the entire enterprise and permit Integrated Reporting, Analysis and Decision-making, across the organization. This would provide a single Customer view/definition across the enterprise – eliminating the disconnect in processes such as sales, fulfillment and customer service & satisfaction.

The Challenge in the Details

The client had disparate source systems and multiple decision support systems where data could not be merged or consolidated. These data sources/elements did not map to the definitions in the financial systems either. They were able to generate reports at an invoice level and the reports were taking exceedingly long execution times. The challenges for Systech were:

  • To build a single repository for information – integrating data from the disparate systems.
  • To design a cost effective solution utilizing the existing hardware and software.
  • To deliver within the extremely tight timelines defined by the customer(s).
  • To enable flexible & detailed data analysis.
  • To implement the front-end application such that it could support existing requirements and possible future developments.
  • To provide visibility and insights into costs, revenues, capacity and assets, providing insight into past, present and future information.
  • To measure historical performance, profits of incoming orders, initiate trend analysis, predict and optimize costs, profit, capacity; for return on invested capital of your future business.
  • To ensure the delivery of undeniably accurate, actionable and widely accessible cost (direct and indirect), resource and capacity information enabling the client to operate more efficiently and in turn reduce cost.

The Solution

At the very beginning, it was determined that the sheer size of the workload combined with the complexity of the organizational and data issues would require a project team with strong leadership & high level executive sponsorship from the client. The tight schedule and budget constraints worked against the traditional approach of organizing a big onsite project team with the resources necessary to accomplish those goals.

Systech team decided to split the project into manageable parts – each of which would be tackled by a small team split into an On-site project lead and an Off-site project team. The Onsite-Offshore teams adopted a fast, responsive and iterative approach to fashion a solution for their part of the puzzle. Iterations of model-build-test-fix-retest resulted in a better componentized build for the Data Warehouse.

Systech teams worked in collaboration with the client to engage, understand the business requirements, craft the technical components and deliver a cost effective analysis for key business areas including:

  • CUSTOMER
    • Customer & Channel Profitability
    • Segmentation profitability
    • Sales Optimization
    • Strategic Cross-Sell
  • OPERATIONS
    • Distribution Optimization
    • Reducing Operating Expenses
    • Reengineering & Process Redesign
    • Supply Chain Measurement and Optimization
    • Resource & Capacity Planning & Utilization
  • PRODUCT
    • Product Profitability
    • Line of Business/Segment
    • SKU Rationalization
    • Brand Analysis
  • CORPORATE
    • Corporate Performance Management
    • Business Process Measurement & Analysis
    • Optimized Return on Capital
    • Continuous Improvement Monitoring

Result

  • The solution delivered by Systech not only addressed the pain areas but also provided additional benefits to the client.
  • Datawarehouse delivered to the client resulted in improved process efficiencies, faster query response times, reduced data load windows, a flexible data model to permit a wide range of analysis.
  • Systech’s solution empowered decision makers by allowing them to drill down into their data for detailed analysis.
  • Additional types of analysis facilitated by the solution include profitability analysis based on segment, insight into wholesale acquisition cost and better insights of the historical data.
  • Forecasting was a key functionality in the delivered solution. This function provided the scoring and tracking tools for business operations.
  • Systech helped pinpoint client’s unprofitable products, customers and vendors that might require renegotiation, re-pricing or obsolescence
  • Systech’s solution identified profitable products and customers and helped identify opportunities for profit improvement

Featured Article , ,

Industry News – Dec 2009

December 17th, 2009


Fordham University and IBM Launch Business Analytics Curriculum to Prepare Students for Careers

Fordham University and IBM are collaborating on a new business analytics curriculum to help prepare college students for careers in key industries such as energy and utilities, healthcare, education, transportation and public service that are expected to benefit from $1.8 trillion in global stimulus investments.

Businesses and governments are now driving transformation projects including smart grids that lower energy consumption, sensors that help reduce traffic congestion, electronic medical records for personalized healthcare and RFID tags that trace food and medicine for consumer safety. The digital infrastructures supporting these projects will generate enormous amounts of data requiring a skilled workforce to make sense of it in a meaningful way. For example, computing systems today are generating 15 petabytes of new information every day — eight times more than the combined information in all the libraries in the U.S.

In a recent IBM Global CIO Study, 83 percent of respondents identified business analytics — the ability to see patterns in vast amounts of data and extract actionable insights — as a top priority and a way in which they plan to enhance their competitiveness. As the adoption of business analytics grows within organizations, the need for analytics skills across all functions of a business rises as well.

“Analytics can vastly improve our lives and provide new job opportunities for college students entering the workforce,” said W. Raghupathi, Professor of Information Systems, Fordham University School of Business. “Fordham has a long history of collaboration with IBM that has brought innovative new skills to our curriculum to prepare students for future jobs. With this effort, Fordham is preparing students with marketable skills for a coming wave of jobs in healthcare, sustainability, and social services where analytics can be applied to everyday challenges.”

Fordham’s Schools of Business, which offers undergraduate and graduate programs in information and communication systems, is addressing the need with a first-of-its kind Business Analytics for Managers course based on IBM analytics technology. Beginning Spring 2010, students can register and get hands-on training in business intelligence, data analytics, data warehousing, data mining and online analytical processing (OLAP) techniques. Students will also learn managerial decision making and how analytics technology can improve the effectiveness of key business functions such as marketing, sales, finance, business development, human resources and manufacturing. Additional topics include:

Reporting: Students will become proficient at authoring, using and sharing any type of report — drawing on any data source — so they can present business analytics information in a consistent and easy-to-use way.

Analysis: Students will learn how to analyze and report against online analytical processing (OLAP) and dimensionally aware relational data sources. This will help them learn how to spot trends and see business issues from a variety of dimensions.

Score carding: Students will master the art of building easy-to-use scorecards to align teams and tactics with business strategy. They can communicate business goals company-wide and let people monitor performance against their targets.

Dashboards: Students will learn how to communicate complex information quickly using dashboards, which provide a single view of information that business professional, can use to make key decisions.

Business and governments alike are using the power of analytics to better manage the information explosion and make informed decisions to better serve customers and citizens.

This BI Insight news item contains information from a recent press release by the company mentioned.

Over the years Systech continues to develop skills, knowledge, work processes and technologies to effectively deliver BI solutions across the globe.

View Systech’s Training model and road to building leaders in BI

http://www.systechusa.com/training-model/


Kaleida Health Monitors Flu Cases with Oracle

Kaleida Health, the largest health care provider in Western New York, is monitoring daily cases of patients showing flu symptoms being treated across its five- hospital system with the help of business intelligence (BI) dashboard developed using Oracle Business Intelligence Suite Enterprise Edition (Oracle BI Suite EE).

The dashboard enables a team of 35 at Kaleida Health including hospital presidents, Chief Nursing Officers, Chief of Emergency Medicine, Chief Medical Officer, and others, to understand trends related to patients with flu symptoms, and track trends related to staff with flu-like symptoms.

Additionally, the dashboard tracks how the trending information impacts staffing levels at its hospitals, and report the number of cases of patients with flu symptoms to the New York State Department of Health.

The Flu Monitoring Dashboard is updated automatically daily and replaces previously manual efforts by hospital staff to track patients showing flu-like symptoms from reports run daily.

Flu Monitoring Dashboard Part of Broad BI and Analytics System Deployed by Kaleida Health

Kaleida Health’s Flu Monitoring Dashboard highlights:

Current in-house patients with flu symptoms in aggregate, per hospital and as a percentage compared to the total number of in-house patients across Kaleida Health hospitals;

Graphs tracking trends of patient visits to Emergency Departments with flu symptoms at each of Kaleida Health’s hospitals;

In-house patient and outpatient with flu symptoms trends over the last 13 months; and,

Total number of Kaleida Health employees calling in sick with flu-like symptoms by day, by role and by hospital

The Flu Monitoring Dashboard, prototyped and developed within a week’s time in September 2009, is just one of over 25 executive dashboards available to Kaleida Health’s management team via the organization’s “Magellan” Balanced Scorecard system, which is powered by Oracle BI Suite EE.

Magellan helps Kaleida Health’s management team monitor metrics and Key Performance Indicators across five categories: Financial, Quality, Staffing, Operational, and Growth and Strategic.

In addition to offering executives an accurate overview of daily operations and finances, the system’s dashboards helps guide strategic decision-making from exploring expansion and development of new lines of business, to physician recruitment and staff retention, and beyond.

Oracle BI Suite EE runs on top of an Oracle Database-powered data warehouse that includes data from various systems running at Kaleida Health including financial, billing, payroll and clinical applications.

Buffalo, New York-based Kaleida Health went into production with Oracle BI Suite EE in August 2009.

Magellan will be rolled out to over 600 employees across Kaleida Health in 2010.

“With the flu season starting up in early September, we were able to pull together all of the necessary information on a single dashboard page in about a week’s time,” said Dan Gerena, Director of Business Intelligence and Corporate Analytics, Kaleida Health. “It’s a very different paradigm for reporting now with Oracle BI Suite EE. It was a very quick process in terms of building the Flu Monitoring Dashboard, getting new users up and running, educating them on what the metrics are, and showing them how to access the dashboard.”

This BI Insight news item contains information from a recent press release by the company mentioned.

Systech offers a number of innovative solutions based on Oracle Business Intelligence Enterprise Edition. Partnering with Oracle, Systech continues to help companies manage customer, workforce and financial information.

View Systech Solutions as a leader in the implementation of Oracle based Business Intelligence solutions

http://www.systechusa.com/oracle-bi/

Systech’s Healthcare Analytics solution helps integrate patient data across the enterprise and makes it available at the point-of-service to help providers improve customer service, reduce medical errors, improve productivity and enable patient-centric processes – the prerequisite for improving the care delivery process.

View various applications and benefits of Healthcare Analytics developed at Systech.

http://www.systechusa.com/healthcare-analytics/


Sunny Delight Leverages Trade Promotion Management to Strengthen Customer Profitability

Consumer Goods (CG) manufacturers rely heavily on trade funds to proactively shape demand, influence retailers and to collaborate on marketing programs that help drive consumer behavior. While the average shopper may not be aware of it, virtually every product placement, price reduction, and end cap has been funded by the manufacturer. For the average CG manufacturer, trade spending ranks second only to the cost of goods on the balance sheet and regardless of the recent recession trade spending has not decreased in most companies.

As a result, most consumer goods companies have implemented trade promotion management (TPM) solutions with the idea of improving trade spend, automating antiquated spreadsheets or creating a better planning and forecasting process. For Sunny Delight Beverages Co. (Sunny D), a leading producer of juice-based drinks in North America and Western Europe , it was all about customer profitability.

A Sunny New Direction

After spinning off from CG giant Proctor & Gamble, Sunny D suddenly found themselves a small fish in a big pond. As a new small-to-medium-sized business (SMB), it was imperative that Sunny D not only implement new technologies, but rather use them in a way that could exploit their position as a smaller CG manufacturer and help them to better compete with their much larger competitors.

The first step in the process for Sunny D was to integrate its TPM system with its broker’s network. In order to make this happen as quickly and as seamlessly as possible, Sunny D knew they needed to adopt the right trade promotion management solution – one that would tie into the broker network while improving synergies between TradeLync and Sunny D’s financial system. Sunny D also realized, like many other CG companies, that Excel spreadsheets were not the optimum way to communicate trade promotion and/or sales and reporting activities between the Company and its broker, Acosta. Consequently, and on the recommendation of Acosta who already uses MEI for trade promotion management, Sunny D began an intensive look at this TPM solution.

Customer Profitability Will Quench Your Thirst

After a fast implementation, Sunny D’s order management and ERP systems were feeding data to the new TPM application. However, they soon began to realize that there was a lot more to trade promotion management than improving and tracking overall trade spend, so they quickly shifted their overarching goal to improving customer profitability. If they could map revenue, trade promotions, cost of goods sold, logistics and any other variable customer-related costs to finance, they could also improve the overall efficiency and revenue of the Company. To do so, this model would require them to extend the use of the TPM solution throughout all of finance, product supply and logistics.

“By gaining small wins with the MEI trade system and then multiplying those wins on an enterprise-wide level, we could really drive change across the company,” commented Chris Miller, Sales Finance Manager. “We knew that combining various data and customer touch points would allow us to identify spend by customer and see how effective we are at driving specific financial contributions at the customer level.”

Managing cash is always a priority for SMBs and Sunny D is no exception. They needed to be specific when it came to incremental trade and be able to analyze which programs could be more profitable to the business. Miller stated, “When allocating incremental trade funding, we can analyze the data to determine the appropriate investment. We recently analyzed two very similar customers with slightly different profitability to determine why there was a delta. Using the MEI TPM suite across internal groups, we identified the difference in profitability was due to logistics; not necessarily in shipping costs, but in ‘lumper’ fees and late fees. After some discussions, the customer now picks up their orders saving both Sunny D and the customer a significant amount of budget. Being able to see trade spend and revenue per customer enabled the groups to perform an accurate analysis of the situation. This resulted in a win for Sunny D and the customer.”

The TPM solution helped in other ways too. For example, the Company sells to the Military though government approved distributors; consequently, they wouldn’t normally be able to track the end customer’s profitability. By leveraging the functionality of the MEI TPM solution, Sunny D is able to drill down and see how the distributors are loading their data, which – in turn – enables Miller to gain valuable insight into how the end user is buying the Company’s products.

Sunny D also uses the TPM solution to help analyze a company after an acquisition. During its recent acquisition of Veryfine, some of the product lines were considered unprofitable. However, using the MEI system, Sunny D was able to analyze the “spend per pack size” data and determine that trade spend was a lot more efficient than they initially realized. “The ability to see the details enables us to act faster to market conditions and make the best choices for the Company.”

Sunny D’s sales force is also using the TPM application. In fact, Miller stated they use contribution to maximize the efficient use of their customer’s trade funding by analyzing top-line revenue down to cost of goods sold. ”Our goal is to make our funds work as hard as possible to grow revenue for Sunny D and our retail partners.”

Since the implementation, Sunny D has seen a higher level of efficiencies across the board, and has enlisted the help of various departments to help strengthen profits. In fact, the trade promotion management application has already helped the company exceed initial goals for the implementation. Although Sunny D concentrates on customer profitability, they also reap the more standard rewards from trade promotion management technology including simplified budgeting, planning, accruals and volume- and spend forecasting. But it’s the smaller business mentality that Miller claims is the crux behind the Company’s successful use of its TPM technology. By fully utilizing all of the functionality of its TPM suite, Sunny D has successfully managed its business through a detailed view of customer profitability and by continuing to create wholesome beverages that meet the needs of their target audiences.

This BI Insight news item contains information from a recent press release by the company mentioned.

Systech provides cutting edge Cost Reduction and Profit Improvement solutions for Retail and CPG companies. Systech enables companies in uncovering hidden profit opportunities and in creating profitable revenue growth; quickly and easily.

View various applications and benefits of Profit Analytics developed at Systech.

http://www.systechusa.com/profit-analytics/

Industry News , , , , , , , , , ,

Industry News – Apr 2009

April 30th, 2009

Systechusa.com gets a facelift!

Systech is pleased to announce the launch of a new and improved website, http://www.systechusa.com/. We’ve spent months designing our corporate website so that we could become more of a resource to you, to our current and prospective clients and partners! Our intent is to keep this an active process of updating our portal constantly.

Our upgraded Web site is easy to navigate and easier than ever to find through search engines because of the way our information is presented and Systech’s search engine optimization capabilities.

The all new http://www.systechusa.com/ is filled with exciting new content that we believe and hope you will find it user-friendly and informative. So… what are you waiting for? Check it out!

Pi and Netezza Webinar: The Power of Item Profitability Analytics

April 2009 Pi Solutions and Netezza jointly sponsored a free web seminar focused on how true item-level profitability analytics could enable Retail and CPG companies to optimize revenues for the business by understanding and assessing their profits at the most granular level.

Ernie Levenson, VP of Operations at VTech, was the key speaker at this event. Ernie discussed how VTech used profitability analytics to improve their business. Ernie shared his insights on how to successfully implement and leverage these solutions. Pi Solutions provided a brief overview of their Pi Profit Analytics™ application, built to run on the Netezza platform. And, Netezza talked about its market-leading family of data warehouse appliances.

This webinar focused on how item-level profitability enables a company to:

  • Make profitable decisions on product pricing, substitution and mix
  • Manage customer relationships and make fact based decisions on pricing and discounting, order size, delivery arrangements and supply chain efficiencies
  • Replace lowest price suppliers with lowest TCO suppliers
  • Highlight new opportunities in the business and provide financial justifications for decisions
  • Improve product development by providing product and merchandising managers information to optimize costs and maximize functionality

“The power of Item Profitability Analytics webinar” showcases how VTech was able to turn an unprofitable division to profitable one using profit analysis. It highlights how to leverage Pi Profit Analytics software and Netezza appliance to build the next generation profitability solution quickly and easily. The information in the webinar can be used by any company in increasing their own bottom line profitability through true profitability analysis. I would highly recommend it to anyone who is interested in improving their company’s profitability,” said Keshav Kuthiala, Vice President of Marketing Pi Solutions.

This event is recorded and is available on demand: The Power of Item Profitability Analytics

Oracle Buys Sun Microsystems

Apr 2009 Sun Microsystems and Oracle Corporation recently announced they have entered into a definitive agreement under which Oracle will acquire Sun common stock for $9.50 per share in cash. The transaction is valued at approximately $7.4 billion, or $5.6 billion net of Sun’s cash and debt.

“We expect this acquisition to be accretive to Oracle’s earnings by at least 15 cents on a non-GAAP basis in the first full year after closing. We estimate that the acquired business will contribute over $1.5 billion to Oracle’s non-GAAP operating profit in the first year, increasing to over $2 billion in the second year. This would make the Sun acquisition more profitable in per share contribution in the first year than we had planned for the acquisitions of BEA, PeopleSoft and Siebel combined,” said Oracle President Safra Catz.

“The acquisition of Sun transforms the IT industry, combining best-in-class enterprise software and mission-critical computing systems,” said Oracle CEO Larry Ellison. “Oracle will be the only company that can engineer an integrated system – applications to disk – where all the pieces fit and work together so customers do not have to do it themselves. Our customers benefit as their systems integration costs go down while system performance, reliability and security go up.”

There are substantial long-term strategic customer advantages to Oracle owning two key Sun software assets: Java and Solaris. Java is one of the computer industry’s best-known brands and most widely deployed technologies, and it is the most important software Oracle has ever acquired. Oracle Fusion Middleware, Oracle’s fastest growing business, is built on top of Sun’s Java language and software. Oracle can now ensure continued innovation and investment in Java technology for the benefit of customers and the Java community.

The Sun Solaris operating system is the leading platform for the Oracle database, Oracle’s largest business, and has been for a long time. With the acquisition of Sun, Oracle can optimize the Oracle database for some of the unique, high-end features of Solaris. Oracle is as committed as ever to Linux and other open platforms and will continue to support and enhance our strong industry partnerships.

Teradata and SAP Expand Partnership

Apr. 2009 Teradata Corporation, a company solely focused on data warehousing and enterprise analytics, and SAP AG, a provider of business software, recently announced at Teradata Universe a new agreement to provide SAP NetWeaver Business Warehouse (SAP NetWeaver BW) on the Teradata database. Customers have asked for accelerated, unified access to detailed enterprise data for improved business visibility. To address this need, the partnership will deliver a seamlessly integrated and scalable solution that lowers total cost of ownership and consolidates data on one database platform.

Companies around the globe use both Teradata and SAP products. Today, these customers have various databases for their data warehouses, and use different business intelligence (BI) tools to analyze that data. Most have at least one SAP NetWeaver BW data warehouse. As a result of the new agreement, customers will benefit from an integrated end-to-end offering, including everything from data warehouse infrastructure and management to BI tools. The consolidation of all data on one database platform will support joint SAP-Teradata customers’ efforts to standardize and rationalize their IT investments while lowering their total cost of ownership.

“For companies like ours that leverage massive amounts of information with Teradata and SAP, the promise of tighter integration and closer collaboration is significant,” said Joe Zakutney, Vice President, Global Applications, The Hershey Company. “Most companies realize that centralized data warehousing is the best approach for BI and analytics, and SAP software running on Teradata is exactly the kind of combination we foresee as a technology advantage in the years ahead.”

Will Business Intelligence Software Move to Appliances?

SAP-Teradata alliance, IBM’s plans and Oracle-Sun deal all point to BI bundles on top of data warehouse appliances.

An alliance announced this week between SAP and Teradata goes beyond integration of SAP NetWeaver Business Warehouse and the Teradata database. That first part is good news for joint customers who are getting by with customized integrations of the two data warehouse environments. But the alliance also points to what is likely to be a growing trend in data warehousing and business intelligence: the bundling of BI software onto data warehouse appliances.

Looking beyond support for the Teradata database, which will happen with the next release of SAP BW, the two vendors are “exploring many other opportunities to more closely integrate,” says Miles Stephenson, Teradata’s vice president of alliances. “We wouldn’t preclude some sort of a bundle… and we’ve actually looked at several of the packages that SAP BusinessObjects has put together as industry solutions.”

From SAP’s perspective, working with Teradata makes good sense. Nearly half of SAP’s top 100 customers run Teradata. What’s more, BusinessObjects was the number-one BI tool running on top of Teradata even before the BI vendor’s acquisition by SAP. As for the possibility of a joint appliance with bundled BI software, “Teradata obviously has a lot of strength in the appliance space, and it was one of the very first appliance vendors,” comments Tim Lang, vice president of product management at SAP BusinessObjects. “SAP isn’t new to appliances either, as we’ve had our Business Warehouse Accelerator technology for a number of years.”

In fact, SAP and Teradata may be responding in part to IBM. IBM has let it be known, and in an interview with Intelligent Enterprise in early March it acknowledged, that it will make its BI and information integration software available as modules. These modules will run –preconfigured and preinstalled — on top of the InfoSphere Balanced Warehouse appliances.

“Customers will be able to say, ‘I want this E-Class Balanced Warehouse on a pSeries server, and I also want the IBM Cognos module, the InfoSphere Information Server module and maybe the Optim data retention module as well,” says Bill O’Connell, IBM’s data warehousing CTO. “The appliance would be shipped to the customer data-load ready, with everything installed and configured, further expediting time to value for our customers.”

So it’s apparent that data warehouse appliances are likely to give way to complete data warehouse and BI appliances. But with its pending deal to acquire Sun Microsystems, Oracle is talking about taking one-stop shopping for hardware and software to even greater extremes, adding in applications as well as information infrastructure.

The trend goes beyond data warehousing and BI. It’s about prefab data centers, ready to plug in and go with minimal systems integration and the promise of faster, lower cost deployment.

Industry News , , , , , , , , , ,