Experience

DBD International

• United Kingdom
• Business Consulting and Services
• 1 - 100 Employee

• Power BI Developer

  • Oct 2021 - Present

  • Designed and Developed Data warehouse for the NTS, EM and CDE project and created series of SQL tables, views and stored procedure to support Power BI Reports. • Designed and developed Power App for the modelling team to create new and update existing scenarios. The Power App was also used to delete and archive unwanted data/scenarios in the database. • Strong analytical skill with data modelling experience and a history of managing Extract, Transform, Load (ETL) processes using SSIS and ADF (Azure Data Factory). • Exported files from Anylogic are deposited/saved to a shared OneDrive Folder which is automatically copied onto blob storage • Created Azure Blob Storage for Import/Export data to/from Azure SQL DB • Created and managed of data pipelines, transformation, and efficient storage • Built monitoring and alerting mechanisms for data pipelines and transformations • Liaised with clients/Management for requirement /Specification for Dashboards and reports. • Created Paginated reports which allows users to display all the data in a table even if the table spans multiple pages. • Power BI expert with complex DAX coding and strong understand of Power BI architecture for optimising setup and performance • UX/UI expertise in creating amazing PBI visuals using Zebra BI Chart, Tables, sophisticated filtering, dynamic visuals, drill-thru, drill-down etc. • Ensured that solution exhibits high levels of performance, security, scalability, maintainability, reusability, and reliability on deployment • Parameterised Power BI data sources that enables users to switch from one database to another (Development dB, Test dB and Production dB) • Power BI Deployment Pipeline to have a Dev, Test and Prod dB whole lifecycle inside Power BI. • Created a Visual Tooltip in Power BI - Makes Consumers really go wow • Published Power BI Report from Power BI Desktop to Power BI Service. Show less



Betsi Cadwaladr University Health Board

• United Kingdom
• Hospitals and Health Care
• 700 & Above Employee

• Business Intelligence Developer

  • May 2021 - Aug 2021

  • Gathered, analysed, designed and delivered requirements for reports from stakeholders using Power BI • Developed the trust recovery six point plan report that helps to manage capacity and demand using power BI • Developed a robust Theatre, Cohort (1&2), Inpatient and Outpatient Activity report using power BI. • Designed, developed and maintained stored procedures, views, constraints and indexes • Advanced understanding of the DAX (Data Analysis expressions) language in Power BI - using DAX functions, creating DAX columns and measures over data models for the purpose of enhancing Power BI visuals • Modelled and Analysed data based on users’ requirements using Power BI • Automated Daily, Weekly and Monthly reports in power BI • Used Power BI Gateways to keep the dashboards and reports up to date • Installed and Configured Enterprise Gateway and Personal Gateway in Power Bi Services Show less



Swale Heating Limited

• United Kingdom
• Utilities
• 100 - 200 Employee

• BI Developer

  • Jun 2019 - May 2021

  • Developed new and update/optimizing existing stored procedures to implement new business logic and processes to support Power BI, SSRS reports • Designed, developed and maintained stored procedures, views, constraints and indexes • Good knowledge on Sub queries, Joins, set operations and stored procedures • Performance tuning to minimise run time of processes • Monitor SQL Agent jobs to ensure they are functioning as expected • Migrated on-premises SQL Server instance to Azure SQL Database and granted different levels of accesses to different users. • Excellent in creating SSIS Packages for integrating data using OLE DB connection from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all • Scheduled and monitored the SQL Server Agent jobs to run the SSIS packages and stored procedures • Migrated Daily activities report from excel to Microsoft SQL server and Power BI based report • Advanced understanding of the DAX (Data Analysis expressions) language in Power BI - using DAX functions, creating DAX columns and measures over data models for the purpose of enhancing Power BI visuals • Modelled and Analysed data based on users’ requirements using Power BI • Built dynamic dashboards to reflect KPIs, using SQL and Power BI • Rewrote Crystal query in Microsoft SQL server. Mapped the necessary dimensions and facts table • Validated pre-loaded and post-loaded data • Solid experience using MS SQL Server Integration Services (SSIS) for data integration • ETL, data cleaning, governance and scheduling • Design SSIS packages; define destination fields, map and match incoming data types etc. to avoid errors/failover, apply conditional split and other package definitions to ensure safe migration • Migrated data from multiple legacy systems into Microsoft SQL server using SSIS package Show less