Performs advanced PeopleSoft systems analysis and programming duties in the area of PeopleSoft Benefits and Pension Administration. Work involves doing extensive data research and work 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 item.
• 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.
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.
• 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.
• Must be capable of attaining and sustaining the cooperation of other personnel within the agency.
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.
Preferred
• Experience with PeopleSoft integration with other PeopleSoft and third party applications experience using web services
Never miss an opportunity! Create an alert based on the job you applied for.