JOHAN AN
PHONE: 253-***-****
EMAIL: *******@*****.***
Experience
SEPTEMBER 2018 - PRESENT
Inventory Management Project, Tacoma, WA - SQL Developer
● Created database schema and tables to store inventory data in MySQL for local businesses
● Maintain legacy code and develop new stored procedures
● Validate and analyze small to large datasets
● Generate ad-hoc reports using SQL
● Performance tuned tables by analyzing explain plans and creating and modifying indexes MAY 2017 - JANUARY 2019
KITA/KOFOTI, Seoul, South Korea - International Consultant
● Conduct daily large scale lectures
● Teach and consult job training and interviewing for international candidates
● Consult and instruct resume/cover letters as well as interviewing and public speaking skills
● Attend weekly meetings with other instructors and panels
● Maintain data invoices and spreadsheets of students’ academic performances and results JUNE 2016 - MAY 2017
National Intelligence Service, Seoul, South Korea - Private Consultant
● Consult national foreign relations with overseas workers
● Prepare clients for speaking and conversational tests in English
● Attend weekly meetings with officers and supervisors
● Conduct data cross checks for new clients and past clients using Excel Education
SEPTEMBER 2012 - JUNE 2016
University of Washington, Seattle - Bachelor’s in Economics/Sociology SEPTEMBER 2009 - JUNE 2011
Green River Community College, Auburn - Associates in Arts JUNE 2009 - JUNE 2010
Yonsei University, Seoul, South Korea - Study Abroad Skills
● MySQL, Sql Server, SQL, T-SQL
● Python
● MySQL Workbench
● Excel