Computer Services Homepage

Job Title: Programmer/Analyst II, Financial Assistance Office

Department: Academic Information Technology Services

Date: April 2006

Updated: February 2007

A. PURPOSE OF THE JOB:

Support the operations of the Student Information Systems (Banner and SIS) for the office of Financial Assistance and Enrollment Management at Texas A&M University – Corpus Christi.

B. DUTIES:

This is a programmer analyst position requiring a broad base of programming and technical skills.

1. Major Duty: Implement and Support the Student Information System (Banner) and
a. Convert data for Financial Aid, analyze the results, and fix the conversion issues,
b. Copy validation tables from one database instance to another,
c. Identify dependencies and constraints on validation table,
d. Write reports and Interfaces as needed, and
e. Other duties as required.
2. Major Duty: Support the Student Information System, SIS Plus, and:
a. Coordinate and schedule the automation of job requests, processing and applying of federal and state funds to student accounts, updating of the database,
b. Monitor nightly production processing results,
c. Write programs to support user request,
d. Prepare reports for: the reporting to state and federal agencies; statistical analysis and surveys; audit trails of funds and reconciling of funds,
e. Maintain and assist in the use of outside software applications (U.S. Dept Education and Texas Guaranteed Student Loan Corporation) that interfaces to Banner. Troubleshoot and fix user problems,
f. Coordinate, test, and implement software enhancements, regulatory updates, SIS+ updates. Maintain TAMU-CC customized software changes to SIS+ programs,
g. Coordinate, setup and test all financial aid production programs for each new school term,
h. Identify and resolve software problems,
i. Troubleshoot and fix user problems,
j. Document programs and procedures,
k. Act as liaison between the Computer Services Dept and customer to make sure all PC’s and related hardware are performing to maximum capability,
l. Train personnel as needed, and
m. Analyze other computing needs not handled by the SIS system and recommend and implement automated solutions.

C. KNOWLEDGE AND SKILLS:

1. Education required; Bachelor’s degree and two years work experience.
2. Skills required:
a. System Analysis and Software Development,
b. Report writing & Interface development,
c. Oracle software suite,
d. SQL/PL-SQL, Java, PHP, C/C++/C#, HTML, Shell Scripting, ProCOBOL?,
e. UNIX,
f. ERP Student Information Systems (Banner or equivalent), and
g. 3rd party SIS systems (Evisions, Degree Navigator, AppWorx?, AdAstra?, Touchnet).

D. FISCAL RESPONSIBILITY:

N/A

E. APPLICATION OF KNOWLEDGE AND SKILLS:

1. Implements, converts, and customizes ERP software specific to higher education,
2. Consults with clients to gather information about program needs, objectives, functions, features, and input and output requirements,
3. Analyzes, defines, and documents requirements for administrative system software,
4. Writes and maintains functional and technical specifications,
5. Develops and maintains plans outlining steps and timetables for developing programs,
6. Research and evaluate software and hardware to assist in programming or to use as program platforms,
7. Customizes and codes screen layouts, graphical user interfaces, printed outputs, and interfaces with other systems,
8. Converts designs and specifications into computer code, and compiles code into programs and corrects errors detected in compile process,
9. Creates test transactions and runs tests to find errors and confirm programs meet specifications,
10. Analyzes code to find causes of errors and revises programs. Consults with client to prototype, refine, test, and debug programs to meet needs,
11. Writes and maintains documentation to describe program development, logic, coding, testing, changes, and corrections,
12. Provides technical assistance by responding to inquiries from others regarding errors, problems, or questions about programs, and
13. Train end users or technical support staff to use programs. Monitor performance of programs after implementation.

F. SUPERVISION:

N/A

G. EXTENT OF PUBLIC CONTACT:

Interact with members of the university community and other external individuals as needed to support the customer.

1. Daily contact with customers within the Financial Assistance office,
2. Contact with university academic offices in support of the student information system and 3rd Party supported systems as well as Banner project, and
3. Contact with other university offices as required.