July 2015 Ohlone Community College

APPLICATIONS AND WEB DEVELOPMENT LEAD 100 12 Month Classified Position

Range57

SUMMARY OF POSITION

Under general direction provides and recommends solutions in using information systems applications ERP systems and other related systems in improving services offered by the College using systems and technology recommends and assists in planning implementing projects and assigning tasks and projects to the Applications and Web Development team related to programming systems analysis and management of databases Assist the analysts programmers and DBA in developing professional goals Coordinates and recommends the work schedule and taskproject assignment of the programmers analysts and database administrator coordinates projects and manages workflow of teams on projects if needed Night weekend and off-campus work may be assigned Perform related duties as assigned

DISTINGUISHING CHARACTERISTICS

The position serves as the technical expert in the Colleges ERP system and other related systems This is an experienced and professional level position with incumbents expected to perform work independently Responsibilities include but not limited to significant coordination and collaboration time management work assignment project management and the ability to solve issues and problems in a timely manner The incumbent serves as the lead working closely with staff and administrators in developing project plans project schedules and project deliverables

ESSENTIAL DUTIES The following duties are typical of those performed by employees in this job title however employees may perform other related duties and not all duties listed are necessarily performed by each employee in the job title

bull Provides on-going support and solutions to the Colleges ERP system as assigned bull Participates in the review and definition of functional areas processes and procedures

organization and flow of data methods and forms to automate or to improve existing systems

bull Conducts analysis ofdata for reports or report requirements acts as liaison between end users and IT in the assessment and development ofreporting needs explores innovations and trends in technology with and for institutional applicability

bull Designs and provides specifications for computed columns for queries and reporting

Applications and Web Development Lead Page2

writes simple computed va1ues in the integrated database (data pointers between files) coordinates with end users to develop and write reports develops report formats and specifications conduct analysis to improve the ERP system use and reliability for all end users

bull Uses effective project management tools for development and custom programming patch testing and project accounts lead project teams conducts and evaluates department needs and provide analysis ofcomputer systems and recommend solutions

bull Coordinates onsite vendor technical support bull Develops support maintenance and security structures for systems bull Creates documentation and train end users in system features and usage manages and

maintains procedural documentation develops procedures to support and interface with systems and streamline operations leads users and user groups in assessment and process mapping and business workflow criteria

bull Evaluates and implements State and Federa1 reporting requirements for information collection and processing manage and direct submissions of State and Federal regulatory and mandated reports establishes procedures and docwnentation to provide accurate input and maintenance of data reporting including but not exclusive to California MIS data Federal NSLC 1099 1098-T W2s 941 Quarterly Use-Tax Report FISAP and CaJGrant Grades Verification

bull Recommends workflows and request procedures for providing services related to ERP systems and other enterprise-level systems

bull Documents technical procedures and processes bull Develops user manuals and procedures to assist departments and divisions in the effective

use ofinformation systems bull Participates in short-range and long-range planning bull Coordinates assigns monitors progress and reports statuses of all tasks projects and

other activities ofthe Applications and Web Development team bull Plans and schedules upgrades testing and roll out of the Colleges systems that

minimizes impact to the operations ofthe College bull Coordinates with vendors and consultants for all requirements and needs licensing and

renewals and scheduling bull Maintains a thorough understanding ofcurrent trends in the areas ofcomputer hardware

and software telecommunication information security automated office procedures and public policy and law related to systems and technology in a Higher Education context

bull Contributes to the development of College planning docwnents policies procedures manuals and guides related to effective college operations

bull Assists staff in creating technical solutions to ongoing or mission critical issues with technology and

bull Leads in training employees in the effective use of the Colleges systems

OTHER JOB RELATED DUTIES

Perform related duties and responsibilities es required

EXPERIENCE AND EDUCATION GUIDELINES Any combination of experience and

Applications and Web Development Lead Page3

education that would likely provide the required knowledge and abilities qualifies A typica1 way to obtain the knowledge and abilities would be

Education Bachelors degree in Computer Science Information Systems Information Teclmology Computer Engineering Business Administration or other closely related degrees Experience may substitute for a degree on a one on one equivalency

Experience At least five years offull-time experience in the area ofprogramming systems analysis technical documentation testing report generation andor user training at least three years offull experience in ERP systems required (ex Colleague Banner Jenzerbar PeopleSoft)

