Duc Nguyen

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

Palm Beach Gardens, FL 33412

202-***-****

ac6k23@r.postjobfree.com

Qualifications Summary

I.T Manager / DBA with 20 years of experience managing and developing enterprise applications. Expert in gathering, analyzing and defining business and functional requirements; creating global metrics, trend charts and other decision-making tools; leading data-modeling and process-mapping initiatives; and designing/re- engineering processes, workflows and networks. Proven ability to lead seamless implementations and deliver next-generation technical solutions improving revenues, margins and workplace productivity. Expertise Highlights

Data Architecture/Migration, ETL

SQL Server 2005-2014

Data/Business/Systems Analysis

Database Design & Management

SQL Queries & Data Modeling

Agile methodology, Waterfall, SCRUM

Telerik UI for ASP.NET AJAX, MVC, VBS, WPF

C#.NET, VB.NET, Appian, VB6, Visual FoxPro 9

SSIS, SSRS, BI, SQL Server Data Tools (2015)

Laserfiche Development

Education

Florida State University, 1997

B.S Computer Science

Minor: Mathematics

Microsoft Certifications:

Microsoft Certified Database Administrator (MCDBA)

Microsoft Certified Solutions Developer (MCSD)

Microsoft Certified Systems Engineer (MCSE)

DOD Clearance: Secret

Experience

LIUNA, Washington, D.C June 2006 – May 2018

I.T Manager / DBA / Sr. ASP.NET Software Engineer

Manage and develop large-scale enterprise web applications in ASP.NET with a heavy emphasis on SQL Server 2008 SR2 as the data backend. Responsibilities cover all aspects of the .NET SLDC projects at LIUNA HQ. Serving as data architect and DBA for all .NET related projects. Other responsibilities include:

Developed a custom .NET application in ASP.NET utilizing C#.NET to manage membership data for entire LIUNA organization and the 9 regional locations throughout. This application is used to manage over 500,000 active union members keeping track of the following: Duc Nguyen

Cell: 202-***-****

ac6k23@r.postjobfree.com

2

Membership Dues for their current local union

Membership Pension and benefits information tracking

Membership Jobsite location for all members throughout the 50 states

Membership Status from enrolling one local union to another

Developed custom SSRS reports in C#.NET to automate emailing reports to upper management on a monthly basis.

Developed custom letter generation module in ASP.NET for all executive assistants at LIUNA HQ

Developed custom fax tool in ASP.NET to automate sending of all e-fax to and from LIUNA HQ

Re-engineered over 100 FoxPro 2.6 legacy desktop applications into Windows applications designed in VB.NET/C#.NET

Serving as webmaster for current website running DotNetNuke (www.liuna.org)

Designed custom a HIPPA compliance “encryption” tool in VB.NET to encrypt sensitive membership information to be sent via email.

Serving as SCRUM Master on all related .NET and database projects

Successfully re-engineered, converted and migrated the legacy Microsoft Fox Pro 2.6 flat file database architecture into SQL Server environment using SSIS with SQL Server Data Tools

Extract Transform Load (ETL) development using SQL Server 2008, SQL 2014 Integration Services (SSIS)

Enhancing and deploying SSIS Packages from development server to production server

Use SSIS to unite data from existing system and performed data transformation on millions of membership records onto MS SQL 2014 on AWS

Performance tuning of SQL stored procedures using SQL Profiler an Index Tuning Wizard SSIS / SSRS Implementation

Migrating SQL 2005 to 2008 to 2012

Migration of SSRS 2005 to SSRS 2008 R2

Created triggers, views for audit and security purposes

Created different types of User-defined functions for all .NET applications

Developed SQL Server 2008 reporting services (SSRS) to show the membership data trends for the last 10 years.

Created mapping tables to find out the missing attributes for the ETL process

Created source and target table definition using SSIS. Duc Nguyen

Cell: 202-***-****

ac6k23@r.postjobfree.com

3

Created SQL jobs to schedule SSIS Packages

SQL Design / Implementation

Interacted with the users for understanding and gathering business requirements

Served as the initial person to setup/install and configured SQL Server 2005 for development team

Created initial logical and physical SQL database design using Erwin Modeler.

Successfully re-engineered existing Fox Pro 2.6 flat databases into a SQL ERD

Created and managed schema object such as tables, views, indexes, stored procedures, and triggers & maintaining Referential Integrity

Create datasets using stored procedures and reports using multi value parameters

Used indexes to enhance the performance of individual queries and enhance the Stored Procedures

Effectively used views to prevent unauthorized access

Set up Microsoft .NET development team developing ASP.Net applications with SQL as data backend

Set up Visual Source Safe environment to store all database changes including: stored procedures, functions, indexes and SQL performance tuning scripts. BAE SYSTEMS, Washington, D.C Jan 2001 – June 2006

Sr. Software Engineer

Provided object-oriented analysis/design, coding and testing of company’s proprietary web portal management software application designed in ASP.NET. Defined, wrote and managed requirements for a major section of this groundbreaking application. Specialized in designing COM+ components replacing administrators to support web portal.

Helped introduce a new, reproducible software development methodology that contributed to higher quality product releases and a 27% reduction in errors.

Served on team that ported MS-DOS environment to a Windows-based, client/server solution. Efforts averted the threatened loss of customers who were transitioning to Windows and provided a more user friendly GUI.

Championed the implementation of code reviews that detected programming errors early in the development process, accelerating product go-to-market time by more than 15%. Duc Nguyen

Cell: 202-***-****

ac6k23@r.postjobfree.com

4

SAIC, Falls Church, VA Jan 1998 – Jan 2001

Software Engineer

Developed a wide range of internet applications for Health Care Financing (HCFA) including:

FMIA – an intranet application to automate the Employee Evaluation Process

ECEF – an intranet application for the Department of Treasury used to analyze and report chartered thrift institution oversight. ECEF was designed using Microsoft ASP technology and SQL Server 7

EI / DS – Executive Information Decision Support System for the Department of Defense. Received a letter of commendation from COL Russell H. Mattern.

References

Brian Donohue, Chief of Staff

LIUNA

Phone: 202-***-****

Email: ac6k23@r.postjobfree.com

Gene Walters, CEO

PioneerTech

Phone: 571-***-****

Email: ac6k23@r.postjobfree.com

Matthew Richard, CIO

LIUNA

Phone: 202-***-****

Email: ac6k23@r.postjobfree.com

Wayne S. Grinion, National Program Manager

Department of Homeland Security (DHS)

Phone: 703-***-****

Email: ac6k23@r.postjobfree.com

Contact this candidate