Resume

Kenneth "Rick" Cramer

Data Engineer

Senior Technical Consultant and Data Engineer with 8+ years of progressive experience spanning data engineering, analytics, ERP development, system integration, migration, and enterprise data systems. Deep SQL experience across PostgreSQL, SQL Server, and Oracle, complemented by Python, REST APIs, data modeling, ETL/ELT, validation, and automation.

Contact Me

Experience

Senior Technical Consultant

Data Platform & Analytics Engineering

Unanet

April 2023 - August 2026

Remote

Designed ETL pipelines and transformation processes for complex ERP migrations, conversions, integrations, and reporting solutions.
Developed large-scale SQL migration and transformation logic across PostgreSQL and SQL Server with validation, reconciliation, and data-integrity controls.
Reverse-engineered legacy schemas, application behavior, and business rules to design reliable target-system mappings and transformations.
Served as primary architect and engineer for Nessie, an automated analytics and data-quality platform supporting financial, project-performance, operational, and compliance use cases.
Built automation with SQL, Python, PowerShell, and REST APIs that saved hundreds of consultant hours annually.
Acted as a technical escalation point for complex migration, integration, customization, data, and analytics issues.

Business Data Analyst III

Liberty University

December 2021 - March 2023

Remote

Served as product owner for Centralist, a centralized marketing data application built with Oracle PL/SQL and Python on Ellucian Banner data.
Developed and optimized complex SQL and PL/SQL solutions across large relational datasets.
Designed data-processing and integration solutions connecting Banner with enterprise systems for reporting, marketing analytics, and business intelligence.
Translated business requirements into scalable technical solutions while serving as a technical liaison and mentor.

Business Data Analyst II

Liberty University

November 2019 - November 2021

Lynchburg, Virginia

Developed SQL-based reporting, extraction, and analytical solutions using Ellucian Banner and other enterprise data sources.
Designed reusable datasets and reporting logic for complex institutional data.
Performed query optimization, data validation, troubleshooting, and discrepancy analysis with technical and business stakeholders.

Business Data Analyst I

Liberty University

June 2018 - October 2019

Lynchburg, Virginia

Developed SQL reporting and data-extraction solutions using Ellucian Banner and related enterprise systems.
Performed data validation, reconciliation, troubleshooting, and technical documentation in an Oracle-based enterprise environment.

Senior Admissions Counselor

Liberty University

December 2015 - May 2018

Lynchburg, Virginia

Worked extensively with Ellucian Banner across admissions, financial-aid, and enrollment workflows.
Analyzed enrollment and performance data while serving as an informal data and systems resource for reporting and process improvement.

Admissions Counselor

Liberty University

September 2013 - November 2015

Lynchburg, Virginia

Used Ellucian Banner extensively to support admissions and enrollment operations.
Developed foundational experience with institutional data, validation, enterprise workflows, and process improvement.