This is a position on the Controller’s Financial Systems and Reporting Team of the Controller’s Office.   Under direction of the Payroll Systems Manager, this position provides functional and technical support for GEAC, the City’s mainframe (Cobol) Payroll System and Time Entry System (TESS), a rule based, client server system.  TESS is a front end to GEAC. We are seeking an individual who can work with the Payroll and Personal Services Division users to define business/system requirements and perform technical development and administrative duties for these systems.  This position must have thorough knowledge of relational databases and SQL language and experience with application development methodology.  The Controller’s Financial Systems and Reporting Team which supports all systems for the Controller’s Office.  Employee must be willing to work a 40-hour week as determined by the department.  Overtime work may be required. 

This position may also participate in the City’s new integrated Human Resources Information System which is a multi-agency, long term project to replace all the City’s Personnel and Payroll Systems including GEAC.

Essential duties of the job included, but are not limited to:

• Experience interfacing with end users to capture business requirements and translating these requirements to system specifications and design, developing test case scenarios and testing insuring quality work product;  
• Develop and maintain a thorough knowledge of all Time Entry System (TESS) and HR:M payroll systems;
• Develop specialized queries and use other database tools to maintain TESS data and provide information to management;  
• Working knowledge of SQL, and relational databases such as Microsoft (SQL & ACCES) and Oracle;  
• Run imports to and exports from the database as needed.  As well developing specifications for interfaces from third party and to third party insuring that data is transported in a secure environment;
• Evaluate the need for developing new systems and front ends, and make recommendations to the management team;
• Manage application and systems implementation of federal and state payroll requirements and tax laws, local ordinances, and Memoranda of Understanding pertaining to all employee pay and benefits in a timely manner;  
• Analyze contracts to identify payroll-related provisions and document them for assessment of TESS and payroll systems rule needs;  
• Assist client and users to follow up on problems and resolve them before implementation including production problems;  
• Prepare service requests and support documentation to implement system changes and new version implementation and coordination with PPSD managers;  
• Analyze the feasibility of and develop requirements for new systems and enhancements to existing systems; ensure the system design fits the needs of the users; 
• Effectively managing the stress of last minute projects so that others are not negatively impacted; 
• Perform other duties as assigned.

1.  Possession of a baccalaureate degree from an accredited college or university; AND

2. Three (3) years experience performing systems analysis and support for large, complex Payroll systems OR two years experience providing reporting system support and training on HRIS such as GEAC mainframe and SQL based applications. Must include experience with defining user requirements, acceptance testing, implementation support, report definition and specification, troubleshooting and problem resolution.

Additional Qualifications : This position also requires verifiable and recent senior level experience in database modeling and design of MS Access, SQL Server, and other relational databases, and specifying and developing financial reports using report-writing software.

Desirable Qualifications:

1.  Design and maintenance of SQL based applications and mainframe applications using tools necessary to extract data from databases and knowledge of COBOL, JCL, TSO and CICS;   Demonstrated strong analytical, planning and organizational skills and abilities; 
2.  Strong oral and written communication skills;
3.  Ability to coordinate multiple tasks and competing priorities;
4.  Ability to effectively interact with internal and external City personnel and outside vendors and contractors;  
5.  Experience with database, data warehousing and report writing tools (Oracle, SQL, VSAM);   Intermediate or advanced skill using office automation tools (Microsoft Office suite or equivalent); 
6.  Knowledge of governmental payroll, database development, and mainframe legacy systems and the City’s Payroll policies and procedures highly preferred. 

How To Apply:       

Applications must be filed through the online process (see instructions below).  Computer kiosks are located in the lobby of the Department of Human Resources, 1 South Van Ness, San Francisco, for use by the public to file a City job application (if no other internet link is accessible).  The hours of operation are from 8:00 a.m. to 5:00 p.m. Monday through Friday. 

• Visit https://www.jobaps.com/sf/sup/images/default.asp to begin the application process
• Click and select PEX-1053-055560
• Click on “Apply”, read the instructions and "agree to the terms of use"  
• Click on “I am a New User” if you have not previously registered, or on “I have Registered Previously”
• Follow the instructions given on the screen

Please include an updated resume with a list of three professional references and detailed cover letter specifically indicating how you meet each of the additional and desirable qualifications as stated above (note that this is a critical part of the application evaluation process).  You will be able to attach these documents when completing the online application).  If you have any questions regarding this application process, please contact the analyst Mirna Palma at (415) 554-7530, email: mirna.palma@sfgov.org  

Selection Process:

The selection process will include an evaluation of applications and an assessment of candidates’ relative job-related knowledge, skills and abilities by oral interview.  Written and performance exercises may be included.  Only those applicants who most closely meet the needs of the Department will be invited to participate in the selection process.  Applicants meeting the minimum qualifications are not guaranteed advancement to the interview.

Verification:  

1.  Verification of the education and experience may be required at any point in the selection process.  Failure to submit verification documentation, if requested, may result in rejection of application or ineligibility for employment.

2.  All statements made on the application or subsequent documents required under this examination are subject to verification

General Notes:

1.  Applicants with disabilities requiring reasonable accommodation must contact the analyst by phone (415) 554-7506 (voice) or by email (specify class 1053 IS Business Analyst-Senior) at mirna.palma@sfgov.org as soon as possible.

2.  1986 federal regulation requires verification of employment eligibility.  Candidates who are offered employment with City and County of San Francisco, must be able to provide proof or employment eligibility by providing original permanent employment eligibility documents.
3.  Per CSC Rule 114, Article VIII, Sec. 114.44:  "Any person occupying a position under exempt appointment shall not be subject to civil service selection, appointment, and removal procedures and shall serve at the pleasure of the appointing officer."

Micki Callahan, Human Resources Director

Department of Human Resources

Announcement#: 055430

Issued:  May 22, 2009

Team: CON/MP (415) 554-7530

MINORITIES, WOMEN AND PERSONS WITH DISABILITIES ARE ENCOURAGED TO APPLY

An Equal Opportunity Employer