Data Technical Support
Resume:
Kumar
*****.*********@*****.***
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