2007-2012
A group of 2 self-employed enthusiasts formed a company in Nottingham, UK named E-Business Solutions, and later on, Miaz-tech Ltd and IDB solutions Ltd. Target domain BI, Business analysis, system integration , and informational systems. The main tools were Oracle, Big data , and system integration. This was a period of time when local businesses just started to realize opportunities for BI. Tens of local businesses entrusted us with BI for their business processes and the development of BI infrastructure.
2012-2013
A core element of BAA’s strategy was to ensure that Heathrow Airport’s vision of “To be Europe’s hub of choice by making every journey better” is enabled through transformational change.
To support this strategy BAA has initiated a number of activity streams to simplify the business, raise professional standards, increase personal accountability and reduce costs. In order to achieve this, BAA invested in people, processes, and technology changes across the organization and a major program for BAA’s Capital Directorate, which was managed within a business process change project known as “BAA Re-Engineering”. The drive for continuous improvement also enabled a review of the Capital and IT Directorate’s expenditure, and its governance; which created an opportunity for an upgrade of the current Programme Controls toolset used within BAA for Heathrow Airport projects.
The Programme Controls (PgC) Project was initiated to address this requirement by delivering a Programme Controls toolset based on Primavera software applications onto a hosted platform provided and managed by Oracle on Demand in the USA.
- BAA aimed to replace the existing cost (Artemis) and schedule system Primavera (P6.2) with EPPM (P6) in order to have the scheduling and cost view in one system.
- The project requires data analysis, transformation, business analysis, developing data mock-up, testing scripts and end-to-end process evaluation.
- Development, specification, testing and migration and archival of data from the legacy system to the new ERP (Primavera 6.2)
- Divide the project into three tranches
- Tranche 1
- Live data migration (Cost, schedule) using business rules using PL/SQL.
- Data Cleanse during data migration
- DQ report after each load
- Worked closely with 3rd parties to develop a Java-based app to perform data migration from legacy P6 to EPPM using P6 APIs
- Tranche 2
- Migration of legacy data from Excel to Oracle Database
- Working 3rd part to capture MI/KPI for BAA directorate and contract/sub-contractor.
- Build P6 extended schemes and develop OBIEE 10g to develop RTF based report