Seungmin Cheon Email & Phone Number

Vancouver, British Columbia, Canada

Scarborugh

• Provided IT services to the Technology in Polls department and was responsible for preparing equipment for advance polls and polling day.• Successfully performed fast and efficient network support including troubleshooting, help desk functions, and other correction problems such as equipment functioning, and swapping out equipment• Provided support service to training officers for any technical issues• Took ownership of synchronizing the database between Poll equipment and HQ serve

Toronto, Ontario, Canada

• Configured data visualization using Google Data Studio to deliver a clear representation of data for internal use; performed product data normalization and denormalization for data visualization• Developed automatic ETL from on-promise to cloud using SQL batch files, Gsheet, and Apps Scripts• Responsible for the design, testing, monitoring, reporting, and performance tuning of large-scale databases• Developed a web crawler for competitive analysis of online prices using Python and Selenium• Updated HQ and store databases using Microsoft Dynamics worksheet and DML statements• Successfully exported and imported product data between online store and HQ database• Optimized complex T-SQL queries through SSMS execution plan; improved performance by 60%• Provided Hardware and software technical support for other various departments• Generated reports using excel, Gsheet, word, pdf and crystal report on ad-hoc basis for various teams• Ensured successful network connections between HQ and store servers, and scheduled synchronization• Supported IT workshops and meetings for store managers, sales representatives, merchant buyers• Responsible for documenting all the procedures, manuals, and memos related to database