Maintaining data for Karmak Fusion, Business Management Application

We have been maintaining data real-time for this Business management solution for a commercial transportation client from USA. We have direct access to the application established using VPN connection to carry out the daily activities of Items Creation with its Image uploading, Specifications updating, Price Updating, Invoice Creation, Freight Invoice updating, Title & MSO, Location Updating, UPS & FEDEX Tracking and generating various reporting based on the data available in Karmak.

Maintaining data for Arcadium, CRM Application

The scope of work included maintaining the data online for the Customer Relationship Marketing (CRM) application of a truck and trailer leasing client in USA from our remote location in India. The daily activities included Items Creation & updating, Image Resizing and Updating, updating the Title & MSO, updating the location of the inventory, updating the specification details, updating the price change and Inventory Lease Spec Updating.

Maintaining data in Magento, e-commerce Application

This project is executed online for a client from USA to maintain data in the Magento e-commerce application. The project scope included creating items, assigning suitable images to the items after image processing, updating the inventory locations based on the movement of items, updating the price changes and specifications, managing the inventory and sales reports.

Management Information Reporting

This project involves generating various periodic Management Reports for our Client from USA from data provided, data source provided and by extracting information from their underlying ERP and CRM applications. These reports include 44-59 Delinquency and Repo Report, Image Review Reports, Performance Report from Project Logs, Sales Report, Monthly Marketing Report, Trailer Tracking Report, Accounts Receivable Report, Performance Slides for Management Review, Data Integrity Reports and Aging on Accounts Receivables.

Assigning Product Codes

This project involves generating various periodic Management Reports for our Client from USA from data provided, data source provided and by extracting information from their underlying ERP and CRM applications. These reports include 44-59 Delinquency and Repo Report, Image Review Reports, Performance Report from Project Logs, Sales Report, Monthly Marketing Report, Trailer Tracking Report, Accounts Receivable Report, Performance Slides for Management Review, Data Integrity Reports and Aging on Accounts Receivables.

Maintaining data in Salesforce, CRM Application

As part of this project, we did customer servicing and sales prospecting using remote login facility provided to access Salesforce, their customer relationship management application. We kept a dedicated team to answer all customer complaints received by modifying the pre-defined templates to suit the customer complaint. We did this project for a USA based client who provided Mobile Apps to their clients after suitably modifying the App. We were also keeping track of the complete sales prospecting stages and answering their clients on their queries and also informing them about the customization status of their Apps in tandem with the status of activities of the development team.

Maintaining data in NetSuite, ERP Application

We have been maintaining data for a USA based client for their back-office jobs in NetSuite ERP system. The scope of work include creation of Item units, Purchase Order Processing, PO Cost Link, Purchaser Sub Item, Purchase Inventory Adjustment, Petty Tasks, FET Sub Item, FET Purchase Order, Item Image Conversion and Uploading, Invoice Supporting Files Converting and Uploading, Cost Added After Fulfilment, Monthly Billing, Rental & Lease Invoicing, Monthly Bank Reconciliation, Shop Floor Work Sub Item an procurement, Marketing Report, Rental Tasks, Commission Calculation, Master leases, Analysing Marketing Report (Who is Calling), Inventory Management, Daily Inventory Comparison and Updating and various reports generating. The daily transactions are scanned and uploaded in FTP or send to us in mail attachments by the client for us to process them.

Maintaining data in Sage MAS 200, ERP Application

The scope of project included management of various Backoffice data in Sage MAS 200 ERP. The modules of Sage MAS 200 used included Accounting, CRM Sales Force, Inventory Control and Fixed Assets Management. The broad activities covered are Accounts Receivable, Accounts Payable, Bank Reconciliation and General Ledger in Accounting along with New Item creation, Receipt of Goods, Receipt of Invoice, Corporate Cost Adjustment, Used Items Creating, creating Purchase Orders, Receipt of Goods, Receipt of Invoice, Data Updating, Corporate Cost Adjustment, Creating Trade In Items, Updating Quantity, Updating Cost, Consignment Items Maintenance, New Vendor Set Up, Shop Adjustments, Lead Scraping Process, Master Lease and Scanning PO's to FastDocs, the Document Management Tool.

