John Patrick Dempsey


Biography

Highly skilled full stack .NET Developer with over 8 years of experience in designing, developing, and maintaining robust applications using the .NET framework. Proficient in C#, ASP.NET, and SQL, with a strong background in both front-end and back-end development. Demonstrated ability to optimize code for performance, implement scalable solutions, and integrate complex systems. Adept at working in Agile environments and collaborating with global cross-functional teams to deliver high-quality software solutions. Proven track record of successful project outcomes and a commitment to continuous learning and professional development.

Education

Sacred Heart University

M.S. Computer Science & Information Technology
August 2016



University of Connecticut

Bachelor of General Studies
May 2011

Technical Skills

  • Languages:
    • C# | T-SQL | HTML | XAML
  • Technologies:
    • .NET Framework 3.5, 4.x | .NET 8 | ASP.NET | MVC | ADO.NET | Bootstrap | CSS | AJAX Control Toolkit | JavaScript | LINQ | Entity Framework | WinForms | WPF | Microsoft Azure | SSL certificates
  • Developer Tools:
    • Visual Studio 2010/13/17/19/22 | DevExpress | Syncfusion | Microsoft SQL Server Management Studio 2008/12/14/17/18/19 | SQL Server Data Tools | Azure Data Studio | Microsoft Data Migration Assistant | MySQL Workbench | SQL Server Migration Assistant for MySQL | SQL Developer | Power BI Desktop | ReSharper | Azure DevOps | log4net | SSIS | SSRS
  • Servers:
    • Windows Server 2012 R2 Standard | Microsoft SQL Server 2008 R2/12/14/16/17 | MySQL Server | Bonobo Git Server | Azure Virtual Machine Windows Server 2019 IIS 10 | Windows Server 2022 IIS 10 | Oracle Database 21c
  • Source Control:
    • Azure Repos | GitHub | TFS
  • Applications:
    • Microsoft Office 2010/13 | Beyond Compare 4 | MS FrontPage 2003 | Microsoft Expression Web 4 | InstallShield X/2018 | FileZilla Client | Open Broadcaster Software (OBS) Studio | Microsoft Teams | Skype | Webex Meetings | Zoom | Rally
  • Software Development Practices:
    • SDLC | Agile
  • Continuous Integration:
    • TeamCity | JIRA | Jenkins | Azure Repos | GitHub | TFS | SDLC | Agile

Work Experience

CVS Health – Remote

.NET Developer - Consultant
Feb 2023 – Mar 2024

  • Developed C# console apps in .NET 4.6.1 to extract and transform MySQL data, FTP to mainframe, ensuring data integrity.
  • Used MySQL Workbench for schema creation and data manipulation, enhancing database efficiency.
  • Collaborated with SCRUM team via MS Teams, ensuring seamless project coordination and timely delivery.
  • Perform unit testing on C# applications, ensuring high code quality and reliability.
  • Implemented task parallel library in C# for multi-server data extraction and comparison, improving data analysis processing and system performance by over 50%.
  • Leveraged TeamCity and Octopus for streamlined build and deployment processes, resulting in faster and more reliable software releases to Windows Server 2019.

Fox Rothschild – Remote

.NET Developer - Consultant
Mar 2022 – Feb 2023

  • Implemented ASP.NET Webforms and MVC with Data tables, improving user interface functionality.
  • Utilized AJAX toolkit controls via NuGet, optimizing webform performance.
  • Managed SQL Server databases with 300+ tables, ensuring data integrity and accessibility.
  • Collaborated in Agile teams, contributing to weekly sprints and project milestones.
  • Developed internal web applications using C# .NET, leveraging ASP.NET Webforms and MVC. Integrated complex databases and implemented AJAX controls for enhanced functionality.
  • Managed multiple server environments, ensuring seamless deployment across Development, Lab, and Production. Utilized Team Foundation Server for efficient source control.
  • Participated in Agile methodology, contributing to weekly meetings and fostering team collaboration. Adapted to evolving project requirements and deadlines.
  • Optimized web application performance by leveraging latest .NET frameworks and AJAX toolkit. Implemented creative solutions for complex database interactions.
  • Delivered high-quality internal web applications, improving organizational efficiency. Consistently met project milestones while adhering to best coding practices.

Credit Suisse - Remote

MS SQL .NET Developer - Consultant
Dec 2019 - Mar 2022

  • Engineered robust C# ASP.NET MVC web apps, enhancing financial data analysis capabilities and user experience for the team.
  • Developed and optimized SQL queries for financial data analysis, enhancing data processing efficiency and accuracy in the team’s reporting systems.
  • Spearheaded migration from console to web applications, improving user accessibility and streamlining financial data interaction processes.
  • Designed and maintained robust logging systems using log4net, ensuring comprehensive error tracking and system performance monitoring.
  • Implemented CI/CD pipelines, streamlining project builds and releases with automated notifications.
  • Developed custom reports with SSRS 2017, improving data accessibility for the team.
  • Utilized Jira for project management, fostering effective team communication and ensuring timely delivery of high-quality software solutions.

Dr. Hervey Weitzman – Bridgeport, CT

.NET Developer - Consultant
Sept 2012 - Dec 2019

  • Installed and configured Windows Server 2012 R2 Standard and MS SQL Server 2014.
  • Designed, coded, and maintained website in HTML5, CSS3, Bootstrap 4, and JavaScript while hosted on IIS 8.5 web server with an installed SSL certificate.
  • Created a MS SQL database and created tables, stored procedures, views, SQL statements for daily database operations for the outpatient tracking application.
  • Coded CRUD operations, joins and implemented search capability for patient lookup via stored procedures.
  • Graphed program metrics via DevExpress third party charting controls.
  • Created several jobs via SQL Server Agent that queries on multiple tables and backs up.
  • Created matrix and tabular reports on database tables using SQL Server Reporting Services (SSRS) and output the reports in various formats such as (.pdf, .docx, xls). Developed and maintained C# MVC application for outpatient tracking, implementing CRUD operations and search functionality via stored procedures.
  • Designed and deployed a responsive website using HTML5, CSS3, Bootstrap 4, and JavaScript, hosted on IIS 8.5 with SSL certification.
  • Engineered MS SQL database architecture, creating tables, stored procedures, and views for efficient daily operations of outpatient tracking system.