Sunghwan Ki

Experience

• 

  Korea International Trade Association(KITA)

  Mar 2008 - Jul 2008

  Americas Team Intern

  - Coordinated events for national visitors such as President Lugo and G.W. Bush.- Organized business seminars to promote an enterprise culture regarding to globalization.- Studied and analyzed the economic condition between Korea and USA.

• 

  Kuehne + Nagel

  Nov 2009 - Sept 2010

  Ocean Import LCL Intern

  - Daily correspondence with overseas agents to ensure documentation accordingly.- Notified other offices in USA and customers of detailed shipment information. - Maintained communication with vendor, shipper, customer, carrier and overseas offices throughout the process and chose proper routing appropriated to the customer’s needs.- Coordinated the release of goods from the carrier, customs or other governmental agency examinations.

• 

  LOTTE chemical

  Oct 2011 - Nov 2013

  Purchasing Specialist

  - Analyzed ICIS and Platts data to negotiate with suppliers to get a fair price and conditions- Analyzed cost of material to estimate alternatives that satisfied with a limited budget- Maintained optimum stock levels within budget allowances and production requirements- Efficiently updated and monitored the status of purchasing orders to assure they were expedited on time- Processed purchase orders to suppliers and requested delivery confirmation, back-order status, and pricing confirmation- Maintained records of warranties and service agreements Show less

• 

  Kukdo Chemical Co., Ltd.

  Dec 2013 - Jul 2015

  Assistant Purchasing Manager

  - Analyzed price proposals, financial reports, market data, and other data in the chemical industry using Excel- Negotiated with various vendors to ensure that a fair price for goods using ICIS data- Planned and purchased chemical materials from domestic and imported with economic conditions- Monitored shipments to ensure timely delivery of the product to internal customers and external customers- Monitored and evaluated supplier metrics for capability, performance, and delivery to meet organizations planning and forecasting needs Show less

• 

  Dongwon Autopart Technology Georgia LLC

  Aug 2015 - Dec 2017

  Assistant Sales Manager

  - Demonstrated efficiency of 2D barcode adoption in logistics management through data analysis- Analyzed customers (Kia, Hyundai Motors) production data from SAP and optimized transportation time

• 

  Fast campus (패스트캠퍼스)

  Jan 2018 - May 2018

  Data Scientist

  - 16 week, full-time career accelerator course with 800+ hours of professional training and practicum experience covering the full range of data science practices and tools.- Intensive training to ensure a solid understanding of data analysis: retrieving, transforming, exploring, and modeling data as well as interpreting and communicating results - Basic Data Science Toolkits: Linux, Git, SQL- Python Programming: Analytics, Numpy, Scipy, Pandas, Scikit-learn, Matplotlib, Seaborn, Web scraping- Machine Learning with Python: Descriptive statistics, hypothesis testing, supervised and unsupervised learning, k-nearest neighbors, linear regression, logistic regression, ridge and lasso regression, cross-validation, PCA, decision trees, random forests, bagging, boosting, support vector machines, neural networks, cluster analysis, Naive Bayes, natural language processing, and time series analysis Show less

• 

  Hyundai Powertech

  Jul 2018 - Jul 2019

  Production Control Specialist

  - Conducted a data regression analysis of the relationship between irregular usage of parts and production processing condition to optimize the inventory level- Analyzed customer demand and calculate both parts inventory and productivity to create an optimal production plan

• 

  PNC

  Jul 2019 - now

  Data Engineer Sr

  - Responsible for data ingestion, wrangling, manipulation, the transformation of raw and master files per business usecase using IntelliJ, Jenkins, Bitbucket, and Spark (ETL Process)- Writing scripts in Pyspark or Scala performing unit tests in Jupyter to ensure the highest data quality assurance proposed by lines of business- Working on analyzing Hadoop cluster and different big data analytic tools including Scala, Pyspark, and Python - Implementing and automating for job work-flow scheduling and monitoring in work and production environment by Control-M- Monitoring the execution of daily and monthly processes and investigation and solution for process errors (data records issues, platform issue, and so on)- Working closely with the data architecture team for the creation, maintenance, and validation of data dictionaries, schemas as well as creation of HDFS paths for different source systems Show less