Maintaining data in GRIN, Influencer marketing application for ecommerce

In this project, we provided our service to one of our USA based client by remotely connecting to GRIN, the Influencer marketing application for ecommerce, to find, recruit, and manage authentic relationships and to build their brand image by creating meaningful relationships with their influencers while producing authentic media that transcended the traditional forms of advertising. The process defined has various stages and with multiple steps in each of the stages. There have been various activities include in each stage including searching the influencers by applying multiple search criteria and filters, check and select the suitable one and add them to the prospects list and tagging them separately under different names. The scope also included offering email, product fulfilment, reporting, and list curation.

Auto Accessories Data Project

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

Product lines comparison

The scope included comparing different parts manufactured by our client company for various makes, model, year and Engine specification to that of our client from the After-Market industry in USA. There were over 50,000 different products compared in this process. When 2 parts are found same on their specifications, then their coverage based on their respective application is studied to identify the larger market potential. This work helped our customer to decide on the products that are to be persisted with, replaced with or be modified when they were taking over another company in the After-Market industry.

Data Capture from Proprietary Software

This project involved compiling data from a proprietary software. The information provided by the software is extracted based on queries on defined parameters, and then analysed for its suitability. If found suitable for a specific requirement, they are then captured and formatted into a predefined format. The project also included classification of these captured data to different categories. This project is undertaken for a client in the healthcare industry from USA.

Data Collection for Demand Approval Process

This project involved mapping the Google Play and iTunes Store to extract data for free Google app and iTunes apps from all available categories, categorize them based on the popularity and upload available information to the Google doc at specified location on a daily basis. The Developer’s information is gathered by making the Google search using "Sales Loft" and upload the extracted and categorized information on a weekly basis. The data then populated to the Demand Partner Approval tool for the Demand Partner Assignments for “Partners” listed in the provided Google doc. This is done by accessing data through a Virtual Private Network (VPN), removing duplicates by file comparison and then updating data for both Mobile Video Approvals and Mobile Banner Approvals. We had executed the 'Demand Approval process' for both Banner Demand Partner and Video Demand Partner processes in different sites like Mobfox, Smaato and Pubmatic as per documented procedures.

Data Capture from LinkedIn Profiles

As part of this project, we extracted data from a provided list of LinkedIn profiles and uploaded the extracted file in a CSV format to specified target location. The collected data was verified for accuracy including the latest contact details using the provided URL of the contact.

Creating Data repository for Healthcare Industry

In this project, we created a database of life insurance agents from data listed in various data sources. We had utilized free videos from the youtube.com and populated the link to our customer's site with key specific content. We had also collected and compiled data from different sources such as Genetic Health Conditions, Glossary, Go Local Data, Mental Health Services Locator (Mental Health Facilities Locator and Mental Health Services Directory), and Assisted Living Directory Data.

Creating Business Contacts for Pharmaceutical Company

The database of business contacts was created by extracting data listed in various data sources. The data is scraped, stored, and regularized into a database for publishing. Various data captured are updated to respective database using a software developed by us exclusively for this project. The data was identified, scraped, stored, analysed, regularized, processed and keyed into the Application as required by our customer.

OE Research

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

Research on Application Coverage

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

Data Capture from web on Different Topics

In this project, research was done to capture data from web for given topics and classify them in different heads of importance. Popular search engines and in-house developed scrapper programs are used to assimilate information from different sources. There were data, illustrations, urls, related topics and other such details were to be collected for the topics.

Market Research Projects

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, analyse and compare the data and deliver to the customer in the required formats in an MS SQL file. There have been many projects where the research is done that include various entities in US in the field of Automotive, Real Estate, Hospitality, Medical, insurance and Credit Services among others.

Market Analysis

We had executed this project for a client engaged in automotive related products and services. This scope covered 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. The data had to be provided in different formats specified and in MS Access file.

Data Analysis based on Domain

This project involved collecting various data from internet sources, matching the domain of each record with any of the list specified and with the domain given in Target Accounts. Once the domains are found matching, then the most recent contact details are verified with various other sources including LinkedIn.

Compilation of Data from Internet and Analyzing Projects

