Tableau Dev
Resume:
Sanketh
Tableau Developer
Professional Summary:
7+ Years experience working with Business Intelligence data visualization tools with specialization on Tableau 7.0/8.0/9.0/10
As Tableau Developer, responsible for creating wonderful visualizations to help clients to take their decisions.
Consistently delivered results in various stages of Software Development Life Cycle (SDLC).
Have been working with various data sources such as Oracle, SQL Server, ODBC and flat file sources
Extensive experience in Business and Data Analysis along with 5 years of data visualization using Tableau Desktop.
Created solution driven dashboards by developing different chart types including Crosstab's, Heat/Geo/Tree Maps, Pie/Bar Charts, Circle Views, Line/Area Charts, Scatter Plots, Bullet Graphs, and Histograms in Tableau Desktop.
Tableau tools include Tableau Desktop versions and recent implementation of 8.2, Tableau Server, Tableau Public, and Tableau Reader.
Administered user, user groups, and scheduled instances for reports in Tableau. Installed patches on server and documented upgrade plan form Tableau 8.0 to Tableau 8.1
Extensive Knowledge of Tableau Server Concepts like tabcmd, tabadmin, creating users, sites and projects.
Involved in Trouble Shooting, Performance tuning of reports and resolving issues within Tableau Server and Reports.
Worked on generating various dashboards in Tableau server using various sources such as Teradata
Good in writing T-SQL, working on SSIS, SSRS, Data Migration.
Experienced in designing customized interactive dashboards in Tableau using Marks, Action, filters, parameter, calculations and Relationships.
Having knowledge on gather business requirements and translate them into reporting needs.
Recommending Dashboards per Tableau visualization features and delivering reports to Business team on timely manner.
Used Alteryx for Data Blending and Analytics.
Designed and Developed matrix, tabular, parametric and Sub Reports in the SQL Server Reporting Services (SSRS) 2012.
Successfully upgraded Tableau platforms in clustered environment and performed content
Established Best Practices for Enterprise Tableau Environment and application intake and Development processes.
Designing, Developing and supporting interactive Tableau Dashboard reports.
Experience in Marks, Publisher, Security concepts, creating Worksheets and Dashboard using Tableau.
Extensive experience in Analysis, Design, Development, Implementation, Deployment and maintenance of Business Intelligence applications.
Knowledge of Data warehouse Concepts and methodologies.
Expertise in identification of Business and Data requirements and converting them into conceptual and logical data models.
Generated the OLAP cubes, and extracted the related reports through SSRS
Performed Extract, Transform and Load operations from the databases using SSIS. Also, created the merge, lookup and send mail tasks.
Created triggers, stored procedures and complex queries.
Significant experience in developing practical and effective data visualizations.
Detail-oriented problem solver, quick learner, and flexible team player
Excellent skills in communication & collaboration, interest & ability to learn new technologies in short time
Technical Skills:
Reporting Tools:
Tableau 10/9.x/8.x/7.x/, SSRS, Crystal Reports, Business Objects
Databases:
SQL Server, DB2, Oracle, Netezza, Teradata
ETL Tools
SSIS, SSAS, Informatica 7.x/8.x
Internet Tools:
HTML, DHTML, XML,VB Script, Java Script, JSP, ASP
Languages:
SQL, PL/SQL, C/C++, C#, Java, Shell Scripting
Operating Systems:
MS-DOS, UNIX, WINDOWS 98/2000/NT 4.0/XP/Vista, AIX 5.1\5.3, Sun Solaris 2.7\2.8, Linux
Testing Tools:
Quick Test Professional QTP, Win runner, Load Runner
Experience:
Capital One, Richmond, VA Feb 2015 to present
Tableau Developer
Responsibilities:
Assisted in complete Life Cycle including Design, Development and Testing
Created Sub Reports, Parameterized and Drill down Reports based on the requirements provided
Deployed the generated reports onto the report server.
Formatted the reports using the Global variables and expressions.
Deep experience with the design and development of Tableau visualization solutions.
Background in installing and upgrading of Tableau server and server performance tuning for optimization.
Involved in license management SLA’s with Tableau support.
Defined and created procedures to install Tableau desktop in silent mode.
Extensively used Tab admin and Tab cmd commands in creating backups and restoring backups
of Tableau repository.
Administered user, user groups, and scheduled instances for reports in Tableau.
Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.
Extensively used Alteryx for giving Data analysis and BI software with SQL Server.
Defined best practices for Tableau report development.
Experience with creation of users, groups, projects, workbooks and the appropriate permission sets for Tableau server logons and security checks.
Preparing Dashboards using calculations, parameters in Tableau.
Strong hands on experience using Teradata utilities (SQL, Fast Load, MultiLoad, Fast Export, T pump, Visual Explain, Query man) and Teradata parallel support.
Created Parameterized reports, Cross-Tab reports, Drill down reports& Summary reports by using SSRS using SQL Server.
Proficient in coding of optimized Teradata batch processing scripts for data transformation, aggregation and load using BTEQ.
Understanding of relational database structures, theories, principles, and practices.
The ability to interact professionally with a diverse group, including executives, managers, and LOB.
Excellent analytical, problem solving and debugging skills, with strong ability to quickly learn and comprehend business processes and problems in order to effectively develop technical solutions to their requirement.
Designed and Developed matrix, tabular, parametric and Sub Reports in the SQL Server Reporting Services 2012.
Found ways to make graphs and tables visually exciting, and aesthetically pleasing, while maintaining the accuracy of the core information content that is being communicated
Proof-read all documents and maintain accuracy of information and preparing SOP.
Responsible for Developing a Dashboard and preparing ad-Hoc Reporting.
Managed and created and altered Databases, Tables, Views, Indexes, Constraints with business rules using T-SQL
Developed complex Stored Procedures, Triggers, User Defined Functions based on the requirement
Environment: Tableau Server 7.0, Oracle SQL Developer, SQL server, HPQC, Oracle 11g, java 1.5
platform, Teradata, Microsoft office 2007, Business objects, SQL, PL/SQL, T-SQL.
Money Gram, Golden Valley, MN Feb 2013 – Jan 2015
Tableau developer
Responsibilities:
Actively involved in gathering requirements from end users, involved in modifying various technical &, functional specifications.
Analyzed various reports, dashboards, scorecards in Micro Strategy and created the same using Tableau desktop server.
Mentored 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 data sources together on one dashboard to filter data in multiple views.
Involved in new KPI generation for Scorecards.
Data collection and leveraging on data manipulation teams for required data.
Developed complex SQL scripts for Teradata database for creating BI layer on DW
for tableau reporting.
Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
Created actions, parameters, Filter (Local, Global) and calculated sets for preparing dashboards and worksheets using Tableau.
Effectively used data blending, quick filters, actions, hierarchies’ features in tableau.
Executed and tested required queries and reports before publishing.
Converted Metric insight reports to tableau reports.
Analyzed the data using statistical features in tableau to develop Trend Analysis reports.
Experience in assisting users in creating and modifying worksheets and data
visualization dashboards.
Scheduled frequency and time to refresh data for the data sources are publishes or
extracted to server.
Design and development of various reports and dashboards that can be easily
accessible through Tableau App in IPad, IPhones, and other smart mobile phones.
Environment: Tableau 7/8.2 Desktop, Tableau server, Oracle 11i, SQL, SQL*Plus, TOAD, Windows 2003/ XP, UNIX.
Abbvie, Waukegan, IL May 12 – Feb 13
Tableau Developer
Responsibilities:
Designed automated scripts in T-SQL, DTS, and BCP to import data from various ODBC sources into SQL Server databases to maintain the consistency and data integrity.
Exposed to data conversion from different data sources to SQL Server 2012 using SSIS.
Experienced in ETL (Extracting, Transforming and Loading) development using DTS and SSIS for migration of data between legacy systems to SQL Server 2012.
Experience in developing and monitoring SQL Server Integration Services (SSIS), Microsoft SQL Server Reporting Services (SSRS),
Developed and maintained graphs, tables, slides and document templates for the efficient creation of reports.
Interacted professionally with diverse group of professionals in the organization including managers and executives.
Experienced in standardizing Tableau for shared service deployment.
Developed Standard Operating Procedures (SOP) for Monitoring.
Extensively used data blending, embed functionalities in Tableau.
Deployed Tableau Server in clustered environment by mapping server nodes to primary machine.
Building, publishing customized interactive reports and dashboards, report scheduling using
Tableau server. Creating New Schedule's and checking the task's daily on the server.
Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots,
geographical maps, Gantt charts using show me functionality.
Worked extensively with Advance analysis Actions, Calculations, Parameters, Background
images, Maps.
Trend Lines, Statistics, and Log Axes. Groups, hierarchies, Sets to create detail level summary report and Dashboard using KPIs.
Gathered user requirements, analyzed and designed software solution based on the requirements.
Interacted with Business Analysts and Data Modelers and defined Mapping documents and
Design process for various Sources and Targets.
Defined best practices for Tableau report development and effectively used data blending feature in tableau.
Involved in creating database objects like tables, views, procedures, triggers, functions using T-SQL to provide definition, structure and to maintain data efficiently.
Environment: Tableau Server 7.0, Oracle SQL Developer, SQL Assistant, Oracle 11g, java 1.5 platform, Teradata, Microsoft office 2007, Business objects, SQL, PL/SQL, T-SQL.
Reddy’s Laboratories, Hyderabad, India May10 – Apr 2012
SQL Server Developer
Responsibilities:
Developed SQL Server Stored Procedures, Tuned SQL Queries (using Indexes)
Analyzed the requirements and selected the appropriate fact tables/created fact tables
Selected the dimensions required based on the analysis requirements, Created the new dimensions, Shared dimensions, and time dimensions
Configured SSRS 2005 for directly deploying the report in SharePoint 2007.
Wrote DTS packages to transfer data from heterogeneous database & different files format (Text File, Spread Sheet) to SQL Server.
Actively involved in Normalization & De-normalization of database
Materialized views, dimensions and stored outlines for optimal performance
Wrote Triggers and Stored Procedures to capture updated and deleted data from OLTP systems
Used SSRS Reports to write complex formulas and to query the database to generate different types of ad-hoc reports for Business Intelligence
Environment: SQL Server 2005 Enterprise Edition, Enterprise manager, Crystal Reports, Erwin MS, PowerPoint, MS Project.
Contact this candidate