KEVIN FAIRCHILD 11541 Murcott Way Land O' Lakes, FL 34638 kevin@developmentgeek.com 727.753.8467 ________________ SUMMARY 10+ years of success and still passionate about developing software. Achievements include software projects focused on the reduction of operational expenditures, increase of revenue, and retention of customers. ________________ SKILLS SQL Server 2008 TSQL Visual Studio 2010 VB.NET FxCop / Code Analysis Team Foundation Server 2010 AForge.NET Balsamiq Mockups QuickFuse ________________ EXPERIENCE Sr. Software Developer AnazaoHealth Corporation - Tampa, FL 2007-Current 1. Designed an automated process for detecting duplicate patient records at data entry. This was based upon many factors, such as overlapping phone numbers, physicians, or matches to identifying information (such as SSN). The most complex aspect of this was a cross-reference system based on first names. This last piece helped recognize a link between names like "Robert Smith" and "Bob Smith". Potential duplicates were then ranked by a confidence-level score, so only highly-likely matches were shown to the users. 2. Improved the quality of our code, through custom exception logging. This allowed unhandled exceptions to create work-orders in the company's bug-tracking software (Track-It). New exceptions include a screenshot, system/user information, and additional details about the exception. Previously-reported exceptions alert the user that it's an issue currently being worked on. This added visibility to issues that might otherwise go unnoticed. 3. Developed a data cleanup processes to sanitize physical addresses in the system, built upon web-tools from USPS. This enabled staff to catch data-entry errors prior to shipment and helped identify potential duplicate records. 4. Created custom Code Analysis rules and participated in peer code reviews, to ensure code-compliance across projects. 5. Utilized AForge.NET to build a tool for the company's digital radiograph, allowing radioactive "seeds" to be identified by the system for QA purposes. True-to-scale printing enabled the company to print these images on standard printer paper, rather than relying on expensive radiograph film. 6. Designed and implemented a payment collection system using Authorize.Net's CIM system, as part of a PCI compliance project. 7. Improved customer service experience and response times by integrating TAPI support into the in-house application used by customer service, allowing employees to quickly view the profile of the patient they are on the phone with. 8. Created an outbound IVR application, built around the QuickFuse IVR service from Plumvoice, to contact patients and remind them about expiring prescriptions, improving customer retention and prescription-refill sales. 9. Replaced high-cost subscription from First Databank with database information available from the FDA. This enabled the company to get the information it needed and provided a huge cost-savings for the company. Sr. Software Developer Sten-Barr Medical, Inc. - Tampa, FL 2000-2007 1. Migrated legacy databases from MS-Access to SQL Server 2000 with VB.NET winform front-ends. 2. Assisted in implementing and modifying Actsoft's CometTracker application to allow forwarding of orders sent to phones by writing custom stored procedures and DTS packages. 3. Automated reports for internal and external customers utilizing SQL stored procedures, DTS packages, and Network Automation's AutoMate product. 4. Optimized SQL Server query, indexes, and stored procedures using industry best-practices. 5. Initiated code review processes, as a way of catching things that normally would have gone unnoticed. Problems discovered ranged anywhere from minor things like assuming a dataset would always have results to larger issues, like an incorrect set of joins throwing off a query for the accounting department. 6. Provided database administration help to the systems administrator, whenever assistance was needed with database backups, maintenance plans, or security. ________________ EDUCATION St. Petersburg College — 2003 Oracle Database Development, A.A.S. ________________ REFERENCES Available upon request.