Tableau Data Analyst

Varshika

*********@*****.*** (Phone 980-***-****)

PROFESSIONIAL SUMMARY

• Business Intelligence Tool Developer with 6+ years of relevant experience and track record of delivery of complex Tableau dashboards.

• Versatile and results-oriented with balanced proficiency in technical and business analysis skills.

• Domain knowledge in Banking Sector.

TECHNICAL SKILLS

• Tableau Desktop Development in version 8.x, 9.x, 10.x, 2018.x, 2019.x

• Proficient in writing SQL queries and Data Modeling

• Proficient in Tableau Administration of Tableau Online and Tableau Server.

• Proficient in MS Excel with pivot tables, v-lookups, and data manipulation.

• Working experience in Agile environment and Jira software. WORK EXPERIENCE

Business Intelligence Consultant, First Republic Bank, CA 03/2019 - Present Tableau Desktop, MSSQL Server, Snowflake, AWS

• Responsible for analytics initiatives in Enterprise Agile Transformation Group by partnering with Agile Coaches, Scrum Masters, Products Owners and Managers to define and measure KPIs of Agile teams.

• Design and develop complex interactive Tableau dashboards including LOD expressions, parameters, calculated fields, sets, groups, table calculations, advanced charts, custom SQLs, data blending, cross-database joins, dashboard actions and row level security following best practices in data visualization and design.

• Design and Create Data Services Layer in DENODO Express and feeding it to downstream Dashboard systems through Tableau.

• Migrated from MS SQL Server to AWS Snowflake Database. Achievements:

Successfully deliver and maintain seven complex Tableau dashboards for various line of business leaders

Tableau Developer, TIAA, NC 10/2017 – 02/2019

Tableau Desktop, Tableau Online Admin, MS SQL Server, Advanced Excel

• Responsible for Business Intelligent projects for 529 Plan - Education Savings Product & Plan Products including analyzing requirements and creating quick POC.

• Designed and developed complex interactive Tableau dashboards from Enterprise Data Warehouse (EDW) utilizing advanced functionalities including LOD expressions, parameters, calculated fields, sets, groups, table calculations, advanced charts, data blending, cross-database joins, dashboard actions and row level security following best practices in data visualization and design.

• Validated Tableau dashboards against data extracted from Essbase to SQL Server system using advanced Excel calculation.

• Published dashboards to Tableau Server and set up data refresh automation. Perform Tableau admin tasks for Tableau Online site including creating and managing users, user roles, groups, projects, contents, and permissions.

• Explored complex dataset with SQL queries to gain business insights and provide recommendations to business stakeholders.

• Migrated few reports from Adobe Analytics to Tableau using web-based marketing data.

Achievements:

Successful delivery of over twelve complex Tableau dashboards for 529 Education Savings Product plans that drive high level decision making. Database Analyst, Wells Fargo, NC 07/2016 – 09/2017 Tableau Desktop, Tableau server, SQL, advanced Excel

• Conducted data analytics in consumer finance business and partnered with cross functional teams to support management decision making.

• Developed and maintained interactive Tableau dashboards utilizing advanced functionalities including LOD expressions, parameters, calculated fields, sets, groups, table calculations, clustering, statistical functions, and advanced charts.

• Designed and Implemented business Analytical solutions for Banking institutions to increase the data accuracy to enhance the Customer Risk Management.

• Involved in reviewing business requirements and analyzing data sources from Excel/Oracle, SQL Server for design, development, testing, and production rollover of reporting and analysis projects within Tableau Desktop.

• Deep dived into large dataset with SQL queries to find possible business insights. Achievements:

- Successfully deliver and maintain complex Tableau dashboards for various line of business leaders.

Tableau Developer, Northwestern Mutual, WI 10/2014 – 06/2016 Tableau Desktop, Tableau Online Admin, SQL, advanced Excel

• Conducted data analytics in consumer finance business and partnered with cross functional teams to support management decision making.

• Developed and maintained interactive Tableau dashboards utilizing advanced functionalities including LOD expressions, parameters, calculated fields, sets, groups, table calculations, clustering, statistical functions, and advanced charts.

• Presented business findings to project stakeholders including Executives on BOD business review meeting.

Achievements:

Improved marketing strategies with customer segmentation analysis which increased ROI by 8%.

Data Analyst, Paxterra Software Solutions, India 06/2013- 12/2013 SQL, statistical analysis, Advanced Excel, MS Project

• Managed web application development projects for financial market including defining business requirements, designing database relational models, and driving projects to completion.

• Developed SQL queries to extract data from MySQL database and built financial analysis models with MS Excel features such as Pivot tables, v-lookups, advanced filters, data consolidating, scenario analysis and data manipulation. EDUCATION

• Master’s in computer science - Northwestern Polytechnic University California, USA

• Bachelor’s in computer science engineering - JNTU Hyderabad, India

Contact this candidate