Caro Smith Email & Phone Number

Greater Minneapolis-St. Paul Area

• Leads a staff of two Research Analysts in a department created based on my work automating data and reporting, saving the office more than 3000 hours of staff work a year and expanding data available for internal and.
• Directly supports the work of 16 other analysts and directors as well as staff and institutions outside my office.
• Implements new reporting and data visualization solutions resulting in expedited and expanded data access for stakeholders with significantly less work for staff.
• Creates and oversees training for office staff in SQL, Alteryx, Tableau, MS Office, Azure DevOps and others.
• Supports timely and accurate regulatory reporting to a variety of state and federal government departments.

Walden University

Database and data warehouse developer and administrator for Office of Institutional Research and Development. Created and maintained data reports and visualizations. Lead the office toward improvements in reporting as well as new ways of looking at information. Developed and conducted technical trainings (ex. VBA, SQL, Access, Tableau) and provides.

Wrote programs to automate reporting saving over 1700 hours of staff time a year. Designed, created and administers database and data warehouse to store student data, standardize cleaning processes and automate reporting, saving the department hundreds of hours and reducing errors. Tested, learned and implemented new software for the department..

Minneapolis, MN

Created new report format for quarterly student reports, improving experience for users and increasing usability. Oversaw university-wide graduation survey, including redesign of survey questions, administration, collection, analysis and presentation of results to executive leadership. Created and taught technical training courses in VBA and Excel for.

Conducted research and analyzed policy outcomes. Facilitated daily constituent services including handling sensitive or confidential information and coordinating with local and federal governmental and non-governmental agencies. Maintained knowledge of members’ district demographics, current events, policy areas and legislation.

Paid vendors and suppliers, automated processes to save hundreds of hours, maintained and ordered inventory for clinics, provided administrative support for medical staff, maintained confidential medical files and supervised two part time staff members

Researched and analyzed policy proposals affecting the city. Wrote weekly newsletter regarding issues at the legislature. Developed legislative tracking system for city officials. Developed presentations on policy issues and upcoming city projects for city, county and state staff and elected officials

Masters, Intelligence Studies

Master'S Degree, Public Policy

B.A., Political Science, History