top of page
Home: Blog Feed
Meet Suphanet Kotchum
Home: Welcome
Education
My Schooling
MS in Applied Analytics, Columbia University
MS in Taxation, DePaul University
(Fully funded by the Royal Thai Government)
BBA in Accounting, Khon Kaen University
Home: Education
Experience
What I’ve Done
Business Analyst, U.S.Trading Company
June 2021-Aug 2021
Supported a team of 3 people on warehouse optimization and ad-hoc projects.
Analyzed data for warehouse optimization, resulting in 5% increase in picking and replenishment efficiency.
Resolved error in the database regarding product information by writing SQL query to extract, load, and transform (ELT) data from database. Then using both SQL and PowerBI DAX to manipulate data before finding deviations.
Improved internal inventory platform by converting product images from a source folder into binary data (Base64Encoder) with Python query and uploaded on PowerBI, resulting in faster inventory research for employees and faster response times to customer service requests.
Re-addressed product storage locations in the warehouse based on the product footprints to minimize damages when packing and delivering that can cause product crushing.
Established Minimum Order Quantity (MOQ) for different customers based in California, which are wholesales, retails, and restaurant customers, by utilizing sales, distance, gas price, truck capacity, and customer data.
Improved warehouse capacity by analyzing product movements, products, storage locations, sales data to recommend items to discontinue which gaining additional available storage locations.
Evaluated Rate of Return using Time Series and dashboard to illustrate abnormal returning behaviors and conducted interviews for root causes. The new return policy was constructed to reduce return abusers.
Senior Tax Auditor, The Revenue Department of Thailand
(Large Business Tax Administration Division)
Performed data analysis of 200 multinational companies to identify possible transfer pricing rules non-compliance.
Executed in-depth data analysis and tax audit using Profit Level Indicators (PLIs) on transfer pricing rules compliance multinational companies, yielding incremental of $50 million tax revenue.
Conducted tax audit on international tax avoidance cases.
June 2020Â - October 2020
Senior Tax Auditor, The Revenue Department of Thailand (Central Audit Operations Division)
April 2016 - May 2020
​
Tax Auditor, The Revenue Department of Thailand (Central Audit Operations Division)
May 2011 - December 2013
Spearheaded a team of 6 auditors in auditing the 50 highest-profile national tax cases including serious tax crimes annually.
Juxtaposed information on tax payments, tax return filings and financial performance with information received from other law enforcement authorities including Anti laundering Money Laundering and The Narcotics Control Board to find anomalies in tax compliance, contributing to additional tax-revenue by 200%.
Collected data from interviewing taxpayers and performing on-site visit to develop comprehensive tax audit strategies.
Verified VAT payments throughout the supply chain to facilitate VAT refunds consideration and criminal legitimations on the making and using of false invoices.
Established analysis and audit guidelines for high net-worth individuals.
Coached trainees and team members to analyze large datasets to detect tax frauds.
Home: Experience
My Skillset
Data Analysis
Python and R programming languages
Data Visualization
Tableau
Database
MySQL, Spark, Hadoop
Home: Skills
"Life begins at the end of your comfort zones"
Neale Donald Walsch
Home: Quote
bottom of page