Summary
Overview
Work History
Education
Skills
Certification
Timeline
Generic
Ankur Singh

Ankur Singh

Vancouver,Canada

Summary

Dynamic Senior Consultant in Data and AI with 7+ years of experience delivering actionable insights using Microsoft Azure tools like Fabric, Data Lake, Synapse, Databricks, and Power BI. Expertise in data governance with Purview and developing metadata-driven pipelines. Proven track record in building data platforms for enhanced reporting capabilities and informed decision-making across diverse industries, including Oil & Gas, Finance, Insurance, Mining, and Healthcare. Skilled at translating complex business requirements into scalable technical solutions while optimizing data workflows for accuracy and efficiency.

Overview

12
12
years of professional experience
1
1
Certification

Work History

Senior Consultant, Data & AI

Avanade
Vancouver, Canada
03.2019 - Current
  • Led the development of a comprehensive data platform for an insurance brokerage firm, including designing data architecture, creating metadata-driven ADF pipelines, transforming data in Databricks using PySpark, and building fact and dimension tables for Power BI reporting.
  • Set up and managed Unity Catalog and Purview for governance and compliance, ensuring secure data access and lineage across platforms.
  • Led efforts on Microsoft Fabric for an oil and gas logistics company, transforming data using Azure Data Factory and Databricks, and designing a Power BI semantic model using SQL for enhanced reporting. This POC was completed in 4 weeks, showcasing Fabric capabilities and receiving great recognition.
  • Contributed to the migration of Dynamics 365 Finance and Operations data to Azure Data Lake in CDM format, then transformed this data using PySpark in Databricks for reporting, ensuring 99.9% data availability.
  • Led Power BI and Azure Synapse reporting for a mining company. Extracted data to Azure Data Lake, utilized Synapse pipelines, and created a data model in Synapse using SQL for Power BI reports. Managed Synapse pipelines, data models, and led the offshore team in report development.
  • Facilitated the migration of 100 TB of data to SharePoint for a banking and financial services client, creating SQL views for status reporting in Power BI.
  • Led cross-functional teams to align business needs with technical solutions, overseeing data architectures, pipelines, and reporting tools.

Data Analyst

Alex Solutions (Tech Startup)
Melbourne, Australia
07.2018 - 10.2018
  • Gathered log data from clients who implemented Alex's Metadata Management tool, cleaned and transformed the data using Python into a more readable format, and built Tableau dashboards for senior management to track feature usage.
  • Researched and implemented emerging technologies to enhance Alex's scanners and data lineage capabilities.
  • Built POCs to demonstrate data lineage to clients, showcasing value, and facilitating customer buy-in.

Business Development Manager

DeyTec Solution LLC (Startup)
Noida, India
09.2012 - 08.2016
  • Led new business acquisition in the US IT Staffing sector, establishing key client relationships and consistently driving revenue growth.
  • Managed and expanded existing partnerships, ensuring high client satisfaction and long-term collaboration through tailored solutions and ongoing support.
  • Led continuous training and development for the team, enhancing skills to meet evolving business and client demands, while playing a key role in setting up a new office location. Led recruitment, infrastructure setup, and ensured seamless operational integration across multiple locations.

Education

Master of Information Systems -

University of Melbourne
Australia
12.2018

Bachelor of Computing Science -

Thompson Rivers University
07.2012

Skills

  • SQL
  • Python/PySpark
  • Microsoft Power BI
  • Microsoft Fabric
  • Microsoft Purview
  • Databricks
  • Azure Synapse Analytics

Certification

  • Microsoft Certified: Fabric Analytics Engineer Associate
  • Microsoft Certified: Azure Data Engineer Associate
  • Databricks Certified Data Engineer Associate
  • Microsoft Certified: Azure Enterprise Data Analyst Associate
  • Microsoft Certified: Azure Power BI Data Analyst

Timeline

Senior Consultant, Data & AI

Avanade
03.2019 - Current

Data Analyst

Alex Solutions (Tech Startup)
07.2018 - 10.2018

Business Development Manager

DeyTec Solution LLC (Startup)
09.2012 - 08.2016

Master of Information Systems -

University of Melbourne

Bachelor of Computing Science -

Thompson Rivers University

Similar Profiles

CREATE PROFILE
Ankur Singh