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 EXPERTISE:

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, ORM, 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, NuGet, 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

WORK EXPERIENCE:

Confidential

Senior .NET Developer

Responsibilities:

• Recruited and hired a team of five highly talented full-time and contract developers and support technicians.
• Designed and oversaw the implementation of a multi-tiered and secure virtualized server environment completing the transition from a physical server environment.
• 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. The effort resolved difference between multiple database instances to unify the data into a single database with data conversion from the legacy databases to the unified database.
• 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.
• Design and conducted the implementation of a TFS based change control system including the reorganization and restructuring of source code projects into a logical and cascading tree and the recompilation and redeployment from source control to virtualized test and production environments.
• Oversaw and led in the daily analysis and diagnosis of severe custom .NET and ASP application stability and performance issues and led in the surgical correction of diagnosed issues resulting in substantial stability and performance improvements.
• Oversaw the implementation of Office 365 cloud-based email hosting and the migration from a local Exchange-based email system.
• Reviewed, analyzed existing information security practices and began an extensive implementation of a secured environment through physical and logical security mechanism and work procedures.
• Managed multiple vendors including a large managed network vendor contract and a large application development support vendor.

Confidential

Senior Developer

Responsibilities:

• Conducted JAD sessions, business analysis, requirements definition, new business process design, external interface design and functional specification development.
• Assisted in the design and implementation of the application database utilizing forward engineering via SSDT and implemented an SSDT-based test and production installation and upgrade procedure. The new database architecture replaced multiple overlapping and distributed databases with a single centrally hosted design.
• Designed and documented the 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 the 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. The 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 with law enforcement agencies statewide to coordinate the promotion and adoption of the electronic interface. Coordinated interface development by several collision reporting software vendors.
• Provided the system architecture guidance and software design for the development of and ASP.NET web user interface for collision report entry and supplemental report filing.
• Designed and documented the server installation procedures and provided production server installation and administration support.

Confidential

Responsibilities:

• As the system architect and senior developer designed the solution architecture to support the implementation of the web user interface and external system interfaces.
• Assisted in the design and implementation of a flexible unified database design which enabled the centralized storage of variable format product data so that 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 the new common database design.
• Designed and implemented an XML serializable object model to enable the dynamic run-time generation of the 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 with a plug-in architecture using dependency injection to support XML configurable application modules each with 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 the Amazon.com seller item classification schema to enable the 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 the automatic raising and cancelling of alerts based upon business rule logic and associated data state transitions, and, the 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 the application framework to enable the creation of a report library tied to application plug-in modules data views.

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 the 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.

Confidential

Responsibilities:

• As a senior .NET developer performed enhancement, maintenance and production support of the 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 the overall web-based solution concept and sold the core recommendations to the client's executive steering committee to facilitate the 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 the implementation of a hosted application and database environment in a centralized state data center moving away from the previously locally hosted design.
• Assisted in and oversaw the development of a single unified SQL database design which superseded the previously proposed distributed database architecture.
• Guided the 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 the 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 with 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 the 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 the majority of the development of a .NET and EntireX based batch conversion system to move the active claims from the legacy Adabase database to the CaRES SQL Server database.