imran siddiqui

Consistently successfully migrated clients to Azure Cloud and Power BI, reducing costs by 30% and increasing client satisfaction by 40%. Designed and implemented efficient migration plans using Azure Migrate, resulting in a 25% improvement in processes while training and mentoring a team of 10 to enhance productivity. Leveraged Azure Cost Management strategies to achieve an average of 20% client cost savings. With a proven track record of leading large, cross-functional teams, I specialize in developing and implementing innovative Business Intelligence and Cloud solutions. Highly skilled in communication, negotiation, and addressing complex technical challenges, I excel at building strong stakeholder relationships, driving consensus across organizational levels, and fostering collaboration among diverse team tiers.

Professional Experience

US Air Force (Dayton, OH/ Remote) – Sr Azure BI Solution Architect Oct 2024 – Present

• Architected and led the deployment of secure, enterprise-grade Azure data platforms, integrating SAP BusinessObjects 4.3 SP04, Power BI, and Power Platform components for unified analytics. Leveraged Azure Synapse, Data Factory, and Databricks to drive scalable data transformation, real-time integration, and decision intelligence with cybersecurity-aligned controls.
• Expertise in designing scalable, modular data architectures that incorporate both Data Lakes and Data Warehouses, optimized for hybrid cloud environments and aligned with zero trust principles and FedRAMP security baselines.
• Created conceptual, logical, and physical data models to support enterprise data strategies across structured, semi-structured, and unstructured sources, ensuring adaptability and system resilience.
• Proficient in Microsoft Fabric ecosystem, including Lakehouse, Dataflows, Pipelines, and Notebooks, integrating seamlessly with Azure Data Lake Gen2, SQL Database, Synapse, and Azure ML Studio to deliver governed, end-to-end analytics solutions.
• Engineered high-performance ETL/ELT pipelines using Azure Data Factory, Synapse Pipelines, and Databricks, enabling real-time streaming and batch data ingestion from ERP, CRM, and third-party cloud systems.
• Built and governed Azure Data Lake platforms, implementing Unity Catalog, data lineage, access control, and metadata management frameworks, ensuring data quality, PII/PHI de-identification, and compliance with NIST, FISMA, and HIPAA standards.
• Developed and enforced robust data governance policies, integrating data catalogs and lineage tools to improve discoverability, reduce duplication, and ensure secure role-based access.
• Enabled MLOps with secure CI/CD pipelines using MLflow, Azure ML, and DevSecOps practices, ensuring model traceability, controlled deployments, and continuous monitoring.
• Tuned complex ETL workflows, optimized semantic models, and improved query performance in Power BI and SAP BO environments through caching strategies, partitioning, and index management.
• Translated complex business requirements into scalable technical solutions, serving as the primary technical liaison to stakeholders and clients across cloud migration, BI modernization, and AI/ML analytics initiatives.
• Led full-scale migration to modern data platforms, transitioning legacy systems to cloud-native architectures such as Microsoft Fabric, Azure Synapse, and Databricks, with minimal business disruption and full compliance assurance.
• Designed and implemented Microsoft Fabric-based analytics frameworks, combining real-time streaming, data pipelines, and Power BI Embedded to deliver secured, context-rich dashboards and insights to business and federal clients.

Solano County (Fairfield, CA/Remote) - Azure Cloud BI Development & Architect Oct 2023 – Aug 2024

• Partnered with business stakeholders to gather requirements and define Business Requirement Documents (BRDs) for data analytics solutions.
• Architected modern data solutions using Microsoft Azure PaaS services: Azure SQL Managed Instance, Data Factory, Synapse, Data Lake, HDInsight, and Snowflake CDW.
• Designed and implemented full-stack Power BI dashboards, complex DAX KPIs, and multi-level drill-through visualizations, enabling strategic performance measurement and operational analysis.
• Led cloud migrations from on-premises SQL Server BI infrastructure to Azure Cloud, improving scalability and reducing operational costs.
• Built and optimized ETL/ELT pipelines, data warehouses (Star, Snowflake), and data marts using ADF, Azure Synapse, Azure SQL, and Databricks.
• Developed dimension and fact tables, custom Power BI dataflows, and Analysis Services models for enterprise-wide reporting.
• Implemented dynamic Row-Level Security (RLS), custom gateways, and secure Power BI environments with user-specific data views.
• Managed Azure network architecture, including VNets, subnets, firewalls, and Load Balancers, deploying IaaS and PaaS resources in secure zones.
• Created Databricks notebooks for advanced transformation, feature engineering, and ingestion of structured/unstructured data.
• Developed BI visualizations using QlikView, OBIEE/OAS, Tableau, and ThoughtSpot, integrating real-time data and cross-platform filtering.
• Automated end-to-end QlikView solutions, from ETL scripting to dashboard distribution.
• Performed data wrangling and analytics using SAS Studio, Enterprise Guide, Alteryx, and PROC SQL, supporting statistical analysis and reporting.
• Delivered SLA monitoring dashboards and breach alert systems in CRM with custom Power BI reports.

CMS.Gov Centers for Medicare & Medicaid Services (Remote) - BI Data Architect     Dec 2022 – Sept 2023

