Project Goal

Before the project was implemented, company employees did not have direct access to client databases and had to request information from management to determine a lead's status or phone number. As part of the task, a project was launched, after which access to the client database was distributed taking into account each employee's job responsibilities. This solution reduced the management's workload for checking clients and enhanced information security.

About the Project:

• Developed a local closed web service for employees to access the client database.
• For the backend, I had to use a CSV parser to transfer client data into a proper SQL database, as it was initially stored in Excel files.
• The web service allows searching for data on specific clients without giving access to the entire client database to regular employees.

Security:

• Implemented data encryption.
• Introduced a password rotation system.
• Blocked access from external IPs using CDN Cloudflare.