Muzaffar Ali Syed

About Muzaffar Ali Syed

As a highly skilled BI and Data Engineer with 6+ years of experience in Microsoft Business Intelligence Technologies, including Power BI, SSIS, and SSRS, I possess extensive knowledge and expertise in dealing with Relational Database Management Systems like SQL Server. Additionally, I have expertise in Power BI report development and tenant administration, as well as a good understanding of Azure Cloud Platform and Office 365 administration. I am also proficient in building and maintaining ADF pipelines and have been trained in T-SQL, M-Query, Kusto Query, and DAX.As a team leader, I have excellent problem-solving and communication skills, with a proven track record of delivering excellent results and effectively meeting deadlines. I am passionate about leveraging my skills and experience to create innovative solutions that enhance business processes and improve data reporting.

Experience

1. Senior Power Bi Technical Specialist

   LTIMindtree

   Mar 2019 — Present · Bellevue, WA, US

   Analyzing business requirements and creating software requirement specifications. • Involving in creating Power BI reports and custom dashboard templates based on user inputs. • Perform quality assurance checks for enhancement of the developed artifacts. • Creating flawless and optimized data models using Power BI, SSMS, Excel, ADLS, ADF for Business users to consume data. • Creating and Managing On-Premises Data Gateways to setup connections between cloud services and On-Premises Data Sources. • Ensuring proper Fail over mechanism and load balancing by creating several child gateways under a single gateway. • Scheduling and delivering updated reports to business users based on their ask. • Managing Power BI Administration from both Power BI Service side and Azure Portal side. • Assigning permissions and report access based on user roles,setting up new users in Azure Active Directory. • Creating and Managing Premium and Embedded capacities. • Monitoring the capacities using Premium Utilization metrics app to avoid any throttling or overload. • Development and Maintenance of ADF Pipelines, ADLS Gen 2 Accounts and Azure SQL DB’s. • Using Kusto Queries to retrieve error information from the Azure Log Analytics and Power BI error log using Azure Data Explorer. • Developing scripts in Power Shell to call the Rest APIs to perform CURD Operations. • Developing and updating technical and low-level design documentations for training purpose. • Resolving escalated, complex technical user issues on the Azure/Power BI Platform and delivering Technical Support to help resolve the issue and identify the Root cause. • Automation of manual activities to minimize execution effort and increase productivity using tools like PowerApps and Microsoft Flow. • Act as a technical advisor for team of 10 members and ensuring all the SLAs are promptly met and deliverables are deployed on time. • Collaboration with various business and technical teams to understand data and requirements.

Education

• Jawaharlal Nehru Technological University

  Bachelor's degree, Computer Science and Information Technology

  2010 — 2014

• Governors State University

  Master's degree, Computer Science

  2016 — 2017