portfolio · 2026

Abishek
Variyan Kandiyil

Lead BI Engineer  |  BI Architect

10 years turning raw data into decisions. I design enterprise-scale data platforms, modern warehouses, and self-service analytics solutions — from database architecture to executive dashboards. Based in Bangalore, working across construction tech, insurance, and agriculture domains.

Bangalore, India  ·  +91 75984 39724  ·  abishekvk.jobs@outlook.com

LinkedIn ↗ Tableau Public ↗ Blog ↗
career metrics
0
Years Experience
0
Companies
0
Hrs/yr Automated
0
Team Size Led
tech proficiency
SQL
95%
Power BI
85%
Tableau
75%
Snowflake
70%
Python
45%
core competencies

Skills & Tech Stack

Data Platforms
Snowflake SQL Server AWS Azure MicroStrategy
BI & Visualization
Power BI Tableau Data Visualisation Semantic Layer Row-Level Security
Data Architecture
Kimball Methodology Star Schema Dimensional Modeling Data Warehousing
Automation & Integration
AWS Lambda Python Excel VBA API Integration ETL Pipelines
Business Tools
Salesforce Anaplan ServiceNow Microsoft Copilot
Analytics & Analysis
Data Analysis Data Wrangling Data Pipelines Exploratory Data Analysis Text Analytics
Leadership & Process
Team Leadership Stakeholder Mgmt Data Governance Requirements Gathering
work history

Work Experience

Autodesk India Pvt Ltd Principal Analyst – Data Jul 2024 – Present
Construction Technology  ·  Sales Commissions & Operational Efficiency
  • Lead a 5-member operations team and 3-member dashboard & automation team
  • Automated Salesforce portfolio member creation using Python — 7–10 min → 1–2 min across 500+ annual requests, saving ~50 hrs/year
  • Built Excel automation templates (VBA & formulas) for sales assignments — 70% of 600+ annual requests adopted the template
  • Delivered Incident Timeline dashboard identifying SLA breach root causes; drove process improvements without adding headcount
  • Implemented Row-Level Security in Power BI semantic models for live-streaming dashboards
  • Support Salesforce and Anaplan administration for sales operations and territory management
Trimble Inc. Data Analytics Engineer Jul 2022 – Jul 2024
Construction ERP & Field Technology
  • Led a 3-member BI team, coordinating between onsite stakeholders and offshore team members
  • Designed scalable Snowflake data models and pipelines, optimizing performance for large-scale analytics
  • Led enterprise BI dashboard development using Snowflake + Power BI for executive decision-making
  • Migrated dashboards from batch to live streaming — real-time operational visibility across service teams
Tiger Analytics BI Data Engineer Feb 2020 – Jul 2022
Insurance · Pacific Life, AXA, Employers
  • Delivered Advisor Segmentation dashboard used by senior leadership to monitor insurance advisor performance
  • Led EDA using SQL and Tableau to identify clustering variables for data science team
  • Built analytics dashboards and performed quality assurance across insurance clients
Systech Solutions Senior Software Engineer Jul 2016 – Feb 2020
Agriculture Exports (OLAM) · Media & Entertainment (Fox) · Internal Product (Doppler)
  • Built end-to-end Cost & Freight analytics platform for OLAM — Kimball/Star Schema design, replacing manual Excel process saving team 2–3 hrs/day
  • Automated MicroStrategy user provisioning via batch scripts
  • Contributed scripting components to Doppler, an internal job scheduling product
projects

Project Highlights

Cost & Freight Dashboard – End-to-End
Designed and built a complete analytics platform for OLAM (agriculture exports) as sole contributor — Kimball/Star Schema database design, pipeline development, BI-ready views, and daily-refresh dashboards. Replaced a fully manual Excel process and processed 10 years of historical data.
Kimball MethodologyStar SchemaETL PipelineDashboard
Advisor Segmentation & EDA
Led EDA using SQL and Tableau to identify key clustering variables for a data science team building an insurance advisor segmentation model. Delivered multiple EDA dashboards and post-clustering visualisation dashboards used at the leadership level.
TableauSQLEDAClustering
Real-Time BI Migration & Data Governance
Led migration from batch to live streaming dashboards at Trimble using Snowflake and Power BI. Implemented Row-Level Security in Power BI semantic models to enforce data governance and control user access.
SnowflakePower BIRow-Level SecurityReal-Time
Salesforce & Workflow Automation
Automated Salesforce portfolio member creation using Python scripting — cutting processing time from 7–10 min to 1–2 min across 500+ annual requests. Also built Excel automation templates (VBA & formulas) for sales assignment workflows, adopted by 70% of 600+ annual requests.
PythonExcel VBASalesforceAutomation
KPGIS – Kerala Public Grievance Intelligence System
Designed and proposed a citizen-facing grievance tracking platform to improve government accountability and transparency in Kerala. Submitted as a voluntary public service initiative to the Chief Minister's office and individual MLAs.
Civic TechData ArchitecturePublic Policy
Incident Timeline Dashboard
Built an Incident Timeline dashboard at Autodesk that identified root causes and key factors driving SLA breaches. Helped business teams improve coordination between customer-facing and internal teams, reducing breach frequency through process improvements rather than resource additions.
Power BIServiceNowSLA AnalyticsProcess Improvement
certifications

Credentials & Learning

📊
Tableau Desktop Specialist
Tableau Software
✓ Certified · 2021
🔷
Fabric Analytics Engineer (DP-600)
Microsoft
⏳ In Progress
⚙️
Data Integration Certification
Systech Solutions
✓ Certified · 2016
personal projects

Personal Achievements

AI Integration
Claude AI + Power BI Integration

Explored and implemented an integration between Claude (Anthropic's AI) and Power BI, enabling AI-assisted analytics and natural language interaction with dashboards. A hands-on experiment in GenAI-powered BI tooling.

Claude AI Power BI GenAI API Integration
Learning & Upskilling
dbt (data build tool) Learning Path

Actively learning dbt to strengthen modern data transformation skills — covering models, tests, documentation, and Snowflake integration. Part of a broader upskilling roadmap alongside the Microsoft Fabric DP-600 certification.

dbt Snowflake Data Transformation SQL
volunteering

Beyond Work

Civic Tech Initiative
KPGIS
Kerala Public Grievance
Intelligence System
Independently designed and proposed a citizen-facing grievance tracking platform to improve government accountability and transparency in Kerala. The system routes grievances intelligently and provides data-driven visibility into resolution timelines. Submitted voluntarily to the Kerala Chief Minister's office and pitched to individual MLAs as a public service initiative — applying BI and data architecture skills toward civic impact.

Also an active contributor to civic data analysis, creating data visualisations and analytics content around Kerala governance and election data for public awareness.