IVY KOKO S. MACLEAN

***** ******* ******, **. ***** Shores, MI 48080

Mobile No.: +1-586-***-****

Email Address: aca62c@r.postjobfree.com

QUALIFICATIONS

Have 12 extensive experienced in Information Technology, leader,

hardworking, have the ability to handle multiple projects

simultaneously under tight deadlines. Interface well with all levels

of staff to achieve efficient results, have good analytical and

troubleshooting skills. Almost 5 of teaching computer subjects and had

8 years of conducting office IT training for staff.

COMPUTER SKILLS

HARDWARE: Servers, PCs and compatibles, HP and Epson Printers,

Network hubs and switches, Scanners, Tape

Drives and other computer peripherals

OPERATING SYSTEM: Windows: MS Windows NT 4.0, 2000, XP, 7, MS Windows

2000, 2003 & 2008 Server

UNIX/Linux: SCO UNIX, Red Hat Linux 4, 5, 6,

CentOS, Oracle Linux

Other: Novell Netware 4.10,

PROGRAMMING LANGUAGE: Microsoft Visual Foxpro 3.0, Microsoft Access

2000 & 2010, C/C++, Foxfire, Codebook,

DreamWeaver, Seagate Crystal Reports, Microsoft

Frontpage, Visual Basic, HTML, XML, Shell

scripting, T-SQL

APPLICATION SOFTWARE: Microsoft Office Suite 2000, 2003, 2010, Adobe

Acrobat X Pro, Aldus Page Maker, Adobe

Photoshop, Macromedia Authorware, HelpStar,

Lotus Notes, MS System Center Configuration

Manager (SCCM)

DB APPLICATIONS: Microsoft Great Plains, Oracle EBS ERP, Oracle HRMS,

SysAid, QAD ERP, CEBOS, Kronos, MES, Pyramids'

Intelliworks & Intellipack,

BACKUP, MONITORING, Veritas Back-up, Brightstor ArcServe, Symantec

Backup Exec,

DRP TOOLS: Windows Server backup, Legato Replistor, Mailer Daemon,

Mailscan, Wingate, Nagios, Cacti, Ignite, SQL

Server Profiler, Database Engine Tuning

Advisor,

DATABASE: Microsoft SQL 2000, 2003, 2005, 2008 & 2012

Oracle 9I, 10G, 11G, Derby, Progress Open Edge

PROFESSIONAL EXPERIENCE

YanFeng USA Automotive Trim Systems, Inc. 24

Oct 2012 to present

42150 Executive Drive, Harrison Township, MI, USA 48045

IT Engineer (Database/Applications)

. DBA for MS SQL Server 2005 & 2008, Progress OpenEdge

(Administration, Installation, Configuration, Implementation,

Maintenance, Security, Upgrades, Performance Tuning)

. Assist IT Manager with Applications & Database planning

. Document the company's DB environment

. User Systems maintenance and installation

. FTP/SFTP User administration

. Servers backup using Symantec and maintenance

. IT Equipment maintenance and inventory

. Assist IT Team members for Tier 2 IT Support

. In charge of documenting IT Processes for IT Audit, user

manual, IT dept. knowledge base

. Conducting internal IT trainings

United Nation Mission in Liberia (UNMIL) 2 Nov

2011 to 18 Apr 2012

Pan African Plaza, Tubman Boulevard, 1st Street

Monrovia, Liberia, West Africa

UNV IT Technician & Service Desk OIC

. Provide effective and prompt IT software/hardware/second

level workshop support to the end users;

. Endeavour to meet Service Level Agreement targets for 1st and

2nd line in situ ICT support;

. Lead teams to standardize network printers and desktop/laptop

computers configuration in accordance with mission policies

for IT security and network access;

. Monitor event logs for systems, equipment rooms, network

switches and other room environment monitoring devices and be

able to interpret the data;

. Ensure applications are implemented according to UN-

established standards for Information Technologies,

Application Software and Network connectivity on LAN/ WANs;

. Participate in Duty Rosters for limited ICT support after

hours, during weekends and holidays;

. Perform any other related duties as may be assigned (Service

Desk OIC). As Service Desk OIC,

o Oversee & manage 6 staff and handle the operation of

Service Desk.

o Handles ICT complains at 1st level support. Follow

up/escalate ICT issues in a timely manner

o Attend weekly meetings

ACCOMPLISHMENT

V Increased SLA of Service Desk

Document Written:

Basic Training for Service Desk staff

ASIAN INSTITUTE OF TECHNOLOGY

Mar 2008 to Jul 2011

58 Moo 9, Km. 42, Paholyothin Highway

Pathumthani 12120, Thailand

Part-time Oracle & Linux Lecturer

. conducted intensive Oracle training

. conducted Basic Linux Administration training

United Nation Economic & Social Commission for Asia & the

Pacific

UNESCAP - IMCTS 30 Nov 2009 to 18

