Tableau Social Media

Krishna Sruthi

Contact: 402-***-**** / Email: ***********@*****.***

Summary of Experience:

Over all 5 plus years of experience in analysis, design and development of reports using Tableau and data wrangling.

Experience working with Tableau 8.x, 9.x & 10.x.

Experience in moving data from/into HDFS and traditional data sources like Oracle, SQL server and Netezza.

Interacted with IT and Business Team at various levels and coordinated meetings during the different cycles of the project.

Tableau development skill set including visualization development, use of parameters, and report optimization.

Security configuration including user / group setup, permissions, security roles, configuration of trusted ticket authentication.

Experience with designing complex dashboards taking advantage of all tableau functions including data blending, parameters, etc.

Experience integrating Tableau into various external environments (such as websites, social media websites, etc.)

Develop canned / Ad-Hoc reports and complex dashboards in Tableau as needed.

Ability to use custom SQL for complex data pulls.

Good knowledge of tableau server, administrative functions, installation.

Supported the development of Data Warehousing and BI solutions in support of the cross-functional teams.

Designed and lead development of a state-of-the-art dashboard.

Experienced in working on Tableau (Desktop, Server, and Reader), creating Dashboards and Reports using different functionalities.

Create a wide variety of analysis including comparisons, trending and what-if analysis.

Proficient with Cross tab, Scatter Plots, Geographic Map, Pie Charts and Bar Charts, Page Trails, Density Chart, etc.

Experienced in creating Calculations (Table Calculations, Hide Columns, Creating/Using Parameter, Totals) and Formatting (Annotations, Layout Containers, Mark Labels, Mar Card Changes, Rich Text Formatting, Shared Encoding) using Tableau Desktop.

Proficient in design and development of various dashboards, reports utilizing Tableau Visualizations like bar graphs, scatter plots, pie-charts, geographic visualization and other making use of actions, other local and global filters according to the end user requirement.

Expertise in designing and creating various analytical reports and Dashboards to help users to identify critical KPIs and facilitate strategic planning in the organization.

Able to Create Power BI dashboards and reports. Design, build and deploy BI solutions.

Strong knowledge of Power BI data querying and modeling capabilities, such as creation of calculated columns, measures, and relationships.

Had Knowledge on power query, PowerPivot and other Excel extensions.

Develop and generate standard and ad hoc reporting capabilities from new and existing data sources

Mastered the ability to design and deploy rich Graphic visualizations with Drill Down menu option and Parameterized using Tableau.

Posses’ strong knowledge of database management in writing complex SQL queries.

Extracting data from different sources connecting them and used the same to create dashboards.

Created visually compelling and actionable interactive reports and dashboards

Extensive experience database trouble shooting and performance tuning.

Complete basic installation of Tableau Server

List the (default) ports Tableau Server requires and describe how default ports can be changed during installation

Experience in creating aggregate tables, table partitions, indexes and cache management.

Strong SQL Skills related to information retrieval and analysis. Exposure to Client Interaction, User requirement Analysis and Support.

Education:

Bellevue University Feb16 - Aug17

MS in Computers and Information Systems (Specialization in Software Engineering)

Nimra College of Engineering &Technology, Vijayawada. Oct 08 - May 12

BTech in Computers and Information Systems

Technical Skills:

Tools

Tableau Desktop 10.x/9.X/8.X, SAS,PowerBI

Big Data

Hive, Hue

ETL Tools

Informatica PowerCenter 9.x, SSIS

Operating systems

Windows XP, Windows Server 2003/2008, UNIX

RDBMS

Oracle 10g/9i, SQL Server 2012/2015 R2, MS Access

Languages

SQL, HTML, C, Java

Methodologies

Complete Software Development Life Cycle, Waterfall, Agile, Iterative, Scrum

Professional Experience:

Client: Walmart Jan 18 - Present

Role: BI Developer

Responsibilities:

Built/developed the Insights Generator dashboards for Inventory Management/Customer Acquisition.

Built a lot of dashboards for store systems different apps like pickup kiosk, PlanIt app, Hunting & Fishing: displaying data by city, state, sales, inventories, margins and promotions.

Combined different sources like products, calls, complaints, surveys, churn and web data to create a consolidated and comprehensive data source for the project

Also created the member offer related data sets that feeds into the member profiling models

Created Schedules and Extracted the data into Tableau Data Engine

Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server

Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau

Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps

Effectively used data blending feature in tableau.

Administered user, user groups, and scheduled instances for reports in Tableau.

Executed and tested required queries and reports before publishing.

Developed parameter and dimension-based reports, drill-down reports, matrix reports, charts, and Tabular reports using Tableau Desktop.

Involved in Creating the Schema objects i.e. Attributes, Facts, Hierarchies and Transformations.

Involved in extraction, transformation and loading of data directly from different source systems like flat files, Excel, Oracle and SQL Server.

Able to Create Power BI dashboards and reports. Design, build and deploy BI solutions.

In our new app we started creating reports on Power BI

Environment: Tableau 10.0.2/9.3.2, Hive, Oracle 10g, SQL Server 2015, Netezza, MS Excel.

Client: P&O Ports, UK Aug 12 – Jul 15

Company: CTECH IT Solutions

Role: Tableau Developer/Data Analyst

Responsibilities:

Participate in the user requirement gathering and Design meetings.

Implemented action filters, parameters, calculated filed and set for preparing dashboards and worksheets in Tableau.

Created Tableau scorecards, dashboards using Stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.

Administered user, user groups, and scheduled instances for reports in Tableau.

Developed dashboards in Tableau Desktop and published them on to Tableau Server that allowed end users to understand the data on the fly with the usage of quick filters for on demand needed information.

Effectively used data blending feature in tableau.

Translate business needs into reporting and analytic requirements.

Build interactive dashboards and publish Tableau reports utilizing parameters, calculated fields and table calculations, user filters, action filters and sets to handle views more efficiently

Worked on the development of Dashboard reports for Key Performance Indicators for the top management

Rebuild existing Reports into Tableau Visualizations with user and action filters

Performed Tableau Server admin duties; add users/groups from Active Directory; and schedule instances in Tableau Server including weekly data dump.

Ensure data accuracy and reliability of reports.

Created Bullet graphs to determine profit generation by using measures and dimensions data from Oracle SQL Server and MS Excel.

Interact with customers on a regular basis to resolve issues.

Create custom SQL connections and calculated fields within Tableau to facilitate automated production of data visualizations

Published Workbooks by creating user filters so that only appropriate users can view/edit them.

Generated context filters and handled performance issues while dealing with huge volume of data.

Generated tableau dashboards with forecast and reference lines.

Experience in creating aggregate tables, table partitions, indexes and cache management.

Also acted as the ETL developer in the team and used Informatica when complex transformations were required.

Created advanced mapping, transformations, and workflows using Informatica PowerCenter 8.x then exported the csv files to use in Tableau.

Environment: Tableau Desktop 8.1, Tableau Server, Tabadmin, Tabcmd, Tableau Data Engine, Informatica PowerCenter 8.x, Oracle 9i, PL-SQL, SQL, SQL Server 2008 R2, MS Excel.

Contact this candidate