C# .NET, MVC, Entity framework, SQL, Razor, Javascript, jQuery, Devexpress, Azure

• Developed and maintained business intelligence reports for the hospitality industry using technologies: .NET C#, T-SQL (stored procedures and functions), JavaScript and Vue.js.• Converted reports from the legacy XML code to C#, JavaScript and Vue.js.• Supported legacy XML and Classic ASP code.• Modified microservices with .NET C# and .NET Core.• Utilized .NET C# to create unit tests using xUnit.net that had 80% coverage.• Maintained source code with Sourcetree and DevOps.• Wrote and maintained SQL queries on an Azure database with both SQL Server and Azure Data Studio.• Created RESTful APIs.• Deployed code to the QA and staging environments using Jenkins and Azure pipelines.• Wrote documentation, such as how to configure the authentication microservices and deploy the builds to QA and staging sites, for the development team.• Developed and maintained the SQL scripts that created a database and loaded data for customer Excel cubes.

Full Stack ASP.NET software developero Utilized C#, LINQ and SQL for report modification o Altered schedule and aging reports to create verifiable totals and generate comprehensive report detailso Added validation to DevExpress and Windows controls using JavaScript, Ajax and server controlso Employed Code First Entity Framework in database modification

o Mapped patient data from JSON and SQL to ASP.NET C# objects for serializationo Wrote complex systems of stored procedures that created electronic health records (“EHR”). Technologies used include: temp tables, table variables, CTEs, complex joins, subqueries and function callso Created entity objects and providerso Wrote stored procedures and C# methods that enabled data to be placed in entity objects o Utilized ASP.NET C# to create service layer methods that returned specific pieces of patient data using LINQo Methods utilized complex business logic in order to ensure compliance with government regulations as laid out in the Affordable Care Acto Mapped HL7 data for ASP.NET C# and SQL projects. Projects included: patient problem data to ICD9 and ICD10 codes, medications to RxNorm codes, and lab results to LOINC codes. o Optimized stored procedures o Wrote unit tests in ASP.NET C#o Trained offshore developers in ASP.NET C#

• Created SQL/SSRS reports. Reports centered on Business Intelligence aspects of company’s healthcare business. Reports covered such items as the cost effectiveness of client’s insurance program, as well as the spending and savings with different combinations of payment methods and drug types.• Developed back end stored procedures for the SSRS reports and wrote ad hoc SQL reports.• Performed analysis on existing SSRS reports in order to sync totals across different reporting types. Maintained existing SQL/SSRS reports.• Interviewed end users in order to gather report requirements.

• Created new modules for Police Central product using ASP, VBScript, JavaScript, Visual Basic and HTML. This product is web based and client server. An example of a module I wrote is inmate watch. This module keeps track of when inmates on suicide watch get monitored.• Lead Developer of Reports. Wrote, maintained, and supported reports written in both Crystal Reports and HTML. Examples of reports include permits, inmate counts, and information sheets on individual inmates.• Created website in ASP.NET that runs SSRS reports.• Created an interface between the ASP.NET reports website and the main Police Central product.• Helped develop interface service using ASP.NET. This service monitors when inmates enter the jail or get moved in jail, creates an interface file, and then FTPs the interface file to the client company.• Maintained Police Central product.• Wrote scripts that create interface files. An example of an interface face would be an XML file of all the new inmates and their bio. • Worked with customers in order to determine report layout and functionality. • Wrote T-SQL configuration scripts for overall product and specific customers. Examples of configurations include setting up charges, inmate locations, questionnaires, and validation for individual agencies.• Wrote scripts for both SQL Server 2008 R2 and SQL Server 2005• Wrote data conversion scripts. These scripts upgraded customers from our older versions of Police Central to a more current version.• Wrote stored procedures and functions to simplify in-house scripting process.• Upgraded customers systems on both their test site and live site.• Did production support for main Police Central product.• Backed up SQL databases and restored the database on another machine.