Jill Johansen Hastey, Mba Email & Phone Number

St Louis, Missouri, United States

Greater St. Louis Area

Mallinckrodt Contrast Media & Delivery Systems division purchased by Guerbet 2015• Produced 4 years (2012-2015) of missing monthly (US) and quarterly (global) Mallinckrodt (MNK) self-reporting market share/sales reports, coordinating with 2 manufacturing consortiums. Provided Guerbet with indispensable market share reports for 6 newly purchased product lines (MNK Contrast Media and Delivery Systems). This allowed Guerbet to more accurately set manufacturing and sales targets.• Incorporated Guerbet products into 15 standard Mallinckrodt reports (3 major and 12 minor).• Converted Sales Volume from Mallinckrodt preferred Eaches(units) into Liters for reports. • Collaborated with IS/IT to add Liters field into Cognos, converting skus from units into liters within the data warehouse in order to extract sales volume in Liters and eliminate manual conversion for every data pull.• Received Guerbet Value Ambassador Award (employee whose behavior exemplifies the values, principles of action and managerial qualities promoted by Guerbet) for mfg. consortium/market share project, June 2016.

Greater St. Louis Area

Covidien Pharma division spun-off as Mallinckrodt Pharmaceuticals in 2013• Adept at taking an idea from product manager or sales director and creating an Excel model or customer facing tool. Examples include Leverage Analysis tool, expanding existing Contract Calculator tool and Product Allocation tool. Sales Director of Strategic Accounts (DSA) attributed the increase in sales volume to using the calculator tool, which added $506K in annualized margin.• Calculated customer impact of new contracts, tracked customers gained/lost to quantify impact of new contract vs competitor and identify areas to focus sales/marketing efforts. Used by 15 sales managers and 3 DSAs.• Developed/maintained customer facing tools for DSAs to manage largest contracts, increase Purchase Commitment Levels and retain business with lost GPO customers.• Provided analysis of low margin products to help product managers meet or exceed standard margin targets, resulted in eliminating manufacture of 3 products and not stocking 2 third-party products.• Supported core business with analysis projects for marketing and sales teams, including tracking lost sales after the primary Group Purchasing Organization (GPO) contract not renewed, which improved forecast accuracy and prevented reduction of inventory/supply before sales were actually lost.

Greater St. Louis Area

Healthcare divisions of Tyco International spun-off to form Covidien in 2007• Managed request and receipt of data/documents across multiple departments, (5 major/4 minor) to ensure timely completion of GPO requests for information (RFI) and requests for proposal (RFP), 5 to 16 annually.• Performed detailed impact analysis for Executive Management on pivotal events including: new generic product launch/conversion and GPO contract awards. Produced/analyzed multiple scenarios (by unit, mL, procedure and total customer spend) for GPO RFI / RFPs.• Assisted sales organization in execution of new GPO contracts. Developed Excel models which demonstrated customer impact from new pricing structure and tracked customer compliance to contract agreements. This led to price increases for non-compliant customers. • Provided detailed information for Strategic Planning meetings: tracked sales/margin for Integrated Networks, Strategic/National Accounts, GPO contract sales and conversion to new products. • Constructed detailed analytical Excel model for sales organization to identify potential competitive product conversion opportunities by territory. Allowed Covidien to build generic sales of competitor’s brand name product as soon as the patent expired. Product launched Sept 2008 and became profitable immediately.• Presented $1500 monetary award for work going above and beyond expectations relating to the primary GPO RFP, March 2011.

Greater St. Louis Area

• Approved new customer GPO contract pricing requests from 35 sales account managers and 4 DSAs. Verified customer volume and contract compliance requirements using competitive data from IMS Health.• Provided analytical support to sales organization through business reviews and impact analyses of Integrated Networks, Strategic and National Accounts.• Assisted other business units in achieving multi-department and cross-department goals such as partnering with marketing and distributor sales on GPO contract compliance.• Trained 40+ sales personnel and other internal users on how to use IMS Health’s on-line tool for competitive product sales information and the internal Cognos version.

Greater St. Louis Area

• Operated/maintained Excel market model for new product launch, ran multiple scenarios for Sr. Executive Product Development Team meetings.• Calculated annual GPO price increase and corresponding Service Fees for customers.• Prepared Capital Expenditure Requests, including ROI/NPV analysis for new generic product launch. • Created financial models in Excel to analyze Pricing, Freight, Reimbursement and various sales scenarios to GPOs.

Greater St. Louis Area

May Department Stores acquired by Macy's in 2006• Supported executive management by managing Long-Range Plan process, accurately forecasting monthly cash-flow, interest expense and year-end cash balances for $14.4 billion department store retailer. • Managed preparation of financial materials for 5 Board of Directors and 2 Finance Committee meetings. • Successfully completed special projects for senior and executive management including transfer of duties from May Corporate Treasury to Federated (Macy’s) Corporate office.

Greater St. Louis Area

• Operated five-yr. Long-Range Plan with $14.4 to $19.2 billion in annual sales; updated multiple (17 – 22) times per year. • Obtained inputs from 5 other departments at multiple levels company wide. • Produced monthly cash forecast used to determine amount/timing of borrowing needs. • Monitored operating results against Five-year Plan. Researched/explained variances. • Completed special projects, analysis/financial modeling as requested by senior and executive management, such as analyzing feasibility of potential debt prepayments and corresponding effect to earnings. • Managed replacing $650.6 million of high interest bonds with more favorable rate bonds.

Greater St. Louis Area

• Produced University’s $192.2 million annual general unrestricted budget.• Built models unique to each year’s assumptions and variables.• Prepared written analysis of each VP’s annual budget request for University Executive VP/Provost, used in the approval process and subsequent budget review meetings.• Analyzed University programs and projects for Executive VP/Provost, most notably, calculated cost savings of closing Parks College campus in Illinois and merging with main campus in St. Louis.• Monitored current year actual revenues and expenditures versus budget. Notified over-drawn departments and facilitated with budget revisions.• Forecasted current year-end fund balances.• Trained University department administrators how to use new PC-based budget system and provided continued support throughout the budget process.

Bachelor Of Business Administration - Bba, Corporate Finance And Accounting

Master Of Business Administration - Mba, Business Administration And Management, General