Cyril DROUET's projects
List of the completed projects
Projects realized with the lawfirm
Period
Title
Objective
Carrying out
Result
2009 à 2010
Project of modernization of the trademark watching
Reduce the work from 6 months to one month at the trademark watching department
Automate all the tasks with a minimum of operation by creating an Access database
-Group all the trademark watches connected with their trademark, their domain names, and the company names in the trademark database;
-Calculate every estimate according to the customer needs;
-Edit the customer proposals and the covering letters ;
-Edit the customer instructions intended to the watching service provider
-Edit invoices, the renewal statements, and the covering letters;
2011
Widen the project on all the sites of the lawfirm
-Migrate the database on SQL SERVER 2000
-Create a data collecting interface for the sites
-Design the SQL SERVER
-Add data
-Centralize the data
-Establish statistics on the whole lawfirm
2012
Design a document management system (DMS)
-Scan 10 m3 of the records
-Scan all the incoming and outgoing documents of the lawfirm
-Create electronic files
-Use a big scan to digitalize all the paper documents with OCR 300 dpi and the bar code then edit them in PDF/A
-Create an Access data to use the DMS process : metadata, integration, capture, indexing, storage, searching and publishing
All the staff can use the DMS process with the interface