Arun Goud Email and Phone Number

• Interacted with business users and performed Gap Analysis of Client requirements.• Prepared Business Requirement Document and then converted business requirements into Functional Requirements Specification.• Worked with the report development Manager and other team members on report requirements based on existing reports/dashboards in Business Objects, timelines, testing, and technical delivery.• Worked closely with business power users to create reports/dashboards using tableau desktop.• Designed and Developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.• Utilized advance features of Tableau software like to link data from different connections together on one dashboard and to filter data in multiple views at once.• Created Prompts, customized Calculations, Conditions and Filter (Local, Global) for various analytical reports and dashboards.• Create and modify Interactive Dashboards and Creating guided navigation links within Interactive Dashboards.• Created Table of Contents (TOC), a common navigation page which had all the links to various reports.• Responsible for migrating tables from traditional RDBMS into Hive tables and later generate required visualizations and dashboards using Tableau.• Make use of filters and making them local and global accordingly.• Publish the developed dashboard, reports on the Tableau Server so that the end users having access to the server can view the data.• Scheduled frequency and time to refresh data for the when sources are publishing or extracted to server. • Design and development of various reports and dashboards that can be easily accessible through Tableau App in IPad’s, IPhone’s, and other smart phones.• Responsible to facilitate load testing and benchmarking the developed product with the set performance standards.

• 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. • Effectively used data blending feature in tableau. • Defined best practices for Tableau report development. • Administered user, user groups, and scheduled instances for reports in Tableau. • Executed and tested required queries and reports before publishing. • Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop down menu option and Parameterized using Tableau.• Created side by side bars, Scatter Plots, Stacked Bars, Heat Maps, Filled Maps and Symbol Maps per deliverable specifications. • Consistently attended meetings with the Client subject matter experts to acquire functional business requirements to build SQL queries that would be used in dashboards to satisfy the business’s needs.• Extensive experience in Tableau Administration Tool, Tableau Interactive Dashboards, Tableau suite.• Provided support for Tableau developed objects and understand tool administration.• Worked in Tableau environment to create dashboards like weekly, monthly, daily reports using tableau desktop & publish them to server.• Created Custom Hierarchies to meet the Business requirement in Tableau.• Manage Production, Test and Development environments including installation of patches, security administration and access controls in Tableau.• Created Workbooks and dashboards for analyzing statistical billing data using Tableau 8.0• Created various connections, Data foundations and Business layers using Information Design Tool 4.1 (IDT)for AP Reporting. • Converted WEBI Reports to Tableau Dashboards for Advanced Visualizations.• Converted Xcelsius dashboard to Tableau Dashboard with High Visualization and Good Flexibility.

• Responsible for design and development of Sales Data Warehouse.• Worked with Business Analyst and application users to finalize Data Model, functional and detailed technical requirements.• Creation of user, groups, folder structures, library and repository Tableau server logons and security checks.• Created Advance connections, join new tables, create & manage Extract and Monitor Queries using SQL Assistant.• Created Complex workbooks and Dashboards by connecting to multiple data source (Teradata) using data blending.• Created Tableau scorecards, dashboards, Heat maps using show me functionality.• Good Experience in publishing reports and dashboards to Tableau server• Created complex data Views Manually using multiple measures, also used sort, Filter, group, Create Set functionality.• Published Reports, workbooks & data source to server and exporting the reports in different Formats.• Good experience in using URL’s, Hyperlinks, Filters for developing Complex dashboards.• Worked on creating Aggregations, calculated Fields, Table calculations, Totals, percentages using Key Performance Measures (KPI) and Measure• Validated the reports before publish reports to server.• Administered user, user groups, and scheduled instances for reports in Tableau. • Collected data on various process measurements and formatted into graphs using Tableau • software. • Building, publishing interactive reports and dashboards, report scheduling using Tableau Server.• Set up Tableau Desktop, Data Analysis and publishing reports.• Wrote custom T-SQL stored procedures and triggers to improve performance, preserve referential integrity, and provide additional application functionality.

• Gathering business requirements• Creating database objects like tables, synonyms, sequences and views.• Created, edited procedures and functions to suite the improved business requirements.• Created records and nested tables in the procedures for handling of data.• Used SQL Loader to load data into the database coming from Knipper and FICO.• Used export/ import and exp dp/imp dp database utilities for data transfer.• Coded complex SQL queries to retrieve data from the database depending on the need.• Created Cursors and Ref cursors as a part of the procedure to retrieve the selected data.• Made use of Bulk Collect feature to process the data from cursor/ Ref Cursors.• Made use of Sub Query-Factoring (WITH clause) to make complex SQL statements simple and make them more efficient.• Using set operators in PL/SQL like Union, Union all, Intersect and Minus.• Performed exception handling for the procedures created.• Written and edited shell scripts to automate the execution of the procedures and report the results through e-mail.• Worked with performance tuning tools like Oracle optimizer, explain plan, hints to improve the database performance.• Support for the development, test and the production databases.• Used SQL plus and TOAD to develop database applications.• Documentation of the technical work done.

• Reading data from different sources like .csv, excel, tab delimited files.• Perform various business checks on the source data to confirm whether data is correct or not.• Compare the source data with historical data to get some statistical analysis.• Perform transformations like Merge, Sort and Update etc.to get the data in required format.• Generate Reports in user required format by using ODS and PROC Report.• Experience in resolving anomalies in the production database.• SAS data sets are validated using SAS procedures like Proc Means, Proc Frequency and Proc Univariate.• Created indexes for faster retrieval and improved query performance.• Performed data integrity checks and data cleaning using SAS MACROS and data steps, created HTML outputs with table of contents using ODS HTML.