HOP NGUYEN

I am an IT professional with over fourteen (14) years of experience in troubleshooting enterprise information systems and over seven (7) years of experience in programming and application support, six (6) of which are in the healthcare industry and four (4) are with oil and gas industry.  I have solid experience with MS WINDOWS 2003 Server, IIS 6, SQL servers (Microsoft & Oracle) coupled with strong scripting and Visual Studio 2005/2008 development experience.

LANGUAGES
Microsoft SQL, Oracle SQL, TCL/TK, Borland C/C++, Pascal, Visual Basic 6, Visual Basic .NET (2003, 2005, 2008), HTML, JavaScript, VBscript, DHTML, light Unix/Linux shell scripting, PHP, ASP.NET (2005, 2008), CSS

SOFTWARE
Microsoft Office 2007, Microsoft Office 2003, Microsoft Visio 2007, Microsoft Windows 2003 Server, Microsoft Windows XP Pro, Microsoft Vista, Microsoft Windows 7, Microsoft Windows Mobile, Microsoft Sharepoint 2 & 3, Microsoft Internet Information Services (IIS), Microsoft Visual .NET Studio (2003, 2005 and 2008), Microsoft Visual Basic 6, Linux (Redhat, Mandrake), Microsoft SQL Server both 2005 and 2008, Oracle 8i, 9i, MySQL 3+, Provation MD (Provation Medical), Impac (Radiation Therapy), McKesson Horizon Patient Folder, McKesson Horizon Business Folder, Informatica Powermart Central 6, Adobe Acrobat 8, Adobe Photoshop CS3, Adobe Illustrator CS3, Adobe Dreamweaver CS3, Adobe Premiere Pro 2, Adobe Audition 3, Netware Client, SSL, Plesk management, cPanel management

HARDWARE
Dell Small Business Windows 2003 Servers, HP Small Business/Enterprise Windows 2000 & 2003 Servers, enterprise desktops, laptops, and workstations, Windows Mobile 5 PDA, consumer and small business routers & switches

 A+ and Server + certification, Oracle SQL certification, Microsoft Network Essentials
Certified to Diagnose and Repair:
• Compaq Armada 1500, 4100, 7300, 7700, 7800, E500, E300, M700
• Compaq Prosignia 200
• Compaq Deskpro 2000/4000
• Compaq Proliant Servers: 800, 850R, 1200, 3000, 2500, 5500, 6000, 6500, 7000, 5100, 6000, 6000/7000 Pentium II Xeon
• Compaq Workstation 5000, 5100, 6000/8000
• Hewlett Packard Laserjet 4000 and 5si/5simx Mopier/8000 series

12/09 – 06/10: Infosys Contract : Comsys/BP – Trading Floor Mid-Tier Operations SME

- Train Infosys employees on BP Mid-Tier specific technologies and process.
- Serve as 4th level support for operational problem incidents and service request
- Answer questions and advise Infosys employees when asked
- Update documentations

5/08 – 12/09: BP Contract : Mid-Tier Administrator/Applications Support

- Acquired working knowledge of Informatica 8.3, Tidal Enterprise Scheduler.
- Acquired support knowledge of nMarket power, nMarket gas.
- Acquired technical and administrative knowledge of SAS Risk Management.
- Installed Business Objects XI.
- Installed and configured SSRS 2008, SPN & Kerberos.
- Promoted ETL, codes, and binaries from development to testing, and to production.
- Performed troubleshooting of various issues touching firewall, ports, database, and systems.
- As a member of a team of six, supported of 1200 servers for BP trading group.
- Consulted various project groups on implementation methods and best practices.
- Maintained 99% uptime with various systems.
- Programmed VB.NET 2005 tool to kill run away Tidal Enterprise Scheduler module.

7/07 – 5/08 : MEDICAL RESEARCH CONSULTING (Houston, TX) : Software Developer

- Fixed slowness in download of VB6 code at mrcrecords.com.
- Coded C# .NET 2005 Invoice Viewer.
- As part of a group, designed Themis database schema.
- Repartitioned and reloaded Windows 2003 Server, restored service.
- Restored two production servers in one day
---  Virtual Server 2005 R2 on Windows Server 2003 R2 64bit
---  Created two Windows 2000 Servers VM
---  Created a Windows 200 Server cd from i386 folder to replace a missing cd
---  Configured Wisefiles IIS 5 service on one VM (mrcdata.com)
---  Configured RecordRetrieval IIS 5 service on another VM (mrcrecords.com)
---  Updated both SSL VeriSign certifications
- Obtained and signed wisefiles.cab with VeriSign Digital ID (mrcdata.com & wisefiles.com).
- Consulted IT infrastructure changes:
--- Exchange 2007 OU structure
--- VOIP
--- Servers
--- Firewalls
--- Migration Path
- Conducted Salesforce.com Administrator training.
- Planned and implemented disaster recovery offsite co-location (dr.wisefiles.com).
- Troubleshot SQL Server 2005 slowness issues.
- Configured SQL Server 2005 nightly and noon backups and notifications.

