Emily Woodhall Email & Phone Number

Hurst, Tx, Us

United States

Focused on setting the strategy and leading HR data governance, developing our HR data platform strategy, and auditing systems to identify and address accuracy gaps. This ensures our data infrastructure supports the digital-first, advanced technological initiatives within HR, drives organizational efficiency, and provides a better foundation for People Analytics

Irving, Texas, United States

Irving, Texas

Irving, Tx

- Support manufacturer negotiations across distribution channels though economic models and recommendations of rate negotiations- Create economic models for new products manufacturer contract renewals - Created template and streamlined process for economic models - Calculate gross margin for product through buy and sell side financials - Provide forecasts based on market research and model assessments - Estimate gross margin for pipeline products based on analog performance- Build economic models for ‘what if’ scenarios in the market related to Gross to Net reductions, channel shifts, new differential pricing models and changing competitive landscapes- Manage Specialty/Biosimilar list of 600+ products - Identify FDA approvals and assess for Specialty designation within McKesson - Audit SAP for correct coding - Product / Market research for specialty and biosimilars- Support differential pricing strategy for Specialty/Biosimilars—a $44B segment for McKesson - Guide strategy for new sell side pricing models and customer specific negotiations - Aid in planning and design of reporting / Tableau dashboards for differential pricing

Ft. Worth, Texas

Overview- Manage Green Belt program with 21 Green Belts- Trained two Green Belt classes- Grew Customer Care Green Belt program by 60%- Manage a Green Belt engagement rate of 67%- Manage portfolio of 13 active projects across five business areas- Perform analytics for large scale projects including predictive analytics- Develop Tableau reporting to support project initiatives - Co-trained Black Belt classProject Impact- FY16 financial impact: $2.7M || FY17 financial impact: $1.3M- Managed migration of 8000 employees from Office 2007 to Office 2016 (O365)- Analyzed and provided automated solution to enroll more customers in profitable generics program realizing an additional $1.0M in margin in the first two phases- Developed reporting and analysis model to identify customer order times for early order release and holiday schedule management in the supply chain to increase capacity and reduce overtime- Provided solution to connect call data sets together to provide better analytics to Customer Care - Leveraging predictive analytics to determine customer attributes as indicators of more frequent call patterns and initiate project to reduce inbound calls from these customers- Developing analysis to determine new high volume central fill model to increase working capital and add a new revenue stream- Vetted impact of expanding footprint to Puerto Rico for a particular customer- Vetted impact to operation in the loss of a large customer- Vetted impact of shipping tote consolidation for large customer chain

Carrollton, Texas

