Professional services Custom Application development Quality assurance
Onsite Off shore Fixed Price
Government Manufacturing Healthcare Bio Tech Technology Supply Chain / Distribution Finance
Work Culture Benefits Kutir connect program Positions
About Kutir
Value Propostion / Integrity Policy
Mission statement
Management
Advisors
 

 
 
 
 
 
Bio-Technology
 
About the Client:
Our client facilitates bio-tech research through its cryogenic storage facilities It was the location of the first family cord blood bank in the world and is currently one of the largest and most modern laboratory facility dedicated and designed exclusively for cord blood stem cell processing and storage.
Business Requirements:
To have an end to end web based application:

1. Application which would cater to different needs of various users both internal customers (marketing, operations, accounting, sales etc.) and external customers (Consumers or end customers).
2. It has to interlink various applications used internally, segregate data, analysis and present data to the various users appropriately to their needs while maintaining the data security.
3. The application should provide with the capability to store, track and maintain data in the database from different application sources and generate reports to be presented in a consumable format as per the target audience.
Challenges:
1. There were too many internal application used by various departments to maintain and track data as per there requirements. Some of the applications were robust enough with good report generating capabilities and other weren’t offering only with Basic reporting capability.
2. There was no centralized data storage system making the entire business information system unstructured.
3. No uniformity in data tracking.
Our Solution:
Our suggestion to their problem was four different applications which would solve the issue and bring in more structure to the Business Information system and the way they store, track and maintain data with highly robust report generation capability which is directly aligned with the Business requirements.
1. Customer Web Portal: To develop an application which has been Coded, tested and deployed with an User friendly Interface and back end components on the customer internet application. This application would enable the customers to access there own account data which is linked to the centralized database.
2. DocImage Web Interface: Using an ASP.NET web interface, developed an application to access different PDF files by calling a Web Service to get the files and transport them to web server and then open and display them to the user accordingly.
3. Provue HIBOSS: Developed a middleware application called HIBOSS middleware which provides communication between the internal business applications at the CBR Lab with the Provue instrument which creates test result of blood samples provided by the mother and baby. This is a critical application which should map the data accurately at the same time maintain security standards as this provides critical information about the customer.
4. XmlMerge: An application used to unpackaged XML files created by a internal Telephony application (Witness), updating fields within those files, repackaging them and presenting them to an application that consumes them, providing management reports. This again is a critical application as the reports generated by this application in consumed by various management people enabling them to make business decisions.
Technology Used:
Window 2003 Servers, XP, SQL Server 2005/2000 Reporting Services/SSIS/Analysis Services, SQL, VS.Net, C#, XML
How we did it:
The whole project efforts were dived into 1/3rd DBA work and 2/3rd Development work. We also interconnected and maintained user access to more than two dozen SQL Servers for both application and Backup/ restore activities. Maintaining these SQL servers is a critical factor as these store the entire database of the customers and other internal data’s for consumption. This includes maintaining multi-server links, DTC, delegation and other advanced security issues; as well as performance management on structures such as indexes and queries, and strategic data location and movement. Also included are setup, maintenance and use of multiple Reporting Services, SSIS and Analysis Services servers.

This enabled CBR to achieve highly efficient and robust report generation system which gave an easy access to reports from the Microsoft Dynamics GP with Drilldown actions, open reports within reports, Chart options, customization and flexible report view and gives capability for tailor made reports.

The other accomplishment was to create a Multi- GB Database and supporting code that acquires, maintains and operationally manage (7x24) 20+ tables of Siebel Production data for analysis and reporting purposes. To maintain up to data information the DB was designed to run in few seconds for each hour. This enables all the customer and sales information are up to date and can be consumed by the Sales, marketing, operations and 3rd party access etc without locking and blocking the large number of data flow to and from the Siebel services and interfaces. Our development work enabled full set of field sales operations reports for 50+ national field sales personnel and their management and support specialists accessible and customizable to the management of various levels to make better business decisions. This included setting up and maintaining the organizational data—territories, regional groupings and relationships—as well as the “payoff results” of their efforts: sales call metrics, rankings of efforts, quotas, actual sales and other pertinent data. Extensive SQL and VS.NET coding is used in data preparation and presentation.

Development effort included “meshing” the company internal GL and invoicing requirements with Siebel information displays. We interview the account personnel to understand the current invoicing structure. We analyzed the prototyping, pre-production runs and the design and found it to be time consuming, unstructured and multi-person staff effort. We provided a solution that replaced the existing manual invoice (line-by-line) key-ins (multi-person staff effort) with data gleaned from Siebel production tables on customer sales and services provided. This data is restructured and enhanced to drive invoice verification and printing, and the subsequent posting to the GL itself. The completed invoicing (invoice IDs, dates, and amounts) and GL data is inserted into Siebel production database for company-wide and customer online access. This made the whole invoicing system more structured, automated and aligned to the application.