Learn Data Skills
Beta
Matthew Rummel

Matthew Rummel

Certified

Stay-at-Home Dad | Colorado

Technologies

Matt is a problem solving go-getter.

My Work

Take a look at my latest work.

course

Introduction to SQL

SQL
course

Intermediate SQL

SQL
course

Joining Data in SQL

SQL
course

Introduction to SQL

SQL

My Certifications

These are the industry credentials that I’ve earned.

SQL Associate

SQL Associate

Data Literacy

Data Literacy

AI Fundamentals

AI Fundamentals

DataCamp Course Completion

Take a look at all the courses I’ve completed on DataCamp.

Courses

Introduction to SQL
Understanding Artificial Intelligence
Understanding ChatGPT
Intermediate SQL

My Work Experience

Where I've interned and worked during my career.

Colorado Christian University | Nov 2021 - Present

Director of Advancement Services

Reporting to the Vice President of University Advancement, manages the daily coordination, processing, and documentation of all donations received by the University. Is the primary administrative user for all Advancement software and systems. This includes a mastery of the Customer Relationship Management (CRM) database of Raiser’s Edge (RE). This CRM houses over 100,000 constituents to support the philanthropic efforts of the University. The Director of Data and Donor Services will be responsible for “clean” data within the database. This includes but is not limited to: merging duplicate records, identifying accurate contact information (mailing, email, phone, etc.), appending constituents to better identify philanthropic roadmaps, generating lists and queries, as well as adding other users. Provide statistical and analytical reports to be used by Senior Directors, University Cabinet Members, and University Board members to assist with University vision and mission. - Forecast department success strategies via data analytics - Manage Advancement donor database (Raiser’s Edge) and supporting software; including maintenance and improvement of gift systems and back- end workflows - Generate monthly, quarterly, and yearly (calendar/fiscal) reports for the University Cabinet to assist with University direction and budget; Comprehensive Advancement Report (CAR); Portfolio Health Reports (PHR) - Manage and track pledge intentions via installment dates and amounts - Generate dynamic dashboards used to direct department’s philanthropic focus; Contact Reports, Fund tracking, etc. - Manage gift processing; data entry of gifts (including cash, check, credit card, gift-in-kind, matching, pledges, IRA, and stock donations) - Direct/facilitate Advancement Staff meetings - Liaison with the State of Colorado in association with Enterprise Zone qualifying donations for tax certificates - Responsible for keeping entire department accountable with current priorities
Show More

Colorado Christian University | Mar 2018 - Nov 2021

Data Architect

The Advancement Data Architect will be responsible for the overall administration and integrity of data for the Advancement office, stewardship as it relates to receipts and thank you letters, and donor/financial/statistical reporting. - Responsible for Advancement donor database and supporting software to generate donor information. - Build, generate, and run queries, imports, benchmark and metric exports, and other reports as requested. - Leads the Advancement team's efforts through segmentation of constituents for solicitations and donor communications. - Provide donor/prospect research and analysis. - Create procedures, provide training, and establish access for new users and modules. - Receive and codes donations in preparation for processing. - Produce monthly Comprehensive Advancement Report (CAR). - Produce donor acknowledgments, tax receipts, Enterprise Tax Zone forms, and year-end giving statements. - Interact with Qualtrics for survey creation - Use Online Express to create/update University web giving pages - Attend and work University Advancement events.

Colorado Christian University | Aug 2018 - Dec 2020

Affiliate Professor

CIS 101: Business Applications in Technology Course Description: A look at the history and use of the personal computer, with an emphasis upon current Microsoft products including MS Office. Students will gain skills in word processing, spreadsheet management, database management, web design, and presentation graphics. An emphasis will be placed on the use of technology in Business. A mastery of the materials and skills taught in this course is essential for success in most of the other courses in the School of Business and Leadership because the tools taught in this course are used extensively in the other courses.

Colorado Christian University | Feb 2016 - May 2018

Operations Data Analyst

