Summary
Overview
Work History
Education
Skills
Timeline
Generic

Rona McNeil

Madison,WI

Summary

Experienced Data Architect proficient in data management, data analysis, and end to end solution design. Skilled in process improvement and effective communication. Committed to delivering innovative data solutions to transform operational data into accessible information.

Overview

36
36
years of professional experience

Work History

In Person Absentee Voting Clerk

City of Madison
MADISON, WI
10.2024 - 04.2025
  • Processed voter registrations and maintained accurate records for compliance.
  • Assisted in setup and management of polling stations to ensure smooth operations.
  • Provided voters with information regarding election procedures and requirements.
  • Verified voter identification and eligibility at polling locations to uphold integrity.

Data Architect

Madison Area Technical College
Madison, WI
10.1998 - 06.2024
  • Other titles: State Enrollment Reporting & Institutional Research Specialist; Enterprise Systems Project Leader; Business Intelligence/Data Engineer
  • Designed data models to support academic programs and administrative functions.
  • Collaborated with IT teams and subject matter experts to integrate systems and enhance data accessibility.
  • Collaborated extensively with management, staff, and faculty throughout the college to solve problems, answer business questions, and make planning decisions.
  • Developed data governance policies to ensure compliance and data integrity.
  • Analyzed user requirements to create effective database and software solutions for student, staff, and faculty needs.
  • Designed, developed, implemented and managed ETL processes for data extraction and transformation.
  • Evaluated emerging technologies to improve and align data architecture strategies to match the college's roadmap.
  • Documented system workflows and architectural designs for future reference and training.
  • Designed and implemented security for applications, data, software, and reporting environment.
  • Developed and managed enterprise-wide data analytics application environment, processes, and models - Cognos Analytics.
  • Created and implemented complex business intelligence solutions.
  • Collected, outlined and refined requirements, led design processes and oversaw project progress.
  • Assisted in developing a roadmap for data migration from legacy systems to new systems.
  • Trained non-technical users and answered technical support questions.
  • Regulatory reporting lead developer and coordinator
  • Cognos developer, PeopleSoft developer, SQL Server developer

Research Analyst

Department of Vocational Rehabilitation/DWD
Madison, WI
12.1996 - 10.1998
  • Analyzed data trends to improve service delivery and client outcomes.
  • Collaborated with stakeholders to assess program effectiveness and client needs.
  • Provided expertise in data management systems for tracking program performance.
  • Analyzed complex datasets utilizing advanced analytics techniques.
  • Produced reports, surveys, and research projects for internal staff, department administration, oversight council, legislature, and federal government.
  • Developed and maintained data systems necessary to meet federal and state regulatory requirements.

Management Information Specialist

Division of Information Technology - UW Madison
Madison, WI
09.1991 - 12.1996
  • Microcomputer Consultant (1991-1993): Technical help desk support responsibilities (phone and in person) for student, staff ,and faculty on PC software and hardware issues .
  • Program Assistant (1994-1996): Provided advice and assistance to students,staff, and faculty interested in purchasing computer software and hardware through the DoIT educational discount programs. Built and maintained software sales database for operational reporting, decision making, and planning.
  • WiscWorld Internet services (1995-1996)
  • Coordinated the production, distribution, and support of the Wiscworld internet product to students, staff, faculty, and public subscribers.
  • Planning and budget reporting.
  • Developed data system to monitor sales, usage, and expenditures.
  • Built and maintained the website.

Seasonal WI Income Tax Processing

Wisconsin Dept of Revenue
MADISON, WI
02.1994 - 05.1994
  • Review Wisconsin income tax returns for accuracy, compliance, and completeness.

Research Assistant

Board of Governors of the Federal Reserver System
Washington, DC
06.1989 - 08.1991
  • Assisted Federal Economists in preparing reports, studies, briefings, and presentations for Congress, Public, Chairman Greenspan, FOMC Committee, and internal staff.
  • Developed and maintained large data systems to support research and evaluation of economic trends.

Education

Bachelor of Arts - Economics

Bryn Mawr College
Bryn Mawr, PA
05-1989

International Baccalaureate - Liberal Arts and Sciences

United World College of The American West
Montezuma, NM
05-1985

Some College (No Degree) - Accounting, Liberal Arts, IT

Madison Area Technical College
Madison, WI

Some College (No Degree) - Economics, Project Management

University of Wisconsin - Madison
Madison, WI

Skills

  • Data Management
  • Data Analysis
  • Regulatory Reporting
  • Project Management
  • Requirements
  • Problem Solving
  • Process Improvement
  • SQL/ETL/Software Development
  • Stakeholder collaboration
  • Effective communication

Timeline

In Person Absentee Voting Clerk

City of Madison
10.2024 - 04.2025

Data Architect

Madison Area Technical College
10.1998 - 06.2024

Research Analyst

Department of Vocational Rehabilitation/DWD
12.1996 - 10.1998

Seasonal WI Income Tax Processing

Wisconsin Dept of Revenue
02.1994 - 05.1994

Management Information Specialist

Division of Information Technology - UW Madison
09.1991 - 12.1996

Research Assistant

Board of Governors of the Federal Reserver System
06.1989 - 08.1991

Bachelor of Arts - Economics

Bryn Mawr College

International Baccalaureate - Liberal Arts and Sciences

United World College of The American West

Some College (No Degree) - Accounting, Liberal Arts, IT

Madison Area Technical College

Some College (No Degree) - Economics, Project Management

University of Wisconsin - Madison