SUMMARY:

• Proficient in Visual Basic 3/4/5/6/Visual Studio.NET (VB.NET,C#,ASP.NET)/ 2003/2005/2008/2010/2012, C, ASP, XML, Pascal, Fortran, C++, HTML, DHTML, JavaScript and Perl (cgi).
• SQL Server DBA (all versions)
• Successfully develop in Tandem, MS - Windows, UNIX and MS-DOS.
• Able to utilize SQL Server 6.5/7/2000/2005/2008/2012/2014, Oracle 8/10, ANSI-SQL, MS-Access and DB2 relational databases. Strong skills in writing stored procedures/functions/triggers, indexes, performance tunning, maintenance and disaster recovery.
• Achieved the planning, designing, implementing, testing and maintaining of complex systems and software over multiple platforms.
• Experience in migrating VB6 applications to VB.NET and C#.

PROFESSIONAL EXPERIENCE:

Confidential, Lousiville, KY

Software Developer

• Implemented Dynamic Proxy Web Service Clients to consume and call traditional SOAP based or WFC based web services. Consuming the WSDL and compiling the proxy in memory. Building the structures generically and calling the web services based on a dynamically designed XML structure.
• Created SQL Sever Reporting Services reporting engine. Both Sever (RDL) and Local (RLDC). Even if SSRS was not installed, the same report would work locally (RDLC).
• Conversion of VB.NET to C# Windows Service implementation. Supporting both languages and multiple .NET frameworks

System Analyst/Software Developer

• Designing and implementing publishing management software. Including managing clients, orders and invoices. (SQL Server 2005/C#)

System Analyst/Software Developer

• Performed enhancements to existing Scheduling software for DNA samples. (MySQL, Servoy)
• Working on import/export process for customer’s paternity DNA information. (MySQL, Servoy)

System Analyst/Software Developer/SQL Server Admin

• Working with outside organizations after we were acquired to migrate data to and from different entities. This included multiple types of data from multiple sources and databases. (SQL Server 2005/2008/C#/VB.NET)
• Developing SharePoint services to provide decoupled information to applications. (SharePoint/C#/SQL Server 2008)
• Managed and created migration application, scripts, etc. for a closed facility of all data to a new facility.
• Utilizing SharePoint Server and SQL Server reporting server to provide Business Intelligence reports for management and users. (C#/SharePoint/SQL Server 2008)
• Performed full lifetime development cycle for new application to be used in the field by collectors to enter sample collection information, take photos and capture signatures for collections. Then once able to connect to internet to upload all of this information for pre-accessioning of collections via a new web service I developed. (C#.NET/ASP.NET/SQL Server 2005)
• Converted several Visual Studio projects to Visual Studio 2008.
• Designed, developed, delivered and maintained a collector management system. Including handling schedules, payroll and integration with our Great Plains accounting system. This also included using SQL Server replication. (VB.NET/SQL Server 2005/Great Plains)
• Added capabilities for Private Paternity DNA website to handle Brokers and Affiliates for orders. (VB.NET/SQL Server 2005)
• Developed a new web service to handle Private Paternity DNA orders from the Private Paternity website. (VB.NET/SQL Server 2005)
• Performed migration of data from a company we acquired into our internal systems. (DB2/SQL Server 2005)
• Developed new metrics reporting for management. (VB.NET/SQL Server 2005)
• Converted all Visual Studio 2003 projects to Visual Studio 2005.
• Enhanced and maintained several C#.NET web applications.
• Converted several VB6 applications to VB.NET applications.
• Integrated robotics into our LIMS Forensic DNA system. (Tecan)
• Converted applications and reports from Crystal Reports to Active Reports.
• Trained and mentored developers on existing internal applications.
• Performed duties as Team leader for all developers now and going forward.
• Added capabilities for result PDFs and subjects collected PDFs with signatures to be retrieved via the Paternity DNA website or the Paternity DNA webservice for clients. (VB.NET/ASP.NET/SQL Server 2005)
• Converted all of our applications and databases to utilize SQL Server 2005.
• Provided all DBA roles for SQL Server now and going forward.
• Created a web service to allow clients to pull their case results and specimens for Paternity DNA. (VB.NET/ASP.NET/SQL Server 2000)
• Adding capabilities to new Paternity DNA website for clients to create and maintain their own Schedules for sample draws.
• Developed new Paternity DNA website for general information and for our clients to get their case results, statistics and conclusions. (VB.NET/ASP.NET/SQL Server 2000)
• Collaborated in designing, developing, delivery and maintaining Call Center application to handle all sales calls and processing of Private Paternity Cases. (VB6/VB.NET/SQL Server 200)
• Rollout of LIMS for Forensic DNA to three different facilities.
• Developed import/export process for specific client requirements for our Paternity DNA Scheduling and Lab Process. (VB6/VB.NET/SQL Server 2000)
• Collaborated in designing, developing, delivering and maintaining Lab Management System for Forensic DNA testing. (VB6/SQL Server 2000)
• Worked on ASP.NET enhancements to existing Paternity website. (ASP.NET/SQL Server 2000)

System Analyst/Software Developer

• Altered existing applications for bank transaction data to handle multiple banks. It was designed for one bank and needed to be generic. Translation logic was added to parse the various data files. Performance was increased by a factor of five.(VB6/SQL Server/Windows NT/2000/2003)
• Handled support of existing production applications. In the process, increased performance in each application repaired or evaluated.(VB6/SQL Server/Oracle/Windows NT/2000)
• Reverse engineered existing C application and rewrote from scratch using VB.NET and Oracle 8i. Application retrieved data and created several types of reports. The reports were then printed, faxed or emailed. The success of each type of delivery was tracked. The ability to regenerate and send any report from any date was an enhancement. Multithreading technique were used to improve overall speed and responsiveness of application.(VB.NET/Oracle/Windows XP)

Vice President/System Analyst/Software Developer

• On going support and enhancements to existing software..
• Helped with database design, software design and initial implementation of the second generation Lab Management Software (LIMS). This including new concurrency logic throughout the application.
• Developed scheduling tool for paternity testing. Allows client service representatives to schedule individuals to have DNA samples drawn to determine probability of paternity. Using a centralized database accessible from anywhere on the Internet, the installation base spanned virtually the entire US. Each laboratory already had proprietary databases with vastly differing structures, thus a common XML interface was defined and an XML server implemented at each location. These XML servers used Versign certificates and SSL technology for security. The web-based application connects to the lab XML servers to add/update cases to the individual labs when schedules were modified. Users can search cases at individual labs and access test results. (VB/SQL Server/IIS/XML/Windows 98/NT/2000)
• A website was put in place for clients and private parties to access there test results using the XML server interfaces. (VB/ASP/IIS/XML/Windows 98/NT/2000)
• Created automatic updating and distribution software for new releases of all of the company applications. All users were at remote locations. The software atomically downloads and installs new versions of updated files. (VB/Windows 98/NT/2000)
• Performed on-site training, product demonstrations and created extensive on-line help manuals for users. (VB/RoboHelp/Windows 98/NT/2000)
• Worked with team on building a Lab Management system for Forensic and Paternity DNA testing. The system encompassed all aspects of lab management. From the time a sample came in the door, interfacing with all of the testing equipment, quality control and finally reporting the results. This software is now used throughout the largest Forensic and Paternity DNA labs in the world. (VB/SQL Server/Windows 98/NT/2000)
• Created Ad Server for local dot com company on their existing website, Ads would rotate based on logged in users locality and current web page or category. Created Management tool for the ads, companies advertising and localities. (VB/SQL Server/ASP/IIS/Windows 98/NT/2000)
• Developed application for DNA lab tray provider to create Antibody tray definitions and export. Second application would import and use data to input results for patients. The database would be synchronized from application at tray creation location to the various testing labs at separate locations. Several standard calculations are built in for reporting based on inputted results. (VB/Access/Windows 98/NT/2000)

System Analyst/Software Developer

• Engineered Fund Administration tool. This application was used to import proprietary bank account data into a common database. Then daily posts were performed and fund performance calculated. Investor reports created on daily basis and distributed via e-mail, web login or fax. This product managed new investments, multiple and complex fund types, quarterly and yearly reconciliation, collapsing shares and extensive reporting. Adding new investors or investments at any time. (VB/SQL Server/ASP/IIS/Windows 98/NT)

President/System Analyst/Software Developer

• Created web site for company. Site is primarily a Visual Basic resource site. (Macromedia Dreamweaver/JavaScript/Perl/FrontPage//UNIX)
• Developed Visual Basic Developer shareware tool. Available through Internet via Web Site. (VB/Windows 98)
• Implemented Client/Server Visual Basic application to import SQL Server database to AS400 DB2 database. (VB/MS SQL Server/AS400 DB2/Windows 95)
• Produced Client/Server Visual Basic application to use Windows GUI interface to collect data and paste to AS400 emulator screens to bring customer service AS400 applications to Windows. (VB/AS400/Windows 95)
• Designed and implemented Windows NT Service to monitor invoice data on AS400 and print invoice on local network printer when invoice was ready to print. Service automatically runs without user intervention. Can be controlled from AS400 configuration table. (VB/AS400 DB2/Windows NT)
• Converted single-user VB/Access application to multi-user VB/Oracle application. Many features and enhancements were completed for the commercial application. The application, Prism, is now an enterprise solution capable of operating on Oracle or SQL Server backends. (VB/Oracle/Windows 95/NT)

System Analyst (Independent Consultant)/Software Developer

• Designed and implemented Travel Agency Group Reporting software. This included database and software. Application used to track contact and reporting information using MS-Access. (VB/Windows 95)
• Designed and created Employee and Employer relationship tracking software. Application primary used to track demographic, employment and financial information and the affiliations between client and various companies using SQL-Server. (VB/Windows 95)

System Analyst/Software Developer

• Designed multiserver solution utilizing DCOM, Visual Basic, Multithreading and dynamic method invocation. (VB/Windows NT/SQL Server/ASP/IIS)
• Implemented Registry Wizard to register Active X DLLs on remote servers. This utility gave developers the ability to register DLLs from their local workstation on NT servers. The utility stops applications that may be using the DLLs, unregisters the old DLL, copies the new DLL, registers the new DLL and starts the applications on the NT server. (VB/Windows NT)
• Created general DLL tester. Developers provide the library and object name of the DLL they wish to test. The DLL tester will give a list of methods and properties. Once a method has been chosen, the parameters to that method are displayed. The developer sets the appropriate properties and parameters and calls the method. (VB/Windows 95/NT)

System Analyst (Consultant)/Software Developer

• Developed Intelligent Update Utility to update any files on the local machine from an NT Server. Launched from client/server application when new version exists. (VB/Windows 95/NT)
• Helped in development of large client/server application providing associates complete access to data in several physical locations, including the Internet. (VB/Windows 95/NT/Internet/SQL Server/ASP/IIS)
• Created and maintained ActiveX DLLs used by client/server system. (VB/Windows95/NT/SQL Server)
• Designed Service Monitor tool to ensure client/server related Services continue running and processing data. The Monitor will restart any stopped services in a specified order. This design included use of DCOM technology to provide a client tool for using the Server Monitor remotely. (VB/Windows 95/NT/DCOM/SQL Server)
• Built installation program for client/server application. (Install Shield Express/Windows 95)

Software Engineer

• Created on-line non-stop Transaction Authorization Server used Nation wide at gas stations. (C/Tandem/ANSI-SQL)
• Developed Client/Server Windows Applications using ODBC/RSC/Visual Basic/C. (VB/C/Windows 3.x/ 95/Tandem/ANSI-SQL)
• Automated processes and procedures using Netbatch. (Netbatch/Tandem)
• Designed and implemented numerous applications for on-line transaction processing system. (C/Tandem/ANSI-SQL)
• Produced complete design documentation for implementing new on-line transaction processing system. Including new database structures and access. (Windows 95/Tandem)
• Created design specifications for developers to implement new system. (Windows 95/Tandem)
• Developed client/server interface for new system utilized by internal and external sources totaling 200 users in different locations around the country. (Windows 95/Tandem)
• Built installation program for client/server interface referred to as Online System Interface. (Windows95/Tandem)
• Created application update procedures to allow users from any physical IP connection to get Online System Interface patches and updates. (Windows95/Tandem)

Application Development Engineer

• Enhancements to existing commercial database development product. (Windows 3.x/FilePro)
• Engineered UNIX migration of various in house applications. (Windows 3.x/UNIX/FilePro)
• Developed library of routines to support Binary Large Objects (BLOB) in database fields. (Windows 3.x/UNIX/FilePro)

Programmer/Analyst

• Developed SQL based on-line electronic data interchange transaction editor for claims clearinghouse. (Tandem/ANSI-SQL)
• Implemented several support utilities and SQL interfaces for users of claims clearinghouse. (Tandem/ANIS-SQL)
• Coordinated with System Engineers in the development and implementation of claims clearinghouse. (Tandem/ANSI-SQL)
• Evaluated several X12 translator products. Implemented the addition of X12 translator on UNIX platform to claims clearinghouse on Tandem. (Tandem/UNIX)
• Integrated communication between UNIX and Tandem for supporting X12 translator.