Muhammad Haroon Ashfaq

• Home Office - Senior Oracle MI Developer 

Haroon was a key member of the Define Team on the Home Office engagement, which focused on decommissioning a legacy case working system and infrastructure while migrating critical immigration data to ensure the continuity of essential MI reporting. This marked Haroon's second stint on the project, showcasing his in-depth understanding of the unique challenges and requirements involved.  

As a Senior Oracle Developer on the MI workstream, Haroon worked extensively with immigration data, ensuring that the complexities of its structure and sensitivity were managed effectively. Collaborating closely with Business Analysts, Haroon mapped the new data structures to the legacy system framework, addressing the intricate differences between the two systems. He also reviewed the ETL processes and contributed to the custom development of SQL code to accurately load and organize the data, meeting the client’s stringent reporting requirements.  

Haroon ensured that the MI reports delivered were not only accurate but also aligned with the client’s operational needs. By optimizing code performance, resolving technical and data mapping challenges, and rigorously testing reports, Haroon played a crucial role in enabling the client to continue generating reliable insights from their immigration data without disruption.

Project Experience:

• InvoCare - Senior Oracle Cloud BI Consultant

The InvoCare engagement involved the development of a new reporting solution that entailed the development of new reports from multiple source systems. The new solution was being built using the following technologies: Oracle Autonomous Database, Oracle Analytics Cloud and Oracle Data Visualisation. Haroon was the Senior Oracle Analytics Consultant working alongside key stakeholders to understand the requirements of numerous reports that would need to be developed. With the requirements understood Haroon helped develop the underlying Data Model that would drive the development of the new reports. Once the Data Model was in place, Haroon helped to develop the new reports and showcased these to key stakeholders and business users across the business.

• Ocado - Senior Oracle Cloud BI Consultant

Haroon was brought in to conduct an Analytics Review on Ocado’s current reporting solution (OTBI/BI Publisher). Ocado were facing multiple issues which ranged from report delivery, security, and a lack of in-house expertise. Haroon put together a thorough report that highlighted the current issues faced by Ocado and a clear list of recommendations on how these could be resolved. Haroon presented his findings to key stakeholders which was well received. Off the back of the review Ocado took on the recommendations to help obtain the full potential of their existing reporting solution.

• NatWest - Senior Oracle Analytics Consultant

The NatWest engagement involved aiding the migration from previous analytical tools across to Oracle Narrative Reporting/Data Visualisation. The challenges faced where around redeveloping existing reports whilst optimising them with the benefits of the Oracle stack they’d recently taken on. Haroon was the Senior Oracle Analytics Consultant on the MI work-stream and worked with Business Analysts to map out the redevelopment of the existing reports within the new Oracle stack. Haroon’s focus was around building a new data model that would be used to help redevelopment of existing reports but also for any new reports that may need developing in the future.

Project Experience:

• Home Office - Senior Oracle MI Developer 

The Home Office engagement involved decommissioning of a legacy case working system, infrastructure and migrating necessary data to ensure business critical MI reporting continues to operate with no impact on the business. This involved an overly complex process due to the different structure of the legacy data and new case working system data.

 Haroon was the Senior Oracle Developer on the MI workstream and worked with Business Analysts to map the new data structures to the legacy data structures. Haroon also reviewed the ETL process and assisted with the custom development of SQL code to step by step load and structure the data to ensure business continuity on the MI critical reports. Haroon refined the code to ensure efficient performance, reviewed and produced solutions to technical issues, resolved data mapping issues and tested MI reports to ensure functionality and data were as expected.

Haroon was brought in as a Senior Oracle Business Intelligence Developer to continue the work that Deloitte had begun with IHG on a company wide project known as PRISM. At the time IHG were also going through a restructure in moving across their Information Delivery Team from the US to the UK allowing Haroon to take lead on all major projects going forward.

