Duc Nguyen
Palm Beach Gardens, FL 33412
*********@*****.***
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-***-****
*********@*****.***
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-***-****
*********@*****.***
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-***-****
*********@*****.***
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: ********@*****.***
Gene Walters, CEO
PioneerTech
Phone: 571-***-****
Email: ****.*******@***********.***
Matthew Richard, CIO
LIUNA
Phone: 202-***-****
Email: ********@*****.***
Wayne S. Grinion, National Program Manager
Department of Homeland Security (DHS)
Phone: 703-***-****
Email: ******.*.*******@***.***.***