Summary
Overview
Work History
Education
Skills
Additional Information
Timeline
Generic
TEJAS BALLAMWAR

TEJAS BALLAMWAR

Lead Data Analyst
Pune

Summary

Accomplished data analyst, recognized with star performer awards, having 8 years of proven expertise in data transformation, visualization, governance and analysis. I am adept at delivering end to end BI and reporting solutions in intense and challenging roles. A go-getter having excellent engagement & presentation skills, I am seeking a challenging role in Business Intelligence domain

Overview

8
8
years of professional experience
7
7
years of post-secondary education

Work History

Lead Data Analyst

Barclays
Pune
09.2020 - Current
  • Gathering business requirements by interacting with mid, senior management and transforming that into technical requirements/use cases; setting priorities, deadlines etc
  • Using proficiency in SQL/Python to do data cataloging, analysis, validation and signoff
  • Identifying source systems, understanding business process
  • Defining implementation and validation approach, doing data discovery and mappings for making life of delegates, data engineers simpler and easier
  • Creating advanced Tableau visualizations with special focus on performance tuning to showcase KPI analysis of Product evolution/performance, billing, utilization, Inventory details and financial service by using filters, parameters and calculations, LODs, aggregations and all tableau features
  • Providing revenue and utilization forecasts, baselines and predictive analysis for Barclays billing and commercial services using Tableau, Python and SQL
  • Managing and delivering E2E BI/reporting solutions by facilitating collaboration and providing technical guidance/coaching
  • Creating data management processes, data quality controls and doing trend/variance analysis
  • Mastery in writing and optimizing SQL scripts and integrating data from multiple databases
  • Doing data modeling, creating partitions in sql server and Postgre sql for establishing relationship between different tables in databases
  • Writing PowerShell and python scripts for end to end process automation
  • Performing user acceptance testing, unit testing, performance testing
  • Performing data blending, data warehousing and ETL using Tableau, Python, SSIS, SQL server
  • Working with different teams spread across multiple regions and multitasking in intense environment
  • Preparing high level design docs and technical reviews of code developed by team members
  • Planning and executing tasks, working on effort estimation, tracking JIRA stories, SNOW tickets, mentoring teammates
  • Strong communicator of ideas and insights with ability to influence stakeholders to ensure data driven actions

Key Achievements:

  • Helped Barclays print team achieve cost-cutting of approx. £ 2 million under ‘Carbon footprint reduction’ initiative by providing insights, optimization scope calculation through Tableau graphs and prediction mechanisms
  • Reduced breached Service Now incident count by 20% through keyword analysis using Python and Tableau. This helped ascertain team’s performance and response on mobile and print service incidents/tickets
  • Recognized by Managing Director for driving print optimization initiative through data analysis and supporting print service transformation

Lead BI Developer

Cybage Software
Pune
10.2015 - 09.2020
  • Designing and implementing high availability Tableau server architecture for approx 3000 users
  • Creating advanced but easy to read Tableau & Power BI dashboards using Sunburst, Waterfall, Donut, scattered plots, Geographical maps, Word Cloud charts and other advanced visuals for story telling
  • Administering/Maintaining Tableau server and Power BI service
  • Implementing data security
  • Implementing performance capturing, monitoring, improvement mechanisms in Tableau Server
  • Performing troubleshooting of Tableau server issues/dashboard performance issues
  • Implementing governance, SOP for Tableau & Power BI workflow
  • Automating Tableau server extracts, alerts using bash scripting, tabcmd commamds
  • Training and advising technical groups on BI best practices especially Tableau
  • Working in Agile/Kanban delivery model

Key Achievements:

  • Enhanced database performance by ~15% with backend query optimizations by writing indexes, stored procedures
  • Slashed average dashboard loading time by 60% by implementing SDLC with rigorous performance testing, dashboard performance tuning and optimizing backend queries
  • Designed and implemented configuration and installation of Tableau server for client in a robust highly available environment by learning Tableau administration all by myself
  • Designed a rich looking entertainment portal with navigation functionalities using Tableau

Education

Bachelor of Engineering - Computer Science

GH Raisoni College of Engineering
Nagpur, India
05.2011 - 05.2015

H.S.S.C (XII) - Science

Maharashtra State Board
07.2009 - 05.2011

S.S.C - undefined

Maharashtra State Board
06.2008 - 05.2009

Skills

    SQL

Tableau

Data warehousing

Data Analysis

Data cataloging

Data Validation

Data Modelling

Python

ETL

Azure

Additional Information

Bagged Star performer award in my current role in Barclays (Proof available on request)

Secured 1st Prize in Ultimate technocrat competition -Research and presentation competition organized jointly by Institute of Engineers, India and Engineering India (Proof available on request)

Timeline

Lead Data Analyst

Barclays
09.2020 - Current

Lead BI Developer

Cybage Software
10.2015 - 09.2020

Bachelor of Engineering - Computer Science

GH Raisoni College of Engineering
05.2011 - 05.2015

H.S.S.C (XII) - Science

Maharashtra State Board
07.2009 - 05.2011

S.S.C - undefined

Maharashtra State Board
06.2008 - 05.2009
TEJAS BALLAMWARLead Data Analyst