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:

• Development of web-based member data conversion status monitoring tool for users being migrated from the legacy mobile banking platform to a new cloud-based online banking platform. The application was constructed in .NET Core 1.1 using a code-first Entity Framework model along with a thin MVC-based user interface accessing all business logic and data services hosted in Web API-based services. The effort also included the development of a generic, dual-mode user access Web API service supporting both .NET Core Identity-based users along with Active Directory-based users using JWT (JSON Web Token) based authentication and authorization ticketing.
• Development of bulk data loading tools for generating status tool user accounts and tools for loading legacy banking members into intermediate conversion databases to support the cloud migration effort. Implemented modifications to a legacy banking web application to support transition of users to the new platform. The technologies used include Visual Studio 2015, .NET Core 1.1, C#, Web API 2.0, JSON, MVC 5, WebForms, Entity Framework, Dependency Injection, JWT, LINQ to SQL, SQL Server, Oracle, XML/SOAP, MVC, ASP.NET, JavaScript, GIT, NuGet, TFS, Postman, Fiddler and MSTest using an agile development process.
• Development of an electronic data exchange service between the county’s locally hosted Confidential case management system and the public defender’s office cloud-based JustWare case management system. This replaced the prior system’s local data entry approach for loading case data.
• The service was constructed with an object model populated using FileHelpers with calls to a cloud-based API via a tiered architecture exposed by a Web API interface for scheduled invocation. The technologies used include Visual Studio 2017, C#, SQL Server 2014, Oracle, Web API, JSON, XML/SOAP, MVC, ASP.NET, Dependency Injection, JavaScript, GIT, TFS, NuGet, Postman and MSTest.
• Design and implementation of the eReferral service for the automated processing of HL7 CDA medical patient records for the QuitPro anti-smoking program. The service uses a multi-tiered Windows service-based architecture to retrieve new patient referral CDA XML format documents coming from clients from a cloud-based data exchange platform (Max-MD) using WCF/SOAP API calls then deserializes the documents into .NET objects for loading in the QuitPro database.
• It also selects outgoing progress reports to be delivered back the clients, constructs new HL7 CDA messages then transmits those to Max-MD for retrieval by clients using WCF/SOAP API calls. The service was implemented with TFS, C#, WCF, SQL Server 2008 R2, Windows 2008R2 and Visual Studio 2013 using an agile development process.
• Development of a web based electronic document publishing application utilizing Variable Data Printing (VDP) and a rule-based client configurable architecture. Contributions included the development of Web API data repositories for interface to SQL databases from an MVC/Angular based user interface. Provided extensive design and development of SQL procedures and views as well as ongoing development of new schema and refactoring of existing schema.
• Utilized SQL Server Data Tools (SSDT) for forward and reverse engineering of the database design, continuous integration and scripted publishing of changes to the test environment.
• Developed the legacy data conversion process and tools for existing client document definitions. Developed the database upgrade process and provided configuration management of the database development environment. The technologies used include Visual Studio 2015, SQL Server 2014, SSDT, C#, Web API, XML/SOAP, MVC, ASP.NET, Dependency Injection, AngularJS, XMPie, TFS, NuGet, Perforce, Postman and NUnit.
• Conversion of a legacy distributed client-server system to a cloud-based web-based architecture and with a unified database design integrating data from several disparate and incongruent databases. This included the mapping of database objects to the new model, resolution of record key and referential integrity concerns and the development of complex data migration scripts to populate the new system from the old. Conversion of an associated legacy transaction auditing system from the old architecture to a new web-based design using a responsive client UI pattern. This included the mapping of database objects to the new model and the related code conversion and regression testing in the new environment.
• Prototyped and implemented a tSQLt-based unit testing framework for complex SQL business rules. The technologies used include Visual Studio 2013, SQL Server 2014, SSDT, tSQLt, Git, BitBucket, JIRA, Confluence, C#, MVC and AngularJS. The work was performed in an agile SCRUM process with two-week sprint cycles.
• Design and implementation of the Mount Beacon Opt-Out web site used by insurance agencies to opt of out of high risk homeowner’s insurance policies.
• The service uses a four-tiered service-based architecture to display and enable update of insurance policy opt-out status. An automated SQL-based reporting feature was developed to transmit opt-out changes to the home office on a daily basis. The site was implemented with TFS, VB.NET, ASP.NET, SQL Server 2012, Windows 2008R2 and Visual Studio 2013 using an agile development process.
• Managed all aspects of information technology and office equipment for Employers Unity. Implemented wide-ranging software and hardware infrastructure modernization and transitioned the organization through a series of major systems upgrades. Acted as technical leader on software system development and maintenance.
• Technologies utilized include Windows 2008-2012 Server, SQL Server 2005-2014, Visual Studio 2005-2013, Team Foundation Server, Office 365 and Office 2013.

Confidential

Senior Developer

Responsibilities:

• Performed bug fixing and enhancements to financial data edit applications using WPF, C# 4.0, SQL Server 2008. Performed bug fixing and enhancements to financial data calculation objects using VB 6, COM+ and SQL Server 2008.
• Performed enhancements to transactional multi-threaded file copying service using C# 4.0, Windows Services, MSMQ and SQL Server 2008.
• As the Software Architect envisioned the integrated solution architecture to meet the stated requirements of the federal grant as well as the 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 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 Confidential -555 collision report data for use by external web service, external web UI clients and internal Confidential 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

Senior .NET developer

Responsibilities:

• 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 Confidential 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

Senior .NET developer

Responsibilities:

• 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

Lead system architect

Responsibilities:

• 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 Confidential ’s Confidential Communicator, C# and .NET XML web services.
• Designed and performed the majority of the development of a .NET and Confidential based batch conversion system to move the active claims from the legacy Adabase database to the CaRES SQL Server database.