PROFESSIONAL SUMMARY:

• 5+ years of experience in working with Tableau Desktop, Tableau Server and Tableau Reader in various versions of Tableau 10.x/9.x/8.x/7.x.
• Over 5 years of experience in creating complex dashboard reports using different reporting tools.
• Expertise in Tableau Server Administration and working in DW environment
• Outstanding knowledge& working experience of slice & dice Looker, Power BI & Cognos.
• Experience in facilitating Joint Requirement Planning (JRP) sessions with Business User Groups, conducting Joint Application Development (JAD) sessions with IT Groups and Conflict Management with Project team members.
• Extensively worked on Prototyping and designing reporting, data analytics and visualization solutions
• Create process efficiencies through automation (report delivery, dashboard creation and data management)
• Strong knowledge in developing, designing and implementing data mining models using neutral networks and logistic regression
• Experience in Tableau Server Installation and Configuration, creating users, groups, projects, providing access levels.
• Employed various Tableau functionalities like Tableau Extracts, Parameters, Filters, Contexts, Data Source Filters, Actions, Functions, Trends, Hierarchies, Sets, Groups, Calculations, Data Blending and Maps etc.,
• Expertise in Performance Tuning Tableau Dashboards and Reports built on huge Data sources.
• Extensive experience in creating logical tables and columns, Dimensional Hierarchies, Level Based Measures, Time series data for complex data analysis.
• Outstanding Data analysis skills including Data mapping from source to target database schemas, Data Cleansing and processing, writing data extract scripts/programming of data conversion and researching complex data problems via API

TECHNICAL SKILLS:

BI Tools: Tableau 10.X/9.X/8.X/7.X (Desktop, Server, Reader), Looker 4.1 to 5.10, SSRS, Cognos, Power BI.

ETL Tools: Informatica, SSIS, Alteryx

Front End Tools: Microsoft Project, Microsoft Office

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

Defect management tool: Test Director, HP Quality center

RDBMS: Hadoop,Snowflake DW, Teradata, Oracle, SQL Server, MS Access, TFS.

Scripting Languages: C, C++, HTML, CSS, SQL

Operating systems: Windows 7/XP, Windows Server 2012/2008, UNIX/Linux.

PROFESSIONAL EXPERIENCE:

Confidential, Ann Arbor, MI

Sr. Tableau & Looker Consultant

Responsibilities :

• Defined the current reporting activities for the development of existing and future reporting procedures and models by charting existing processes.
• Performed Research, review, and analyze the effectiveness and efficiency of existing report procedures and develop strategies for enhancing or further leveraging these processes.
• Developed routines and procedures for end - users to facilitate best practices use of reporting tools and applications.
• Created prototype reporting models, specifications, diagrams, and charts and develop reports and analytics.
• Developed, prepare and deliver reports, recommendations, or alternatives for improving processes in reporting systems across the organization.
• Created requirement specification and review the details with cross functional teams (finance, marketing, sales ops, and customer success) and implement reports in tools or spreadsheet.
• Experienced with report writing and technical requirements analysis, business process modeling/mapping, methodology development, performance tuning and data modeling.
• Experienced with reporting tools, software, and other applications, including SQL Database, Looker, Tableau and Salesforce dashboards (reports designing tool) and Data warehouse.
• Extensive practical knowledge in importing data for use in reporting software (Tableau & Looker) graphs, and flowcharts.
• Designed excessive attractive & detailed visualizations such as Funnel, Timeline, Static Map (Regions & Points), Donut Multiples, Scatter Plot, Area Chart, Line & Pivot.
• Current Qtr/yr/month role group, Deal desk, Historical trending and pipeline dashboard, Territory account map by account owner etc dashboards for AMER & AMEA regions, are created for sales-ops team.
• Extensively worked on 2 phases of MSP billing implementation project Dashboards such as MSP Accounts billed & not billed, Edition for ACV calculation, MSP daily change, MSP billing model & MSP trending dashboards etc.
• Restricted data for particular users using Row level security and User filters.
• Developed Tableau workbooks from multiple data sources using Data Blending.
• Provided 24/7-production support for Tableau & Looker users on Ad-Hoc basis.
• Published Workbooks by creating user filters so that only appropriate teams can view it. Extensively used Tabadmin and Tabcmd commands in creating backups and restoring backups.
• Developed effective and interactive Dashboards using Parameters and Actions.
• Setting the user permissions in Tableau Sever.
• Maintaining server activities, user activity, and customized views on Server Analysis.
• Prepared proof of concept for best practices in Tableau deployment.
• Worked with Source System Subject Matter Expert (SME) to ensure that the extracts are properly mapped. Used SQL Workbench for data mapping and querying.
• Involved in testing the SQL, Lookml in Looker & Snowflake DB Scripts.
• Understands the data flow of Finance (Saas Optics, NetSuite), Sales (SalesForce), MSP (Recurly), Business Function Decisions (Anaplan), Ticketing, People (Jira, ServiceNow, Zendesk), Communications (RingCentral & Slack), Customer Success (Omni Clone) etc.
• Conducted UAT session with different teams.

