Adam Hawk Email & Phone Number

Portland, OR, US

Beaverton, Oregon, United States

Portland, Oregon Metropolitan Area

Charlotte, North Carolina Area

• Develop and implement a short, medium, and long-term plan to automate analytics within the Supply Chain Analytics team to transition from an excel based analytics group to a SQL and Dashboarding group for self-service.
• Lead a team of nine financial and operation analysts across two locations to support the contracting and procurement, distribution center, and hospital operation's supply chain teams.
• Manage several projects (4-6 concurrently) involving clinical teams, supply chain support, executive leadership, and financial analyst resources.
• Utilize SQL Server (Simple, Subquery, Case Statements) and excel to analyze financial and operational data.
• Gather requirements, Build and Distribute self-service dashboards using QLIK Sense and PowerBI, to drive positive change and enable prompt KPI data reviews.
• Interface with senior leadership in supply chain, clinical teams, and hospital operation teams.

Charlotte, North Carolina Area

• Generate inventory reports for perpetual operating room supplies by analyzing data from past usage, preference cards and chargeable items.
• Reduce “invoiced but not received” items dollar values by an average of 20% by building additional capabilities to an Access program that help determine the root cause and allow for the ease of “INR” resolutions.
• Utilize SQL (Simple, Subquery, Case Statements, windows functions) and Excel to determine root cause and potential solutions.
• Utilize an ODBC Connection to pull large datasets from an enterprise oracle database.
• Build several databases for multiple facility usage to collect specific information for ongoing projects and proposals.
• Asses supply chain process improvement projects which include producing baseline analytics, project goals, and project timelines for multi-disciplinary teams.

• Lead a team of over 20 associates in the following processes, Inbound, Outbound LTL, Outbound Parcel, Inventory Prep, Inventory Management, and Vendor Management.
• Utilize advanced Excel skills (Pivot Tables, Advanced Equations, Vlookup, etc.) to determine root cause and identify errors to solve complex process problems.
• Responsible for leading projects pertaining to minimizing non-value added activities and increasing associate productivity.
• Serve as a main point of contact on the Operations team for Sage 500 (Mass 500) and the Starship shipping program.
• Provide analytic data to support projects and proposals.
• Led a warehouse transition of a secondary warehouse to increase its output and inventory utilization leading to large increases in efficiency.

Scottsdale, AZ

USA

• Led several teams of up to 50 associates in a variety of logistics and transportation functions at the JCPenney Manchester and Statesville Distribution Center locations.
• Provided analytic data to support associates’ projects and proposals.
• Redesigned the shipping and receiving department to maximize value added activities and increase employee engagement.
• Implemented a new quality program to focus on the root cause of reoccurring errors and promote first time quality.
• Designed an inventory management system which saves over $50,000 per year in materials and shipping costs.
• Graduated from a supply chain management trainee program over a period of four months, upon completion became a logistics supervisor.

Master Of Management In Clinical Informatics

Bachelor Of Science, Business Management

Bachelor Of Science, Supply Chain Management