Experienced business analysis professional. Designed and developed end-to-end data pipeline and business intelligence solutions. Conducted in-depth analytics to identify underlying opportunities and risks. Provided insightful analysis and actionable recommendations to cross-functional groups to support strategic business decision making.
• 5+ years of hands-on expertise in end-to-end data pipeline, data visualization, business intelligence and analytical solutions from gathering business requirements, solution design, data modeling to dashboard development.
• In-depth understanding of business requirements and metrics. Solid understanding of data modeling such as tabular semantic model. Demonstrated ability to identify business and technical impacts of business requirements and incorporate them into data modeling and design.
• Strong problem solving, data analysis and communication skills. Ability to identify key business drivers and convert findings into dashboard visualizations to help business owners to understate business performance, underlying risks, and opportunities.
• Proficient in SQL, Power BI, SQL Server Analysis Services (SSAS) and SQL Server Integration Services (SSIS). Experience with Azure Analysis Services (AAS).
• Advanced user of Power BI, Power Pivot, and Excel.
• Experienced Software Engineer with a demonstrated history of working in the computer software industry Report Development (SSIS,SSRS,SSAS) and Performance Tunning.
• Expert in creating Packages, SSRS Reports, TSQL queries using tools like MSSQL, creating Jobs,alerts and
schedule for SSIS packages in sql server Agent.
• Highly Proficient in using TSQL for developing Complex Stored Procedures,Triggers,Tables,Views,
User Functions, Relational Database Models and SQL Joins.
• Strong Experienced in Relational Database and Datawarehouse (SSAS),Design CUBE With Dimensional Model(Star Schema, SnowFlake Schema)and also Perform the operations on OLAP CUBE,Also Knowledge about Slowly Changing Dimension(SCD), Conformed Dimension,Junk Dimension,Bridge Table ,Factless Fact Table.
• Expertise in Dataset ,expressions and functions for the reports In SSRS.
• Hands-on Experience In MDX Expressions, DAX Expressions, Power BI, Power Pivot, and creating Dashboards in Power BI Visualization tools.
• Strong engineering professional graduated from National Textile University, Faisalabad.