Timothy Mcilvain Email & Phone Number

Tinley Park, Illinois, Us

Facilitated sales forecasting for the Americas, global strategic accounts, and new top opportunities. Facilitated forecasting of mature and new product demand. Analyzed forecast accuracy. Assisted product management by creating automated reporting to provide data on their products. Created Power Bi dashboards to track sales by product, region, and distributor over several years for North America and Latin America. Created Power Bi dashboard to track sales trends for individual products. Managed allocation process between sales , product management, and manufacturing for products facing production constraints or surplus demand. Created and distributed reporting on booking trends, sales trends, acquired business sales.

Tinley Park, Illinois, Us

Completed pricing requests for special pricing authorization. Worked with sales and product management to balance getting best price to win the business with maintaining profitability and preventing price erosion of the product. Created a Power Bi dashboard to accurately track completed requests, completion time, benefits of automation, and productivity for the first time. Analyzed requested prices against prior pricing, project size, customer importance, and geographic region to provide the appropriate pricing.

Chicago, Illinois, Us

Senior analyst in charge of electric utility tax audits for municipalities throughout the United States. Analyzes tax remittances, address data, and utility bills to ensure that the municipality is maximizing their utility tax revenue and minimizing utility costs.Developed a comprehensive Excel training class ranging from the basics through macros, pivot tables, and advanced functions. Teaches the class on a weekly basis.Team Lead since February 2018

Chicago, Illinois, Us

I assist with any overflow work or special projects. I help maintain and update contact information in the company's database. I maintain a database of events for bank employees to attend for networking and learning.

Des Plaines, Illinois, Us

I was responsible for finding locations to hold infusion therapy classes for nurses. Once I found a location in the desired city I marketed the class to hospitals, clinics, and nursing homes.

Fort Lauderdale, Fl, Us

I taught an ACT test prep course to classes of high school seniors. I taught a 3-4 hour class once a week. Before each class I planned my lesson using information from Kaplan materials and the skills I learned in training.

Arlington, Va, Us

I analyzed supplier proposals over $750,000 to ensure a fair and reasonable price for the customer. I evaluated the basis of the estimates, the learning curves, and the rates and factors applied in the proposals. To complete the analysis I built my own spreadsheets to calculate a fair price based on purchase history, labor hour data, inflation, and regression analysis. Once I finished an analysis my position became the negotiation target. During negotiations I assisted the procurement agent by creating an opening position and then evaluating all subsequent counter offers. I also actively participated in the negotiations by sitting in on the calls to defend our position and answer/ask questions of the supplier. I also provided material estimates for smaller proposals. I used cost history or supplier quotes as the basis of my estimate and applied quantity curves, escalation, freight, and complexity factors to create an accurate estimate.

I performed office duties such as scanning documents, answering phones, creating spreadsheets, and delivering packages.I filed suits and paperwork in various courthouses in the Chicagoland area including Cook and Dupage counties.I completed the discovery portion of lawsuits in which the defense would send me a list of interrogatories and I would answer them with the evidence and information we had already collected.I called creditors in order to forgive the debt of our deceased clients. I served subpoenas to witnesses and defendants.I worked in the Worker’s Compensation Commission in Chicago on a daily basis. I got dates for our Worker’s Compensation cases, ordered case information, and requested continuances for selected cases.

Muscatine, Iowa, Us

I developed and implemented a test to determine if a hot chocolate mix matched the blend manufactured by the producer. The test proved that the lab’s blend did not match the producer’s blend.I assisted in the development of new dry mix products and in the improvement of existing products.I was in charge of creating sample batches and shipping the samples to potential customers, the sales team, and the company headquarters.

Bachelor'S Degree, Economics

Post-Baccalaureate, Pre-Medicine/Pre-Medical Studies