Data Analyst
CurrentLed projects to analyze & integrate data across multiple SQL databases with ERP tools and custom-coded SQL queries:• Saved over $1M in annual purchasing costs by comparing item sourcing from wholesale vs. item manufacturer, including data design, integration, and analysis at multiple different levels (branch, individual purchaser, seasonality, purchase conditions, buyer frequency, and stock vs. non-stock items)• Cleaned up 1% of over 5K vendor accounts by analyzing purchase activity, collaborating with IT & accounting• Identified purchasing process improvements by analyzing 175K transactions to uncover inconsistencies, inaccuracies, and potential fraud using statistical techniques (Benford’s Law, Round & Duplicate Number Usage)