Mohammad Shakeel

Freelance BI Developer / Analyst

• Job Details:Evaluated BI requirements and formalized design specifications, ensuring alignment with business needs. Designed and implemented ETL processes using SSIS to integrate data from various sources into a centralized data warehouse. Created and optimized dimension and fact tables to support business analytics and reporting needs. Developed complex stored procedures and triggers in SQL Server to enhance data processing and retrieval. Conducted performance tuning of SQL queries and SSIS packages, leading to significant improvements in load times. Created interactive Power BI dashboards for financial performance, improving budget tracking and variance analysis and leading to a 10% reduction in operational costs. Optimized data models leading to a 50% decrease in dashboard refresh times, greatly benefiting real-time decision-making processes. Optimized Power BI reports for performance, decreasing report load time by 25% through the use of DAX and Power Query. Implemented row-level security in Power BI reports, enhancing data privacy and compliance across departments. Utilized SQL and Python to perform complex data analysis, identifying trends, patterns, and anomalies in large datasets. Developed and implemented a data warehouse solution to consolidate and integrate data from multiple sources, improving data accessibility and consistency. Led the implementation of a business intelligence platform to provide real-time data insights and dashboards for key performance indicators (KPIs).

Data Analyst

• Job Details:Facilitated requirements gathering sessions, translated business needs into technical specifications, and provided training and support to ensure successful adoption of the solution. Collaborated with stakeholders to define KPIs and ensure alignment with business objectives. Designed and deployed over 20 interactive dashboards, enabling real-time insights and improving decision-making efficiency by 40%. Transitioned legacy reporting systems to Tableau, improving reporting capabilities and cutting delivery time by 25%. Optimized data models leading to a 50% decrease in dashboard refresh times, greatly benefiting real-time decision-making processes. Integrated data from multiple sources, including SQL databases, to create unified visualizations.

Power BI Analyst

• Job Details:Collaborated with stakeholders to gather requirements and deliver tailored BI solutions, boosting user satisfaction scores by 25%. Developed SQL scripts/SSIS packages to extract, transform, and load data into the data warehouse, reducing load time by 30%. Created and maintained SSAS tabular models for advanced data analytics. Created Power BI dashboards that analyzed customer purchase patterns, leading to a 10% increase in targeted marketing campaign success. Responsible for the management of Power BI assets, including reports, dashboards, workspaces, and the underlying datasets that are used in the reports. Implemented row-level security in Power BI reports, enhancing data privacy and compliance across departments. Conducted Power BI training sessions for employees, boosting company-wide adoption of the platform by 30%.