C# Sql Server

Guangdi Li (Jason Li)

**** ***** ****** *** **

Marietta GA 30067

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

Phone: 678-***-****

LinkIn

SUMMARY

Experienced Full-Stack Developer with 10+ years of expertise in multi-tier enterprise applications, Microsoft web technologies, and client/server technologies. Proficient in ASP.NET, C#.NET, and front-end technologies. Strong knowledge of OOP concepts, database design, and security. Committed team player with a proven track record.

NET Experienced in developing Web Forms and Web Services in ASP.NET, C#.NET

Very strong understanding of Object-Oriented Programming features of C# such as Polymorphism, Inheritance, Interfaces, Events, Generics, Collections, etc.

Having expertise in Front-end Programming using Web Services, MVC, SOAP, XML, XSL, XSLT, XPath, DTD, XML Schema, CSS, DOM, HTML, AJAX, JSON, JQuery, Angular 2/12, Bootstrap and JavaScript

Created deployment packages for applications using Visual Studio.Net. Expertise in the IIS administration

Expertise in Entity Framework, LINQ, Data Adapter, Dataset, and Data Reader as a part of ADO.NET to access and update the database as a full-stack developer.

Using Database Design, Development, and Query Optimization using MS SQL Server 2008/12/14/16, Oracle

Hands-on experience with Network Protocols using TCP/IP, HTTP, SOAP, Restful Services, XML, and JSON data formats

Good Exposure to .NET securities like Authentication and Authorization

Good working knowledge with design tools such as Microsoft Visio, Axure RP

Proficient in SharePoint 2007/2013 administration

Expertise in Crystal reports creation and experience with SSRS, SSIS

Highly Motivated, committed, and a natural team player with the Capability to work independently, strong analytical ability

TECHNICAL SKILLS Microsoft Technologies:

ASP.NET from 1.1 to 4.8 frameworks, VB.NET, C#.NET, MVC, ASP.NET, Entity Framework, CSS, Bootstrap, JavaScript, AJAX, JQuery, XML, WEB API

Programming Languages:

C#.NET, VB.NET, SQL, Java, C/C++, ColdFusion, XML, XSLT, HTML, Forte, ASP, ASP.NET, JavaScript, TypeScript, SQR, Shell scripts, TCL

RDBMS:

MS SQL Server, Oracle 10g/11ic

Operating Systems:

Windows Server 2003/2008r2/2012, UNIX (SunOS/Solaris/O2), Linux

Development Tools / Design Tools:

VisualStudio.NET 2003 to 2022, Dream Weaver, Oracle SQL Developer, TOAD, Microsoft Access, XML Spy, JBuilder, Sun Forte IDE, MS Visio, Axure RP 6.5, Redgate

Version Control:

Microsoft Visual SourceSafe, Microsoft Team Foundation Server with Agile/Scrum, Git Bash

PROFESSIONAL EXPERIENCE

5/2022-8/2023 Sr. developer at Cognizant Technologies Inc.

Managed LPL Financial client works advisers project to debug and update on AngularJS

Managed and updated LPL Financial advisers loans estimate calculator project on Angular 12

Managed and updated capital solution loan Web API .Net core 6.0

Revamping LPL Finacial client works project in capital solution marketplace Angular 12

Updated capital solution loan index rate, capital solution loan detail import, capital solution loan conversion projects, and console app loan report from .Net core 3.1 to 6.0

Revamping LPL Financial client works web API from .Net core 3.1 to 6.0

Worked JRA, GitHub, Git Bash, Visual Studio Code, Visual Studio 2022, SQL database, JFrog Artifactory, DevExtreme Angular components, jest testing, etc.

Manage UPS Payroll system in C#.

Updated UPS SSRS.

Update and manage SQL database jobs and stored procedures.

10/2021-4/2022 Consultant at Kim Technologies Inc.

Developed SAML/SSO components

Developed DocuSign plugin with the Kim platform

Developed data retention rule application

Customer support and bug fix

