Resume

Amteck LLC - Data Manager

Employment: 2023/07/05 - Present

Employment: 2019/12/02 - 2023/07/05

Job Responsibilities

Purchase general and specialized equipment, materials, and subcontractor services for construction projects.
Review plans, specifications and contracts to ensure the correct equipment, material, and subcontractor services are ordered and/or purchased.
Determine or negotiate contract terms and conditions, award supplier contracts, or recommend contract awards.
Manage relationships with key suppliers to maintain quality of goods, timely delivery, and compliance to terms of contracts.
Preparing and processing purchase orders.
Maintaining records of all transactions, purchase orders, receipts, and payments.
Approving invoices for materials and equipment rental.
Track and maintain equipment for job sites.
Daily communication with field and office personnel.
Other duties as required.
Analyzes company-wide data on purchasing, pricing trends, and overall project efficacy to increase productivity.

Contributions

Created a new report inside the COINS ERP system to track purchased materials against budgeted materials. Pulled data from Purchasing, Accounts Payable, and Estimating in order to provide information on current qty purchased, overall qty budgeted, and outstanding/committed costs.

In addition to the report itself, I created a SOP and Excel VBA macro to take exported budget information from our Estimating software, and process it to be bulk uploaded into the ERP. This saved Project Coordinators from having to format and upload by hand budgets that are up to 1000s of line items long.

Previously, all equipment POs were entered by hand by employees. This added up to a significant amount of time each day and rather large break in the normal flow of the job. To improve this process I created this web app that took this from a dreaded long process, to quickly filling out a form and bulk uploading this into our ERP.

Rental POs are now being entered into the system quicker and more efficiently. This lead to more accurate, up-to-date job cost reporting and correct invoicing.

After seeing that the tool was useful to myself in my everyday work flow, I distributed it to the other purchasing agents across the company and let them use it as well. When last checked, it was saving almost 2 weeks of labor per year per agent. This opened up time for other, sometimes neglected, tasks to move up in the queue.

The other task that was rather simple but very time heavy was entering purchase orders into the system. To streamline this process I used the Microsoft Power Automate platform. Now quotes are sent to a cloud hosted flow, processed by an AI model, and formatted into an excel file for bulk upload into the PO.

The largest hurdle with this project was matching the vendor items up to our own internal item numbers. To accomplish this I implemented a very basic Reinforcement Learning process where the AI request further input from the user as needed to get the correct answer and then stores the answers provided for future use. This meant that even though the system started with no prior knowledge of our suppliers or our own inventory coding, the more it was used, the more capable it became.

Now, a few months into using this system, the majority of POs from our top tier vendors can be keyed without a person ever opening the quote.

Employment: 2019/10/02 - 2019/11/30

Employment: 2018/10/20 - 2019/09/27

Scheduled and coordinated all outbound and inbound shipments.
Daily coordination meetings with CEO, President, and Production Manager to assess and analyze current production flow
Managed the reorganization of the digital inventory to streamline productivity and inventory maintenance.