Speaker "Joseph Frank" Details Back



Connecting Silos: How HR Analytics Helps Win More Business and Breaks Down Barriers


Over the past 10 years, the funding environment for medical research in the U.S. has become increasingly competitive. By leveraging existing data and unique analysis capabilities in the Human Resources office, a small team of senior leaders teamed with an HR data analyst set out to identify and advocate for organizational change. The question is: How do you build high-performance proposal development teams in a changing environment? While this work may not win a Nobel Prize nor cure Alzheimer's Disease, it will help scientists bring in more dollars towards life-saving research. This presentation is the culmination of a process of engagement between HR, senior managers, IT and Finance. This level of cooperation in developing analyses for focused decision-making helped lay the groundwork for process improvement. The data used for this project included grant and contract award data, compensation and benefits data, expenditure data, financial / accounting transaction data, and proposal development data. This wide variety of data inputs required significant data clean-up partly because each of the systems used to generate the data has its own quirks, as largely home-grown systems developed in-house or enhanced by in-house application developers. The focus is on the “local research administration” function of a large medical school. This function is the front-line in assistance to faculty.


Manager, Human Resources Reporting and Compliance Washington University in St. Louis Adjunct faculty member: Webster University; Fontbonne University; University of Missouri-St. Louis; and Washington University (University College). Education and Professional Certifications: • PhD, political science, Washington University in St. Louis • MA, political science, Washington University in St. Louis • BS, public policy administration, University of Missouri-St. Louis • BA, political science, University of Missouri-St. Louis • Certificate, non-profit management and leadership, University of Missouri-St. Louis • Certified Compensation Professional, WorldatWork • George Washington Certified Contracts Manager, George Washington University • Exchange Student, University of the Western Cape (Cape Town, South Africa) • HS diploma, Metro High School, St. Louis Public Schools I am an expert in the business and operations of higher education, healthcare, academic medicine, and urban government; with a focus on economic development in distressed urban communities. I also have interests (for later in my career, perhaps!) in meeting the challenges of building better urban systems: smart cities, sustainable cities, and resilient cities, particularly in sub-Saharan Africa; using Information and Communications Technologies for Development (ICT4D), and in monitoring and evaluation (M&E) of global development projects and programs. 19+ years'​ experience in management and operations of large, complex organizations across multiple sectors - health care, higher education, technology, economic development, retail, political campaigns, and government. • Experienced in database management and development, statistics, and business analytics. • User of platforms including Microsoft SQL Server, IBM Cognos, ArcGIS, SAS, Stata, and Tableau. • Experienced manager and advisor to senior management in complex, decentralized organizations. • Extensive statistical training in a social science PhD program focused on quantitative methods. • 15+ years' experience as a university instructor at multiple institutions, developing curricula and mentoring students in business, technology and the social sciences; in undergraduate, graduate, and continuing education programs. My current focus is on leading and growing a University-wide Human Resources analytics, reporting and compliance team (with my own emphasis on Medical School operational support). I am also involved in compensation analysis, with a particular focus on physician compensation. I provide data support for institutional research, mandatory government reporting, and strategic planning at the Medical Campus. I also support executive compensation reporting and salary budget analysis reporting to the compensation committee of the Board of Trustees.