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.
-
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.