Data Analyst

OBJECTIVE

To seek a position as a Data Analyst for new challenge

SUMMARY OF QUALIFICATIONS

. Strong analytic ability to generate various reports and dashboards with

reporting tools

. Highly experienced in designing data diagram for logical or physical

database, handling large volume data resources

. Proven skills for excellent organizational and time management for large

scale project

. Extensive experiences in handling various IT environments from desktop,

client/server to high-end servers

. Technical expert with over 16 years experience as a project manager,

business analyst, project coordinator and data analyst roles

. Proven knowledge of data auditing by successful completion of CISA exams

PROFESSIONAL EXPERIENCE

Data Analyst : Nov. 2010 - Feb. 2014

Guestlogix Inc. ~ Toronto,Canada: provides handheld PDA payment devices and

software solution on Airlines, rail and bus operators. listed in Canada

Technology Fast 50 companies.

Technical Skills - MS-Access, Advanced Excel with macro, pivot table,

slicers, vlookup, various charts, Sharepoint, SQL, SQL Server, power point,

VBA

. Gathered and refined daily quantitative logistics data from oversea

branches for over 40,000 handheld devices' repaired component

. Designed logical and physical logistic database model with tables, views

and reports

. Load and archived device status and repair data into consolidated Access

database

. Programmed and manage VBA/Access scripts for forms, report, views and

query to extract and process data conversion

. Ran SQLs, forms and Querys to generate various reports and dashboards

. Created weekly and monthly reports by each customer using pivot, vlookup,

macro

. Upload and download the SLA report onto SharePoint server to share with

users

. Reconciled sub contractor's cost analysis reports on monthly bases for

Finance's payment invoice

. Prepared various statistical reports to meet top management's urgent

decision making requirements in unexpected manner; using dynamic tables

and views

. Monitored daily repairing TAT(Turn around time) for improving the

regional repair center's repair quality and repair technician's

efficiency

. Performed an orientation to introduce company's logistics processes for

new hired employee; created logistics process document

Data Analyst / Web planner (Temporarily), 2012

LSK Canada International ~ Toronto, ON ( www.well4you.ca

Technical Skills - MySQL, php, Magento (Contents Management System),

Advanced Excel, SQL, Web Hosting, Photoshop, Google Adwords, phpMyAdmin,

CSS, Java Script

. Gathered user requirements and planned, analyzed online nutrition food

business

. Analyzed, designed the logical ERD, physical database with mySQL for

installing and customizing the Magento e-Commerce content management

system

. Introduced and customized the Moneris e-payment solution

. Load the refined and cleaned production information into MySQL database

. Launched the online B2C shopping mall website and maintained the process

Project Manager : 2008 - 2010

Hanyang Cyber University Project, LG CNS Inc. ~ Seoul, Korea

LG CNS Inc. ~ Seoul, Korea ( www.lgcns.com, Market leader in Korean SI

market, providing solutions from consulting to system deployment. Over

6,800 IT professionals with annual revenues in excess of $2.4 billion.

. Managed and coordinated $13 million size budget project (30 developers

and PMO) to develop and support online cyber classes for 10,000 students

and 80 faculties

. Estimated and controlled cost for program developing and introducing

solution modules

. Supervised and wrote detailed scopes of work for project staff and 33 sub-

contractors

. Communicated with clients on project status and reviewed each step of

developing cyber classes lectures and online examinations

. Created weekly/monthly status reports and presented system performance

status regularly

Project Coordinator : 2005 - 2008

Korea Meteorological Administration Project, LG CNS Inc. ~ Seoul, Korea

. Coordinated the Climate Database building program to restore historical

climate reports of 2 million pages for eternal preservation

. Developed WBS; Scheduled and controlled project schedule with MS Project

. Planned resources, Analyzed variances, Composed the processes

documentation

. Analyzed, designed and built database of 20TB size multi layer east Asian

satellite images produced by LANDSAT, IKONOS satellites; Using Erdas

Imagine, ArcGis and ER Mapper software environment

Data Analyst : 1998 - 2004

LG Household Inc. MIS (Marketing Information System) Project, LG CNS.

Seoul, Korea

. Downloaded IBM mainframe sales data from IMS hierarchical database

. Sorted statistical data into each products to store into Oracle tables

. Created dashboards through Powerbuilder by each internal division,

department and team status of sales, and consuming materials

. Build graphical status reports using by one touch click information

trends reports

Programmer : 1990 - 1997

LG CNS Inc. ~ Seoul, Korea ( www.lgcns.com,

Technical Skills -DB2, VSAM, IMS DB/DC, CICS, Main frame, COBOL, PL/1, JCL,

Power Builder, Linux, Unix, Oracle, Oracle forms

TECHNICAL SKILLS

Database : MS-Access, SQL Server, Oracle, PL/SQL,

mySQL, IMS DB, DB2

Programming : VBA, ASP.Net, Html, Cobol, PL/1, Powerbuilder,

CICS, php

Database Tool : phpMyadmin, TOAD, Oracle Forms, ER-Win

Applications S/W : MS-Word, Excel, PowerPoint, Magento, Photoshop

Analytic tools : Mindmap, Google AdWords

Project Management : MS-Project, PMS, Crystal Report, Visio, Sharepoint

Methodologies : SDLC, Method/1, Agile

EDUCATION

Bridging Program for Internationally Educated Professionals : 2010 ~ 2012

York University, Toronto, ON

ASP .NET Core Programming Course : 2009,

Choongang Institute of Information Technology, Seoul, Korea

SED Phase II Course, LG CNS Inc. Technical Graduate School, Seoul, Korea :

1991

System Engineering Development : COBOL, IMS DB, CICS, JCL

Bachelor of Arts, English Literature : 1990,

SungKyunKwan University, Seoul, Korea

Honors & Awards

. Certificate of Appreciation for Volunteer works in Good Sheppard

Homeless, KCW Association, Toronto, 2013

. Certified PM(Project Manager), by LG CNS Inc, 2007

. CISA (Certified Information Systems Auditor), Successful completion of

the CISA examination, ISACA, USA, 2004

. Best Employee of the Month, given by LG CNS Inc, 2001

. Y2K Certified Auditor, KAIT(Korea Association for Information &

Telecommunication),1999

. The Army Achievement Medal for Dedicated military serves by US Defense

Secretary, 1988

References Available Upon Request

Contact this candidate