JOB RELATED AND ESSENTIAL QUALIFICATIONS

Knowledge of Professional knowledge ofthe following

bull Architecture ofERP systems bull Principles and techniques ofsystems analysis and design using proven tools bull Principles ofmodular and integrated testing bull Principles and techniques ofprogramming online programming and data processing bull Structured programming object oriented programming and web programming bull Principles of query language bull Principles ofsystem interoperability scalability flexibility and availability bull Principles ofdisaster recovery and business continuity bull Principles oftechnical writing bull Proper English usage spelling grarrunar and punctuation bull OSHA and ADA regulations

Ability to bull Plan organize and manage assigned projects bull Document all work performed in an online service management system bull Adapt to the use ofnew and emerging technologies bull Deal effectively with both novice and experienced users bull Develop documentations for information systemsbull activities processes and procedures bull Set-up load test maintain configure and troubleshoot reports scripts and other

developed solutions bull Coordinates with vendors and consultants and effectively articulate requirements and

needs in both technical and ordinary language communicate effectively both orally and in writing

bull Demonstrate sensitivity to and understanding of the diverse academic socioeconomic cultural and ethnic backgrounds of faculty staff and students with physical and learning disabilities work in teams and promote collaboration and communication

Skills to

Applications and Web Development Lead Page4

bull Respond in a timely and effective manner to help desk requests from all divisional clients bull Provide in person and remote support to clients that empbasizes a high level of customer

satisfaction and communication bull Problem solving and in identifying issues with reports and process gaps bull Analyzing and recommending process improvement to effectively and efficiently improve

business processes bull Coordination collaboratio~ and communication to successfully implement projects on

budget and on time bull Work independently or as part of a team ifneeded to resolve customer problems plan and

implement large scale software and hardware deployments migrations and upgrades and bull Be available and flexible to resolve problems after normal business hours as needed

SPECIAL REQUIREMENTS ampsentiafduties require thefollowlngphyslcal abilities andworlc environment

bull Ability to work in a standard office environment bull Communicate clearly and concisely both orally and in writing bull Ability to operate standard office equipment bull Ability to sit stand walk kneel squat reach and lift 40 pounds bull Ability to recognize and deal with electrical and mechanical hazards bull Ability to differentiate accurately between colors used in coding and identification bull Work in an officeclassroom environment bull Ability to work flexible scheduling ofwork time including evenings and weekends and

rotational days offandor off-setting shifts

All Tentative Agreements must be ratified as part of the entire collective bargaining agreement by both the CSEA members and the Board of Ohlone Community College District

Presented and Revised 07022015 08022015 08102015 Approved CSEA 610 Approved CSEA Local Ratified Ohlone Board approved

For Dimrict

Applications and Web Development Lead Page2

writes simple computed va1ues in the integrated database (data pointers between files) coordinates with end users to develop and write reports develops report formats and specifications conduct analysis to improve the ERP system use and reliability for all end users

bull Uses effective project management tools for development and custom programming patch testing and project accounts lead project teams conducts and evaluates department needs and provide analysis ofcomputer systems and recommend solutions

bull Coordinates onsite vendor technical support bull Develops support maintenance and security structures for systems bull Creates documentation and train end users in system features and usage manages and

maintains procedural documentation develops procedures to support and interface with systems and streamline operations leads users and user groups in assessment and process mapping and business workflow criteria

bull Evaluates and implements State and Federa1 reporting requirements for information collection and processing manage and direct submissions of State and Federal regulatory and mandated reports establishes procedures and docwnentation to provide accurate input and maintenance of data reporting including but not exclusive to California MIS data Federal NSLC 1099 1098-T W2s 941 Quarterly Use-Tax Report FISAP and CaJGrant Grades Verification

bull Recommends workflows and request procedures for providing services related to ERP systems and other enterprise-level systems

bull Documents technical procedures and processes bull Develops user manuals and procedures to assist departments and divisions in the effective

use ofinformation systems bull Participates in short-range and long-range planning bull Coordinates assigns monitors progress and reports statuses of all tasks projects and

other activities ofthe Applications and Web Development team bull Plans and schedules upgrades testing and roll out of the Colleges systems that

