**** ******* ***., ***** ******, VA *****

Cell 703-***-****

advv7s@r.postjobfree.com

Professional Summary

Mr. Le is a PL/SQL software developer with 20 years of professional experience in database and web development, including extensive work in design and development of information systems, data modeling, relational database design, indexing, SQL performance tuning, data cleansing, and ETL process. He is experienced with Oracle, MySQL, PL/SQL, SQL, Hibernate SQL, and JUnit. He is also familiarized with these tools: InteliJ IDEA, Toad, SQL Developer, Jira, SVN and gitlab.

Relevant Experience

Company/Position: Zachary Piper Solutions / Accenture Federal Services / Software Developer

Date: June 2021 - PRESENT

Duties & Accomplishments:

Mr. Le is working in an Agile environment. He is leading a team of four, adding and modifying the existing PL/SQL codes and Oracle table structures to add Mail Weighted Scores to the mail product reports. He also added new logics for the First Mile processes and Sampling Reorganization processes for the restructuring of USPS districts. He is also conducting bug fixes and performance tuning to enhance the existing system; used partitions and oracle hints to improve performance.

Company/Position: CACI / Software Developer

Date: February 2016 – June 2021

Duties & Accomplishments:

Mr. Le worked in an Agile environment. He worked on data migration and fixed data discrepancies. He wrote many PL/SQL procedures and functions to migrate Oracle data into MySQL database. Applied business logic in the migration scripts to fix data discrepancies and to convert data into the new table structures. He also learned and modified existing java code to fix issues and to add new functionalities to the existing java projects. He also helped the Java developer team with JUnit.

From these projects, Mr. Le used many Oracle and MySQL functions in his PL/SQL procedures, such as: oracle LOAD DATA function to import .csv files into oracle database; used Load Data Local INFILE to import data from text files into MySQL tables; used Export and Import features in MySQL Workbench to backup and refresh databases. He also created tables, indexes, sequences, triggers and views in MySQL database.

Company/Position: VISTA Technology Services, Inc. (VISTA) / Software Developer

Date: January 2014 – January 2016

Duties & Accomplishments:

Mr. Le worked on Real Property Planning and Analysis (RPLANS) for the Army, Army Reserve, and National Guard. RPLANS allows users worldwide to share, analyze and present information about real property assets, organizational stationing, installation populations, and facility allowances and requirements. RPLANS is a web-based application utilizing an Oracle 11, DHTMLX, PL/SQL, SQL, JavaScript, and APEX.

Mr. Le was leading the ETL process that pulls in units' stationing, which uses to build the unit hierarchy. The ETL process also pulls in units' population, assets, requirements, projects, and other attributes to calculate asset allowances for the unit, which then roll up to the complex, site, base, installation, IMO, IMOA, and the US ARMY. The ETL process takes three weeks to complete; it has 100-plus PL/SQL procedures and functions, 100-plus tables and million records of data.

Mr. Le designed the Data Validation report, a dynamic validation process that allows users to validate their real-estate allowances, requirements, assets, excess and deficits, and report up to the chain of command. Mr. Le also designed the Footprint Reduction Plan report, a process that allows users to plan for excess reduction and report up to the chain of command. Mr. Le also lead and worked on the Planning Module that allows users to plan for asset reduction or asset increment when moving units from a batallion to another battalion.

From these projects, Mr. Le wrote many PL/SQL procedures and functions and used many Oracle functions, such as: bulk collect, pivot, partition by, forall, merge insert update, result_cache relies_on, and oracle hints. He also created local temporay table, table types, indexes, sequences, triggers and views; created interactive Apex reports and using DHTMLX to create user data entry screens.

Company/Position: Booz Allen & Hamilton / Associate

Date: 2000 - 2013

Duties & Accomplishments:

SHARP Project: August 2013 - December 2013

Mr. Le worked on a Sexual Harassment Assault Response and Prevention (SHARP) project for the ARMY. SHARP is running on Microsoft SQL Server 2008. Due to the inheritance of bad legacy data that caused discrepancies in the reports, he worked with the clients to do data cleansing. Using T-SQL Mr. Le created several standardized global views for the reports to use, which created standardized reports and fixed the discrepancies. He also created several reports by using SQL Server 2008 Report Builder.

