Abdul Raheem Mohammed Email and Phone Number

Participated in business analysis, the collection of ETL, data modelling, and Business intelligence requirements, and documentation of physical and logical data models and mapping.Designed and created several Integration packages and business-related data marts. Processed departmental data requests and created applications to provide customer data reports. Created ETL test data for all ETL mapping rules to test the functionality of the SSIS Mapping. Developed detailed ETL and ELT… Show more Participated in business analysis, the collection of ETL, data modelling, and Business intelligence requirements, and documentation of physical and logical data models and mapping.Designed and created several Integration packages and business-related data marts. Processed departmental data requests and created applications to provide customer data reports. Created ETL test data for all ETL mapping rules to test the functionality of the SSIS Mapping. Developed detailed ETL and ELT Test Plan, Test Resource Utilization and Close Down document for multiple data engineering and business intelligence projects. Understand business requirements in BI context and design data models to transform raw data into meaningful insights by visualising the data using Power BI. Analysing data and present data through reports that aid decision-making Convert business requirements into technical specifications and decide timeline to accomplish requirements. Created multiple data model and used as a common data source for the reporting purpose. Used Power BI Gateways to keep the dashboards and reports up to date. Show less

Developed several Azure DataFactory re-usable parameterised pipelines, linked services and activities with parameterization techniques which can be used to cut down development time. Designed and developed ETL mappings for data sharing between interfaces utilizing SCD type 2 and CDC methodologies using Azure Data Factory, T-SQL stored procedures. Analysed business requirements, data mapping specifications and developed Test Plans, Test Cases, expected Results and Prioritized tests for… Show more Developed several Azure DataFactory re-usable parameterised pipelines, linked services and activities with parameterization techniques which can be used to cut down development time. Designed and developed ETL mappings for data sharing between interfaces utilizing SCD type 2 and CDC methodologies using Azure Data Factory, T-SQL stored procedures. Analysed business requirements, data mapping specifications and developed Test Plans, Test Cases, expected Results and Prioritized tests for the BI and Data Engineering solutions. Compared the actual result with expected results. Validated the data by reverse engineering methodology i.e. backward navigation from target to source. Create and maintain BI models for designing, developing, and generating standard and ad-hoc reports using Power BI Desktop, DAX, Power Query Create insightful BI based reports to monitor and highlight contributing factors to financial and operational variances and anomalies helping the executives in key decision making. Publish the reports, schedule reports using gateways, and create and manage groups, users, workspaces, Data sources and data connections in the Power BI services. Used T-SQL in constructing User Functions, Views, Indexes, Triggers, Common Table Expressions, Sub Queries, Relational Database Models, Data Dictionaries, and Data Integrity. Show less

Responsible of gathering requirements from various teams, functional users and determining the best method and practices to present and visualise data using Power BI. Responsible for creating SQL datasets for Power BI reports and Ad-hoc reports and expert on creating multiple kinds of Power BI Reports and Dashboards. Create dashboards and interactive visual reports using Power BI to Identify key performance indicators (KPIs) with clear objectives and consistently monitor those metrics… Show more Responsible of gathering requirements from various teams, functional users and determining the best method and practices to present and visualise data using Power BI. Responsible for creating SQL datasets for Power BI reports and Ad-hoc reports and expert on creating multiple kinds of Power BI Reports and Dashboards. Create dashboards and interactive visual reports using Power BI to Identify key performance indicators (KPIs) with clear objectives and consistently monitor those metrics. Developed and maintained Business Intelligence solutions that meet the evolving business growth, and tells a story visually about the business using Power BI Distributing and Sharing dashboard across enterprise using Power BI Services, enabling permissions to users, Managing ownership and scheduling datasets for reporting. Worked on different resource, activities, packages with various types of transformation tool like: Lookup, derived column, join and conditional split, pivot, unpivot Perform the Unit testing after the development. Support Designing the Reports as per client Requirement and created the reports using Power BI and SQL Server database. Show less