Sql Server Senior Software

John Ho

Pearland, Texas *****

832-***-**** • ********@*****.*** • linkedin.com/in/ho-john-15560837

Senior Software Development Profile

Technical professional with 20+ year track record of innovation and success providing enterprise software-based solutions

Core Competencies:

Web/Web API Development

Azure/ AWS cloud Developer

Strategic Problem Resolution

Client Relationship Management

Software Solution Architect

DevOps CI/CD Pipeline

Requirements Definition

Problem Resolution / Troubleshooting

Professional Experience

Texas Children Hospital, Houston, TX

Senior Full Stack Developer, 7/2019-present

Design, develop and architecture web application, Rest API and database for Hospital. Software are focus on healthcare and insurance. Project technology rely on Angular, .NET & .NET Core and SQL server database

Key Achievements:

•Architecture and develop new software applications follow micro services software architecture with web client, middle end Rest API and SQL server database

•Primary architecture/develop multiple web applications for health plan department using Angular and Telerik Kendo UI

•Develop multiple Web API, Web service for vendors and internal applications to consume

•Interface with Epic vendor for push/pull patient medical records between Hospital and Epic System

•Implement Single Sign On (SSO) using AD and SAML 2.0 for all applications for department use

•Create/Analyze/optimize and improve store procedure SQL server for large database

•Streamlined and automated large datasets from vendor to SQL database using Azure Data factory

•DevOps CI/CD setup & configuration Pipeline for build and release to Dev/Staging/Production for all applications

•Participate in peer code/architecture review, workload sprint planning

•Research and prototype machine learning, Python, Power BI, Power Apps, Azure/AWS cloud

Project technologies: C#, .NET core, ASP.NET Core Web API, Entity Framework, LINQ, Angular 14+, Typescript, Python, Telerik Kendo UI, SQL Server, Azure SQL, Azure Data Factory, MySQL, Azure App Service

Management Control, Houston, Texas

Senior Software Developer, 5/2016 – 7/2019

Design and build efficient, reusable and reliable code with focus on web/mobile application development. Translate use cases into functional web applications.

Key Achievements:

Maintain and develop new features for legacy web applications

Develop progressive web apps using Angular 6, Typescript, HTML5, Bootstrap 4 with ASP.NET Web API, Cosmos database and Elastic Search

Created maintenance store procedure in SQL server for legacy applications

Design and Develop mobile/kiosk apps cross platform Android &iOS using Xamarin. The application is used to track time in/out based on geolocator, onboard and give access to contractors on the fields.

Implement Web API using ASP.NET core for mobile aps and web apps.

Design Single Sign On (SSO) using Azure AD, SAML 2.0, 0Auth 2.0 and Open ID Connect. Maintain multiple ASP.NET Core MVC web applications.

Research and prototype new technologies .NET Core, Angular, elastic search, azure service

Project technologies: C#, .NET core, Web API, Web Form, Xamarin, Entity Framework, LINQ, Angular 6+, React, Typescript, Kendo UI, SQL Server, Azure SQL, Azure App Service

Sogeti, Houston, Texas

Senior Consultant, 6/2011 – 3/2016

Served as senior consultant on various technology client projects. Researched and presented new technologies.

Key Projects:

Transocean: Created new features and deploy maintenance for ICS web application and ICMS desktop application. Maintained large scale database. Engineered new functions for Web services. Advised on production issues to assist with troubleshooting client issues.

Project technologies: ASP.NET, C#, VB.NET, desktop WinForms, Web Service, SQL Server 2008.

Maintain and update SQL Server database

KBRS: Supported complex multi-tiered ASP.NET application utilized by clients to manage contracts, payment processes and legal claim information. Revise code, workflow and procedures to improve application performance. Conducted requirements gathering for technical and business functions.

Project technologies: ASP.NET, C#, VB.NET, Web Services and SQL Server 2008

Lockheed Martin Information Technology, Houston, Texas

Software Engineer, 9/2000 – 2/2011

Served as Software Engineer on various technology NASA projects.

Key Projects:

Migrate Life Science Data Archive from ColdFusion to Silverlight and ASP .NET

Support/maintain Web applications for Tele-science for Wyle Contract

Integrated solution to establish reliable data share between NASA data centers.

Developed and maintain Life Science Data Warehouse for Bio Contract

Upgrade/Convert Flight Simulation and Math Model Software from Fortran to C/C++

Project technologies: .NET C#, Silverlight, C/C++, Java Applet, ColdFusion, Flash and SQL Server/Oracle

Technical Proficiencies

Language:

Cloud:

Database:

C#, Python, JavaScript, Angular, Typescript

Azure App Service, Azure API, Azure Data Factory, AWS

SQL Server, MySQL, Azure Cosmos database

Tools:

Telerik Kendo UI, TFS, Git, Azure DevOps

Education and Credentials

Bachelor of Science in Computer Science, Minor in Math

University of Houston, Houston, Texas

Contact this candidate