Market Research/Big Data / Hadoop Solutions
Bigdata Case Study 1
Business Pain Point: One of the leading Market Research company at Bangalore was facing a problem of time delay in processing their statistical calculations. They were using a conventional software for doing the same and its taking lot of time to get the final result. Also they are advised to buy new high configuration servers for handling the same. Solution given by Sesame: Sesame studied this Business Pain Point and our hadoop experts suggested to do the same with the help of Hadoop framework. This method helped them to acquire more processing power and storage capacity by clustering the existing commodity machines without purchasing new high configured servers and storages. Based on the formulas and algorithms given by the Market Research Company, Sesame developed a POC using Hadoop , Hive and Python. Out come : Client observed that the time taken by Hadoop based solution provided by sesame is much lesser than the time taken by their existing software. Also they realized that existing servers can be used much efficiently by converting them in to Hadoop clusters.
Bigdata Case Study 2
Business Pain Point: One of the leading Recruitment company at US was facing a problem of time delay in accessing their portal in peak hours. They were using a conventional programming language & RDBMS for doing the same and it is very slow while multiple users accessing the portal concurrently. Solution given by Sesame: Sesame studied this Business Pain Point and our hadoop experts suggested to do the same with the help of Node.JS and MongoDB. This method helped them to acquire a real-time web portal that can perform well with concurrent users. Based on the existing huge amount of data, SESAME developed a recommendation engine using Hadoop and R. Also developed data visualizations for portal admin using d3.JS and R, which was very much useful for analyzing the huge data in a single page. Out come : It is reduced 95% of customer complaints related to portal slowness and helped client to focus on their business development when compared to the previous Business Pain Point. Also the recommendation engine & data visualization pages reduced the human efforts that they have previously spent on huge amount of data.
Bigdata Case Study 3
Business Pain Point: One of a leading electronic brand in India was looking for a solution to know what people are discussing about their brand/products/services. Solution given by Sesame: Sesame studied this Business Pain Point and our Big data experts suggested to do Sentimental Analysis for analysing the customer sentiments from various social networking portals and based on the same useful analytical reports were given to client.
Out come : Client was able to see not only what people are discussing about their brand/products/services but also of immediate competitors. This gave them valuable information to improvise and re- allign their services/branding/products related activities.
Bigdata Case Study 4
Business Pain Point: One of a leading travel and tour portal at Middle East was looking to identify what are customer’s common friction spots in the online booking process. Also they were looking to give some value based real time recommendations to the customers based on transactional and search data. Solution given by Sesame: Sesame studied this Business Pain Point and our Big data experts suggested to integrate a real time recommendation engine which will help them to solve this situation.Sesame's Real time recommendation engine identified the behaviour patterns of the customers and visitors by analysing the search and transactional data and gave valuable recommnedations to customers and portal admin. The friction spots in the entire online process is identified and recommendations are given to the portal admin for solving the same.
Out come : The revenue for client increased without any additional manual efforts and client was so impresssed with our soution.
Automobile/Online Vehicle Service Booking System
Business Pain Point: One of the leading automobile dealers, German Motors was having a hard time manage their vehicle servicing booking system. German Motors has service centers spread across various locations and had no mechanism to manage their vehicle service bookings from a single point which resulted in facing problems in managing the same. Solution given by Sesame: A study was conducted at client side and Sesame proposed a web based vehicle service booking system to sort out this issue. Client accepted the solution and sesame developed and implemented a web based Service booking system with which every customer were able to login to the website with the username and password provided to them at the time of purchasing the vehicle. Logged customer can view the free dates available from the dealer’s side to take a service booking and once the booking is confirmed, customer will get a unique registration code along with the address of service centre to were customer should bring the vehicle. From the dealer’s side the concerned person can view which are the service bookings that they received for a particular day. Also dealer has the option to set max number of service bookings that should be taken for a specific day. Once this level is reached that date will be automatically removed from the available set of dates displayed in the website. Outcome Now The Client was able to manage the Service booking system very efficiently by saving time and manpower to a very large extend. Also they reduced a lot of phone calls landing at the desk related to service booking process.
General/Online Sales Executive Management System
Business Pain Point: One of the leading roofing solutions company ( M/s LAFARGE ) operating in India who had their Marketing executives working all over India, the company was finding it difficult to manage the daily reports from these executives. Executives used to send the report by means of courier and emails from various working locations with the report, which could not be consolidated easily by the Marketing department and so there was no effective reporting happening as well as observed huge differences in sales figures. Solution given by Sesame: Sesame proposed a web based call reporting system as a solution to the problem faced by client. A study was conducted at client side and sesame walked through the system of daily call reporting process of the client and developed a web based call reporting system for the client, with which executives were able to key in daily call details and related information from any geographical location they were assigned with the help of internet. The marketing managers can instantly review, comment and guide their executives through this system. Out come : Marketing Managers are now able the access and monitor the details provided by executives and they are able to take consolidated reports easily between any two given dates, and are also able to identify the hot customers with just a click of the mouse, managers are now able to drive the executives in such a way that they keep their commitments and follow up activities assigned very easily. After a month of trial run, it was observed a sudden change in the sales figures and paper work was very limited and the entire reporting process was streamlined and effective.
Hospitality/Online Hall Reservation System
Business Pain Point: Ashirwad Loans, The first centralized AC hall in Calicut was getting feed back from customers abroad that they are not able to check (out of office hours ) whether the Hall is available on a specific date for fixing programs or functions. In working hours the help desk at the hall will be functioning and after that when customers want to check for hall availability for a specific date, the same far from possible even for the local customers. Solution given by Sesame: Sesame proposed a web based hall availability and booking system as a solution to the problem faced by client. A study was conducted at client side and sesame walked through the existing system and processes followed by client and developed a web based hall availability and booking system for the client, with which administration team would get notified on enquiries posted from the customers through their website as well as over phone. All this information gets updated on to a common database and the same gets displayed on the website as well. Out come : The customers are now able to check 24x7 whether the hall is available for a particular date for fixing a program. Normally when discussions for fixing dates of marriage are happening at homes, the first thing that the parents want to check is about the availability of halls for conducting the function. By the help of this system it is easily possible to check it round the clock.
General/Franchisee Management System
Business Pain Point: Our client, G-TEC EDUCATION an ISO 9001:2008 IT training company with more than 250 franchisees across the globe was facing difficulties in managing distributing training materials and related documents to its franchisees. Client was depending courier services and postal department to move their materials to various franchisee location. This consumed lot of time and manpower for managing the same. Solution given by Sesame: Sesame proposed a franchisee management application after a detailed study at the client site. The application was designed in such a way that all franchisees have their own access on this system. The head office can manage all the requests from their franchisees in an organized manner and can queue up their requests and execute them on a first in first out basis. Each franchisee can login and interact with the head office for getting the learning materials, fee structures and also can perform other franchisee level administrative activities from this application. Out come : The admin team and Franchisee heads are now able to manage all their activities with much ease and relief as all the requests are now centralized and monitored from the head office. Also they observed very less time delay in delivering or resolving the requests rose from each side. A lot of time and manpower is saved in managing the entire show.
Education/Online Students Information System
Business Pain Point: Our client is one of the leading residential schools. More than 3000 students are doing their schooling here. In order to bring about improvements in the grade and marks of the students, the school management decided to move all the report cards frequently to their parents so that each parent can review their ward’s progress in terms of academics and have a close watch of their ward. The decision was greatly appreciated by all the parents and the challenge before the school management was to manage the huge administration work involved as all the reports which includes unit tests, quarterly tests, half yearly, annual year tests had to be printed and posted. Solution given by Sesame: Sesame proposed a web application where all the reports can upload to one single location on a web-server by the school management team as soon as the results are published. Each parent will have a login to this system and they will have the provision to view their wards results as well as their previous results summary. This will help them to analyze closely the progress of their wards’ academics. Out come : On successfully implementing this system, now students are more cautious on their academic performances and parents are more aware of their wards progress. The school management was able to cut great costs connected with administration and paper works and organizing parent- teachers meetings very frequently. Now, the results of small unit tests as well are easily accessible for every parent as they have their own login to this application and are able to analyze and compare their wards scores with the other students in the same class. The school is now benefited, gained great recognition compared to other schools in the same locality and the parents are much happier as they have less meetings and great visibility on their wards.
Construction/Project Status Intimation System
Business Pain Point: Our client Kent constructions, a reliable builder, was facing issues in managing to display their multiple project details in a single website. Also they were facing issues in addressing the customer’s daily enquiries for getting up to date status of projects they have already purchased. Sales team was facing issues in sharing the availability of villas and apartments in a specific project. Solution given by Sesame: Sesame Designed a full fledged web portal with a back end application program which helped client to publish project wise details to the website, update daily status of each project which was also diverted to the concerned buyer . It also helped client to update the availability status of the villas and apartments to the respective page in the web portal. Out come : On successfully implementing this system, now all sales enquiries reach the sales desk as emails and also recorded in the database and all enquiries are attended with great care. The customer care manager is able to track and close the customer support requests better and based on ageing reports. Customers/ property owners have their own login to the application and they can review the status of their ticket request they had posted at any point of time.
General/Lucky Draw Management System
Business Pain Point: Our client Malabar Gold and Diamonds, a leading jewellery retailer with more than 100 showrooms across the globe faced a problem in managing the lucky draw contest launched as a part of their campaign Brides of India. They want to consider customers coming to all showrooms across the globe for this contest and want the lucky draw management process to be done from the Head office. Solution given by Sesame: Sesame designed a custom made web application that helped client to manage fetching customer billing value from all point of sale counters and based on some prefixed criteria classified them to different value buckets. The data in each bucket was taken for the automated lucky draw process and winners were declared. This was done centrally from the Head office. Out come : On successfully implementing this system, now Malabar Gold and Diamonds are able to handle Lucky draws without much efforts of gathering data from various branches across the world as they are growing their showroom network at great speeds. They were also able to save a lot of time and manpower when compared to the previous Business Pain Point of doing this process manually.
Travel Segment/Visa Management System
Business Pain Point: One of the leading Travel Agent in Saudi Arabia ( Comfort Travel Group) with more than 20 branches across the world was facing problem in managing their Visa related information and Job applicants . Applicants approached in various branches and enquired about the job application status and from branches they need to call HO each time and enquire about the actual status . This was a tedious process and customers were unsatisfied with this process. Solution given by Sesame: A study was conducted at client side and Sesame proposed a web based centralized Visa Management system with access at each branch and super admin control from the HO only. IF anybody brings a Visa to any branch same can be added to the system and admin team will approve the same. This enabled the feature of viewing Job openings from any branch without calling to the HO. Also job applicant registrations were able to accept from any branch and the status can be viewed from respective branch without contacting the HO. Out come : Client saved a lot of time in managing the visa, job applicants, and also the payment related information. A centralized system helped all users to access information without disturbing each other. Also calls landing at HO from branches and end customers were reduced drastically