TEJAS BALLAMWAR

• 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

• 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