Elizabeth Marie Crawley

Projects

Portrait of Elizabeth M. Crawley

Selected case studies from higher-ed operations, analytics, and process automation. (All examples are summarized and de-identified.)

Case Studies

Screenshot mock-up of a churn dashboard with Top 10 Predictors of Churn(Random Forest)

Customer Churn Prediction (ABC Wireless)

Built and compared predictive models to identify at-risk customers and target retention offers.

Stack
R (tidyverse, caret), ggplot2
Role
Modeling, feature engineering, evaluation
Outcome
Lifted precision for top decile by 22%; delivered actionable retention segments.
  • Logistic regression vs. random forest with cross-validation.
  • Calibration and ROC analysis; business-friendly thresholds.
  • Reproducible report with visuals and recommendations.

Case Study

ABC Wireless – Churn Presentation

Workflow diagram mock-up showing form stages and approvals

Dynamic Forms SOP & Workflow Library (KSU)

Standardized NextGen Dynamic Forms processes to speed up packaging and reduce errors.

Stack
NextGen Dynamic Forms, Banner 9 (Oracle)
Role
System design, documentation, training
Outcome
Cut onboarding time for staff; improved data quality and audit readiness.
  • Reusable patterns for approvals, routing, and validations.
  • Clear SOPs with screenshots; versioned updates.
  • Alignments with FERPA and institutional security policy.

Read SOP Excerpt

Systems Request Form

Cognos report mock-up demonstrating aggregated values and filters

Compliance & Packaging Reports

Revamped Oracle SQL and Cognos reports for Pell, SEOG, OCOG, and TEACH programs.

Stack
Oracle SQL, Cognos, Banner 9
Role
Report authoring, query optimization
Outcome
Faster run times, consistent outputs, and less manual reconciliation.
  • Query tuning with indexes, CTEs, and explain plans.
  • Parameterized reports for staff workflows.
  • Documentation for reproducibility and handoffs.
Screenshot of Ellucian Banner query I wrote for automated batch posting and population selection output

Automated Batch Posting, AppXtender Integration & GLRSLCT Selections

Built Banner 9 population and variable definitions as well as writing out steps used in automations for nightly batch posting and downstream processes, integrated with AppXtender, and used the defined selections for automatic document merging and selecting targeted communications.

Stack
Oracle SQL, Ellucian Banner 9, AppXtender, IBM Cognos
Role
Design & implementation of batch jobs, data flows, and letter generation; SOPs & handoffs
Outcome
Faster postings, fewer manual steps, traceable document indexing, and consistent letter output.
  • Designed and tuned Banner 9 population selection used by scheduled jobs for **automated batch posting** and import/export processes.
  • Integrated with **Xtender** for output indexing/attachments tied to import/export and transaction records.
  • Leveraged **GLRSLCT** population selections for letter creation and targeted outreach.
Students programming a robot at a table

Robotics Mentorship (FLL/FTC)

Curriculum and mentoring for robotics teams—coding, sensors, and teamwork.

Stack
Python, EV3/FTC toolchains
Role
Coach, curriculum designer
Outcome
Student projects showcased at competitions; increased participation.
  • Hands-on challenges tied to core STEM concepts.
  • Version control basics and documentation habits.
  • Inclusive team norms and peer review.

Python Programming Introduction (Video)

Watch on YouTube