Arthur O.

Over 10 years of experience developing Business Intelligence, data analytics, and reporting solutions using SQL Server BI Stack, Power BI, Tableau, Microsoft Fabric, Azure Data Factory, Databricks, Azure SQL Database, Azure Data Lake, BigQuery, Firebase, and Google Data Studio. Experience with Microsoft Fabric orchestration and ETL development, including Fabric Pipelines, Lakehouse, Dataflow Gen2, Notebooks, Warehouse, OneLake, medallion architecture, and Bronze/Silver/Gold data processing for analytics and Power BI reporting. Experience migrating SQL databases and on-premise data sources to Azure Data Lake using Azure Data Factory, Azure SQL Database, Azure SQL Data Warehouse, Azure Data Lake Analytics, Databricks, and modern cloud data integration patterns. Experience in database design and Business Intelligence development using SQL Server 2019, SQL Server Analysis Services, DAX, MDX, OLAP Cubes, SSAS Tabular Models, Star Schema, and Snowflake Schema. Experience managing database security, controlling access, granting permissions, and supporting data governance across SQL Server, Azure SQL, Fabric workspaces, and reporting environments. Experience with Microsoft Power Apps, including integration with SQL Server tables as a data source and storage layer for business applications. Generated ad hoc reports using Excel Power Pivot, Power Query, and Power BI to support critical business decisions and stakeholder reporting. Experience with Microsoft Reporting Services, Power BI dashboards, Crystal Reports, SSRS, SQL Server on-premise reporting, and SSAS Tabular models using DAX and MDX. Proficient in building complex SSIS packages for data transformation and transferring data from multiple sources into data warehouses based on business logic. Utilized Power BI and Tableau to create analytical dashboards for tracking Sales KPIs, operational metrics, and executive-level reporting, including slicers and self-service reporting features for business users. Implemented Power BI Gateway connections to multiple data sources to support scheduled refresh, semantic modeling, Power Pivot, and Power View reporting. Performed Tableau data preparation and type conversion functions when connected to relational data sources such as Microsoft SQL Server and GitHub. Developed storytelling dashboards in Power BI Desktop and Tableau Desktop and published them to Power BI Service, Power BI Report Server, and Tableau Server for end-user consumption.