Systems Engineer Asp.Net Core

Jaswant Singh

**** ******* ***** **., ********, CA 95843

Phone: 916-***-**** Email: *******@*****.***

Key Highlights:

Microsoft Certified Systems Engineer (MCSE) & Microsoft Certified Professional (MCP)

Strong experience in analysis, design and development of client/server web-based applications with extensive experience in the Software Development Life Cycle.

Experience in .NET 6, .NET 5, .NET Core, MVC, ASP.NET Core Identity, ASP.NET Web Forms, C#, Web API, WCF, Entity Framework, LINQ to SQL, JavaScript, AJAX, JSON, jQuery, Salesforce, XML, CSS, HTML, BizTalk B2B XML, Text files, and EDI messaging.

Extensive experience with both MS SQL Server and Oracle database technologies and implementing highly efficient Entity Framework Core, LINQ to SQL, SQL queries, stored procedures, functions, and views in TSQL and PL/SQL.

Experience in Data Adapter, Dataset, and Data reader as a part of ADO.NET.

Strong experience in developing Data Definition Language (DDL) and Data Management Language (DML) in different database handlers such as Microsoft SQL Server.

Experience in implementing Service Oriented Architecture (SOA), Web API, WCF, and rich experience around all layers that encompass SOA.

Extensive experience in building, testing, deploying, managing, and maintaining applications and services through Microsoft Azure Cloud Computing Services.

Experience in designing and developing (SOA) services using ASP.NET Core 3.1, .NET 5, Web APIs, C#, JSON, stored procedures, functions, and T-SQL.

Experience in designing and implementing centralized core functionality, including application security and user access control using Identity and custom permissions integrated with the Azure active directory.

Strong experience in setup Azure OpenID Connect and OAuth token-based authentication.

Experience in setting up the bridge in .NET and Java.

Experience in different document formats such as XML, X12, EDI Files, Flat Files.

A good team player with excellent technical, communication and interpersonal skills and capable of taking up responsibilities independently. Motivated and determined to deliver productive high quality, complete deliverables within deadlines with minimal supervision.

EDUCATION/TRAINING/CERTIFICATION:

Education:

MS in Information Technology

BS in Computer Science

Certifications:

Microsoft Certified Systems Engineer (MCSE)

Microsoft Certified Professional (MCP)

MCP+I

TECHNICAL ENVIRONMENT:

Microsoft Technologies: .NET 6, .NET 5, .NET Core, MVC, C#, ASP.NET Core Identity, ADO.NET, AJAX, LINQ, BizTalk, Azure Storage (Tables, Queues, Blobs), Azure Cache for Redis and Azure Functions

Programming Languages: C#, C, VB.NET, TSQL, PL/SQL, LINQ to SQL

SOA: Web API .NET Core, Web API, WCF

Scripting Language: Java Script, jQuery, JSON, Python

RDBMS: Oracle 9i/10g, SQL Server 2016/12/08, Enterprise Manager, PL/SQL Developer, SQL Server Management Studio, SSRS Reports

XML Related Technologies: XML, XSLT, LINQ to XML

Operating Systems: Win8.1, Win10, Win11, UNIX, Linux

Development Tools: Visual Studio 2022/19/17/15/12/10/08, HLK Studio, XML Spy, Quick Build

Source Control: GIT, Azure DevOps, Perforce P4, SVN

MAJOR ASSIGNMENTS:

Client: Tennessee Housing Development Agency, Nashville, TN Oct 2023-Mar 2024

Staff Role: Senior Application Developer

Responsibilities:

Upgraded existing Admin project to ASP.NET 6.

Updated Telerik Kendo UI and fixed related bugs and added new features.

Added nested grid for user access Roles and Permissions.

Generated ad-hoc SQL queries using joins, database connections, and transformation rules to fetch data from SQL Server database systems.

Developed Data Definition Language (DDL) and Data Management Language (DML) in different database handlers such as Microsoft SQL Server and Microsoft Access.

Updated Test project for automation testing.

Updated application security and user access control.

Perform daily basis scrum and sprints in agile software development cycles to track project progress.

Environment: T-SQL, HTML & CSS, .NET 6/Framework, LINQ to SQL, JavaScript, jQuery, Kendo

Client: Tennessee Housing Development Agency, Nashville, TN Feb 2022-Feb 2023

Staff Role: Senior Application Developer

Responsibilities:

Delivered quick problem assessment and escalation and total system availability for all critical production systems.

Responsible for working in all stages of the Software Development Life Cycle (SDLC).

Modified user manuals and other system documentation practices.

