John M. Purcell Email & Phone Number

Chapel Hill, Nc, Us

Durham, North Carolina, United States

Durham, North Carolina, United States

- Maintained Customs Post Entry Audit Log as approved by US Customs during Customs focused review.- Provided required customs documentation for all imports including product composition worksheets, Harmonized codes, and Country of Manufacture. Downloaded 7501 forms for each entry and audited them for accuracy.- Maintained the HTS codes database used by brokerage groups. Includes new product research through CROSS and updates to existing codes driven by CBP rulings. Added 790 new parts to the HTS database in 2020.- Contacted suppliers in Germany, Italy, the UK, Japan, India and more for part info and documentation required by Customs to resolve clearance delays; including worksheets for belts, bearing, motors, sensors, LED lights, inks, and other parts. 113 part worksheets added in 2020.- Processed Freight Payment Cost Allocation Exceptions to ensure account coding accuracy and correct billing.- Used Excel Pivot Tables and other visualizations to do a monthly review of the frequency of domestic shipments by vendor to highlight cost savings and consolidation opportunities.- Ad Hock reporting as needed using VLookups, Pivot Tables, Data visualizations and other Excel functions

- Supervised 20-30 children, led activities such as games, crafts and devotions to promote health and character development and mentored new employees in conflict resolution, communication and understanding group dynamics.

Raleigh, Nc

- Work directly under CEO and Vice President of Worldwide Operations- Utilize skills in procurement, international trade, forecasting, information technology, and industry research. Have completed five major projects to reveal insights and opportunities regarding unused resources within the company, growth forecasting, competitor analysis, and potential areas for growth. - Use Excel functions to calculate formulas, manage data, and create pivot tables and projections- Worked with teams of three to five to brainstorm creative ideas and solutions to business problems, including logistics, strategy, negotiations approaches, sales pitches, event planning and more.

- Served on a team which developed a standardized process to allow for substitution of comparable components within a regulated product.- Communicated professionally and effectively with project team to understand the internal approval process resulting in the creation of a process map.- Delivered presentation to practicum judges and the RJ Reynolds team.