Adil Mohammed

About Adil Mohammed

With over 10 years of IT experience, I specialize in the analysis, design, development, testing, and implementation of ETL and Business Intelligence solutions using Tableau, Data Warehouse/Data Mart Design, ETL, SQL Server, Azure SQL Cloud, and MSBI tools, including Power BI.I have extensive experience designing and deploying BI solutions with SSIS, SSRS, SSAS, and Power BI. My expertise with MS SQL Server (2016, 2014, 2012) includes Business Intelligence services like SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), and SQL Server Reporting Services (SSRS).I excel in ETL processes using SSIS, DTS, Bulk Insert, and BCP, handling heterogeneous data sources (Oracle, IBM DB2, Teradata, XML) with SSIS. My SQL programming skills include creating tables, stored procedures, triggers, functions, views, indexes, and complex SQL queries.I am proficient in writing complex SQL queries and optimizing reports by modifying T-SQL and MDX queries using DMVs. I thrive in OLTP/OLAP environments and have strong data warehousing experience.Additionally, I have worked on Proof of Concepts (POCs) to migrate on-premises BI platforms to Azure Cloud and have experience with Azure Data Factory for data loads from on-premise to Azure Data Lake. In Azure, I have set up new resources and managed resource groups efficiently.I am skilled in developing parameterized reports, charts, dashboards, scorecards, and SSAS Cube reports using MDX and Power BI. My proficiency with Power Pivots, Power Queries, Power Views, and SSRS reports using the Tabular model (DAX), MDX cubes, and SQL queries enhances my ability to deliver high-quality BI solutions.I also have experience developing OLAP cubes using SSAS, defining data sources, views, dimensions, hierarchies, and calculations with MDX, and generating reports from OLAP cubes using SSRS and Report Builder 3.0.

Experience

1. Sr Power Bi Sql Developer Data Engineer Data Analyst

   Aflac Group Insurance

   Jan 2023 — Present · Miami, FL, US

   Set up and ran Power BI Environment, creating app workspaces, publishing apps, and setting up Power BI Gateway-Worked in Reconciliation of Data By Creating Different Databases-Data Integration Reconciliation-Published Power BI Reports in the required originations and made Power BI Dashboards available in web clients-Practical understanding of the Data modeling (Dimensional & Relational) concepts like Star-Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables-Utilized Power BI gateway to keep dashboards and reports up to date with on premise data sources-Developing visual reports, dashboards and KPI scorecards using Power BI desktop-Sharing of Power BI reports and managing workspaces in Power BI service-Developed and deployed scalable cloud applications using Microsoft Azure Fabric, enhancing performance and reliability-Collaborated with cross-functional teams to design and implement microservices architecture on Azure Fabric, improving system modularity-Coded and tested SQL queries based off the persistent table using Inline Views, Dynamic SQL, Merge statements-Managed application lifecycle and orchestrated services using Azure Fabric, resulting in reduced downtime and increased availability-Involved in designing and developing Data Warehouses, Data marts and Business Intelligence using multi-dimensional models such as Star Schemas and Snow Flake Schema for developing Cubes-Data management and data processing solutions using SSIS, this includes Error Handling and Slowly Changing Dimensions-Designed and implemented End-to-end Data pipelines in Databricks, integrating various data sources, performing ETL operations, and ensuring data quality and consistency-Designed complex SSAS solutions using multiple dimensions, perspectives, hierarchies, measures groups and KPIs to analyze performance of Strategic Business Units as well as corporate centers.

Education

• Osmania University, Hyderabad

  Bachelor's degree, Computer Science