Project Impact - Led analytics through RFQ development and decision making for enterprise wide marketing spend reduction project driving projected savings of $3.0M EBIT - Developed analysis models including RFQ analysis and inventory analysis for enterprise wide wireless carrier project driving projected savings of $4.8M EBIT over the first three years - Developed process and data analysis to identify savings opportunity in Indirect Procurement for non-catalog purchases across 14K vendors and 2,329 purchase orders using weighted ranking analysis using MS Access and IBM Quality Stage for data processing - Utilized SQL Server to calculate project benefit using what-if analysis for rebate contracts to drive EBIT savings of $0.5M - Created complex MS Access database to vet returns matrix analysis project across three market segments which identified EBIT savings opportunity of $4.0M where customers have returns fee logic at the account level - Analyzed current state of Corporate Accounts Payable payment terms to determine financial loss of not utilizing the best payment term and determined an 11% non-compliance resulting in $1.1M lost working capital driving a system enhancement for auto-choosing best term for payment - Leveraged data to determine financial risk of current state logic for free Remote Emergency Delivery fees and propose multiple options for new logic - Designing a dashboard for Consumer Products Group to determine which items to review or remove based on profitability and sales volumeLeadership - Support Black Belts with data mining and analysis through SQL Server, TOAD, MS Access, MS Excel, Netezza, and Business Objects - Developed and presented several Lunch & Learn for Green Belt Engagement Program - General support for other GB initiatives (Networking event, Expo, Year End Event, other L&L's) - Manage GB Engagement Program and support four GB's on their Six Sigma projects

Carrollton, Tx

Reporting Solutions:- Created process map for Primary Care rebate reconciliation- Automated supplier notification of expiring contracts for EC saving three hrs/ month- Built financial models to analyze impact of contract synchronization- Delivered report for Apria cost changes for proactive communication- Delivered report for identification of items sold off pricing bid to aid in quick corrective action- Maintain monthly reporting to finance for Monthly/Quarterly Business ReviewsBusiness Performance:- Automated process for updating Extended Care Address Book and Catalog saving five hrs/week- Led Extended Care project team to refine process for customer matching and contract loading - Created productivity metrics for Extended Care rebate reconciliationCAMS:- Participated as the only Business Team Member on the CAMS Reporting effort and managed reporting stories through sprint planning and execution- Surveyed and worked with Contract Administration to identify list of reporting to be converted- Facilitated Contract Administration focus groups to verify reporting work and identify new reporting required by system changes- Successfully delivered 96% of report requests in 14 three-week sprints- Developed documentation and facilitated training for Business Objects reporting- Wrote test scripts and executed quality testing for report development- Rolled out 100% of non-contract related reporting to productionMMS GPO Admin Fee Project:Supported team in project plan and execution of project tasks- Obtained current SQL GPO fee code from business for evaluation and rewrote to support new methods of calculation- Extracted financial information for analysis with new calculationsTechnology Roadshow:- Supported design and planning to implement the Technology Roadshow- Presented Microsoft Excel benefits, training, and tips - Managed the idea submission and evaluation for the Technology Roadshow idea contest

Richardson, Texas

Coppell, Tx

- Managed 42 centrally paid vendors with 130 consolidated invoices- Performed analytical spend analysis on consolidated vendors on a weekly and monthly basis- Managed and developed invoice approval workflow in Microsoft SharePoint- Engaged in process improvement of processing invoices from receipt to payment- Documented standard desktop procedures for Accounts Payable Department- Developed and maintain productivity metrics- Assisted with various strategic projects and ad hoc reporting- Maintained department SharePoint website- Aided in training internal customers on researching A/P information in PeopleSoft Financial

Coppell, Tx

- Lead project to internally build an automated, online reporting tool for performance metrics- Reduced labor hours by 288 hours annually- Reduced the number of reports by 89%- Initiated research and analysis for build vs. buy for an automated reporting system- Developed performance metrics management tool using Microsoft Excel from ground up- Strategically assessed need to design and implement internal and external reporting solutions for performance metrics- Took assigned projects from original concept through final implementation- Worked directly with appropriate internal and external customers to understand project concepts and objectives- Accurately prepare routine reports for upper and regional management- Quarterly Cost Allocations to 200 Brink's branches- Billing for six customers across 67 Brink's Branches- Service Level Agreement Compliance for 29 customers across 125 branches and 5 lines of business- Document procedures and requirements for SLA, Billing, and Allocation report preparation- Assisted with customer support as needed- Assisted in project planning and developing project requirements for new national billing program- Aided in reconciliation process between four branches affected by Hurricane Katrina

Coppell, Tx

- Independently performed internal audits of inventory, processes and procedures- Aided GM in resolving non-compliance discovered in audits- Efficiently executed balance confirmations with customers for each audit- Encouraged and began implementation of paperless audit procedures- Provided insight and aided in large reconciliation projects due to poor implementation of Brink’s SOP

Grand Prairie, Tx

- Independently managed 2-day internal audits of inventory, cash, and file management of more than 80 stores- Aided RM and GM in resolving non-compliance discovered in audits- Compiled audit report for internal management and external investors- Trained new auditors on audit procedures- Assisted in store acquisition by converting lease agreements to SOP- Carried responsibility for personal travel accommodations and expense reports for every audit

Graduate Certificate, Data Mining And Business Intelligence

Mba, Strategic Leadership

Bs, Accounting

Activities and Societies: Alpha Phi Omega - National Service Fraterity, Alpha Kappa Psi - National Business Fraternity