Home  Service  Projects  Clients  Advantage  About US  CEO Desk  Contact Us

Data Services

Automotive Aftermarket Industry

We have been a leading provider of E-Catalog, E-Commerce and Custom made Software solutions for automotive, truck & equipment parts industries, mainly in the USA. Our offshore business model has been most appealing to our many clients to reduce costs as well as to expand mutual business. The cost savings achieved by relocating services offshore in India are passed on to our clients along with the highest quality customer service, fastest turnaround times and utmost confidentiality.

Till date we have serviced some of the major automotive information providers in the US in their data conversion & extraction, PDF conversion, Image processing, extraction of data from legacy systems, formatting of data, XML conversion etc. We have also helped clients in building automotive websites and portals. We have implemented customized software solutions, Interactive forums and Electronic catalogues with search option, data capture tools, interchange data linking, productivity monitoring tool etc. for different customers. We have in place a dedicated team with extensive knowledge of the various methodologies, standards etc, that is currently in use in the automotive industry.

We can offer you our services in the following areas

  • Converting paper catalogue books containing automotive part information such as part  numbers, manufacturer information, interchange information, part description,  technical specification and images to electronic form in text, database or other  formats
  • OE Research
  • Creation of database for OEM-Aftermarket or Aftermarket-Aftermarket interchange etc
  • Data conversion to industry standards
  • Scanning of catalogs, image processing, image optimization & conversion to PDF
  • Extracting data from electronic catalogues in PDF formats, CDs, or legacy software   applications having proprietary data structures
  • Formatting data in tables from other partially formatted structures with the help of   parsers and other utility software
  • Re-ordering and cleaning up data elements after reading in from other database   formats.
  • Periodic updating of data
  • SGML/HTML/XML tagging and other related services
  • Customized software solutions
  • Website and business portals
  • Flash intro, flash presentation of vehicles, 360-degree panoramic views, graphics and  animation etc

Glossary Project

The scope of this project is to capture glossary of various dictionaries from the links provided by the client and convert these into XML files with the structure provided.

The converted XML files had a unique code for the Terms. Other data of interest in the XML file include Book / Dictionary details, Term Names, Variations for the Terms, Term Definition, HTML Tables, X-Refs, and Images, if any, referred in the term and other related links. The project was executed by developing an in-house utility program for XML Conversion.

Auto Accessories Data Project

Project involves building up of data on auto parts belonging to Original Equipment manufacturers (OEMs) and After Market manufacturers. Process involves converting data from different formats such as catalogs in printed form, electronic catalogs in PDF formats, proprietary electronic catalog information retrieval systems etc., to standard data formats. Process also involves arriving at part cross-references using a unique linking logic and presentation and retrieval of cross-referenced parts in easily readable formats.

Medical Data Capture

This project, done for a customer from USA, included data capture in relation to healthcare industry in USA from a proprietary software using a parsing programs developed by us.

OEM Research

The scope of this project included accessing the electronic parts catalogue of General Motors, NISSAN and Ford from a remotely located server in USA and extracting the information based on various filters. The collected information is then compared and correlated with different parts and interchange data that were built from paper catalogs. After these linking of data done, the data is then converted as per American Aftermarket Industry Association (AAIA) standard. Along with the process various reports such as total coverage, partial coverage and no coverage are generated.

Product lines comparison

This project was done for a USA based company in automotive industry, when it took over another company. The scope included comparing different parts manufactured by one company for various makes, model, year and Engine specification to that of the other company. There were over 50,000 different products compared. Once 2 parts are found same on specification, then their coverage is studied to identify the larger market potential. This work had helped our customer to decide on the products that are to persisted with, replaced with or to be modified.

Data Capture from Remote Server

The project involved logging to the client’s machine located in USA, and collecting the requirements for data capture. The source for data entry was given in various formats such as scanned documents, PDF files, images and other electronic forms. The data captured are formatted in specified formats under instruction and are uploaded to the clients server located in USA.

Electronic Publishing

This project involved capturing data from printed catalogs and categorizing them as per requirements of a browser developed for publishing in specified format. The project was executed for automotive industry parts catalogues, and involved image scanning and processing for required resolution for publishing.

Data Entry from EPC

The project included logging to the client’s machine located in USA, and accessing the OE Electronic Parts catalogs (EPC). The catalog data are then analyzed and captured for defined categories and filters and presented in specified formats. The scope included data capture from EPC of many of the most popular OE manufacturers in the USA.

Interchanges Comparison

The work involved keying in various parts that comes under a ‘unit’ (as given by OE) produced by different aftermarket manufacturers and then comparing and analyzing the coverage that one had over the other. The analysis also included an intelligent interpretation of indirect matches through a unique algorithm developed for the purpose.

Market Research

The scope of this project was to provide systematic collection, analysis, interpreting and reporting of data from internet about various markets and their preferences, opinions, trends, and plans, used for corporate decision making. The project scope also included extraction of the relevant data from the Internet communities, analysis and comparison of data and delivery to the Client in the required formats in an MS SQL or MS Access database file. The research is done for various entities in US in the field of Automotive, Real Estate, Hospitality, Medical, insurance and Credit Services among others.

