Description
Many of these achievements were done from past employers as a consultant to another company with work that was usually a mixture of onsite and offsite work. Managed projects for Agiline (see below) for development by overseas programmers including database and application design and architecture of their databases. Functioned as Database architect in a team for a Health Services company developing in-house medical web and SQL application including audit control company workflow processes for their claims processing. Designed and managed their Build process (Team Foundation Server). Deployed numerous SQL installations (50+ with at least 8 clusters) and SharePoint installations (20+) including multi-domain Active Directory domains DMZ domain and extranet access * Completely rewrote the data tier of the primary website for a California MSP to make use of SQL access technologies immune (or nearly so) to SQL injection as well as enabling for the first time effective execution plan reuse and substantial improvement in performance * Implemented missing data integrity constraints (there were none) for the same company above and audit logging through SQL Change Data Capture (CDC) * team pushed forward the programming methodology towards Test-Driven Development (TDD) both for C# components and SQL statements (using FMTONLY) * Developed and deployed connectors to external web service interfaces to provide scheduled synchronization of billing data (one using SOAP another use REST) Designed implemented and deployed ASP.Net tracking system for hourly employees including export to ADP payroll management approval and Active Directory integration. * Designed the hardware and software architecture for a multi-host virtual server programming environment (VMware and some Hyper-V) including Cisco firewall network infrastructure multiple domains certificate and mail servers and development engines for the all company's developers. * In a team designed and implemented the data tier for migration from an IBM mainframe application (claims processing for medical benefits) to Microsoft .Net Windows application and SQL Server and IBM DB2. Designed implemented and deployed a Windows .Net tool (LEEDS assessment) with XML local data storage. * Collaborated on $250K migration from SQL 2000 to 2005 (legacy stock exchange service) including multi-terabyte databases partitioning optimization and ETL for FTP and other data sources using SQL Server Integration Services with special emphasis on high performance as required for stock exchange activities.