MS SQL Server – Envisa We enable success. Wed, 28 Sep 2016 18:02:43 +0000 en-US hourly 1 SmartBargains Launches Custom Merchandising Tue, 03 May 2016 15:10:31 +0000

Since its launch in late 2000, SmartBargains has steadily attracted a legion of loyal bargain hunters. During the period of rapid growth, two key objectives emerged for the SmartBargains merchandising and planning teams: ƒ

  • Create a more efficient means of collecting, reporting and analyzing critical business information ƒ
  • Greatly streamline the purchase order process


The Envisa Solution

To meet these challenges and sustain the company’s earlier success, SmartBargains teamed with Envisa to design, architect and implement two new systems to dramatically improve the company’s business intelligence capabilities and to simplify the handling of purchase orders.

The Results

Reduced Time to Create Purchase Orders

By dramatically reducing the time required to create a purchase order, the Envisa solution allowed buyers to focus more on critical research activities and made the buying process more efficient.

Delivered Real-Time Market and Trend Data

With the custom merchandise management application, planners can now approve purchase orders in real-time and can access essential information about market trends, product demand, and profitability to enhance forecasts.

Improved Operational Efficiencies

With the Envisa solution, purchasing is now seamlessly integrated with both the financial package and online content management system reducing errors and greatly improving operational efficiencies.

A.T. Cross Goes Global Sun, 01 May 2016 02:00:58 +0000

A.T. Cross called on Envisa to architect, design and implement an internationalized site based on an existing US-only e-commerce solution.  The goals was to enable Cross to provision and operate localized e-commerce solutions—that differ in product mix, pricing, language, currency, promotions, etc.—in target markets across Europe, North America, and Asia based on a central global platform.

The Envisa Solution

Envisa was responsible for consolidating two discrete, separately maintained and supported e-commerce assets [one in the US, one in Europe] into a single, centrally maintained solution.

The Results

Strong Global Brand with Consistent Presence

The Cross globalization project provided a common user experience and brand presentation across all target markets thereby solidifying the global brand and improving Cross’s market presence.

Improved Overall Growth and Reach of Business

The Envisa globalization solution leveraged robust product data, creative assets, and marketing content across all supported locales and enabled rapid, low-cost expansion into new markets to drive the overall growth and reach of the business.

More Efficient Use of Marketing Tools

The new Cross global platform provided a balance of the flexibility needed to optimally service local markets with the efficiency afforded by allowing for centralized management of core/common information.  It also enabled investments in new end-user capabilities, infrastructure, and technology to be leveraged across multiple regions/markets.

Yale Improves Service with BI Solution Sun, 01 May 2016 01:26:32 +0000

Maintaining their signature high level of service at every point along the purchase life cycle is a top priority for Yale Appliance, but lack of visibility into customer behavior and buying habits limited their ability to continue delivering a top-quality personalized experience for every customer.

The Envisa Solution

Envisa designed and developed a custom data warehouse and customer analytics solution that integrated in store and online data from their ERP solution. The solution also included custom integration with their email marketing and marketing automation solution. By implementing a data warehouse, Yale Appliance has been able to dramatically improve their customer service, which is a critical competitive differentiator in the high-end household appliance industry.

The Results

Enabled Targeted Marketing and Communications

Envisa’s data warehouse solution has enabled Yale Appliance to analyze their customer preference, purchase history and brand preference information to produce targeted marketing and communications campaigns, including automated outbound email campaigns, service touch points, delivery notifications and customer satisfaction surveys.

Improved Sales Reporting

Yale has improved overall sales by better understanding product performance by sales representative.


Improved Operational Efficiency with Automated Reporting

The Envisa solution eliminated manual report development by creating automated operational reports that are delivered each morning to key decision-makers.

Soundbite Measures Campaign Performance Mon, 04 Apr 2016 19:16:40 +0000

Soundbite (now Genesys) provides on-demand, multi-channel customer communication tools using voice, text, dialer, web and e-mail technologies.  To support their growing business which was generating billions of transactions annually, Soundbite asked Envisa to build a flexible information management solution that would allow them to assess customer campaign effectiveness and better support their clients.