Designed and developed (SOA) services using ASP.NET 5 Web API, C#, JSON, and Entity Framework Core for lender loan application submissions.

Upgraded existing Finance projects to ASP.NET MVC Framework v4.8 and updated Telerik Kendo UI, and fixed related bugs.

Generated ad-hoc SQL queries using joins, database connections, and transformation rules to fetch data from SQL Server database systems.

Developed Data Definition Language (DDL) and Data Management Language (DML) in different database handlers such as Microsoft SQL Server and Microsoft Access.

Wrote SQL queries to validate data on staging tables and data warehouse tables to validate the data results.

Updated Test projects for testing.

Implemented application security and user access control using Identity and custom permissions.

Perform daily basis scrum and sprints in agile software development cycles to track project progress.

Environment: T-SQL, HTML & CSS, ASP.NET 5 MVC/Framework, LINQ to SQL, JavaScript, jQuery, SSRS

Client: Adora POS, Roseville, CA Oct 2020-Oct 2021

Staff Role: Senior Application Developer

Responsibilities:

Designed and developed large-scale enterprise applications using ASP.NET Core 3.1, .NET 5, MVC, C#, Entity Framework Core, and JavaScript.

Designed and developed (SOA) services using ASP.NET Core 3.1, .NET 5, Web APIs, C#, JSON, stored procedures, functions, and T-SQL.

Developed Object-Oriented Analysis and development (OOP/OOD) Programming.

Implemented error handling techniques in T-SQL with error functionalities in SQL Server.

Designed and implemented centralized core functionality, including application security and user access control using Identity and custom permissions integrated with the Azure active directory.

Setup Azure OpenID Connect token-based authentication for apps.

Setup Azure OAuth2.0 Web API token-based authentication with custom database.

Setup Azure Storage (Tables, Queues, Blobs), Azure Cache for Redis and Azure Functions.

Developed a reusable library to centralized control for MVC and Web API.

Designed SQL Server 2016 database and created new tables, stored procedures with JSON, functions, and T-SQL.

Migrated old technology projects to latest technologies.

Performed daily basis scrum and sprints in agile software development cycles to track project progress.

Environment: T-SQL, HTML & CSS, ASP.NET Core/Framework, LINQ to SQL, JavaScript, jQuery, SSRS

Client: CA Department of CSD, Sacramento, CA Sep 2017-Jul 2020

Staff Role: Senior Application Developer

Responsibilities:

Worked on troubleshooting failed mission-critical production systems under extreme pressure conditions and time constraints.

Worked on various phases of the Software Development Life Cycle (SDLC) of the application, such as requirement gathering, design, analysis, and code development.

Developed detailed project plans, including design, implementation, and system documentation practices.

Worked on Software Development Life Cycle (SDLC), Object Oriented Programming (OOP), and Object-Oriented development (OOD) principles using C#.NET Designed and developed the application using C#.

Designed and developed large-scale enterprise application to calculate an accurate cost of home repair for low-income families using ASP.NET Core 3.1, .NET 5, MVC, C#, Entity Framework Core, JavaScript and JQuery.

Designed and developed (SOA) services using ASP.NET Core 3.1, .NET 5, Web APIs, C#, JSON, stored procedures, functions, and T-SQL.

Designed SQL Server 2016 database and created new tables and stored procedures with JSON, functions, and T-SQL.

Provided all aspects of Technical Project Management, including detailed analysis, requirement definition, project planning, metrics tracking, budgeting, and timely deliverables.

Created a covering index to avoid bookmark lookups and improve SQL query performance.

Fine-tuned the complex SQL queries to improve the efficiency and performance.

Collaborated with accounts and Finance team to add features to reserve the funds for vendors and issue the funds to vendors after repair and final approval.

Added a feature to manage and record the day-to-day financial transactions.

Setup Azure OpenID Connect token-based authentication for MVC app.

Setup Azure OAuth Web API token-based authentication with a custom database.

Worked on unusual entries that accountants need to make and run reports to evaluate the currently available funds.

Designed and implemented application security and user access control using Identity and custom permissions.

Developed reusable libraries for MVC and Web API.

Perform daily basis scrum and sprints in agile software development cycles to track project progress.

Environment: T-SQL, HTML & CSS, ASP.NET Core/Framework, LINQ to SQL, JavaScript, jQuery, SSRS

Client: Broadridge, El Dorado Hills, CA Apr 2016-Apr 2017

Staff Role: Software Engineer

Responsibilities:

Designed and developed applications using WPF, Prism/Unity, C#, XAML, XML.

