SUMMARY

• Over 6 years of IT experience inTableauDesktop and Server and as SQL Developer.
• Proficient in creating rich visualizations usingTableauDesktop. Software Analysis, Design, and Development in the fields of Databases, Business Intelligence, Client Server Technologies and Web - based Applications Expert in Data Visualization development usingTableauto create complex, instinctive, and imaginative Dashboards.
• Extensive experience in creating UI visualizations withTableauDesktop,TableauServer andTableau Reader in various versions ofTableau10.x/9.0,9.1.9.2,9.3x/8.x/7.x/6.x
• Good comprehension of ideas for example, Data Warehousing, Data Marts, ER Modeling, Dimensional Modeling, Fact & Dimensional Tables
• Involved in making dashboards and reports inTableau8.2. Made report plans onTableauserver Specialist in planning Universes and creating complex and Ad hoc Reports utilizing the Business Objects Reporter/Desktop Intelligence and Web Intelligence Tools
• Extensive experience in modeling and developing logical/physical data models using entity relationship modeling tools like ERWIN
• Able to handle distinctive tasks simultaneously and Lead experience and Good Working Knowledge in Agile Project administration (Scrum process)
• Ability to Lead the Data Visualization Analysis, Design and Efforts and Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop-down menu option and Parameterized dashboards usingTableauDesktop
• Extensive knowledge in various Bi reporting objects like Hierarchies, filters, calculated fields, Sets, Groups, Parameters and Dashboard Actions etc. inTableauDashboard Design
• Building and publishing customized interactive reports and dashboards, report scheduling usingTableauserver and using SSIS to extract and transform data
• Experience in working on generating various dashboards toTableauServer using different data sources such as Teradata, Oracle, SAS datasets, MS Excel etc.
• Experience inTableauadmin roles such as managing user roles; create/manage groups, workbooks and Projects
• Knowledge in Data warehouse approaches and schema
• Knowledge on Modified Cognos 8 Framework Manager, Metric, Query and Report Studio environment
• Knowledge on monitoring server activities/usage statistics to identify possible performance issues
• Expertise in Data Blending concepts inTableauDesktop and creating/Publishing interactive dashboards
• Experience in GeneratingTableauDashboard with quick/context/global filters onTableau(8.0 / 9.1/9.3) reports
• Experience in providingTableaudesktop support to the business end users such as usage policies
• Expertise in maintaining data quality, data organization, metadata and data profiling
• Experience in Business Analysis and Data Analysis, User Requirement Gathering, User Requirement Analysis, Data Cleansing, Data Transformations, Data Relationships, Source Systems Analysis and Reporting Analysis
• Participated in complete life cycle (SDLC) implementation of an Enterprise Data Warehouse and data mart
• Experienced with Multi-Serversand Multi-Terabyte Databases design for Very Large Databases
• Experienced in Data Warehouse and Highly Normalize Database Design including Data Files and File group organization, Capacity Planning, Data Partitioning, Data Normalization and De-normalizing
• Hands on experience with Data Modeling tool like Microsoft Visio, Erwin and Lucid chart and worked on conceptual physical and logical all stages of data model
• Proficient inSQLServerReplication, Backup/Recovery, Disaster recovery and planning
• Good hands-on with creating Partitioned Tables, Partitioned Views, Data Quality Service and Data Profiling
• Also, highly efficient on Monitoring and optimizing the performance of the Queries and Indexes usingSQLServerProfiler, Database Engine Tuning Advisor, Performance Monitor, DBCC commands and Dynamic Management Views
• Expert in creating and maintaining Functional, Technical and Data Mapping Documentations
• Expert in Query Tuning and activities including Updating Statistics, Re-building and Re-organizing Indexes
• Extensive knowledge in various reporting objects like Facts, Attributes, Hierarchies, Filters, Prompts, Calculated fields, Sets, Groups, Parameters etc., inTableau
• Worked on the development of Dashboard reports for the Key Performance Indicators for top management
• End to end experience in designing and deploying data visualizations usingTableau
• Extensive experience in Data Analysis
• Providing technical and analytical expertise in responding to complex, specialized report requests requiring higher-level data analysis and data management services
• Strong interpersonal skills with demonstrable verbal and written communications to maintain effective work relationships with all levels of personnel
• Ability to meet deadlines and handle multiple tasks, team player, motivated, able to grasp things quickly with analytical and problem-solving skills
• Inclination towards learning new technologies and Bi tools

TECHNICAL SKILLS

