Software Engineer Sql Server

Phone #:909-***-****

E-mail: ***.*********@*****.***

LinkedIn URL: https://www.linkedin.com/in/david-cortez-3104486/

Skype ID: d.cortez61

Southern California, 91701

David R. Cortez

Programming Languages/ Databases/Virtualization

Source Control

Web Programming

Work Experience

Python 3.9, Pandas 2.2, C#.Net 8.0, .Net Core 8, MS Task Parallel Library,

SQL Server 2022, and SQL Server 2016, Oracle, PostGres 10, Entity Framework 6, Entity Framework Core 6-9

MS T-SQL, Oracle SQL, & Azure SQL

Microsoft Azure Cloud Development (ARM)

GitHub, TFS, & Atlassian Source Tree

ASP.Net MVC Core 6 - 9, HTML 5, JavaScript (Client-side)

11/2022 – Present Discover Financial Services (Remote)

Software Engineer:

Asp.net Core/C# application development in Student Loans

ACH payments code development

Angular 9 front-end development for Student Loans web page

Regression Testing in Python and Pandas

Developed SSMS /SQL Server Queries

Applications deployed to AWS

SQL Developer / Oracle Queries

Snowflake Cloud-based Queries (Historic Data)

Develop Finacle Core facing banking services (Payments)

GitHub code repositories

CI/CD OCP, Jenkins

Agile/DevOps JIRA Project Management

01/2022 – 9/2022 LanceSoft LLC (Remote)

Software Engineer, Client: Lockheed Martin, Denver Colorado.

Develop ETLs in C#

Developed WPF applications to demo TPL

Deploy and Config CI/CD (YAML) pipelines in OpenShift (RHET OCP)

Kubernetes Container Orchestration & AWS S3 Buckets

GitLab software repositories

Develop Asynchronous & Parallelized C#.Net code in Microsoft’s Task Parallel Library (TPL)

Agile/DevOps JIRA Project Management

Asp.Net MVC Templates

09/2021 – 12/2021 R Systems LLC (Remote)

Software Architect/ Team Lead (5 Engineers), Client: Oasis Financial, Las Vegas Nev.

Azure Data Analytics Development and Config

Developed WPF Application

Develop Azure Service Fabric APIs for the back-end

Azure API Gateway (APIM)

Develop back-end, Azure-based, services to work with SQL Server on-prem Databases

Developed ETL processes

Azure Redis Cache configuration

Project Management: Agile/DevOps -JIRA/Confluence

Develop Architectural Documentation for legacy systems

05/2021 – 9/2021: Logix Guru LLC (Remote)

Software Architect: Client: University of Pennsylvania Medical Center

Developed Web Extensions for Microsoft DevOps in TypeScript (AzDo)

Web Extensions REST Web API for DevOps

Configurations written in Groovy for ConnectALL Value Stream Management tool

Azure SQL Server 2016 (Cloud-based)

Power App Connectors in C#

Power BI

12/2020- 04/2021 BrainTree Los Angeles Ca.

Software Engineer/Team Lead (6 Engineers)

Software Architect SPA/RESTful WebAPI applications for Pacific Life Insurance

Authored Technical Design Document for Pacific Life Insurance

All services (RESTful Web API) architected in C# Core, deployed in Red Hat Enterprise Linux

Project Management through Atlassian JIRA, BitBucket repository

Web APIs hosted in Asp.net Core 5 on Red Hat Enterprise Linux servers

Web API consume Stored Procedures written for Postgre databases, All services interface with Stored Procedures written in PL/pgSQL for Postgre databases

Architected Azure DevOps CI/CD Pipelines into Dev, QA, and Production environments utilizing Self-hosted Agents

Data providers are Devart dotConnect and DevExpress that connect to Postgre data source

5/2017-10/2020 Infosys Ltd. Hayward, Ca.

Software Engineer: Support and develop Enterprise Solution Architecture for Southern California Edison (So Cal Edison) Power Utility Client

Enterprise Solution requires database support and development in Oracle 12c and SQL Server 2014 & 2016, on premises and Azure Cloud, and PostGres 10

Utilized Microsoft Server 2008, 2012, and 2014, on-premises and Azure Cloud

Software Version Control in TFS Git, Source Tree

Azure Data Analytics development and config

Experience with network appliances: DataPower, Redwood, CIFS Shares (NAS), and Managed File Transfer

Experience upgrading with Netmotion VPN software

C# 7, develop business logic for Grid Mod application

Entity Framework 5, Entity Framework Core 2 for data binding in applications

Develop/Configure CosmoDB for NoSQL in Azure

Caldera Hadoop Enterprise associated with Edge devices

Developed and supported public facing consumer applications in the .Net domain describing power usage in Southern California via ArcGIS heat maps

Team Collaboration was through the Off-Shore Model with India

5/2016- 1/2017 Alemba Group LLC Costa Mesa, Ca.

Software Engineer/ Team Lead (3 Engineers)

Software Engineer

Support and Develop bugfixes for VFire IT CRM/ERP/CMS Software

Develop bugfixes in C#.net, VB.net, HTML, JavaScript, & T-SQL

Support and Develop software fixes for VFire back-end SQL Server 2012 & 2014

Software Version Control in Git, Source Tree & TFS

Test applications in virtualized environment (VMWare vSphere 5.5 & Workstation Pro 10 & 12.5

Project Management through Atlassian JIRA/Bitbucket repositories

Software Connectors/Services written as WCF 4 and Web API

Architected REST APIs for back-end C# Web APIs

Architected AngularJS Front-ends

Team Collaboration was through the Off-Shore Model with Great Britain and Sydney Australia

3/2003 – 3/2016 Westwood College Upland, Ca.

Instructor/Supervisor, Game Software & Electronics Technology

Develop software laboratory exercises for 2D & 3D graphic engines & Artificial Intelligence

Teach all levels of C/C++/C# programming (Beginning, Intermediate, and Advanced)

Curriculum Development

Course Scheduling

Game Software Development (Windows API, DirectX 10.0, OpenGL)

Developed National Instruments Virtual Instrumentation Lab Simulations

Supervise Instructors

Education

2001 University of California Los Angeles Extension

Professional Designation in Application Programming

Object-Oriented Programming & Design

Client/Server Computing

C++ & MFC(Visual C++ 6.0)

Java & XML

UML(Rational Rose)

Relational Database Programming/Management

1985 California State University Los Angeles

B.A. Industrial Technology

Specialized in Industrial Electronics

Industrial Motor Controls

Electronic Communications

1990 Chaffey Community College Alta Loma Ca.

A.S. Mathematics

Completed two(2) years of Calculus

Completed one(1) year of Physics and Chemistry

Supplemental Course work

University of California Riverside Extension

Asp.Net Web Development

Linux OS: System Administration/Shell Programming

PERL Programming Language

Memberships & Organizations

Inland Empire Dot Net Users Group: www.iedotnetug.org

Contact this candidate