Org Charting Software Tool to Enable Visualization of

Org Charting Software Tool to Enable Visualization of Current and Future Workforce so as to Facilitate a Timely Organizational Restructure HR Specialty Products & Services Catalogue Executive Summary A No Frills Distillation of Vendor’s Marketing Collateral Thomas A Ference President & CEO Human Resources Mining & Distribution Co Locating, Validating and Accelerating HR Innovation Office: 219 -662 -0201 Cell: 630 -240 -2583 Fax: 219 -661 -0236 e-mail: tference@hrmdco. com Website: www. hrmdco. com

Features and Benefits • Post M&A, determining the optimal surviving workforce can take months. Any currently-in-use charting software may lack desired functionality, accuracy and efficiency • This desk top application integrates with any and all HR files to auto-generate a visualization of the workforce and reporting structures. (A Visio compatible version is available) • A powerful auto-refresh feature updates revised org charts based on changes to underlying HR data files at any desired frequency • Modeling capabilities assess impacts on organization structure changes in terms of span of control, performance levels, training, experience levels, pay, bonuses, etc. • ”Interactive PDF’s” can be peeled off to allow for analysis at the business unit level • Tangentially helps to identify HR data files errors, gaps, overlaps and reporting anomalies that can be seen only via visualization

Visualization of HR and Workforce Data

Case Study – Post M&A Workforce Merger • A large internet search company (30, 000+ employees) acquired a cellular hardware manufacturer (24, 000+ employees) • A joint company team of business executives and HR analysts were tasked with developing a new organizational plan by identifying which employees to retain or not based on a set of established criteria. • Post vendor search, this technology was selected because of its ability to merge multiple HRIS data sources and visually work with the data. • Relevant data from Workday and People. Soft (e. g. job titles, performance ratings, compensation amounts, etc. ) were imported into this analytics and visualization tool to developed a set of heat maps, organizational charts and other views to determine the design and cost of the new organization. • The project was completed in only two weeks versus the typical time frame of ten weeks for completion of such work. • Merged HR data was automatically transferred to the surviving HRIS system

Workforce Merger Visualization - Examples

Next Steps • This product/service is contained in the HR Specialty Products & Services Catalogue™ • Operational level details about this particular service provider can be obtained in conference with the vendor • The HR Mining &Distribution Co. is an independent and contracted representative of the vendor • Upon your request, we will arrange for an introduction that can range from a simple, quick conference call to a services overview / system demo • Tom Ference 219 -662 -0201 (Chicagoland area) or tference@hrmdco. com • Thank you for your potential interest in this fresh thinking