Skills: Web Intelligence 4.0, Dashboard Designer, Query Designer, MS Office

ETL Tools: Informatica, Data Stage, Microsoft SQL Server Integrated Services (SSIS), SQL Server Reporting Services (SSRS)

Front End Tools: Microsoft Project, Microsoft Office, Visible Analyst

BI Tools: TableauDesktop,TableauServer,TableauReader, Cognos, MSBI, Qlik view

Databases: Oracle 9i, SQL Server, Sybase, MS Access, SQL Server, MS SQL, DB2, MySQL, SAP Hana, Amazon Redshift, PostgreSQL, Cloudera and Teradata

Document management: Visual Source Safe 6.0, Share point, Ultra Edit, Documentum

Defect management tool: HP Quality center 10.0

Languages: C, C++, HTML, CSS, JavaScript, Power Shell script, SQL, PL/SQL, XML

Data modeling: Erwin, ER Studio, MS Visio

Operating System: Windows, UNIX, Linux

Bug Tracking Tool: JIRA, HPALM, Asana

PROFESSIONAL EXPERIENCE

Confidential - Hartford, CT

Sr. Tableau Developer

Responsibilities:

• Deep experience with the design and development ofTableauvisualization solutions
• Created Interactive Dashboard, worksheets usingTableauwith primary and secondary data sources using data blending where primary and secondary data sources linked by specified relationships
• Extract data from Teradata and create data sources using Data warehousing concepts
• Create action filters, parameters and calculations for preparing dashboards and worksheets inTableau
• Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards
• Defined best practices forTableaureport development
• Experience with creation of users, groups, projects, workbooks and the appropriate permission sets forTableauserver logons and security checks
• Preparing workbooks using calculations, parameters inTableau
• Understanding of relational database structures, theories, principles, and practices
• The ability to interact professionally with a diverse group, including executives, managers, and LOB
• Gathering necessities and comprehension the source systems to actualize DW/BI Data Analysis and giving proposals to higher administration
• Present the investigation to inside and outer groups and Explain information from a business point of view and importance to Key Performance Indicators (KPI)
• Interacted with Business Analysts and Data Modelers and characterized Mapping reports and Design process for different Sources and Targets
• Developed and audited SQL questions to validate data and UsingTableauextract to perform offline investigation
• Blended data from different information sources by utilizing connecting component as a part ofTableauDesktop
• Developed perspectives using modern counts like Table estimations, Logical computations, date figuring, and Trend Lines
• Developed Views and intelligent Dashboards using Parameters, Filters, Actions, Bar/Bullet/Dual Axis graphs, Area/Geo/Heat maps, scramble plots/Bubble Charts and so forth, inTableauDesktop
• Developed various Views and consolidated them into Dashboards for intelligence by giving Quick Filter and Parameters to further information penetrating ability Creating Users, Groups, Projects, Sites, and Permissions in Tableau Server Working on creating different dashboards inTableauserver utilizing various sources
• ExtensiveTableauExperience in Enterprise Environment andTableauAdministrator experience including specialized bolster, investigating, report plan and checking of framework use and Presenting training to Business users in usingtableau
• Excellent analytical, problem solving and debugging skills, with strong ability to quickly learn and comprehend business processes and problems to effectively develop technical solutions to their requirement

Environment: TableauDesktop/Server 8.0/9.0/9.1/9.2/9.3/10 , Teradata SQL Assistant, Teradata Administrator, Adobe Analytics, Microsoft SQL Server, MS Visio, Microsoft Office Suite (Word, Excel, PowerPoint), Tableauonline, JIRA.

Confidential - Richmond, VA

Tableau Developer

Responsibilities:

• Actively involved in gathering requirements from end users, involved in modifying various technical & functional specifications
• Mentored business power users to create reports/dashboards usingtableaudesktop
• Created Dashboards with interactive views, trends and drill downs
• Published Workbooks and Dashboards to theTableauserver
• Combined visualizations into Interactive Dashboards and publish them to the web
• Created groups and users inTableauserver
• Upgraded Workbooks and Dashboards fromTableau7 to 8
• Implemented new features inTableau8 to the existing Workbooks and Dashboards
• Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet inTableauDesktop
• Utilized advance features ofTableausoftware 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 fortableaureporting
• Building, publishing customized interactive reports and dashboards, report scheduling usingTableauserver
• Created actions, parameters, Filter (Local, Global) and calculated sets for preparing dashboards and worksheets usingTableau
• Effectively used data blending, quick filters, actions, hierarchy features intableau
• Analyzed the data using statistical features intableauto 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
• Involved in gathering the requirements and analyzing the requirements
• Regularly interacting with customer to resolve issues
• Responsible for Preparing the Report Design specifications based on the User's requirement
• Created List, Cross Tab Reports with Quick Filters, Summarized Filters
• Developing, Designing and supporting interactiveTableauDashboard reports
• Experience with the design and development ofTableauvisualization solutions
• Created Bar Charts, Columns Charts, water fall charts, Heat Maps, And Geographical Maps

