DST turns financial planning, budgeting and cash flow forecasting data into actionable information that improves business performance.
Whether you require a total project solution, full or part-time staff augmentation, DST works with you to develop the strategy and solution that is tailored to your business requirements.
DST services include:
● Project Management and Business Analysis for Budgeting and Cash Flow Forecasting, Financial
Reporting, Performance Measurement, Sales and Operational Analysis.
● Data Base / Data Warehouse Architecture Design with Oracle, DB2, Sybase and Microsoft Sql Server.
● Essbase OLAP Cube design, development and implementation.
● Web based reporting solutions: Hyperion, Brio, IBM, Applied OLAP, Cognos.
● Essbase Application Integration with SAP, Oracle/Peoplesoft, JD Edwards, Lawson.
● Production and technical support service programs tailored to customer requirements including
support for Essbase and Hyperion Planning.
Decision Support Technology certified Essbase and Hyperion consultant(s) deliver OLAP and Business Intelligence solutions for a variety of applications:
Advertising & Publishing
For a large National Metropolitan Newspaper Chain designed, developed and implemented Essbase Budgeting and Capital Forecasting Systems that integrated with Peoplesoft and reduced their business budgeting and forecasting cycle by over 50%.
For a large NY based Advertising Firm, DST successfully designed, developed and implemented a Customer Profitability System in Essbase that provided Company executives with key performance indicators and detailed insight on tracking profitability and cost breakdowns. The Customer Profitability System allowed the firm to track each customer account and marketing campaign to make more effective customer pricing decisions and service offerings.
Insurance & Financial Services
For a New York Investment Bank, re-architected, designed and implemented Essbase with Aggregate Storage Option to address size and performance issues for the Bank's Customer Performance and Account Profitability Analysis. Storage, Calculation and Data Load times were reduced by over 90% while increasing scalability and performance.
For the Investment Arm of the Top Ranked US Life Insurance Company, architected, developed and implemented the firm's Investment Portfolio Analytics and Reporting Systems in Essbase with Hyperion Integration Services (EIS) cube management architecture and Hyperion Analyzer. Data cube size was reduced from 8 GB to 400 MB while reducing Calculation and Data Load times from 6 hours to under 15 minutes.
Pharmaceutical and Retail
For a large International Pharmaceutical Firm designed, developed and implemented Corporate P&L, Variance & Expense Reporting, and Sales Analysis Systems with Essbase. Additionally delivered several rapid turnaround systems to support specialized data collection and reporting needs.
For the world headquarters Finance Group, performed the design, development and implementation of On Line Analytical Processing applications in Essbase to support Corporate P&L Reporting, Variance Reporting and Product Profitability Analysis.
For a large International Retailer, designed, developed and implemented Financial Reporting and Business Analytics that integrate with SAP.