Designed and developed REST service using ASP.NET Core Web API, C#, JSON, SQL for real-time update.

Developed services for clients for Remedy and Sonar.

Developed a reusable library to get the position of the sub-image (cropped image) of an image comparing pixel by pixel.

Developed library to setup Bridge between .NET and Java using open source tool.

Performed daily basis scrum and sprints in agile software development cycles to track project progress.

Environment: T-SQL, HTML & CSS, ASP.NET Core/Framework, LINQ to XML, JavaScript, jQuery

Client: Intel Corporation, Folsom, CA Apr 2012-Jan 2016

Staff Role: Software Engineer

Responsibilities:

Provided support for critical production systems and worked in all phases of SDLC.

Developed applications using ASP.NET Framework 4.x, C#, ASP.NET Web Forms, Custom User Controls, HTML, JavaScript, jQuery, AJAX, WCF, and CSS.

Worked on Object Oriented Development, analysis, and modeling using UML/Rational Rose and Microsoft Visio.

Worked on development, unit testing, and build-related work for ASP.NET MVC, Entity Framework, C#.NET, and CSS applications.

Developed reusable libraries for common tasks.

Developed client-side grid and exported to Excel using C#, jQuery, JSON, and Web API.

Created and maintained SSRS Reports on the SQL Server data tool as directed.

Worked with a cross-functional team of resources to provide end-to-end Technical Project Management of all aspects of the solution design and development lifecycle.

Optimized indexes to improve SQL queries and analyzed database performance with SQL Profiler.

Understood complex orchestrations, maps, and custom pipeline components.

Developed Silverlight file uploader.

Worked closely with the project team in understanding the Business requirements and with the programmers in understanding the design of the queries.

Developed Akamai Token generation for Edge Server authentication.

Designed SQL Server 2012 database and created new tables and stored procedures with JSON, functions, and T-SQL.

Designed and implemented a web application to facilitate the Intel driver certification process.

Performed unit testing, system testing, and regression testing of the different applications.

Worked on requirements analysis, design, development, deployment, testing, and go-live stages of the project.

Performed daily basis scrum and sprints in agile software development cycles to track project progress.

Environment: T-SQL, HTML & CSS, ASP.NET Framework, LINQ to XML, JavaScript, jQuery, SSRS

Client: Teleplan, Roseville, CA Feb 2008-Apr 2012

Staff Role: Application Developer

Responsibilities:

Enforced change process affecting critical production systems.

Created websites that address the phases of the software development life cycle (SDLC).

Created and updated standard operating System Documentation Practices.

Worked on Object Oriented Design and Development (OOD) with .NET.

Developed application using ASP.NET Framework 4.x, C#, HTML, JavaScript, jQuery, User Controls, CSS.

Designed SQL Server database design and created new tables and stored procedures with JSON, functions, and T-SQL.

Optimized SSRS reports with modifications to embed queries and/or stored procedures.

Interacted with business analysts to understand the business requirements and Functional Requirement analysis.

Worked on entire Software Development Life Cycle (SDLC) of the project.

Used ASP.NET controls, HTML & CSS for improved look and feel of the front-end screens.

Worked on LINQ to XML, XDocument, Xpath, and XmlNode to access XML Data Document.

Worked on sending Emails to clients after any kind of transaction had been made.

Worked on Grid Views sorting and paging.

Fixed Bug during the build and deployment process and debugging.

Optimized code and improved efficiency in databases, including re-indexing, updating statistics, recompiling stored procedures, and performing other maintenance tasks.

Performed daily basis scrum and sprints in agile software development cycles to track project progress.

Environment: T-SQL, HTML & CSS, ASP.NET Framework, LINQ to XML, JavaScript, jQuery

Client: Intel Corporation, Folsom, CA Mar 2007-Feb 2008

Staff Role: Software Engineer

Responsibilities:

Developed Software tool collecting data relating to stress and characterization of microprocessor product lines.

Intermediate to advance troubleshooting of software issues.

Data management and Aries data upload notification.

Developed Information Software tool used to provide technicians and Inventory Control a quick and easy way to locate a lot of CPU’s saving time and money.

Environment: T-SQL, ASP.NET Framework

OTHER ASSIGNMENTS:

Client: Apple Computers, Elk Grove, CA Nov 2006-Feb 2007

Staff Role: Software Technician

Responsibilities:

Testing, troubleshooting, and monitoring hardware and software issues related to Macintosh platform for MacBook, iBook, MacPro G5, MiniMac.

Other duties included quality control of repaired Apple products.

Contact this candidate