Manikanta Vedumala
Austin,TX
Summary
- 8+ years of experience as a Business Intelligence Developer with Tableau, Business Intelligence tools, Data Analytics, and Dashboards.
- Experienced in working with Tableau Desktop and Tableau Server
- Experience gathering client requirements, writing test cases and collaborating with developers to guarantee full understanding of internal/external client needs, and delivering training to others on the utilization of Tableau.
- Designed, developed, and maintained reports and Multilevel dashboards in Tableau.
- Experienced as a Data Analyst and in transforming client requirement documents into business requirement documents.
- Proficient in data visualization, Reporting, and Analysis using Bar Charts, Line Charts, Tree Maps, Pie Charts, Heat Maps, Scatter Plots, Dual-axis, Geographical Maps in Tableau Desktop.
- I have installed Tableau Server and experience in adding Worker Nodes .
- Strong knowledge of Data Warehousing methodologies and concepts, including star schemas, snowflakes, dimensional modelling and reporting tools.
- Experienced in publishing workbooks with different User Filters to Tableau Server and managing Schedules, Permissions, and authorization.
- Created actions, custom made relationships, data blending, filters, calculated fields, parameters, hierarchies, groupings, sorting, live and extract connections, drill down analysis on Tableau Desktop.
- Extensive working knowledge on advanced Tableau features – Clustering, Level of Detail expressions, Parameters, Sets, Groups, Forecasting, viz in a Tool tip, Data Blending etc.
- Created advanced analytical dashboards using Reference Lines, Bands and Trend Lines.
- Experience in development of user defined reports to give on demand data analysis utilizing Excel and created charts and pivot tables in Excel.
- Experience including technical support, troubleshooting, report design and monitoring of system usage in SAP Business Objects.
- Proven capacity in Tableau, SAS, SQL, and Excel.
- Good experience in using URL's, Hyperlinks, Filters for developing Complex dashboards.
- Worked with ETL Tools such as SSIS (SQL Server Integration Services) and experience in creating Custom SQL Queries on Tableau.
- Extensive hands-on experience on BASE SAS, SAS Enterprise Guide and SAS Enterprise Miner in performing data analysis.
- Built users, groups, projects, data connections, settings as a tableau administrator.
- Proficient in building Calculations (Hide Columns, Creating/using Parameters, Table Calculations, Totals) and Formatting (Annotations, Layout Containers, Mark Labels, Rich Text Formatting) using Tableau Desktop.
- I worked on developing Dashboard reports for the Key Performance Indicators (KPI) for the top management.
- Strong understanding of project life cycle and SDLC methodologies including Waterfall and Agile.
- Highly motivated team player and a Quick Learner with good communication, strong problem-solving skills, and excellent presentation and interpersonal skills.
- Exceptionally well organized, meticulous, and highly self - motivated.
Overview
9
9
years of professional experience
Work History
Tableau BI Engineer
Toyota Financial Services
Plano, TX
10.2021 - Current
- Actively participate in initial and review meetings with business users to ensure that the development of projects meets business and system requirements for design development testing and production rollover of reporting and analysis projects within Tableau Desktop.
- Involved in testing the SQL Scripts for report development, Tableau Dashboards, Scorecards and handled the performance issues effectively.
- Tested dashboards to ensure data matched as per the business requirements and if there were any changes in underlying data.
- Worked with business stakeholders and participated in requirement gathering sessions to understand the business needs.
- Responsible for creating dashboards and overall creation of data visualizations.
- Communicate with internal clients to develop and translate a business requirement into a practical and insightful interactive analytical dashboard.
- Quickly and effectively diagnose and respond to service desk requests regarding data integrity and functional or interactive issues in existing and future dashboards.
- Created dashboard designing with effective data visualization of large data volumes from various data sources (SQL Server, oracle, spreadsheets, etc.).
- Developed Tableau data visualization using Cross Map, Scatter Plots, Geographic Map, Pie Charts and Bar Charts, and Density Chart.
- Prepared Dashboards using calculations, parameters in Tableau and created calculated fields, groups, sets, and hierarchies, etc.
- It is used Oracle, SQL server as data sources for designing Tableau Reports and Dashboards.
- Generating tables employing various SAS data steps and procedures with Statistical SAS procedures, graphs, and plots .
- Provided customer support to Tableau users and Wrote Custom SQL to support business requirement s.
- Worked creating Aggregations, calculated Fields, Table calculations, Totals, percentages using Key Performance Measures (KPI), and Measure.
- Expert level capability in Tableau calculations and applied complex, compound calculations to large, complex data sets.
- Involved in Planning, Defining, and Designing data based on business requirements and provide documentation.
- Performed Tableau Server admin duties; add users/groups from Active Directory; and schedule instances in Tableau Server, including weekly data dump.
- Created Schedules and extracting the data into Tableau Data Engine.
- Building, publishing customized interactive reports and dashboards, report scheduling on Tableau server.
- Created and implemented Tableau best-practices on migrating and governing the dashboards in multiple environments.
- Environment: Tableau Desktop (2020.3, 10.3 & 9.3), Tableau Server, SQL Server 2012, IBM DB2, MS office 2007, MS Access.
- Spearheaded energy management program to drive performance and minimize operating costs.
- Organized and prioritized competing priorities to maximize personal and team productivity.
Tableau Developer
Verizon
Tampa, FL
01.2018 - 09.2021
- Created Tableau scorecards, dashboards utilizing stack bars, bar graphs, scattered plots, geographical maps, Gantt charts utilizing show me functionality and publishing them to tableau server and Tableau Online.
- Extensively worked on meta data in Tableau desktop to alter data types, rename fields, joins, assign roles, refresh data, and change extract data options to prepare data sources to be utilized by users.
- Built interactive dashboards and stories using Tableau Desktop for accuracy in report generation applying advanced tableau functionality: parameters, actions, and toolkit changes.
- Created advanced analytical dashboards using Trend Lines, Forecasting, Linear Regression Models etc.
- Combined structured and semi-structured data using Snowflake.
- Developed effective and interactive Dashboards using Dashboard objects and Dashboard Actions.
- Optimized current pivot table reports using Tableau and proposed an expanded set of views in the form of interactive dashboards using line graphs, bar charts, heat maps, trend analysis, Pareto charts, and bubble charts to enhance data analysis.
- Involved in upgrade of Tableau Server from 10.0 to 10.5 and created Users Groups, Projects, and assigned Access levels in Server.
- Defined best practices for Tableau report development and effectively used data blending feature in Tableau
- Worked with pivot tables, v-lookup, graphs, and charts to analyze large sets of data using Excel.
- Created SQL queries for data extraction and transformation to make certain that the data is properly extracted for building Tableau dashboards.
- Designed and developed a business intelligence dashboard using Tableau Desktop, allowing executive management to view current, forecast, and past sales data.
- Worked with multiple data sources joins in Tableau Desktop.
- Worked on designing and developing Tableau visualization solutions and Created Business requirement documents and plans for creating dashboards.
- The building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
- Write PL/ SQL queries to develop standard procedures and functions for developing reports using SSRS.
- Working with a team of developers designed, developed, and implemented a BI solution for Sales, Product, and Customer KPIs.
- Designed the architecture of Tableau security by customizing the access levels and creating various user groups by assigning row and column level security at the application level, folder level, and user level.
- Worked on creating interactive, real-time dashboards using drilling downs and customizations.
- Consolidating data from different sources like DB2, SQL Server & Oracle for data manipulation and data cleansing purpose using SAS Data Integration Studio 4.2 and SAS Enterprise Guide.
- Published Tableau dashboard on Tableau Server or Tableau Online and embedded them into the portal.
- Good SQL reporting skills with the ability to create SQL views and write SQL queries.
- Environment: Tableau desktop 9.1.1 tableau server, SQL Server 2012.
- Analyzed business requirements and created functional requirements specifications to build and deploy solutions.
- Elicited business pain points and established technical and data capabilities.
Tableau Developer
American Express
Arizona City, AZ
11.2016 - 12.2018
- Created dashboards for scenario analysis, variance analysis, monthly and quarterly reports and Ad-hoc reports.
- Created Histograms, Scatter plots, box plots, and filled area charts wherever there was a need to show data distribution.
- Created line graphs to show the trend over the period.
- Analyzed massive and highly complex data sets, performing ad-hoc analysis and data manipulation.
- Wrote reports using Tableau reporting system to extract data for analysis using filters based on the research.
- Developed Tableau reports including highlight tables, stacked bars, side by sidebars, symbol maps, filled maps, heat maps.
- Created a demo-able marketing database (logical and physical data modelling) to show BI tools (Business Objects and Tableau) functionality.
- Generated context filters and user-based performance actions while handling large volumes of data in the project.
- Interacted with business stakeholders, gathered dashboard requirements, and managed the delivery.
- Implemented Security Features of Business Objects like row-level, object-level to make the data secure.
- Documented various business requirements, deployment plans, and organized several user's courses to facilitate the users to learn and adapt to the new systems.
- Used calculated fields substantially for exceptional logics for Trend, Extended price calculations for the distinctive cost types.
- Analyzing raw data, drawing conclusions & developing recommendations.
- Adept in data extraction and preparation methodologies.
- Environment: Tableau 7.0/8.0, Teradata 13.10, Teradata SQL Assistant, SQL, Share Point, Agile-Scrum, Microsoft Office Suite.
- Analyzed business requirements and created functional requirements specifications to build and deploy solutions.
- Elicited business pain points and established technical and data capabilities.
SQL Server Developer / Data Analyst
Western Union
Austin, TX
01.2015 - 10.2016
- Experienced in creating SQL queries and optimizing the queries in SQL Server.
- Created Stored Procedures, Triggers, Cursors, Tables and Views, and other SQL joins and statements for applications.
- Generated Reports on a Weekly, Monthly, Quarterly Basis .
- Extracted and reviewed data from heterogeneous sources like (Excel, CSV, Oracle, flat file, Text Format Data) using SQL Server Integration Services (SSIS) from OLTP to OLAP.
- Implemented Data Mart, Facts, Dimensions, Snowflake schema, Star Schema, and OLAP cubes.
- Experienced in creating actions, filters, data blending, sorting, grouping, establishing live connections from SQL Server to Tableau.
- Development of Interfaces, Packages, Procedures & Cursors using SQL and PL/ SQL.
- Worked on developing excel reports using SQL navigator.
- Responsible for tuning and Optimizing Queries for the reports.
- Expert in SQL Server Management Studio interfaces for writing queries and stored procedures.
- Created and maintained Roles and Database users.
- Worked in visually enhancing reports as per user requirements.
- Created database objects like views, indexes, user-defined functions, triggers, and stored procedures.
- Responsible for troubleshooting the reports.
- Environment: PL/SQL, SQL Server Management Studio, SSIS.
- Followed standard practices for migrating changes to test and production environments.
- Implemented system enhancements to design and develop solutions to address problem reports.
Education
Master of Science - Information Technology Project Management
The University of Tampa
Tampa, FL12.2014
Bachelor of Science - Computer And Information Sciences
MLRIT
Hyderabad, India03.2013
Skills
- Analytics Tools: Tableau Desktop v8x/v9x/v10x, Tableau Server v9x/v10 Tableau Online v9x/v10x, Tableau Reader, Tableau Public, Tableau Mobile, SAS
- Database Skills: SQL Server, Oracle, Teradata, Microsoft Access
- Programming Languages: Python, R, SAS, SQL
- Applications: Word, Excel, PowerPoint, SharePoint, Outlook, Open Refine
- Data Modelling: MS Visio, Star Schema Modelling, Snowflake Modelling
- ETL Tools: Informatica, SSIS, Microsoft SQL Server Integrated
Timeline
Tableau BI Engineer
Toyota Financial Services
10.2021 - Current
Tableau Developer
Verizon
01.2018 - 09.2021
Tableau Developer
American Express
11.2016 - 12.2018
SQL Server Developer / Data Analyst
Western Union
01.2015 - 10.2016
Master of Science - Information Technology Project Management
The University of Tampa
Bachelor of Science - Computer And Information Sciences
MLRIT