CHARLIE HAO TRAN
Lincolnwood, IL. 60712
E-mail: ******@*****.***
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-10, 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
Apex Systems (United Airlines) Chicago, Il.
Field Engineer 4/2016 – 6/2016
• Imaged laptops/desktops for users.
• Refreshed IT equipment for the NOC.
• Installed laptop/desktop/monitor and Cisco Phone for users.
• Assisted users with IT equipment move to new offices/cubes.
• Inventory and tracking equipment.
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 Illinois University
BS in Computer Science 1998
Certified: Microsoft Certified Systems Engineer 2003
Working Status: US Citizenship