• Haroon led on the design and implementation of three major projects known as Hotel Winning Metrics, Regional Winning Metrics & Leading Indicators. This enabled hotel owners and senior executives to get a better overall picture of how their hotels or regions were performing. This was a custom-built solution pushing the boundaries of OBIEE by using EPM as the source for the data and the use of HTML/Java to build fluid user interaction. Haroon supported the project through the requirements gathering stage talking to key stakeholders along with helping during the testing phase up until go live when the project was ready to launch to all end users.  
• Haroon also helped with general business as usual requests. This entailed up keeping the large portfolio of EPM reports using Oracle Financial Reporting Studio along with OBIEE fixes on current reports and dashboards.
• Haroon helped in moving IHG towards a more agile approach in delivering new projects and enhancements to current work. Haroon leveraged his knowledge gained from UoB and helped implement best practices.
• As part of the restructure Haroon was a part of an international team across different time zones. This could have caused problematic however due to Haroon’s prior experience working within an international team he was able to pioneer a way to get the best results for the business.

Haroon helped deliver the technical/functional development and implementation of the BI aspects for the New Core Programme, and the extension of this to accommodate other BI requirements of the University that impact on New Core.

• Haroon provided expert knowledge regarding the implementation of Oracle’s pre-built “Business Intelligence Applications” solution, which consisted of a dimensional warehouse specifically designed to hold ERP and HR data, with ETL routines to populate the warehouse from Oracle cloud systems, metadata dictionary and a suite of prebuilt reports and dashboards across Finance, procurement, projects, HR and Payroll data.
• Haroon led on the design and implementation of the custom OTBI/Cloud security for reporting. This entailed talking to key business users around the university and producing a set of requirements that could be translated into custom roles for users to access the correct reports and more importantly data.
• Haroon led on the design, implementation and extension of the delivered Oracle out of the box reports and dashboards to deliver to the New Core reporting requirements. This entailed complex report and dashboard build alongside a number of key stakeholders within the university. This covered off both the HCM/Financials modules for the project taking a lead role in ensuring over 300+ reports were delivered on time and to high standards.
• Haroon worked closely within the BI team to adopt an Agile methodology across the stream to help deliver the reports in the most effective and efficient way possible. This proved to be a challenge within the wider project as a whole which was being run in a waterfall fashion. However the Agile approach provided the desired results
• Haroon provided expert knowledge in the Data model design and documentation (Facts and Dimensions, Business Users & Security Permissions, Stars with Hierarchies, Business Model Names for Source Columns, Reports and Dashboard Layouts).

Project Experience:

• Oman Trading International - Project Management/Data Migration Lead

Haroon worked on OTI as the Lead Data Migration specialist. This entailed migrating data from OTI's current trading system (Vitol) through to the new system being implemented (SAP ByD). This proved to be extremely challenging as the data hadn't been cleansed for years. Haroon's role was to analyze the data thoroughly for any gaps or discrepancies before populating the data into the new system being implemented. This required Haroon to liaise with OTI personnel to obtain missing data or to cleanse existing data. Alongside Haroon's Data Migration role he was project managing the overall project which entailed: project planning, meeting scheduling, document creation & workshop facilitating. 

• SSE - Oracle BI Consultant

Haroon was assigned to the SSE project in an advisory role to help SSE make the correct decision on the proposed plans that had been put forward by 3rd party companies on the structure and architecture of there newly designed reporting solution. Haroon liaised with many individuals within SSE to give recommendations on the proposed solution. After extensive analysis of the entire solution (OBIA/OBIEE Stack) by Haroon the recommendations where accepted by SSE with the solution being pushed back until the amendments had been made before being presented once again to key stakeholders within SSE. 

• Santander UK - Oracle Service Cloud Technical Lead

Haroon’s role covered the initial requirements gathering phase of the project where he was put in the awkward situation of providing the designs for the Service Cloud solution with out any clear direction. However Haroon proved to be extremely versatile and adaptable by turning around the designs and providing these to the business which were agreed upon. Haroon then scoped out the level of development and provided a project plan to the business with all the key dates of how long the proposed solution would take to implement. With the design piece and scoping agreed upon Haroon began the development of the site using his own technical knowledge from previous experiences but by also learning on the job and excelling outside his comfort zone to bring the solution to life. Haroon worked with many different technical web development languages such as HTML,CCS and PHP to name a few.

Haroon also took part in the planning of the workshops that were to be run to show the development and progress being made on the solution to the business. Haroon was requested to run part of the workshop to run the business through the new look and feel that the Service Cloud solution would be taking. He was meet with some resistance on the way the solution was progressing and the impact the new solution would have on old processes. However through Haroon’s clear communication and persuasive manner in drawing on the benefits of the new solution the business could see the real value that would be added and agreed to continue on the path Haroon had advised.

