SUMMARY

• Outstanding software design and development expertise utilizing relational databases, OOP, services oriented architecture, web and desktop user interfaces, cloud services, role based security, enterprise application integration and visual development technologies.
• Superb solution architecture, business analysis, business process re - engineering, requirements definition, data analysis and synthesis, change control and change management skills.
• Extensive Agile and SDLC expertise including analysis, planning, design, test driven development, continuous integration, configuration management, version control, deployment and production maintenance.
• Wide ranging vertical technology skills including document capture, document management, fax/email/messaging/print integration, real-time network integration (SCADA) and geographic information systems (GIS).
• Excellent technical project management, team leadership, mentoring, training and communication skills.
• Microsoft Certified Technology Specialist (MCTS), Microsoft Certified Application Developer (MCAD), Microsoft Certified Database Administrator (MCDBA), Microsoft Certified System Administrator

TECHNICAL SKILLS

Operating Systems: Windows Server 2016, Windows Server 2012, Windows Server 2008 R2, Windows Pro 7-10

Technologies: NET Framework 4.7, .NET Core 1.1, IIS 7.5+, MVC 5, Entity Framework 6, Web API 2.0, JSON, JWT, XML/SOAP Web Services, Windows Communications Foundation (WCF), WPF, WebForms, WinForms, Windows Services, MS Test, NUnit, Enterprise Library

Databases: SQL Server 2000-2016, Oracle 8-12, MySQL, MongoDB, Access

