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
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.
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 🚧
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 💻
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.
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).
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).
Retailers (Map view)
- Retailers' location on a map. Additional layers functionality (Jurisdictions, Reference, etc.)
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?
Meet us across the globe
United States
66 W Flagler st Unit 900 Miami, FL, 3313016 E 34th St, New York, NY 10016
Europe
109 Borough High St, London SE1 1NL, UKProsta 20/00-850, 00-850 Warszawa, Poland
Vasyl Tyutyunnik St, 5A, Kyiv, Ukraine
Av. da Liberdade 10, 1250-147 Lisboa, Portugal
