# sanket patel

sanket patel is a remote worker on Himalayas, Senior BI/Data Analyst at Department of National Defense, based in Canada.

Source: https://himalayas.app/@sanketpatel

```text
I build secure data pipelines and dashboards that turn complex data into operational decisions.
```

| Detail | Value |
| --- | --- |
| Availability | Open to opportunities |
| Location | Canada |
| Authorized to work in | Canada, United States |
| Job categories | Data Analyst, Business Intelligence Analyst, Data Engineer, Data Analyst, QA Analyst, Privacy Manager, Systems Analyst, Data Architect, Analytics Analyst, Data Science Analyst, Financial Data Analyst, IT Data Analyst, Data Analytics Specialist, Team Lead |
| Skills | SQL, Python, R, Java, Scala, BASH, Tableau, Power BI, DAX, Excel, SAP BusinessObjects 4.3, IBM Cognos Analytics, AWS, Azure, Google Cloud Platform, Oracle, Microsoft SQL Server, Snowflake, MySQL, PostgreSQL, Amazon Redshift, Azure Synapse, Azure Databricks, Apache Spark, PySpark, Kafka, Delta Lake, Hadoop, Apache Hive, Airflow, ETL, ELT, Data Modeling, Data Quality, Query Optimization, Docker, Jenkins, GitHub Actions, Git, Agile, Kanban, Jira, Trello, Data Governance, Statistical Analysis, A B Testing, Ggplot2, AWS Step Functions, NumPy, Pandas, Sqoop, Yarn, Databricks, Azure DevOps, JSON, XML, Amazon Kinesis, Avro, GitHub, Compiled, Amazon Athena, Apache Iceberg, S3, OneTrust, Bridges, Great Expectations, Factory, Hamilton, Microsoft Fabric, SeaBorn |

## What I'm looking for

```text
I'm looking to build secure, scalable analytics and data engineering solutions where I can lead data initiatives, develop modern cloud pipelines and dashboards, partner with stakeholders, and improve data governance and adoption.
```

## About

```text
At the Department of National Defence, I lead data initiatives across Canadian Armed Forces bases, extracting complex Oracle data, improving SQL performance by approximately 30%, and delivering 70+ interactive Tableau dashboards with role-level security.

Previously, I established Cloud Works' data function and enterprise KPIs, built reporting in Power BI, Tableau, SAP BusinessObjects, and Excel, and trained cross-functional teams on analytics and data governance. Across OpenText, Finastra, Capgemini, and Ontario's Ministry of Health, I've combined SQL, QA, data reconciliation, privacy administration, and stakeholder collaboration to improve data integrity and reporting outcomes.
```

## Experience

### Senior BI/Data Analyst (current)

Department of National Defense. Sep 2023 - Present

```text
Operated across two Canadian Armed Forces bases, advancing to a Team Lead role. Managed data initiatives using Kanban, collaborated with military personnel to gather requirements, and engineered data extraction from Oracle databases. Authored advanced SQL queries, boosted query performance by ~30%, and developed 70+ Tableau dashboards with Row-Level Security.
```

Skills: Dashboard-Development, Query-Optimization, DevOps, Oracle-SQL, SQL-Developer, Tableau, Python, R, ETL, JSON, XML, Kanban, Agile, Role-Row-Level-Security, Data-Visualization, Stakeholder-Management

### Data Analyst & Privacy Administrator

