Ashutosh Agrawal
Tableau Lead
Canonsburg,PA
Summary
Around 13 years of experience in IT industry as Tableau Developer/Business Intelligence Engineer with extensive knowledge in functional and technical domain of Business Intelligence, ETL tools, creating reports, dashboards through Tableau, identifying trends and processing mapping with strong background in Databases and Data Warehousing concepts. Tableau 9.0 Desktop Certified
Overview
16
16
years of professional experience
5
5
years of post-secondary education
1
1
Certification
Work History
Senior Tableau Developer
Veteran Affairs
1 2024
- Creating Tableau Reports for the claims department
- Working on converting legacy report to interactive Tableau reports
- Using different Tableau features like LOD, Maps, Drill Down for the reporting Involved in doing impact analysis for multiple projects.
Senior Tableau Developer
Avis Budget Group
08.2023 - 12.2023
- Working as a senior Tableau developer for ABG global
- Supporting multiple projects at same time involving customer relationship, revenue management, resource management
- Creating complex Tableau reports using different Tableau features like LOD, Maps, Drill Down
- Using multiple data sources like Google BigQuery, AWS Redshift, Oracle and MS SQL Server
- Created many Tableau Prep flows for creating and manipulating data from different data sources
- Involved in doing impact analysis for multiple projects
- Migrating reports from Power BI to Tableau.
Data Consultant
Accenture Flex
01.2022 - 07.2023
- Creating Tableau Reports for consumer hardware team
- Directly interacting with client to understand reporting needs for the project
- Using Google BigQuery for data analysis and custom SQL for Tableau
- Running weekly reports critical for business needs for client
- Single point of contact in onshore for client for reporting needs
- Attending PI planning meeting for resource utilization of reporting team for bi-weekly scrum activity.
Senior Tableau Developer
Illumina
06.2021 - 12.2021
- Creating Tableau Reports for the Finance department based on company data
- Writing complex calculations in Tableau for creating Tableau Report
- Using SAP Hana Studio from writing SQL queries for data analysis and custom SQL for Tableau
- Updated Crystal Reports in SAP BO
- Migrating Crystal Reports to Tableau
- Using Alteryx for ETL tool for manipulation of data
Senior Tableau Developer
PNC Bank
01.2021 - 06.2021
- Gathering requirements from the client for reporting
- Creating Tableau reports based on client requirements based on data pulled from different sources including Oracle, SQL Server and Excel
- Using TOAD from writing SQL queries for data analysis and custom SQL for Tableau, Using Tableau Prep to create data flows for data extracts sitting on Tableau server.
Business Intelligence Engineer
Amazon
05.2019 - 10.2020
- Working as Single point of Contact as Tableau Developer/BI Engineer for AWS Global Procurement team of more than 200 people
- Created monthly and weekly reports for presentation to Senior Management for Cost-Savings and Areas of Improvement Built customized interactive reports and dashboards using Tableau for AWS procurement data (including vendor bids for current and new AWS regions)
- Working extensively with AWS technologies for Table creation, lake formation, data pull from tables and other different sources
- Created complex SQL queries based on Redshift database for data pull for different dashboard Managing ticketing system for team for requests from customer for creating tableau dashboards and data request Mentored peers and interns with use of Tableau for building interactive dashboards
- Conducted Tableau training sessions for peers and customers.
Informatics Consultant/Lead
Aetna
10.2017 - 05.2019
- Built customized interactive reports and dashboards using Tableau for patient data (including Pharmacy data, Claims, Inpatient, Readmissions, Emergency Room and Outpatient.) Utilized Tableau visual analytics and best practices like Dashboard structure, view orientation, Sizing and Layout, Data Emphasis, Highlighting, Color, Fonts, Tooltips, and performance improvement of complex dashboards/reports
- Did performance tuning on Tableau to reduce the time taken by dashboards
- Performed and overseen the performance of Design to develop technical solutions from Analysis documents
- Responsible for accomplishing the project objectives within the constraints of the project
- Involved with the planning, controlling and monitoring
- Established architecture, design and technology principles and guidelines
- Recommends transformation roadmap and works with Program management
- Performed unit testing of Data Integration, BI Reports
- Created technical design documents, test case documents & code review documents.
Business Intelligence Engineer
Highmark Health
10.2016 - 07.2017
- Utilized Tableau visual analytics and best practices like Dashboard structure, view orientation, Sizing and Layout, Data Emphasis, Highlighting, Color, Fonts, Tooltips, and performance improvement of complex dashboards/reports
- Perform and oversee performance of Design to develop technical solutions from Analysis documents
- Responsible for accomplishing project objectives within constraints of project Resolved architecture disputes and establishes compliance checkpoints in major capability development process
- Identify and fix Data Integration, Quality issues
- Did unit testing of BI Reports before sending to Production environment.
Senior Tableau Developer
PNC Bank
07.2015 - 10.2016
- Lead team of 2 Tableau Developers for creating different dashboards as per business requirements
- Analyzed user and business requirements attended periodic meetings for changes in application requirements and documents
- Created rich dashboards using Tableau and prepared user stories to create compelling dashboards to deliver actionable insights
- Created Tableau reports for data reconciliation to check data integrity for data coming from different sources
- Responsible for design, document, and modify software specifications throughout production life cycle
- Developed new framework /dashboards for financial BI Analytics using Tableau by extracting data from various sources like RDBMS, Hadoop Data Lake and other.
Senior Software Engineer
Unisys India
08.2011 - 07.2013
- Developed mortgage solutions from end to end for banking clients in UK
- Took part in daily standup meeting for development of project
- Responsible for design, document, and modify software specifications throughout production life cycle
- Responsible for accomplishing project objectives within constraints of project
- Involved with planning, controlling and monitoring
- Created process for testing for improvement for time and structure
- This reduced testing effort by 10%
- Created technical and non-technical documents for development of project based on client requirement
- Delivered all projects on time and in schedule.
Systems Engineer
Tata Consultancy Services Ltd.
04.2008 - 08.2011
- Spear headed lot of projects with team of 5 people with delivering all of them on time and within budget
- Monitored project status throughout whole process to maintain quality and standards of deliverables
- Met clients on daily basis to provide project status updated and to understand if any needs are not met properly
- Involved with planning, controlling and monitoring
- Streamline development process which helped to reduce development time and cut down on errors.
Education
Master of Business Administration - Business And Information Technology
Virginia Polytechnic Institute & State University
Blacksburg, VA 08.2013 - 05.2015
Bachelor of Computer Science and Technology - Computer Science
West Bengal University of Technology
Kolkata, India 08.2003 - 05.2007
Skills
Windows Server 2000/2003/2008
Windows 98/2000/XP/VISTA/7/10
C
SQL
PL/SQL
SQL Enterprise Manager
Teradata SQL Assistant
SAS
Aginity
SAP Hana Studio
MS SQL Server
Oracle
Teradata
Netezza
MS Access
Hadoop
Redshift
SAP Hana
Google BigQuery
Microsoft Office
MS Visio
Toad
HP ALM Quality Center
Tableau (Desktop/Server/Public)
Power BI
MS Excel
AWS Quicksight
Crystal Reports
Agile Methodology Experience
Data Visualization Mastery
Tableau performance optimization
Advanced Tableau expertise
Complex dashboard creation
Data Validation
Business Intelligence
Certification
Tableau 9.0 Desktop Certified
Timeline
Senior Tableau Developer
Avis Budget Group
08.2023 - 12.2023
Data Consultant
Accenture Flex
01.2022 - 07.2023
Senior Tableau Developer
Illumina
06.2021 - 12.2021
Senior Tableau Developer
PNC Bank
01.2021 - 06.2021
Business Intelligence Engineer
Amazon
05.2019 - 10.2020
Informatics Consultant/Lead
Aetna
10.2017 - 05.2019
Business Intelligence Engineer
Highmark Health
10.2016 - 07.2017
Tableau 9.0 Desktop Certified
08-2015
Senior Tableau Developer
PNC Bank
07.2015 - 10.2016
Master of Business Administration - Business And Information Technology
Virginia Polytechnic Institute & State University
08.2013 - 05.2015
Senior Software Engineer
Unisys India
08.2011 - 07.2013
Systems Engineer
Tata Consultancy Services Ltd.
04.2008 - 08.2011
Bachelor of Computer Science and Technology - Computer Science
West Bengal University of Technology
08.2003 - 05.2007
Senior Tableau Developer
Veteran Affairs
1 2024