Data Analyst Tableau Server

Shraddha Jhanwar

● +1-704-***-**** ● Email: ***************@*****.***

Tableau Public Profile: https://public.tableau.com/profile/shradda.jhanwar#!/ Objective:

Highly skilled and results-oriented Data Analyst with 5 years of experience in analyzing complex datasets, developing data-driven strategies, and providing valuable insights to drive business growth. Seeking a challenging position in a dynamic organization where I can leverage my expertise in data analysis and visualization to contribute to the company's success. Highlights:

Ø 5+ years of experience as a Data Analyst, specializing in data interpretation, statistical analysis, and data-driven decision-making.

Ø Proven experience in data engineering and analysis, with a focus on leveraging Databricks, Python, and Snowflake SQL to solve complex data challenges. Ø 5+ years of experience creating user-friendly and dynamic Tableau dashboards with KPIs, Heat Maps, Scatterplots, Bar Charts, Slicers, Drill down, Drill up etc. features and possess understanding of when to use them.

Ø 5+ years of experience working closely with internal and external stakeholders to discuss organizational needs and gather dashboard requirements and creating functional/technical requirement documents for smooth process flows.

Ø Strong hands on advanced SQL concepts like Joins, windows functions, subqueries, etc. Ø Extensive knowledge in various reporting objects like Joins, Unions, Hierarchies, filters, calculated fields like LODs, Sets, Bins, Groups, and Parameters in Tableau. Ø Experienced in Tableau Server administration including Publishing workbooks, publishing data sources, schedules, creating sites and projects, creating and adding new users/groups/roles, managing users and groups, assigning permissions, keeping revision history and setting up data driven alerts. Ø Strong hands on experience creating highly interactive dashboards, designing rich graphic visualizations with modular design of reports, worksheets and views in Tableau with a strong understanding of the appropriate chart types to use to highlight patterns in the data, answer questions, and communicate results.

Ø Good Exposure on connecting different data sources to Tableau like relational databases (RDBMS), Athena, Snowflake, flat files, MS Excels etc.

Ø Strong understanding of Data Visualization concepts and ability to identify trends & patterns in the data for providing actionable insights using Tableau Analytics Pane Ø Wrangling data from multiple sources including sales, inventory, product, and customer databases to create integrated views that can be used to drive decision making. Ø Excellent analytical and logical programming skills with a good understanding at the conceptual level and possess excellent presentation, interpersonal skills with a strong desire to achieve specified goals. Excellent written and verbal communication skills including experience in proposal and presentation creation.

Ø Motivated and enthusiastic team player that takes ownership to deliver successful results. Willing to go the extra mile with a strong work ethic; self-directed and resourceful. Ø Strong Hands on Tableau desktop, Tableau Prep and Tableau server in various Tableau versions. Professional Experience:

EMPLOYER: ZoomInfo Jun 2021 – Present

Data Analyst II:

• Won the hackathon, created a slack bot (on-demand insight), using python and reading data from Snowflake backend, the project was about creating a data report so the sales team can directly interact with slack bot and get live data and get top level sales data and customer Insights without writing any SQL/Code on their end.

• Anticipated business questions and developed data frames and analytical solutions. By staying ahead of the curve, this allowed me to provide valuable insights and recommendations to stakeholders in a timely manner.

• Utilized Databricks and Apache Spark to develop and maintain data pipelines and ETL processes, ensuring efficient data extraction, transformation, and loading.

• Implemented complex data transformations using Python within the Databricks environment, addressing specific business requirements and data challenges.

• Leveraged Snowflake SQL to design and optimize data models and schemas, improving query performance and data retrieval efficiency.

• Collaborated with stakeholders to define data requirements and business objectives, translating them into technical solutions using Databricks and Snowflake.

• Identified a manual data validation process that was time-consuming and prone to errors.

• Developed a Python script to automate the data validation, utilizing pandas and data manipulation techniques. Reduced the data validation process time from 8 hours to just 30 minutes, improving efficiency and accuracy.

