John Robert Email & Phone Number

St. Louis, MO, US

St. Louis, MO, US

St. Louis, MO, US

• Implemented manufacturers including Boehringer Ingleheim and Merck into our Formulary Rebate Processing system and utilized SQL to create queries for contracts to manage, integrate, and analyze data.
• Managed over $500 million in invoicing each month and resolved invoicing discrepancies with manufacturers.
• Acted as a liaison between pharmaceutical contracting strategy and clinical account management ensuring that clinical contract language was accurately translated into financial modeling.
• Constantly utilized pivot tables, vlookups, and advanced functions to analyze invoicing data and create reports.

Sunset Hills, MO, US

• Utilized forecasts to ensure accuracy of physical inventory by entering inter-company purchase orders and inter-company transfers into the system following defined processes.
• Managed vendor base with reviews for lead-time, price, problem resolution, shipping, and quality discrepancies and aligned vendor performance with corporate goals.
• Evaluated suppliers based on cost, selection, distribution capabilities, and availability.

Louisville, KY, US

• Prospected for clients using different databases and resources including MiEdge, Dun & Bradstreet, and LinkedIn.
• Put together proposals for various clients across the state of Kentucky.
• Participated in meetings with the sales team where we discussed strategy and technique for making sales.
• Created censuses for both new and existing clients ensuring all information was correct and updated.

St Louis, Missouri, US

• Reviewed purchase order detail sheets from clients validating the expected revenue from each order as well as the costs of charges and presented my findings to the CFO.
• Recorded invoices in accounts payable.
• Created journal entries to close the books for May, June, and July.
• Sent invoices to customers including Dillard’s, Harley Davidson, and Legendary Whitetails ensuring the items they ordered, the quantity of each item, and the freight charges were all correct.
• Prepared materials for board meetings by closing accounts including prepaid expenses and prepaid insurance to generate reports showing changes in each account during the given month.

Master'S Degree

Bachelor'S Degree, Mathematics And Economics And Finance

Education record