Abdul Aahad Siddiqui
Chicago,IL
Summary
Experienced BI Engineer proficient in end-to-end BI lifecycle, including data acquisition, transformation, visualization, and reporting. Skilled in optimizing data warehouses, ETL processes, and data models for complex analytics. Expertise in Power BI, Tableau, and QlikView for interactive dashboards. Hands-on experience with AWS and Azure for scalable BI solutions. Strong analytical skills, committed to continuous learning and staying updated on emerging BI technologies.
Overview
9
9
years of professional experience
Work History
Business Intelligence Engineer 2
Microsoft
06.2022 - Current
- Collaborating with different team members & teams to gather & analyze business requirements that aid to improve Data Accuracy & Efficiency
- Designed Data Models & Dashboards using Power BI, DAX, SQL Server & publishing the reports to Power BI Service
- Engineered and Administrated – Storage, Execute as Expected Cycle Time, MEIO – Warehouse to Live Actuals, Warehouse to Dock Cycle Time, to the Supply Chain Team
- Providing Power BI Solutions Training to team members working on different Dashboards across Supply Chain Team
- Worked with Power Automate for Automation of Business Processes such as triggering automated cloud flow for automation of emails
- Configuring Incremental Refreshes to refresh data daily for Business reports that have been delivered to Workspaces
Power BI Developer
Apex Systems
12.2021 - 12.2022
- Managed Power BI Service as an Administrator to maximize performance, configuring gateways, and creating workspaces
- Developing solutions to transform reports in the Legacy Environment into new & up-to- date tools that businesses can help utilize & make an impact for business related inquiries/decisions
- Validated Data to ensure accuracy of metrics and information for consumption of business leaders
- Used SharePoint to manage documents, collaboration, and meet deadlines
- Modeling Data in Power BI to perform combined analytics and publishing to Power BI Service
- Experienced in utilizing Data Bricks collaborative environment for collaborative development and streamlined deployment of Apache Spark-based workflows.
Power BI Developer
United Airlines
06.2019 - 11.2021
- Led team efforts in gathering, analyzing, and converting business requirements into robust database solutions, covering all aspects from architecture to implementation.
- Modeled data in Power BI for combined analytics, implementing features like incremental refresh and publishing reports to Power BI Service, enhancing data accessibility and performance.
- Conducted workshops and training sessions for Business Users and Power Users on Power BI, empowering them to leverage BI tools effectively for data-driven decision-making.
- Designed and implemented data warehousing solutions using Azure Synapse, enabling efficient querying and analysis of large datasets, and utilized Smartsheet for workflow management and SharePoint for document collaboration to streamline project operations.
Power BI Developer
FM Global
02.2019 - 05.2019
- Developed and maintained a comprehensive data model integrating multiple sources, applying transformation rules to convert raw data into actionable business insights.
- Designed and implemented robust security measures, including row-level and role-based security, ensuring controlled access to sensitive data within the BI environment.
- Utilized Power BI to import data from various sources, creating visually appealing reports, dashboards, and KPI scorecards to meet organizational requirements.
- Automated tasks and job scheduling through the implementation of data access stored procedures and triggers, optimizing efficiency and reliability in report generation processes.
Power BI Developer
Camber
03.2017 - 10.2018
- Proficient in importing and integrating data from diverse sources into Power BI to develop dynamic, well-organized reports and dashboards supporting strategic decision-making.
- Extensive experience in Azure environment projects, extracting data from SQL Server, storing it in Azure SQL Server via Blob Storage, and creating insightful reports using Power BI Desktop.
- Skilled in advanced data transformations within Power BI, including calculated columns, relationship management, measures creation, and various data manipulation techniques, enhancing data analysis capabilities.
- Expertise in Data Analysis Expressions (DAX) for accessing data directly from tabular SSAS databases, enabling deeper insights and analysis in Power BI reports.
BI Developer
Neo Tech
04.2016 - 02.2017
- Utilized SQL Server Reporting Services (SSRS) to create a variety of reports including Drill-Down, Drill-Through, and various chart types, enhancing data visualization for stakeholders.
- Implemented SSIS packages to efficiently load data into Staging, Operational Data Store (ODS), and dimensional model, leveraging control flow and data flow items for data transformation and loading.
- Designed and optimized Dimensions using T-SQL programming and created Indexes for performance enhancement of complex stored procedures, ensuring efficient data retrieval.
- Proficient in DAX queries within Power BI Desktop and extracted data using SSIS from OLTP to OLAP, facilitating the generation of daily, weekly, and monthly reports for managerial decision-making.
MBI Developer
Bank of America
04.2015 - 03.2016
- Led planning and design phases for data structures, documenting requirements and solutions for clarity.
- Developed and optimized T-SQL scripts, including Stored Procedures and User Defined Functions, to implement complex business logic and enhance database performance.
- Implemented database optimization techniques such as index creation and performance monitoring, resulting in improved performance for statistical reporting.
- Automated ETL processes and day-end operations through the creation of jobs in SSIS and SQL Server Agent, ensuring timely execution of critical tasks.
Skills
- Data Warehousing
- Power BI
- Tableau
- DAX
- SQL
- Azure Data Factory
- Azure Synapse
- Azure DevOps
- GitHub
- Data Bricks
- Power Automate
- Power Apps
Environment
Microsoft Power BI
Microsoft SQL Server
Jira
GitHub
Confluence
Azure
AWS
Languages
English
Native or Bilingual
Timeline
Business Intelligence Engineer 2
Microsoft
06.2022 - Current
Power BI Developer
Apex Systems
12.2021 - 12.2022
Power BI Developer
United Airlines
06.2019 - 11.2021
Power BI Developer
FM Global
02.2019 - 05.2019
Power BI Developer
Camber
03.2017 - 10.2018
BI Developer
Neo Tech
04.2016 - 02.2017
MBI Developer
Bank of America
04.2015 - 03.2016
Similar Profiles
Catalina DinuCatalina Dinu
Senior Technical Support Engineering Manager at MicrosoftSenior Technical Support Engineering Manager at Microsoft
TONY HAUGENTONY HAUGEN
Partner Customer Account Manager / Customer Success Account Manager at MicrosoftPartner Customer Account Manager / Customer Success Account Manager at Microsoft
Denis MazurovDenis Mazurov
Senior Software Engineer at MicrosoftSenior Software Engineer at Microsoft
Shubham SinghShubham Singh
Software Developer II (Level 62) at MicrosoftSoftware Developer II (Level 62) at Microsoft
Jason FigueroaJason Figueroa
Firefighter at ELK MOUNTAIN HOTSHOTS Mendocino National ForestFirefighter at ELK MOUNTAIN HOTSHOTS Mendocino National Forest