Projects

Traffic and sales report generation system

Type Web application
TECHNOLOGIES Java Spring, JavaScript
DURATION 5 years
TEAM 3 developers

The project is a SaaS system for gathering information from various online resources, such as Facebook, Twitter, Google Analytics, Google AdWords and MailChimp. The system is based on marketing algorithms and is intended for tracking sales statistics, traffic and other criteria of an e-business success rate. All 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.

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.

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.
Areas of expertise

Social networks integration (Facebook, Twitter) // Google services integration (Google Analytics, Google AdWords, Google Checkout) // Mailing services integration (AWeber, MailChimp, Campaign Monitor) // Payment systems integration (PayPal, Authorize.Net, Spreedly payment engine) // Freemarker templates // Intercom.IO // NewRelic

Additional Technologies

HTML 5 // oAuth // Ajax // jWidget // Percona (MySQL)

See our client's feedback

See our client's feedback

Speech to Text application
Speech to Text application
Application to store 3D models
Application to store 3D models