9/06 – 7/07 : ACCENTURE, INC : Client Server Analyst - Exxon Mobil Outsourcing Project

- Diagnosed and resolved complex business application and data base (Oracle, MS SQL) issues.  This application portfolio included more than 200 applications.
- Quickly learned information needed to immediately support clients’ applications.
- Modified VB6 codes upon request.
- Coordinated 12 NT 4.0 to Windows 2003 migrations for various business groups within Exxon Mobil (SQL Servers, application servers, and IIS Servers).
- Worked with various vendors to troubleshoot application issues.
- Maintained excellent documentation.
- Developed and strengthened working relationships with department managers, key application users, and key support ExxonMobil infrastructure analyst.
- Obtained working knowledge of Informatica Powermart (data integration software) and added features to existing Powermart job.
- Gained working knowledge of Remedy ticketing system.

11/01 – 7/06 : THE METHODIST HOSPITAL, Houston, TX : Application Analyst III (Clinical Applications & Servers)

Supported information systems for five departments: Enterprise Master Patient Index, Digestive Disease, Medical Staff Services, Pacemaker Clinic, and Cancer Registry.
- Enterprise Master Patient Index responsibilities:
Proactively administered the Oracle 8i database
Performed scheduled database re-organizations
Developed ad-hoc database queries
Created custom web reports
Provided ad-hoc AIX support of IBM AIX 5L server
Maintained eight (8) MS Windows 2000 middle tier servers & server services
Supported eight (8) power users and 25 patient schedulers
Performed troubleshooting of advanced firewalls, DNS, and other network problems
Proactively solicited Security, Infrastructure, and Network IT groups (both TMH & BCM) to assist in problem resolution
Performed HL7 interface troubleshooting between The Methodist Hospital and Baylor
Acted as the vendor’s liaison for current projects, upgrades and requests
Trimmed the Oracle License cost while still maintaining the Oracle support contract
Implemented nightly scripts that trimmed the database and sent database statistics to department specific users
Researched ROI and provided recommendations to project stakeholders
Established a working relationship with Methodist’s external partner, Baylor College of Medicine, for purposes of maintaining a high quality of IT support
Documented the EMPI system to ease on-call and troubleshooting experiences of our team
- Digestive Disease Department responsibilities:
Monitored and supported the Oracle 8i database
Checked and adjusted table space
Actively supported Windows 2000 Application Server
Maintained and supported Windows 2003 Server and IIS Web Server in the test environment
Assisted in configuring the Interface services
Locally installed, administered and supported 12 treatment workstations and travelcarts (with local Oracle databases) running the vendor application, Provation MD, with external image capturing devices
Supported two Methodist satellite hospitals on instances of treatment workstations as well as travelcarts
Installed and supported the dictation application and eighteen dictation workstations
Worked closely with Provation on major vendor upgrades
Maintained constant communication with IT management, department director and power users
Performed troubleshooting and worked with other IT groups to resolve problems relating to workstations and servers
Developed automated scripts to resolve known issues
Researched vendor suggestions and software considerations and then made recommendations to IT management and department director
Documented the system to ease on-call and troubleshooting experiences of our team
Built and maintained working relationships with department users and management
 - Pacemaker Clinic Department Responsibilities:
