1064 Peoplesoft Programmer Analyst
IS Prg Analyst-Principal
|Date Opened||4/5/2021 5:00:00 PM|
|Salary||$54.50 - $68.58/hour; $9,447.00 - $11,886.00/month; $113,360.00 - $142,636.00/year|
|Job Type||Permanent Exempt|
*ANNOUNCEMENT UPDATED 7/28/2021 TO REFLECT NEW CONDITION OF EMPLOYMENT*
CONDITION OF EMPLOYMENT: All City and County of San Francisco employees are required to be vaccinated against COVID-19 as a condition of employment. For details on how it is applicable to your employment, please click here.
Controller's Office Systems Division
The Controller's Office manages the following enterprise-wide systems for the City: PeopleSoft Financials & Supply Chain Management, PeopleSoft Human Capital Management, PeopleSoft Enterprise Learning Management, PeopleSoft Interaction Hub, Cognos Business Intelligence, and Informatica. For our PeopleSoft systems, we strive to keep updating to the latest version of the applications and People Tools.
The Controller’s Office is committed to enhancing and expanding application functionality to better support our users’ changing needs. Over the last 5-year period, we have launched new applications and products that have greatly increased and diversified our user base and amplified the need to improve how we assist our business partners to drive stakeholder value and desired business outcomes.
The PeopleSoft Principal Programmer Analyst reports to the Technical Development Lead and is a part of the Development Team of the Systems Division. The Controller’s Office is looking to fill one or two positions with this job posting.
Essential duties for this job include but are not limited to:
1. Provide assistance to staff in the analysis and determination of appropriate action to respond to service requests and problem reports; evaluate user service requests to determine and recommend the most appropriate solution which meets user business and application system requirements; coordinate scheduling between technical support staff and departments.
2. Plan, analyze, design and implement a variety of new systems establishing internal and external controls.
3. Review departmental work-flows, functions performed and procedures used; consult with departmental personnel to obtain information on existing systems procedures; develop proposals and plans for installing new or revised complex systems.
4. Design, code, test and debug programs and implementation of customizations including pages, menus, workflow, self-service components, batch jobs, reports and queries for PeopleSoft ERP based Citywide financial system and for special projects and interfaces; prepare final systems design and documentation necessary for programming.
5. Code and test data interface modules between internal and external systems using interface-appropriate communications tools like IB, application messages, web services, application engine and SQR. Conducts code reviews of own and peer work.
6. Analyze, research and repair program logic and systems; modify program logic; analyze service requests for system changes or new requirements; assist peers in diagnosing program failures.
7. Analyze and respond to service requests; determine the most cost-effective approach and the appropriate staff time required to achieve needed modifications; recommend appropriate solutions to meet user needs and project requirements.
8. Ensure program specifications are complete; produce basic components to ensure complete programming; review specifications submitted by vendors and users to ensure compatibility with current systems. Create technical design specifications and develops unit test plans documentation in support of complex programming work.
9. Assist users and other analysts in diagnosing complex program failures; develop recovery and backup procedures; detect, identify and correct software deficiencies.
10. Develop detailed specifications necessary to support applications programming. Review, develop, and apply technical design specifications; provide regular and accurate reports including progress updates on assigned tasks; ensure program specifications are complete; produce basic components such as program overview, listing of files, related programs and sub-programs, charts and screen flow diagrams, to ensure complete programming.
11. Analyze and resolve system problems; develop and implement solutions; resolve technical problems with end users in the implementation, maintenance and modification of complex application programs. Detect, identify, and correct software deficiencies, providing detailed research including trace files and components affected by PeopleSoft bug reports; creates data conversion development requests; provides comprehensive analysis and testing after application of maintenance packs.
12. Provide advice and consult with users regarding problems, special reports, revisions and enhancements to existing systems; provide progress reports on programming activities.
These minimum qualifications establish the education, training, experience, special skills and/or license(s) which are required for employment in the classification. Please note, additional qualifications (i.e., special conditions) may apply to a particular position and will be stated on the exam/job announcement.
An associate degree in computer science or closely related field from an accredited college or university OR its equivalent in terms of total course credits/units [i.e., at least sixty (60) semester or ninety (90) quarter credits/units with a minimum of twenty (20) semester or thirty (30) quarter credits/units in computer science or a closely-related field].
Five (5) years of experience in applications or software programming or development.
License and Certification:
Additional experience as described above may be substituted for the required degree on a year-for-year basis (up to a maximum of two (2) years). One (1) year is equivalent to thirty (30) semester units or forty-five (45) quarter units with a minimum of 10 semester / 15 quarter units in computer science or a closely related field.
- Five (5) years of experience working with structure design techniques, including data models; writing technical design specifications for enhancements, customizations, reports, interfaces, workflows, or data conversion in a PeopleSoft environment. This experience must include the following:
- Four (4) years of technical design and development experience with PeopleSoft Development Tools (PeopleTools 8.5x, Application Designer, PeopleCode, SQR, Process Scheduler and PeopleSoft Query);
- Four (4) years of experience writing complex SQL preferable on Oracle relational databases;
- Four (4) years of experience in PeopleSoft Financials & Supply Chain (FSCM) or PeopleSoft Human Capital Management (HCM) system and module functionality, fit/gap analysis, customization, and testing strategies;
- Two (2) years of experience working with structure design techniques, including data models; writing technical design specifications for customizations, reports, interfaces, or data conversion in a PeopleSoft environment
- Two (2) years of experience writing SQL on Oracle relational databases
- Two (2) years of technical design and development experience with Application Engine, Component Interface, Approval Workflow Engine (AWE), Application Packages and XML Publisher Reports;
- Integration experience between PeopleSoft Financials & Supply Chain (FSCM) and PeopleSoft Human Capital Management (HCM) using the delivered integration Broker Service Operations.
- Fluid development experience
- Experience with De-customization/ PeopleSoft new configurable features
- Experience with live production support of PeopleSoft FSCM or HCM Systems
- Ability to work independently and take ownership of assigned tasks
- Ability to troubleshoot, analyze and research PeopleSoft FSCM or HCM System related issues and problems
How To Apply
As a selected candidate for a job, you will be fingerprinted, and your fingerprints will be sent to the California Department of Justice (DOJ) and the Federal Bureau of Investigation (FBI). The resulting report of your conviction history (if any) will be used to determine whether the nature of your conviction (or arrest, in limited circumstances) conflicts with the specific duties and responsibilities of the job for which you are a selected candidate. If a conflict exists, you will be asked to present any evidence of rehabilitation that may mitigate the conflict, except when federal or state regulations bar employment in specific circumstances, such as:
- Candidates for positions with the Unified School District and the Community College District may be disqualified from consideration should their conviction history not meet the standards established under the California Education Code.
- Candidates for positions with the Recreation and Park Department may be disqualified from consideration should their conviction history not meet the standards established under California Public Resources Code 5164.
Having a conviction history does not automatically preclude you from a job with the City.
If you are a selected candidate, the hiring department will contact you to schedule a fingerprinting appointment.
Disaster Service Workers
All employees hired on or after January 10, 2009 will be required (pursuant to San Francisco Charter Section A8.432) to contribute 2% of pre-tax compensation to fund retiree healthcare. In addition, most employees are required to make a member contribution towards retirement, ranging from 7.5%-13.25% of compensation. For more information on these provisions, please contact the personnel office of the hiring agency.
Click on a link below to apply for this position:
|Fill out the Application NOW using the Internet.|