Resume

Sign in

Data Technical Support

Location:
Cumming, Georgia, United States
Posted:
January 29, 2018

Contact this candidate

Kumar

ac38ob@r.postjobfree.com

810-***-****

Professional Summary

Over 8 years of IT experience with 5 years of experience in Tableau Desktop/Server

Extensive Tableau Experience in Enterprise Environment and Tableau Administrator Experience including technical support, troubleshooting, report design and monitoring of system usage.

Hands on Experience on Data Visualization tools like Tableau, MicroStrategy

Certified Tableau Desktop 10 Qualified Associate

Involved in creation of Data visualization reports, workbook prototypes for Business users and peer groups

In-depth knowledge on Tableau Desktop, Tableau Reader and Tableau Server.

Strong experience with Agile methodologies and the ability to manage team,appropriate to meet business and technology needs

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

End to end experience in designing and deploying data visualizations using Tableau.

Build and manage the experience design process, workflow, and integration with agile with SDLC

Generation of Dashboards with Quick filters, Parameters and sets to handle views more efficiently in Tableau.

Knowledge of System Development Life Cycle (SDLC) and Software Testing Life Cycle (STLC).

Data blending implementation on EMPI databases and generated interactive dashboards.

Creating adhoc reports to users in Tableau by connecting various data sources.

Technically strong in SQL, PL/SQL, Procedures, Packages, Functions, Triggers, SQL Loader.

Extensive Tableau Experience in Enterprise Environment and Tableau Administrator Experience including technical support, troubleshooting, report design and monitoring of system usage

Actively participate in review meetings with Project Manager to ensure that the development of projects meet business and system requirements for design development testing and production rollover of reporting and analysis projects within Tableau Desktop.

Hands on Experience on ETL Tools like Informatica, SSIS,SSRS

Expertise in designing and development of various dashboards, reports utilizing various Tableau Visualizations like Dual Axis, Bar Graphs, Scatter Plots, Pie-Charts, Heat Maps, Bubble Charts, Tree Maps, Funnel Charts, Box Plots, Waterfall Charts, Geographic Visualization and other making use of actions, other local and global filters per the business/client requirement

Building and publishing Tableau reports utilizing complex calculated fields, table calculations, filters, parameters.

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

Expertise in Tableau Data Extracts, Data Blending, Dashboard actions, Row Level Security etc.

Extensive experience in Tableau Administration Tool for Configuration, adding users, managing licenses, data connections and scheduling tasks.

Published of various kinds of interactive data visualizations, dashboards and workbooks from Tableau Desktop to Tableau Servers

Experience in creating aggregates, sets, Joins, bins, hierarchies, sorting, grouping, actions, table calculations, calculated measures and parameters

Experience in creating, filters, quick filters, data source filters, global filters, context filters and user filters

Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop

Developed SQL database and BI solutions using T-SQL, SSIS, SSRS, MDX, query performance tunings, database development, support of data, and underlying data models

Experience in implementing Customized queries and advanced custom visualizations in Tableau.

Worked on Performance tuning, which included creating indexes, providing Hints, modifying tables, analyses tables and estimate stats using explain plan utility.

Hands on Experience on Tableau 10 .X Versions

Experience in SQL performance tuning using Cost-Based Optimization (CBO)

Expertise in handling errors using Exceptions of PL/SQL programs.

Automating data loading, extraction, reports generation using UNIX Shell scripting.

Experience in preparing the SQL and PL/SQL coding convention and standards.

Expertise in handling the Problem management, Release Management and the Change Management.

Experience in documenting Functional and Technical Specifications.

Extensive exposure to concepts of Data warehouse like Design, Data Modelling, OLTP, ETL and Reporting.

Technical Skills:

Data Visualization Tools

Tableau Desktop 10 .X9.x/8.x/7.x, Tableau Server 8.x, 9.x, Oracle, SQL Server

ETL Tools

Informatica 8/9.x, ODI10g,SSRS,SSIS

Operating Systems

Windows 2000/XP-Pro/Vista/7/8/10

Programming Languages

SQL, PL/SQL, T-SQL, C, C++, HTML 4.0

Database Tools

SQL Developer, PLSQL Developer, SQL* Plus, TOAD, T-SQL

RDBMS

