Post Job Free

Resume

Sign in

DBA/Application

Location:
Boston, MA
Posted:
October 20, 2023

Contact this candidate

Resume:

HAI NGUYEN

ad0ip7@r.postjobfree.com

617-***-****

Summary

A highly skilled, Microsoft Certified Professional with many years of experience and extensive expertise in Microsoft solutions development for website and applications programming.

Results oriented and customer focus with strong attention to detail, analytical and problem-solving skills.

Proven ability to successfully work in both team and self-directed settings.

Skills

Language/Tools: VB6, VB.NET, C#, jQuery, CSS, X++, HTML, JavaScript, ASP, XML, SQL, Crystal Reports.

Databases: MS SQL Server, Access, Oracle.

Operating System: Windows 7, Windows 10, Windows Server 2019, Unix/Linux.

Version Control: SourceSafe, ClearCase, Subversion, TFS – Team Foundation Server.

Professional Experience

Senior Application Specialist and Oracle Database Administrator, Boston Water and Sewer (BWSC), Boston, MA (August 2017 – Present)

Provide professional and technical support from design through implementation of computer-based applications.

Responsible for the management and end-user support of the Oracle database which is utilized by the Commission’s core applications such as Peoplesoft, Finance, Geographic Information System (GIS) and others used across many departments.

Responsible for the development of the Job Posting application utilized by Human Resource department to post internal jobs on Digital Signage (DS). This application adopted programing best practices and leveraged the latest programming language and technology such as C# and MVC.NET with SQL database.

Manage and develop new feature requests for multiple VB6 applications such as Final_Siteplan, StreetLog, and CIP (Capital Improvement Program). These applications track all internal and external construction projects related to the City’s water and sewer system.

Maintain and provide support for multiple VB.NET applications such as ArchiveBox, Contractors, DailyWaterConsumption as well as Crystal Reports used by the Revenue department.

Manage and develop new reports for CCP (Capital Construction Projects) Paradox9 application which includes the following features:

oTracking of project progress from start to end across Plan, Bid, Design, Construction, Complete, etc.

oTracking of cost associated with water and sewer construction projects awarded to independent contractors.

oProviding reports customized for department specific needs such as Procurement, Purchasing, Designing, Construction estimate payout etc.

Support Analyst II, Boston Water and Sewer (BWSC), Boston, MA (October 2016 – August 2017)

Provided end-user support and handled issue resolution for various applications.

oTriaged incoming service requests from end-users. Diagnosed and applied fixes at the desktop level

oHandled desktop application installation and upgrades.

oHandled complex technical issues escalated by junior support staffs.

oCommunicated application bugs to internal/external developers and keeping IT support team informed.

oIdentified and obtained training for applications utilized by the Commission.

Dynamics AX HCM/.NET developer, Elevate HR Technology, Parsippany, NJ (local office in Woburn, MA) (August 2015 – October 2016)

Developed/maintained new feature requests for Human Capital Management (HCM) application and ensured compliance with Microsoft best practice.

oDeveloped Active Directory feature that allow Human Resource to automatically create AD accounts for new employees upon hired.

oMigrated Dynamics AX 2012 which utilized X++ language on Morph X platform to AX7 running on Visual Studio 2015.

oDeveloped Applicant Portal, a C#.NET web application which:

Allows applicants to search for jobs and apply for them.

Allows HR to collect new hire’s information including ID(s), bank accounts and educational information, etc.

Programmer/Web Developer, Aetna Insurance Co, Cambridge, MA (Feb 2007– August 2015)

Developed and maintained HardWaiver application; a customized .NET web application that allows students to enroll or waive their health insurance.

Developed and maintained VE-Viewer application; a .NET web application that allows school administrators to run reports and generate billing letters for Voluntary Enrollments.

Developed and maintained Subsidy Import .NET window application which includes features such as:

oPicking up excel file (dropped by schools) from ftp server.

oProcessing and validating student information in Excel file format and bulk loading the data into the production SQL servers.

oAutomatically sending emails to notify schools and developers when the total number of bad records reaches the pre-defined threshold and forcing the job to fail.

oSet up scheduled jobs to kick off applications automatically based on predefined schedules.

Programmer/Web Developer, Ames Safety Envelop, Somerville, MA (May 2006 – Feb 2007)

Designed and developed custom bookbuild application utilizing asp.net and SQL 2000 backend. Application features include:

oAllowing users/professors to create custom books online by searching from available contents provided by Pearson. The goal is to provide users the power of creating custom books from multiple sources.

oAllowing users to upload their own materials/syllabus.

oAllowing users to configure the cover page and adding custom text to the back and front cover of their books.

oReference website: http://www.bookbuild.com/links

Programmer/Web Developer, Valueoptions, Boston, MA (October 2004 – May 2006)

Collaborated with the project team to design and develop multi-tiers application which allows users to create adhoc queries, generate crystal reports and export them in PDF format.

Developed and maintained the company’s website ( http://www.masspartnership.com) and the intranet site which include data processing and manipulation to report generation (ASP, ASP.NET, VB.NET, C#, JavaScript, SQL Server 2000, Crystal Reports 7.0, MS Access Reports).

Created and set up scheduled DTS package to transfer data between different database servers

Administered SQL database restore and backup tasks which kept data in sync between development and production environments.

Designed and implemented stand-alone applications (VB.Net, ASP.NET, Window Forms, SQL Server 2000).

Built new reporting templates using MS Access/Crystal 7.0.

Software Engineering, Raytheon, Marlborough, MA (June 2001 – November 2002)

Developed test procedures and conducted test events for System Performance test for STARS project (US Air traffic control system) that observed by FAAs and other government’s witnesses.

Developed JumpSTARS using Korn-shell and Borne-shell scripts.

Investigated and resolved all Software Trouble Reports for JumpSTARS.

Coding Features and Techniques used:

Shell scripts to search and delete obsolete patches and created soft link for identical patches that reside in different directories within a project (server).

Extra work for User support: Software and Hardware configuration

Education

MBA – Master of Business Administration, University of Massachusetts at Boston, MA (September 2014)

GPA: 3.75

oBachelor of Science in Computer Science, University of Massachusetts at Amherst, MA (May 2001)

Minor: Mathematics; GPA: 3.57

Certifications & Training

Microsoft Certified Professional (May 2008)

Exam 305 - Developing and Implementing Web Applications with Microsoft Visual Basic .NET and Microsoft Visual Studio .NET

Web Page Design Certificate (May 2003)

Courses include: Java Script, HTML 1 &2, Photoshop, Dream weaver, and Site Design. Develop and maintenance web page, create dynamic pages.

Web Page Programming Certificate (May 2003)

Courses include: Structure Query Language (SQL), Microsoft Access, and Active Server Pages (ASP). Knowledge of database design, understanding the language of web page programming, application programming and applying them to website development.

Awards

August 2002: Recognized and awarded for Outstanding Performance for the successful development of JumpSTARS product. JumpSTARS is a tool that allows all workstations in the connected LANs to be simultaneously jumpstarted and set up to receive application software.



Contact this candidate