Applications Development Analyst V

at  Long Beach City College

KNOWLEDGE OF:

1. Extensive database design and/or data warehousing background in Microsoft SQL Server or Oracle.
2. SQL and use of SQL Plus or Query Analyzer.
3. Software development life cycle/methodology.
4. System design and development as well as production support of PeopleSoft systems.
5. Windows clients and NT server versions.
6. Complex data base management techniques.
7. Application Messaging, PeopleCode, PeopleGTools, Crystal Reports, SQR, NVision, COBOL, App Engine, Change Assistant, Workflow Administration.

EDUCATION, TRAINING AND EXPERIENCE:

A typical way of obtaining the knowledge, skills and abilities outlined above is graduation from a four-year college or university with major coursework in Business, Computer Science, Information Technology or elated field plus course work in project management or administration and a minimum of five (5) years hands-on work experience on PeopleSoft Student (version 8.0 or greater) systems, preferably in the Higher Education product line or an equivalent combination of education and experience. PeopleSoft Financial product version 8+ and business processes and additional training in management and technical areas is required.

LICENSES; CERTIFICATES; SPECIAL REQUIREMENTS:

A valid California driver’s license and ability to maintain insurability under the District’s Vehicle Insurance Policy may be required for certain assignments.

GENERAL PURPOSE

Under the direction of the Director, Applications Development and Support, provide senior level technical/functional production support for PeopleSoft Student and Financials Systems which also includes cross training of staff. This also involves troubleshooting and solving production issues, aiding the functional staff in utilizing the system more efficiently and providing technical support for upgrades, modifications or reporting needs from campus users. This position will work as an integrative team member with both technical and functional staff and also be key resource in providing the analysis and delivery of the data from the data warehouse.

ESSENTIAL DUTIES AND RESPONSIBILITIES

The duties listed below are intended only as illustrations of the various types of work that may be performed. The omission of specific statements of duties does not exclude them from the position if the work is similar, related or a logical assignment to this class.
1. Troubleshoot Student and Financials Systems production issues, resolve PeopleSoft trouble tickets, and provide functional/technical training as needed to staff.
2. Determine enhanced system features desired, reports needed, and scope effort. Responsible for keeping up-to-date on upcoming features in new releases as well as designing means to incorporate these features into the campus system.
3. Research and provide functional/technical campus solutions to areas within Student Administration and financials which need improvement. Direct the application functional staff and technical staff to provide new features fit/gap analysis, specification preparation, development, testing and preparation of time/cost estimates for proposed customizations and project activity.
4. Provide system design, analysis with portal, data warehouse, and additional self service features available in PeopleSoft. Ensure data quality for all campus reporting via MIS report needs.
5. Track PeopleSoft delivered changes made to Student Administration and Financials products and helping user verify the updates/fixes and bundle releases. Assist user with testing, test cases, and test approach.
6. Responsible for reporting of PeopleSoft reported tickets and resolution into campus Production system. Monitor HEUG (Higher Education User Group) reported PeopleSoft issues and identifying applicable ones for campus implementation.
7. Create and support change control and security standards. Provide system, operational, technical documentation as needed. Impart knowledge to other staff. Work as a tem member with DBA, Network, Web, Business Analysts and other application managers to support PeopleSoft applications and systems.
8. Perform related duties as required.