James Hyunwook Park

Business Intelligence Engineer / Data Engineer / Data Analyst

Website Links

• Portfolio : https://jamess2eagle.github.io/portfolio/index.html

• GitHub : https://github.com/jamess2eagle

• Linkedin: https://www.linkedin.com/in/james-park-95381762/ Summary

Business Intelligence / Data Engineer with 5+ years of experience in Data Analysis. Passionate and insatiable learner with strong business background and excellent leadership skills. An advocate for continuous improvement - both personally and professionally. A proven track record of successfully leading multiple projects that yielded thousands of dollars of cost savings and many hours of time savings. Skills & Qualifications

• Languages: SQL, VBA, Python, HTML, CSS, JS, C

• Data Manipulation & Visualization: Pandas, Numpy, Matplotlib, Leaflet, D3, Beautifulsoup, Tableau

• AWS: QuickSight, S3, Lambda, Data Pipeline, Datanet, Athena

• Machine Learning: Scikit-learn, TensorFlow, AutoGluon, Sagemaker Canvas & Studio.

• Database: MySQL, Redshift, Athena

• Other: Flask, Git, command line, Selenium

Work Experience

Business Intelligence Engineer (Jun 2021 to Present) Amazon, Bellevue, WA

• Developed Lambda jobs using python to migrate and share accesses on hundreds of dashboards using boto3 API.

• Developed a CloudTrail monitoring tool using lambda to notify the team of deleted analyses & dashboards.

• Lead Redshift view migration to Data Lake using Managed Workflows for Apache Airflow (MWAA). Additionally, provided necessary training on CI/CD processes to the team.

• Provided training on incorporating Machine Learning on QuickSight using Sagemaker Canvas & Studio.

• Created a Python module that extracts table names from Redshift SQL queries and converts them to Athena SQL queries.

• Developed asset uploading VBA module that transforms, validates and save data into mySQL database automatically. This reduced a layer of approval process and eliminated redundant manual data clean up and uploading process saving over ~400 hours yearly. Moreover, by setting up a macro to insert data straight into the database instead of csv uploads, it reduced the processing time from ~3s / record to ~0.15s / record (~200% improvement).

• Resolved version distribution issue on a macro that was being used by 100+ stakeholders monthly by introducing a VBA module that updates itself automatically. This new module will save significant amount of time and effort from developers and mangers to distribute new versions of the macros to users in a timely manner. Estimated time saving over ~300 hours yearly.

• Created Python script to send email notifications for accolades and anniversary notifications to the organization.

• Developed / Enhanced / Debugged 3~5 QuickSight Dashboards along with views and datasets monthly that simplified business process, minimize risks and improved work efficiency for internal stakeholders.

• Experienced in utilizing AWS products. Created / debugged ETL jobs using Lambda, data pipeline, Datanet, S3, Sagemaker, Redshift and Athena.

• Experienced in working in agile environments by resolving numerous ad-hoc feature / bug requests daily.

858-***-**** • aduvh5@r.postjobfree.com • San Diego, 92124 Business Consultant/Analyst (Business / Data Analyst) (Dec 2018 to May 2021) Kaiser Permanente, San Diego, CA

• Lead an automated correspondence audit automation project by using VBA, Selenium and Altair Monarch that scrapes data from internal website and reconciles against PDF files that reduced the audit time over 80%

• Developed second version of automated correspondence audit automation by utilizing Alteryx and Microsoft Access automating the entire audit process.

• Automated Data Flow Audit by guiding auditors to right questions depending on different scenarios that reduced the average audit time ~ 30% using Microsoft Access

• Developed an automated audit assignment tool using VBA that reduced a daily task that takes over an hour to several minutes.

• Revamped existing dashboards and built new automated dashboards for numerous audits that get reported out to executive leaders, resulting in over 60% of time saving.

• Built a VBA macro that opens closed tags on the internal website, reducing the audit time ~16%

• Discovered, evaluated, and reported a discrepancy in refund audit that resulted in net various amount of over $15k USD every year.

• Through time study discovered an area that can be improved and built a script that leads auditors to the right scenarios automatically reducing the audit time ~11% Service Operations Assistant Manager (Senior Data / Quality Analyst) (Aug 2016 to Nov 2018) LG Display America, Inc., Carlsbad, CA

• Lead insurance claim (~700K USD) project by providing several data and error analyses to verify data accuracy.

• Evaluated the efficiency and renovated parts room, reducing average pick order time by ~40% as well as reducing the Dead-on Arrival (DOA) rates.

• Reduced parts turnover rate from 8 to 3 months by accurately assessing the parts use rate (+250% less inventory)

• Increased parts fill rate from ~40% to 75% by refining parts forecast logic through NPI (New Product Introduction) and by analyzing defects and RMA (Return Material Authorization) trends (+150% efficiency).

• Assisted in persuading CDTFA (California Department of Tax and Fee Administration) auditor to approve use tax refund claim (~80K USD) by setting up a new logic and by providing supporting data. The new process will be saving around 2~3K USD of use tax monthly.

• Revamped the South America RMA process resulting cost saving of ~7.5K USD per year.

• Simulated and studied different customs methods and properly applied them in the appropriate cases, saving ~12.5K USD per year.

• Developed new processes and submitted post-hearing rebuttal comments and exclusion requests to reduce the impact of US-China trade war, saving over 1 million USD.

• Mentored, monitored, and provided guidance for assistants and technicians to meet KPI (Key Performance Indicator)

• Prepared various reports (weekly, monthly, year-end closing data) to managements IT/Data Analyst (Apr 2016 to Aug 2016)

Student Worker, San Diego County Assessor, San Diego, CA

• Reduced physical inventory time from two days to two hours by developing an automated SharePoint forms to manage and track assets.

• Assisted in quality control on roll closing data. Projects

All projects with details can be found in portfolio: https://jamess2eagle.github.io/portfolio/index.html Education and Certifications

Data Science and visualization Bootcamp Certificate University of California, San Diego (November 2020) Bachelor of Science, Nano Engineering

University of California, San Diego (June 2016)

Contact this candidate