Roshail Khan

Roshail Khan - |-| linkedin.com/in/muhammad-roshail-khan Education Ghulam Ishaq Khan Institute of Science and Technology KPK, Pakistan Bachelor of Software Engineering Aug. 2016 – July 2020 Experience Power BI Developer January 2024 – Present Systems Limited Remote • Led development and support for the data platform • Developed PowerShell Script for file transfer from on-premise to Azure Blob Storage • Developed PowerShell scripts for transferring files from one server to another • Implemented ADF Event-Driven Triggers for near real-time parsing of XML files • Developed Delivery & BOL Documents using report builder, giving users near real-time access to documents, increasing operational efficiency by 75% • Created Budget Variance report using Power BI to identify the difference between Utilized & Allocated Budget • Assisted in Power Apps implementation with Power BI for user-input data analysis to identify Items and their respective quantities need for production • Develop aggregated data warehousing models for the financial department Power BI/Azure Developer Aug. 2023 – Jan 2024 Creo Technologies Remote • Led migration of on-premise data platform to Azure Cloud • Developed and maintained pipelines using Azure Synapse • Integrated data from various source systems e.g. SAP, Salesforce, Big Query, On-Premise Database, File System • Used Azure Data Lake storage to maintain data in different layers (Bronze, Silver) in the form of parquet & delta files • Utilized Mapping Data flows for schema implementation & incremental loads for delta tables • Implemented data flows for transforming and sinking data into a Gold layer • Configure different schedules to refresh data at various frequencies (15 mins, hourly & nightly refresh) Database Developer July 2021 – Dec 2023 Systems Limited Remote • Developed and managed end-to-end pipelines using Azure Data Factory • Refreshed data various at frequencies to assist business in their operations • Created pipeline to extract data from INFOR M3 ERP system using Compass API with Azure Data Factory • Stored data in different layers (Landing, Curated, Serving) • Implemented parameterized Stored Procedure to handle curation for each entity • Collaborated with the team to build a data warehouse on SQL Database hosted on Azure VM • Utilized Mapping Data flows for schema implementation & incremental loads for delta tables • Leverage Power BI to develop reports & dashboards for the Operations department • Utilized Power BI to identify shortages in Product Quantities to assist the operations team in appropriate planning • Developed Income Statement and Balance Sheet in Power BI to streamline financial department processes Data Engineer Systems Limiteds • Utilized Power BI for examining technical support tickets • Transformed XML files into CSV using Python • Created Azure Timer Function for file retrieval every 30 mins • Acquired proficiency in Azure Services and foundational knowledge of SQL and Power BI Jan. 2021 – June 2021 Remote Projects Sciensus Limited | Data Pipelines (ADF), Data Warehousing, Power BI, RCA July 2021 – Dec 2021 • Engaged with team to integrate diverse data sources into a unified data platform using Azure Data Services • Integrated Data from various sources (D365 F&O, CE, CRM, Manual Files) • Collaborated with the reporting team to successfully migrate over 100 reports to the cloud data platform • Enhanced data accuracy up to 95% by conducting Root Cause Analysis (RCA) of reported bugs • Devised 30+ National Healthcare Key Performance Indicators (KPIs) to drive overall business improvement • Implemented data models for data warehouse using Azure Synapse Dedicated SQL Pool • Developed transformation queries to incorporate complaints data into Facts & Dimensions using Azure Data bricks • Created Stored Procedures for SQL Server Reporting Services • Constructed Tabular Model in Analysis Services • Developed complex DAX formulas tailored to specific business use cases • Generated dashboard in Power BI for Supply Chain tracking • Utilized Power BI to highlight High, Medium & Low-Risk Patients, mitigating delay in delivery of medicinal dosage Technical Skills Data Integration & Pipelines: Azure Data Factory (ADF), PowerShell Scripting (File Transfer), Azure Synapse Analytics Data Warehousing: Azure Data Lake Storage (Bronze, Silver, Gold Layers), SQL Database (Azure VM), Data Warehouse Modeling (Facts & Dimensions) Business Intelligence & Data Analysis: Power BI (Report Development, Dashboards, DAX Formulas), Python (Data Transformation - XML to CSV), SQL (Foundational Knowledge) Cloud Platforms: Microsoft Azure (Azure Blob Storage, Azure Timer Function) Other: Root Cause Analysis (RCA), Data Quality Improvement Development Tools: Azure Databricks (Transformation Queries), SQL Server Reporting Services (Stored Procedures), Analysis Services (Tabular Model) Version Control: Familiarity with version control systems, implied by working with data pipelines and data warehouses Certificates Academy Accreditation - Databricks Lakehouse Fundamentals Awards Star of 2nd Quarter at Systems Limited for the year of 2022