Building ad hoc data workflows with SQL, Python pandas and Excel at Hammerton
Summary Hammerton is a high-end decorative lighting manufacturer based in Salt Lake City, Utah. My work at Hammerton as a Financial/Data Analyst has consisted of ad-hoc reporting and analysis work on a diverse series of projects to analyze and improve business processes. These projects include, but were not limited to: Repricing over 30,000 SKUs of the company's main product line under time pressure. This involved calculating product costs and gross margins by calculating the cost of overhead to produce a product + direct material costs, and acting as a project manager coordinate with multiple departments and executive management to figure out what we will sell and at what price. Building dashboards for Quality to analyze service order data. Updating database fields to simplify the chart of accounts for Accounting. Creating a randomly sampled list of inventory to audit inventory counts. Reconciling discrepancies between purchase orders (what we ordered) and accounting (what we thin...