I am a highly experienced, Microsoft-centric individual who can help your business by maintaining and/or upgrading those business critical, legacy applications that you depend on.

Technologies

● Visual Basic – VB3 to current

● VB Conversions - VB3 to current

● VBScript – 15+ years

● MS Access – All versions (Current)

● MS SQL Server – pre-2000 to current

● ASP/ASP.NET – ASP to current

● Database Upgrades/Conversions – 15+ years

● HTML – 15+ years

● T-SQL, Stored Procedures, Triggers – 20+ years

● MS SSIS – 4 years

● MS SSRS – 5+ years

● .NET WDSL web services

Long term experience with custom client-server development and integration in MS Dynamics SL and GP accounting systems.

Experience

May 2013 - Present Fidelity National Financial – Jack of All Trades

Part of two-man technical team porting ten year old business-critical Access/VB6/SQL Server applications into modern .NET client-server application while keeping ongoing operations running. Personally responsible for developing customer reporting, database maintenance, and life-support for large MS Access application. Accustomed to working with minimal oversight, under rapidly shifting priorities.

●Responsible for development of web service to facilitate high-volume ordering of products.

●Primary contact point for technology transfer to subsidiary in India.

●Used SSIS to perform nightly/weekly/monthly imports of tax and violations data from NYC.

●Transformed NY State ORPTS property and SalesWeb, NYC ECB violation, and NYC RPAD building data into useful, accessible formats.

●Replaced undependable VBA/VB6/MSWord customer product reporting with high-speed .NET application.

●Implemented SSRS Reporting, allowing management to receive regular BI reports that were previously unobtainable.

●Developing automated process to acquire NYC Department of Finance data using Juniper WebConnect HLLAPI interface.

●Reworked customer-facing website to support improved order entry and work retrieval.

●Constantly translating and importing new datasets from various governmental agencies.

October 2010 – May 2013 American Red Cross – Lead Database Engineer

Responsible for development and maintenance of systems used to manage issues with blood donors and recipients. 24-7 high-volume website operations with constant regulatory oversight. High visibility troubleshooting and user interaction.

●Implemented Numara / BMC FootPrints help desk – generating 1000+ tickets daily. Responsible for backend integration with all existing systems.

●Ports of multiple legacy applications off VB6 and MS Access and into .NET and SQL Server.

●Implemented SSRS Reporting, replacing many custom-programmed client reports.

●Provided management data support for effort to reduce open caseload from 25K to 4K.

●Implemented regulatory-required audit trails in online systems.

May 2000 – October 2010 Saros Incorporated – Contractor/Consultant

Clients: Abitibi-Bowater, Shamrock Environmental Services, Dallas County Texas Alcohol Board, AllScripts/MySys, Mine Safety and Health Administration, Blue Max Materials, Wizard Technologies, Scott Madden Associates, TWT Distributors, DyStar/Color Solutions, Buckeye Fire Extinguishers, Wilco/Trade Oil

●Developed web-based safety event tracking for large paper mill (SSRS, ASP.NET, SQL Server, VB.Net, VB6).

●Custom application and reporting development for major healthcare systems supplier (SQL Server, SSRS, VB.NET, VB6).

●Online document management for real estate investment group (VB.NET, ASP.NET, SQL Server).

●Integrated truck weight into order shipping system (MS Dynamics, VB.NET, SQL Server).

●Created rapid development tool for data-driven web sites, allowing the implementation of complex processing flows with minimal input from dedicated programming staff (VB.NET, ASP.NET, SQL Server, SSRS).

●Extremely high-volume EDI order entry into SQL Server and Dynamics SL supporting Family Dollar, Albertsons, AAFES.

●SSIS/SSRS credit card reconciliation solution for major travel-mart/convenience store chain, processing 500K transactions per day.

●Integration of credit card processing and content management into existing web sites (ASP, ASP.NET, SQL Server, Access).

●Implement links between legacy web-order system and MS SQL Server based Solomon Order Management, including credit card authorization. Trimmed multi-day order turnaround to four hours.

4/99 – 5/00 GOLD Imaging, Charlotte, NC - Technical Manager

●Responsible for 3 programmers and 2 production people.

●Hired and managed all the programmers and was integral to day-to-day business operations, including production and support (Visual Basic, various/many database technologies).

●Technically, job consisted of converting raw county tax data and maps into CD based product sold to lawyers, real estate agents, etc.

●Data was originally created on just about every database platform imaginable, from mainframe to PC. Published over 120 titles in one year, each involving a unique data conversion and map cross-reference.

7/94 – 4/99 OPTIM LLC - Consultant

●Software based on my work is currently in production internationally and in at least five manufacturing facilities in the U.S.

●Applications are all various incarnations of a custom manufacturing workflow package (C, C++, Visual Basic, BTreive, Sybase, Informix, DB2, IBM SQL).

●Participated in day-to-day management of business. Heavily involved with Solomon financial system implementations, integration, and enhancement for both U.S and foreign clients.

8/91 – 7/94 Policy Management Systems Corporation - Project Leader

●Team leader for the client management software group. My team was responsible for consulting and modifying the standard product to meet client requirements (C, C++, OS/2, DB2, CICS. COBOL, IBM SQL).

●Spent approximately 6 months in Stockholm and spent the winter of 1994 in Norway supporting products.

10/90 – 8/91 Lowe’s Home Improvements - Lead Programmer

●Lead programmer in small group responsible for hardware interfaces and satellite communications in the new store-management application (C, C++, CICS, COBOL, Informix SQL).

●Developed store system health monitor that reported maintenance issues back to North Wilkesboro over the satellite link.

1/81 – 10/90

●GMD – 10/87 to 10/90: Engineering systems consultant and developer (IBM RISC, IBM 43xx, CADAM, CAEDS, CATIA, C++, Fortran, assembler, CICS, COBOL, IBM SQL)

●Square D - 6/82 to 10/87: CAD Manager, design engineer (IBM 4381, CADAM, CAEDS, hardware design, IBM SQL)

●NCR - 1/81 to 5/82: Test systems engineer (hardware design, assembler, DEC technologies)

Education

●BS Electrical and Computer Engineering, Clemson University

Contact this candidate