Case Study Automated System for Online Advertisers & Market Research
www.brainvire.com | Š 2013 Brainvire Infotech Pvt. Ltd
Page 1 of 4
Client
Requirement
The client is an award-winning provider of market research and economic analysis on the technical, business and economic aspects within semiconductor, nanotechnology and related industries. It provides intelligence for faster and better decision making in the areas of semiconductors, photovoltaic, LEDs, display, manufacturing, materials and critical subsystems. Brainvire has developed an automated system for Online Advertisers & Market Research for sending and receiving data by providing the advertisers with past and present information related to the market research and analysis, generating various reports and projecting information with a view of enhancing search advertising strategy to improve the user experience and expand the presence in the online market. The users can avail the subscription on any research information and based on that the client provides research and analysis materials, white papers, access to basic reference guides etc. Apart from this, Brainvire is successfully executing CSS (Customer Satisfaction Survey) every year conducted by the client for its customers.
Project
Challenges
Team faced the following challenges:
Generating reports based on the customer satisfaction survey using complex statistical functions with the qualification criteria changing each year.
Integration of Apache Open Meeting into the system for conducting webinars.
Conversion of docx or pptx into pdf which are then sent as attachments.
The conversion is done using Windows server where MS Office is used in conjunction with PHP’s COM library. The PHP script is called which is hosted on the Windows server from a UNIX machine.
The CRM system has a very complex set of business rules so any changes have to be carefully integrated taking into consideration the impact on the system.
www.brainvire.com | © 2013 Brainvire Infotech Pvt. Ltd
Page 2 of 4
Technologies Operating System & Server Management
Development Tools & Environments Database
Used Linux, Multi-Server Architecture with Staging & Production Environment through Version Controlling releases, Load Balancer, Server Optimization, Security & SSL Implementation, Scheduler for Back-ups, Alert Monitoring System Integration, Server Performance Tuning at regular intervals, Software Firewall Configuration & Maintenance LAMP, PHP, Smarty, JQuery, Integration with Third-Party Payment Gateway, Integration with PDF Library for Reports, SAP Integration for Taxing & Billing to Customers MYSQL Database Server, DB Clustering, DB Optimization, Master Slave Replication, Query Optimization, Slow Query Optimization, Scheduler for Backups, Alert Monitoring system integration etc.
Manpower
Project Leader
1
Developers
2
Designers
2
Quality Assurance Testers
2
Planning The following development approach was adopted to equip the application with numerous features and functionality mentioned below: The thorough research and analysis were done at every project level to effectively manage the development process. Designing the application interaction and flow for user-friendliness and interactivity. Growing library of automated email programs covering new releases and recommendations.
www.brainvire.com | © 2013 Brainvire Infotech Pvt. Ltd
Page 3 of 4
Architecture
Development
Highlights
Designed and implemented a highly secure system for online advertisers and market researchers that allow search, view, order and download of data related to market research and analysis based on the client’s preference. Key features include conversion of docx or pptx into pdf, fine tuning, MYSQL and PHP for optimal search time. We are also the server support and created the server from ground up for the client. Search Engine Optimization activities were regularly resorted to with a view to ensure high visibility over the internet.
www.brainvire.com | Š 2013 Brainvire Infotech Pvt. Ltd
Page 4 of 4