A competent Insight Activator with year of expertise in Data Analytics and Business Intelligence. Experience in client requirement analysis | physical | logical modeling | development | debugging | testing | deployment |…
A competent Insight Activator with year of expertise in Data Analytics and Business Intelligence. Experience in client requirement analysis | physical | logical modeling | development | debugging | testing | deployment | support and maintenance of business application using MSBI Stack (SQL | SSIS | SSAS | SSRS and Power BI). Extensive knowledge of Data Warehouse/Data Mart concept and expertise in Data Modeling for OLAP and OLTP systems from designing to deployment with Relational | Tabular and Multi-Dimensional modeling using Star | Snowflake Schema approach. Proficient in creating Store Procedures | Views | Triggers | and Complex queries in MS SQL Server. Having expertise in Big Data domain include Hadoop | Hive Query.
Analyzing the Business problem by understanding the customer’s business, identifying the objective, requirement gathering, and Designing and Implementing the best solution that addresses the customer’s objective.
🔳 Writing T-SQL, SQL scripts, and queries.
🔳 Manage SSIS packages, and SSAS OLAP, develop packages and cubes on business owner requirements.
🔳 Build and maintain Dashboard and Reports using Power BI and SSRS.
🔳 Uses modeling techniques and tools in analyzing and data structure in large & complex data sets.
🔳 Data Analyzing, processing, Transformation, and visualization using Power Bi.
Client: Bank Alfalah (5th Largest Bank of Pakistan)
Administered SQL Server-based data pipelines to streamline and optimize data flow for Business Intelligence purposes.
Executed a Power BI strategy optimizing data analysis, processing and visualization, leading to a 30% decrease in processing time and enhanced decision-making capabilities.
Managed SSIS and SSAS OLAP, innovating packages and optimizing cubes for a 15% boost in business intelligence efficiency.
Streamlined and optimized Power BI dashboards, leading the development of over 10+ new reports for enhanced data visualization and analysis.
Conducted thorough analysis of APR, MPR and Expense data layouts in MS SQL Server, yielding a significant 15% efficiency gain.
Engineered dashboards presenting real-time budget, MTD, and YTD metrics, elevating strategic planning in MPR.
Applied advanced expertise in Data Analysis and Business Intelligence, culminating in a commendable 20% enhancement in overall process efficiency.
Applied data analytics for international client-focused enhancements.
Utilized data analytics for Ecommerce, emphasizing user experience and business intelligence.
Created dashboards for tracking key performance indicators.
Collaborated with the Data Analytics team on projects, including database development and migration.
Main responsibilities: ETL, Data Warehousing, Reporting/Dashboarding, and Process Automation.
Collaborated with cross-functional teams to implement efficient data solutions.
Expertise in data modeling, RDBMS, ETL tools, and SQL Server Reporting Services (SSRS).
Developed and maintained performance dashboards and data warehouses.
Applied process automation techniques to streamline data workflows.
The AI-first Recruitment Operating System that unifies and automates the entire hiring lifecycle for modern enterprises worldwide.
Dr Job FZ LLC. 2026 © All Rights Reserved
