Hi, I'm Zarana. I turn data into decisions.

> Data Analyst

Results-driven Data Analyst with 5+ years of experience across Banking, Healthcare, SaaS, and Enterprise domains — building dashboards, pipelines, and data models that drive measurable business value.

✦ View Projects Ask the AI about me ⬇ Download Resume
SCROLL TO EXPLORE ↓
01CAREER TIMELINE

Five years of building data trust across industries.

From requirements gathering to executive dashboards — a journey across Banking, Insurance, and Healthcare data.
Jan 2024 — Present
Data Analyst
National Bank, Canada
Analyzed financial, transactional, claims, risk, and portfolio data to support underwriting and investment decisions. Built ETL/ELT pipelines with Azure Data Factory, Databricks, dbt, and Airflow. Delivered executive dashboards in Power BI, Tableau, and Looker for KPI tracking and risk analytics.
SQLSnowflakeAzurePower BIPython
May 2018 — Dec 2023
Data Analyst
GVT Software Solutions, Ahmedabad, India
Delivered business and technology solutions across Banking, Insurance, Healthcare, and Enterprise domains. Led requirements gathering, BRD/FRD/user stories, executive dashboards, and KPI reporting while driving Agile delivery and stakeholder alignment.
ExcelPower BISQLAgile/ScrumJIRA
02SKILLS GALAXY

A living constellation of capabilities.

Every node is a tool I reach for in production — from querying to dashboarding to pipeline orchestration.
GALAXY.EXE · DATA STACK
SQL Python Power BI Tableau Snowflake Azure ADF Databricks dbt Airflow Looker DAX Fabric
SELECT A NODE

Hover any node to see where it shows up across financial reporting, ETL pipelines, and dashboard missions.

Querying
BI / Visualization
Warehousing
Pipelines / Infra
03PROJECT COMMAND CENTER

Missions, not screenshots.

Each card is a real engagement — the data problem, the stack used, and the business outcome it drove. No mockups, just shipped analysis.
MISSION 01 · BANKING
Financial Risk & Portfolio Analytics
Built SQL and Snowflake-based pipelines covering claims, risk, and portfolio data to support underwriting and investment decisions for finance and risk teams.
SQLSnowflakeAzure SQL
MISSION 02 · DATA ENGINEERING
ETL/ELT Pipeline Modernization
Designed and automated ETL/ELT pipelines using Azure Data Factory, Databricks, dbt, and Airflow — ensuring reliable data integration, transformation, and warehouse loading.
Azure Data FactorydbtAirflow
MISSION 03 · BI & REPORTING
Executive KPI Dashboard Suite
Developed interactive dashboards and executive reports in Power BI (DAX, Power Query), Tableau, and Looker for financial reporting, revenue, and risk analytics.
Power BITableauLooker
MISSION 04 · DATA QUALITY
Data Profiling & Reconciliation Engine
Performed data profiling, cleansing, validation, and root cause analysis using Python (Pandas, NumPy) and Snowflake — maintaining high data quality and regulatory compliance.
PythonPandasNumPy
MISSION 05 · PROCESS AUTOMATION
Workflow & Reporting Automation
Automated reports and business workflows using Power Automate, REST APIs, Python, and scheduling tools — significantly reducing manual reporting effort across teams.
Power AutomateREST APIsPython
MISSION 06 · BUSINESS ANALYSIS
Requirements & Stakeholder Delivery
Led requirements gathering, BRD/FRD/user stories, gap analysis, and UAT across Banking, Insurance, and Healthcare domains — translating business needs into scalable solutions.
BRD/FRDAgile/ScrumJIRA
04DEVELOPER TERMINAL

For the people who'd rather type.

A real command interface. Try help, skills, experience, or projects — it actually runs.
ZARANA@OS: ~/ZARANASOLANKI.GITHUB.IO
ZARANA.OS shell — type "help" to begin.
zarana@os $ ▍
// OPEN A CONNECTION

Let's build something worth reporting on.

Open to full-time and contract data analyst roles. The fastest way to reach me is email — I reply to everything thoughtful.

✉ Email me +1 365-996-4757 ↗ LinkedIn
Home⌂ Timeline⏱ Skills◈ Projects▣ Terminal▤ Contact✉