The have been many projects executed for diverse requirements from our clients to collect data from internet based on their preferences, validate the data in multiple sources for its accuracy and non obsolescence, classify and format them in suitable formats and upload in designated locations. Some of such projects are;

• Data collection and Analysis of Target Companies and Contacts
• Data related to Security services, Facilities protection, Executive/staff protection worldwide
• Data on contacts who provide Home Tuition for Physically or economically challenged students
• Extracting the data of companies providing Securities services
• Extracting data from the Sales Commerce
• Extracting the data of Universities and Colleges Book stores
• Data Research on (Insured Companies Details
• Data Research by matching the company URL with that in the LinkedIn and members website
• Data Research to compile a Media list
• Data Capture and compilation of Universities with given or similar job Titles
• Data Capture and compilation of Athletic Directors and Coaches
• Data Capture and compilation of Gyms and Gym coaches
• Data Capture and compilation of Healthcare Providers using Zip Codes locator
• Compiling list of Retailers, Sprouts, Jewel-Osco, Wegmans and other chains using Zip Codes locator
• Extracting the data from the NCHSAA Member Schools
• Data Captured and compilation of SFH CrossFit Retailers
• Data Collection and Analysis of beverages with BCAAs
• Data Capture and compilation of specific categories of stores with their details
• Data Capture and compilation of natural food stores and health food stores
• Data Capture and compilation of natural food retailer based on MAP
• Data Capture and compilation of Health and Gym place
• Data Capture and compilation of Knock Stores from specific countries using Zip Codes locator
• Data Capture and compilation of Dealers of various automotive parts country wise and location wise
• Extracting, classifying and normalizing lead data from HubSpot

USA Federal Census Data Capture

Project involved capturing of data from scanned images of hand written census documents of yesteryears going back to year 1890. A Team of over 97 professionals trained in different handwriting styles and popular USA names and places undertook this work for a very popular customer from USA. The team consistently clocked over 99.5% accuracy while meeting the project schedules.

Restaurant Data Capture

The project involved capturing data from restaurant menus, images and web sites. The input contained various information (like Category, Description, Rate, etc) of the menu items served in the restaurants. The relevant data is captured and converted to MS word in appropriate formats. The project was executed with the agreed level of accuracy of 99.5% by applying defined verification and data validation process.

Data Capture from Remote Server

The project involved logging on to our customer’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 then formatted in specified formats as required and are uploaded to the customer's server located in the USA.

Transcription Services for Automotive Industry

This project included data capture from printed catalogues, interchange data processing, data conversion, OE research, image processing, electronic cataloguing, electronic publishing, AAIA coding among others. Some of the clients had electronic cataloguing solutions and data provided by us were used in this cataloguing engine for publishing their electronic catalogues.

Audio Transcription

In this project data from audio files having business data were transcribed and presented in defined reports forms. The work consignments were downloaded from the customer’s FTP and the processed forms were uploaded back. The customer had defined priorities for each of the consignments and our process was fine tuned to meet the required Turn-Around-Time (TAT).

Automotive Interchange Data Capture

The project was executed for a USA based Automotive Client to capture parts interchange data from catalogues of various aftermarket companies and over a billion automotive aftermarket interchange data were built. This facility remained in operation for over 3 years and had never recorded a single case of schedule slippage or rejection. OE research was also performed on these data to establish the potential coverage of the parts.

Transcription from Digital video files

This project was executed for a client in the healthcare industry and involve transcribing the data available in the provided digital video files. The captured data are to be codified as per coding structure provided and grouped and uploaded to the designated location. There were associated images that were to be captured from the internet, for which search has to be executed based on the data captured.

Data Entry from Images/PDFs

This project involved transcribing data from the provided image and pdf files. The transcription was not verbatim; instead it involved analysing and understanding the information provided in the input files available in the client’s FTP and chunk that information before entering them in their ecommerce portal. The project has scheduled time for upload of the data based on the type of contents. The data has to be uploaded only on or before the scheduled data of publishing.

Porting Data to Zen Cart

The scope of this project was to capture data from an existing website and port it to our client’s E-Commerce Zen Cart database. The data included product details with images that our customer from automotive industry selling under different make, model, year and engine Specification along with special pricing options. We parsed out data for each product under different categories from the existing website using an in-house developed application, and then the data is cleaned up, categorized and then assigned new codes as per the new database structure and coding scheme. The codified data is then directly inserted to the backend database through SQL queries keeping in mind the referential integrity constraints enforced by the application.

Importing Medical Data from Proprietary Software

The scope included capturing data of healthcare industry in USA from a proprietary software using a parsing program developed by us. The scope involved collecting Doctors details from various sources in different formats, formatting them to specified formats in MS-Excel, and upload to designated locations. Apart from the data capture, the contents of the website also updated frequently.

Data Syncing from Different Management Systems

The Project scope is to export data from 30 different management systems on a regular basis and then import the data to a single target location under different account heads. Each of the management systems has a different process for exporting and importing data. The data syncing to be done from Monday to Saturday during day light hours of our client operating out from USA also keeping in mind different time zones for different management systems. Various account heads in each of the source databases also had different times specified for export and imports. There were about 400 account heads for which the data having their daily transactions to be synchronized.

Exporting Aftermarket Interchange Data

This project was executed for a client in the American aftermarket industry and involved exporting data from a proprietary catalogue. The data received based on queries relating to different applications in terms of make, model, year and Engine specifications are extracted to an MS Excel format, which then cleaned up before uploading to the target destinations.

Data Import from Diverse Sources

This project was executed for a training institution in Saudi Arabia under the Ministry and covered data conversion and export to the new Training Administration Management software developed for them. The sources of data included MS Excel, MS Access, MS Word and such office automation tools. There were different interfaces developed by us to export data to the target MS SQL database and also to export selected data from MS SQL database to the MS Excel format of generating various graphs and to MS Project for planning courses’ schedules.

Porting Data to New Application

The scope involved porting data from existing MS Access application to the newly developed Oracle application of Forensic laboratory under the Ministry in Saudi Arabia. The data relating to DNA profiling, Biology, Chemistry and Toxicology are appropriately ported to the new application. There were multiple branches of the office across Saudi Arabia from where the data is received in heterogenous formats, which had to be ported to the newly developed application database structure without losing the branch identity and referential integrity.

Porting Data from Images

The scope included capturing data from image illustrations or callouts and classifying and converting them into a predefined format. Analysis is then done on establishing relationship between different classified data elements and associating them with appropriate images that are processed for specific resolution. The entire data is then ported to the backend SQL Server.

Digital Image Processing Projects

The activities involved in most projects are by and large the same with minor changes. These activities at a glance covered capturing images either from different sources including internet, scanning documents or receiving images from clients in different resolutions and processing them for specific resolutions and as per clients’ instructions. We did a lot of Digital Image Processing projects covering activities like Image import, analysis, image sharpening, image enhancement, image restoration, image conversion, image cropping, image resizing, image editing, image clipping, image retouching, and cleaning up to suit the requirements of the target destination where the processed image is finally uploaded. Some of these projects also warranted creating thumbnail views of the images for specific needs of the application.

Some of the projects that we did in the past are;

• Processing images for many Customized Applications
• Processing images as part of Backoffice jobs
• Processing images for ERP Applications
• Processing images for Mobile Applications
• Processing images for CRM Applications
• Processing images for Social Media Publishing
• Processing images for Automotive ePublications
• Processing Product images for ePublishing
• Processing images for various Portals
• Processing images for Automotive eCatalogues
• Processing images for Real Estate Industry
• Processing images for 397-degree panoramic views
• Processing images for Computer Based Training Tools

Assigning Deals for chains of stores

The scope included assigning a product category to each product included in each job from a master list of product categories provided by our client. The data so categorized are updated at specified frequencies as per instructions provided by the client along with its description and other contents. As the second major activity, which we are still doing, we set up the deals for listed products in the circular pages published on a weekly basis. There are different chains of stores having their deals published on specific days in a week. For the listed deals available at the client's order admin page, circular spots are created and offers relevant to the selected dates are assigned to those spots using Date Picker available. This project is being executed from Monday to Saturday.

Maintaining Online Automotive Publications

The articles to be published are received as scanned images, or in PDF or MS Word formats from the FTP location. There were clearly laid down rules for the processing including how to capture the Headings, short description, major contents, keywords, images and preferred thumbnail view for each article. The scope included Data Conversion, Text capture from images, Image Processing, Proofing, HTML Tagging, Content Updating and Quality Control on Contents. Our client had provided instructions to carry out these processes. Completed work comprising of XML files are dispatched through email, FTP and also uploaded to the web sites specified by our customer. This project was executed online for over 3 years for updating the content database.

Glossary Project

The scope of this project was to capture glossary of various dictionaries from the links provided by our customer and convert these into XML files as per the structure provided. The converted XML files had a unique code for the Terms. Other data of interest in the XML file included Book and 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.

Tagging Social Media Updates

The scope of work was to add suitable images related to each scheduled social media update for the client’s affiliated Twitter and Facebook accounts based on instructions conveyed by the customer through emails. The process involved accessing all their 8 social media accounts online daily on all working days, identify new posts, locate those which are not having images attached to it, identify potential images, select most appropriate image, create their thumbnails and update them for publishing.

Content Management for Educational Institutions

The scope of work was to update contents to each of the websites belonging to the client having many educational institutions. There were approved templates for content updating for each institution so as to have close similarity among the websites of their parent institution. For every specific type of content, there were instructions provided by the client. Completed work was first uploaded to a production web site. Once reviewed and approved by our customer, the contents were then updated to other applicable websites depending on the type of content. One approved content has to be uploaded to many websites depending on the nature of content.

Electronic Publishing

This project was executed for a USA based client for electronic publishing of current and archived publications of over 50 different publications at different frequencies. The files were received in Quark Express and PDF with associated images in .tif and .eps formats. The process of digitization included Image Conversion, Text Conversion, XML Generation and Updating into their Content Management System (CMS). Verification was done during each stage to ensure the quality of the contents. The completed articles were uploaded to the customer’s FTP facility daily. The project duration was 4 years.

Quality Control on Content Publishing

This project was executed 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 received over 2,50,000 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 association for the website restricted the upload of images containing obscene and objectionable images and messages. We did manual review process for screening these images and messages after they have been uploaded and removed any images or messages that did not meet the required criteria for publication. 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.

Maintaining Documents in FASTdocs

For our client from the business of Cargo Shipping industry, we executed a project to maintain their various documents and images under FASTdocs, Alogent's enterprise content and information management platform (ECM / EIM). The project scope included grouping related invoices, charges, images and other documents together before uploading to this platform. The images required processing to convert them to the desired resolution and size and the documents required scanning and cleansing before uploading. The documents are received in our FTP and are processed within 12 hours from receipt. Quality Control on contents was done based on precompiled rule sets. Documents provided were validated based on the rule sets and/or algorithms and cleaned up as per instructions provided by the Client. The clean-up process involved finding garbage data, formatting to desired format and flagging off the documents. The rejected and cleaned documents are then converted as XML files.

Quality Control on Community forum for automotive industry

The project scope included monitoring the posts under different threads of a community forum built for automotive industry. There were different sections like new cars, used cars, new trucks, used trucks and also have different applications under these sections. The posts could appear at any time and could be relating to any of threads in the forum. Hence there must be constant vigil to filter the objectionable posts and marked them for review. Those marked for review are verified once again by the administrator before a decision is taken to publish it or not.

Our various e-Cataloguing projects

The scope of various projects that we did, by-and-large included Catalogue Data Entry, Catalogue Data Research, Converting Paper Catalogue to e-Catalogue, Catalogue Processing, Catalogue Image Processing, Photographs Editing/Conversions for publishing, building Images with 360º panoramic views, building Catalogue Design templates & Intuitive Interfaces, presenting Structured information, Catalogue Building and Indexing, Catalogue Content Management, Quality Control, Catalogue Revisions, HTML & XML Conversions, Presenting data in SQL formats, PostScript Outputs, Burning CD and Catalogue Change Management.

Following are some of the projects that we did in the past;

• Electronic catalogue for Automotive OEM
• Electronic catalogue for Automotive Aftermarket Client
• Electronic catalogue for client from Plumbing Industry
• Electronic catalogue for client from Electrical Industry
• Electronic catalogue for Retail Industry
• Electronic catalogue for Garment Industry
• Electronic catalogue for Real Estate Agents
• Computer Based Training materials