Senior Data Analyst

• Jan 2019 - Present

Expert - POS(Point of Sale) Management

• Feb 2017 - Feb 2018

• Created a tool (using SQL/Excel Macro) to pull POS data errors processed week prior to either fix the POS or report to Accounts Receivable for the errors that cannot be fixed.• Answered questions regarding POS data from various departments including sales, accounting and within the SBT (Scan Based Trading) department mostly using ad-hoc SQL queries and advanced Excel techniques such as Pivot Tables, VLOOKUP, and advanced formulaes.• Investigated and reported POS data issues to relevant departments.• Proactively created a tool to find discrepancies between two SQL tables and reported to get them fixed.• Participated in refining tools created by testing and finding issues and suggesting fixes.• Found and corrected miss-assigned POS data.• Participated in IT meetings as SBT department representative for server immigration, and other issues.

SBT Data Analyst

• Oct 2014 - Feb 2018

• Processed daily POS data for magazines & books from Canadian and US retailers for a magazine/book wholesaler.• Created a tool (using SQL/Excel Macro) to validate incoming POS data and report anomalies before processing daily POS; this reduced the check time from an hour to 5-10 mins.• Sent out weekly POS Anomaly Reports (Customers / UPCs) to Sales / EDI / UPC management / AR / Customer account Management for missing or low POS record issues and followed up.• Ran monthly final/raw report for retailers to summarize to analyze the POS VS Distribution• Uploaded POS that were missed from original EDI transfer according to the specification of database by changing formatting and checking with current data with correct formatting and created manuals for common retailers and what needs to be done for each retailer to create no problem when uploading them.

Inside Sales & Customer Service - Korean Language Support

• Nov 2012 - Oct 2014

Office Administrator

• 2006 - 2007

Operation Support Team

• Jan 1997 - Dec 1998