Software Engineer Sql Server

William Miller

Laguna Hills, CA

949-***-****, **********@*****.***

Full Stack Business Development

EXPERIENCE

Software Development (20 years)

Visual Studio.Net 20 years (2003-2022 C#,VB,ASP)

Source Safe, TFS, SVN, GIT 20 years

ASP, JavaScript 15 years

Web Services SOAP 20 years

T-SQL 20 Years

HTML 20 years

Visual Basic 6 years

AJAX, 10 years

CSS 13 years

JQuery, 10 years

Telerik, 4 years

SSRS, 4 years

Crystal Reports, 4 years

Dynamics 365, 2 years

Power BI, 2 years

ORM (LLBLGN, Entity Framework, CodeSmith), 5 years

Mobile Applications, 1 year

SCRUM, 2 year

.Net Core, 1 year

Swagger, 1 year

Database (20 Years)

SQL Server (2000,2005.2008,2012,2019,2022), 20 years

SQL Server 7/2000, 15 years

SQL Server 2005, 5 years

SQL Server 2008, 5 years

SQL Server 2012, 11 year

SQL Server 2019, 5 years

Network Environment (20 Years)

Windows NT 4.0 Server, 20 years

Windows Server 2003, 20 years

Windows Server 2008, 7 years

Windows Server 2012, 8 years

Windows Server 2016, 7 years

Windows Server 2022, 2 years

VMWare ESX Server, 6 years

EDUCATION

National University, Bachelor of Science, Computer Science

WORK HISTORY

4/2024 – 6/2024 San Manuel Casino – San Bernadino, CA

Software Engineer (Hybrid)

Began investigating using Duende Identity Server

Working team of 8

Used C# Visual Studio 2022

Used SQL Server 2019

Continued use of Git for Source Control

Also used SCRUM and Jira

6/2017 – 5/2023 Franchise Services, Inc – Mission Viejo, CA

Lead Programmer

Wrote with contractor REST API application to update Marketing Leads in C# MVC app with OAuth 2.0

Created A/R billing application that would create a PDF invoice, eliminating manual mailing of paper invoices.

Created all new apps in .Net 4.x, MVC with C#. Legacy apps in VB.Net ; All use JQuery front end.

Built dashboard with Power BI in Dynamics 365

Upgraded 5 Tradeshows websites to IIS 7 for SSL for TLS changes with PayPal to Process Credit Cards.

Assisted Accounting with re-building of Prem Dynamics data mart. This sped up their processing.

Created 50+ stored procedures to map entire legacy data from SQL2000 to Microsoft CRM, Dynamics 365 to replace legacy systems.

Upgrade to Visual Studio 2019 increased Security for legacy apps written in VS2003-2010 Webforms.

Installed/Administrated SVN for source control of legacy code. New code used GIT

Use of Oracle 8i and 9.3 for query of legacy accounting data using SQL+.

Maintained suite of internally written applications

Deploy applications and database objects to production for applications.

3/2015 – 6/2017 IQVIA – Irvine, CA

Senior Software Engineer

Maintained Web sites on IIS 7 using C# WinForms

Use of SQL 2012 Database Server

Maintained legacy apps written in VS2008-10 Webforms and LINQ-To-SQL

Built an application that generated Excel workbooks .xlsx without the need for Microsoft Office.

Used SSRS to rewrite and rebuild 100+ reports.

Worked with 2 other developers.

8/2014 – 11/2014 Mirion Technologies – Irvine, CA

Contractor

Maintained legacy apps written in VS2008-15 C# Winforms/LINQ-to-Sql

Used SQL 2008 Database Server

Maintained legacy apps written in VS2008-10 Webforms and LINQ-To-SQL

Converted application for Credit Card processing from PayPal to Chase Orbital

6/2013 – 8/2014 Advantage Sales and Marketing – Irvine, CA

Senior Software Engineer

Created new websites using MVC, C#, JQuery, Visual Studio 2012

Maintained existing 3 sites written in ASP.Net Webforms C# .Net 2.0 & 4.51.

Used Entity Framework 6 as ORM tool with SQL 2012 Database Server.

Developed using SCRUM.

Gathered requirements from stakeholders.

Continually developed, tested and confirmed progress with stakeholders.

Converted apps to be used on mobile devices(iPad).

Worked with 1 other developer and project manager.

Sites completed: Email Survey Generator, ASM Change Email Address

Use of Telerik controls in webpages

4/2012 – 6/2013 Collectors Universe, Inc. – Santa Ana, CA

Software Engineer

Created new public facing websites using MVC, C#, JQuery Visual Studio 2010.

Maintained existing 6 ASP.Net Webforms, C# .Net 2.0 & 3.5.

Used CodeSmith as the ORM tool to connect with SQL 2008 Database Server

Created views, tables and stored procedures, for complex data access.

Created Twitter application that caches RSS to the local webserver using C# for display.

Worked with a team of 3 Developers and a graphic artist.

7/2010 – 4/2012 Kofax, Inc – Irvine, CA

Developer Support

Work with Kofax KTM, assist developers with building forms and coding of product.

Kofax KTM uses a VBA like language that can access and use Windows COM components.

Product stores OCR image data in XML format and original image as a bi-tonal TIFF.

Assist users in configuring IIS6/7 to access ASPX pages of the KTM Thin Client product.

Assist customers in connecting ODBC data sources to SQL Server 2000-2008, Oracle, DB2

Set up ESX 4.2 Server for department, wrote tool in .Net for renamed of VM to avoid system conflicts.

Use of Salesforce to record customer support tickets.

Contact this candidate