Summary
Overview
Work History
Skills
Timeline
Education
Web
Accomplishments
Certification
Volunteer

Venkat Vootla

Staff Data Engineer
Bangalore

Summary

Organized and dependable candidate successful at managing multiple priorities with a positive attitude. Willingness to take on added responsibilities to meet team goals.

Phone # +91 7207553522

Email v.venki05#gmail.com

Overview

12
12

Years of Professional xperienceE

10
10

Years of BI & DW Experience

4
4
Certificates
4
4

Years of Data Engineering

Work History

Staff Data Engineer / Product Owner

GE
Bangalore
03.2018 - Current
  • Developed and Managed 50+ Dashboards in Production
  • Created Financial Close Dashboards using Tableau / Power BI / OAS for daily, weekly and monthly reporting
  • Developed team communications and information for meetings
  • Resolved problems, improved operations and provided exceptional service
  • Large Live Connection Data Sources and Security
  • Caching / Pre-Cache Dashboards for Executive Visibility
  • Security / Access Automation for End Users
  • Developed and implemented performance improvement strategies and plans to promote continuous improvement
  • Databricks migration from GP Procedures
  • Alteryx/Dataiku for Data preparation and Data Science workflows
  • OAS Workflow and Dashboard Development
  • Sound knowledge on Data Lake, Ingestion, DQ and Process
  • Proved successful working within tight deadlines and fast-paced atmosphere
  • Actively listened to customers' requests, confirming full understanding before addressing concerns
  • Collaborated with team members to achieve target results
  • Identified issues, analyzed information and provided solutions to problems
  • Drove operational improvements which resulted in savings and improved profit margins. (Metadata API driven aproach had 40K USD savings per year)

Data Visualization Expert / Product Owner

Broadcom
Bangalore
08.2017 - 03.2018
  • Identified and documented detailed business rules and use cases based on requirements analysis
  • Translated business requirements into technical requirements
  • Monitored and troubleshot data source systems for data flaws and errors and upstream data issues
  • Attended meetings to identify risks and maintain project targets
  • Interpreted data and translated ad hoc requirements and requests to deliver relevant and impactful results
  • Data Ingestion using Spark

Data Visualization Expert

Brocade
Bangalore
08.2016 - 08.2017
  • Collaborated with business-unit leaders to identify and prioritize problems
  • Utilized data visualization tools to effectively communicate business insights
  • Implemented code solutions to answer analytic questions and test and assess new methods
  • Developed tables, views and materialized views using SQL
  • Worked with business intelligence software and various reports to glean insights into trends and prospects
  • Keep an eye on scheduled extracts and identifying Root Cause if anything fails
  • Creating hot backups and cold backups for disaster management
  • Responsible for Handling Server Patching and Upgrades
  • Assist other developers in design and implementations ensuring best practices are followed
  • Troubleshoot and diagnose critical production issues other duties as assigned

Tableau Developer

Capgemini
Bangalore
01.2014 - 07.2016
  • Understanding datasets and do reporting as business expecting
  • Selects, recommends and applies appropriate analytic and statistical methodologies and techniques to execute against an analysis plan
  • Responsible for weekly processing of Cube
  • Experience creating custom metrics and calculated sets in SSAS and Tableau
  • Interfacing with business/ client for requirement gathering and creating detailed requirements design documents
  • Extensively involved in creating FDD and TSD documents
  • Good exposure working with Promotion planning and Forecasting Volume and Revenue numbers
  • Extracting data from various business data repositories (Teradata, SQL Server, and Excel) and preparing dashboards for business using Tableau
  • Established generic data connections either Live or Data Extracts and published them to Tableau server for business slice and dice or Adhoc Reporting
  • Leverage Tableau to analyze and build reports for understanding and managing Committed and Upcoming Promotions and their KPIs
  • Working knowledge on Tableau Server / Administration.

Skills

Tableau Desktopundefined

Timeline

  • Executive Leadership Program
11-2020
  • Tableau Server Architect
05-2020
  • Tableau Data Scientist
05-2020
  • Tableau Desktop Specialist
06-2018

Staff Data Engineer / Product Owner

GE
03.2018 - Current

Data Visualization Expert / Product Owner

Broadcom
08.2017 - 03.2018

Data Visualization Expert

Brocade
08.2016 - 08.2017

