Muzaffar Ali Syed Email & Phone Number

Bellevue, Wa, Us

Mumbai, Mh, In

• 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.

Dallas, Tx, Us

• Developed a Project Management Web application to better facilitate new Microsoft construction projects utilizing SQL Server and integrating various Office 365 services.• Developed various PowerApps and Microsoft Flow applications.• Designed and created various databases, including financial databases.• Worked on financial reporting with different modules for whole trade flow and built a complete database for the financial system.• Created T-SQL Programming, Stored Procedures, Dashboards, SSRS Reports, SSAS Cubes, and Apps according to business requirements.• Performed indexing, performance tuning, and ensured data integrity. • Designed SSIS packages to consolidate data from various sources for the project management team.

Redmond, Washington, Us

• Designed databases and ensured their stability, reliability, and performance.• Improved application performance.• Prepared documentation for database applications.Managed memory for database systems.• Developed database schemas, tables, and dictionaries.Ensured data quality and integrity in databases.• Data modeling to optimize the power bi reports.Connecting and collaborating power bi reports with excel.• Creating the SSAS cubes and writing the MDX Queries.Design, build and deploy effective SSIS packages. Creating the logic Apps and deploying into the Azure Environment.

University Park, Illinois, Us

• Add,delete,retrieve and update the information of users.• Creating the constraints on the tables and views.• Creating the user roles.• Track the data from database for data of volunteers, homeless people, employees, donations, donors, expenditures and the actual donation.

University Park, Illinois, Us

• Documenting the lecturer notes and works which is associated to the professor.• Writing the thesis for the program management.

Ann Arbor, Mi, Us

• Designed databases and ensured their stability, reliability, and performance.• Improved application performance.• Prepared documentation for database applications.• Managed memory for database systems.• Developed database schemas, tables, and dictionaries.• Ensured data quality and integrity in databases.

Master'S Degree, Computer Science

Bachelor'S Degree, Computer Science And Information Technology