minimizes impact to the operations ofthe College bull Coordinates with vendors and consultants for all requirements and needs licensing and

renewals and scheduling bull Maintains a thorough understanding ofcurrent trends in the areas ofcomputer hardware

and software telecommunication information security automated office procedures and public policy and law related to systems and technology in a Higher Education context

bull Contributes to the development of College planning docwnents policies procedures manuals and guides related to effective college operations

bull Assists staff in creating technical solutions to ongoing or mission critical issues with technology and

bull Leads in training employees in the effective use of the Colleges systems

OTHER JOB RELATED DUTIES

Perform related duties and responsibilities es required

EXPERIENCE AND EDUCATION GUIDELINES Any combination of experience and

Applications and Web Development Lead Page3

education that would likely provide the required knowledge and abilities qualifies A typica1 way to obtain the knowledge and abilities would be

Education Bachelors degree in Computer Science Information Systems Information Teclmology Computer Engineering Business Administration or other closely related degrees Experience may substitute for a degree on a one on one equivalency

Experience At least five years offull-time experience in the area ofprogramming systems analysis technical documentation testing report generation andor user training at least three years offull experience in ERP systems required (ex Colleague Banner Jenzerbar PeopleSoft)

JOB RELATED AND ESSENTIAL QUALIFICATIONS

Knowledge of Professional knowledge ofthe following

bull Architecture ofERP systems bull Principles and techniques ofsystems analysis and design using proven tools bull Principles ofmodular and integrated testing bull Principles and techniques ofprogramming online programming and data processing bull Structured programming object oriented programming and web programming bull Principles of query language bull Principles ofsystem interoperability scalability flexibility and availability bull Principles ofdisaster recovery and business continuity bull Principles oftechnical writing bull Proper English usage spelling grarrunar and punctuation bull OSHA and ADA regulations

Ability to bull Plan organize and manage assigned projects bull Document all work performed in an online service management system bull Adapt to the use ofnew and emerging technologies bull Deal effectively with both novice and experienced users bull Develop documentations for information systemsbull activities processes and procedures bull Set-up load test maintain configure and troubleshoot reports scripts and other

developed solutions bull Coordinates with vendors and consultants and effectively articulate requirements and

needs in both technical and ordinary language communicate effectively both orally and in writing

bull Demonstrate sensitivity to and understanding of the diverse academic socioeconomic cultural and ethnic backgrounds of faculty staff and students with physical and learning disabilities work in teams and promote collaboration and communication

Skills to

Applications and Web Development Lead Page4

bull Respond in a timely and effective manner to help desk requests from all divisional clients bull Provide in person and remote support to clients that empbasizes a high level of customer

satisfaction and communication bull Problem solving and in identifying issues with reports and process gaps bull Analyzing and recommending process improvement to effectively and efficiently improve

business processes bull Coordination collaboratio~ and communication to successfully implement projects on

budget and on time bull Work independently or as part of a team ifneeded to resolve customer problems plan and

implement large scale software and hardware deployments migrations and upgrades and bull Be available and flexible to resolve problems after normal business hours as needed

SPECIAL REQUIREMENTS ampsentiafduties require thefollowlngphyslcal abilities andworlc environment

bull Ability to work in a standard office environment bull Communicate clearly and concisely both orally and in writing bull Ability to operate standard office equipment bull Ability to sit stand walk kneel squat reach and lift 40 pounds bull Ability to recognize and deal with electrical and mechanical hazards bull Ability to differentiate accurately between colors used in coding and identification bull Work in an officeclassroom environment bull Ability to work flexible scheduling ofwork time including evenings and weekends and

rotational days offandor off-setting shifts

All Tentative Agreements must be ratified as part of the entire collective bargaining agreement by both the CSEA members and the Board of Ohlone Community College District

Presented and Revised 07022015 08022015 08102015 Approved CSEA 610 Approved CSEA Local Ratified Ohlone Board approved

For Dimrict

Applications and Web Development Lead Page3

education that would likely provide the required knowledge and abilities qualifies A typica1 way to obtain the knowledge and abilities would be

Education Bachelors degree in Computer Science Information Systems Information Teclmology Computer Engineering Business Administration or other closely related degrees Experience may substitute for a degree on a one on one equivalency

