SUMMARY

• Over 15 years of experience in IT industry with more than 9 years in Datawarehousing & BI development and 7 + years in Tableau Dashboard development in various domains like Health Insurance, Finance, Telecom, Travel and Hospitality, Consumer Care
• Expert in design, development & administration of Tableau Dashboards and servers in data warehouse environment.
• Actively involved in all DW house activities like Data Modelling, ETL, Reporting, Visualisation
• Expert in creating Dashboards using Tableau features like Quick Filters, Action Filters, Drill down, Hyper linking, Ranking.
• Performed Highlighting effectively using Groups and Sets in Tableau.
• Used data extracts/SQL queries effectively to achieve optimization.
• Proficient in creating reports, interactive GUI and dashboard using different data sources like Oracle, Access, text files, excel documents etc. as per the user requirement.
• Good knowledge of Data Visualization, Data Warehousing Models, RDBMS concepts, SQL, PL SQL, Oracle and SQL Server.
• Experience in getting Visualization done from raw data
• Well versed in Data Manipulation using disparate tools - Alteryx, Pandas etc.
• Data Exploration and transformation using Python Pandas, Numpy
• Integrating data from multiple sources using Pandas
• Pandas select, filter, join aggregation and transform operations
• Built charts like Waterfall chart, Scatter plot, Heat map, Tree Map, Gantt Charts, Bar charts, Line charts, Geo Coding, Pie Charts
• Highly proficient in handling performance issues related to Tableau reports.
• Expertise in optimizing, Debugging and testing SQL queries.
• Expertise in Tableau Server Management, User Security, Performance Monitoring
• Experienced in application development methodologies and life cycle: planning, design, development, testing and implementation.
• Excellent analytical, co-ordination, interpersonal, leadership, organizational and problem solving skills, ability to adapt, learn new technologies and get proficient in them very quickly.
• Involved in Tableau installation and upgrade whenever new versions are released.
• Established Connections with various Data Sources like Google Analytics, Salesforce, Business Objects, AWS(Amazon Web Services)
• Performed capacity planning, user security/Environment setup
• Performed the role of Tableau Admin, created Schedules, User groups, Projects, Sites
• Well versed with Agile methodology-Sprint Planning
• Involved in discussions with various BA’s, SME’s and concerned Product owners
• Performed pulling of data from OLTP, Data marts to staging DB and then finally transformed to Data warehouse
• Also created Visualisations using Power BI Tool.

Environment: Tableau 2019.1,Tableau 2018.2,10.x,9.x,8.x, Oracle 10g, MS SQL Server 2008/2012, Alteryx, Jaspersoft, Informatica PowerCenter 7.1.3, UNIX, Spark SQL,Redshift, MYSQL,Cognos, Python(Pandas)

PROFESSIONAL EXPERIENCE

Confidential

Tableau Lead/Sr. Tableau Developer

Responsibilities:

• Created Various interactive dashboards to teams involved in Safe Agile Metrics, Survey data, Program management and Data Quality Metrics, Product portfolio
• Connected to Hive Server using Alteryx in an efficient manner.
• Created Tableau ready dataset using Pandas.
• Used Dataframes for Select Filter, Join, Aggregation and Transformation operations in Pandas
• Worked with multiple Product owners in an Agile Environment
• Used LOD calculations, Table calculation, Context filters in conjunctions to deliver complex use cases.
• As a part of the dashboard building, used charts like Waterfall chart, Heat maps, Burndown Charts, Donut Charts etc., Pareto charts
• Worked with different dashboard layouts to cater the aesthetic aspect of different product owners
• Worked on the development of Tableau Dashboard reports for Key Performance Indicators for the top management.
• Used Conditional formatting to get Multiple KPI in Same Visualization
• Rebuild existing Reports into Tableau Visualizations with user and action filters.
• Actively spoke with Product owners to find out what insights Business is looking out from raw data.
• Worked with actual business users to make dashboard actionable as possible, by minimizing quick filters.
• Business was appreciative of the creativity of dashboards developed and the simplicity.
• SQL Query Tuning and Monitoring Performance

Environment: Tableau 2018.2,Tableau 10.x, Tableau 9.x, Oracle 10g, MS SQL Server 2008/2012, Alteryx

Confidential, Jersey City NJ

Tableau Lead/Sr. Tableau Developer

Responsibilities:

• Created Various interactive dashboards to teams involved in Portfolio management, Cost Analysis and Time management.
• Connected to SQL Server using Alteryx in an efficient manner.
• Rigorously worked with Business partners in a Agile Environment
• Used LOD calculations, Table calculation, Context filters in conjunctions to deliver complex use cases.
• As a part of the dashboard building, used charts like Waterfall chart, Heat maps, Box and Whisker plots, Radar Chart, Donut Charts etc., Pareto charts
• Demo of Tableau dashboard to users to enhance their knowledge on all the key capabilities of application.
• Build interactive Tableau dashboards and publish Tableau reports utilizing parameters, calculated fields and table calculations, user filters, action filters and sets to handle views more efficiently
• Actively spoke with Product owners to find out what insights Business is looking out from raw data.
• Worked with actual business users to make dashboard actionable as possible, by minimizing quick filters.
• Business was appreciative of the creativity of dashboards developed and the simplicity.
• Create Jasper PDF reports which user can access by sending an email .
• Build search logic in Alteryx using various tools
• SQL Query Tuning and Monitoring Performance

Environment: Tableau 2018.2,Tableau 10.x, Tableau 9.x, Oracle 10g, MS SQL Server 2008/2012, Alteryx, Jaspersoft

Confidential, Boston, MA

Tableau Lead/Sr. Tableau Developer

Responsibilities:

• Created Sankey Diagram to show Treatment and Drug Switching.
• Connected to Hive Tables in Cloudera Cluster using Spark SQL in an efficient manner.
• Constantly interacted with Business partners in a Agile Environment
• Involved in cohort building exercise.
• Used LOD calculations, Table calculation, Context filters in conjunctions to deliver complex use cases.
• Created Patient time line beautifully using Gantt Charts.
• Worked rigorously with backend data & SQL to get Tableau ready datasets.
• Actively spoke with Product owners to find out what insights Business is looking out from raw data.
• Worked with actual business users to make dashboard actionable as possible, by minimizing quick filters.
• As a part of the new product development, used charts like Waterfall chart, Heat maps, Box and Whisker plots, Radar Chart, Donut Charts etc., Pareto charts
• Used Tableau command line commands to publish workbooks periodically.

Environment: Tableau 10.x, Tableau 9.x, RedShift, Oracle 10g, MS SQL Server 2008/2012, Apache Spark