Environment : Tableau (Desktop/ Server), Looker(Lookml Development/Desktop/ Admin, Server), Teradata, AWS, SnowFlake SQL, Tester, MS SQL Server, Oracle, SQL, PL/SQL, T-SQL, MS Access, IOS, SalesForce

Confidential, Cary, NC

Sr. Tableau ReportingConsultant

Responsibilities :

• Performed extensive GAP analysis in the project as there were numerous 'As-Is' and 'To-Be' conditions.
• Consult with clients and internal stakeholders to gather requirements and plan milestones in the research, development, and implementation phases of the project lifecycle.
• Working with team of developers to designed, developed and implement a BI solution for Sales, Post Sales Research, Product and Customer KPIs.
• Working in Agile Scrum Environment. Working on Jira and Service Now Ticketing.
• Building, publishing customized interactive reports and Tiled dashboards, report scheduling using Tableau server.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Developed Super Complex Tableau workbooks to perform Forecasting year over year, quarter over quarter, YTD, QTD and MTD type of analysis for Subscribers and Sales.
• Generated Dashboards with Quick filters, Parameters and sets to handle views more efficiently.
• Generated context filters and data source filters while handling huge volume of data.
• Built dashboards for measures with forecast, trend line and reference lines. for report development, Tableau reports, Dashboards, Scorecards and handled the performance issues effectively.
• Involved in integration of Tableau JavaScript API Filters in web application
• Defined best practices for Tableau report development.
• Created dashboards and reports for ad-Hoc Reporting.
• Extensively worked on crystal reporting.
• Experience in working on sourcing the data from HADOOP platform using scoop.
• Experience in running queries in HIVE.
• Configured AWS for Tableau and Installed Tableau Server.
• Played an important role in coordination with the entire team and managing the time estimates for the entire project.
• Used SQL tools like Toad and Teradata SQL Assistant to run SQL queries and validate the data in the warehouse and marts.
• Provided post implementation production support.

Environment : Tableau (Desktop/ Server), Teradata, Hadoop, SQL developer, MS SQL Server, Oracle, SQL, PL/SQL, T-SQL, Teradata SQL Assistant, Toad, MS Access, Windows 2007 server,

Confidential, Philadelphia, PA

Sr. Tableau Reporting Consultantand Sr. Data Analyst

Responsibilities :

• Interacted with the stakeholders by interviewing them, by preparing questionnaire and getting feedback.
• Collaborated with Enterprise Architecture, IT leadership and internal stakeholders.
• Communicated Project Requirements, Business Issues, Solution and made recommendation.
• Worked with Project team to determine technical and development impact of a project.
• Responsible for defining the scope of the project, gathering business requirements, doing gap analysis and documenting them textually or within models
• Gathering and documenting the requirements that are critical to the business mission and using those requirements to design application software.
• Conducted JAD sessions to allow different stakeholders to communicate their perspectives with each other, resolve any issues and come to an agreement quickly.
• Worked with Source system Subject Matter Expert (SME) to ensure that the extracts are properly mapped. Used SQL for data mapping and querying.
• Develop, Organize, manage and maintain graphs, tables, slides and document templates for the efficient creation of reports.
• Specified and analyzed requirements for scalable database and result reporting
• Created world class web data-mining system
• Handled the tasks of code development and data analysis
• Experienced in a wide variety of telecommunication networks
• Experienced in configuring and administering different level of securities.
• Designed and developed transformations required for generating machine learning data sets
• Interact professionally with diverse group of professionals in the organization including managers and executives.
• Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.
• Created reports and dashboards using Trend Lines, Statistics, and Log Axes, Groups, hierarchies, Sets.
• Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps.
• Create, customize & share interactive web dashboards in minutes with simple drag & drop method and access dashboards from any browser or tablet.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Created new Schedule's and checking the task's daily on the server.
• Experience in standardizing Tableau for shared service deployment.
• Extensively used data blending, embed functionalities in Tableau.
• Deployed Tableau Server in clustered environment by mapping server nodes to primary machine.
• Involved in creating dashboards and reports in Tableau and Maintaining server activities, user activity, and customized views on Server Analysis.
• Gathered user requirements, analyzed and designed software solution based on the requirements.
• Interacted with Business Analysts and Data Modelers and defined Mapping documents and Design process for various Sources and Targets.
• Defined best practices for Tableau report development and effectively used data blending feature in tableau.
• Created users, groups, projects, Data connections, and settings as a tableau administrator.
• Good SQL reporting skills with the ability to create SQL views and write SQL queries.
• Experience working on PowerShell scripting.

Environment: Tableau Desktop / Serve, Teradata, Informatica, MS SQL Server, Toad, Teradata SQL Assistant, SQL, PL/SQL, T-SQL, UNIX,PowerShell, Microsoft office Suite (Word, Excel, PowerPoint).

Confidential, Philadelphia, PA

Tableau Developer / Dashboard Reporting Analyst

Responsibilities :

