Post Job Free

Resume

Sign in

database design, development, optimization

Location:
Deerfield Beach, FL
Posted:
April 23, 2024

Contact this candidate

Resume:

Tung H. Nguyen

**** ** **** ***.

Parkland, FL **067

Cell phone: 954-***-****

Email: ad4753@r.postjobfree.com

LinkedIn: https://www.linkedin.com/in/tung-nguyen-529b6523/ Profile

Sr. Software/Database Developer; MCP (Microsoft Certified Professional). Database design/development/optimization; Reporting; Scripting; Application development. Technical Skills

• Operating systems: DOS, Unix, Windows 9x/NT/2000/XP/Vista/7/10/11.

• Languages: C#, C/C++, VB 6.0, VBA, VB.NET, ASP.NET, Perl. Limited experience with Java, Pascal, Ada, Lisp/CLOS, VBScript, JavaScript, HTML, ASP, ColdFusion.

• Tools: SQL Studio/Profiler, MS Visual Studio, Visio, ERWin, Toad, git, GitHub, Source Safe, Resharper.

Database and Reporting Development Experience

• Worked with Databases: Oracle 8/10; Microsoft Access, SQL Server 6.5/7.0/2000/2005/2008/ 2012/2014/2016/2019/Azure. Experienced with T-SQL, PL/SQL o Designed tables (fields, constraints, indexes). Built data marts. o Developed stored procedures, functions, views, triggers, (Oracle) packages. o Wrote complex queries (ad-hoc or reporting). Built dynamic queries. o Optimized query performance.

o Created and scheduled SQL jobs for data population or for maintenance. o Developed extended procedure in C/C++ due to its complexity and time constraint. o Set up servers, backed-up/restored database.

o Developed transactional replication and merge replication. o Set up snapshot replication.

o Loaded and transformed data using bulk copy and DTS / SSIS. o Built utilities to import data from different sources.

• Developed reports with: SSRS, Crystal Report, Actuate Report 7.0/8.0, and Perl 5.0. o Design and developed reports in completed cycle. o Developed (Actuate) report libraries for consistency and easier maintenance. Application Development Experience

Worked on all phases of projects from front-end to back-end in role of architect and/or developer:

• Developed web applications using Visual Studio 2003/2005/2008/2010. o programmed in ASP.NET and C#/VB.NET; utilized Infragistics controls.

• Designed and developed Windows applications in VB 5.0/6.0; utilized Sheridan controls. o Used InstallShield to create deployment packages.

• Designed and developed middle-tier components in C# and VB.NET (or VB6.0)

• Developed Access applications using VBA.

• Developed Perl scripts to retrieve data from web pages. or to create formatted reports.

• Developed batch scripts to help automation of tasks.

• Developed utilities in VB or C/C++.

Professional Experience

Office Depot, Boca Raton, Florida

Lead Developer

04/2013 – present

Working in SQL Server 2008/2012/2014/2016/2019/Azure database environment:

• Designed tables, built data mart for product info.

• Developed stored procedures and functions that are utilized by front-end application, API calls, reporting, and data feeds.

• Imported and converted catalog data for foreign countries.

• Imported product and pricing data from different internal systems (Oracle, Snowflake).

• Populated data for data feeds and for search engines (Endeca, Bloomreach).

• Developed SSIS packages in C# to import/export data feeds from/to various sources/destinations

(such as Google, Bing, Facebook, Salesforce, CNET, etc.).

• Optimized query performance; fine tune the flow of data among different systems.

• Developed queries with outputs as XML or JSON.

• Set up snapshot replication to copy data from one SQL server to others. JPay, Miramar, Florida

Sr. Software Developer

11/2010 – 04/2013

Worked in SQL Server 2005/2008 database environment:

• Developed web applications in C# and VB.NET, using Visual Studio 2008/2010. o for customers to send money using credit card/money odder/MoneyGram, to buy merchandise, to review transaction history.

o for admin users to set up configurations and business rules for applications, to review activities and performing actions upon, and to run reports.

