SUMMARY

• Over 7 years of experience in building reports and Dashboards using various BI tools including Tableau/ Business Objects/Power BI.
• Experience in Training & Supporting end - user reporting needs using Power BI, Tableau and Business Objects.
• Experience in creating different type of reports including: Cross-tab, Conditional, Drill-down, Top/Bottom N, Summary, Form/Mailing label and Sub-reports.
• Experience in performance tuning, identify and resolve performance bottlenecks at various levels like source, target, mappings, and session.
• Extensively used Tabadmin and Tabcmd commands in creating backups and restoring backups and migrate objects of Tableau repository.
• Created incremental refreshes to pull the delta records from data sources to Tableau Extracts.
• Creating users, groups, projects, Data connections, setting up roles as a Tableau administrator.
• Created subscriptions to deliver the reports on a scheduled time through email.
• Worked on different databases like RDBMS (SQL Server, Oracle, MY,), OLAP cubes and In Memory databases for reporting in Tableau Desktop.
• Very strong in Client/Server Architecture, Relational Databases (RDBMS), Data Modeling and Designing and build the Data Warehouse, Data marts using Star Schema and Snow Flake Schema for faster and effective querying for the Metadata Management solutions.
• Excellent knowledge in Implementation of Relational Database (OLTP) and Data warehousing systems (OLAP) and Data Marts.
• A good Team player with the ability to communicate effectively at all levels, possessing excellent presentation, communication and interpersonal skills.

TECHNICAL SKILLS

BI Tools: Desktop/Server/Online 2019.x/2018.x/10.x/9.x, 7.x Alteryx, Business Objects, Crystal report, Dashboard Designer, Google Analytics

Data sources: SQL Server, Oracle, Teradata, MySQL, Msexcel.

Languages: SQL, TSQL, PL SQL,Stored Procedure, Json

ETL: Alteryx, Tableau Prep

Others: Microsoft Office, SharePoint, JIRA, ALM.

PROFESSIONAL EXPERIENCE

Confidential - Wilton, CT

Tableau Developer/Data Visualization Expert/Analytical Consultant

Responsibilities:

• Implemented Tableau BI Dashboard reporting solution for different groups in the organization.
• Developed Tableau workbooks using best practices and Optimized Tableau performance at the Tableau and Databases level.
• Worked closely with Stakeholder/Business users to implement the solutions from scratch.
• Responsible for gathering business requirements from various users of different Departments and stake holders.
• Published Dashboards onto Tableau Server and from there consumers would choose viewing medium (laptop, pc, iPad).
• Extensively used analytical features in Tableau like calculations, trend lines, forecasting etc. in many tableau reports.
• Created extensive joins for data blending from several different data sources.
• Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.
• Configurated and Deployed all the Reports cross various SDLC environments.
• Responsible for creating datasets using T-SQL and stored procedures.
• Scheduled the packages to keep extracting the data from OLTP at specific time intervals.
• Built complex formulas in Tableau for various business calculations.
• 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 Tableau Desktop.
• Created organized, customized analysis and visualized projects and dashboards to present to Senior Level Executives.
• Introduced several Levels of Dashboard Drill Down and Links to interrelated performance metrics.
• Created, assisted and train users in Tableau dashboards usage.
• Administered and provided production support for Enterprise wide Tableau application consisting of multiple key functional business domains.
• Worked with business analysts, interpreted business requirements that users looked to dashboards to answer, and created server-based Tableau dashboards with automatic updates.
• Created several dashboards with various chart types such as stacked bar charts, scatter plots, heat maps, and text tables that demonstrated insightful trends over a period.
• Documented complete server architecture and solutions to troubleshot performance, scheduled workbooks and handled server related issues.

Environment: Tableau, Alteryx, SQL Server, Teradata, JIRA, TFS.

Confidential, Jersey City, NJ

Data Visualization Expert/ Analytical Consultant

Responsibilities:

• Analyzed data and developed Tableau dashboards from multiple sources such as Google Analytics, external marketing data, and sales data to formulate and develop insights used to grow revenue and profit within the sales/marketing organization.
• Regularly generating insights by analyzing actual business performance versus targeted business performance.
• Gathered Business requirements, interacted with the Users, Project Manager and SMEs to get a better understanding of the Business Processes.
• Created views/reports in Tableau Desktop that were published to internal team for review and further data analysis and customization using filters and actions.
• Worked in the application UI to present to the end users with Tableau dashboards and visualizations in multiple platforms.
• Created Heat Map showing current service subscribers by color that was broken into regions allowing business user to understand where we have most users vs. least users.
• Created customized Tableau Dashboards, integrating Custom SQL from Teradata and Oracle, Hadoop and performing data blending in reports.
• Worked closely with business power users to create reports/dashboards using tableau desktop.
• Worked extensively in documenting the Source to Target Mapping documents with data transformation logic
• Used Google analytics data to build the dashboards in Tableau for enterprise website analysis.
• Performed data analysis and data profiling using SQL on various sources systems including Oracle and Teradata.
• Wrote SQL code with multiple joins to pull the data from multiple Oracle Database. Optimized and automated the query.
• Organized dashboards in Tableau to analyze the revenue, expense over various attributes of employee, project, time and location dimension.
• Prepared dashboard and analyzes trends to aid in targeting and the development of new business opportunities.
• Responsible for the design and development of key indicators and the appropriate tracking reports to assist in the management of marketing campaigns.
• Gathered data, analyzes trends, and proactively identifies variances to forecast.
• Responsible for automating current dashboards by working with cross functional team members.
• Capable of performing ADHOC analysis and develop insights
• Extensively involved in all the phases on SDLC such as analyzing, requirement gathering, development, QA and deployment.

