Overview

TresVista is a leading financial services company, founded in 2006 and has its headquarters in Mumbai India. With a team of 500 employees TresVista generates a revenue of USD 7 million annually.

TresvistaLogo

Client

TresVista has a lot of clients and wanted to make sure that for all the documents its employees worked on would follow the same guidelines as provided by the client. TresVista started looking for a plugin for word, excel and powerpoint that could control the stylings according to the brand guidelines for its employees working on different projects.

Brand guidelines include font settings, color, chat styles, object styles etc. and all of those styles should be pre-configured on the plugin and should restrict the user to only use the styles allowed by the brand for that project.

As there was no ready to use solution available, they decided to hire a development company and have it custom developed. They contacted MetaDesign Solutions and contracted us for the development of these plug-ins.

Problem

  • The plugin should work on Word, Excel and Powerpoint.
  • It should be able to preconfigure the style settings for different projects.
  • It should retain the formatting when the data is copied between Word, Excel and Powerpoint.
  • It should restrict the user to use the style settings depending on the project he/she is working on.
  • The plug-in should integrate with active directory and fetch user profile details based on his AD user
  • Admin Panel should be a web based application hosted on cloud.

MDS Solution

The team at MetaDesign Solution came up with the solution that involved two components

  • Component 1: Web based Admin

    The functionality of web based admin was to allow admins to configure the users and different style settings and associate styles to different projects, and then those projects could be assigned to different users. To do this the web admin panel was integrated with an active directory for login. Web based admin panel is currently hosted on AWS in Mumbai. Admin panel was developed using Angular in the frontend and ASP.Net MVC for backend API.

  • Component 2: Office Add-ins supporting Desktop PC

    The second component of the solution involved Add-ins for word, excel and powerpoint supporting desktop PC versions. User is identified based on his Active Directory profile. When the user starts any of his Office Applications such as Word, Excel or Powerpoint, a list of projects is fetched from the central admin application and shown to the user to select the project he wants to work upon. Based on the project selected, office application is configured to use the style settings defined for the application. If he is working on project xyz then the plugin will restrict him to only use the styling associated with xyz project in the admin panel. The Add-in also allows users to copy past items within office applications retaining style information.

Business Impact

In conclusion, the new solution has resulted in better efficiency and accuracy:

The users are more efficient, they are able to save 40% of their time and are able to do more projects in the same amount of time. Now they are able to produce more accurate documents, which are in line with the brand guidelines of the customer. This has helped reduce the number of review cycles from 4 to 2. Thus, saving time for the client and TresVista employees.

The new plugin has also impacted the business in terms of reduced cost of doing a project and they are also able to reduce the time taken to complete a project, ie, the same person can do more projects in the same amount of time. Accuracy level has also increased which is making it less painful for the customer to review the documents.

They Trust Us

mds

Client Reviews

Overall client rating is 4.9 out of 5 for MetaDesign Solutions by 500+ clients on
2000+ projects.

I would recommend MetaDesign for anyone looking for Plug-in Development or Workflow Automation using InDesign or InDesign Server. We had a fairly complex InDesign Workflow problem to solve; MetaDesign provided just right the set of suggestions and built custom stuff which was required.

James Walter
Vice President, PublishWise

“We really enjoy working with MetaDesign and his team. Our first project has suffered some delays, but MetaDesign never compromised on the final quality of the product and our full customer satisfaction. Today, the product in service delivered by MetaDesign is the foundation of our personalized books business, and has allowed us to reach an amazing productivity, and getting rid of the human error factor. We see MetaDesign as a real partner for our IT projects and recommend them to anyone”

Mathieu Landman
https://www.unique-editions.co.uk/

“MetaDesign is wonderful to work with; reliable, responsible and the finished product is just what we wanted.”

Cassandra Myer
Production Engineer, Product Services, Atex

“I feel sick when I am unable to point finger at someone. Alas! MetaDesign makes me feel sick by giving me no scope to point a finger at their work.”

John Sean
CTO, Brisbane
1/