Muhammad Fayyaz Talib
Tampa
Summary
Experienced Business Intelligence Architect specializing in Power BI development and advanced analytics solutions. Proven track record in leading migrations to Power BI, enhancing performance and user adoption while delivering real-time insights that drive informed decision-making across organizations.
Overview
1
1
Certification
18
18
years of professional experience
Work History
Business Intelligence Architect
Liberty Mutual Insurance
11.2021 - Current
- Led BI platform migrations to Power BI, successfully transitioning from Cognos and Tableau, improving performance and increasing user adoption.
- Designed and implemented semantic models to support extensive data processing, enhancing ad-hoc reporting efficiency and enabling real-time insights.
- Optimized data refresh processes for large-scale semantic models using incremental refresh and partitioning, reducing refresh times by 60%.
- Managed datasets exceeding 1 billion rows in DirectQuery mode and over 500 million rows in Import Mode, improving overall query performance.
- Utilized tenant reporting apps to analyze Power BI usage, identifying and addressing performance bottlenecks.
- Set up and monitored Enterprise On-premises Gateway and Premium capacity, ensuring optimized connectivity and performance.
- Developed technical documentation through reverse-engineering SAS code, improving knowledge transfer and reducing onboarding time for new team members.
- Led requirement gathering sessions, translating complex business needs into implementable solutions.
Senior Business Intelligence Analyst
PwC
Tampa
12.2018 - 11.2021
- Designed and implemented seamless connectivity between Snowflake & Redshift with Power BI using DirectQuery and optimized Import mode for large-scale reporting, enabling real-time analytics.
- Developed and managed SSAS tabular models to support advanced data analytics and reporting.
- Designed, developed, and maintained reports in SSRS and Power BI, ensuring accurate and timely data delivery.
- Created and fine-tuned T-SQL queries and stored procedures, improving performance and functionality for data processing.
- Transformed and modeled MongoDB data in Power BI, enabling effective visualization and analysis for enhanced decision-making.
- Collaborated with management, decision-makers, and stakeholders to understand business requirements, performing data analysis that provided leadership with critical reports for Tax Reporting System and Contract Reporting System.
BI Analyst
Revlon
NY
08.2012 - 11.2018
- Engaged with management, decision-makers, and stakeholders to analyze business requirements, delivering leadership reports and analyses, including KPIs and dashboards for informed decision-making.
- Collaborated with business users to gather and analyze requirements, ensuring alignment between technical solutions and business needs.
- Executed end-to-end project cycles, encompassing extraction from OLTP systems, transformation, loading into data warehouse, and SSRS reporting to streamline data processes.
- Designed, developed and optimized new SSIS packages.
- Created SQL queries, stored procedures and functions to retrieve data from Dynamics AX 2012 database.
- Oversaw BI daily batch job cycle, resolving production issues to maintain operational continuity.
Database Development Lead
Netsol Technologies
07.2008 - 08.2012
- Developed secure web-based applications providing financial institutions and government agencies with real-time access to critical information for credit risk management.
- Implemented solutions for assessing credit worthiness of borrowers, enabling financial institutions to make informed lending decisions and mitigate default risk.
- Led a team of developers to design, develop, and maintain client applications, ensuring timely delivery of high-quality software solutions aligned with client requirements.
- Developed Test Planning and Test Strategy documents to ensure comprehensive coverage and alignment with project goals.
Education
Masters - Computer Science
Institute Of Management Sciences
Lahore, PakistanSkills
Certification
- Microsoft Certified: Power BI Data Analyst Associate
- Microsoft Certified: Fabric Analytics Engineer Associate
Timeline
Business Intelligence Architect
Liberty Mutual Insurance
11.2021 - Current
Senior Business Intelligence Analyst
PwC
12.2018 - 11.2021
BI Analyst
Revlon
08.2012 - 11.2018
Database Development Lead
Netsol Technologies
07.2008 - 08.2012
Masters - Computer Science
Institute Of Management Sciences