Who Am I?

Name: Rhiannon Wallace

Hello, I am Rhiannon! I am a dedicated professional currently pursuing a Master of Science in Information Systems at the University of Cincinnati. With a strong foundation in Business Administration, Finance, and Insurance & Risk Management from Bowling Green State University, I consistently demonstrate a commitment to excellence and continuous learning.

My diverse experience includes roles as an IT Internal Audit Intern at Behunin & Associates, where I enhanced audit processes and fostered client relationships, and as an Enterprise Risk Management Intern at The Hartford, where I developed automated data cleaning procedures. At Central Mutual Insurance, I streamlined data processes and automated regulatory reports, showcasing my expertise in data analytics and process automation.

My leadership and problem-solving skills were evident as a Certified Swing Shift Manager at McDonald’s. Along with being an active member of the Bearcat Bands and Tau Beta Sigma, I am proficient in SQL, Python, and data analytics, making me a versatile asset in any organization.

My LinkedIn Profile

Academic Background

University of Cincinnati, MS-IS, August 2024 - April 2026
  • Cumulative GPA: 4.0
  • Extracurriculars: Bearcat Marching Band, Bearcat Pep Band, and Tau Beta Sigma
Bowling Green State University, BSBA in Finance and Insurance & Risk Management, August 2020 - April 2024
  • Cumulative GPA: 3.973
  • Extracurriculars: Falcon Marching Band, Tau Beta Sigma, Gamma Iota Sigma, and Beta Gamma Sigma

Professional Background

Analytics Developer, American Modern Insurance Group, July 2025 - Present
  • Location: Cincinnati, OH
  • Designed and maintained Oracle SQL and PL/SQL workflows to support regulatory reporting for agencies, like ISO
  • Collaborated with cross-functional teams to translate insurance regulations into actionable analytics requirements
  • Engaged in continuous improvements to streamline reporting workflows to align with cloud modernization goals through the use of Azure DevOps and Databricks
  • Conducted ad hoc research to assess workflow adjustments as data infrastructure transitions to a cloud environment
Product Management Intern, American Modern Insurance Group, May 2025 - July 2025
  • Location: Cincinnati, OH
  • Leveraged IBM’s Cognos and Excel to conduct data analysis and performance reporting to assist in monitoring key metrics, identifying trends, and supporting data-driven decision-making
  • Gained a deep understanding of Odentrack and state regulation implementation across American Modern’s various product lines including Recreational and Residential products
  • Conducted research on GenAI use during the hiring process, including risks, mitigation strategies, and LLM testing
IT Audit Intern, Behunin & Associates, May 2024 - April 2025
  • Location: Philadelphia, PA
  • Assisted in IT audit projects, performing control testing and documenting findings to enhance compliance, utilizing Workiva and FieldGuide for efficient auditing
  • Collaborated with internal audit and IT departments to enhance audit processes, ensuring efficiency while applying Sarbanes-Oxley knowledge to ensure compliance and risk mitigation
  • Participated in client meetings to assess and align audit requirements, leading to tailored audit strategies and strengthening client trust through responsive solutions
Enterprise Risk Management Intern, The Hartford, May 2023 - August 2023
  • Location: Hartford, CT
  • Designed an automated data cleaning procedure for a small commercial portfolio using SQL, reducing processing time from 2 weeks to 3 days
  • Improved data accuracy and reliability by implementing automated error correction algorithms, achieving a 30% reduction in data inconsistencies across operational reports
  • Tailored automation processes to meet end-user needs, enhancing usability and reducing manual intervention through intuitive code design and workflow alignment
Enterprise Intelligence Intern, Central Mutual Insurance, May 2022 - August 2022
  • Location: Van Wert, OH
  • Streamlined data processes using SSMS, SQL, and Alteryx, enhancing efficiency and accuracy
  • Automated 3 critical regulatory reports using Alteryx, cutting preparation time from 4 hours to under 30 minutes, ensuring compliance and improving report precision
  • Engaged in a comprehensive insurance company simulation, acquiring practical knowledge in underwriting, claims handling, and ratemaking, which enhanced industry insight

Experience with R

My experience with R begins in the Summer of 2023. During my internship at The Hartford, my manager wanted me to try to connect my data cleaning procedure to a model already cretaed in R for a few other risks to see their impact across the globe. When trying to download and situate RStudio onto my work computer, IT was delaying the software for so long that it was decided I would not build this feature. Instead, I continued to refine other parts of the process in SQL.

I am very excited though to finally see the capabilities of this new tool after hearing so much about it from co-workers!

Experience with Other Analytic Software

SQL I have a lot of experience in SQL from many roles. Today, I commonly use PL/SQL, Oracle SQL Developer, and VS Code in my role as an Analytics Developer.

Python I have used Python in a few classes so far at UC, such as BANA 6043 and IS 8034. I find it a fun language to do for smaller side projects. I even used it at work to count the number of processes we would need to alter when Databricks is fully implemented at American Modern.

Other Software - C++, C#, Alteryx, KNIME, Databricks, HTML, CSS, and Java Script