Justin T Allison

Justin T Allison 2346 Fleming Dr West Lafayette, IN-Skills & Abilities Data Analysis and Programming SQL (PostgreSQL & SQL Server) Microsoft Power BI. Visual Basic for Applications (VBA). Data analysis, Trend analysis, and Data Visualization Critical and System Thinking Root Cause Analysis Leadership Cross-function team developmental projects. Self-driven Team oriented. Team growth and development focused. Project Management Facilitation and active role in cross-functional project meetings. Maintaining project punch list. Microsoft Project. Microsoft Visio JIRA Kaizen and process improvement projects. Microsoft SharePoint Communication Written and verbal communication across all levels within the companies. Experienced with Microsoft Office, Word, Excel, Outlook, and PowerPoint. Supplier communications. Inventory Management SAP and Red Prairie. Inventory count, correction of inventory physically and systemically. Ability to trace products from multiple points in the process using available systems and information. Professional Experience Supply Chain Material Analyst | Subaru of Indiana Automotive, Inc. | Jan. 2019- Current Assist in the startup of a new logistics cross dock building. Assist in development and implementation plans for process and IS developmental projects, ensuring alignment with organizational goals. Maintain and update project punch list. Facilitate cross-functional meetings with management, third-party logistics teams, IS and other departments to identify process improvement opportunities and drive consensus on solutions. Serve as a central point of contact for all logistic center projects and activities, coordinating efforts across teams to achieve project milestones. Work with SIA third party vendors to reach objectives. Verify and ASN outbound loads. In-depth knowledge of related system to receive inventory and track shipments. Keep track of new model parts and part changes. Provide technical expertise in troubleshooting inventory discrepancies, utilizing various systems and methodologies to identify root causes and implement corrective actions. Use data analysis tools, including Microsoft Excel, to track trends, identify process inefficiencies and, develop data-driven solutions. Utilize various process and modern principles to analyze current workflows, identify bottlenecks, and propose optimization strategies. Continuous improvement of different facets of the position to increase efficiency, accuracy, and value added to the role. Selected Projects Supplier Ordering System Development: Collaborated with the IS team to create a system allowing suppliers to order parts directly, improving order accuracy and lead times. Impact: Enhanced supply chain efficiency and supplier satisfaction. Process Flow Modernization: Designed new labeling and tracking processes, creating flow charts to automate data transfer from suppliers. Impact: Increased visibility and traceability of parts, improving accuracy across facilities. Parts Hot Call, Scrap, and Freight Damage Systems: Assisted in the development and user-side testing of a parts hot call system and a new scrap/freight damage application. Impact: Reduced operational downtime and improved handling of urgent parts requests. Efficiency Improvement Initiatives: Facilitated initiatives to standardize pallet quantities and optimize shipment schedules, reducing daily shipments to weekly. Impact: Lowered labor costs and streamlined supply chain operations. Microsoft SharePoint Initiative: Led the initiative to implement and optimize Microsoft SharePoint for team use. Leveraged SharePoint to improve communication by making it a central documentation hub for projects, tracking milestones, issue tracking, compliance, and other team related files. Integrated SharePoint with data analysis tools such as Power BI for visualization of KPIs, compliance trending, Cost savings. Team event notifications utilized for upcoming events, project milestone due dates, or other relative information. Impact: Simplified and improved communication and information sharing, improved visibility into project performance, active issues, and decision-making allowing for more effective team analysis and proactive processes. Previous Experience Shipping & Receiving (Express Professionals) | Parker-Hannifin | Oct. 2018- Jan. 2019 Shop Clerk | Cives Steel Company | Apr. 2018-Sep. 2018 Quality Assurance Coordinator | Vector Packaging USA | Aug. 2014-Nov. 2017 Primary Responsibilities: Claims Management and Product Quality Testing Education Associates in Engineering | Ivy Tech Community College (currently attending) Applied Organizational Leadership Studies Certificate | Ivy Tech Community College (currently attending) Associates in Information Technology | University of Phoenix 33 credit hours obtained. Major: Concentration in Information Technology. Related coursework: Microsoft Office, Critical Thinking, Intro to Desktop Support, Business Communications, Intro to IS security, Intro to programming. High School Diploma | May 2009 | Rensselaer Central High School