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

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.