Data Tableau
Resume:
Sruthi Vanam
**********@**********.***
www.linkedin.com/in/sruthi-vanam
PROFESSIONAL SUMMARY:
Tableau consultant with 6+ years of experience providing data driven solutions across Financial, Insurance, Retail, Supply-Chain and Telecommunications
In-depth knowledge on Tableau Desktop and Tableau Server in various versions of Tableau 10.4, 9.0, 8.0 and Tableau 7
Strong hands on experience implementing dashboarding, data visualizations, and analytics using Tableau desktop and server
Experience in using Tableau functionalities for creating different Charts, Interactive dashboards with Page and dashboard Prompts
Extensive exposure on building Predictive models using statistics, Machine learning algorithms and help solve complex business problems
Experience in creating different visualizations using Bars, Lines and Pies, Maps, Scatter plots, Gantt charts, Bubbles, Histograms, Bullets, Heat maps and Highlight tables.
Mastered the ability to design and deploy rich Graphic visualizations with Drill Down menu option and Parameterized using Tableau
Extensive exposure on building analytical methods to identify trends and relationships between different pieces of data, apply datamining techniques to build statistical models and draw appropriate conclusions.
Extensive exposure on analytics project life cycle CRISP-DM (Business understanding, Data understanding, Data preparation, Modelling, Evaluation and Deployment)
Experience in Tableau Server Migration, Upgradation and Active directory integration and schedule creation.
Experience in using the Tableau supporting tools like Interworks Tableau workbook tool kit
Experience in Business Analytics, Business Intelligence, Data visualization, Data Analysis, Design, Development, Implementation and Testing of Data visualization and Tableau architecture.
Experience on data wrangling, data blending, data modeling, data visualization and reporting using various tools like using R, SAS, SAS Enterprise Miner, Tableau and SQL (MS SQL Server).
Very strong knowledge of large relational databases,SQL programming
Profound analytical and ProblemSolving skills along with ability to understand current business processes and implement effective solutions
Worked on Tableau Server set up, E-mail Subscription, and Alerts Set up on the Tableau Server
Successfully upgraded Tableau platforms in clustered environment and performed content upgrades
Extensive experience in analyzing models and optimizing business processes, data flows, document business requirements and functional specification documents
Story boarding of results with business interpretation to non-analytic audience through creative visualization tools to enable informed decision making and drive the appropriate actions.
Capable to generate new insights, drive business decisions based on data and strong commitment to make positive impact.
EDUCATION
Bowling Green State University(BGSU), OHIO August 2016 – June 2017 Master of Science(Analytics) - GPA 3.9
Coursework: Data Mining, DBMS, Regression Analysis, Exploratory Data Analysis, Time Series Analysis and
Forecasting, Decision Optimization, Business Intelligence, Big Data Analytics
National Institute of Technology Warangal, India July 2011 – May 2015 Bachelor of Technology- GPA 7.2/10
CERTIFICATIONS & TECHNICAL SKILLS
Certifications: SAS Certified Base Programmer for SAS 9
Python for Data Science &Machine LearningBootcamp
Programming: R, SAS,SQL, Python
Tools:Tableau Desktop 10.X, 9.X, 8.X, Tableau Server 10.X, 9.X,8.X, Power BI, Business Objects,
Alteryx, SAS E-Miner, MS Office (Excel, Project, Visio, Access,PowerPoint)
Databases: Apache Hive, Teradata Oracle 8i/9i/10g/11g, MySQL Server,Microsoft SQL server
Algorithms: Linear Regression, Logistic Regression, Naive Bayes, Decision Trees, Random Forests, Bagging,
K-Means, K-Nearest Neighbors
EXPERIENCE
Tableau Consultant, R Systems Dec 2018 – July 2019
Client: CUNA Mutual Group
Project Description :CUNA Mutual Group is a mutual insurance company that provides financial services to cooperatives, credit unions, their members. Project objectiveisto provide analytical support to the credit unions and help them understand their customer base and provide them with leads to follow. To strategize the optimization and segmentation of the book of business of advisors based on their performances.
Tools/Languages :Tableau Desktop 10.5 Tableau Server 10.5,R, MS SQL Server Management Studio, Hive
Interacted directly with the business users in the requirement gathering and design session
Extracted the data from SQL Server by writing and executing the SQL queries
Developed Tableau workbooks from multiple data sources using Data Blending
Presented the Dashboard demo in every sprint to the business users and provided them the necessary training to use the product
Designed and developed Tableau dashboards for the product sales for each credit union
Fine\tuned SQL Queries for maximum efficiency and performance
Validated the data on dashboard with the source data files
Created Geo spacious tableau workbooks on customer and their products related data
Built an Interactive Tableau dashboard which shows the probability of a customer buying a CBSI product
Analyzed the distribution of leads over Different PersonicxFinancial, Age and Income groups using different visualizations like Scatter plots, Gantt charts, Heat Maps, which is used for marketing purposes
Tracked the response rates for the lead gen campaigns, the monetary value of the Program for FY vs YTD vs QTDand presented them using interactive visualizations to the Credit unions
Provided the analytical support to the Advisors in Optimizing their book of business and calculated the advisor’s engagement performance and studied the effect of engagements on the product sales
Created a metric for customer’s propensity score of buying a product using their Assets and Net worth
Helped the Advisors in segmenting their book of business and provided them with the priority list of customers to be contactedbased on the propensity scores
Supported the business team in meetings with the credit unions by showing the value that analytics could bring to the credit unions.
Calculated the Advisor’s performance based on their engagement activities with the customer and helped them in reallocating the resources based on the priority,performance
Developed functional and specification documents for Analytics projects
Created Interactive Tableau Dashboards to present the interpretations and analysis
Worked directly with Business users to get them familiarize with the dashboard functionality and UAT process
Tableau Developer June 2017–Dec 2018
Client: Kellogg’s
Project Description :Kellogg’s is an American multinational food-manufacturing company which produces cereal and convenience foods. Project Objective is to perform analysis on the sales to theirretail customers like Walmart, Woodmans,Hyvee, etc. and prepare the performance reports and work along with strategy teams.
Tools/Languages: Tableau Desktop 10.3, 10.5 Tableau Server 10.3, MS Excel, Alteryx, Dashboarding,Oracle
Calculated and Reported the performances of Multiple Distribution Centers& Business units using Tableau
Tracked and Analyzed the utilizations, Load, Case pick, Case fill of multiple customers every week using different visualizations
Worked on enhancing the existing dashboards and building the new dashboards based on the inventory data to help the customers
Created Adhoc reports and dashboardsusing Tableau, MS Excel based on the requirements
Developed Tableau workbooks to perform year over year, quarter over quarter, YTD, QTD and MTD type of analysis
Involved in creating a dual-axis bar chart with multiple measures
Generated Dashboards with Quick filters, Parameters and sets to handle views more efficiently
Reported the findings and the analysis on weekly and monthly basis
Used Alteryx to combine the data from various databases and to make any required changes to the dataset and use the output to build dashboards
Created SQL Reporting views based on the requirement of the Tableau dashboard
Involved in creating tables, and views and other SQL joins and statements for applications.
Worked with the UI/UX team to integrate Tableau server with web applications
Created Multiple scorecardslike VAS, Joint which reflected the KPIs of various customers
Prepared presentations showing insightful visualizations and graphs of the customer logistics data
Designed and Developed Mobile versions of dashboard to send Alerts using Tableau 10.2 feature
Involved in Tableau Center of Excellence (COE) Team to discuss designing sessions and guidelines
BI Analyst, IBM June 2015 – July 2016
Client: AT&T AOTS
Project Description: AT&T AOTS is a trouble ticketing system to request assistance from AT&T SME on either a question or issue raised by a user. Project Objective is to work for the enhancement of the ticketing systems and perform the analysis as per the requirements of the business
Tools/Languages: Tableau Desktop 9.0, 8.2 & 8.1, Tableau Server 9.0, 8.2,Microsoft Power BI R, SQL,Agile
●Worked for enhancement of AT&T ticketing system and performed requirement analysis, resource optimization, data quality checks and defect metrics analysis
●Designed dashboard layout and functionality to measure the project parameters by using Visualization techniques, Statistical analysis techniques in Tableau, R
●Calculated and tracked the project progressfor each week, monthly basis and changed the schedule accordingly
●Performed a statistical analysis on project parameters in R and created data visualizations in Tableau to track the project progress and managed project scheduling accordingly.
●Involved in writing QA test cases for the Tableau dashboards
●Created weekly reports, monthly reports, ad-hoc reports and defect metrics using MS Excel and Tableau which demonstrated key information for decision making and were presented to managers, clients during scrum meetings and internal reviews
●Maintained Dashboard level security on Tableau Server by creating user groups
●Created Documents for User training and conducted several sessions to train users
●Developed dashboards using Microsoft Power BI as a POC Project
Reporting Analyst, Spring Spree March 2013 – May 2015
Project Description :ProjectObjective is to provide financial planning, analysis and the execution for the successful completion of the event.
Tools :MS Excel, Tableau, Finance
●Performed Exploratory analysis of cash flows by applying Visualization techniques and Summary statistics in Microsoft Excel and Tableau for a cultural festival which had $80000 turnover.
●Audited 30 records for Fraud Detection so that the use of funds complies with the conditions set by sponsors and created views in Tableau that were published to internal team for review and further data analysis to be done were discussed
●Involved in data source audit to reduce the data extract size to create optimized Tableau workbook
●Using the Interworks Tableau workbook tools enhanced the calculated fields to reduce the Viz load timings
●Assisted in execution and provided analytical support for new plans to achieve company’s objectives
Contact this candidate