Experience At least five years offull-time experience in the area ofprogramming systems analysis technical documentation testing report generation andor user training at least three years offull experience in ERP systems required (ex Colleague Banner Jenzerbar PeopleSoft)

JOB RELATED AND ESSENTIAL QUALIFICATIONS

Knowledge of Professional knowledge ofthe following

bull Architecture ofERP systems bull Principles and techniques ofsystems analysis and design using proven tools bull Principles ofmodular and integrated testing bull Principles and techniques ofprogramming online programming and data processing bull Structured programming object oriented programming and web programming bull Principles of query language bull Principles ofsystem interoperability scalability flexibility and availability bull Principles ofdisaster recovery and business continuity bull Principles oftechnical writing bull Proper English usage spelling grarrunar and punctuation bull OSHA and ADA regulations

Ability to bull Plan organize and manage assigned projects bull Document all work performed in an online service management system bull Adapt to the use ofnew and emerging technologies bull Deal effectively with both novice and experienced users bull Develop documentations for information systemsbull activities processes and procedures bull Set-up load test maintain configure and troubleshoot reports scripts and other

developed solutions bull Coordinates with vendors and consultants and effectively articulate requirements and

needs in both technical and ordinary language communicate effectively both orally and in writing

bull Demonstrate sensitivity to and understanding of the diverse academic socioeconomic cultural and ethnic backgrounds of faculty staff and students with physical and learning disabilities work in teams and promote collaboration and communication

Skills to

Applications and Web Development Lead Page4

bull Respond in a timely and effective manner to help desk requests from all divisional clients bull Provide in person and remote support to clients that empbasizes a high level of customer

satisfaction and communication bull Problem solving and in identifying issues with reports and process gaps bull Analyzing and recommending process improvement to effectively and efficiently improve

business processes bull Coordination collaboratio~ and communication to successfully implement projects on

budget and on time bull Work independently or as part of a team ifneeded to resolve customer problems plan and

implement large scale software and hardware deployments migrations and upgrades and bull Be available and flexible to resolve problems after normal business hours as needed

SPECIAL REQUIREMENTS ampsentiafduties require thefollowlngphyslcal abilities andworlc environment

bull Ability to work in a standard office environment bull Communicate clearly and concisely both orally and in writing bull Ability to operate standard office equipment bull Ability to sit stand walk kneel squat reach and lift 40 pounds bull Ability to recognize and deal with electrical and mechanical hazards bull Ability to differentiate accurately between colors used in coding and identification bull Work in an officeclassroom environment bull Ability to work flexible scheduling ofwork time including evenings and weekends and

rotational days offandor off-setting shifts

All Tentative Agreements must be ratified as part of the entire collective bargaining agreement by both the CSEA members and the Board of Ohlone Community College District

Presented and Revised 07022015 08022015 08102015 Approved CSEA 610 Approved CSEA Local Ratified Ohlone Board approved

For Dimrict

Applications and Web Development Lead Page4

bull Respond in a timely and effective manner to help desk requests from all divisional clients bull Provide in person and remote support to clients that empbasizes a high level of customer

satisfaction and communication bull Problem solving and in identifying issues with reports and process gaps bull Analyzing and recommending process improvement to effectively and efficiently improve

business processes bull Coordination collaboratio~ and communication to successfully implement projects on

budget and on time bull Work independently or as part of a team ifneeded to resolve customer problems plan and

implement large scale software and hardware deployments migrations and upgrades and bull Be available and flexible to resolve problems after normal business hours as needed

SPECIAL REQUIREMENTS ampsentiafduties require thefollowlngphyslcal abilities andworlc environment

bull Ability to work in a standard office environment bull Communicate clearly and concisely both orally and in writing bull Ability to operate standard office equipment bull Ability to sit stand walk kneel squat reach and lift 40 pounds bull Ability to recognize and deal with electrical and mechanical hazards bull Ability to differentiate accurately between colors used in coding and identification bull Work in an officeclassroom environment bull Ability to work flexible scheduling ofwork time including evenings and weekends and

rotational days offandor off-setting shifts

All Tentative Agreements must be ratified as part of the entire collective bargaining agreement by both the CSEA members and the Board of Ohlone Community College District

Presented and Revised 07022015 08022015 08102015 Approved CSEA 610 Approved CSEA Local Ratified Ohlone Board approved

For Dimrict