CHARLIE HAO TRAN

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

Lincolnwood, IL. 60712

E-mail: acu02f@r.postjobfree.com

Objective

To obtain a challenging position in information technology that utilizes my education, work experience, and leadership qualities, with the opportunity for personal growth in a professional environment.

Computer Skills

Operating Systems:

Windows7-8, Windows XP, Linux, SunOS, AIX, HP-UX, VAX, and DOS

Softwares:

Perl, HTML, CSS, PHP, Javascript, VBA, VBScript, MS Access, Oracle, MS SQL Server, Shell-scripts, Active Directory, Exchange, Radius, RSA, MailFrontier, MAXIMO, InstallShield V6.30, Visual Basic, C, Red Brick Data Warehouse, BrioQuery, ODBC, PeopleSoft, Quattro Pro.

Employment

Hanley, Flight & Zimmerman, LLC. Chicago, Il.

Technical Support 8/2014 – 6/2015

• Technical support for the whole office of about 40 employees and 5 remote users with Windows XP, 7 and 8.

• Setup and deploy desktops/laptops to users.

• Keep inventory for toners, order equipments and co-ordinate projects with vendors.

• Create loginID for users for all systems.

• Archived and search mailboxes from former employees in MS Exchange.

• Replaced APC UPS battery for server room, and add more physical hard drives to backup servers.

• Monitor shared drives and increasing disk partition for VMWare.

• Very proficient with MS Office.

• Modify Perl scripts for scheduled jobs.

Neustar Louisville, Ky

Product Support 2/2013 – 7/28/2014

• Provide client support and technical issue resolution via E-Mail, phone, and other electronic medium in accordance with SLA’s.

• Work with other Internal Departments to determine the root cause of customer facing issues.

• Maintain OSS Helpdesk tickets with current information.

• Processing CARE via GUI or load from files.

• Communicate with customers and trading partners for expedite issues.

• Develop tool to help team search for authorized callers, customers’ data, and auto-login from GUI to different websites by using MS Access form and VBA scripts.

• Very proficient with MS Access and Excel.

• Used ServiceNow ticketing system.

• Received Spot Award 10/13.

Freelance Tech Support Chicago, 4/2010 – 2/2013

• Upgrade/repair crashing or slow laptops and desktops for friends, relatives and customers.

• Setup printers, scanners, VOIP phones, DSL, wireless internet.

• Scan and removal for virus and spyware.

• Data backup and recovery.

• Assist/tutoring customers with computer usage, MS Office, emails, internet etc.

• Hardware, software installations and upgrades.

S & T Realty Chicago, Il

Project Manager 5/2008 – 4/2010

• Managed a family construction project for a 7-story masonry in downtown Chicago.

• Worked with architect for the floor layout plans and architectural corrections.

• Worked with general contractor to settle and resolve construction issues.

• Worked with lender to make sure draw requests were paid correctly.

• Coordinated meetings with architect, general contractor, lender and owners.

• Checked the construction reports from general contractor and reported back to owners.

NeuStar - (Formerly a Lockheed Martin company) Sterling, Va

Lead HelpDesk Administrator 06/04 – 4/2008

• Supported internal employees with general computer, applications, VPN and network connections.

• Installed, setup, configured and imaged computers, laptops, printers to the network.

• Setup accounts for ACE, Radius, Network, Email and Intranet for new employees.

• Managed users’ info, Group, Distro lists by Active Directory.

• Granted network access and privilege to users.

• Maintenance of adequate equipment/supplies to meet the demands of the Helpdesk environment.

• Upgraded and migrated data for users from Windows 2K to Windows XP.

• Configured Cisco 1200 series access points and maintain all wireless network access corporate-wide.

• Led and assign projects to team members.

• Dictated meeting and brief with team members weekly.

• Updated weekly and monthly status report of the team to manager.

• Backup data on network drives.

• Gave presentations to new employees in orientation.

• Maintained all network ports in conference rooms and visitor’s areas.

• Designed MS Access database and GUI with two security levels for Legal, Sales and Marketing departments.

• Used Siebel ticketing system.

Lockheed Martin – Chicago, Il

Application Engineer 05/98 to 02/00 Chicago, 01/03 to 06/04 Sterling, Va.

• Developed and maintained detection scripts to provide alerts when production systems interrupt.

• Tier two support external and internal customers on all application and software related issues.

• Maintained Oracle and Versant databases to reflect customers and systems need.

• Installed patches, upgrade for new release, and worked with vendor to fix bugs.

• Lead role for the mass-update of customer’s data for the SS7 projects.

• Lead role in generating ad hoc reports for internal and external customers.

• Wrote scripts (UNIX) and batch (DOS) programs to automate and simplify tasks.

• Performed internal integration, regression, verification and acceptance test for software releases deliver by

software development team.

• Communicated with vendors, customers, and internal network to obtain and provide support services.

• Involved in software release life cycle and industry wide effort for system integration, testing and certification.

• Identified and responded to system deficiencies with those systems as well as recommend, review and coordinate changes

• Technical training to Tier one.

• Compiled reports and M&P documents on business operations and performance.

• Wrote procedures to solve problems, and training peers up to speed.

Syclo LLC. Barrington, IL.

Technical Specialist / System Integrator 02/00 to 01/03

• Installed and configuration software and customized SQL scripts for clients to work with MAXIMO database.

• Implemented and created triggers, functions and procedures in SQL Server and Oracle in clients’ databases.

• Setup and configured handheld devices and PDAs to work with MAXIMO work orders.

• Supported and trouble-shooting for clients issues.

• Customized MAXIMO interface for clients.

• Created Oracle and SQL Server databases for QA group to test on application.

• Project manager and main QA for software international version.

• Created new and maintained installer programs using InstallShield 6.30. These multi-languages installers will be sent to clients for demo or Sales Team using these installers as demo.

• Developed and maintained MS Access database to populate international languages for software installation.

• Setup databases and load clients data dump for trouble-shooting.

• Trained and did presentation to technicians to work with software on the handheld devices.

Commonwealth Edison Chicago IL

Development Analyst III 5/96 to 5/98

• Developed full-cycle and managed Microsoft Access databases for network wide usage to keep track

of development errors and performance statuses.

• Used SQL to get data from Oracle and MS Access for testing purposes and reports.

• SQA administrator: designed and maintained workflow for defect developments and problem logs.

• Utilized the HP Unix and Windows NT systems for projects such as plotting, extract, and to analyze

electrical devices (switches, transformers, fuses etc.) from the Geographical Information Systems.

• Used Oracle, Unix and PeopleSoft to perform model build of general ledger processes.

• Installed Brio, ODBC and Red Brick drivers for users.

• Analyzed and traced errors from Data Warehouse Systems.

• Created reports for various departments by using BrioQuery, Oracle Report, Crystal Report, and MS

Access Reports.

• Project manager for Data Warehouse properties display using Metadata.

• Wrote macro for Excel.

• Installed & Configured Cisco Routers.

• Performed trouble-shooting for employees at the Computer Helpdesk.

• Managed MS Access databases for Network Shared Directory Renewal, Network Account Renewal

and Hardware/Software Reconciliation.

• Administered Novell Network.

• Installed and replacement computer parts and software.

• Verified and granted access for each individual account as needed.

Education: Northeastern Il. University

BS in Computer Science 1998

Certified: Microsoft Certified Systems Engineer 2003

Working Status: US Citizenship

Contact this candidate