Suphanet Kotchum
What I’ve Done
Business Analyst, U.S.Trading Company
June 2021-August 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, Transfer Pricing Audit Team
June 2020-October 2020
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.
Senior Tax Auditor     , The Revenue Department, Central Audit Operations Division
April 2016-May 2020
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.