• Developed reports for web applications and for SSRS.

• Developed Perl scripts, using LWP library, to retrieve data from web pages.

• Developed batch scripts to help automation of application buildings and deployment of database schemas and projects.

Nationwide Laboratory Services, Fort Lauderdale, Florida 03/2007 – 11/2010 Sr. Software Developer (also 02/2006 – 04/2006)

Worked in Oracle 8/10 database environment:

• Developed web applications in ASP.NET 2003/2005, written in VB.NET and JavaScript, utilized some Infragistics controls:

o for users to enter and keep track of personal information. o for placement of medical tests and displaying of results. o to set up custom medical test templates used in custom reports. o to run and to schedule Actuate reports.

• Designed and developed electronic signature feature for doctors to sign medical orders.

• Developed Oracle Form 6.0 applications and PL/SQL codes for Billing.

• Developed reports with Actuate Report 7.0/8.0.

South Florida Water Management District, West Palm Beach, FL 05/2006 – 03/2007 Sr. Software Developer (contractor)

• Developed an Access application for field engineers to enter data.

• Developed merge replication in SQL Server 2000 to synchronize data between SQL Server database and the Access application.

Citco Technologies Management, Fort Lauderdale, Florida 12/2004 – 12/2005 Sr. Database Developer (contractor)

Worked in SQL Server 2000 database environment:

• Converted data for ViewPoint application (which is a financial tool for Company and Trust Administration)

o Required splitting/merging of data from 50+ tables; as a result, nearly million records have been transferred and replicated.

o Developed transactional replication to convert/ synchronize data between databases of new and legacy systems.

WildCard Systems Inc., Sunrise, Florida 02/1998 – 12/2004 Software Developer

Worked in SQL Server 6.5/7.0/2000 database environment:

• Redesigned and developed an application for data entry and classification of products’ items. Designed and built utilities for users to import product data from different sources.

• Developed an application for Customer Service to detail the debit/prepaid card transactions and cardholders’ information, to perform various actions on accounts.

• Designed and developed an application for Business Users to set up custom configuration for clients, which affects 100+ tables in database. Many sub-systems and applications (such as Authorization, Settlement, Statement, Fee, Report, etc.) relied on these setups.

• Designed and developed the Statement System, built and populated data mart.

• Designed and developed an application to set up, retrieve, and print formatted statements using Crystal Report. Designed and assisted the development of application and batch to export statement data into formatted files for third party to print.

• Developed reports for clients or for internal uses; reports were formatted using Crystal Report 6.0/7.0 or Perl 5.0, ran in batch mode or from applications.

• Modified/enhanced Authorization System, which was linked to Visa or Master Card networks, for customizations for clients in various industries such as Banking, Healthcare, Retailer, etc. Florida Atlantic University, Boca Raton, Florida 06/1997–12/1997 Research Assistant

• Developed a simulation program for the Everglade Landscape Modeling Project, which was sponsored by South Florida Water Management District. o Programmed in C with parallel architecture in Unix environment. Education & Achievement

• 05/2012: Master of Economics, Florida Atlantic University (FAU), Boca Raton, Florida.

• 2004-2005: Microsoft Certificates of

o Installing, Configuring, and Administering SQL Server 2000. o Designing and Implementing Database with SQL Server 2000. o Designing and Implementing Desktop + Distributed Applications with VB 6.0

• 2002: Brainbench Certificates of SQL Server, VB 6.0, and C.

• 12/1997: Master of Computer Science, Florida Atlantic University (FAU), Boca Raton, FL. o 1997: individual winner and team winner of the ACM programming contests at FAU.

• 09/1994: Engineer Diploma of Special Study, National University of Computer Science and Applied Mathematics of Grenoble (ENSIMAG), Grenoble, France.

• 09/1993: Maîtrise of Electrical Engineer, University of Southern Paris (Paris XI), Orsay, France.

• 07/1990: BS of Computer Engineer, Polytechnic University, HoChiMinh city, Vietnam.



Contact this candidate