• Applied a customer oriented focus and built trust with customers and stakeholders by leveraging my insights and analytical expertise. I utilized various channels such as dashboards, reports to effectively communicate findings and compelling stories that highlighted the key insights.

• Developed a reusable script that standardized data formats, performed calculations, and generated transformed datasets, read and write from AWS s3 and Google GCP data storage.

• Automated the scheduling of reports to run at specific intervals, eliminating the need for manual intervention. Reduced the time spent on report generation by 90%, resulting in significant cost savings by freeing up employee resources.

• Trained more than 10 Junior Data analyst to get them onboarded to the ZoomInfo System EMPLOYER.: TAVISCA

Data Analyst : Mar 2018 – Feb 2020

• Responsible for interaction with business stake holders, gathering requirements and managing the delivery, covering the entire Tableau development.

• Advanced Tableau experience from dashboard design and development. Expertise with use of action filters, user filters, advanced navigation techniques, Level-of-Detail (LOD) expressions.

• Interactive data visualizations in Tableau desktop and providing BI Solutions to the management for strategic decision making.

• Created sequential story points for the stakeholders.

• Designed, developed, tested, and maintained Tableau functional reports based on user requirements and published using Tableau server.

• Development assisting users in creating and modifying worksheets and data visualization dashboards.

• Extensively involved in creating graphs by using measures and dimensions data from various databases.

• Involved in publishing of various kinds of live, interactive data visualizations, dashboards, reports and workbooks from Tableau Desktop to Tableau servers.

• Blended data from multiple databases into one report from each database for data validation.

• Scheduled data refresh on Tableau Server for daily, weekly and monthly increments based on business change to ensure that the views and dashboards were displaying the changed data accurately.

• Worked with the customers to resolve various issues associated with the reports. Environment: Tableau 2019.4/2018.3/10.5, Tableau Server, Tableau cloud, Tableau Online, Tableau Mobile, Tableau Public, Tableau Reader.

EMPLOYER: TCS Jan 2017 - Mar 2018

SQL and Tableau Developer:

• Performed the entire project life cycle from Analysis, Development, Testing, Production and end user support, worked closely with business users and Platform Team while gathering requirements.

• Worked on several interactive dashboards with Filtering, highlighting, ability to combine multiple data sources, easy sharing with support for existing security using several visual analysis best practices.

• Wrote advanced SQL to analyze data in Athena and Snowflake for business users’ queries.

• Designed, developed, tested, and maintained Tableau functional reports based on user requirements.

• Involved in creating database objects like tables, views using Oracle SQL to provide definition, structure and to maintain data efficiently.

• Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics and table calculations.

• Provided Production support to Tableau users and Wrote Custom SQL to support business requirements.

• Created Relationships, actions, data-blending, filters, parameters, hierarchies, calculated fields, sorting, groupings, live connections, and in-memory in both Tableau and Excel Visualized data by creating Charts and Graphs (bar graphs, line charts, pie charts, Tree maps, Word clouds, Bubble Charts, Pareto Charts, Waterfall Charts, Bump Charts, Funnel Charts, Bollinger Charts) based on clients need.

• Developed Tableau workbooks from multiple data sources using Data Blending.

• Developed Tableau workbooks to perform year over year, quarter over quarter, YTD, QTD and MTD type of analysis.

Environment: Tableau Desktop 10.0.x, Tableau Server, MS Office Suite (Word, Excel, PowerPoint), MS SQL Server. Technical Skills:

BI/Reporting Tool: Tableau (Version10.X), Tableau desktop, BI Tools Languages, Database: SQL, MS SQL SERVER & MySQL, Oracle, Athena, SnowFlake Excel 2010, Word Application Life Cycle: JIRA, GIT, Jenkins

Methodologies: Agile

Education:

Master of Business Administration, Finance (MBA)

Bachelor of Business Administration (MBA)

Tableau Desktop Specialist Certified.

Oracle SQL Fundamentals certified

Contact this candidate