SUMMARY

• 7+ years of experience in design, development, implementation and administration of Tableau Software and expertise in implementing various functionalities of Data Warehouse; designed stunning visualizations and dashboards using Tableau Software.
• Expert experience in Tableau Desktop, Tableau Server, Tableau Reader, Public and Mobile in various versions of Tableau 2021/2020/2019/10/9/8
• Strong Business Analysis experience on Data Analysis, Business Requirement Documents, Data Migration Documents, User Requirement Gathering, User Requirement Analysis, Gap Analysis, Physical and Logical design, Resource Planning, Data Cleansing, Data Transformations & Impact Analysis.
• Proficient in data visualization, Reporting, Analysis, Pie Charts Bar Charts, Cross Map, Scatter Plots, Geographic Map, Page Trails, Density Chart and other making use of actions, other local and global filters according to the end user requirement.
• Expertise in designing and creating various analytical reports and Dashboards to help users to identify critical KPIs and facilitate strategic planning in the organization.
• Successfully upgraded Tableau platforms in clustered environment and performed content upgrades.
• Experience in creating different visualizations using Bars, Lines and Pies, Maps, Scatter plots, Gantts, Bubbles, Histograms, Bullets, Heat maps and Highlight tables.
• Extensive knowledge in different reporting objects like Facts, Attributes, Hierarchies, Calculated fields, transformations, filters, Sets, Groups, prompts, Parameters etc. in Tableau.
• Expert in creating Calculations (LOD, Cube Calculations, Creating/using Parameters, Table Calculations, Totals) and Formatting (Annotations, Layout Containers, Mark Labels, Rich Text Formatting, Shared Encoding) usingTableauDesktop.
• Experience in Trouble Shooting, Performance tuning of reports and resolving issues within Tableau Server and Reports.
• Experience on Configuring installation and managing Tableau Server with large data volumes like Setting up Tableau data sources. Filters, blending, joins for optimum performance and Trouble - shooting issues.
• Expert in Data Extraction, Transformation and Loading (ETL) using SQL Server Integration Services SSIS/DTS.
• Experience in developing different types of Tabular Reports, Matrix Reports, Drill-Down, Cross Tab Reports, Ad hoc reports and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS) using SSRS.
• Involved in Trouble Shooting, Performance tuning SQL Server and resolving issues within Tableau Server and Reports.
• Experience in Data Conversion and Data Migration from earlier versions to current SQL server using SSIS and DTS services across different databases like Oracle, MS access and flat files.
• Experienced with SQL Server and T-SQL in constructing triggers, tables, views, stored procedures, user defined functions, indexes, user profiles and relational database models with data integrity.
• Good knowledge in Tableau Admin utility commands like TABCMD and TABADMIN.
• Experience in writing SQL and PL/SQL scripts to validate the database systems and for backend database testing across various database platforms such as Teradata, SQL Server, Oracle etc.
• Experienced in working with different data sources like flat files and Excel to source data in SSIS and proficient in creating SSIS packages from scratch and deploying them.
• Experience in creating Jobs, Alerts, SQL Mail Agent, and schedule ETL Packages.
• Experience in PL/SQL and SQL and in performance tuning SQL queries in TOAD.
• Highly Proficient in Agile, Scrum and Waterfall software development life cycle.
• Excellent verbal and written communication skills combined with strong interpersonal and conflict resolution skills and possess strong analytical skills.

TECHNICAL SKILLS

BI/ETL Tools: Tableau (Tableau 2021, 2020, 2019, 10X, 9X, Tableau Desktop, Tableau Server, Tableau Reader), SSIS, SSRS, DTS & Data stage

Databases: SQL Server, Oracle, MS Access, MS excel, Teradata

Modeling Tools: MS-Visio

Reporting Tools: SQL Server Reporting Services

Languages: T-SQL, SQL, PL/SQL, C, C++, JAVA, VB, MS ACCES, Python

Operating Systems: Windows 8/7/XP/2003 & Unix

Office Tools: Microsoft Office /

Methodology: Agile Methodology, Scrum Model, Water fall method.

PROFESSIONAL EXPERIENCE

Confidential, Somerset, NJ

Tableau Developer

Responsibilities:

• Used tableau as the reporting and dashboard tool to have a clear overview to the users about the expense bill which is spending on different projects.
• Reviewed business requirements and analyzing data sources form Excel/Oracle SQL Server for design, development, testing, and production rollover of reporting and analysis projects within Tableau Desktop.
• Created views in Tableau Desktop that were published to internal team for review and further data analysis and customization using filters and actions.
• Created Heat Map showing current service subscribers by color that were broken into regions allowing business user to understand where we have most users vs. least users.
• Projected and forecasted future growth by developing reports to show in detail.
• Converted charts into Crosstabs for further underlying data analysis in MS Excel.
• Created Bullet graphs to determine profit generation by using measures and dimensions data from Oracle SQL Server and MS Excel.
• Blended data from multiple databases into one report by selecting primary key’s from each database for data validation.
• Combined views and reports into interactive dashboards in Tableau Desktop that were presented to Business Users, Program Managers, and End Users.
• Reviewed basic SQL queries and edited inner, left, and right joins in Tableau Desktop by connecting live/dynamic and static datasets.
• Developed story telling dashboards in Tableau Desktop and published them on to Tableau Server which allowed end users to understand the data on the fly with the usage of quick filters for on demand needed information.
• Scheduled data refresh on Tableau Server for weekly and monthly increments based on business change to ensure that the views and dashboards were displaying the changed data accurately.
• Tested dashboards to ensure data was matching as per the business requirements and if there were any changes in underlying data.
• Collaborate with development team on data approach for coding Understand data guidelines, and understand data sources available, what is new based on requirements, and how the project will impact common data stores
• Participated in meetings, reviews, and user group discussions as well as communicating with stakeholders and business groups.

