Post Job Free

Resume

Sign in

Sql Server .Net Developer

Location:
York, PA
Posted:
December 19, 2023

Contact this candidate

Resume:

Le, Khai Tuan

ad13br@r.postjobfree.com

**** ******** **, **** ** 17402

717-***-****

SUMMARY:

** ***** ** ********** ** building, designing and migrating both dynamic .Net and Java Application as well as database to Azure and AWS.

TOOLS AND UTILITIES:

Visual Studio 2010, 2012, 2015, 2019, 2022, SDK, .Net Framework 4.0, 4.5 and 4.8, 5.0, 6.0 and 7.0

Sql Server 2010, 2012, 2015, 2019, 2022 with Management Studio.

Post Man tool kit to test the API.

Spring Boot, Eclipse, Maven, IntelliJ IDEA Tomcat Servers, Oracle Server, Oracle JDeveloper, (version 8i, 9i, 10i, 11g,12c and 18c)..

Java 7, Java 8, Java 11, JDK 11, JDK 17.

Aws (S3, Elastic Search, Cloudwatch events, Aws Lambda, Amazon Elastic Block Store (EBS) volums).

Azure (Portal, File Storage, Blob Storage, Container, Table and Queue Storage, Data Services and network Service).

Having an ability of Speaking and Writing English, Vietnamese and Spanish.

Next.js Framework (Shallow Routing, Imperative Routing, Dynamic API Routes, Dynamic Components, Prefetch, Container and Layout).

EDUCATION:

Strayer University– 2010

Master of Computer Science

Strayer University – 2004

Bachelor of Computer Science

I am only 4 classes away from completing my second Master in Accounting with current GPA 3.5.

EXPERIENCE:

03/2022 to

Dec /2023 Tollbrothers – Philadelphia, PA

.Net Developer

Project: These projects are to keep track of all customers appointments, housing applications, orders requests, time spending, cost expenses on constructions projects, billings, banking information, locations, permits, reports and etc. The technologies that are used for building, deploying and hosting this project are .Net Core version 3.0.3, Ajax control toolkit, Sql Server Management Studio 18.11.1, css, Rest API, WCF, React Js, Python, Graph QL Windows Azure, Angular TypeScript, Singleton Design Pattern, Dependency Injection, Microservices, Windows Services and more.

EXPERIENCE:

12/2019 to Washington Gas – Springfield, VA

02/2022

Project: Complete the Work Process Tracking System that allows the company to keep track of who is using company’s equipment, who gives permissions on the use of those equipment, who returns them etc. Also, the system will be able to provides reports of tasks that have accomplished by the end of that working day. In addition, using HashCode, Tokens, Random Number Generation and Encryption to ensure data Integrity. Finally, adding or removing contents bases on assigned requirements. In addition, write complex queries, Unix scripts, Oracle Scripts, Data Migration for batch processing, data loadings and deploy them to AWS cloud. Finally, update company Sharepoints contents (Modified Web Parts, Template, Sites and more…)

Below are the listing Technologies and Methodologies that are used while building the above system:

Infor EAM, Ajax, Cloud Technology (Lamda Service, .Net Core, S3, Elastic Beanstalk, EC2, Docker, Cloud Watch, etc..), Rest API, Web Services, Node.js, React, C#, Oracle, Ext.JS, PHP, Drupal, Html5, Css and JavaScript, Angular TypeScript, Postman, DevOps, Agile Development Methodology, and Cognos Report Studio

EXPERIENCE:

11/2015 to CAREFIRST – FairOak, VA

11/2019 .Net Developer/ Java Developer

Project1: Completed the existing part of Survey System Project that was left off by a previous Web Developer by adding different types of reports, filters, access Layer, User Controls, User Defined Functions and more…. This project used Html4, Css3, Css4, Less, Sass, jQquery, Adobe Photoshop, AEM Forms Designers vs 6.4, Angular Type Script (Version 2, 4 and 7), Acrobat Reader, Ajax for front end design. The middle Layer used C# classes and methods. The backend layer used Sql Server (Version 2015), SQL Server Integration Services (SSIS) and SQL Reporting Service (SSR). Deploy and public application to Azure. Also, strong knowledge in sending, deleting SQS messages and queue.

