1E50
INFORMATION TECHNOLOGY REPORT WRITER (ORACLE)

  This is specialized information technology report writing in the Oracle HRIS system for the City’s central human resources agency. The employee in this class is responsible for developing, maintaining, revising and completing a variety of standardized and ad hoc Oracle Reports using Oracle Report Writer. The employee will collect end user requirements, create functional/technical specifications, design, develop, test and deliver the report, and write the associated database queries. A significant aspect of the work is the development, preparation, production and security of confidential management reports for use in human resources analysis, including the collective bargaining process. Work is performed under the direction of a technical or administrative supervisor.

1. The position in this class must develop, maintain, revise and complete a variety of reports using Oracle Report Writer.
2. Only one position will be allocated to this class in the Personnel Department.

  Collects end user data requirements; creates business requirement specifications for reports in a standard format; acts as a liaison between users and the Information Technology staff to interpret user needs and provide practical, cost-effective solutions that will enable the users to improve productivity.

  Analyzes available data and creates specifications for data views and data extracts; works with the Database Administrators to create data views for reporting tools and to define and implement the best technical design to support the business requirements; works with Database Administrator and other Information Technology staff to insure that data is collected and stored in formats compatible with reporting requirements; writes database queries.

  Designs, develops, and tests reports using Oracle Report Writer in a format acceptable to the requestor using the available data analysis tools; develops functional and technical specifications; writes and maintains technical documentation to describe program development, logic, coding, testing, changes, and corrections; documents findings; develops and executes test plans / scripts to find errors and confirm reports / programs meet specifications; consults with Information Technology staff to prototype, test, and debug reports / programs to meet business requirements.

  Designs reports with an emphasis on highly understandable layouts and good visual design principles; develops, prepares and produces a variety of confidential reports for use by management during the collective bargaining process; builds and modifies reports as specified by users; creates data extracts and imports data into desktop applications such as Excel and Access for further analysis by users; develops report distribution strategies, including scheduled e-mail distribution, on-demand report generation, and storing of reports; delivers reports to users; maintains a documented report library and re-uses prior work to achieve maximum efficiency; maintains a glossary of terms (data dictionary); designs and develops methods to control reported data; ensures mathematical accuracy in reporting.

  Analyzes and understands business needs of the functional units of the department; analyzes legislation, regulations, collective bargaining agreements, policies and procedures to understand their impact on operations and on the data requirements of users; develops an understanding of users data by interviewing subject matter experts, querying data, analyzing existing reports and applications; conducts meetings with end users to determine report requirements and to identify ways in which reports can solve business problems for users; confers with representatives of the management bargaining team to determine data needs, format reports and deliver requested data; provides guidance in gathering, formatting, analyzing and presenting data required for bargaining; trains users on the features and uses of the ORACLE system; performs ad hoc analyses on a variety of specialized business issues; provide periodic status reports to supervisor.

  Performs related work as required.

KNOWLEDGE OF:
• Oracle Report Writer
• Oracle Reports and table / architecture
• Oracle Applications for E-Business Suite
• Oracle Workflow , Forms Development and Troubleshooting
• Relational data models, data modeling, database programming, and SQL
• Data warehousing concepts
• Microsoft Office (Access and Excel).
• Business analysis
• Oracle E-Business Suite Human Resources Management System
SKILL IN:
• Creating Oracle Reports
• Testing reports
• Effective presentation, organizational and planning skills
• Devoting rigorous attention to detail and application of standards and process
ABILITY TO:
• Use a personal computer using database, presentation, spreadsheet software and SQL
• Learn the operations, functions, data and reporting needs and requirements of the agency
• Learn the regulations, ordinances, policies and procedures related to the work of the agency
• Read, interpret, and understand technical information and apply cross-functional knowledge
• Communicate well verbally
• Write clearly, to create technical documentation related to report development activities
• Work independently and on a team
• Work independently with little supervision
• Exercise discretion in the storing, accessing and dissemination of confidential data
• Perform efficiently under strict deadlines
• Handle multiple project responsibilities simultaneously

EDUCATION

Completion of a bachelor’s degree program at an accredited college or university with major course work in information technology, computer science or a related area.

AND
GENERAL EXPERIENCE:

Two years experience information technology report writing.

AND
SPECIFIC EXPERIENCE:

Experience equivalent to two years full-time experience using reporting tools in Oracle.

PREFERRED EXPERIENCE:

Using Oracle E-Business Suite Human Resources Management System.

OR


Any equivalent combination of education and experience that has included completion of a bachelor’s degree and the specific experience.

Ability to physically perform the duties and to work in the environmental conditions required of a position in this class.