Market Analysis

We have executed a VPO facility for a USA based company engaged in automotive related products and services. This facility provided Market research from internet to collect and collate information related to various dealers (New cars and used cars), parts and interchange, insurance agencies, auto accessories manufacturers and distributors, aftermarket industries and such with associate data in prescribed format. We have built over a billion records database in 3 years, which was constantly updated for changes.

Quality Control on Content Publishing

This VPO facility was created to execute for our customer in USA, who offer an online community forum that lets people meet their friends' friends. Through this forum, people can share photos, journals and interests with their growing network of mutual friends. The site receives over 250k of new images every day being uploaded by its members.  These images were immediately placed online and made available to the public.  The terms of service for the website restricted the upload of images containing obscene and objecting images and messages. 

The VPO facility did a manual review process for screening these images and messages after they have been uploaded and removing any images or messages that did not meet these criteria. Apart from the daily uploads, over 25 million images that were in the library were also reviewed and completed well ahead of the required time.

Border Control System

The project involved Designing and implementing database architecture for Border Control Application for our customer in Brunei. This application had a central server and four remote locations at the entry and exit points of the country. The application provided functionalities such as capture and analysis of the passport images, capture and analysis of landing cards, capture movement details across the border, checking reference lists of 'searched' people, and supporting border crossing with smart card and passport. To achieve these functionalities we have implemented multi master and procedural replication between all remote Oracle databases.

Electronic Publishing

Scope of work performed by the VPO includes providing technical services to digitize various magazines. This facility is in operation for nearly 3 years now.

This VPO facility is provided for a USA based company for electronic publishing of current and archive publications of over 50 different publications at different frequencies. The files are received in Quark Express and PDF with associated images in .tif and .eps formats.

The process of digitization includes:

    a. Image Conversion
    b. Text Conversion
    c. XML Generation and
    d. Updating into Content Management System (CMS)

During Image Conversion, every image in the article is cropped, resized, and saved into different sizes (as specified) and files are named with the specified naming convention. The articles are then processed for text.

During Text Conversion, the articles are opened using Quark Express and the text contents are captured in a defined structure. The name of the item should precede each captured item (e.g. Title, Subtitle, etc.). After this, XML code is generated.

XML Conversion is done using utility software developed in-house. XML is generated from the text file after the text conversion process.

The story text from the articles is updated to the client content database through a software for content management. The contents, except images, are updated to the CMS in the customer’s server in USA site.

Verification is done during each of the above stages. The completed articles are uploaded to the customer’s ftp facility on a daily basis.

Operations for Logistics Company

Scope of work in this VPO facility was to provide technical services for cost effective routing of trucks, gas purchases, driver assistance, and, to generate various reports.
The project scope also included

  • Cost-effective Routing: Based on the Source, Destination and the stops in between,  routes are derived considering the gas prices across the fuelling stations on route.  Fuel Routes and Fuel Override instructions were provided to the drivers for the loads  assigned to them by providing 24 X 7 supports. The routes are derived for the trips  based on the Initial fuel available in the truck, the route of the trip and cheaper  fuel availability in the route. Instructions are then sent to drivers with the  override locations and the quantity of fuel to purchase at different override  locations.

  • Monitor Qualcomm Messages and Provide support to fuel issues: During Nights (on  weekdays) and 24 hours during weekends, Qualcomm messages in Citrix are constantly  monitored for the messages from drivers. Fuel needs are addressed and routes are  provided to the drivers on request.

  • Generate Exception Report (Override Report): Based on the fuel instructions provided  to the Truck Drivers, a Daily Fuel Report comprising of the Trip Details (Trip #,  Truck #, Fuel Card #, Origin, Destination, Miles in the Trip, Dead head Miles) and  Override Details (Fuel locations, Fuel Rates, Gallons to purchase, Miles between the  override locations) is prepared. Based on these Daily Fuel Reports, Fuel Override  Reports are generated by capturing data from Citrix and TCH E-Manager. This report  gives details of violations on the fuel instructions by the drivers. The Override  reports are generated twice a day, during weekdays.

  • Generate Miles per Gallon (MPG) Report: This report is generated by extracting data  from Citrix and TCH E-Manager for the entire trucks of the Companies. Load  information (Truck #, Date, Origin, Destination, and Miles) is extracted from Citrix  whereas the fuel information (Override Locations, Date, Quantity, Rate, Amount) are  extracted from the TCH E-Manager. Based on these information Miles per Gallon (MPG)  and Cost per Mile (CPM) are calculated for the trucks. This report is generated every  alternate day - Monday, Wednesday and Friday.

  • Charge Back Summary Report: This report is generated for the Charge Back to be levied  from the drivers for violating the fuel instructions provided for each trip. If there  are violations made by the drivers in following the Override instructions, then they  are charged for the monetary loss for not following these instructions. This report  is generated each Monday.

  • Generate other reports such as Totals Spreadsheet,  Daily Issued Checklist, Daily  Fuel Report, Daily Gross Profit Report and Unpaid Settlements (Weekends)

The data for processing are captured after logging on to the Citrix Loadmaster and  TCH E-Manager using the credentials provided.