Project2: Build Windows, .Net Web Forms and .Net Core with MVC (entities framework and design patterns like code first, database first, Lazy Loading, Automatic Migration, Dependency Injections, Repository and Factory), Web API (Rest Full Web Services with Get, Post, Put, Delete and Patch), Web Service, stored procedures and methods for small businesses with front end designs using BootStrap, Angular JS (custom directives, controllers, modals, jquery, Ajax, html5, Css3, JavaScript, Vue’s Script, Next.js, Html helpers, Razors, Unit Testes) and back end (C#, Oracle or MsSQL Server). Also, deploy and configure applications to Aws (Lamda Services, EC2, Audora, Docker and more…).

Project3: Build a Scheduling System for Department of Veteran. This Scheduling System is built

inconjunction with Java latest Web Technology and can run on both Mobile and Windows web application. It uses Intelliji tool, Java Jdk 1.8, Eclipse, Spring Tool Suite, Git, Jira, Ios, AEM/CQ services, GateWay Api, Aws, S3, Lamda, Java Generic Collections, Thread Safe, Docker, Pega, Unix, Web Logic Server and Unix for application deployment, version control and project tracking. The front end UI design uses MVC, Html5, BootStrap, Rest, Android, Vue’s.js, React.Js, NodeJS (Buffers, Streams, Process, Events, Callback, Path, React.JS and Css. The middle layer that communicates with both front end and backend are composed of Spring Framework, Spring Boot, Maven Plugin, Node.Js, Python Scripting, Spark, Apache Tomcat Server and Java Class. Finally, the backend databases designs use Object Relational Mapping Hibernate, Oracle Apex (Packages, Stored Procedures, Triggers, Index, Functions, Subqueries, etc…) and Mongo DB.

04/2013 to UNIFIED INDUSTRY, INC – Springfield, VA

11/2015 Lead .Net/SharePoint Developer

Maintaining and Building both the company’s intranet and internet sites by using different types of programming languages, provide technical supports for front users.

Project1: Rebuilding and Redesign the existing Java JSP Web Application to make the web application to be more attractive to users by adding more animations in to it (J2EE, Core Java, JSF, JSE, JSP, Spring Ioc, Spring Injections, Aws (Dockers, EC2, Lamda, MongoDB), Spring Annotation, Spring Dependencies, Core Java, Hibernate Mapping, XML, JavaScript Set time out Interval, Css, html colors and pictures). Also, rebuilding indexes, modified and run speed tests on queries, add triggers, functions and stored procedures to make the existing Oracle Database Application to run faster and more efficiency. In addition, Build new Forms, and maintain existing application that runs on Oracle Apex. Furthermore, built and consume Java, Soap and Restful Web Service Applications using Jersey. Finally, use Enterprise Application Integration principles (EAI) to ensure information in multiple systems is kept consistent, follow the rules, easy to access or more…

Project2: Redesign the Company Sharepoint Site using SharePoint Designers by adding jQuery Animations, TextBoxes, Buttons, Css and Html to Templates, Master Pages and Contain Pages. Packing and Deploying ASP.Net applications to SharePoint Site (Sharepoint Version 2013).

B

Project 3: Build two SpotCheck Applications Systems using VB6 and C++ that will allow the users to import text files into ms access database format, compare, convert, add, make changes to information. Also, the two new systems should be able to generate reports and then export those data back to the text files or csv files base on users’ requests.

Project4: Working as a Team Lead for this project to Build a Samin Science web Site using ASP.Net 4.0 (VB) that displays Samin and Unified Lab’s Products. Users will be able to search for items available, send comments and update information for changes.

Front End Design: Slides Show, Text boxes, Search engine, Pictures, Drop drown lists, Layouts, Master Pages, Content Pages, Telerik Toolkit, Views with MVC 4 (Html5, Linq, WCF, Rest Api, Css, JavaScript, Angular.JS, html, Xml, Jquery, VB, Unit Testing Framework with MoQ and TDD).

Back end Design: VB Class and Methods that connect to Ms Sql Server, Stored Procedures, Encryption Methods for connection strings, Controllers and models.

Project 5: Build POS System for Samin Science Technology.

Front End Design: Buttons, Canvas Layout, Grid, Template, Skin, ComboBoxes, Panels, StoryBoard and etc…

Back End Design: C# classes and Methods with Binding to Databases using DataSet and MVVM methodology.

Project6: Convert an existing JSP Web Application to Java Server Faces using Richfaces, JSF toolkits, DataTables, JSF Models, Ajax, Maven, Eclipse, Web Logic Server, Html4, Css, Oracle Database and more…The system is to provide services and supports for Department of Air force.

Roles and Responsibilities:

Write sub queries, stored procedure, System Cursors, functions, triggers and packages using both oracle and Microsoft Sql.

Build Relational Database Tables, models, Generate Entity Framework with DB context bases on models created using Code First methodology in MVC.

Strong knowledge of Repository, Dependencies Injection, Model Validations, HTML Helpers and Razor in MVC.

Strong knowledge of Mobile Application, Google Map and Cross Browser.

Strong knowledge of SQL Injection.

Create, Update, Retrieve and Delete application information using WCF and Web Api through resource available on the server.

Manage Source Codes using Team Foundation Server.

Used the ADO.Net Entity Framework for doing the data manipulating activities.

Strong knowledge of using different types of tools such as Visual Studio, WordPress.

Strong knowledge of WPF (MVVM, StoryBoard, Canvas, GridLayout, Binding, XAML, Skin and Template).

Maintenance of a risk application, develop Web Application with Rest API, ASP.NET MVC, using C# and NHibernate as its Object Relational Mapping (ORM) framework.

Extract data that are collected from difference sources and write programs that can generate reports for users.

Train and write instructions for new users on how to use new build software or systems.

Build and update the SpotCheck Windows Application System using both C++ and VB.

Create classes, threads and interfaces using c#.

Use Encryption Methods to secure connection strings.

Developed programs in Excel using VBA.

Import Excel Data into MS Access and wrote VBA function to clean up those records.

Maintain, Design and Update both the company’s intranet and internet sites using Java, Spring, MVC4(design patterns), JSP, J2EE, Html, XML, Unix, Ajax, Angular.JS, BootStrap, and Jquery.

Strong knowledge of using different types of tools such as Visual Studio, Drupal, WordPress, Adobe Photoshop, Microsoft SQL Server, Oracle 11g, Unix, Clear Case, Clear Request, Toad and Team Foundation Server.

Strong knowledge of Web Pages, Web Configuration, Security and Web Services.

Strong knowledge of NoSql/RDS.

Write Scripts response to Http Client requests.

Create java classes, html files, xml files, css folders, jsp files that connect to database and .war files. Then, deploy .war files to Web Application Servers.

Analyze requirements, set up schedules times to interview users and design relational databases bases on objects’ entity types, rules, attributes and relationships.

Build Reports using Oracle Form.

Strong knowledge of Algorithms and Pseudocodes.

11/2012 to SYNEREN TECHNOLOGIES CORPORATION- Arlington, VA

04/2013 System Analyst/ Oracle System Maintenance/Content Management

Roles and Responsibilities:

Write subqueries, stored procedures, System Cursors, functions, object types and packages that are able to respond to the customers’ requirements using Oracle 11g, Oracle Apex 4.2 (UI, charts features, responsive form layouts, automatic dml, and Web Development) and Toad Database Application.

Develop Java server-side and Web Logics (Soap and XML) applications that take advantage of the scalability and performance of the Oracle Database.

Write Unix commands or programs that track down the flows of the PDPS system.

Added Cron jobs to Cron under Unix System.

Analyze the costs, operations, options, optimize and more… using Oracle’s Explain Plain tool.

Built, Rebuilt indexes and create Clusters.

Strong knowledge of batch steps in batch procedures, Infomatica/ETL.

Write codes in PHP, JavaScript, Jquery and MySQL Scripts using DreamWeaver and MySQL Database.

Strong knowledge of building dynamic web forms in JSP.

08/2011 to SAGE GROUP CONSULTING, Harrisburg, PA

11/2012 Application Developer/.Net System Maintenance

Roles and Responsibilities:

Created Sql Connection to SQL servers and Oracle Servers (using Web Configure).

Built reports and published them to the web sites so that users will be able to examine those reports (MS Business Intelligence, Reporting Services, Oracle, C#, Jquery, MVC 3, VB.net, Ajax, Json, XML, JavaScript, Web Services, HTML5, JetForms and more….)

Developed units testing for package functions and stored procedures created.

Created Erwin diagram or model for large database system.

Strong knowledge of using ref cursors and sys cursors.

Used PivotTable to extract portions of data that wanted and display them in variety of charts and graphs

Reused and added addition codes to existing projects.

Strong knowledge of using Visual Source Safe.

Created flow charts, data modeling and schema.

05/2011 to BANK OF AMERICA – Wilmington, DE

08/2011 Application Developer

Collect information from clients, interview users for necessary information. Draw and design flow charts of how the data will be flow. Build dynamic web forms that allow users to interact with database using Cognos.

Roles and Responsibilities:

Designed work flows for database system.

Create unit testing for each of the work break down structure.

Reused existing codes from previous developers.

Strong knowledge of using .Net debugging.

Design and Built Dynamic Web Forms (examples: tables, panels, ajax toolkit, css classes, dropdownlist, user controls, source controls, data bindings and more)

Retrieved and create sessions, cookies, etc…

Create SQL Connections to IBM Cognos.

Wrote Package stored procedures, Templates, Filters, Analytical Reports, Charts, etc..

Used Shared Points to populate and shared documents within company’s organization.

09/2010 to BORDER BOOK STORE - WASHINGTON DC

04/2011 Application Developer

Gather all the requirements from the customers, design database diagram, maintain the company web site, database access layer, write and tested complex queries, functions and stored procedures. Ensure technical problems so that the system will perform the result smoothly. Allow the customers to be able to search through items online and keep track of their transactions. Build online shopping carts and more…

Roles and Responsibilities:

Designed database access layer, schema for the system.

Created Classes, Interfaces, Generic Collections, Threads and Methods for reused in C#.

Created Sql Connections to SQL servers and Oracle Servers.

Used Linq queries to replace SQL queries.

Designed web sites structure and maintained the company’s web site (Ajax, C#, HTML, XML, JavaScripts, jQuery, and knowledge of Section 508 compliance).

Embedded stored procedures, functions and triggers when connecting to the database (using SQL server).

Analyzed and measured all the requirements for building the system.

Tested and supported the company’s web site.

Strong knowledge of creating DTS Packages.

Strong knowledge of .NetNuke within the CMS or Content Management Environment (example: changing the look of the web site, set specific security to allow or denied user login).

Having the ability of handling clear request configuration.

01/2008 to COSTCO WHOLESALE - PENTAGON CITY, VA

09/20010 Oracle PL/SQL Application Developer

Collect requirements from Revenue Management system users, design and develop new or modified programs, reports, forms and interface systems (programs to enable exchange of information) in support of Contract Administration, and Accounting. Develop new systems in support of customer sales and quality data analysis. Ensure technical problems related to updates are resolved in a timely fashion so that systems run smoothly. Provide technical and trouble shoot supports to system users.

Roles and Responsibilities:

Performed analysis, design, coding, implement and support (example: Added or Removed Users, Performed update and reset users password, etc…)

Wrote stored Procedures, Functions, Packages and Triggers for back end validations

Code base consists of complex package logic that uses DML and writes all SQL executed to log tables for trouble shooting, and logic that processes logistical data for optimizing selecting a particular product and its features available across different companies. Measuring and reporting product list using Excel, PL/SQL scripts.

Wrote complex SQL queries using joins and correlated sub queries.

Wrote Java, C++ Functions and Plus them into Oracle Procedure.

Analyzing the tables by using method of Normalization.

Build and Rebuild the indexes

Data models consists of almost 100 tables spread among over 4-5 schemas.

Designed billing systems that kept track of account balances, orders and customers’ information.

Developed programs in Excel using VBA.

Import Excel Data into MS Access and wrote VBA function to clean up those records.

Wrote SQL Query for testing those functions.



Contact this candidate