Tableau Data Analyst Resume Profile
DE
PROFESSIONAL Summary
- Over 8 years of Data warehousing experience with Business Intelligence tools Tableau 8.2/8.1/8.0/ 7.0, OLTP and OLAP Microsoft SQL Server, Microsoft Excel as Developer in various companies.
- Involved in creating Dashboards, reports as needed using Tableau Desktop and Tableau Server.
- Extensively used Tabadmin and Tabcmd commands in creating backups and restoring backups of Tableau repository.
- Involved in installation of Tableau desktop 8.0, Tableau server Application software.
- Involved in creating dashboards and reports in Tableau 8.1. Created report schedules on Tableau server.
- Administered user, user groups, and scheduled instances for reports in Tableau and documented upgrade plan from Tableau 8.0 to Tableau 8.1.
- Created incremental refreshes for data sources on Tableau server.
- Creating users, groups, projects, Data connections, settings as a Tableau administrator.
- Extensively worked on Tableau Administrator and Tableau Server.
- Proficient in designing techniques like Snowflake schemas, Star schema, fact and dimension tables, logical and physical modeling.
- Preparing Dashboards using calculations, parameters in Tableau.
- Extensive knowledge in various reporting objects like Facts, Attributes, Hierarchies, Transformations, filters, prompts, Calculated fields, Sets , Groups, Parameters etc., in Tableau.
- Involved in Development, Production Support and Maintenance for MAINFRAME based applications.
- Work experience in Mainframe Technology including Utilities / tools and Database.
- Extensive exposure to different phases of SDLC process starting from analysis through evolution in Banking, Retail and Telecom Domain.
- Possess strong architectural background of software components.
- Technologies used include Oracle-based DB2, Data Stage Tools.
- Received Galaxy of Thanks Award for excelling performance at TCS.
- Received Customer Appreciation certificate for an extra ordinary work in Projects.
- Involved in PCI activities and Weekly Call driving for the whole Platform.
- Quest for knowledge and endorsement by the customer and team members for excellent oral / written communication skills.
- Experience in SQL Server development, System Analysis, Design, Development Support of MS SQL Server 2012, 2008, 2005 and 2000.
Technical Skills
Process | Development, Support and Maintenance |
Data Modelling Tools | Star Schema Modelling, Snow Flake Modelling |
Reporting Tools | Tableau 8.2,8.1/8.0/7.0, Oracle BI Administration Tool, Oracle BI Answers, Oracle BI Delivers |
Technology | TABLEAU, MAINFRAMES, JAVA |
Technical Languages | JCL, COBOL,DB2, CICS, Data Stage, Java, Hadoop Eco System Trainee , PL/SQL, Unix Shell Scripting |
Tools Used | CA 7, SOFTECH, PLATINUM, ABEND-AID, FILE-AID, ENDEAVOR, PJS, XPEDITOR, STROBE, CMAN |
Databases | MS SQL Server 2005/2008/2012, MS Access |
Domains | Telecom, Financial, Banking, Retail |
Web Tools | HTML, DHTML, XML, JAVA SCRIPT |
Others | MS Word, Excel, VISIO 2007 |
Project Experience
Confidential
Tableau Data Analyst/Developer
Responsibilities:
- Effectively interacted with Business Analysts and Data Modelers and defined Mapping documents and Design process for various Sources and Targets.
- Gathered user requirements, analyzed and designed software solution based on the requirements.
- Involved in creating database objects like tables, views, procedures, triggers, functions using T-SQL to provide definition, structure and to maintain data efficiently.
- 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.
- Converted metric insight reports to tableau reports.
- Create, customize share interactive web dashboards in minutes with simple drag drop.
- See a comprehensive view of your sales pipeline and results.
- Access dashboards from any browser or tablet.
- Involved in installation of Tableau desktop 7.0, Tableau server Application software
- Creating users, groups, projects, Data connections, settings as a tableau administrator.
- Involved in creating dashboards and reports in Tableau 8.1. Created report schedules on Tableau server.
- Creating New Schedule's and checking the task's daily on the server
- Maintaining server activities, user activity, and customized views on Server Analysis.
- Created Business requirement documents and plans for creating dashboards.
- Involved in creating ad hoc analysis and reporting requests in a timely manner for BML Risk related to fraud Approval's, Declines daily, monthly and yearly
- 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 KPI's
- Created organized, customized analysis and visualized projects and dashboards to present to Senior Level Executives.
- Good SQL reporting skills with the ability to create SQL views and write SQL queries highly recommended
- Deep experience with the design and development of Tableau visualization solutions
- Provided 24/7 production support for Tableau users.
Environment: Tableau Desktop 8.2/8.1/8.0, Tableau server / Administrator, SQL Developer, SQL 2008
Confidential
Tableau Data Analyst/Developer
Responsibilities:
- Worked with Business Analyst and the Business users to understand the user requirements, layout, and look and feel of the application to be developed.
- Data blending implemented on databases and generated interactive dashboards.
- Created adhoc reports to users in Tableau by connecting various data sources.
- Handled Tableau admin activities granting access, managing extracts and Installations.
- Generated Dashboards with Quick filters, Parameters and sets to handle views more efficiently.
- Published Workbooks by creating user filters so that only appropriate teams can view it.
- Analyzed the source data and handled efficiently by modifying the data types.
- Used excel sheet, flat files, CSV files to generated Tableau adhoc reports.
- Generated context filters and used performance actions while handling huge volume of data.
- Generated tableau dashboards for sales with forecast and reference lines.
- Generated tableau dashboards with combination charts for clear understanding.
Environment: Tableau Desktop 8.2/8.1/8.0, Tableau server / Administrator, SQL Developer, SQL 2008
Confidential
Software Developer
Responsibilities:
- Involved in Development activities, gathering business requirements for work teams and perform analysis on the same.
- Unit testing of the programs.
- Participate in peer review and review programs
- Modifying Production codes JCL's and COBOL as per the business requirements and implementing the same using Endeavour.
- Developed detail design and technical specifications for different work teams
Environment: Mainframes, JCL, CICS, DB2, Oracle, JavaScript, MS SQL Server 2005/2008/2012, MS Access
Confidential
Programmer Analyst
Responsibilities:
- Involved in Java coding for the entire application.
- Designed and Developed J2EE components: JSP, Servlets, EJBs.
- Used Java Script for Client side validations.
- Developed JavaBeans.
- Design and coding of classes for database interaction using JDBC.
- Participated in unit testing.
Environment: Java, J2EE, HTML, JSP, Servlets, Oracle, JavaScript.