Muhammad Haroon Ashfaq
Business Intelligence Consultant
- West Midlands
Haroon is an Oracle Business Intelligence and Oracle Data Integration Specialist. He currently sits within the Oracle Reporting Architecture and Strategy stream at PwC. Leveraging his deep technical abilities with his client experiences - he designs solutions befitting a client’s reporting needs. Haroon has both a strong functional and technical skillset, with a sound foundation of experience in the requirements gathering, design, development and support of various applications including the OBI Stack and Oracle E-Business Suite R12. Haroon has spent the past few years with over eight different clients and programmes of work focusing on the planning, delivery, implementation and support of reporting solutions in a diverse range of markets.
The BI/DW Lead Developer will deliver the technical 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
- Provide expert knowledge regarding the implementation of Oracle’s pre-built “Business Intelligence Applications” solution, which consists of a pre-built dimensional warehouse specifically designed to hold ERP and HR data, with pre-built ETL routines to populate the warehouse from Oracle cloud systems, a pre-built metadata dictionary and a suite of prebuilt reports and dashboards across Finance, procurement, projects, HR and Payroll data.
- Leading on the design, implementation and extension of the delivered Oracle data warehouse to incorporate additional Research data from other University systems, and any other data sources identified within the scope of the New Core project.
- Working closely with the IT data stream develop ER diagrams and map the source data into data warehouse objects.
- Provide 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).
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
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.
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.
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.
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.
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.
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.
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
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.
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.
Haroon’s career with Argos has been a long one which has seen him through his university life. Haroon has built many interchangeable skills that have matured him as a person but given him the ability to communicate clearly with different kinds of individuals.
Haroon is valued as a senior member of staff within the Argos team and on numerous occasions has been called upon to train others due to his efficient work ethic and performance within the store. Even though Haroon may not have reached a management position within the company due to university restricting his time that didn’t stop him being used as a Customer Services Manager and taking control of the store when required on many occasions.
Haroon is mainly used as a customer services advisor due to his versatility to adapt to different situations but also to deal with problems in the most efficient way possible to keep both parties happy. Another reason for Haroon being kept within the customer service area is his ability to work under the extreme pressures that come with being in a customer service based role.
Haroon worked at the website design people for just over a year as part of his degree doing an industrial placement. During his time with the company he learnt a range of different skills and web design languages that made him a professional designer. Haroon also learnt how to maintain content management systems for existing client websites that the company was maintaining.
Haroon’s involvement within the company wasn’t just to design websites but from time to time take on a sales role to walk in customers and see how the packages the company offered could suit the customer’s needs. Haroon also maintained communication throughout the project with the clients and constantly liaised with them regarding their product until the final delivery.
Haroon worked at the printing people for just under a year as part of his degree doing an industrial placement. During his time with the company he learnt a range of different graphic designing skills that eventual made him a professional graphic designer. Along the way Haroon learnt about many different software packages such as Adobe Master Collection CS5.5 and Corel Draw.
Haroon also had the response ability of looking after the sales for the company and liaising with customers about design specs and the process of getting the design finalised before being sent off to print.