• City Of London Corporation - Oracle BI Developer 

Haroon was brought in as a Business Intelligence Developer to help aid the closure of the City of London project. Haroon’s role was to troubleshoot in depth technical reporting and metadata issues that had been outstanding for quite some time. Alongside Haroon being brought into troubleshoot he helped in the development of the final few reports under the Property Management module. Haroon showed his true technical ability in getting all issues resolved in a quick and timely matter and liaised with the client in ensuring the fixes were implemented correctly and working as expected following the rework. Haroon’s contribution to the project proved invaluable in tying up loose ends.

• City Of London Corporation - Oracle Technical Trainer

Haroon was brought into this role due to past experience of designing, developing and managing the delivery of Oracle Technical Training. Haroon’s role was to scope out the training that was required by the client and draw up a suitable training package that would cover the clients requirements. Once the requirements were agreed upon Haroon worked as part of a two man team to develop the material that would be used for delivery. The material consisted of Slide deck’s with contextual information as well as exercises to aid the learning process. Haroon helped with the delivery of two different forms of training and both being meet with positive feedback on the improvement in the clients knowledge.

Project Experience: 

• Financial Conduct Authority - Oracle BI Functional Consultant 

Haroon played a pivotal part in the HR Transformation implementation at the FCA. Haroon’s roles varied from helping functional specing the reports that the FCA were after from becoming test lead to run the SIT testing phase at the FCA. Haroon developed more functional skills on the project which will aid him well in the future when returning back to his more technical roles. Haroon was exposed to Fusion BI giving him invaluable experience working on future Fusion projects. Haroon's more technical background proved to be a valuable asset as he was able to provide the client with extra value apart from the functional role he had been brought in to do originally.

• City Of London Corporation - Oracle BI Developer 

Haroon was part of a large team to help deliver the implementation of OBIA Financial Analytics at CoL. Haroon played a number of key roles ranging from ETL work all the way through to report building and writing up technical documentation. Haroon’s skillset evolved throughout the project giving him valuable experience in ETL work enabling him to shoulder more responsibility throughout the project. Haroon also worked well within a team environment always willing to support his senior peers as well as taking the time out to upskill his less experienced peers in tricky situations.

• Royal Bank of Scotland - Oracle BI Workshop

Haroon was brought in to help overcome some complicated reporting issues faced by the Royal Bank of Scotland. Haroon’s knowledge and experience was drawn upon to overcome the issues faced by RBS and a solution was eventually found helping RBS in creating the BI reports they were after and further increasing RBS’s knowledge in Oracle Business Intelligence

• River Island - Oracle BI Workshop/Demo

Haroon lead a small team to structure and deliver the workshop for River Island giving him valuable management experience. The workshop was to demonstrate River Islands OBIA Financial Analytics package that had been implemented. This gave River Island an understanding of the different dashboards and reports that came with there implemented package which covered Payables, Receivables and General Ledger. Alongside this a training session was provided by Haroon to upskill River Island in being able to create there own Adhoc reports going forward.

Project Experience:

• John Lewis Partnership - Oracle BI Reporting/RPD Developer

Haroon was part of a highly specialized Business Intelligence Team at John Lewis Partnership that where implementing a bespoke HR OBIEE solution. Haroon’s experiences were of a broad range:

- Haroon built numerous amounts of bespoke reports ranging from Absences, Time & Attendance, Disciplinary & Grievance and many more that made up the whole HR OBIEE package John Lewis were after. The reports as mentioned were highly customized giving Haroon wide exposure to the endless capabilities of OBIEE.

- Fixing defects of all kinds. Allowing Haroon to demonstrate his problem solving ability but also allowing him to gain a more in depth account of how to resolve specific matters within OBIEE.

- Haroon also played a pivotal part through the testing phases of the project which included: System Testing, User Acceptance Testing & Unit Testing. His role was mainly to help smoke test reports as well as fix defects that came out of the individual testing phases respectively.

- Haroon produced thorough documentation for Business-As-Usual (BAU) to allow successful knowledge transfer of the system implemented but also giving the business all they needed going forward to maintain the bespoke implementation put in place.

Overall Haroon gained invaluable client exposure and along the way learnt a lot more about the whole project life cycle and OBIEE in particular.

• 1st Class Honours