General Description:
Performs advanced PeopleSoft systems analysis and programming duties in the area of PeopleSoft Benefits and Pension Administration. Work involves doing extensive data research and w ork on creating data mapping rules from PeopleSoft to the new
system. Work may also involve analyzing user requirements, procedures, and problems to automate processing or to enhance existing systems; systems integration; writing complex programs; and giving technical assistance to programming personnel.
Functional responsibilities:
Essential Functions:
- Performs highly advanced analysis and development of all ERS PeopleSoft applications and modules.
- Performs advanced data analysis and assists in doing extensive data research and create simple to complicated data mapping rules.
- Assists ETL developers, testers, business analysts and users in defining a data mapping rule and provides estimates for a work in team.
- Writes, tests, debugs complex PeopleSoft programs like SQR, Application Engine, PeopleCode, etc.,
- Designs and develops complex PeopleSoft Pages and Components.
- Experience with PeopleSoft XML Publisher reporting.
- Experience with PeopleSoft Integration tools and integrating PeopleSoft applications with third party applications using web services.
- Prepares detailed analyses, plans, diagrams and procedures within a technical design document for existing and proposed PeopleSoft applications.
- Determines the effort involved in implementing new systems or enhancements to existing systems due to changes in user requirements, legislative mandates, new software releases, changes in equipment configurations, etc.
- Suggests technical solutions to enhance business processing efficiency of existing and/or new processes.
- Demonstrates developed functionality to agency staff prior to the implementation of new or revised technical systems and offers advice and guidance during the implementation process.
- Attends work regularly in accordance with agency attendance policies.
- Complies with all applicable agency policies and procedures, including safety and standards of conduct.
- Performs on-call or scheduled after hours work as required.
- Performs other duties as assigned.
WORKER SKILLS AND QUALIFICATIONS
Minimum
Years
Skills/Experience
- Must have graduated from a four-year college or university with the last year of major coursework in data processing, computer science, business or a related field. Each year of related experience over the required minimum may be substituted for one year
(30 semester hours) of required college credit.
6+ years At least six years of experience with PeopleSoft PeopleTools development.
3+ years At least three years of PeopleSoft development experience with PeopleSoft Benefits Administration and Pension Administration.
3+ years At least three years of experience using SQL with an Oracle database.
3+ years At least three years of experience of writing SQR programs and PeopleSoft PeopleCode.
3+ years At least three years of experience of doing in-depth data analysis.
2+ years At least two years of experience with PeopleSoft Application Engine programming.
1+ year At least one year of PeopleSoft XML Publisher experience.
Knowledge, Skills and Abilities
- Knowledge of PeopleSoft Benefits Administration, Pension Administration, Base Benefits, core HR functionality to understand ERS benefits, and Financial systems, internally and externally.
- Considerable experience using SQL with an Oracle database, SQR programming, PeopleCode, Application Engine programs.
- Experience with PeopleSoft XML Publisher reporting.
- Experience with Web Services and integrating web services between PeopleSoft and third party applications is a plus.
- Ability to draw flow diagrams to show pictorially the new or existing processes.
- Ability to handle multiple projects at one time.
- Must be capable of attaining and sustaining the cooperation of other personnel within the agency.
- Skill in the use of computer equipment and in modifying programs for computer applications.
- Advanced ability to process information logically; to design programs and systems logically; to prepare program specifications; to code, test, and debug computer programs; to interpret technical information relating to PeopleSoft programming and other areas of data processing; and to perform mathematical calculations.
- Must be capable of conducting design review meetings and documenting the meeting minutes.
- Must have excellent written and verbal communication skills.