Perform technical data analysis to support the College of Undergraduate Students recruitment team at Colorado Christian University (CCU). This includes generating reports, digital/physical communications, analyzing reports, and other office tasks to assist CCU with its enrollment and retention goals. - Generate reports including funnel reports for Recruitment Team, Director of Admissions, VP of Student Life, Financial Aid Director, and CCU Cabinet members. - Provide/present technical report interpretation services to the recruitment team in the performance of their duties. - Refine the predictive recruitment model for Admissions by analyzing current patterns in each status of the recruitment cycle, alert issues, and make recommendations. - Create a yearly Annual Report consisting of all data, activity, and recruitment results with analysis for each recruitment territory. - Understand the processes of CCU’s CRM; Ellucian Recruit. This includes created dynamic views, updating records, creating events, importing (i.e. Records, test scores, high schools, events, etc.), work flows, dialogs, and queues. - Work directly with CCU’s Information Systems Management (IST) team and Web Team. - Assess current recruitment strategies by territory and state, and will assist in the development of an annual total inquiry development program including identifying key recruitment territories. - Directly manage third party outsourced relationships to prospect inquiries. - Manage departments composed of students (Call Team (6 members) and Operations (6 members)) to ensure productivity, call quality, results, and basic administrative skills.

Colorado Christian University | Aug 2017 - Dec 2017

Affiliate Professor

INT 101: First Year Integration Course Description: Think critically, grow spiritually, and change the world. Based on the premise that we as Christians are called to be rational creatures, relational creatures, and responsible creatures, FYI is an integrative study of foundational Christian principles with other disciplines. Examination and discussion of problems and contemporary issues - academic, personal, and social - facing students in their pursuit of success in college and life. Please see the First-Year Integration (FYI) page for specific information about this required course.

Colorado Christian University | Aug 2014 - Feb 2016

Dual Credit Representative

Responsible for the establishment and maintenance of relationships with administrators at high schools who are currently offering CCU's dual credit program and is the primary contact for establishing new relationships in eligible dual credit candidate schools within states located in CCU’s West and North territories (Alaska, Arizona, California, Idaho, Michigan, Minnesota, Montana, Nevada, North Dakota, Oregon, South Dakota, Utah, Washington, Wisconsin and Wyoming). A couple high schools that I partner with in my region include Northwest Christian High School (AZ) and Valley Christian High School (CA). - Maintain relationships and have consistent communication with current dual credit partner high schools. - Reliable direct contact with high school administrators and provide accurate information on the implementation of CCU’s dual credit program. - Market the dual credit program to Christian schools, public schools, and other non-profit entities within the western territory through the generation of leads and the cultivation of contacts and be responsible for the addition of new schools. - Effectively communicate the course application process to high school administration and teachers and provide support throughout the approval process. - Individually visit every dual credit high school within the western territory to explain the registration process and effectively communicate the benefits of dual credit to high school students and their parents. - Visit high school dual credit classes to maintain the integrity of the courses. - Work alongside CCU Enrollment Counselors in maintaining relationships with partner high schools. This includes attending partner school visits, college nights, and any other program offerings CCU hosts in partner high schools who have implemented the dual credit program or who are considering the program. - Significant travel to high schools throughout the western territory. Check the program out at: http://www.ccu.edu/dualcreditprogram/

Trulia | May 2014 - Aug 2014

Contractor - Data Cruncher

Working intensely to gear the organization for growth and that involves optimizing our sales engine. My role was to analyze, crunch, and otherwise reorganize the many data points which we collect continuously as part of our sales process. I worked closely with our Head of Sales to make sure our strategic sales decisions are based on solid insights and analytics, and was a key player in optimizing the way the organization used customer insights and past sales data to generate future revenue. I played a key role in assisting our Head of Sales in data-driven revenue optimization! Additionally, I worked on reviewing the performance of our sales team by monitoring the ongoing progress. This work involves a heavy amount of organization and analyzing multiple data points. - Managing/organizing/structuring workflow - Building live reports - Data gathering/analyzing in MS Excel - Communicating with cross functional departments - Identifying needs, gaps and inefficiencies in rep and management workflows - Strategic thinking and planning around raising agent sales productivity - Working with cross functional business partners - Managing to tight deadlines - Communicating updates and changes to Agent Sales - Basic understanding and ability to speak the lingo. Ex. Flexing communication style when working with Salesforce.com vs. Marketing vs. Training vs. Engineering - Building SalesForce.com reports, charts, views and dashboards for easy visibility for Directors, Managers and reps