Oracle 11g/10g/9i, SQL SERVER 2005/2008, DB2, Teradata, Netezza, Hadoop

Professional Experience

Foot Locker

Camp Hill PA Jan ’ 17–Till Date

Tableau Admin/Developer

Responsibilities:

Designing the Visualization Reports as per business Requirement.

Installed and configured Tableau Server and Tableau Desktop.

Worked extensively in creating dashboards using Tableau that includes tools like Tableau Desktop, Tableau Server and Tableau Reader in various versions of Tableau 10.x. Also, involved in the administration of Tableau server like installations, upgrades, user, user groups creation and setting up security features.

Worked closely with all team members in implementing Tableau BI tool in all IT projects. Generated reports using SQL queries in Tableau and published them to users in online thru Tableau server.

Performed generating Daily/Weekly Sales & Finance trending reports using Tableau by identifying the dimensions, measures, measure values and level of details for Business Analytics & Top Executives to give an overview current Trends.

Involved in meetings with business users to discuss and finalize the requirement and design of reports.

Worked on motion chart, Bubble chart, Drill down analysis using tableau desktop.

Managing the Metadata associated with the ETL processes used to populate the Data Warehouse.

Published of various kinds of live, interactive data visualizations, dashboards, reports and workbooks from Tableau Desktop to Tableau servers.

Identified the factors involving the performance of the reports and coordinated in creation of indexes, statistics to improve the query turnaround time efficiently.

Worked extensively with Advance Analysis Actions, parameters, dynamics groups and sets, data hierarchies, context and global filters, calculated fields, ad-hoc calculations, forecasting, reference lines, table calculations, background images, trend lines and other custom function like string functions, date functions and logical functions

Utilizing capabilities of Tableau such as Data extracts, Data blending, Forecasting, Dashboard actions and Table calculations.

Performance turning in Tableau to improve report response time.

Coding Custom SQL scripts for creating aggregate tables and generating views.

Responsible in designing and developing various Weekly and Monthly reports showing detailed information that could be used to send information to diverse group of users, clients, and managers.

Work with team members to understand and clarify visualization requirements needs and designing the database as per project requirement.

Deftly designing dashboard templates as per the requirement & dashboards content which includes complex tabular reports by Quality, Service, Cleanliness & Legal rating against compliance & supporting commentary per test, each carrying a weighting resulting in a total overall score, Bar charts, water fall charts, score cards, Gantt charts, Bubble charts, Word maps, Geospatial visualizations, network charts etc.

Assisting users with questions and issues using Tableau. Working with various infrastructure teams and Tableau support team to help improve dashboard response time.

Advocate the use of Tableau solution and help educate business users to facilitate early adoption of the tool.

Performed Tableau type conversion functions when connected to relational data sources.

Maintained and Installed Tableau Server in all the environments.

Hands on Experience on converting SAP HANA Files to Tableau

Created incremental refreshes for data sources on Tableau server.

Connected Tableau to various databases and performed Live data connections, query auto updates on data refresh etc.

Provided technical support to all team members during project execution

Performed reports/dashboards performance optimization

Recommending optimized design and chart for specific requirement.

Handling change requests and providing support/maintenance for deployed projects.

Environment: Tableau Desktop 10x,9x, Tableau Server 9, SQL Server, Oracle 10, Microsoft Office Suite (Word, Excel,

Power Point), HP ALM.Tableau Desktop 8.x, Tableau Server, Windows Server Standard R2, Excel, Oracle, Hadoop.

T Mobile

Seattle WA

Tableau /MicroStrategy Developer Aug 2014-Dec 2016

Responsibilities:

Building, publishing customized interactive reports and dashboards

Extensive use of data blending, filters, parameters, sets, groups etc., with best practices

Knowledge on installation, configuration, procurement assessment, machine uplifts.

Upgrades existing servers to 9.3, which facilitates automatic worker upgrades.

Defined best practices for Tableau report development.

Executed and tested required queries and reports before publishing.

Analyzed requirements for various reports, dashboards, scorecards and created proof of concept / prototype the same using Tableau desktop.

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.

Experience in creating advanced Custom Filters by using Pass-Through Expressions in Micro Strategy.

Expertise in creating interactive Dashboard Reports and Scorecards to view personalized reports based on user requirements.

