DATA PROCESSING SUPERVISOR
PROMOTIONAL EXAMINATION #71-193
DATE OF EXAMINATION: SATURDAY, DECEMBER 10, 2016
PLACE OF EXAMINATION: AB Davis Middle School – Mount Vernon, New York @ 8:30 A.M.
APPLICATION CLOSING DATE: NOVEMBER 9, 2016 @ 3:00pm –no exceptions
AT PRESENT, THERE IS ONE VACANCY IN THE MOUNT VERNON CITY SCHOOL DISTRICT.
MUST BE EMPLOYED IN THE MOUNT VERNON CITY SCHOOL DISTRICT IN A PERMANENT COMPETITIVE CLASS POSITION FOR NOT LESS THAN ONE YEAR AND MEET THE FOLLOWING REQUIREMENTS.
REQUIREMENTS FOR TAKING THE EXAM:
- Bachelor’s Degree in Business, Computer Science, Information Technology or a closely related field; PLUS 4 years of recent experience (gained in the last 8 years) where the primary function was in Human Resources data management which must have included specialized experience in the design of relational databases and queries for computer software and the proficient use of multiple versions of MS Office Suite products, e.g. MS Access, MS Excel, NS Word; OR
- An Associate’s Degree in Business, Computer Science, Information Technology or a closely related field; PLUS 6 years of the experience as noted in (a) above;
- Graduation from high school or possession of an equivalency diploma issued by the New York State Education Department; PLUS 8 years of the experience as noted in (a) above.
NOTE: For appointment from the resulting eligible list, applicants with a foreign high school diploma must submit a course by course evaluation of their educational credentials. You must pay the required evaluation fee. Evaluations will be accepted from services such as: WORLD EDUCATION SERVICES, INC., P.O. BOX 5087, NEW YORK, NY 10274 – 212-966-6311, GLOBE LANGUAGE SERVICES, INC. 319 BROADWAY #200, NEW YORK, NY 10027, 212-227-1994, OR INTERNATIONAL EDUCATION RESEARCH FOUNDATION, INC. P.O. BOX 3665, CULVER CITY, CA. 90231.
DUTIES: Under general supervision of The Assistant Superintendent of Human Resources and the Associate Superintendent of Human Resources, incumbent in this class is responsible for the management and support of all Human Resources data information systems and software applications generating databases used throughout the school district and for confidential negotiations. This may include, but not limited to: Microsoft Access and Excel, MUNIS, AESOP, Applitract, SQL, Power Point, NYSED Application Business Portal, and all versions of Windows in a workstation end user environment. This position is responsible for designing and customizing databases and queries to meet various user needs in regards to the collection, analysis, reporting and sharing of automated data. This is a technical professional level position with access to all Human Resources-related automated data maintained throughout the school district, including confidential data on students, teachers and support staff. Trains staff when necessary. Supervision may be exercised over support staff. Does related work as required.
REQUIRED KNOWLEDGE, SKILLS AND ABILITIES: Thorough knowledge of and demonstrated ability to successfully self-direct accurate and timely acquisition of proficiency with database applications for micro/minicomputers including a combination of the following (see above); strong ability to analyze problems in a logical and systemic manner; proven ability to design relational databases; ability to program, upgrade and customize databases to user defined needs and validate successful changes; proven ability to design advanced queries for the purpose of user-defined reporting requirements; good command of the English language; good ability to understand and complex oral and written directions; ability to lead, organize, manage and complete projects accurately and in a timely manner; ability to validate and cross-reference multiple data sources; demonstrated ability to communicate effectively and collaboratively with instructional, administrative, technical and support staff in order to provide user training; ability to coordinate work of others; initiative; creativeness; dependability; ability to work well with others; ability to work extended hours to insure that the system is continuously operational and responsive to the department’s schedule and physical condition commensurate with the demands of the position.
SUBJECTS OF EXAMINATION: The written test will cover knowledge, skills and/or abilities in the following areas:
1) PRINCIPLES OF DATA BASES FOR MICROCOMPUTERS;
2) DATA PROCESSING CONCEPTS AND TERMINOLOGY;
3) PREPARING WRITTEN MATERIAL;
4) PROGRAMMING TECHNIQUES AND CONCEPTS;
5) PRINCIPLES OF PROVIDING USER SUPPORT.
EXPANDED SCOPE STATEMENT:
PRINCIPLES OF DATA BASES FOR MICROCOMPUTERS – These questions test for a basic background in the design and use of databases on microcomputers. They cover such topics as database terminology and concepts, analyzing a database project, planning the database, organizing the data, designing entry forms, accessing and manipulating the data, generating reports and performing backups.
- DATE PROCESSING CONCEPTS AND TERMINOLOGY – These questions are designed to test for knowledge of computer characteristics and operations that is relevant for computer programming and analysis. They may cover, but not necessarily be confined to, basic terminology of data processing, data entry, data access and data communications; basic characteristics of storage media and data bases; types of data processing (e.g., time-sharing), the functions of operating systems and hierarchies of computer memory.
- PREPARING WRITTEN MATERIAL – These questions test for the ability to present information clearly and accurately and to organize paragraphs logically and comprehensibly. For some questions, you will be given information in two or three sentences followed by four restatements of the information. You must then choose the best version. For other questions, you will be given paragraphs with their sentences out of order. You must then choose, from four suggestions, the best order for the sentences.
- PROGRAMMING TECHNIQUES AND CONCEPTS – These questions test for basic structures of higher-level computer programming languages and their applications. They cover such subjects as programming techniques and terminology, program documentation and flowchart interpretation.
- PRINCIPLES OF PROVIDING USER SUPPORT – These questions test for knowledge and skill in working in a user support situation. They cover such subjects as how to communicate effectively with users requesting help; how to deal with different types of situations; troubleshooting techniques; and how to gather, organize and make available technical information needed to provide support.
The New York State Department of Civil Service has not prepared a test guide for this examination. However, candidates may find information in the publication “How to take a written test” helpful in preparing for this test. This publication is available on line at: www.cs.ny.gov/testing/localtestguides.cfm
Calculators are pERMITTED for this examination: DEVICES WITH TYPEWRITER KEYBOARDS, SPELL CHECKERS, PERSONAL DIGITAL ASSISTANTS, ADDRESS BOOKS, LANGUAGE TRANSISTORS, DICTIONARIES OR ANY SIMILAR DEVICES ARE PROHIBITED.
Candidates are required to attain a final average rating of 70 in order to be eligible to have their name placed on the eligible list established as a result of this examination. Life on the list will be stated at the time the list is established.
APPLICATION FEE: A $25.00 NON-REFUNDABLE FILING FEE IS REQUIRED FOR THIS EXAMINATION. The applicable fee is required and must accompany your application. If your application is received without the required fee, it will be considered incomplete and you will not be admitted to the examination. Only MONEY ORDERS will be accepted for the applications fee. The money order should be made payable to the City of Mount Vernon and be sure to write the examination number on the money order. CASH OR CHECKS WILL NOT BE ACCEPTED. Because NO REFUND will be made, you are urged to compare your qualifications carefully with the requirements for admission.
Applications are available in the Mount Vernon Municipal Civil Service Commission Office Monday through Friday from 9:00 AM to 4:00 PM or send a self-addressed, legal-sized envelope to the Civil Service Commission, Room 103 – City Hall, One Roosevelt Square, Mount Vernon, NY 10550. Applicants may also obtain applications from the City of Mount Vernon’s website at www.cmvny.com. All applications must be returned to the Civil Service Commission Office on or before the application deadline date.
For applications go to the Civil Service Office Monday through Friday from 9:00 am to 4:00 pm or send a stamped self-addressed, legal-sized envelope to the Civil Service Commission, Room 103, City Hall, 1 Roosevelt Square, Mt. Vernon, New York 10550. You may also obtain applications from our website @www.cmvny.com. ALL APPLICATIONS MUST BE RETURNED TO THE CIVIL SERVICE OFFICE WITH YOUR FILING FEE. Applications received via mail will not be accepted if postmarked after the closing date deadline of NOVEMBER 9, 2016.
RELIGIOUS OBSERVERS AND DISABLED PERSONS: If special arrangements for testing are required, please indicate this on your application and submit on a separate sheet of paper and attach it to your application at time of submission. You will be notified of the alternate test date which will take place in City Hall.
VETERAN’S CREDITS: Veterans or disabled veterans who are eligible for additional credits must submit an application for veteran’s credits with the application for examination or at any time between the dates of their application for examination and the date of the establishment of the resulting eligible list. Applications for Veteran’s credit are available in the Civil Service Office. DD214 (Discharge papers must also be submitted). Veteran’s credits can only be added to a passing score on the examination.
Effective January 1, 1998, the State Constitution was amended to permit a candidate currently in the armed forces to apply for and be conditionally granted veteran’s credits in examinations. Any candidate who applies for such credit must provide proof of military status to receive the conditional credit. NO CREDIT MAY BE GRANTED AFTER THE ESTABLISHMENT OF THE ELIGIBLE LIST. It is the responsibility of the candidate to provide appropriate documentary proof indicating that the service was in time of war, as defined in Section 85 of the Civil Service Law, and that the candidate received an honorable discharge or was released under honorable conditions in order to be certified at a score including veteran’s credits.
ALTERNATE TEST DATE POLICY: Alternate test(s) date(s) may be arranged upon review of the circumstances according to the alternate Test Date Policy adopted April 14, 2008 by the Civil Service Commission. Under specific circumstances an alternate test date may be arranged. Your request with written documentation must be received in the Mt. Vernon Civil Service office no later than two (2) weeks preceding the examination. If an emergency prevents you from appearing for the examination, please notify the Civil Service office in writing no later than the Friday before the test date and provide verifiable documentation of the reason. A determination will be made as to if an alternate test date will be scheduled.
SPECIAL REQUEST FOR MAKE UP EXAM DUE TO MILITARY DUTY: A make-up test will be available for written or any other portion of the test for persons who are in the activity military. A person eligible for military make-up test does not have to wait until discharge from active duty to take the test. Applicant must submit to this office a copy of a military order, DD214, or any other military document that substantiates active military service prior to the make-up test.
It is the responsibility of the candidate to notify the Civil Service Office of any change in name or address.
No attempt will be made to locate candidates who have moved.
THE CITY OF MOUNT VERNON IS AN EQUAL OPPORTUNITY EMPLOYER