Kenneth "Rick" Cramer

Data Engineering & Migration

• Designed and maintained ETL pipelines and transformation processes supporting ERP migrations, data conversions, integrations, customizations, and reporting solutions across multiple client environments.
• Developed complex SQL transformation and migration logic across PostgreSQL and SQL Server to normalize, map, validate, reconcile, and curate legacy data for target ERP environments.
• Reverse-engineered undocumented legacy schemas, relationships, application behavior, and business rules to determine reliable target-system mappings and transformation strategies.
• Designed idempotent conversion and remediation processes that could be safely rerun while preserving data integrity and avoiding duplicate or unintended changes.
• Developed reusable migration and validation patterns to improve consistency and reduce implementation effort across customer engagements.

SQL, Analytics & Data Quality

• Designed scalable relational data models and analytics-ready datasets supporting financial reporting, project performance, compliance, operations, and business analysis.
• Built and optimized large-scale SQL transformation and analytical logic, including solutions exceeding 7,500 lines of SQL.
• Implemented validation, reconciliation, and data-integrity controls to identify mapping errors, transformation discrepancies, and production data issues.
• Performed query optimization, indexing analysis, schema investigation, metadata analysis, and production database troubleshooting.
• Developed reusable analytical logic and standardized data structures to reduce duplicated business logic across reporting and consulting workflows.

Integration & Automation

• Developed Python-based REST API integrations incorporating authentication, dynamic payload generation, JSON processing, response validation, error handling, and auditable logging.
• Built internal tooling and automation using SQL, Python, PowerShell, REST APIs, and platform-specific technologies.
• Processed and transformed JSON, XML, CSV, financial, purchasing, project, employee, vendor, billing, and operational data across enterprise systems.
• Created reusable diagnostic and automation workflows designed for repeatability and maintainability rather than one-time manual fixes.

Nessie Platform & Software Engineering

• Served as primary architect and engineer for Nessie, an internal analytics, reporting, diagnostic, and data-quality application used to automate recurring ERP consulting workflows.
• Developed and maintained Java backend functionality supporting analytics, diagnostics, validation, reporting, and reusable engineering processes.
• Generated structured JSON output that was consumed by a vanilla JavaScript frontend to render a static analytics site refreshed daily with current findings.
• Built an end-to-end data-quality workflow that surfaced issues and allowed users to generate preformatted remediation files compatible with Unanet import processes.
• Designed Nessie to support recurring financial, project-performance, operational, compliance, configuration, and data-quality analysis across customer environments.
• Integrated SQL, Java, JavaScript, JSON, Python, PowerShell, REST APIs, and reusable engineering tooling into a cohesive internal platform.
• Built automation and reusable analytical tooling that saved hundreds of consultant hours annually.
• Acted as a technical escalation point for complex migration, integration, customization, reporting, application, data, and analytics issues.
• Partnered directly with clients, consultants, developers, and business stakeholders to translate complex requirements and legacy-system behavior into maintainable technical solutions.

Centralist & Data Engineering

• Served as product owner and process owner for Centralist, Liberty University's centralized marketing list-generation application built primarily with Oracle PL/SQL and Python on Ellucian Banner data.
• Developed, optimized, debugged, and maintained complex SQL and PL/SQL supporting marketing audience segmentation and enterprise data processing.
• Analyzed Centralist's architecture and business logic to identify reliability, maintainability, performance, and data-quality improvements.
• Designed data-processing and integration solutions connecting Banner with other institutional systems and reporting processes.

Analytics & Technical Leadership

• Designed reusable analytical and reporting logic supporting marketing analytics, business intelligence, audience segmentation, and institutional reporting.
• Worked extensively with Oracle, Ellucian Banner, Python, Power BI, and DAX.
• Served as a technical liaison between business stakeholders, analysts, developers, and other technical teams.
• Contributed to shared development practices, technical documentation, reusable libraries, code review, and mentorship of junior analysts and developers.

• Developed SQL-based reporting, extraction, transformation, and analytical solutions using Ellucian Banner and other enterprise data sources.
• Designed analytics-ready datasets and reusable reporting logic supporting operational and leadership decision-making.
• Standardized business metrics and shared logic to improve consistency across departmental reporting.
• Performed query optimization, data validation, reconciliation, discrepancy analysis, and performance troubleshooting.
• Worked with enterprise data integration and virtualization technologies including DataVirtuality and Teiid.

• Developed SQL-based reporting and data-extraction solutions using Ellucian Banner and related enterprise systems.
• Supported business intelligence, data analysis, and institutional reporting initiatives.
• Performed data validation, reconciliation, troubleshooting, and technical documentation in an Oracle-based enterprise environment.
• Built the technical foundation in SQL, relational databases, enterprise data, and analytics that led to progressively more advanced engineering responsibilities.

• Worked extensively with Ellucian Banner across admissions, enrollment, financial-aid, and student-related business processes.
• Used advanced Excel techniques to clean, aggregate, analyze, and prepare enrollment and performance data for leadership reporting.
• Partnered with marketing analytics to analyze web traffic, conversion, and enrollment data.
• Served as an informal data and systems resource for coworkers while developing the enterprise-system expertise that later supported a transition into technical data roles.

• Used Ellucian Banner extensively to support prospective students through admissions and enrollment processes.
• Developed foundational expertise in institutional data, enterprise workflows, data validation, and process improvement.
• Maintained accurate student and enrollment information across enterprise systems and helped identify data discrepancies.
• Contributed to university website maintenance using HTML, CSS, and content-management tools.