4/2021-8/2021 Consultant at Intralot Inc.

Working on Intralot gaming system in vb/c# code for web applications.

Created Crytal reports

Created/Updated Oracle packages and store procedure

Created web service with c# on AWS

8/2020-10/2020 IT consultant at Northrop Grumman Corp.

Resolved technical issues on CDC international websites for epidemiology diseases report

Wrote software in C# and VB. Use Web API and Reverse POCO as backend

Created/updated stored procs for SQL database

2/2019-6/2020 Sr. Software Developer at Cognizant

Gathered technical requirements from the application team on the functionality of the application, understanding and documenting specifications on the healthcare company

Designed and updated SQL Database Healthcare data transportation, created stored procs, triggers, and DB jobs at Zelis Health Inc.

Designed and developed Compass Project in C#, WPF, and Web API for Healthcare data transportation with MVVM and Unity-dependent injection.

Designed and developed health care network management application with MVVM application

Created SSRS and Excel reports/invoices

Created service management layers

Created authentication and authorization. Developed system auditing on projects

Led the application team. Gathered technical requirements on the functionality of applications. Revamping inventory application with .Net core 3.1. Documented specifications for a retail company

Worked in Mays on the cashier’s training lecture application with Angular 8 API. Dot Net Web API 2.0 as backend in restful principle. Maintained and updated the Angular UI part. Included used the Observable, Subject, Route model, Pipe, some operators from rxjs, etc.

Worked on ticket handling, database, reposts maintenance, and SQL Ad hoc fix

10/2017-11/2018 Sr. Software Developer at OTR Capital Inc.

Revamped web application to MVC with Entity Framework 6.2 and .NET Framework 4.6. Use code-first with Structure Map dependent injection and UnitOfWork Patten

Developed and updated websites with DevExpress and DevExtreme components.

Developed and upgraded accounting software applications for factor accounting in web forms.

Designed and developed rich and enhanced web pages using MVC 5.0, C#, Entity Framework, JSON, HTML5, CSS3, JavaScript, AJAX, and JQuery

Designed and developed various abstract classes, interfaces, and classes to construct the business logic using C#, ASP.NET

Involved in all stages of SDLC including designing, coding, testing, and implementing the application following Scrum (Agile) methodology

Maintained and updated SSIS for the auto invoices

Created and updated SSRS reports

Created SQL server database archive and cleaned up DB job

5/2017-8/2017 IT consultant at Comcast through Halo Group

Designed and developed the Fiber Tracking project with MVC 5, entity mapping technology, and Entity Framework on coaxial and fiber cables, hubs, and nodes constructions for the business and residential projects which will be used by engineers designing projection and progress tracking on both air and undergrad constructions. Using Bootstrap menus, and JQuery data tables Using SSIS to import data from MS Excel multiple spreadsheets to a separate database schema.

Designed a Security Badge system for HR to give users strict facility access

9/2016-1/2017 IT consultant at CDC through Futrend Technology Inc.

Designed and developed a dashboard permission role management project for HR Office web applications in c#.NET, Entity Framework, JQuery, Telerik, and SSRS in SharePoint. It allows CDC different teams to track and manage new/existing employees’ hiring status, report management, and team member assessment

2/2016-7/2016 IT consultant at Fiserv Inc., Alpharetta, GA

Developed Bank Notification Project in Angular 2/Typescript

Response design and implement Angular 2 with login components, main page, bank client notification, management user insertion and update, client properties management, notification, searching engine, and banking account alert management. Working with HTML5 and CSS for web pages and mobile websites (SPA). Adapted angular 2 UI with Web API 2.0 in Restful and WCF endpoints. Using scrum methodology through Team Foundation Server 2015

7/2012- 2/2016 Tech Lead, City of Atlanta DOA-DIT (Atlanta Airport)

Maintained ASOCS (Airport Safety software), its mobile site support, and GIS

Maintained Atlanta Airport website, intranet, SharePoint, etc.

Worked on the design of the Auto Parking Reservation system

