C# Sql Server .NET
Resume:
Alan Hoffman
ad7nb7@r.postjobfree.com
Glenview, IL 60025
Summary
Professional Software Engineer, Technical Architect and Full Stack Developer. Particular expertise with database design and application development. Experiences have forged a well-rounded expertise in all stages of the software lifecycle.
Experience includes:
Performed data analysis and design for commercially available software
SQL Server database performance tuning including creating databases, stored procedures and indices
Migration from older to newer platforms
Project coordination
Technical documentation
Code Maintenance
Converting applications from VB6 to C#
Creating new applications in C# from .NET 4.5 to .NET 7
Creating new web applications in MVC and maintaining existing ones in ASP.NET
Creating APIs and using commercial ones (LexisNexis for example)
Broad industry experience includes Insurance, Financial, Trading, Automotive, Manufacturing, Health Care and Publishing. Diverse background in all of the functional areas of Information Technology including architecture, vendor coordination, project management, development, quality assurance, and extensive data conversion.
Education
Bachelor of Science, Computer Science, Rensselaer Polytechnic Institute, Troy, NY
Technical Skills
Database SQL Server 7.0 – 2019, MS-Access 2000 – 2014, SSIS, SSRS, Oracle 10g - 12c, PL-SQL,
Languages C# (VS 2022), ASP.NET, VB.NET 2002 – 2013, VB6, VBScript, VBA, C++, ADO.NET, XML, JavaScript, JQuery
Other Visual Studio, TFS, Visual Studio Tools for Office, WinForms, SSIS, SSRS, BitBucket, Git, Azure, Toad, WCF, WPF, VTSO, Telerik/Kendo, Dapper, Newtonsoft, Renci, NuGet, Dependency Injection, IIS, Docker, Agile, Scrum, Kanban, SharePoint, Design Patterns
Project Experience
Senior Software, Web and Database Developer
Guarantee Trust Life Insurance Company, Glenview, IL
December 2021 to September 2023
Responsibilities:
Maintaining existing legacy applications in .NET 4.8 and adding new functionality. Creating new MVC applications with C#, SQL Server, Azure DevOps.
Produced detailed functional design documents for customer requirements with technical specification for systems integration requirements.
Set up web sites, both ASP.NET and Web API.
Convert VB6 applications to .NET 5 and 6.
Converted a QBASIC application to a Web application in .NET 7.
Unit testing and integration testing for all new applications.
Environment: ASP.NET, Visual Studio 2022, C#, SQL Server, MVC, WinForms, Razor View Engine, JSON, JavaScript, JQuery, CSS, LINQ, AJAX, HTML, XML, .NET 4.8, 5.0 – 7.0, Entity Framework (.NET Core), TFS, Azure DevOps.
Software Developer/Consultant
American Academy of Orthopaedic Surgeons, Rosemont, IL
March 2021 to June 2021
Responsibilities:
Maintaining existing MVC application and console applications by adding new functionality and fixing bugs with C#, SQL Server 2019, Azure functions, data factories and Cosmos database.
Environment: ASP.NET, Visual Studio 2019, C#, SQL Server, MVC, Razor View Engine, JSON, JavaScript, JQuery, CSS, LINQ, AJAX, HTML, XML, .NET 4.6.2, .NET Core 3.0, Entity Framework (.NET Core), TFS, VTSO, Git with Azure Dev Ops, Azure functions, data factories and Cosmos database, Agile, Scrum
Senior Software and Web Developer
Endurance Warranty, Northbrook, IL
September 2017 to October 2020
Responsibilities:
Creating new MVC, Web API, Microservice and Console Applications using C#, ASP.NET and SQL Server.
Set up web sites, both ASP.NET and Web API.
Created architecture needs to enhance current business processes.
Unit testing and integration testing for all new applications.
Lead for enterprise-wide legacy applications.
Created new functionality, customized, and maintained enterprise-wide legacy applications using C#.
Used .Net Core to migrate legacy applications to Azure service apps, web jobs and functions.
Set up new SQL Server databases, creating tables, views and stored procedures.
Created reports for sales, accounting and marketing.
Supported applications throughout the SDLC life cycle.
Created SSIS Packages for loading data from Excel spreadsheets into an SQL Server database
Environment: Visual Studio 2019, Visual Studio Tools for Office, C#, VB.NET, SQL Server 2014, WinForms, SSIS, SSRS, MVC, Razor View Engine, JSON, JavaScript, JQuery, IIS, ASP.NET, Web API, VBScript, CSS, WCF, WPF, LINQ, AJAX, HTML, XML, Dapper, Newtonsoft, Ninject, Renci, .NET 4.6.2, .NET Core 2.2, Entity Framework (.NET Core), TFS, BitBucket, Git, Docker, Agile, Scrum
Software and Database Developer/Consultant
Familia Dental, Schaumburg, IL
March 2016 to August 2017
Responsibilities:
Adding additional functionality to a enterprise-wide custom-built dental and accounting ASP.NET and MVC based application with C# and SQL Server 2014 as back-end. Also responsible for database design and creating or modifying tables and stored procedures.
Created ability to parse Explanation of Benefits statements from PDF and load them into a database table using a 3rd party DLL.
Created ability to handle help desk tickets.
Automatically generated JIRA (Atlassian) tickets that are uploaded via their API.
Created form to enter new offices.
Created form to enter results of office inspections.
Created form to enter patient complaints.
Created ability to enroll new doctors.
Set up instances of SQL Server 2012 and 2014. Configured SQL Server mail queues and profiles. Used SQL Server Profiler to improve queries using LINQ and Entity Framework.
Unit testing and integration testing.
Environment: ASP.NET, C#, SQL Server 2014, Visual Studio 2017, Entity Framework, MVC, Razor View Engine, JSON, WPF, JavaScript, JQuery, CSS, LINQ, AJAX, HTML, XML.
Software Developer/Consultant
Mercer, Vernon Hills, IL
September 2015 - December 2015
Responsibilities:
Worked with their pension and actuarial science department. Migrated large application from .NET 1.1, VS 2003, Oracle 10g and SQL Server 2000 to .NET 4.5, VS 2013, Oracle 12c and SQL Server 2012. Replaced Microsoft Oracle data adapter with ODP.NET. Rewrote VB.NET, C++ and Fortran 90 code to work in new environment. Set up the web server, report server (SSRS) and the client application as well as old VB6 DLLs.
Environment: VS 2013 and 2010, Intel XE 2016 compiler, VB.NET, C++, VB6. Fortran, .NET 4.5 and 4.0, JavaScript, ASP.NET, Visual Studio 2015, Oracle 10g – 12c, SQL Server 2008, PL-SQL, ETL (DTS).
Software Developer
Cree, Inc., Racine, WI
December 2011 – September 2015
Responsibilities:
Maintaining and adding additional functionality to a custom-built system in a live manufacturing environment including but not limited to order entry, work orders, finance (including bank card processing), shipping and invoicing (mostly VB.NET, SQL Server 2012)
Code integration to ensure that developed individual modules worked when integrated
Creating reports for department managers using SSRS and other methods
Enhancing existing databases with designing new tables, creating stored procedures, views, functions and triggers
Software to create xml files to interact with our external web site
Created and modified applications using VB.NET and ASP.NET to support our internal shipping web sites
Created and maintained technical documentation
Migrated legacy systems to VB.NET and data to SQL Server using SSIS and ETL processes.
Created applications using C# and ASP.NET for forecasting part requirements including purchase orders
Migrated custom-built system based on SQL Server to Oracle
Environment: VB.NET 2010, C#, VB6, VBScript, ASP.NET, ADO.NET, SQL Server 2012, Visual Studio 2015, Visual Studio Tools for Office, PL-SQL, Oracle, SSIS, SSRS, ETL, WCF
Programmer Analyst/Consultant
Illinois Rural Health Network, Naperville, IL
June 2011 – October 2011
Environment: C#, SQL Server 2005 and 2008, MS Excel, ETL
Programmer Analyst/Consultant
Johnson Controls, Hammond, IN
January 2011 – April 2011
Environment: VBA, SQL, MS Access, MS Excel, Crystal Reports
Programmer Analyst/Consultant
New Edge Group
February 2010 – July 2010
Environment: VB.NET, MS Access, MS Excel, ETL, Crystal Reports
Programmer Analyst/Consultant
Rock Solid Consulting, Oakbrook Terrace, IL
August 2006 – November 2008
Environment: VB6, C#, MFC, SQL Server, MS Word, MS Excel, JCL, DB2, ETL
Contact this candidate