• Interacted with business to collect and understand Requirements.
• Translated the business needs into system requirements by communicating with the business on non-technical level and with the System Analyst on technical level.
• Arranged walkthrough sessions with the user group and to confirm that all the requirements have been captured and obtained sign off on the requirements documents.
• Identified the key facts and dimensions necessary to support the business requirements. Develop the logical dimensional models.
• Conducted and participated in JAD sessions with the users, modelers, and developers for resolving issues.
• Performed source data quality assessments and created source to target mapping documentation defining source rules, target rules, and data transformations for various ETL packages in SSIS.
• Created Data Definitions and help maintain Metadata repository.
• Created Tableau worksheet which involves Schema Import, Implementing the business logic by customization.
• Building, publishing, customized interactive reports and dashboards, report scheduling using Tableau server.
• Created Relationships, actions, data blending, filters, parameters, hierarchies, calculated fields, sorting, groupings, live connections, and in-memory in both tableau and excel.
• Worked on motion chart, Bubble chart, Drill down analysis using tableau desktop.
• Created customized reports using various chart types like text tables, bar, pie, tree maps, heat maps, line charts, pivot tables, combination charts in excel and SSRS.
• Involved in created stored procedures, views, and custom SQL queries to import data from SQL server to tableau / SSRS.
• Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps.
• Tested reports and uploaded tableau dashboards on to server and provided production support for tableau users.
• Ability to work quickly and under tight delivery deadlines with focus on details.
• Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.
• Defined and created procedures to install Tableau desktop in silent mode and best practices for Tableau report development.

Environment: Tableau (Desktop/ Server), MS SQL Server 2008, Excel, SQL, PL-SQL, TSQL, UNIX, SQL Server 2008, SQL BI Suite (SSIS, SSRS), MS Office, Visual Studio 2010

Confidential, Columbus, OH

Data Analyst

Responsibilities :

• Wrote program to export as text files or PDF to outside Life science Business Users.
• Utilized SQL Queries, stored procedures, packages, used defined functions, views, cursors using Toad or SQL Developer to present data on the reports such as sales information, deposit and payout and their incentive compensation information.
• Created mid to complex Reports (Oracle data sources) with one or more of the following features to support statistical and operational business needs, Grouping, Sorting, Drill-down Dynamic Parameter prompts, Sub reports or Crosstab summaries
• Better understanding and familiarity with hospital and / or clinical workflows.
• Developed Drill down Reports, Linked Reports, sub reports and Parameterized Reports
• Expertise in analysis, design and implementation of data warehousing/ BI and Business Objects solutions.
• Efficiently debugs and manages stored MySQL procedures and functions
• Debugged nested procedures and functions as well as anonymous code (similar to anonymous blocks in Oracle)
• Supported conditional breakpoints and tooltip expression evaluation
• Hands on experience in running SQL commands in the debugging context
• Created formulas and/or used statistical or financial functions for reports as needed.
• Used SQL stored procedures, created alias data tables as required to improve report performance.
• Created Stored Procedures and Views as data sources using Oracle databases for reports.
• Wrote different queries and stored procedures to make our daily data verification and conversion processes faster, more accurate and automated.
• Used Optimizer HINT for tuning T-SQL and PL/SQL queries rewrite most of them for efficiency
• Worked with DBMS PROFILER to tune PL/TSQL Procedures.
• Involved in preparing and executing SQL code deployments (DDL/DML) with application rollout teams into QA/Production environments.
• Created Tables, Views, Constraints, Indexes and developed Complex database objects including
• Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL with exception handling
• Used TSQL extensively by using Joins, Sub Queries, Set Operations, and Advanced OLAP Functions.
• Implementing performance tuning methods to resolve issues and bottlenecks. Identifying long running queries and performing performance tuning.
• Created trigger to collect the trace files to get login information.
• Created Materialized Views and partitioning tables for performance reasons.
• Used cursor, ref cursor, bulk collect and bulk insert (BULK BINDING) in procedure to reduce its execution time.

Environment: Microsoft SQL Server 2008, Crystal Reporting, Shell Scripting,SSRS, SSIS, XML, T-SQL, .NET, MS Word and Excel, SQLProfiler, Toad.

Confidential

SQL Developer

Responsibilities :

• Analyzed reports and fixed bugs in stored procedures using SSRS.
• Used complex expressions to group data, filter and parameterize reports.
• Created linked reports and managed snapshots using SSRS.
• Performed various calculations using complex expressions in the reports and created report models.
• Generated Complex SSRS reports like reports using Cascading parameters, Snapshot reports Drill-down Reports, Drill-Through Reports, Parameterized Reports and Report Models and ad hoc reports using SSRS based on Business Requirement Document.
• Conducted performance tuning of complex SQL queries and stored procedures by using SQL Profiler and index tuning wizard.
• Provided Production support to analyze and fix the problems and errors on daily basis by modifying SSIS Packages and Stored Procedure if necessary.
• Designed and developed Tables, Stored procedures, Triggers and SQL scripts using TSQL, Perl and Shell scripting for enhancements and maintenance of various database modules

Environment: MS SQL Server 2005/2008, MS SQL Server Reporting Services, SQL Server Integrating Services, SQL Server Analysis Services, T-SQL