.Net Developer Sql Server
Resume:
DAVID GILDEN
Microsoft Certified Professional ID: 3230509
LinkedIn: https://www.linkedin.com/in/davidgilden/
PROFESSIONAL SUMMARY
·Full Stack .NET Developer with over 15 years’ of web-based and system-based
application development experience.
Extensive experience in C#, ASP.Net (Webforms & MVC), VB.NET, T-SQL (Microsoft SQL Server), HTML5, CSS3, User Interface/Visual Design.
·Adept at translating design requirements into functional products (development, testing and deployment).
·Proficient with web site and application design and development using a wide range of software on both Macintosh and Windows platforms.
·Proven ability to demonstrate advanced technical abilities,
strong work ethic and effective communication skills.
SKILLS SUMMARY
Programming Languages
Microsoft C#, VB.NET, LINQ, .Net Core, Entity Framework, ADO, WCF, WPF, ASP.Net, Web-API (REST) Python,
JavaScript, MVC, Razor Pages, ASP Classic, T-SQL, PLSQL, JavaScript, jQuery, HTML5, CSS3, Bootstrap, Angular, PHP, PERL, XML, XLST, Regular Expressions, Splunk, Azure DevOps, GIT
Development Software
Visual Studio 2003 - 2019, Visual Studio Team System 2005 / 2008 / 2012, VS Code, PowerShell, Fiddler, Telerik RadControls, Infragistics .Net Advantage, JetBrains Dot Net Peak, ReSharper Dev Express Code Rush, IBM iNavigator, Postman, Splunk
Database
Microsoft SQL Server 2000 - 2014, SQL Reporting Services (SSRS), SQL Server Integration Services (SSIS), Red Gate tools (SQL Prompt), Oracle (Toad), MySQL, DB2
PROFESSIONAL EXPERIENCE
HCL / Boeing 2/26/2025 – 5/30/2025
Full Stack .NET Developer
·Documenting and analysis of legacy web application.
including Oracle database tables, queries, stored procedures and scheduled jobs.
·Add enhancements as requested by product owners.
·Updated HTML/CSS and ASP.Net code.
·Created javascript text filter to prevent illegal characters posting back to the web server.
BNSF Railway 1/2024 – 3/2024
Full Stack .NET Developer
·Contributed to existing C# and ASP.Net project for safety department.
·Project was a legacy ASP.Net Webform with Telerik controls.
·Updated .Net code, CSS and HTML
·Refactored jQuery and JavaScript code
·Researched existing source code and assorted backups folders to determine
what was deployed to the Production Web Server.
·Created GIT Repo for codebase.
·Resolved bugs and updated existing code to meet business requirements.
·Provided cross-training so that code could be maintained.
·Contract ended to budgetary constraints.
Geographic Solutions 4/2023 – 7/2023
Full Stack .Net/SQL Developer
·Modified exiting SSRS reports,
oRefactored dynamic SQL queries in legacy stored procedures.
oUpdated existing stored procedures to meet new business requirements.
oWrote new C# .Net code to include a disclaimer message in PDF and Excel data export.
oRefactored C# code used by internal application notification system.
oParticipated in weekly code review and mentoring sessions.
Bank Of America 9/2022 – 1/2023
Full Stack .Net Developer
·Analyze existing ASP classic code and database queries.
oWork with end users to determine business requirements.
oCreated new Razor Pages using ASP.Net MVC, Web API (REST) and Bootstrap.
oMigrate inline queries to Web API utilizing C# and Toad / DB2.
oParticipated in daily Scrum meetings and code reviews.
Brinks Inc. 3/2022 – 9/2022
Full Stack.Net Developer
·Member of iTrack support team.
oArchitected/Coded new audit modules as part of iTrack Windows Form (WinForm)
application using C# and T-SQL.
oCreated SQL Server stored procedures that were used by audit project.
oAdding logging for audit modules in iTrack WinForm application.
oDesigned SSIS ETL Data Sync Process
oParticipated in application deployment.
JP Morgan Chase 2/2021 – 3/2022
Full Stack .Net Developer
·Member of ETF support team.
oAdded new functionally to internal ETF applications.
oUtilized LINQ and Entity Framework.
oAdding logging for legacy application.
oUsed .Net Core with Visual Code to update internal applications.
oParticipated in application testing.
National Bankruptcy Services 2/2020 – 3/2020
Full Stack .Net Developer
·Member of an agile project team that supported internal business units
oAnalyzed CSV and other data formats from external financial partners.
oWrote code to parse these flat files in a variety text formats.
oMentored development team on using Regular Expressions.
oContract suspended prematurely due to Covid-19
NCR 4/2019 – 7/2019
Full Stack .Net / Splunk Developer
·Member of Connected Payment Team
oConfigured Aloha POS to run on locally on Windows 10.
oResearched log files for Aloha POS system.
oWorked with Splunk to analyze log files.
oFixed bug by adding guard clauses using C# in Aloha POS Open EPS module.
Talus Pay 10/2018 – 1/2019
Full Stack .Net/SQL Developer
·Automated Business Processes
oResearched a cost-effective scheduled FTP solution. Installed, configured and documented business requirement that VanDyke Secure FX FTP software meet.
oCreated new DTS / SSIS packages to send CSV files via email to senior staff and managers.
oAutomated ‘month end’ financial process using SQL Server Agent Jobs and stored procedures to run a DTS / SSIS package on the first five business days of each month.
oCreated SSIS package and stored procedures to pull data for daily import integration
with HubSpot.
oAdded CVS Export functionally to an existing classic ASP web page.
oMigrated from MS Team Foundation Server to Azure DevOps for source control.
Cornerstone Health Group 5/2018 – 6/2018
Full Stack .Net Developer
·Analyzed pharmacy web application, looked for ways to speed up application response time.
oResolved latency issues by creating new stored procedures in DB2 Mainframe based
off the original dynamic queries in SQL Server.
oUpdated the HTML and CSS as needed.
oRefactored C# code time and fix bugs and overall poor architecture
·Capital Expense Request
oUpdated the code repository, files were missing from the last developer’s code check in.
oActively fixing poorly implemented ASP MVC project.
oIdentified and resolved issues with invalid data in SQL Server.
BNSF Railway 5/2017 – 10/ 2017
Full Stack .Net Developer
·Developed Data Acquisition Web Application with Visual Studio 2017
oCreated a desktop like user experience leveraging JavaScript and jQuery
with Telerik RadControls.
oDesigned Information architecture using advanced CSS and HTML
oMulti-Tier design (in C#) utilized WCF Web Service layer to isolate the front end
presentation layer from the database.
oWCF Ajax with jQuery allowed front end to connect the WCF Web Service layer to
return data from SQL server and Active Directory.
oCreated database schema and objects in SQL Server 2014.
oRefactored Data Analysis WinForm Application with Visual Studio 2017
oTook a 7-thousand-line block of code in a Button Click Event
and broke it out in multiple methods and classes.
Facilitating code testability, maintainability, intelligibility and reuse.
oWindows Service was able to use the classes as a result of the refactoring.
oWrote Code to replace SQL server ‘Bulk Insert’ method with application code and TVP
oCreated stand along WinForm to test Regular Expressions in C#.
Daryl Flood Inc. May 2016 – March 2017
Full Stack .Net Developer
·Rewrote Calendar Web Application using Visual Studio 2015
oWrote JavaScript code and incorporated jQuery UI widgets
oFix bugs and added new features.
oRefactored SQL Server stored procedures and UDFs.
·Rewrote Warehouse Inventory Webform Application using Visual Studio 2015
oConverted VB.Net code 2.0 to C# 4.5.
oReplaced ADO with LINQ & Entity Framework 6.0 (for all CRUD data operations)
·Wrote ASP.Net solution that creates dynamic PDFs with embedded barcodes.
oBarcodes are truly dynamic and database data driven.
·Designed Financial Aging Report using Server Reporting Services (SSRS)
oCreated SQL Server stored procedures to aggregate data.
oBuilt report to create multiple workbooks when exported to Excel.
·Migrated Crystal Reports to SQL Server Reporting Services (SSRS)
Y Soft (North America) 5/2014 – 2/2016
Full Stack .Net Developer
·Architected two distinct applications for an internal invoice report project.
oDeveloped Windows Service using Exchange web services to receive reports.
Utilized RSA cryptography to verify report’s digital signature.
oImplemented database schema in SQL Server 2012.
oCreated stored procedures, user defined functions and other database objects.
oBuilt ASP.Net 4.5 webform application to track invoices and provide user administration.
oDesigned a ‘Single Page Application’ user experience using jQuery and JavaScript.
oConstructed a XSLT transform for report export from web page.
oMigrated legacy C# WinForm applications from .Net 2.0 to 4.5 using Visual Studio 2012
oFixed bugs and revised SQL queries and database access code to use ‘best practices’.
oResearched Installer options (InstallShield, WIX)
Independent Senior Software Developer 2/2006 – 5/2014
Indico Corporation
.Net Software Developer
·Upgraded existing record management applications using Visual Studio 2012.
oWrote new C# code and implemented new functionally for Document Upload module.
oAdded new JavaScript code and refectories existing code to use ‘best practices’.
oRevised HTML and CSS.
oCreated Unit and Coded UI Test plans utilizing Team Foundation Server 2012
oDeveloped Windows Service and custom DLL to create data driven XML files.
oWrote WPF application to control this service and display Event Log messages.
Crosstex Energy
.Net Software Developer
·Gathered business requirements for a truck driver scheduling and management web application:
oCreated process diagrams in Visio.
oCreated documentation for application workflow.
oIdentify points of failure in existing code base where new code would be added.
Fidelity Investments
Team Lead / .Net Software Developer
·Integral part of a team of four webforms developers.
oMigrated two existing ASP.Net ‘web forms’ written in .Net 2.0 to .Net 4.0
oResolve complier warnings and errors. Refactored code to use new namespaces as required.
oDocumented application deployment issues for the client's server admin group.
Cash America
.Net Software Developer
·Served as a member of the Cashlinx maintenance team:
oResearched business rules and integrated with the Q&A group to recreate and resolved software bugs as part of webform based applications.
oAssisted colleagues in working through complex use cases.
oUpdated Oracle database packages using Toad.
oWrote C# code for bug fixes and new requirements with Visual Studio 2010.
oDocumented work and testing done for migration to the Q&A group.
oLearned and used GitHub for version control.
McKesson
.Net Software Developer
·Managed several concurrent Webforms projects.
·Rewrote ASP.Net web applications incorporating ‘best practices’
·Upgraded web projects to Visual Studio 2010 VB.Net 3.5 and Telerik RAD Controls
·Replaced basic ‘drag & drop’ data source objects with programmatic versions.
·Added UI & back-end data validation with error handling.
·Created and corrected T-SQL queries and database tables in SQL 2005
·Updated client-side JavaScript with jQuery.
Range online Media
·Built several User Controls in C#, ASP.NET
·Created framework for intraNet dashboard
oIncorporated LINQ & jQuery
oDynamically Loaded User Controls (.ascx)
BNSF Railway 1/2007 – 12/2007
·Responsibilities ranged from code maintenance to new development for internal business units.
·Visual Studio Team System 2005 / 2008 VB.Net 2.0, ASP.NET
oBuilt apps using Microsoft XSD and ADO Datasets
oCoded requested enhancements and resolved bugs quickly in VB code
and at the database level (T-SQL)
·Infragistics .Net Advantage web controls 2008 V2
oWell versed with the use of the Webgrid control and AJAX Warp panel
oResearched Infragistics forums and worked with their support staff to maximize
projects under development.
oUpgraded older projects from 7.1 to 8.2
oResolved and documented bugs with Infragistics
·SQL Server 2005 (Database design / created queries and created stored procedures)
·SSIS 2005/2008 (DTS) SQL Server Integration Services
oCreated ETL packages to import and data from Excel into SQL Server
oLearned SSIS tool set on the job as needed and was able to provide timely turnaround when business end user emailed Excel data that needed to be imported
·Red Gate SQL Tool Set
oUsed for data migration and database schema synchronization.
·SQL 2005 Reporting Services
oCreated Reports using embedded sub-reports
oSupported and built (new) ASPX pages that used the .Net Report Viewer control utilizing a XSD as the data layer tied to SQL Server backend (wrote both ad-hoc queries and stored procedures)
Galactic LTD
·Web development and design for Galactic Meetings & Incentives.
oBuilt web sites using ASP.Net for both external clients and internal use.
·Web Dashboard for business and sales tracking
oCode written in C# .Net 2.0 with SQL Server 2005 database.
oProject used Telerik RadControls for ASP.Net 2.0
·Used Classic ASP for internal data conversion between SQL Server and office subsystems
·Created Flash Animation for client project.
·Created reports using SQL 2005 Reporting Services
PNM Resources
·Code maintenance, documentation and new web development for Texas New Mexico Power and
First Choice Power.
·Wrote custom code in C#, VB.Net 1.1 and ASP/.Net using Visual Studio 2003.
·ASP Classic bug fixes and changes as requested by business units.
·Wrote Web Services C# used by the TNMP marketing group.
·Wrote new modules in ASP VB.NET. As needed, existing modules were rewritten using correct syntax and best practices.
·SQL database scripts created new database objects, data changes and other related data manipulation work. Work was done using Toad for Oracle and or SQL Plus.
·Incorporated CSS and JavaScript to provide new functionally and to resolve outstanding issues.
CERTIFICATIONS
Microsoft Certified Solution Developer (MCSD)
·Analyzing Requirements and Defining Microsoft .Net Solution Architectures (70-300), 2005
·C# .Net (7 0-315 ASP.Net Web Applications), 2005
·VB.Net (70-310 XML / Web Services), 2005
·VB.Net (70-306 Windows apps), 2004
·SQL Server 2000 (70-229 Implementing SQL Server 2000), 2004
Professional Training: MUMPS Programming Language
ESI Technology Corporation, 2003
Certification in Web Programming
University of Illinois, 2002
Contact this candidate