Feb 2010

2nd Floor, Service Building

United Nations Building,

Rachamnern Nok Avennue, Bangkok 10200

Computer Systems Assistant

. over see and carry out the installation, configuration,

testing and deployment of Linux servers, including

application servers, database systems, web servers,

firewall

. oversee and carry out the administration, operations,

monitoring and technical support of Linux infrastructure

. collect various statistics on the performance and

reliability of server systems, and produce pertinent

reports

. assist in deploying/configuring systems so as to conform to

infrastructure standards

. ensure data security and integrity, perform system backup,

plan and review the disaster recovery and business

continuity process

. prepare, update and maintain system's documentation and

related technical/procedural manuals like security,

disaster recovery, network topology, and maintainance

procedures

ASIAN INSTITUTE OF TECHNOLOGY Mar 2008 to

29 Nov 2009

58 Moo 9, Km. 42, Paholyothin Highway

Pathumthani 12120, Thailand

System & Database Administrator

. Installing, maintaining and administering Information System's

RedHat Linux, Oracle Databases & Applications such as ERP

eBusiness Suite, SISSERV & HRMSERV, System Utilities/Services

. Actively searching for possible bugs and security holes and the

removal of those bugs and security holes also applying fixes

. Handle upgrade to newer versions of the Operating System,

Database and Application software

. Handle security and access rights to database and application

software

. Perform database backup and recovery procedures as well as do

cloning the whole system

. Monitor and tune the networking hardware and software to provide

the best performance

. Propose additional hardware and software to provide the best

network performance.

Freelance Programmer, Computer Consultant

Mar 2004 to Jul 2009

DAVIS LANGDON & SEAH PHILIPPINES INC. Sep

1994 to Apr 2005

4/F King's Court I, Makati City, Philippines

March 1, 2001 to Apr 2005

Systems Administrator

. Supervise company Network System and oversee IT Department

operations in areas such as Systems Administration, Network

Management, Database Administration, IT Training for all

staff, Technical Support and IT Quality Assurance

Maintenance.

. Maintains Servers such as SCO UNIX, Microsoft Windows 2000 &

2003 Server and Microsoft SQL 2000 Server, Microsoft Dynamics

Great Plains Server.

. Responsible for purchasing, configuring and maintaining of

all PCs and Servers (including repair, upgrades etc.).

. Maintain the IT fixed Assets (H/W and S/W) and licenses.

. Performs system backups and recovery.

. Monitor and ensure the network integrity, security, uptimes

etc.

. Installs new software releases, system upgrades, evaluates

and installs patches and resolves software related problems.

. Maintains data files and monitors system configuration to

ensure data integrity.

. Member of the company's steering committee, and directly

reports to the President of the company.

. Function also as Database Administrator - Monitor and perform

routine maintenance on database servers, Design and implement

database solutions, tuning, backups and troubleshooting

tasks. Maintains and installs Davis Langdon & Seah

Philippines Inc. proprietary database

ACCOMPLISHMENT

System Deployed: MS Windows 2000 Server, MS SQL 2000 Server,

Wingate, Microsoft Windows 2000 Professional

and Mailer Daemon, Microsoft Dynamics Great

Plains

Document Written: IT Audit Checklist

January 1, 2000 to February 28, 2001

Computer Supervisor

. Supervise company Network System and oversee IT Department

operations in areas such as Systems Administration, Network

Management, Database Administration, IT Training for all

staff, Technical Support and IT Quality Assurance

Maintenance. Maintains Servers such as SCO UNIX, Microsoft

Windows NT and Novell Netware. Responsible for purchasing,

configuring and maintaining of all PCs and Servers (including

repair, upgrades etc.). Maintain the IT fixed Assets (H/W

and S/W) and licenses. Performs system backups and recovery.

Monitor and ensure the network integrity, security, uptimes

etc. Installs new software releases, system upgrades,

evaluates and installs patches and resolves software related

problems. Maintains data files and monitors system

configuration to ensure data integrity. Member of the

company's steering committee, and directly reports to the

President of the company. Function also as Database

Administrator - Monitor and perform routine maintenance on

database servers, Design and implement database solutions,

tuning, backups and troubleshooting tasks. Maintains and

installs Davis Langdon & Seah Philippines Inc. proprietary

database.

ACCOMPLISHMENT

Systems Deployed: Windows NT Server and Server-based

Workstations

Document Written: Computer Hardware Maintenance Manual-

QA(ISO9001)

Information Technology Policy for DLS

Internet Access and Use Policy for DLS

August 1, 1997 to December 31, 1999

Software Support

. Prepared training modules and conduct training for Davis

Langdon & Seah Philippines Inc. proprietary database such as

Compass, Cashflow, Document Register, Correspondence and Time

& Attendance and commercial software such as Microsoft

Access, Microsoft Excel, Microsoft Word, Microsoft

