Summary
Overview
Work History
Education
Skills
Websites
Accomplishments
Certification
Languages
Timeline
Generic

Anil Gorantla

Parker,CO

Summary

Data Engineer and Business Intelligence professional with 11+ years of experience designing cloud-native ETL pipelines, scalable data models, and analytics solutions. Expertise across Azure Data Factory, Databricks, Power BI, and Qlik Sense, with a strong foundation in SQL optimization, data governance, and visualization. Skilled at bridging BI development and Data Engineering, delivering insights that drive executive decision-making and enterprise.

Overview

14
14
years of professional experience
1
1
Certification

Work History

Lead Data & Sr. BI Engineer

Arrow Electronics, INC
04.2018 - Current
  • Developed Qlik Sense/QlikView dashboards with optimized data models and advanced Set Analysis.
  • Designed star and snowflake schemas to support analytical reporting across business units.
  • Built QVD layers (raw → transformed → presentation) for incremental refresh and performance optimization.
  • Built Power BI dashboards using DAX, Power Query, Dataflows, and Gateways.
  • Developed Qlik Sense dashboards, ensuring data accuracy and reliability, and effectively communicated technical concepts to non-technical stakeholders.
  • Designed and implemented ETL pipelines using Azure Data Factory and Databricks notebooks (Python/Scala).
  • Wrote and optimized SQL queries (Teradata, Oracle, Azure SQL, Hadoop), improving query performance by reducing redundant joins and tuning indexes.
  • Developed cloud-native pipelines with Azure Data Factory + Databricks (Python/Scala/Spark) for ingestion and transformation at scale.
  • Designed cloud-based ETL frameworks to support enterprise-wide analytics and self-service BI.
  • Leveraged Azure services (ADF, Databricks, Power BI Service, Power Platform, Power apps) for end-to-end analytics lifecycle management.
  • Optimized pipeline and query performance through partitioning, indexing, and advanced tuning.
  • Delivered high-performance, scalable data solutions that improved speed, reliability, and availability of analytics.
  • Applied data governance through Azure AD groups, RLS, and secure access models.
  • More than 10+ years in developing front-end reporting in Qlik Sense.

Qlik Developer

Horizon Advanced Systems Inc
03.2015 - 04.2018
  • Created QVD layers (raw, transformed, presentation) to optimize load times and reusability and for incremental load strategies, reducing data refresh time.
  • Developed advanced Set Analysis expressions and visualizations to enable self-service analytics.
  • Configured Section Access for role-based security and governed access.
  • Implemented Direct Discovery for real-time querying of big data sources.
  • Optimized dashboards using data reduction, minimized synthetic keys, and optimized joins.

Genentech
04.2015 - 05.2016
  • Migrated legacy QlikView applications to Qlik Sense, improving UI/UX and scalability.
  • Created QVD layer architecture (raw → transformed → presentation), enabling incremental refreshes and reducing load times.
  • Automated data refreshes using Qlik Publisher, ensuring timely data delivery.
  • Worked in Agile Scrum teams, ensuring on-time delivery of BI solutions.

SAP Basis Consultant

Tata Consultancy Services (TCS)
12.2011 - 12.2013
  • Installed, configured, and upgraded SAP R/3 & Java systems on Windows environments.
  • Integrated SAP with multiple databases including HANA, Oracle, MySQL.
  • Managed SAP system migrations and performance tuning.

Education

M.S. - Computer Science

University of Central Missouri
Warrensburg, MO
12-2014

B.E. - Electrical & Electronics Engineering

R.V.R. & J.C.
04-2011

Skills

  • Data Engineering: Azure Data Factory, Databricks (Python/Scala/Spark), ETL, Data Warehousing, Hadoop
  • Business Intelligence: Power BI (DAX, Dataflows, RLS), Qlik Sense/QlikView (QVDs, Set Analysis, Scripting, NPrinting), Tableau
  • Databases: Azure SQL, Teradata, Oracle, SQL Server, MariaDB
  • Cloud & DevOps: Microsoft Azure, GitHub, Bitbucket, Flex Deploy, CI/CD
  • Automation: Shell Scripting, VBA, Power Automate Flows

Accomplishments

  • Reduced BI dashboard refresh time by 40% through incremental load strategies in Qlik and Power BI.
  • Streamlined ETL processes with ADF + Databricks, cutting data processing time from hours to minutes.
  • Improved executive decision-making by delivering self-service analytics platforms to 500+ users.

Certification

  • [Area of certification], [Company Name] - [Timeframe]
  • Certified [Job Title], [Company Name] - [Timeframe]
  • [Area of certification] Training - [Timeframe]
  • [Area of expertise] License - [Timeframe]
  • Licensed [Job Title] - [Timeframe]

Languages

English
Full Professional

Timeline

Lead Data & Sr. BI Engineer

Arrow Electronics, INC
04.2018 - Current

Genentech
04.2015 - 05.2016

Qlik Developer

Horizon Advanced Systems Inc
03.2015 - 04.2018

SAP Basis Consultant

Tata Consultancy Services (TCS)
12.2011 - 12.2013

M.S. - Computer Science

University of Central Missouri

B.E. - Electrical & Electronics Engineering

R.V.R. & J.C.
Anil Gorantla