Projects

Traffic and sales report generation system

Type Web application
TECHNOLOGIES Ajax, HTML 5, Java Spring, JavaScript, JWidget, oAuth, Percona (MySQL)
AREAS OF EXPERTISE Social networks integration, Google services integration, mailing services integration, payment systems integration, freemarker templates, Intercom.IO, NewRelic
QA TOOLS Browser DevTools, Postman, Apache JMeter, MySQL Workbench, Putty, JIRA, TestLink, Nessus scanner, OWASP ZAP, SQL injection tool, SSL scan, Slow http test, Blue closure
TEAM 3 developers

Our team has built a SaaS system for gathering information from various online resources. The examples of resources are Facebook, Twitter, Google Analytics, Google AdWords and MailChimp. The system is based on marketing algorithms and is intended for tracking traffic and sales statistics as well as other criteria of an e-business success rate. All the statistics is displayed as illustrative graphs. The system analyzes the data and makes (linear) forecasts.

Challenges

Development challenges:

  1. For displaying diagrams and column reports universal and maintainable programs (plugins and libraries) were required. These programs should have been of high operating speed and be able to add new features without any difficulties.
  2. The system was to be integrated with a lot of programs and online resources (more than 20). We needed a universal approach to work with these programs.
  3. JS-code needed to be optimized.

QA challenges:

The application has numerous integrations with such web services as Gmail, Google Analytics, Twitter, MailChimp, Facebook, payment engines and others. The main challenge was to create the test environment with all the integrations. Integrated services had to be configured to provide test data, extracted and processed by the application.

Solutions
  1. For diagrams output we wrote a program from scratch. It is based on SVG. For displaying reports we used jWidget to create the necessary component. For displaying diagrams in the weekly digest we designed (implemented) the complex table layout by using Freemarker templates.
  2. We created the architecture which is based on Java Spring and low-level protocol JDBC.
  3. For optimizing JS-code we developed jWidget SDK instrument.

QA activities:

Functional testing, load testing, usability testing, configurational testing, security testing.

Results
  1. The diagrams and reports are well displayed (on mobile platforms as well). However, these tools are only for the project.
  2. The system has the universal approach for gathering data from a great number of integrated programs and resources.
  3. JS-code was successfully optimized.
Global Event Map application
Global Event Map application
Social network for finding, storing and sharing music
Social network for finding, storing and sharing music