[OpenText](https://himalayas.app/companies/opentext). Aug 2023 - Sep 2023

```text
Managed enterprise-level supplier data and privacy records within OneTrust, ensuring compliance for Global Sourcing. Executed high-volume data entry, performed QA audits, and developed Power BI and Tableau dashboards to monitor compliance trends.
```

Skills: OneTrust, Power-BI, Tableau, SQL, Excel, Data-Entry, Quality-Assurance, Data-Analysis, Stakeholder-Management

### Senior Data Analyst

Cloud Works. Jan 2022 - Jul 2023

```text
Pioneered the data function as the inaugural data hire, partnering with executives to establish enterprise-wide KPIs. Championed modern analytics tools, mentored teams, and designed reporting solutions using Power BI, Tableau, SAP BusinessObjects, and Excel. Authored advanced SQL queries and led end-to-end analytics deployment.
```

Skills: Power-BI, Tableau, Business-Objects, Excel, SQL, SQL-Developer, Statistical-Modeling, Data-Governance, Mentor, UAT, Technical-Documentation

### QA Analyst & Financial Data Analyst

[Finastra](https://himalayas.app/companies/finastra). Jan 2021 - Dec 2021

```text
Executed end-to-end QA and verification for 100+ loan applications per cycle, ensuring compliance. Validated financial data integrity against IBM Mainframe systems, managed the full data lifecycle, and performed complex data reconciliation. Compiled summaries and generated daily performance reports in Excel.
```

Skills: Compliance, Quality-Assurance, Data-Validation, IBM-Mainframe, Excel, Data-Reconciliation, financial-data-analysis, SLA-Management

### Insurance Data Analyst & QA Analyst

[Capgemini](https://himalayas.app/companies/capgemini-technology-services). Dec 2018 - Jul 2019

```text
Analyzed and interpreted complex life insurance datasets, extracting financial and demographic information from physical applications. Identified and resolved data mapping discrepancies, tracked daily processing metrics, and conducted data profiling and QA audits. Managed high-volume workflows in a fast-paced environment.
```

Skills: Data-Mapping, Workflow-Management, Data-Analysis, Data-Profiler, Quality-Assurance, Root-Cause-Analysis, Excel, SLA-Management, Data-Integrity

### Systems & QA Data Analyst (Co-op)

Ministry of Health & Long-Term Care. Sep 2016 - Apr 2017

```text
Executed complex SQL queries and analyzed stored procedures in SSMS to extract and reconcile data. Conducted data integrity audits on healthcare datasets, designed test cases, and managed defect resolution. Authored technical documentation and collaborated with developers to optimize application performance.
```

Skills: Data-Integrity, SQL, Data-Analysis, Quality-Assurance, Test-Case-Design, UAT, Technical-Documentation, Healthcare-Data

### Sales Representative

EagleEye Events. Aug 2015 - Aug 2015

```text
Delivered engaging product demonstrations and collaborated within a sales team to meet weekly revenue targets. Executed direct sales strategies across diverse locations and partnered with senior representatives to learn negotiation tactics.
```

Skills: Product-Demonstrations, Negotiation, Sales, Customer-Engagement, Collaboration, Territory-Management

## Education

### McMaster University

Bachelor of Technology, Software Engineering

```text
Bachelor of Technology in Software Engineering Technology from McMaster University.
```

### George Brown College

Advanced Diploma, Computer Programming

```text
Advanced Diploma in Computer Programmer/Analyst from George Brown College.
```

## Tech stack

- Amazon Redshift
- Azure Synapse
- Apache Spark
- IBM Cognos Analytics
- ggplot2
- Microsoft Azure
- Amazon S3
- AWS Step Functions
- GitHub
- Jenkins
- GitHub Actions
- NumPy
- Pandas
- PySpark
- OneTrust
- Sqoop
- MySQL
- PostgreSQL
- Microsoft SQL Server
- Hadoop
- Yarn
- Databricks
- Azure DevOps
- Jira
- Java
- JSON
- XML
- Kafka
- Trello
- Amazon Kinesis
- Avro
- Airflow
- Compiled
- Amazon Athena
- Microsoft Power BI
- SQL
- Apache Iceberg
- Delta Lake
- Great Expectations
- Bash
- Microsoft Fabric
- Hamilton
- Bridge
- Factory
- Seaborn

To contact sanket, message them from this profile with a Himalayas employer account: [Hire on Himalayas](https://himalayas.app/hire).

## People also viewed

- [cs User](https://himalayas.app/@csuser1): Data Specialist, Medavie Blue Cross
- [Ashritha User](https://himalayas.app/@ashrithauser): BI & Data Analyst, BMO
- [Zankar Kulkarni](https://himalayas.app/@zankarkulkarni): Data Analyst, Wealthsimple
- [Adunoluwa Olutola](https://himalayas.app/@adunoluwaolutola): Data & Reporting Analyst, Agio Inc.
- [AYOMITAN ABRAHAM BATIMEHIN](https://himalayas.app/@ayomitanabrahambatim): Business Analyst, SkillHat
- [Adunoluwa Olutola](https://himalayas.app/@adunoluwaolutola1): Data & Reporting Analyst, Agio Inc.
- [Dhruti Gaudana](https://himalayas.app/@dhrutigaudana): Senior Data Analyst, AIonix11
- [Henil Gadhiya](https://himalayas.app/@henilgadhiya): Reporting Analyst, Air Canada
- [Steven Henein](https://himalayas.app/@stevenhenein): Manager of Data Governance and Analytics, VON Canada
- [opeyemi kayode](https://himalayas.app/@opeyemikayode): Data Analyst / Data Analytics, Genpact
