• Build reporting datasets based on needs of institute or individual units using SQL Server/SSMS and MS Access to perform ETL functions with university and local data• Deliver reporting solutions via Tableau, MS Access, and MS Excel• Develop and maintain MS Access applications used by business office for various needs such as reporting, respondent payment processing and check writing, invoicing, proposal tracking/reporting, and other financial, personnel and respondent transaction monitoring• Design and develop pages to share institute-wide information via intranet• Gather university-wide administrative data for use in faculty research projects• Create interfaces via MS Access or MS Excel to interact with various systems such as timekeeping or bank sites• Involved in university's Diversity, Equity, and Inclusion initiative by participating as member of staff working group and collaborating with institute leadership on gathering and presentation of related data• Former chair and current member of cross-university committee tasked with gathering, prioritizing, and delivering metrics related to research administration• Design and develop content delivered on digital signage via Four Winds Interactive• Participant in BI networking groups that share best practices for data integration and visualization

• Gather requirements to define project vision and designs for operational and strategic reporting• Lead analyst tasked with using various reporting tools to validate data in university’s OLAP cube for use in university's web reporting system• Member of project team to introduce faculty/deans to new reporting system over the web• Worked with central finance office on project to de-centralize university’s journal entry process• Consult with administrators in 30+ schools and colleges by listening to their reporting, budgeting, and financial reconciliation needs• Analyze releases and fixes to PeopleSoft AR, Billing, and General Ledger modules• Coordinate technical and functional teams on enhancements to financials data warehouse• Instruct classes, labs, and webinars aimed at reaching out and training a variety of customers across three campuses• Provide second tier assistance on inquiries made through help desk

• Reconcile and withdraw funds for multiple federal Letter of Credit pools that fund a few to 3000 projects over $30 million per month • Leader of five person team to analyze, update, and consolidate 200+ BusinessObjects reports used to maintain integrity of research projects• Collaborated with functional and technical project team responsible for conversion of Legacy Accounts Receivable system to PeopleSoft AR/Billing• Interpret financial guidelines for various federal and non-federal sponsor research agreements• Aid research administrators in complying with sponsor requirements for 800+ projects• Investigate reconciling items for AR system having an average $38 million of monthly activity