Environment: SQL server, Data Visualization Tableau 8x Desktop and Server, MS Excel.

Confidential, New City, NY

Tableau Developer

Responsibilities:

• Interacted with the customer service team; reviewed and analyzed the business requirements and various data sources in order to design, develop, test and produce the reports in Tableau Desktop and Sever
• Created reports of customer profile analysis, customer satisfaction rate, product profile performance report to support the customer service team analysis
• Created heat map by color, broken into age groups, salary groups, job category groups, etc. allowing business analysis team to understand customer groups difference
• Extracted data from different data sources including excel files, flat files, and T-SQL Server
• Designed the customized queries to blend and join the tables together and used filter functions to reduce the data loading size to ensure the accuracy
• Performed calculated fields, mapping and hierarchies to design the report
• Created users filter to show the specific customer or specific product performance
• Applied Geo Maps, Heat Maps, Drill through, Drill down reports functionality
• Developed a dual-axes bar chart with multiple measures, and have created donut charts and pie charts for better visualization
• Developed story telling dashboards in Tableau and published them on Tableau Server allowing business users understand data and constructed quick filter for on demand needed information
• Created comments and captions of the analysis to better explain the reports
• Deployed the reports to report server in time to ensure the efficiency of the analysis

Environment: Tableau, SQL Server Reporting Services (SSRS), T-SQL, Advanced Excel, MS Office Suite

Confidential, Randolph, NJ

Tableau Developer

Responsibilities:

• Involved in requirements gathering and technical discussion of the reporting data model.
• Worked on different Ad-hoc scenarios to come up with various functional specs / Demo's for User acceptance.
• Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop Utilized advance features of Tableau software like to link data from different connections together on one dashboard and to filter data in multiple views at once.
• Created Prompts, customized Calculations, Conditions and Filter (Local, Global) for various analytical reports and dashboards.
• Generated groups for the application field to do category-based analysis.
• Utilized the pages cards to create visualizations for better understanding of the growth margins with respect to revenue and expense over time.
• Performed Predictive analysis using classification (Decision Tree Algorithm, Naïve Bayes, SVM), clustering (K-means), Association Rule Mining and Network Analysis.
• Created Bullet graphs to determine profit generation by using measures and dimensions data from MS SQL Server, MS Access, MS Excel
• Combined views and reports into Interactive Dashboards in Tableau Desktop
• Designing, creating and publishing customized interactive reports, dashboards, and scheduling using Tableau Server.
• Created action filters, sets, parameters and calculated sets for preparing worksheets and dashboards in Tableau.
• Performed Tableau type conversion functions when connected to relational data sources.

Environment: Tableau, SQL, BI, SSIS, Oracle, Python, Advanced Excel, MS Office Suite

Confidential, Newark, NJ

Tableau Developer/ Data Analyst

Responsibilities:

• Created Dashboards by connecting to different data sources and databases.
• Worked on creating interactive, real-time dashboards using drilling downs and customizations.
• Monitor server activity/usage statistics to identify possible performance issues/enhancements
• Published Tableau dashboard on Tableau Server and embedded them into portal.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.
• Present the analysis to internal and external teams and Explain data from a business perspective and relevance to Key Performance Indicators.
• Created Tableau models, architectures, and strategies based on business requirements.
• Analyzed and troubleshoot technical issues related to reporting.
• End to end BI implementation of Data Visualization, ETL and Data Warehousing.
• Creating Data Visualizations as per customer requirements.
• Elicit customers to understand their business processes, at both micro and macro levels.
• Create and setup technology-based solution architecture for proper functioning of BI.
• Creation of data models, warehousing and dashboards based on the KPIs identified.
• Client achieved 23% increase in efficiency within a quarter of implementation.

Environment: Tableau Desktop, Tableau Server, Advanced Excel, MS Office Suite

Confidential, Princeton, NJ

Tableau Developer

Responsibilities:

• Involved in analyzing the user requirements and transform them into Tableau Dashboards and Reports.
• Write complex SQL queries and optimizing them to pull the required data in an effective way and handle the performance issues.
• Utilized views, stored procedures and custom SQL queries to validate data from spreadsheets and MySQL to Tableau.
• Created interactive reports and dashboards by making use of LOD expressions, actions, local and global filters, calculated fields, groups, sets, hierarchies and parameters in Tableau.
• Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps and used data blending feature in Tableau.
• Involved in Tableau Server and Desktop Installation, Configuration, Creating Users, Groups, Projects and Assign Privileges etc., in a multi-server environment.
• Created tables, views and adding/changing tables for data load and transformation, and data extraction.
• Distilled complex information from given database by performing SQL queries such as Joining several data tables.
• Importing/exporting data by developing SQL queries against SQL Server database into Excel for analysis and reporting.
• Practiced data analysis workflows from SQL to Excel and created effective visualizations that delivers essential information.
• Increased efficiency by 24% in time management while delivering services and resolving tickets.

Environment: Tableau Desktop, Tableau Server, SQL, My SQL, Python, Excel