1. Background Information

The purpose of the OMAC is to achieve the following:
• Create a consistent and easy to understand frame of reference for reliable reporting
• It is a central walk-in facility to get immediate visibility and insight on project status, critical path issues, project constraints, understanding of capacity need and system performance
• Facilitate informed decision making and expedite interventions to resolve current and emerging issues impacting individual and multiple sites on a daily / weekly basis
• Enable proactive and ad-hoc stakeholder reporting and communication
• Enable a forum to carry out investigation, brainstorming and problem solving sessions with the intent to devise a plan to manage constraints via daily tasks and activities
• To ensure that issues that have been solved do not reoccur (same site or other sites)
• Trigger decisive and coordinated site, management and executive intervention to mitigate risks and resolve issues before they impact the project targeted milestones, timelines, costs and quality
• Showcase accomplishments and achievements of the OMAC team
To date OMAC has mainly used MS Excel to consolidate and report on the data received from the build projects.Requirements and the be scope of scope Intermediate BI Microsoft SSRS developer

Requirement
3 years design experience
2 years application Server Experience
Expert knowledge on SQL server technology stack
Extensive Knowledge on MS Excel, Power BI, SSRS

Scope of work/supply
We are in need of resources to transform the existing OMAC data sheets into a comprehensive reporting platform, automating the capturing and collection of data, and presenting the content in the form of reports.

Intermediate BI Microsoft SSRS Developer
• Analyse and identify gaps in client data
• Develop and design dashboards based on data collected
• Report publishing and maintenance
• Do skills transfers and coaching