Looking for a job

Ammar Shahid

@ammarshahid

Message

Turning data into information and information into insights.

Canada

Message

I bring to the table 6+ years of Business Intelligence & Data Analysis experience. I provide value added insights in the form of analysis, interpretation and by developing enthralling reports and dashboards to visualise situations and make well-informed decisions.

Experience

Current

Data Analyst

Current

Bukhatir Group

Aug 2019 - Present (4 years 9 months)

- Responsible for the Data Management and BI solutions using Microsoft BI Stack

- Optimized Tabular & Multi-Dimensional model refresh time process from 70 Minutes to 15 Minutes by partitioning various data models, achieving an overall 80% improvement in Efficiency

- Identified and recommended Process Improvements that boosted sales by 18% over a quarter in 2021

TSQL DAX Data Modeling PowerBI SSIS SSAS

Salesforce Administrator

Conmix

Aug 2017 - Nov 2018 (1 year 3 months)

- Maintained and Administered Salesforce across the organization

- Maintained the sales cloud, as well as built custom reports and dashboards

- Managed users, data, and security

- Performed database maintenance tasks, database de-duping and cleanup

- Provided Salesforce training and end-user support

- Assisted end users to develop and fine-tune reports so that they yield meaningful metrics

Salesforce Analysis Salesforce CRM

Jnr. Data Analyst

Bukhatir Education Advancement & Management Intl

Nov 2018 - Aug 2019 (9 months)

- Performed BI & Data Analysis for marketing, HR, IT, academic and other departments

- Used SQL Server Integration Services (SSIS) to create ETL packages to load data to data warehouse databases

- Defined and deployed tabular and multi-dimensional cubes using SQL Server Analysis Services (SSAS)

- Implemented dynamic row level security in all report modules for different levels of users in SSAS

Microsoft Power BI TSQL MS Excel