Office Automation Tools (PMG) Developer

Lanarkshire  ‐ Onsite
This project has been archived and is not accepting more applications.
Browse open projects on our job board.

Keywords

Description

PMG tools developer

Design, implementation, documentation and roll-out of a set of office automation tools to support specific steps and processes for programme and project management activities.

Responsibilities

  • Detailed design of office automation tools based on the purpose and guidelines described in the PMG process definition documents. The design should use data from different information sources such as data export from specific CA Clarity reports, other MS Excel spreadsheets and probably, data access methods to database connectors to specific databases and Datawarehouse.
  • Implementation of the designed tools using MS Excel to import data, transform it, store calculated data as a permanent source, create calculations and value searches, create automated and manual tables and create charts and specific reports. Implementation may include the design and implementation of user-defined formulas and MS Visual Basic functions and subroutines.
  • Development of user guide documentation for use of the tools.
  • Specification and documentation of tools functionality to allow a potential migration and reimplementation of this tool.

skills

  • Intermediate knowledge and experience on programme and project management processes and activities.
  • Advanced knowledge and experience on MS Excel spreadsheet use, including data tables, reference, date and time and conversion formulas, pivot tables, input fields and conditional formatting.
  • Advanced knowledge and experience on MS Visual Basic subroutines development to manipulate spreadsheet cells and functions used in both internal code reference and user-defined available functions.
  • User level knowledge and experience of MS Project.

Access level knowledge and experience on SQL-based databases would be beneficial.

Start date
ASAP
Duration
21/12/2012
From
Experis
Published at
19.10.2012
Project ID:
436599
Contract type
Freelance
To apply to this project you must log in.
Register