Languages: Visual Studio .NET 2005-2017 (C#, MVC, VB.NET, ASP.NET ADO.NET, LINQ), HTML5, JavaScript, Visual Basic for Applications (VBA), Visual Studio 6 (Visual Basic, ADO, Visual InterDev), XML, HL7 CDA Transact/SQL, PL/SQL

Configuration Management: Visual Studio Team Foundation Server (TFS), GIT/Jira, Perforce, Visual Source Safe, SourceOffSite, Serena, PVCS

Products and Tools: ArcView, Ajax, Arc/INFO, Adobe Forms, CodeSmith, Confluence, Crystal Reports, Dart PowerTCP Zip, Documentum AppXtender, DotNetBar, EntireX, Excel, FileHelpers, HPC, Infragistics, InstallShield, Kofax Ascent Capture, LINQ, PDF4NET, Postman, Fiddler, Project, MapObjects, Max-MD DIRECT, Rightfax, SAFileUp, SoapUI, SQL Server Reporting Services (SSRS), SQL Server Data Tools (SSDT), TeeChart, TList, Toad, True DBGrid/DBList, tSQLt,, Visio, wodFTPDlx

PROFESSIONAL EXPERIENCE

Confidential

Responsibilities:

• Team Building and Management - Recruited and hired a team of five highly talented full-time and contract developers and support technicians.
• Hardware Modernization – Designed and oversaw teh implementation of a multi-tiered and secure virtualized server environment completing teh transition from a physical server environment.
• Database Upgrade – Designed and conducted a custom application database upgrade and unification from old to new application versions and from SQL Server 2005 to 2014 through reverse engineering utilizing a Visual Studio SSDT database project. Teh effort resolved difference between multiple database instances to unify teh data into a single database wif data conversion from teh legacy databases to teh unified database.
• Software Engineering – Designed and implemented into production a fully automated, object oriented, highly flexible rule-based data transformation and loading system using .NET 4.5 and SQL Server 2014. Performed timely enhancements and corrections to ASP.NET based web applications.
• Software Configuration Management – Design and conducted teh implementation of a TFS based change control system including teh reorganization and restructuring of source code projects into a logical and cascading tree and teh recompilation and redeployment from source control to virtualized test and production environments.
• Application Troubleshooting – Oversaw and led in teh daily analysis and diagnosis of severe custom .NET and ASP application stability and performance issues and led in teh surgical correction of diagnosed issues resulting in substantial stability and performance improvements.
• Office 365 Implementation – Oversaw teh implementation of Office 365 cloud-based email hosting and teh migration from a local Exchange-based email system.
• Information Security – Reviewed, analyzed existing information security practices and began an extensive implementation of a secured environment through physical and logical security mechanism and work procedures.
• Vendor Management – Managed multiple vendors including a large managed network vendor contract and a large application development support vendor.

Confidential

Technical Lead

Responsibilities:

• As teh Software Architect envisioned teh integrated solution architecture to meet teh stated requirements of teh federal grant as well as teh unforeseen requirements arising from implementation of a parallel electronic workflow alongside a manual workflow.
• Conducted JAD sessions, business analysis, requirements definition, new business process design, external interface design and functional specification development.
• Assisted in teh design and implementation of teh application database utilizing forward engineering via SSDT and implemented an SSDT-based test and production installation and upgrade procedure. Teh new database architecture replaced multiple overlapping and distributed databases wif a single centrally hosted design.
• Designed and documented teh system architecture, work breakdown structure and server infrastructure models and performed product evaluation for commercial components required to generate completed reports into PDF format.
• Designed and implemented an XML serializable common collision report object model used to capture all form CHP-555 collision report data for use by external web service, external web UI clients and internal CHP CARS application clients.
• Designed and led in teh development of a highly secure 5-tiered collision report upload cloud-based service bus enabling consistent and simultaneous loading by both local and remote thick or thin clients. Teh service featured a customized dual model LDAP and ASP.NET membership-based role-permission security model for supporting both internal and external user authentication and authorization using .NET 4.0, WCF, C# and SQL Server 2008 R2.
• Designed and implemented an ASP.NET based administration web site for role based security maintenance, user account provisioning and management and site administration.
• Communicated wif law enforcement agencies statewide to coordinate teh promotion and adoption of teh electronic interface. Coordinated interface development by several collision reporting software vendors.
• Provided teh system architecture guidance and software design for teh development of and ASP.NET web user interface for collision report entry and supplemental report filing.
• Designed and documented teh server installation procedures and provided production server installation and administration support.

Confidential

Responsibilities:

• As teh system architect and senior developer designed teh solution architecture to support teh implementation of teh web user interface and external system interfaces.
• Assisted in teh design and implementation of a flexible unified database design which enabled teh centralized storage of variable format product data so dat it could be accessed consistently by a singular data access service. Development of numerous SQL-based data conversion routines to resolved highly disparate and disjoined record keys and record layouts into teh new common database design.
• Designed and implemented an XML serializable object model to enable teh dynamic run-time generation of teh web user interface to provide maximum flexibility for adapting to constantly changing business requirements and opportunities.
• Designed and implemented a 4-tiered web application generator framework wif a plug-in architecture using dependency injection to support XML configurable application modules each wif distinctive SQL or cloud data sources, data presentation views, search filtering, editing controls and validation routines utilizing .NET 4.0, WCF, ASP.NET, VB.NET, SQL Server 2008, XML, Generics, LINQ, AJAX, jQuery and select third party components.
• Designed implemented ASP.NET based administration web tools for plug-in module creation and management, role based security maintenance and user account provisioning and management.
• Designed and implemented a plug-in application module for product information management which mapped to teh Amazon.com seller item classification schema to enable teh automated publication to Skagen's seller storefront.
• Design and implemented a plug-in application module and associated windows service for web order fraud analysis system using several cloud services for address validation, phone account validation and order IP validation.
• Designed and implemented a rule-base configurable Windows service for alerting and notification which enables teh automatic raising and cancelling of alerts based upon business rule logic and associated data state transitions, and, teh automated delivery of related notifications via user alerts, email, SMS text messaging, and twitter posting.
• Designed and implemented complex SQL queries and views to mine and present sales data from Great Plains managed databases for management reporting and operations support.
• Designed and implemented a seamlessly integrated RDLC (SSRS compatible) report definition and execution model into teh application framework to enable teh creation of a report library tied to application plug-in modules data vi

Confidential

Responsibilities:

• As a senior .NET developer designed and implemented SOA enhancements to Aldea to support B2B data exchange.
• Design and development of a Windows service based WCF service host listener using a multi-threaded plug-in architecture which enables teh instantiation of multiple B2B interfaces from a single console using .NET 3.5, VB.NET, XML /SOAP, SQL Server 2008 and Borland StarTeam
• Design and development of component modules to support interface message format definition and versioning.
• Design and development of component modules to support rule-base configurable message transmission error and format validation error alarming, email notification and alarm clearing.
• Created formal design documentation, unit test plans, conducted and documented unit tests and conducted formal code reviews.
• As a senior .NET developer performed enhancement, maintenance and production support of teh MRTU enterprise energy market risk analysis system.
• Development of new back office service applications, extension of existing applications, refactoring and performance improvements using .NET 3.5, C# 2008, SQL Server 2005, Oracle 9i and Windows Compute Cluster 200.
• Implemented configuration management best practices and improved program maintainability, diagnostics and reliability.
• Developed automated validation of Excel spreadsheets used as system input using an Oracle database-driven rule base and VBA macro programming.
• Created formal design documentation, unit test plans, conducted and documented unit tests and conducted formal code reviews, provided production system support and assisted in release installations.

Confidential

Responsibilities:

• As lead system architect envisioned teh overall web-based solution concept and sold teh core recommendations to teh client's executive steering committee to facilitate teh projects’ funding and initiation.
• As technical leader performed business analysis, process reengineering, project planning, system architecture and software estimation.
• As system architect proposed and oversaw teh implementation of a hosted application and database environment in a centralized state data center moving away from teh previously locally hosted design.
• Assisted in and oversaw teh development of a single unified SQL database design which superseded teh previously proposed distributed database architecture.
• Guided teh implementation of a Team Foundation Server based configuration management and version control system to manage all source code, documentation, work tasks, software builds and defect tracking.
• Assisted in proof-of-concept development for document capture, barcode generation, automated recognition, document management and PDF letter generation subsystems using VB.NET, SQL Server and numerous commercial software products including Kofax Ascent Capture, Documentum AX and RightFax.
• Assisted in formal product evaluation, recommendation and subsequent seamless integration of commercial software products and service providers into teh CaRES system using .NET 3.5, VB.NET, ASP.NET, SQL Server, XML/SOAP web services and Windows services.
• Designed and implemented a SQL Server 2005-based document management wif a multi-tiered VB.NET-based architecture to replace a commercial product which failed to deliver adequate performance and reliability.
• Designed and implemented an automated and secure electronic data interchange to teh client's designated medical bill adjudication vendor using VB.NET, Windows services, XML schema, XML/SOAP web services and C# CLR procedures.
• Designed and implemented bi-directional mainframe to .NET interfaces for parallel system operation using Software AG’s EntireX Communicator, C# and .NET XML web services.
• Designed and performed teh majority of teh development of a .NET and EntireX based batch conversion system to move teh active claims from teh legacy Adabase database to teh CaRES SQL Server database.