SUMMARY

• Over 6+ years of experience in Software Design, Development, Integration, Implementation and Maintenance of Business Intelligence, Database Platforms.
• 4 years of extensive Tableau Experience in Tableau v6.x/7.x/8.x/9.x/10.x (Desktop, Server, Reader, Mobile, Online, public) as a Developer and Analyst
• Competent in Software Development Life Cycle methodology (SDLC) and Software Testing Life Cycle (STLC), which includes RUP, Agile, and Waterfall Methodology.
• Strong knowledge of Business/Process Data flow in organizations and experienced in data modeling concepts.
• Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop - down menu option and Parameterized using Tableau.
• Prepared 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 Desktop.
• Worked on the development of Dashboard reports for the Key Performance Indicators (KPI) for the top management.
• End to end experience in designing and deploying data visualizations using Tableau.
• Good knowledge of Normalization/De-normalization, data design methodology and building Referential Integrity.
• Expertise in analysis, design and implementation of data warehousing/ BI solutions using Tableau, MicroStrategy, SSRS, Informatica and Alteryx.
• Extensive experience in PL/SQL and SQL and in performance tuning SQL queries in TOAD.
• Expertise in generating reports using global variables, expressions and functions for the reports.
• Experienced in tuning long running SQL queries for better performance.
• Experience in Technical Support, Troubleshooting, Report Design and Monitoring of system usage.
• Strong interpersonal skills with demonstrable verbal and written communications to maintain effective work relationships with all levels of personnel.

TECHNICAL SKILLS

BI / Reporting Tools: Tableau Desktop v10.x/9.x/8.x/7.x/6.x, Tableau Server v10.x/9.x/8.x/7.x/6.x, Tableau Online, Tableau Reader, Tableau Mobile, Tableau Public.

Databases: Teradata, MySQL, MS SQL Server, ORACLE, IBM DB2, MS Access

Front End Tools: Microsoft Project, Microsoft Office, JIRA

Document Management: Documentum, SharePoint, Ultra Edit

Versioning Tools: CVS, GIT

Defect Management tool: HP Quality center

Service Management Tool: HP Service Manager, CA Service Desk

Methodologies: Data Modeling - Logical/Physical/Dimensional, Star/Snow flake Schema, ETL, OLAP, Complete Software Development Lifecycle (Waterfall, Agile, Iterative)

Data Modeling: MS Visio

PROFESSIONAL EXPERIENCE

Confidential, New Jersey

Sr. Tableau Developer / Data Analyst

Responsibilities:

• Gather and analyze the business requirements and then translate them to technical specifications.
• Gathered SSRS reports requirements and created in Tableau.
• Implemented action filters, parameters, calculated filed and set for preparing dashboards and worksheets inTableau.
• Effectively used data blending feature in Tableau.
• Prepared and published customized reports/dashboards.
• Converted SSRS and MicroStrategy reports into Tableau.
• Designed and Developed Drill through Reports, Dashboards and modified the existing Dashboards using MicroStrategy Desktop.
• Created different Action filters, Parameters and calculated fields to create most complicated Dashboards.
• Worked with Tableau administrator in managing Production, Test and Development Environments.
• Used data blending feature in tableau and defined best practices for Tableau report development.
• Responsible for Developing Dashboard and preparing ad-Hoc Reporting.
• Created report on Cloud based environment using Amazon Redshift and published on Tableau Online.
• Integrated dashboards with live Connection in Microsoft PowerPoint.
• Developed and reviewed SQL queries with use of joins clauses (inner, left, right) in Tableau
• Worked with Master Data Management architects to develop data models.
• Desktop to validate static and dynamic data for data validation.
• Embedded tableau views in to SharePoint and handled tableau admin activities granting access and hanging extracts and installations.
• Created SharePoint site to store all tableau workbooks and data source.
• Published Packaged workbooks.
• Created Custom Hierarchies to meet the Business requirement in Tableau.
• Executed and tested required queries and reports before publishing.
• Participated in weekly meetings, reviews, and user group meeting as well as communicating with Stakeholders and business groups.

Environment: Tableau 9.x/10.x, Tableau Server 9.x/10.x, Microsoft SQL Server 2013, Teradata, SQL, Oracle.

