Open to opportunities

Zarana Solanki

@zaranasolanki

Message

I’m a Senior Data Analyst who turns complex data into actionable insights across banking, healthcare, and SaaS.

Canada

Message

What I'm looking for

I’m looking for a team where I can deliver end-to-end analytics—requirements to dashboards—using strong SQL, ETL/ELT, and data governance. I want Agile/Scrum collaboration, clear KPIs, and the chance to turn insights into measurable business impact.

I’m a results-driven Data Analyst with 5+ years of experience delivering data-driven solutions across Banking, Healthcare, SaaS, and Enterprise domains. I focus on transforming complex data into actionable business insights through strong SQL, data modeling, ETL/ELT, and data quality practices.

At National Bank (Canada), I analyze financial, transactional, claims, risk, and portfolio data using SQL (T-SQL, PL/SQL), Snowflake, and Azure SQL to support underwriting and investment analysis. I build ETL/ELT pipelines with Azure Data Factory, Databricks, dbt, and Airflow, and I deliver interactive dashboards and executive reporting in Power BI, Tableau, and Looker for KPI tracking, P&L, revenue, and risk analytics.

I also lead data profiling, cleansing, validation, reconciliation, and root-cause analysis with Python and Snowflake to maintain high data quality and regulatory compliance. Previously as a Research Analyst at GVT Software Solutions, I strengthened my business-to-technology translation skills through requirements gathering, stakeholder management, UAT, JIRA-driven delivery, and executive reporting—so I can partner effectively in Agile/Scrum environments and deliver scalable analytics solutions.

Experience

Work history, roles, and key accomplishments

Current

Data Analyst

Current

National Bank

Jan 2024 - Present (2 years 6 months)

Analyzed financial, transactional, claims, risk, and portfolio data to support underwriting, investment analysis, and financial reporting. Built ETL/ELT pipelines and dashboards, and performed data profiling, cleansing, validation, reconciliation, and root-cause analysis to maintain data quality.

Research Analyst

GVT Software Solutions

May 2018 - Dec 2023 (5 years 7 months)

Delivered business and technology solutions across banking, financial services, insurance, healthcare, and enterprise domains. Conducted requirements gathering, stakeholder/UAT activities, and analytical reporting using SQL and Power BI to support data-driven decision-making.