Powerpoint, Microsoft Outlook, Lotus 123, Wordperfect.

Provides support to end users on a variety of issues.

Identifies, researches and resolves technical problems.

Responds to telephone calls, emails and staff requests for

technical support. Tracks and monitors the problem to ensure

a timely resolution.

August 1, 1995 to July 31, 1997

Programmer

. Reviews, analyzes, and modifies programming systems including

encoding, testing, debugging and documenting programs. Coded

standard libraries and administration modules using Visual

Foxpro 3.0. Designed report layouts using Visual Foxpro 3.0,

Report Writer and Foxfire. Help developed and build program

codes for Davis Langdon & Seah Philippines Inc. proprietary

database such as Job Costing, Job Registration, Catalog,

Compass and Time & Attendance using Foxpro ver. 2.5.

EDUCATION, TRAINING & SEMINARS

BAGUIO COLLEGES FOUNDATION, Baguio City, Philippines

Bachelor of Science in Information and Computer Science

Recipient, MGG Scholarship

UNIVERSITY OF THE PHILIPPINES OPEN UNIVERSITY, Laguna, Philippines

Master in Information Systems (MIS)

. Units earned: 21 units

PHILIPPINE CHRISTIAN UNIVERSITY, Taft Ave., Manila, Philippines

Master in Education

. Units earned: 30 units

TRAININGS ATTENDED for 2013

QAD ERP System Administration Training (conducted by QAD)

June 24 to 28, Aug. 26 to 28 & Oct. 17-18, 2013

Progress OpenEdge DBA Training (conducted by BravePoint) - Aug. 7

to 9, 2013

ISO/TS 16949 Internal Auditor Training (conducted by AIAG) - Aug. 13

to 14, 2013

CEBOS System Admin Training (conducted by CEBOS) - July

26, 2013

Eagle/RFNet Express System Admin Training (conducted by RFNet

Express) - Sept. 17 to 18, 2013

CERTIFICATION achieved for 2012

BRAINBENCH CERTIFICATION

. Microsoft Windows 2008 Active Directory - Aug. 11, 2012

. Microsoft Excel 2010 - Aug. 11. 2012

. Microsoft Powerpoint 2010 - Aug. 11, 2012

. Networking Concepts - Aug. 17, 2012

. Microsoft Project - Aug. 17, 2012

. IT Terminology - Aug. 23, 2012

. Server Administration - Aug. 23, 2012

. Listening Skills - Aug. 24, 2012

. Telephone Etiquette - Aug. 27, 2012

. Linux Administration (General) - Sep. 05, 2012

. Disaster Recovery and Planning - Sep. 06, 2012

. Microsoft Windows Server 2003 Administration - Sep. 17, 2012

CERTIFICATION TRAININGS

EDUPRO LEARNING CENTER, Makati City, Philippines

Microsoft Certified Systems Engineer (MCSE) Microsoft Windows 2000

track

. 2151 - Windows 2000 Network and Operating System Essentials - (Apr 2

to 4, 2001)

. 2152 - Implementing Windows 2000 Professional and Server - (May 7 to

11, 2001)

. 2153 - Implementing a Windows 2000 Network Infrastructure - (Aug 13 to

17, 2001)

. 2154 - Implementing & Administering Windows 2000 Dir Infrastructure -

(Sep 10 to 14, 2001)

. 1561 - Designing a Windows 2000 Directory Services Infrastructure -

(Oct 10 to 12, 2001)

EDUPRO LEARNING CENTER, Makati City, Philippines

Microsoft Certified Database Administrator (MCDBA) track

. 2072 - Administering a Database using SQL Server 2000 - (Jul 2 to 6,

2001)

. 2073 - Programming a Database using SQL Server 2000 - (Nov 19 to

23, 2001)

OTHER TRAININGS

ATENEO INFORMATION TECHNOLOGY INSTITUTE, Makati City, Philippines

MS Office '97 (Sep 17 to Oct 22, 1997), MS Excel '97 (Jul 19 to Aug

23, 1997)

ANTI-HACKER'S DAY WORKSHOP

Venus Parkview Resort Hotel - May 28, 2004

ORACLE SECURITY SYMPOSIUM

Grand Hyatt Erawan, Bangkok, Thailand - Aug. 14, 2008

ORACLE SCALE ABOVE THE LIMITS OF HIGH AVAILABILITY

Condrad Hotel, Bangkok, Thailand - Oct. 21, 2008

ORACLE DATABASE SECURITY TECHNOLOGY DAY

Condrad Hotel, Bangkok, Thailand - Mar. 19, 2009

SAP ERP: INTRO TO BUSINESS PROCESSES

Rangsit University Graduate School

21st Floor, TST Tower

Bangkok, Thailand - Mar. 23 to 27, 2009

LORMA COLLEGE, San Fernando, La Union, Philippines (6

Educational units)

Contact this candidate