Resume

Sign in

Developer Sql Server

Location:
Keller, TX
Posted:
June 25, 2018

Contact this candidate

Resume:

David Gilden MCSD

Microsoft Certified Professional ID: 3230509

LinkedIn: https://www.linkedin.com/in/davidgilden/

SUMMARY

Experienced software developer with over twelve years of web related industry experience. Extensive experience in C#, ASP.NET, VB.NET, T-SQL (Microsoft SQL Server), HTML, CSS, 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.

PROFESSIONAL TRAINING & 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

COMPUTER Languages

Microsoft C#, VB.NET, LINQ, Entity Framework 6.0, ADO, WCF, WPF, ASP .NET, ASP .NET MVC,

ASP Classic, T-SQL, PLSQL, JavaScript, jQuery, HTML5, CSS3, PHP, PERL, Python, XML, XLST,

DB2, Regular Expressions, Flash Action Script

Development Software

Visual Studio 2003 - 2017, Visual Studio Team System 2005 / 2008 / 2012

Telerik RadControls, Fiddler

Infragistics .NET Advantage,

JetBrains Dot Net Peak, ReSharper

Dev Express Code Rush, IBM iNavigator

Database

Microsoft SQL Server 2000 - 2014, SQL Reporting Services (SSRS), SQL Server Integration Services (SSIS), Red Gate tools (SQL Prompt), Oracle (Toad), MySQL,

Professional Work Experience

BNSF Railway May 2017 – October 2017

.NET Application Developer PTC Group

Developed Data Acquisition Web Application with Visual Studio 2017

oCreated a desktop like user experience leveraging Javascript and jQuery.

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.

Refactored 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 testabilty, 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

.NET Business 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 Web 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) May 2014 – February 2016

.NET Application Developer

Architected two distinct applications for an internal invoice report project.

oDeveloped Windows Service using Exchange web services to receive reports.

oUtilized 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 web application using ASP.NET 4.5 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.

Migrated 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)

Contract IT Consultant February 2006-May 2014

Major projects include:

Indico Corporation

.NET Web Application 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.

Created Unit and Coded UI Test plans utilizing Team Foundation Server 2012

Developed 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 Web Application 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 Developer

Was an integral part of a team of four 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 Web Application Developer

As part of the Cashlinx maintenance team:

oResearched business rules and integrated with the Q&A group to recreate and resolved software bugs as part of.

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 Web Application Developer

Managed several concurrent 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

.NET Web Application Developer

Built several User Controls in C#, ASP.NET

Created framework for intranet dashboard

oIncorporated LINQ & jQuery

oDynamically Loaded User Controls (.ascx)

PALS Inc

Web Page - Graphic Designer

Graphic Design and HTML Markup for new business concept.

Built several graphic comps in Photoshop

Created HTML templates

Tableless Web 2.0 design (using CSS & DIVs)

jQuery was used for roll-overs

Becker Time

Web Developer / Designer

Visual Studio 2008 C# .NET 3.5, ASP.NET

oImplemented jQuery and utilized CSS for UI’s look & feel

oMentored co-worker in web design & Photoshop

BNSF Railway

VB.Net Web Application Developer

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

ASP.Net Web Application Developer

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

ASP.Net Web Application Developer

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.

Additional Education

4-Year Professional Music Diploma Program, Berklee College of Music (Boston, MA)



Contact this candidate