SUMMARY:

More than 21 years of experience as a Technical Lead, Database Administrator, Architect, Programmer, Web and Ecommerce Developer. Eight years managing developers, scope, and customer relationships during large projects.

SKILLS:

SQL Server, Oracle, PostgreSQL, Data Warehousing, ETL, SQL Server Reports, SSIS Database Design, Development, and Administration

C#, VB.Net, XML, T - SQL, PL/SQL, PSQL, Visual Basic, VBScript, HTML, Java Script

SOAP, WCF, REST, Visual Studio Load Test, WinForms, WPF, ASP

TFS, GIT, VSS, SVN, Setup and Administration of Source Control, Build Scripts

Windows Server from NT 4 to 2016, IIS 2 - 10, Azure Services

EXPERIENCE:

Mid-Level Programmer

Confidential, Harrisburg, PA

Responsibilities:

• Developer assigned to team customizing MPSC WIC system for PA DOH
• SQL Server 2014, SSIS, SQL Reporting Services, VB.Net, WinForms, RoboHelp, Smart client, WCF, VS TFS, VS 2015, VS 2015 Load Testing
• Designed, built, and preformed Load Testing using VS 2015
• Modified WinForms VB.Net application to include new functionality
• Modified and created SQL server reports
• Enhanced performance of poorly performing SQL queries
• Created WCF warehouse interface

Programmer

Confidential, Berryville, VA

Responsibilities:

• Monitored and debugged EDI and Microsoft AX transactions
• Maintained, modified, and debugged existing custom estimating and billing systems written in VB.NET, HTML, JQuery, CSS, SQL Server, Excel, and Access 2003
• Migrated and updated Mobile Frame server. Updated and debugged Windows Mobile Clients
• Designed and built Inventory system for Windows Mobile 6.5 client allowing photos of damaged paper rolls to be saved with report. Using WCF for server access.
• Added barcode scanning and decoding through custom Excel add-in
• Used Visual Studio 2008, 2010, 2012, and 2015. Used SQL server 2005 and migrated to 2014
• Remote and onsite database analysis and migration development for JPL Industries out of Harrisburg PA

Programmer

Confidential, Chambersburg, PA

Responsibilities:

• Developer using Visual Studio.NET, 2005, 2008, and 2010 using VB.Net and C#
• Wrote Windows Services, WPF Applications, Web Services, and ASP.Net pages
• Was tasked to learn Lotus Notes and modify existing interface with Salesforce CRM system
• Worked for client to correct errors in old Access and .asp based system. Designed new .NET and SQL Server system

Programmer

Confidential, Winchester, VA

Responsibilities:

• Project Tech Lead - took role to standardize project development and establish design document best practices
• March 2008 - Database Architect - took position at request from peers and management. Responsible for correcting current database architecture issues, engineering future architecture, and moving applications forward
• Support peers in development and debugging
• Maintain legacy VB6, ASP, SQL 2000 applications. Often assigned the issues with higher complexity
• Develop new functionality in new and legacy systems to support international growth
• In corporate new Unicode and International functionality into legacy applications
• Develop new client web interface in ASP.Net and C# using legacy COM+ and web services back end components
• Generate new reports from SQL database

Team Lead

Confidential, Mechanicsburg, PA

Responsibilities:

• Led teams in development of N-tiered applications using SQL Server, Oracle, Visual Basic 6, COM+, OLEDB, ADO, XML, IIS, VBScript, JavaScript and ASP
• Responsible for maintaining the architectural integrity of the applications while integrating requirement changes and senior developer input
• Worked with customers continually to refine new requirements and help them understand their needs
• Defined source control and deployment methodologies
• Project Manager for a small ($75,000) project for PA

Team Lead

Confidential, Winchester, VA

Responsibilities:

• Led development efforts in the e-commerce realm
• Established policies and standards for development using SQL, VB, VBScript, ASP, ODBC, ADO and HTML
• Defined schedules and managed customer relationships during projects
• Designed Database backbone to support all future e-commerce projects
• Helped pre-IPO Company define team development structure and policies
• Led the company in adopting the Rational Unified Process
• Constructed high level application designs using SQL back ends and using VBScript, ASP, VB, Java Script, ADO and ODBC for the front end
• Led a team of senior and junior developers on e-commerce solutions for InPhonic and Electronic Boulevard

Developer - Systems Architect

Confidential, Winchester, VA

Responsibilities:

• Designed, built, implemented, and maintained SQL server databases
• Built interfaces to data using VBScript and Active Server Pages (ASP) for both Internet and Intranet use
• Worked with Microsoft Commerce Server customizing e-commerce sites for a variety of customers
• Used Visual Basic to build applications for specific tasks, for example: email cleanup utilities, database updates, custom reporting, and mass email tools.
• Rewrote MS AdServer code for managing, and targeting ads leaving only the logic for ad frequency intact. Streamlined tracking and reporting of 2 million ads per day for Martha Stewart (MSLO)
• Developed new architecture for MSLO, built the SQL database, programmed the interface, and tied data throughout site
• Setup and managed 27 web servers, 16 commerce servers, and 8 SQL servers for the MSLO website
• Although Primary responsibility was for MSLO, also worked with Ulla Popken, Reba McIntyre, Electronics Boutique, The Car Connection, and various others