Mark C. Stafford

My role at iCentris involves data transfer and the schemas in which the data is stored. Getting the clients' data in to our system is foundational to our product. Speed, accuracy and reliability are paramount. Effective communication with business clients and in-house developers is essential. My day-to-day tasks involve designing, implementing and maintaining schemas and the flow of data. Reducing and removing bottlenecks in networking, disk I/O and processing has lead to a 92% cut in a 3-hour procedure which now takes only 15 minutes. I also wrote a Java application to extract structures, procedures, etc., from the Oracle Server to track changes over time in Subversion.

I was a key participant in Lexington's conversion from FileMaker Pro to MySQL, normalizing and indexing data for optimal retrieval. I designed and implemented a dynamic application security system. I created a PHP-based monitor to log and police excessive database resource usage. I also automated multiple systems within FileMaker Pro prior to the conversion.

I developed and maintained an ODBC-connected Microsoft Access sales commission reporting application which connected to an Oracle database. Development included Oracle PL/SQL Procedural and Object-Oriented Programming in Visual Basic for Applications. Honors included Employee of the Year award.

Remotely diagnosed and resolved nationwide problems with coworkers' operating systems, networking and applications. Strong familiarity with weaknesses of and solutions for Microsoft operating systems and applications. Expanded Help Desk functionality to include end-user training and some database reporting. Won Employee of the Quarter award.

Led classroom instruction in Lotus Notes and Microsoft Office applications.