ENGLink Redesign Project: September 2009 – July 2013

Mr. Le worked on the Engineer’s Link Redesign (ENGLink Redesign), a Java web-based application utilizing an Oracle 11G in a UNIX environment, Oracle APEX, Java, JavaServer Faces (JSF), Richfaces, JBoss Seam, Weblogic, Hibernate SQL, SQL, JavaScript, CSS, XHTML, HTML, Tortoise SVN, Atlassian JIRA and FishEye.

He created the user interfaces by using JSF, Richfaces, and Ajax components. He created EJBs, stateful session beans and stateless session beans to support the front end, to pull data, create, modify, and remove data from the database.

He used Drools to check for user permissions; he used Ajax to hide and show the fields on the fly, and to change data set in the drop downs. He also used java scripts to do on the fly calculations.

He is fluent with H-SQL and oracle SQL and used them to pull data for reports, list pages, and searches.

He lead and developed many modules in ENGLink, in particular the Deployment module, the vital application with the most use and which is the most complex module in ENGLink. It consists of 30+ tables and 40,000+ lines of code.

Mr. Le created APEX interactive reports for the Mission Power module and the Deployment module.

He also worked on database migration using Toad data pump import and export. Migrated 500+ database tables (15+ GB of data) and wrote many scripts to convert the legacy data to the redesigned Oracle database.

He lead the performance tuning, converting H-SQL into Oracle SQL, fine tune Oracle SQL, redesign the business logic, and created necessary indexes which result had speed up many modules in ENGLink.

He lead a team of three to develop an Incident Report System (IRS). Successfully compressed the delivery date to a third of what was originally estimated.

ENGLink Project: Jan 2000 – August 2009

Mr. Le worked for 10 years on the legacy Engineer’s Link (ENGLink) enterprise web-based application utilizing an Oracle 10G Server in a UNIX environment, PL/SQL, SQL, JavaScript, HTML, CSS, Toad, ChartWorks Charting Engine, Ploticus, and Visual Source Safe. His responsibilities included team leading, task management, schedule management, requirements gathering, code promotion, application design and development in both dynamic PL/SQL, SQL, relational database design and development.

Mr. Le was the lead in the SQL performance tuning, support and maintenance of the ENGLink database that consists of 1000+ packages, tables, procedures, and views.

He assisted team members in designing Oracle tables, indexes, and ensured that his team members used good coding practice.

He has provided tutoring, training and mentoring on ENGLink, Oracle PL/SQL, SQL to all team members.

Mr. Le was a leader in code promotion, validating code and preventing bad code from entering production.

ENGLink is the primary tool used in the Emergency Management and Response cell of the U.S. Army Corps of Engineers for daily activities and is accessible globally on the Corps Network. Application capabilities are centered on people and mission management. System functionality includes file transfer management, reporting and briefing capabilities, financials, personnel management, and skills matrices.

Summary of Skills, Tools, and Technologies

JSF / RichFaces / Ajax (4yrs)

PL/SQL (11yrs)

SQL (12yrs)

Hibernate SQL (4yrs)

Transact-SQL (2yrs)

JavaScript (3yrs)

HTML / HTP & HTF Packages (10yrs)

XHTML (4yrs)

DHTMLX (1.5yrs)

JUnit (2yr)

Oracle Relational Database Design (16yrs)

Toad (13yrs)

SQL Developer (2yrs)

MySQL Database Design (2yrs)

MySQL Workbench (2yrs)

Oracle APEX (3yr)

Weblogic/JRebel (4yrs)

JBoss Seam (4yrs)

JIRA / Atlassian (4yrs)

Version Control (SVN, Citrix, gitlab)

Clearance: Secret (expired)

Investigation type: NAC/LAC/CREDIT

Agency: DoD CAF

Investigation date: May 16, 2013

Clearance: Public Trust (active)

Investigation type: Sensitive

Agency: USPS

Investigation date: May 13, 2021

Education

Pennsylvania State University, B.S., Electrical Engineer

Strayer University, M.B.A., System Administration

Contact this candidate