Completed on design Phase and implemented the ASERRT II Project

Developed CRF Report Project in MVC4, JQuery, JSON

Designed and developed the ASOCS Dashboard project by C# Framework 4.0 and Microsoft Chart

Designed and developed Legal Contract Management System by C# Framework 4.5, Entity Framework, Oracle Role base management

Designed and developed the Security Escort Administration System with C#. NET at Hartsfield-Jackson Atlanta International Airport Aviation department

Designed and coded Security management, HR Talent management, Airport Concession management system, Customer Training System, etc.

Designed and developed Market Traffic Data Projects in vb.net, Crystal Reports, and Oracle database including client website, Admin website, and Web service

Updated Customer Service Database and Customer Training Calendar Websites

Lead Atlanta Airport website redesign and TSA Management System

6/2011-4/2012 Software Engineer (contract), Ebix Inc. Health Department

Web Development and update: using C#.NET, VB.NET, XSLT, X-Path, XML, JQuery, and JSON on a multi-layer system

Database development on MS SQL Server 2008, SQL stored procedure development.

HTML WYSIWYG editor customization in JavaScript

Developed new web services, revamped demo page registration in MVC3

Developed Dashboard Permission project

Web service performance report on SSRS

12/2010-6/2011 Software Developer (contract), TSS Photography Inc.

Created Windows Form Applications for franchise business in VB.NET

Created and integrated interactive, presentation-quality crystal reports into multiple Web and Windows applications

Created stored procedures and MS SQL server batch jobs

Developed window applications revamping the financial department

Development of add-on applications to Sage Peachtree Accounting

07/ 2010-12/2010 Web Developer, contract with AirlineApps.com

Updated and redesigned current web applications from ASP or ASP.NET framework 1.1 to framework 4.0 in VB.NET and C#.NET

Updated Database and created stored procedures. Generated SQL reports

Created Style Sheet. Updated web application

09/2008-02/ 2010 Web Developer, Southern Region Education Board (SREB)

Designed and developed multiple N-Tier online registration forms and billing systems in C#.NET with framework 2.0/3.5, LINQ, AJAX, and MS SQL Server 2005. Reference page

Rebuilt client's system for order entry, invoicing, customer contact management, and fulfillment of subscription and survey orders. Integrated system with accounting functions. Developed data mining and reporting functionality to support marketing and management

Designed and developed an email newsgroup system

Designed and updated multiple databases of MS SQL 2005

Designed and created MS Access 2007 administration applications interface with VBA programming and Macro for MS SQL server 2005

Conducted co-op students in programming

01/2006- 02/2008 Programmer Analyst II, Public Employees’ Retirement System of Mississippi

Worked on migrating Public Retirement System from Forte to Visual Studio.Net utilized C#.NET

Responsible to modify and enhance the Public Retirement System. Creating stored procedures and various reports, maintained clients' account information from the system used ad hoc SQL intensively with MS SQL Server 2000/2005

Developed ‘Web Er’ project which involved creating web pages, forms for our representative agencies, and a security model by ColdFusion, .Net, and JavaScript

Updated and maintained the web services for our clients' payroll deduction

Created and maintained applications for the Department of Financial and Human Resource by WinForms, ADO.NET and MS Access, Excel applications by VBA programming, and Macro Created and maintained financial reports with SQR

09/2002-09/2003 Programmer, Meteorology Dept., Jackson State University

Actively participated in the development and implementation of the “Using Java VisAD for scientific visualization in meteorology” project for the Weather Research Forecasting modeling system using Java/JBuilder

Responsible for maintenance on MM5 and New Morrical weather forecasting modeling system. Use Arc View GIS real-time weather data through the Emergency Managers Weather Information System and Weather Processing System. Individually implemented shell script to automate and configure the system installation in SunOS/Solaris

EDUCATION/CERTIFICATE

Master’s Degree in Computer Science. Jackson State University on 2003

ESRI ArcView GIS Certificate

Bachelor’s Degree in Medical Science, Beijing University

Contact this candidate