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, PA05-1989
International Baccalaureate - Liberal Arts and Sciences
United World College of The American West
Montezuma, NM05-1985
Some College (No Degree) - Accounting, Liberal Arts, IT
Madison Area Technical College
Madison, WISome College (No Degree) - Economics, Project Management
University of Wisconsin - Madison
Madison, WISkills
- 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