Ghulam Sarwar

Plays various strategic, technical and supporting roles to develop and deliver end to end BI and Analytics solutions.
EXPERIENCE
Senior Business Intelligence and Analytics Consultant Sep. 2010 – Jan. 2024
Global Smart Decisions Incorporated
• Key Clients: Designed and developed thousands of BI and data solutions for following clients: GAC Group Holding Ltd.,
DALIAN Enterprises Inc., Coradix Technology Consulting, Ontario Shores Centre, Emera Energy, Medavie Blue Cross,
Park Indigo, RIET, Dewan Drilling Ltd., and Dewan Petroleum Ltd.
• Business Impact: Directly and indirectly improved business profitability by 22%, customer satisfaction by 45%, business
performance by 40%, operational time efficiency by 30%, and operational cost by 35% by implementing enhanced, effective
and efficient BI and data solutions.
• BI and Data Solutions: constructed and delivered following solutions: static reports, interactive dashboards, self-service
analytics, data visualizations, data warehouses, data integration tools, ETL/ELT processes, predictive analytics, prescriptive
analytics, statistical modeling, data governance tools, data security solutions, data masking & anonymization, embedded
analytics, EDW bus matrix, SSIS ETL solutions, ADF pipelines, SSAS solutions, SSRS solutions, dimensional data models,
BRDs, and business process re-engineering.
• BI Tools & Frameworks: leveraged following BI tools, platforms and systems: Oracle, MySQL, PostgreSQL, Microsoft
SQL Server, Snowflake, Amazon Redshift, Google Big Query, Microsoft Azure Synapse Analytics, Informatica PowerCenter,
Talend Open Studio, IBM DataStage, Microsoft SSIS, SSMS, SSRS, SSAS, Azure Data Factory, Power BI Data Flows,
Microsoft Power BI, Tableau, Qlik, Domo, Zoho Analytics, Python (Matplotlib, Seaborn), R (ggplot2), JavaScript (D3.js),
Google Charts, SPSS, R, Python (pandas, stats models), RapidMiner, Weka, Salesforce Einstein, Microsoft Azure Machine
Learning, Amazon SageMaker, Google Cloud AI Platform, Jupyter Notebook, RStudio, Apache Spark, Python (NumPy,
pandas), Apache Hadoop, Apache Spark, Informatica Data Governance, IBM Watson Knowledge Catalog, Microsoft
Purview, McAfee Data Loss Prevention (DLP), Palo Alto Networks Prisma Cloud, Microsoft Defender for Cloud, Azure
AD, Cherwell, SQL, Python, DAX, MDX, Power Query, C++, R, Ralph Kimbal and Bill Inmon Data Warehousing
Methodologies, and frameworks such as TOGAF, ITIL, Zachman, COBIT, Agile, Scrum, DevOps, IIBA.

Increased operational efficiency by 15% and sales conversion by 20% for Emera Energy by implementing a data-driven inventory management system using Power BI and predictive analytics.
Developed and deployed interactive dashboards for Medavie Blue Cross, enabling real-time monitoring of key performance indicators and driving data-informed decision-making.
Designed and built a data warehouse for RIET, consolidating data from multiple sources and improving data accessibility and analysis capabilities.
Led a team of analysts in the development and implementation of BI solutions for clients across various industries, including finance, healthcare, and manufacturing.