• Home
  • Case Studies
  • SaaS tool to track licenses for the sale of tobacco products in the US market

SaaS tool to track licenses for the sale of tobacco products in the US market

The product was developed by WSU in partnership with a U.S. state government tobacco policy enforcement agency.

Industry

Government, SaaS

Project duration

March 2020 - July 2021

Country state

USA

Team

13 members

Technology

SaaS tool to track licenses for the sale of tobacco products in the US market, image #2
Python
SaaS tool to track licenses for the sale of tobacco products in the US market, image #3
React
SaaS tool to track licenses for the sale of tobacco products in the US market, image #4
Django
SaaS tool to track licenses for the sale of tobacco products in the US market, image #5
AWS

The product was developed by WSU in partnership with a U.S. state government tobacco policy enforcement agency. πŸƒ

A web platform was developed in partnership with Counter Tools and Green Info Network exclusively for the U.S. state government tobacco policy enforcement agency.Β 

The product helps to address data management requirements related to monitoring and verifying the sale of tobacco products in accordance with U.S. law.

β€” Data comprehensive filters;Β 

β€” In-depth reports to equip state and local agencies with information to strategize and enforce more efficiently;Β 

β€” Automated data management to support the licensing and enforcement efforts;

β€” Accessibility with ADA Standards for individuals with disabilities;

β€” System support with the latest version of Internet Explorer, Chrome, Firefox, Safari.

SaaS tool to track licenses for the sale of tobacco products in the US market, image #6

Results ✨

Import and normalization

The task involved loading data from all trading points and licenses in the U.S. state, normalizing the data, checking for duplicates, and tracking changes such as transitions between different types of trading points or name modifications.

Browsers

The project achieved seamless functionality across a variety of web browsers, including Internet Explorer, Chrome, Firefox, and Safari.

Automated data management

The project implemented automated data management, improving efficiency and accuracy in handling information.

Accessibility with ADA standards

The platform adheres to ADA standards, ensuring accessibility for a diverse user base and promoting inclusivity.

Project goals ⚑️

Develop the new system from scratch, implementing a complete overhaul and update of both frontend and backend components to introduce new functionality.

Automate data merging from various sources.

Automate retailer information updates.

Allow for retailer geocoding with available map overlays.

Provide a solution for managing retailer list

Automation of the process of collecting information.

Data monitoring and filtering.

Providing ADA support.

Challenges β›°

01.

Import and export: Automation the process of collecting information through a user-centric interface.

02.

Data monitoring and filtering: Providing changes, modifications, and improvements to an existing solution.

03.

Support ADA standards: The platform was accessible to a wider range of users, the software promotes inclusivity, equality, and usability for all stakeholders involved in the monitoring and verification of tobacco product sales.

04.

Responsible design: Approach should respond to the user’s behavior and environment based on screen size, platform and orientation.

05.

Multi-browser project (Explorer, Chrome, Firefox, Safari): The project had to be compatible with multiple browsers, including older versions of Internet Explorer.

The process 🚧

The project followed a strategic development process, beginning with a thorough Discovery Phase, transitioning into Active Development, optimizing browser compatibility, implementing ADA support, addressing bugs, and concluding with refining extra functionalities, all within a 1.5-year timeframe.

Stages 🎒

01.

Discovery Phase: WSU conducted thorough product analysis, user interviews, and created personas to establish a foundation for the project.

02.

Active Development: During this phase, the team built the web platform from scratch, introducing new functionality and aligning development with project goals.

03.

Covering 4 Browsers: Emphasizing user experience, the team optimized the platform's compatibility across Internet Explorer, Chrome, Firefox, and Safari.

04.

ADA support: A dedicated month was allocated for implementing ADA standards, ensuring the platform's accessibility for users with disabilities.

05.

Bugs Fixing: This phase focused on identifying and resolving bugs, ensuring a stable and reliable platform through rigorous testing and continuous improvement.

06.

Finalized Extra Functionality: The concluding phase involved refining and enhancing the platform with additional functionalities beyond the core requirements, preparing it for deployment.

Team composition πŸ‘¨β€πŸ’»

1 Project Manager

1 Tech Lead

1 UI/UX Designer

5 Front-end developers

2 Back-end Developers

3 QA Engineers

Business analyst

Technology stack βš™οΈ

Back-end:: Python, Django, Celery, Gunicorn, Docker, nginx

Back-end host service:: AWS (EC2, S3, RDS, ElasticCache)

Front-end:: React + React-Redux + Styled-components + Docker + nginx

Front-end host service:: AWS (EC2)

Database & Communication protocol:: PostgreSQL, Redis

Core features πŸ’»

SaaS tool to track licenses for the sale of tobacco products in the US market, image #7

Filtering system

  • Filters allow you to sort data correctly:
  • Edit lockout mechanism - the inability to edit information in the system at the same time as other users.
  • Export and quick import of data. The downloaded data is not lost if the import is interrupted at a certain stage.
  • System load allows 100 people to use it at the same time.
SaaS tool to track licenses for the sale of tobacco products in the US market, image #8

Dashboard

  • The dashboard will be customized per each user type accordingly. For now, we defined a couple of useful data blocks to be shown here (CDTFA example).
SaaS tool to track licenses for the sale of tobacco products in the US market, image #9

Retailers list

  • List of retailers information with the ability to search & filter by some specific criteria. ADA support (for example, the layout of components is such that zooming allows you to zoom in on the screen by 400% and continue to use the system).
SaaS tool to track licenses for the sale of tobacco products in the US market, image #10

Retailers (Map view)

  • Retailers' location on a map. Additional layers functionality (Jurisdictions, Reference, etc.)
SaaS tool to track licenses for the sale of tobacco products in the US market, image #11

Reports

  • Full report view with the ability to select filtering options and generate a report. Generated data will be calculated and displayed on the same page so that the user may view the generated data without printing or exporting.

More case studies

Do you want to start a project?

Privacy Policy
Please fix errors

Maksym Petruk, CEO

Maksym Petruk
Banner photo

Meet us across the globe

United States

United States

66 W Flagler st Unit 900 Miami, FL, 33130

16 E 34th St, New York, NY 10016
Europe

Europe

109 Borough High St, London SE1 1NL, UK

Prosta 20/00-850, 00-850 Warszawa, Poland

Vasyl Tyutyunnik St, 5A, Kyiv, Ukraine

Av. da Liberdade 10, 1250-147 Lisboa, Portugal