• Designed and led enterprise-scale data architectures using Azure Data Stack (ADF, Synapse, Databricks), Snowflake Cloud Data Warehouse, and Power BI, driving real-time analytics, ETL/ELT workflows, and scalable BI dashboards.
• Architected end-to-end BI and analytics solutions, managing stakeholder engagement, sprint planning, and delivery using Agile/Scrum methodologies and Azure DevOps CI/CD pipelines.
• Integrated and automated workflows with ServiceNow, enabling efficient ITSM data reporting and ticket analytics through embedded Power BI and Snowflake connectors.
• Migrated legacy on-prem systems to cloud-native environments across Azure and Snowflake, enhancing scalability, performance, and data security through VNets, ExpressRoute, and RBAC policies.
• Delivered Power BI dashboards, implementing complex DAX measures, RLS, dataflows, and multi-tiered visuals to track financial KPIs, SLA performance, and executive insights.
• Led Learning Management System (LMS) training programs, building onboarding documentation, BI workshops, and end-user guides to support enterprise adoption of tools like Power BI, SSRS, and Tableau.
• Designed robust data models and warehouse architectures (Star, Snowflake, OLAP/OLTP) using Erwin, Visio, and TOGAF, supporting high-volume data environments and business-driven analytics.
• Engineered ML pipelines using Azure ML, Databricks, PySpark, and Spark SQL, deploying models into production with automated data ingestion and transformation workflows.
• Developed ETL/ELT solutions using SSIS, Informatica, and Azure Data Factory, integrating diverse data sources into governed repositories with full data lineage and quality frameworks.
• Utilized Apache Flink for stream and batch processing, and Python for scripting and automation across Hadoop-based data lakes and hybrid cloud ecosystems.
• Built and optimized SQL, PL/SQL, T-SQL, MDX, and DAX queries, SSAS cubes, and Power BI datasets to support interactive dashboards and enterprise-level data visualization.
• Mentored junior developers, conducted gap analysis, led cross-functional teams, and ensured alignment of technical solutions with business objectives

Navy Federal Credit Union IT Architect (Azure Data Engineer Development Architect – Synapse Analytics) SEP/2021 –Nov 2022

• Partnered with business stakeholders to gather requirements and define Business Requirement Documents (BRDs) for data analytics solutions.
• Architected modern data solutions using Microsoft Azure PaaS services: Azure SQL Managed Instance, Data Factory, Synapse, Data Lake, HDInsight, and Snowflake CDW.
• Designed and implemented full-stack Power BI dashboards, complex DAX KPIs, and multi-level drill-through visualizations, enabling strategic performance measurement and operational analysis.
• Led cloud migrations from on-premises SQL Server BI infrastructure to Azure Cloud, improving scalability and reducing operational costs.
• Built and optimized ETL/ELT pipelines, data warehouses (Star, Snowflake), and data marts using ADF, Azure Synapse, Azure SQL, and Databricks.
• Developed dimension and fact tables, custom Power BI dataflows, and Analysis Services models for enterprise-wide reporting.
• Implemented dynamic Row-Level Security (RLS), custom gateways, and secure Power BI environments with user-specific data views.
• Managed Azure network architecture, including VNets, subnets, firewalls, and Load Balancers, deploying IaaS and PaaS resources in secure zones.
• Created Databricks notebooks for advanced transformation, feature engineering, and structured/unstructured data ingestion.
• Developed BI visualizations using QlikView, OBIEE/OAS, Tableau, and ThoughtSpot, integrating real-time data and cross-platform filtering.
• Automated end-to-end QlikView solutions, from ETL scripting to dashboard distribution.
• Performed data wrangling and analytics using SAS Studio, Enterprise Guide, Alteryx, and PROC SQL, supporting statistical analysis and reporting.
• Delivered SLA monitoring dashboards and breach alert systems in CRM with custom Power BI reports.

CMS.GOV (Federal Government Project) Medicare & Medicaid, Baltimore, Maryland

SENIOR BI Development and Architect, 9/2013 – 09/2021

Key Accomplishments: Served as a Subject Matter Expert (SME) in healthcare fraud, waste, and abuse data, as well as analytics support for government agencies.

• Provided data integration architecture and strategy advice for Data Lake/Hadoop-based BI solutions.
• Designed and deployed production-ready Data Pipeline Architecture Solutions under the IT Technology Business Delivery Department.
• Developed and published Power BI dashboards, implementing advanced DAX functions and maintaining up-to-date reports using Power BI Gateway.
• Configured and maintained Azure DevOps pipelines for automated builds and deployments.
• Created comprehensive Tableau dashboards and Excel reporting tools to provide critical insights into cybersecurity and business-impacting events.
• Migrated SAP BusinessObjects enterprise environments from version 3.1 to 4.3, delivering over 230 reports, 10 major universes, and 4 dashboards.
• Implemented SAP best practices and IT services management processes, adhering to architecture governance standards.
• Served as a Scrum Master and Solution Architect, leading sprint planning, daily stand-ups, and task sequencing to ensure efficient project execution.
• Provided cloud architecture guidance and implemented Snowflake solutions for scalable data warehousing and analytics.
• Led cloud migration projects, transitioning on-premises applications to AWS and Azure environments, ensuring minimal disruption and maximum efficiency.
• Designed and implemented Learning Management Systems (LMS) utilizing modern cloud-based solutions, resulting in a 40% improvement in training outcomes.
• Applied Agile methodologies to streamline project delivery and enhance team collaboration, increasing efficiency across multiple projects.
• Ensured compliance with Section 508 accessibility standards for all reporting and BI solutions, enabling broader usability.
• Developed advanced data management strategies, leveraging cloud-native tools for efficient data governance and lifecycle management.

MS Computer Science / MBA IT Management, WGU UT, USA