Confidential, New York

Sr. Tableau Developer/ Data Analyst

Responsibilities:

• Prepared project reports for management and assisted the project manager in the development of weekly and monthly status reports, policies and procedures.
• Developing and maintaining high level overview of the project and design flows using MS Visio.
• Building, publishing customized interactive reports and dashboards using Tableau.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Effectively used data blending feature in tableau and 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.
• Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop-down menu option and Parameterized using Tableau.
• Created side-by-side bars, Scatter Plots, Stacked Bars, Heat Maps, Filled Maps and Symbol Maps according to deliverable specifications.
• Provided support for Tableau developed objects and understand tool administration.
• Created Custom Hierarchies to meet the Business requirement in Tableau.
• Created Workbooks and dashboards for analyzing statistical billing data using Tableau 8.0
• Created various connections, Data foundations and Business layers using Information Design Tool 4.1 (IDT) for AP Reporting.
• Converted WEBI Reports to Tableau Dashboards for Advanced Visualizations.
• Created SharePoint site to share project related documents.

Environment: Tableau 9.x, Oracle, SAP Business Objects 4.1/4.0

Confidential, MN

Sr. Tableau Developer / Sr. Data Analyst

Responsibilities:

• Created views in Tableau Desktop those were published to internal team for review and further data analysis and customization using filters and actions.
• Involved in creating interactive, parameterized dashboards by extracting data from various sources using data blending and applying actions - filter, highlight and URL.
• Created dashboard from scratch that included drill-through, filters, Heat/Geo/Tree Maps, Pie/Bar Charts, Circle Views, Line/Area Charts, Scatter Plots and Bullet Graphs.
• Developed unlinked, on-demand sub reports and linked sub reports using shared variables and complex reports like cross-tab, drill down and hierarchical reports.
• Involved in Data profiling, data analysis and data visualization with SAS new features, tools and technologies including SAS Visual Analytics.
• Developed different reports and dashboards using SAS Enterprise Guide.
• Creating visually compelling and actionable interactive reports and dashboards.
• Reviewed and optimized SQL queries and edited inner, left, and right joins in Tableau Desktop by connecting live/dynamic and static datasets.
• Created Context filters on the existing filters and Tableau data extract to publish it in server by optimizing it to reduce the report rendering time.
• Involved in data conversion to provide reporting capabilities as per the requirement.
• Validated the reports before publishing reports to Tableau server, troubleshoot Tableau reports, dashboards, etc.
• Involved in troubleshooting and performance tuning of reports and resolving issues within Tableau Server and Reports.
• Participated in weekly meetings, reviews, and user group meeting as well as communicating with stakeholders and business groups.

Environment: Tableau (Desktop /Server), Oracle, SQL Server, DB2, MS VISIO, Control-M

Confidential

MS SQL Server Developer/BI Developer

Responsibilities:

• Extracted and reviewed data from heterogeneous sources like (Excel, CSV, Oracle, flat file, Text Format Data) using SQL Server Integration Services (SSIS) from OLTP to OLAP.
• Created Stored Procedures, Triggers, Cursors, Tables, and Views and other SQL joins and statements for applications.
• Implemented Data Mart, Facts, Dimensions, Snow Flake schema, Star Schema and OLAP cubes
• Created Calculated Measures and Dimension Members using multi-dimensional expressions (MDX), mathematical formulas, and user-defined functions.
• Implemented MS Analysis Services setup, tuning, cube partitioning, dimension design including hierarchical and slowly changing dimensions.
• Worked in visually enhancing reports as per user requirements.
• Responsible for tuning and Optimizing Queries for the reports.
• Expert in SQL Server Management Studio interface for writing queries and stored procedures.
• Created and maintained Roles and Database users.
• Created database objects like views, indexes, user defined functions, triggers and stored procedures.
• Responsible for trouble shooting the reports.
• Maintained DTS 2000 Packages and migrated them to SSIS

Environment: MS SQL Server 2005, MS Visual Studio 2005, Windows XP Professional, Team Foundation Server, ProClarity, SSIS, SSRS, SSAS.