View all jobs
Consultant Reporting MS Project/Access/VBA - August 2019
Düsseldorf, NRWFor one of our clients we are looking for a Consultant Reporting VBA
Project Description:
ONE!GSC Horizon is a comprehensive business transformation program facilitating the implementation of a globally aligned and harmonized Supply Chain including Purchasing. For the first time in the client, there will be end-to-end, standardized supply chain process. Being part of the client's strategy, this program is a key initiative for the scalable business model. The ONE!GSC Horizon organization with lean and simplified operations aims to enhance the client's competitiveness by leveraging on client's combined potential, boosting process efficiency.
Task description:
Duration: 1 year+
Location: 90% remote, 10% onsite in Duesseldorf
Project Description:
ONE!GSC Horizon is a comprehensive business transformation program facilitating the implementation of a globally aligned and harmonized Supply Chain including Purchasing. For the first time in the client, there will be end-to-end, standardized supply chain process. Being part of the client's strategy, this program is a key initiative for the scalable business model. The ONE!GSC Horizon organization with lean and simplified operations aims to enhance the client's competitiveness by leveraging on client's combined potential, boosting process efficiency.
Task description:
- The Master Plan application provides tools for:
- The reconciliation of status reports from many subprojects into one integrated Master Plan by aggregating the information to strengthen consistency;
- Automatically extracting and publishing information from multiple sharepoints in one dashboard.
- Maintain the Master Plan Platform:
- Safeguard that all reports are collected on time and load the reports into the Master Plan tool;
- Evaluate and resolve any inconsistencies and conflicts in the tool and with the project managers;
- Update the overall integrated plan based on the individual input;
- Export the weekly reports for all projects and provide the reporting template to all projects;
- Update the resource management database on a monthly level based on the input from the resource planning responsibles;
- Engage and coach individual project managers and work stream leads to work with the Master Plan:
- Coordinate adoption of the plan, and
- Facilitate ongoing adherence to the planning and reporting processes.
- Safeguard that all identified streams and projects are working to the defined process and standard for resource management;
- Oversee that all defined updates and reports are performed to the set frequency;
- Manage any conflicts, overload and supply issues that are identified and highlighted for appropriate remedial action;
- Safeguard quality of all programs and fix any bugs in the programmed interfaces of all tools used.
- Enhance the Master Plan Platform:
- Implement new functionalities into the Master Plan by programming new modules for new sub phases and new projects;
- Program and modify all interfaces between the back-end module and the reports generated based on required changes;
- Program new reports for the Dashboard.
Required skills:
- MS Project + VBA
- MS Access + VBA
- Excel + VBA
- MS Powerpoint + VBA
- MS Query
- SQL
- Sharepoint
- In addition to the technical expertise, solid project management experience is required to strengthen consistency with project management standards.
- English is a must as it is an international project.
Duration: 1 year+
Location: 90% remote, 10% onsite in Duesseldorf