Open to opportunities

sanket patel

@sanketpatel

Message

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

Canada

Message

What I'm looking for

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.

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

Work history, roles, and key accomplishments

Current

Senior BI/Data Analyst

Current

Department of National Defense

Sep 2023 - Present (2 years 11 months)

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.

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

Aug 2023 - Sep 2023 (1 month)

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.

OneTrust Power BI Tableau SQL Excel Data Entry Quality Assurance Data Analysis Stakeholder Management

Senior Data Analyst

Cloud Works

Jan 2022 - Jul 2023 (1 year 6 months)

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.

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

QA Analyst & Financial Data Analyst

Finastra

Jan 2021 - Dec 2021 (11 months)

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.

Compliance Quality Assurance Data Validation IBM Mainframe Excel Data Reconciliation financial data analysis SLA Management

Insurance Data Analyst & QA Analyst

Capgemini

Dec 2018 - Jul 2019 (7 months)

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.

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 (7 months)

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.

Data Integrity SQL Data Analysis Quality Assurance Test Case Design UAT Technical Documentation Healthcare Data

Sales Representative

EagleEye Events

Aug 2015 - Aug 2015 (0 months)

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.

Product Demonstrations Negotiation Sales Customer Engagement Collaboration Territory Management