Mohammed Patel

• Involved in setting up guardrails for PowerBI within Fabric ecosystem. Transferred Fabric knowledge across to stakeholders as part of migration into Fabric.

• Built end to end Analytics solutions in Microsoft Fabric, including importing data from APIs, building pipelines, data models and PowerBI reports.

• Comfortable using PySpark in Notebooks and SQL endpoints within Fabric.

• Optimised report performance, reducing load times from 3 minutes to 30 seconds by refining queries and implementing efficient data models.

• Integrated government APIs to automate data extraction and enhance reporting accuracy and efficiency.

• Developed and delivered reports for various council areas, including waste management, highways, grounds maintenance, and neighborhood compliance.

• Ingested data from council and third-party databases, leveraging Power Query to set up robust data models that support insightful and actionable reports.

• Provided knowledge transfer through comprehensive user guides and hands-on training sessions for staff responsible for maintainingreports.

· Being part of a data migration from legacy systems to Azure Data Lake

for various parts of the council such as Finance,HR etc.

· One of my roles within this project was to map which fields and tables

were required to be migrated to build the existing reports within PowerBI.

· Building a data model within PowerBI connecting to tables in the Data

Lake which would then be used to build all the HR reporting. The model

included 40 tables so time was taken to get the tables to the correct

granularity, create the correct relationships and then add in the required

measures and calculated columns using DAX. Time was also spent on

creating transformations within Power Query.

· Being the go-to person for anything related to PowerBI and Data

modelling within the migration project, including upskilling other

members of the team by holding workshops.

· Working in an agile manner in two-week sprints with daily stand ups and

sprint reviews allowing for close communication with the project team and

wider business areas to accomplish much more in shorter time periods.

• Working as part of a data migration project from the previous system to Dynamics 365. My role within this was to build the power bi reports by establishing connections to the new platform. This involved connecting to their Business Central application which held their Financial, Sales & Procurement data.
• Building reports for various business functions such as Sales, Operations and Procurement. This involved developing key metrics such as Gross Sales, Gross Margin %, Average Order Value etc.
• Creating a reporting template and then writing JSON code to build a theme file which could be imported into new reports, replicating all visuals and formatting.

• Created a dynamic Power BI report that provides real-time visibility into Peabody's property portfolio, including property status and tenant demographics, resulting in significantly improved data accuracy and clarity compared to previous reporting methods.
• Built data models within PowerBI using a Star Schema approach, changing them from flat tables into a much more concise model. This allowed for a faster refresh by reducing processing time.
• Worked in an agile environment by using sprints to complete parts of reporting, going back to end users for feedback before implementing and continuing the loop until reports were ready to be signed off.
• Created SQL queries using SQL Server Management Studio to facilitate Power BI reports, merging data from diverse databases and tables for seamless report generation.
• Used M query within advanced editor in Power BI to create custom columns alongside setting up combine and transform queries for multiple tables.

• Conducted collaborative sessions with stakeholders to gather comprehensive requirements for the development of diverse reporting solutions, including HR-related analytics.
• Developed and implemented a wide range of complex DAX measures, aligning them with specific HR reporting requirements, including Headcount, Contracted Hours, Leavers, and other relevant metrics. Utilised Azure Analysis Services to establish a seamless connection with a live model, facilitating the creation of a comprehensive report tailored for a senior leadership presentation
• Successfully transitioned Excel reports to the Azure cloud through Azure Data Factory, encompassing the establishment of linked services, data flows, pipelines, and automated triggers for streamlined data ingestion and processing.
• Worked in an Agile manner, using sprints to complete the HR reporting in an iterative fashion by gaining feedback from end users, applying the feedback and looping back for testing in a timely manner.

• Led the development of Power BI reports for a high-impact Keystone to NEC data migration project. Leveraged SQL scripts to efficiently import data and performed data manipulation using Power Query to ensure data quality. Skillfully built robust data models and compelling visuals within the front end to enable effective data analysis and visualisation.
• Demonstrated a proactive approach by rapidly upskilling in Power BI Report Builder to proficiently create paginated versions of reports in alignment with specific business requirements.
• Engaged in direct and effective communication with stakeholders to actively gather feedback on reports, fostering iterative development cycles. Leveraged existing reports as solid foundations, addressing defects identified during User Acceptance Testing using Azure DevOps . Facilitated thorough testing by users and diligently logged and implemented necessary changes and issue resolutions, ensuring reports precisely aligned with stakeholders' evolving needs and requirements.

• Successfully led the migration of legacy reports from Business Objects to Power BI , effectively modernising reporting capabilities across diverse areas of the council.
• Maintained a consultative approach throughout the process, actively engaging stakeholders to solicit feedback and provide guidance on the progress made.
• Conducted regular and interactive Power BI workshops for permanent staff, equipping them with the necessary skills to independently manage and sustain business-as-usual (BAU) reporting processes.

• Successfully transitioned legacy reports from QlikView and BusinessObjects to Power BI, meticulously replicating their functionality and ensuring a seamless migration process while leveraging SQL and SSMS expertise to create scripts to import tables from databases into Power BI.
• Developed comprehensive financial forecasts illustrating the COVID-19 impact on rental income, considering diverse assumptions and stipulations. These were presented to senior leadership at regular intervals, enabling the business to proactively plan and adapt strategies accordingly.
• Facilitated informative Skype sessions with multiple departments, empowering them to enhance their foundational Power BI knowledge and maximize the value derived from their reports.