The Envisa Solution

After gathering data from dozens of Soundbite employees, Envisa worked in conjunction with Soundbite data architects to develop a data strategy and data design to leverage existing in-house technologies to provide flexible business analysis tools.

The solution included:

  • SQL Server Analysis Services (SSAS 2005) using Oracle as the backend database
  • Several OLAP cubes and metrics designed to quickly analyze campaign performance
  • Several Key Performance Indicator (KPI) reports using the data warehouse and OLAP cubes
  • Training to enable ongoing, internal system support

The Results

Efficient, Effective Approach to Solution Development

To manage project costs, the Envisa solution leveraged existing in-house technologies with an Oracle database on the back-end and SQL Server Analysis Services (SSAS).

Clear and Timely Analysis of Campaign Effectiveness

Using OLAP cubes and metrics specifically designed for the Professional Services group, Envisa delivered several OLAP tools and metrics targeting quick analysis of campaign performance.  In addition, several Key Performance Indicator reports were developed for the organization.

Easy to Maintain Solution with Low Cost of Ownership

Envisa completely transitioned these easy-to-manage business analytics tools to in-house Soundbite business analysts for ongoing maintenance and support.

Work ‘N Gear Unlocks the Power of Data Wed, 09 Mar 2016 15:46:38 +0000

Work ‘N Gear is proud to provide the widest selection of the very best brands of work apparel and work footwear designed and manufactured for use in the most demanding service, security, and industrial environments.  What they needed was a business information solution to support their growing multi-channel enterprise that was as robust as their workwear, and they turned to Envisa to provide it.

The Envisa Solution

Using the Microsoft Business Intelligence solution (SSRS, SSAS, SSIS), Envisa designed and developed and enterprise-wide data warehouse with dozens of custom reports and OLAP cubes. Because of the flexible technical design, Envisa was able to build a solution that would provide uninterrupted end-user access for nearly ten years, even amidst multiple upgrades and a complete replacement of the underlying ERP system.

The Results

Improved Inventory Management and Forecasting

With the Envisa business analytics tool, Work ‘N Gear gained visibility into the store and warehouse inventory, customer buying behaviors and trends and other metrics that enabled more robust forecast reporting.

Quick Answers to Ad-Hoc Questions

Using OLAP cubes, Work ‘N Gear managers have been able to quickly answer ad-hoc queries, leading to improved operations management and customer support.

Targeted Marketing Campaigns

Leveraging integrated customer analytics, Envisa enabled Work ‘N Gear to initiate data-driven, targeted on-line and off-line marketing campaigns to boost sales.

J.N. Phillips Auto Glass Improves Retail Efficiency Sat, 05 Mar 2016 13:19:29 +0000

J.N. Phillips is the leader in auto glass, from mobile auto glass service to insurance replacements. When J.N. Phillips wanted help to increase revenue and improve efficiency at corporate headquarters and retail locations, they turned to Envisa. Our challenge was to develop and deploy a new point-of-sale system to the call center and 40 store locations using a redesigned back-end architecture to improve reliability, security and operational use.

The Envisa Solution

Envisa worked with J.N. Phillips to design and develop an enterprise-wide application and supporting infrastructure to allow executives to view store utilization and profitability from anywhere in the J.N. Phillips network. Additionally, Envisa assisted in the rollout of a new point-of-sale system requiring technical and business process training for over 100 employees.

In conjunction with the application development project, Envisa led a team of various technology partners including Verizon, in the deployment of a new WAN architecture across all store locations.

The Results

Reduction in System Downtime

After upgrading the technical architecture supporting J.N. Phillips, Envisa was able to improve system reliability at corporate headquarters and retail locations, thereby reducing system downtime and costly technical support.

Increased Order Volume

By enabling increased access to integrated data across all stores, Envisa provided executives with real-time insight into retail location performance and utilization, resulting in increased order volume and improved procedural efficiency.

Integration with Over 40 Stores

By implementing the new WAN architecture in over forty stores, Envisa helped J.N. Phillips reduce time and money required to develop and deploy system enhancements and improved consistency of consumer experience across branch stores.