Service Sql

William E. Pendleton

*** ******** ****

Laurel Fork VA 24352

Phone 276-***-**** (H)

Email: ********@*****.***

Summary

• 10+ years Student Records experience in Higher Education environment

• 5+ Years SCT/SunGard Banner Student Records, including the WFU conversion from SRN to Banner

• Primary support for 5 registrars, Athletics, Institutional Research, Office of International Studies, and the Dean’s office

• Deep understanding of SunGard Banner Admissions, Recruiting, Student and AR modules technically and functionally

• Excellent programming skills in Oracle SQL*Plus, PL/SQL

• Shell scripting experience

• Deep understanding of Banner architecture.

• Lead for Banner Student record conversion and Banner 7.0 conversion

• Developer for several applications and interfaces for student registration and self-service

Work Profile

Banner Technical Consultant

N2N Services Inc.

Duluth GA 20097

(March 2008 –Mar 2012)

• Supporting N2N clients (Northeastern University, University of Scranton, North Carolina Central University and Atlanta Technical College) with Banner Student technical, conversion, and other issues

• Helped with Student Conversion and conversion related problems

• Assisted NEU and University of Scranton for Banner 8 upgrade.

o UTF-8 conversion

o Pro*C script migration to fit new character set

• Developed several interfaces

o T2 Interface – Interface from Banner to T2 Parking Management System and vice-versa. Used SQL, PLSQL and Shell scripting to build the interface

o DARS interface – Implemented an interface from Banner to DARS (Degree Audit System). Used extensive SQL, PLSQL programming for this interface

o RMS to Banner – implemented RMS (Housing System) to Banner Location Management interface. This interface includes

Housing Assignments Transfer

Housing Charges Transfer

Meal Plan Assignments Transfer

Address Transfer

o Banner to Gold (ID card system) – Lead developer to transfer the following information from Banner to CS Gold system

Patron Data (Biographic Demographic data)

Enrollment information

Meal Plan information

Housing information

o Wrote several custom Oracle forms to support in-house enhancements to Banner system using Banner INB architecture

Pattern of Attendance form

Advising form

Custom Interface process form

o Wrote several custom Self-Service pages to support enhancements and needs of NCCU, NEU and other N2N customers

Book Allowance Transfer Page

Meal Plan Request Page

Advisor Lookup and Over-ride page

Custom modifications to the Student Information page

o Wrote several custom PL/SQL jobs that can be run from Banner job submission to perform reporting and data manipulation by users from Banner INB

Academic Exoneration Application

Custom Repeat Class Processors

Student Registration Over-rides

Student A/R reports

• Developed sql and plsql scripts for reports, auditing data, etc

• Created custom self-service pages for book allowance requests and meal plans requests

• Created custom forms, jobs and scripts to support University needs

• Helped the Undergraduate and Graduate teams with Degree Evaluation process

• Troubleshoot registration and Banner student processes for N2N clients

Programmer/Analyst

Wake Forest University,

Winston-Salem NC 27109

(Sept 1998-March 2008)

• Y2K consultant. Identified and corrected Y2K problems in Cobol and Powerhouse (Quiz, QTP, Quad) reports and processors for all modules.

• Primary Student Record support for WFU Registrars and offices, including all processes, processors, and reporting needs, including Athletics (NCAA Compliance), NCHED, NSLC, IPEDS, and Institutional Research for the WFU Fact Book

• Streamlining and automating office procedures for Undergraduate and Graduate Registrar offices

• Designed and developed the WFU Law School Anonymous Grading process

• Designed and developed Law school weighted GPA process

• Designed and developed UG Time-ticketing process using SQL and PL/SQL in Banner

• Designed and developed Law School Transcript using Evisions Formsfusion

• Helped the Undergraduate and Graduate teams with Degree Evaluation process

• Designed and developed FERPA compliance processes

• Developed WFU Online Transcript and automated Processor (including addressed envelopes for mailing)

• Project lead for conversion from 144 Credits/112 Hours to 120 Hours

• Led data extraction and fitting of Legacy student data conversion to Banner

• Developed and automated extensive data integrity audits for student module

• Designed Data integrity checks and process using Banner job submission and reports

• Assist and help train Registrar’s staff on all SRN problems.

• Designed and Developed Banner interfaces to BlackBoard, StudioAbroad, Diplomas on Demand, and Pyramed,

• Supporting the Banner to Remedy interface

• Supporting Banner Student Records

Scientific Equipment Design

McAllister Technical Services, Couer d’Alene ID (May 1997-April 1998)

• Design of UHV STM (Ultra High Vaccum Scanning Tunneling Microscope) for a National Lab

Physics Instructor (January 1997-May 1997)

North Carolina Agricultural and Technical University, Greensboro NC

• General Physics Instructor for 157 students

Programming Languages and Skills:

• SQL Plus, PL/SQL, Pro*C, Linux scripting

• Oracle 9i, 10g, and 11 databases

• RMS, Nolij Transfer, Blackboard, Remedy, Studio Abroad

• Korn Shell and C Shell

• Banner Job Submission, Self-Service

Educational Qualifications:

Bachelor of Science in Physics from NCA&T, Greensboro NC (May 1990).

PHD Candidate in Physics at Wake Forest University, Winston-Salem NC (Sept 1990-January 1997)

Contact this candidate