TransUnion | Feb 2014 - Apr 2014

Contractor - Credit Retriever Integrations Analyst

As a Credit Retriever Integrations Analyst I focused on partner integrations by working with customers, partners, internal stakeholders, engineers and other product managers. I was responsible for building and maintaining integrations with various partners across the marketing ecosystem – all of which are crucial to the success of Transunion’s IDMP, MTA and Onboarding Solutions. - Manage the end -to-end process of integrating a partner into the Transunion platform - Develop and design data flows that align customer needs and requirements with products/services sold - Manage the collection and distribution of audience data to and form the TransUnion platform - Analyze current processes to stay up-to-date on best practices - Migrate and ensure quality of sensitive data within the TransUnion platform - Act as a liaison between internal teams and external partners - Create and maintain up-to-date project documentation and create new tools where appropriate

U.S. Department of Homeland Security | Jun 2013 - Jan 2014

Data Analyst II

In addition to the responsibilities of the Data Analyst I, the Data Analyst II was responsible for the training and development of Data Analyst I as well as data quality assurance for the entire team. Other responsibilities included compiling and disseminating report for FPS officers as well as Mega Center platform maintenance. - Upheld Company Quality Standards by Reviewing and Providing Feedback to Office Personnel on Work Products - Met and Often Exceeded Weekly/Monthly/Yearly Department Goals - Prepared Weekly/Quarterly Reports - Created Databases/Presentations - Handled Sensitive Materials for over 900 National Customers - Developed/Applied New Employee Training Manual - Mentored Junior Analysts

U.S. Department of Homeland Security | May 2012 - May 2013

Data Analyst I

The Data Analyst I was tasked to maintain accurate and up-to-date information connected with the Denver Mega Center's platforms. This included building information, alarm accounts, contacts, as well as system data. The Data Analyst I also created, modified , and deleted accounts and records with the the Denver Mage Center's systems as need. Training and support was provided to other Mega Center personnel on the use of the Mega Center systems so that recommendations for improving the platforms efficiency and effectiveness. - Compiling data from different databases - Analyzing information needed for databases - Documenting instructions/procedures - Updating digital and hard copy files - Preparing reports - Tracking/logging of information - Handling sensitive information - Prepare alarm activity reports - Assist Remote Programmer - Respond to general alarm or account inquiries - Maintains tracking and logging for activities performed - Contact Alarm Account Security Managers and emergency contacts for current information

Gilbert Christian Schools | Aug 2009 - May 2011

Middle School Mathematics Teacher

I worked directly with our youth to mentor them in having healthy interactions with each other as well as the world around them. I achieved this through social and interaction skills from the college level to the secondary educational level in the field of mathematics. While working with the generation of tomorrow, I have lead teams of students who have created social events for children who live in horrific living environments as well as directing activities involving alcohol awareness on a college campus. My recent profession in mathematics focused on teaching subjects from Pre-Algebra to Geometry. I taught Saxon Mathematics. My first year this ranged from Math 7/6 to Algebra 2, with one student in Statistics. The math program was set up in a independent study setting for the students. I changed this form of teaching my second year to a lecture base setting with direct instruction. I taught Pre- Algebra, Algebra 1, Geometry, and a little of Algebra 2. I believe that the change to direct instruction increased the students' retention.

My Education

Take a look at my formal education

Master of Education (M.Ed.), Secondary Education and TeachingGrand Canyon University | 2009
Liberal Arts, MathematicsGrand Canyon University | 2007
Minor, Athletic CoachingGrand Canyon University | 2007

About Me

Matthew Rummel

Matt is a problem solving go-getter. He enjoys learning new skills that will assist the results of his team, department, and organization. His drive to produce quality analytics through strategic and critical thinking would be a great addition to you

Powered by

  • Work
  • Certifications
  • Courses
  • Experience
  • Education
  • About Me
  • Create Your Data Portfolio for Free