Worked with Infrastructure to maintain SQL Server 2000 database
Locally installed, configured and supported four workstations
Worked with the vendor on upgrades
Maintained friendly relationships with users in a high stress environment
Performed troubleshooting of application and connectivity problems
- Medical Staff Services Responsibilities:
Supported the Healthline Fox-Pro database and the Healthlinewin32 application (QEW Healthline)
Performed customized code in a VB.NET application to import HL7 data into a database
Consulted with department manager regarding upgrade recommendations
Created Netware snapshots and assisted in SMS application creation
Supported three Methodist satellite instances of the database and application
- Cancer Registry Responsibilities:
Supported the IMPAC vendor database and application running on the Windows 2003 platform
Performed all upgrades, scheduled downtime and communicated with department and IT superiors
Consulted with Cancer Registry management regarding future vendor products and other requests
Assisted users in usage of the application outside of the clinically-specific questions
Performed troubleshooting of advanced network related problems
- McKesson Horizon Patient Folder / Horizon Business Folder Implementation Administrator
Lead technical analyst in the Methodist Imaging Project
Worked closely with the team that included a project manager, three directors, two clinical IT techs, two Cloverleaf techs, one SQL server admin, two server administrators, three McKesson consultants, one McKesson project manager, and six power users
Worked with McKesson consultants in learning the server environment and services
Streamlined the reboot process involving twenty-four servers and one HA SQL server
Received training at McKesson headquarters
Worked with the department heads and power users in designing flowsheets for both Patient Folder and Business Folder
Planned, delivered and installed 12 scanners and scanner workstations
Worked with the HIS team to plan, deliver, and install the 75 ILE scanners and workstation software
Performed troubleshooting of complex issues
Developed a Netware Zenworks package and delivered fat client to 150 PCs across three buildings
Scripted distribute AIS servers to balance loads according to departments and buildings
Documented and performed knowledge transfer to new hires to support project post go-live
Successfully completed project implementation as of December 2004
- Eclipsys Sunrise Clinical Manager support Administrator (assist role)
Loaded vendor hot-fixes
Assisted main technical lead in loading Service Packs
Added workstations, local groups, and printers to print servers
Performed troubleshooting of Citrix client problems
Participated in two out of four go-lives, working nights to assist where needed
- Development
Wrote four Visual Basic.NET applications to fill in features missing from Vendor applications
Eclipsys Sunrise Clinical Manager 4.0 (XA) HL7 Logviewer
---  Application connected to production log server, queried for level 1 errors, and found related HL7 messages, emailed the message and error codes to the responsible party
---  Application ran in user mode or automode
---  Application relied on regex expression to filter match and forward email to listed email address
Eclipsys Sunrise Clinical Manager Report age checker
---  Application checked UNC directory for report files older than 24 hours, sent report to application support group for further action
Radiology PAlog
---  Upgraded old Access 97 database application to a new SQL Server backend and VB.NET frontend with Crystal Reports
---  Designed database, exported old data, imported into new SQL Server database
---  Designed friendly form elements to improve on old application and add additional features to new application
TMH Wireless Access point log and code assignment
This application was integral to providing wireless network access to guests of Methodist patients
---  Application was written in two phases
---  Phase one ran on Cisco BBSM to export list of valid Access Point codes
---  Phase two imported data into SQL Server database
---  Assisted helpdesk in assigning codes and recording name and visiting patient data with VB.NET web application
---  E-mail was generated when Access Point codes were low in the database
- Other Achievements

Nominated for Employee of the Month, March 2006
Maintained working knowledge of other systems in the clinical applications team for on-call troubleshooting and resolutions
Assisted the Physician department IT lead in a consultant role regarding MySQL related database problems and questions
Assisted in multiple IT projects and initiatives
Created and maintained a documentation web server named http://hop to centralize Clinical Apps group systems and support needs. This was created to make on-call easier for a single person (not meant to be the primary on problem system).  Server ran Apache 2.0, PHP, MySQL, and Wikka.
Developed a PHP script text paging system.  This was integrated in the http://hop support page.  This enabled the Helpdesk and IT employees to send alphanumeric text pages to each other. The script worked with Archwireless, Metrocall, Skytel, Nextel, and Verizon Wireless.
Developed PHP script HEAT ticket queue queries on http://hop so the desktop support teams could easily check tickets and notes from anywhere, making desktop group trips more effective
Developed a PHP script management report counts of tickets done for given period of time
Developed a PHP script Oracle database report for expiring user IDs for EMPI
Developed TCL/TK code script to break down large HL7 messages
Leveraged existing technology and resources to consult regarding coworkers’ requests and assist them in completing projects

3/98 – 11/01 : COMPUCOM SYSTEM, INC, Houston, TX : Network Engineer

- Ran critical service and warrantee work orders
- Developed and maintained excellent vendor and customer relationships
- Created an Access 97 inventory database to efficiently manage shipping details of desktops, current location of desktops, configuration stage, packing, Fedex delivery, and receipt confirmation while on Y2K remediation project at El Paso Energy
- Finished two months ahead of schedule with Y2K remediation project at El Paso Energy
- Ordered and expedited seven server hard disk drives during tropical storm Alison, prevented major user data loss with a timely install
- Serviced high profile departments (HR and Executive) while at The Methodist Hospital
- Called on to resolve problems fellow analysts could not resolve at The Methodist Hospital
- Organized and tracked Methodist Hospital’s 100+ Compaq servers
- Researched and informed Methodist supervisors of pending failures and implemented change to avoid downtime
- Diagnosed and resolved network and workstation related problems while at El Paso Energy as a desktop support analyst
- Performed troubleshooting and problem resolution of laptop, desktop, and HP printers hardware problems as a depot repair technician
- Assisted in assembling racks and rack mounting Compaq servers
- Researched and sold parts to major CompuCom clients
- Checked client credit reports
- Consulted hardware owners of upgrades and performance enhancements
- Learned various new vendor hardware as they became available
- Maintained excellent paperwork
- Worked with vendors to verify warrantee and recommend actions to clients

10/96 – 1/98 : SONAT EXPLORATION, INC, Houston, TX : Student Trainee

- Assisted with Lotus Notes user creation and Lotus Notes user configuration
- Worked with lead desktop analyst with helpdesk tickets