Experienced with different kind of Dashboard like traditional performance summary, traditional metric, dynamic content and dynamic visualization dash boards applications and Score carding.

Extensively used advance chart visualizations in Tableau like Dual Axis, Box Plots, Bullet Graphs, Tree maps, Bubble Charts, Water Fall charts, funnel charts etc., to assist business users in solving complex problems.

Created Prompts, customized Calculations, Conditions and Filter (Local, Global), Parameters, Groups and sets for various analytical reports and dashboards.

Create and modify Interactive Dashboards and Creating guided navigation links within Interactive Dashboards.

Extensively used analytical features in Tableau like Statistical functions and calculations, trend lines, forecasting etc. in many tableau reports.

Publish the developed dashboard, reports on the Tableau Server so that the end users having access to the server can view the data.

Environment: Tableau Desktop version 9.3, Tableau Server, MySQL, Microsoft SQL Server, MongoDB, Windows, Tomcat, Microsoft Visual Studio, ERWIN

Virtusa Consulting

Hyderabad Jan’ 12 – June ’ 14

Business Intelligence Developer

Responsibilities:

Worked extensively in creating dashboards using Tableau that includes tools like Tableau Desktop, Tableau Server and Tableau Reader in various versions of Tableau 7, 6 and 5.1.

Involved in the administration of Tableau server like installations, upgrades, user, user groups creation and setting up security features

Worked closely with all team members in implementing Tableau BI tool in all IT projects

Generated reports using SQL queries inTableau6.0/7.0 and published them to users in online through Tableau server

Involved in generating Daily/Weekly Sales & Finance trending reports using Tableau by identifying the dimensions, measures, measure values and level of details for Business Analytics & Top Executives to give an overview current Trends

Worked on motion chart, Bubble chart, Drill down analysis using tableau desktop

Managing the Metadata associated with the ETL processes used to populate the Data Warehouse

Involved in publishing of various kinds of live, interactive data visualizations, dashboards, reports and workbooks from Tableau Desktop to Tableau servers

Identified the factors involving the performance of the reports and coordinated in creation of indexes, statistics to improve the query turnaround time efficiently

Involved in Installation and upgrade of Tableau server and server performance tuning for optimization

Worked on creation of users, groups, projects, workbooks and the appropriate permission sets for Tableau server logons and security checks

Assisted users to publish and collaborate reports via a web browser embed Tableau views in other web applications like SharePoint.

Design and development of new MicroStrategy Reports for the new Retail BI system- created Schema objects / Application objects as well as configuration objects in Test environment.

As MicroStrategy Architect Involved in building schema objects to supported business process change or enhancements throughout projects.

Handling Daily user issues - Setting up and maintaining MicroStrategy web user roles and preferences, helped in resolving daily issues in running Reports and Data Integrity issues.

Environment: MicroStrategy,Tableau, SQL Server,Teradata,Inforamtaica,SSIS,SSRS

iSpace Global Services, Hyderabad, India Jun’ 09– Oct’ 11

SQL Developer

Responsibilities:

Worked on different stages of Project Life Cycle.

Created new Databases, tables, established relationship among tables in a database.

Created stored procedures and functions to support efficient data storage and manipulation.

Created views to display required information on user interface, and triggers to validate consistent data entry into the database.

Designed and developed complex procedures to handle errors and exceptions at both application and database level using PL/SQL and shell scripts.

Conducted code review to ensure development standards.

Used export and import utilities for logical backups.

Implemented various Error/Exception handling methods using system defined exceptions and user defined exceptions.

Used Bulk Collections, Indexes, and Materialized Views to improve the query executions.

Used SQL *LOADER to load large amounts of data from external files to database.

Created and Scheduled DTS packages to pull data from SQL Server and exported to Excel Spreadsheets and vice versa.

Scheduled Jobs using SQL Server Agent. Identified, tested, and resolved database performance issues (monitoring and tuning) to ensure database optimization.

Maintaining jobs for data messaging from development server to test server for generating daily reports for

Created different user level groups, and assigned appropriate permission level to the database.

Environment: Oracle Database 9i, MS EXCEL, T-SQL, UTL_FILE, SQL*Loader, Windows XP

Education:

Bachelor’s in Engineering in Information Technology, Hyderabad, India.



Contact this candidate