1064 IS Prg Analyst-Principal

PeopleSoft Programmer

Recruitment #PEX-1064-075532


City Job Classification:  1064 IS Programmer Analyst - Principal
PeopleSoft Programmer 


Controller's Office Systems Division

The Systems Division of the Controller’s Office manages the City and County of San Francisco’s Enterprise Oracle and PeopleSoft Applications, which include Oracle Interaction Hub, PeopleSoft Human Capital Management (HCM), PeopleSoft Financials and Supply Chain Management (FSCM), PeopleSoft Enterprise Learning Management (ELM), and Oracle Business Intelligence.  These applications are branded locally as our SF Employee Portal, SF People & Pay, SF Financials, SF Procurement, SF Learning, and SF Reports and Analytics systems.  Collectively, these applications provide a robust, integrated platform that delivers mission-critical services to 55 City Departments, eliminating the need for hundreds of independent legacy systems and customized applications.  The division serves over 35,000 active City employees, 75,000 retirees and 25,000 City vendors (bidders and suppliers).  Peripheral and legacy applications also supported by the division include Cognos Business Intelligence, Informatica, Phire Architect and FreshWorks.  The technology implemented and maintained by the Systems Division provides standardization, transparency, and efficiency for the City’s crucial business processes.  Users are fully supported to ensure adoption of these interconnected functionalities. 

The PeopleSoft Programmer Analyst reports to the Technical Development Manager and is a part of the Technical Team of the Systems Division. 

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.  Research and repair program logic and systems, 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 screenflow 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.  


Minimum Qualifications

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 or equivalent foreign degree in computer science, computer engineering, computer information systems, management information systems or equivalent field from an accredited college or university.  AND
Five (5) years’ experience working with structure design techniques, including data models; writing technical design specifications for customizations, reports, interfaces or data conversation in a PeopleSoft environment; this experience must include all of the following:

  • Four (4) years’ 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’ 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) year’s technical design and development experience with Application Engine and Component Interface.
  • Integration experience between PeopleSoft Financials & Supply Chain (FSCM) and PeopleSoft Human Capital Management (HCM) using the delivered integration Broker Service Operations. 

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.

How To Apply

Applications for City and County of San Francisco jobs are only accepted through an online process. Visit www.jobaps.com/sf to register an account (if you have not already done so) and begin the application process.

  • Select the desired job announcement
  • Select “Apply” and read and acknowledge the information
  • Select either “I am a New User” if you have not previously registered, or “I have Registered Previously”
  • Follow instructions on the screen

Computers are available for the public (from 8:00 a.m. to 5:00 p.m. Monday through Friday) to file online applications in the lobby of the Dept. of Human Resources at 1 South Van Ness Avenue, 4th Floor, San Francisco.

Applicants may be contacted by email about this announcement and, therefore, it is their responsibility to ensure that their registered email address is accurate and kept up-to-date.  Also, applicants must ensure that email from CCSF is not blocked on their computer by a spam filter.  To prevent blocking, applicants should set up their email to accept CCSF mail from the following addresses (@sfgov.org, @sfdpw.org, @sfport.com, @flysfo.com, @sfwater.org, @sfdph.org, @asianart.org, @sfmta.com, @sfpl.org, @dcyf.org, @first5sf.org, @famsf.org, @ccsf.edu).

Applicants will receive a confirmation email that their online application has been received in response to every announcement for which they file.  Applicants should retain this confirmation email for their records.  Failure to receive this email means that the online application was not submitted or received.

All work experience, education, training and other information substantiating how you meet the minimum qualifications must be included on your application by the filing deadline.  Information submitted after the filing deadline will not be considered in determining whether you meet the minimum qualifications.

Applications completed improperly may be cause for ineligibility, disqualification or may lead to lower scores.

If you have any questions regarding this recruitment or application process, please contact the analyst, Vicente Centeno, by telephone at (415) 554-7506, or by email at Vicente.Centeno@sfgov.org


Selection Procedures

Only those candidates who most closely meet the needs of the Department will be invited to continue in the selection process.  Applicants who meet the minimum qualifications are not guaranteed to advance through all of the steps in the selection process. 

Verification:  Applicants will be required to submit verification of qualifying education and experience at any point during the recruitment and selection process. If education verification is required, information on how to verify education requirements, including verifying foreign education credits or degree equivalency, can be found at http://sfdhr.org/index.aspx?page=456Note: Falsifying one’s education, training, or work experience or attempted deception on the application may result in disqualification for this and future job opportunities with the City and County of San Francisco.

Conviction History

As a finalist 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 finalist. 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 applying 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 applying 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 selected as a finalist, the hiring department will contact you to schedule a fingerprinting appointment.

Disaster Service Workers

All City and County of San Francisco employees are designated Disaster Service Workers through state and local law (California Government Code Section 3100-3109). Employment with the City requires the affirmation of a loyalty oath to this effect. Employees are required to complete all Disaster Service Worker-related training as assigned, and to return to work as ordered in the event of an emergency.



Applicants with disabilities who meet the minimum eligibility requirements for this job announcement can find information on requesting a reasonable ADA Accommodation at:

General Information concerning City and County of San Francisco Employment Policies and Procedures: Important Employment Information for the City and County of San Francisco can be obtained at http://www.sfdhr.org/index.aspx?page=20 or hard copy at 1 South Van Ness Avenue, 4th Floor.

Copies of Application Documents: Applicants should keep copies of all documents submitted, as these will not be returned.

Right to Work: All persons entering the City and County of San Francisco workforce are required to provide verification of authorization to work in the United States.

Permanent-Exempt (PEX) Appointment:  This position is excluded by the Charter from the competitive civil service examination process and shall serve at the discretion of the appointing officer.

Recruitment Type: PEX
Issued: 12/21/2017
Micki Callahan

Human Resources Director
Department of Human Resources
Recruitment ID Number: PEX-1064-075532
CON/VC/(415) 554-7506


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.

For more information about benefits, please click here.


Powered by JobAps