Premier Invoicing Application for a Multi Million Dollar Pharmaceuticals agency

Client

Our Client, a multimillion dollar digital pharmaceutical agency is known as one of the major players in the Financial Services sector. They have been in the business for more than 15 years and have grown exponentially over the years.

To their credits they have a few "firsts" in the digital pharmaceutical world. Some of them are as follows

  • Introduced the first patient community portal in the pharmaceutical industry
  • Won the first Webby Award in the Pharmaceuticals category
  • Spoke at the historic FDA hearing on the Internet and social media
  • Launched one of the first pharma-focused iPhone ® and iPad ® apps
  • Developed the first pharma-friendly social sharing widget

Industry

Financial Services

Business Challenge

The Client needs the CSV data for a particular month to be imported and presented in a manner that is easy to comprehend. The data should be segregated under different relevant heads such as Invoice#, Invoice Date, Cust ID, etc. and the same should be easy to modify at the Client’s end if needed.

Solution

We at Volga Infotech are in the process of developing an application that allows our Client to import the CSV file for a particular month from different locations and download them onto this application which in turn further splits the data under the relevant heads such as Invoice#, Invoice Date, Cust ID, etc. The application also allows the Client to modify, delete and add data to the existing database.

Some of the major highlights of this application are as follows:

  • Summarized Output – The imported CSV can be imported, downloaded and then presented in a way that is easy to comprehend.
  • Data Sorting - Managers accessing the files can sort the data as per their requirement thus making the file more meaningful and useful.
  • Data Modification - The application allows the user to make relevant changes to the data. They can also add or delete multiple rows and columns at one go.

Benefits

Since the process is automated the Client saves a lot of time and effort which was earlier lost in manually updating the data from the CSV files into the required format. Features such as editing and sorting of data further allows the client to make the necessary changes without making other changes to the file.

Technology Used

Languages C# 4.0
Database CSV, JSON
WEB TECHNOLOGIES ASP.Net MVC 4.0, Javascript, JQuery
WEB SERVER IIS
FRAMEWORKS .NET
THIRD PARTY PLUGINS JQGrid
SOURCE CONTROL TFS