Learn Data Skills
Beta
Muhammad Umair Afzal Ansari

Muhammad Umair Afzal Ansari

Data Analyst

Business Data Analyst

Technologies

My Portfolio Highlights

My New Track

Tableau Fundamentals

My New Course

Introduction to Python

My New Track

Tableau Fundamentals

Insights evangelist, spreading the gospel of data-driven decision-making.

My Work

Take a look at my latest work.

course

Introduction to SQL

course

Introduction to Python

course

Intermediate Python

course

Introduction to SQL

DataCamp Course Completion

Take a look at all the courses I’ve completed on DataCamp.

Courses

Introduction to Python
Introduction to SQL
Introduction to Power BI
Intermediate SQL

My Work Experience

Where I've interned and worked during my career.

Bank of Montreal (BMO) | Jul 2022 - Present

Business Data Analyst

o Execute, monitor, and close the Annual Engagement Survey of 56,000+ employees on the Qualtrics platform. o Produce quick data analysis and ad hoc reports for annual employee engagement projects to meet business needs. o Coordinate with cross-functional teams to design, document, and execute surveys on the Qualtrics platform. o Clean and reconcile data to resolve data integrity issues and to ensure accurate reporting and data records o Prepare Quarterly reports for life cycle surveys for senior management using Qualtrics, Excel, and PowerPoint. o Lead and perform UAT on new surveys and dashboards. o Collaborate with Qualtrics technical team for projects to meet project business and data requirements. o Maintain confidentiality of HR data and produce ad hoc reports for senior leaders and HR Business partners. o Manage data conversion and data archiving of Taleo data to Workday – requirement gathering, monitoring conversion execution, and assuring completion within time and scope. o Design and maintain project tracker to plan and monitor tasks and support BMO Recruiters in accommodating BOTW employees into new roles. o Created, documented, monitored, and executed UAT, A/B, and regression test scenarios of HR employee data conversion and process improvements in Workday using JIRA and SMARTSHEET integration. o Create weekly Bank of the West (BOTW) departure reports for the CEO, CHRO, Head of Line of Business(s), and other senior executives across Canada and the U.S. using LinkedIn Talent Insights. o Developed Workday reports to perform analysis based on business needs
Show More

Ontario Government | Nov 2019 - Jul 2022

Data Analyst

o Collaborated with lateral teams to manage the supply chain of various PPEs across the Ontario Public Sector. o Developed, updated, and maintained Power BI dashboards for different ministries and clients to monitor incoming orders, outgoing shipments, and distributor performances. o Prepared standard and ad-hoc reports for ministries and internal teams using Power BI, Excel, and PowerPoint. o Trained new hires on existing reports and dashboards, processes, software implementation, and available data analytics tools and leveraged their skills to delegate tasks. o Scheduled, tracked, and reported daily orders for Ontario’s health care providers, education boards, childcare, dental offices, and long-term care facilities.

Sysintelligence | Sep 2018 - Nov 2019

Data Analyst

o Collaborated with internal and external stakeholders to ensure the business and technical architecture of the delivered solution aligns with project requirements for manufacturing clients. o Aid in designing, setting, and testing business results reports, maintaining recurring and ad-hoc reporting, and supporting the interpretation, and troubleshooting of the underlying data using Power BI. o Developed reports for senior management (client) to streamline the implementation of pricing changes and impacts on revenue and profits using Power BI for the manufacturing/production industry. o Gathered and documented business requirements for creating data models and analytical report development. o Embedded Power BI reports for clients, managed access to reports and data using Roles, performed user acceptance testing (UAT), and provided accessibility training to stakeholders and project team members. o Developed Tableau dashboards of sales/marketing teams from ZOHO CRM and Salesforce platform.

TCS | Jan 2017 - Aug 2018

BI Analyst

o Gathered Business Requirements by conducting detailed interviews with business users, stakeholders, and SMEs. o Arranged data consolidation environment, developed recurring and ad-hoc reporting templates, and published business reports and dashboards across the organization using Power BI Services. o Utilized Excel and PowerPivot to profile data, developed quality metrics with the team, and visualized KPIs and Key Influencers using Power BI to improve customer satisfaction and service quality.

My Education

Take a look at my formal education

Bachelor's of Engineering in Petrochemical Analytics & OperationsNED University of Engineering & Technology | 2016

Powered by

  • Work
  • Courses
  • Experience
  • Education
  • Create Your Data Portfolio for Free