 Application support for Student Payments, Financial Aid and Finance. SQL Migration Lead for Student Payments and Financial Aid. Coordinate migration of custom programing from Ellucian Colleague Voc paragraphs to SQL. Convert current Custom Colleague Programs that are not SQL compliant to SQL compliant programs. Communicate requirements to external vendors and evaluate options prior to contract deci-sions. Open calls with Ellucian to investigate system issues and or enhancement requests. Lead implementation of Self Service for students, faculty and staff. Convert reports from custom unidata to SQL. Lead upgrade of ImageNow for Financial Aid and Student Payments and Student Central. Lead implementation of ACI Payments and Payment Plan solution. Analyze delivered updates and send out testing plans and coordinate testing. Complete business process diagrams using Visio. Create Approval workflows for HR, Payroll, Budget, Purchasing, Financial Aid and Student Central in ImageNow. Create Reports for Finance, Financial Aid and Student payments using SSRS CROA and Informer. Ad hoc SQL reporting for Finance, Financial Aid, Student Payments, Payroll. Create export files for OSFA (Used for Reconciliation between the state system and Colleague) submission using SQL and advanced Excel skills to manipulate and merge multiple spread-sheets.

Make customizations to programming.Create Computed Columns.Create Complicated Reports using Business Objects Webi.Work with end users to resolve processing issues.

∞ Train end users to use their modules in Colleague.∞ Assist end users with reporting and analyzing their data.∞ Assist in testing of new Colleague releases and patches for modules which I support.∞ Create custom screens, modify Colleague Processes, create subroutines, and Computed Columns∞ Assisted with customization of the online Pay Advice.∞ Provide dedicated support for payroll.∞ Assisted with Year End processing including the printing of W2s.∞ Manage the Informer reporting solution, including training all users and maintaining accounts and files.∞ Project Manager for projects requiring IT resources. Projects include; Upgrade of the Colleague User Interface, Upgrade Informer to most current release, Colleague Payroll Implementation, Upgrade to Colleague Release 18, Create Reporting Users Group and Reporting web site, Colleague Advancement conversion, Informer implementation.

∞ Train end users to use their modules.∞ Assist end users in reporting and analyzing their data.∞ Assist in testing of new Colleague releases and patches for modules which I support.∞ Write programming to compare cost per student to student revenue to determine future cost of tuition.∞ Create custom VOCs and programming in Colleague for reporting, including VOCs.∞ Create I-Descriptors, custom screens and modified processes (Colleague).∞ Create subroutines and Computed Columns using the Envision Tool Kit.∞ Created the mapper specs to import data from JP Morgan Chase for Purchasing card program into the GL.∞ Customized the Pay stub to include data required by the college.∞ Performed the installation of check printing solution in Accounts Payable.∞ Provided 24/7 support for payroll.∞ Assisted with Year End processing including the printing of W2s.

∞ Processed tuition payments∞ Produced reports for management, financials and statistics.∞ Wrote I-Descriptors for the Vermont State College (VSC) programmers.∞ Sent Past due accounts to collections and brought in a new agency that would do skip traces on all accounts placed which resulted in bringing down the past due receivables in first three months. All of the Vermont State Colleges now use this same agency.∞ Assisted with the planning of the Student Services Center which brought the Accounts Receivable office, the Registrars office and Financial Aid Office together in one area for the convenience of the students.∞ Cross trained the staff in the new Student Services Area∞ Managed a staff of 4 peopleMember of the Accounts Receivable (AR) Team for the Vermont State Colleges. The AR Team met twice a month and worked to resolve AR/CR problems in the Vermont State College system.

∞ Supporting AR/CR, Human Resources, Payroll and Benefactor∞ Performed the below tasks via satellite from home in Middlebury Vermont from January 1999 until May 31, 2000.∞ Trained end users to use their modules.∞ Assisted end users in reporting and analyzing their data.∞ Assisted in testing of new Colleague releases and patches for modules which I support. Created custom VOCs in Colleague for reporting, including VOCs, which create an ASCII file for importing into a Word document or an Excel spreadsheet.∞ Created I-Descriptors (Colleague).∞ Investigate and resolve matters such as AR or Payroll not balancing to the General Ledger (Colleague).∞ Created Custom reports to balance AR to the GL for Monthly closing.∞ Created Custom reports for year-end closing and government reporting for HR, Payroll and Finance Office.∞ Created Custom reports for Benefits including Employee Benefit Statements.∞ Investigated and resolved issues with Cash Receipts (Colleague).

∞ Responsible for data entry and balancing reports to both the AS400 and the Colleague system at the time of the University's first Colleague conversion. All Billing and Cash Receipts had to be entered on both systems until they were in balance with the General Ledger.∞ Train staff on cash receipts, miscellaneous billing and refunds.∞ Performed both cash receipts and miscellaneous billing including balancing to the General Ledger∞ Designed instruction manuals for cash receipts, miscellaneous billing and refunds.∞ Gathered data and developed charts and graphs in Lotus and Excel for a number of reports used by the President, Board of Directors and the Annual Report.∞ Produced monthly newsletters for Student Services (Bursar & Registrar)∞ Bursars Liaison for the College Prep Program, which included keeping the participants informed of upcoming events, payment due dates, payment options including a payment plan that I administered. This position also required day-to-day updates and reports to the Vice President of Academic Affairs, which meant tracking payments and enrollment on a daily basis.∞ Processed tuition payments and worked with Students /Parents to set up payment plans.∞ Automated the monthly past due collections report in Lotus spreadsheets.