Environment: Tableau Desktop/ Sever 2018.x, Adobe Analytics, Google Analytics, JIRA, SharePoint, Python

Confidential - Madison, WI

Sr. Tableau Developer/Data Analyst

Responsibilities:

• Designed and developed of Tableau visualization solutions and created business requirement documents and plans for creating dashboards.
• Created organized, customized analysis and visualized projects and dashboards to present to Senior Level Executives.
• Understood, implemented, and automated security controls, governance processes, and compliance validation
• Customized the Tableau landing page with site listing as icons and descriptions.
• Constructed the reports page for internal strategy group with standardized custom right and left side sections within Tableau.
• Generated tableau dashboards with combination charts for clear understanding.
• Implemented systems that are highly available, scalable, and self-healing on the AWS platform.
• Create d Batch Stored Procedures for in the Report Scheduler according to the monthly, weekly or daily.
• Generated Reports using Global Variables, Expressions and Functions for the reports.
• Deployed the generated reports directly on the client’s workstation.
• Created many multi valued parameters in the reports.
• Built, published, customized interactive reports and dashboards, report scheduling using Tableau server. Creating New Schedule's and checking the task's daily on the server.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Defined best practices for Tableau report development and effectively used data blending feature in tableau.
• Created, customized & shared interactive web dashboards in minutes with simple drag & drop method and access dashboards from any browser or tablet.
• Connected to Oracle directly, created the dimensions, hierarchies, and levels on Tableau desktop.
• Created users, groups, projects, Data connections, settings as a tableau administrator.
• Involved in creating database objects like tables, views, procedures, triggers, functions using T-SQL to provide definition, structure and to maintain data efficiently.
• Optimized Tableau workbooks by improving performance in DB side, Tableau desktop and Tableau server

Environment: Tableau 9.x, Oracle, Google Analytics, SQL Server, Jira, Excel

Confidential - Columbus, OH

Tableau Consultant/BI Developer

Responsibilities:

• Analyzed data and developed Tableau dashboards from multiple sources such as Google Analytics, external marketing data, and sales data to formulate and develop insights used to grow revenue and profit within the sales/marketing organization.
• Created and assisted users in Tableau dashboard development.
• Created Data Connections, published on Tableau Server for usage with Operational/Monitoring Dashboards
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Installed patches on server and documented upgrade plan form Tableau 7.x to Tableau 8.x.
• Resolved various performance issues and analyzed the best process distribution for different projects.
• Administered and provided production support for Enterprise wide Tableau application consisting of multiple key functional business domains.
• Developed business process and technical design documentation for each reporting service developed in this project.
• Designed and developed reports such as Drill down, Drill Through using Tableau.
• Developed Reports in Tableau to send the reports directly to the respective E-mails using Subscriptions.
• Created various complex SQL Queries, Stored Procedures, CLR Procedures, Views, Cursors and User Defined Functions to implement the business logic.
• Optimized queries by looking at Execution Plan for better tuning of the database.

Environment: Tableau Server 8.x, Tableau Desktop 8.x, MYSQL, Oracle 10g, Excel, UNIX, Toad, Team Foundation, SharePoint

Confidential

Data Analyst

Responsibilities:

• Actively involved in gathering requirements from end users, involved in modifying various technical & functional specifications.
• Performed extensive task in excel such as Pivots, VLOOKUP, conditional formatting and data manipulation and cleaning for large number of data set.
• Requirements gathering from the customer and documentation of requirements specification.
• Involved in Project related Communication between Onsite and Offshore by attending Status meeting
• Preparation of the Analysis document which translates the business requirement into technical requirements.
• Impact Analysis to identify other issues caused due to this development, accomplishing the deadlines.
• Tracking trouble tickets post implementation, analyze, provide solution and implement the changes in the code.
• Preparing Technical Design, Unit Test cases and Test procedures document. Involved in monitoring the UAT Cycle run.
• Providing Primary On-call support for resolving bugs or issues thereby giving permanent fixes for the Production Issues within the SLA duration.
• Design, coding, testing, and implementation of customizations within software environment which includes replaces, delete, or modify codes to correct errors.
• Analyzes, reviews, and alters program to increase operating efficiency or adapt to new requirements.
• Documenting to describe program development, logic, coding, and corrections
• Communicated effectively and timely with peers and management