SMX was engaged to develop a custom .NET Core application that was flexible enough to run on both Windows and Linux. The application needed to allow queries to be parameterized along with connection credentials in order to redact and modify entries in a given database. The application was deployed with connectivity to a target Microsoft SQL server database, pulled image sets based on the user queries, and then posted specific results to Google’s Cloud DLP service for redaction. Cloud DLP service uses machine learning to identify any PII/PIFI information, redacts those fields in the image, and then returns the redacted image to be updated in the database
The initial solution was deployed in under one month. The SoS office has been able to process more than 100,000 image files in a production environment. The tool allows them to run any query or stored procedure necessary to perform the redactions, while checking the accuracy and validity of results. This flexibility, combined with the power of Cloud DLP, ensures that PII/PIFI data can now be easily identified and redacted from these public facing records.
“We now have a tool capable of reviewing not just text, but handwritten documents that have been scanned two, three or more times, along with the ability to attack the most sensitive information such as Social Security Numbers, and refine the search from there”, states the Deputy Secretary of State. He adds that “we’re pleased with the solution provided by SMX because it supports our mission of safeguarding government and corporate records”.