Marcel P.

Some projects: - A program that downloads new legal cases / events from a number of jurisdictions from NY State and updates an internal database. This program has to integrate with the Lexis/Nexis TimeMatters application and update its database while preserving all internal constraints. - A backup project that monitors a number of folders and uploads daily changes to a NetDocuments account. This project had to solve a number of challenges: the cloud limits the number of files that can be created in a given folder; the service has to be monitored so that any error or interruption is sent as an email alert – without sending a thousand emails if each upload is failing; we had to build a very flexible scheduler that could handle schedules from "each minute of every day except Sundays" to "the third Wednesday of every month". - A common library of WinForms user controls, from an UI for the aforementioned scheduler to a component that allows the user to write a SQL query and then specify at runtime how the results of the query are to be shown in a grid (column ordering, row sort ordering, column widths and so on).

Developed a web portal for managing access to secure areas, providing capabilities for inquiry and change requests to physical building access and leverage WCF, email notifications, and SQL Server for workflow queuing and processing. Integrated security in a MS domain was used for user authentication and data retrieval, and certificate based TLS authentication was used between services.