Tableau Developer

Capgemini
01.2014 - 07.2016

B.E - Electronics and Communication

Anna University
06.2005 - 05.2009

Education

B.E - Electronics and Communication

Anna University
India
06.2005 - 05.2009

Web

Tableau Public

https://public.tableau.com/app/profile/venkat5345

LinkedIn

https://www.linkedin.com/in/venkat-vootla/

Accomplishments


Tableau / Power BI / Data Preparation / Performance Tuning

  • Started as Developer back in 2012, Run couple of POC's for BO to Tableau Migration
  • Work across different Version of Software and very strong knowledge to the core
  • Performing Data Modelling in Tableau Desktop and Prep
  • Resolving any data or performance issues related to workbooks and data sources
  • Coordinating with Tableau Admin Team for Production Deployment
  • Live Connection Data Sources with huge data volumes
  • Extracts wherever needed and also leveraging Hyper API as per the requirement
  • JavaScript API and REST API for Advanced Embedded Analytics and Access Automation
  • CICD workflow for Dashboard testing and deployment
  • Live connection to very large tables and data modelling very complex Data Sources
  • Handling Data Ingestion from Upstream system (GP – Singlestore)
  • Twisting SQL queries for improving performances
  • Row Level Security in Run time using middleware technology
  • Working with stakeholders for Self Service Analytics
  • RPA / Dataiku based solutions for Real time Analytics
  • Tableau Server Administration / Automation
  • Power BI Service – RLS, Workspace Access and more

OBIEE / OAS

  • Requirement’s discussion and RPD Development, Deployment
  • Dataflows for Adhoc Data Sources
  • Self Service Analytics
  • Middleware to leverage RPD for Tableau and Power BI Data sources
  • Report Performance Tuning
  • AWS / Cloud
  • Good understanding on Cloud Native Offering
  • Planning better infrastructure for 100% uptime and availability
  • Containers and Docker and Micro Services planning
  • Cloud Native solutions for cost aspects
  • Snowflake & Redshift based Dashboards in Production

Databricks / Snowflake / Data ingestion

  • Designing and implementing highly performant data ingestion pipelines from multiple sources using Apache Spark
  • Developed scalable and re-usable frameworks for ingesting of finance GL based data sets
  • Integrating the end-to-end data pipeline to take data from source systems to target data repositories ensuring the quality and consistency of data is always maintained
  • Participated in development of cloud data warehouses, data as a service, business intelligence solutions
  • Data wrangling of heterogeneous data
  • Good Understanding of Modern Data Warehouse/Lambda Architecture, Data warehousing concepts
  • Work across different Version of Software and very strong knowledge to the core
  • Worked on migrating GP based workflows / process to Databricks
  • Snowflake Tables and Views for Reporting
  • Create and choose right clusters for workload and Automation

Dataiku / Alteryx

  • Create Dataiku workflows for all Adhoc Requests from Business
  • HTML based page to capture the Event and give the results back according to the workflow script
  • Use Tabpy to integrate Dataiku and run couple of Travel based predictions and What If analysis
  • Design and develop ETL workflows and datasets in Alteryx to be used by the BI Reporting tool
  • ETL specific for creating datasets
  • Write Complex SQL queries on multiple tables using complex joins
  • Prepare technical specifications and documentation for Alteryx workflows supporting BI reports
  • Perform end to end Data validation
  • Resolving any data or performance issues related to workflows

Tableau CRM / Einstein Analytics

  • Responsible for Developing Reports, Data Preparation and Maintenance
  • Understand business needs, build, test and support BI solutions
  • Develop and maintain SFDC objects, fields, validation rules, workflow rules, process flows and visual workflows

Advanced RLS / Caching / Mobile Dashboards

  • Row Level Security with Live Connections during Run time
  • Access Automation for RLS, Dashboard, Self Service
  • ProxySQL / Heimdall Data for Middleware RLS and Caching
  • Pre-Caching the Dashboards using ProxySQL / Redis / RESTAPI
  • Mobile Dashboards for every Executive via Wrapper

Process / Agile / CICD

  • Agile Methodology for Development
  • Idea Tracking and Release Cycle
  • Change Review and Release Process
  • CICD pipelines for entire tech stack Automation

Certification

  • Tableau Desktop Specialist
Venkat VootlaStaff Data Engineer