Environment: Tableausoftware8.3xs,TableauDesktop,TableauServer, Oracle, Informatica, Windows.

Confidential

Tableau Developer

Responsibilities:

• Extensively participated in discussions of BI team with business team and BA to get requirements
• Involved in enhancements for existing dashboards by optimizing the workbooks
• Created a Supply Chain Dashboard usingTableauin which the Order Booking and Shipments were visualized at each step
• Created 'Order Netting Dashboard' usingTableauby which we can visualize Order Booking trends
• Validated data by comparing the data with different data sources using EXCEL and fixed the data issues
• Created user training documents to educate the Users to make the use ofTableauDashboards effectively
• Extensive use of SQL queries for loading data and creating data extracts
• Analyzing the customer retention details based on regions and customer segments using bar charts and tree maps
• Worked on various internal projects for different departments like QA and Sales Team
• Organized user demos onTableauserver features like printing workbooks and email subscriptions
• CreatedTableauworkbooks using Oracle as data source
• Performed tuning of SQL queries to optimize the dashboards
• Created dashboard using parameters, sets, groups and calculations
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets inTableau.

Environment: TableauDesktop,Tableauserver, Oracle 11g, PL/SQL and Windows.

Confidential

Tableau Developer/Admin

Responsibilities:

• Handled Tableau admin activities granting access, managing extracts and scheduling of the dashboards
• 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
• 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
• Participated in meetings, reviews, and user group discussions as well as communicating with stakeholders and business groups
• Defined best practices for Tableau report development
• Executed and tested required queries and reports before publishing
• Provided support for Tableau developed objects and understand tool administration
• Worked in Tableau environment to create dashboards like weekly, monthly, daily reports using Tableau desktop & publish them to Tableau Server
• Tested dashboards to ensure data was matching as per the business requirements and if there were any changes in underlying data

Environment: Tableau 7.0, Tableau Server, MS SQL, Oracle, MS Office, MS Visio

Confidential

SQL Developer

Responsibilities:

• Performed data consistency and performance tuning effectively with SQL Profiler, Index Tuning Wizard
• Used SQL Server Reporting services for creating, editing and scheduling various reports
• Created and maintained database objects, created complex Stored Procedures, Triggers, Cursors, Tables, Views and SQL Joins and other statements for various applications
• Created various reports using SQL Reporting Services
• Developed complex reports, which are migrated from different reporting tools
• Analyzed the existing application programs and tuned SQL queries using Execution plan, SQL performance Monitor, SQL Profiler
• Created and wrote database objects such as tables, indexes, views, procedures, functions, triggers, SQL code with proper grants to all the users and roles
• Interacted with developers on various aspects ranging from usage of utilities to SQL performance, test data and general troubleshooting
• SQL performance tuning by modifying SQL or adding/changing indexes
• Created and automating the regular jobs
• Prepared the reports for the day-to-day as well as weekly/monthly purposes in various formats like MS Excel, PDF, HTML, and XML etc
• Integrated Stored Procedures to generate the Reports

Environment: MS SQL Server 2008, T-SQL, DTS, MS Access, Flat files, Windows XP

Confidential

Jr SQLDeveloper (Intern)

Responsibilities:

• Responsible for the Creation, manipulation and supporting the SQL Server databases
• Created tables, indexes, sequences, constraints, triggers and procedures
• Used triggers, stored procedures and manipulated the data using DDL and DML functions
• Wrote complex T-SQL statements (Queries) for retrieval of data and involved in performance tuning of T-SQL queries
• Used SQL Profiler to find badly performing queries and deadlocks
• Involved in Installation, Configuration of SSRS Reporting server and involved in Deploying reports
• Deploying SSRS Reports across multiple environments including Test, Production and supporting environments including Reporting Services Report Manager
• Scheduled Reports based on a day and sent them through Email in required format (Excel, PDF, etc.)

Environment: SQL Server, SQL Server Enterprise Manage, SQL Profiler, SSRS, SSIS, MS Office.