SUMMARY

• 10+ yrs. of experience in IT industry with around 5+ yrs. of experience as a Data Analysts with Tableau and strong background in Databases concepts and 5+ yrs. as .Net Full Stack Developer
• Experienced in working on Tableau (Desktop, Server, and Online),creating Dashboards and Reports using different functionalities.
• Hands - on experience on working with Cloud Technologies like AWS Redshift.
• Good hands-on experience on Tableau desktop with development, maintenance and troubleshooting Tableau Dashboards.
• Conducted initial in-depth analysis of the business.
• Create a wide variety of analysis including Comparisons, Trending, andWhat-if Analysis.
• Proficient with Cross tab, Scatter Plots, Geographic Map, Pie Charts, Bar Charts, Page Trails etc.
• Expertise in customized charts like Funnel Chart, Pareto Chart, Butterfly Chart, Lollipop Chart, Waterfall Chart, Donut chart etc.
• Strong understanding of advanced Tableau features including Calculated fields, Parameters, Table Calculations, Row-Level Security, Joins, Data Blending, and Dashboard Actions.
• Developed interactive dashboards with Quick filters, Parameters and Actions to handle views more efficiently and using context filters, sets while dealing with huge volume data.
• Facilitate small working groups to standardize data and reports used in planning and forecasting.
• Involved in Requirement Gathering/Analysis, Report Design, Development, Testing and Production support of reporting and analysis projects.
• Designed and developed ETL workflows and datasets in Alteryx to be used by the BI reporting tool. ETL specific for creating datasets (to be used by Tableau Data Extract for BI).
• Expertise in using Alteryx Data Blending tool.
• Translate business logic from one system (Excel, SQL, etc..) into Alteryx in a quick and accurate manner.
• Worked on Maps using Map Services (Map box).
• Created Polygon Maps in Tableau using Shape Files and Manually plotting Latitudes and Longitudes.
• Designing effective dashboards with themes following UX guidelines set by customer and using latest features available in Power BI to guide readers through a compelling data-driven story.
• Build dashboards, reports and cubes using SQL and Power BI.
• Integrate different data sources and create data sets within Power BI.
• Good experience with Data Wrangling (merging, grouping, concatenating etc.) using Tableau, Power BI and Python (Panda’s library)
• Used advanced SQL scripting writing custom queries using different functions like UNION, CASE, JOINS and DATE functions etc.
• Expert in all areas of SQL Server development including SQL Queries,Views, Relational Database Models, Stored Procedure, Triggers, Cursors, and Data Integrity.
• Strong Exposure in creating various types of Sub Queries and proficient in writing queries using Analytical Functions.

TECHNICAL SKILLS

BI Tools: Tableau Desktop 2020.2, 2019.1,2018.3,10.3, 9.2,8.3 Tableau server, Tableau Online, Tableau public

ETL Tools: Alteryx

Cloud Technologies: AWS Redshift

Data Bases: MS SQL Server, Oracle, PostgreSQL, MySQL, Excel Flat files Python, XML, Oracle, PL/SQL, HTML, JavaScript, JSON

PROFESSIONAL EXPERIENCE

Confidential

Tableau Developer

Responsibilities:

• Involved in Requirement Gathering/Analysis, Design, Development, Testing and Client Demo.
• Used SSH tunnel to connect to data behind firewall with Putty.
• Connected Tableau Dashboard to multiple databases like AWS Redshift, PostgreSQL and MySQL and generated detailed view Drill Down reports as per the user requirements.
• Effectively used Cross Database Join feature intableau
• Implemented action filters, parameters, groups, calculated fields and set for preparing dashboards and worksheets inTableau.
• Built Detailed view and established a high visibility Course multi-level drill down dashboards for Business leaders and provided ranking based on best performances.
• Created interactive reporting platform from ground up with tableau.
• Provided ad-hoc reports and in detail analyses with forecasts which influenced leadership decisions.
• Extensively used LOD expressions, Calculated fields, Table Calculations and Sets to visualize users' critical requirements.
• Designed, developed dashboards with stack bars, scattered plots, whisker plots, geographical maps with Tableau functionalities.
• Groups, sets, calculations reference lines, targets, animations etc. are used in reports and stories.
• Executed and tested required queries and reports before publishing to the server.
• Made single click PDF download.
• Administered user, user groups and scheduled refreshes for reports on Tableau server.
• Implemented action filters, parameters, groups, calculated fields and set for preparing dashboards and worksheets inTableau.
• Reviewed basic SQL queries and edited inner, left, and right joins inTableauDesktop. Interacted with customers on a regular basis to resolve issues.
• Created custom SQL connections and calculated fields within Tableau to facilitate automated production of data visualizations.
• Published Workbooks by creating row level security so that only appropriate users can view/edit them.
• Ensured data accuracy and reliability of reports.

Tools: and Technologies: Tableau Desktop 2021.1, Tableau server, AWS Redshift, PostgreSQL, MySQL, Excel, Microsoft Office, Jira, Putty

Confidential, Wayne, PA

Tableau Developer

Responsibilities:

• Participated in the user requirement gathering and Design meetings.
• Creating Reports for end client to help them understanding Seasonal Business and understand the needs of Customers.
• Implemented action filters, parameters, groups, calculated fields and set for preparing dashboards and worksheets inTableau.
• CreatedTableauscorecards, dashboards using Stack bars, bar graphs, scattered plots, line charts, using show me functionality.
• Effectively used cross database join feature intableau.
• Translate business needs into reporting and analytic requirements.
• Build interactive dashboards and publish Tableau reports utilizing parameters, calculated fields and table calculations, user filters, action filters and sets to handle views more efficiently for finance department employee, salary, Joining date and their promotion date and years of service etc.
• Worked on the development of Dashboard reports for Key Performance Indicators for the top management.
• Rebuilding existing Reports into Tableau Visualizations with user and filters for Inventory department based on Stock and availability of products.
• Developed dashboards in Tableau Desktop and published them on toTableauServer for marketing department employee base on offers, latest client benefits and newly launched plans.
• Ensured data accuracy and reliability of reports.
• Generated tableau dashboards with forecast and reference lines
• Reviewed basic SQL queries and edited inner, left, and right joins in Tableau Desktop. Interacted with customers on a regular basis to resolve issues.
• Published Workbooks by creating row level security so that only appropriate users can view/edit them.
• Used Alteryx tool to transform data from MY Sql Server and oracle database and create Data Modelling and apply business logic in the workflow for smoother reporting process.

Tools: and Technologies: Tableau 2019.1,2018.3, Power BI, Python, MS SQL Server, Oracle, PL SQL, Excel Flat files, JSON, Alteryx

Confidential

BI Developer / Tableau Developer

Responsibilities:

• Develop fully customizable and user-friendly BI application based on Tableau to be used by all levels of management to extract the reports.
• Working as Tableau Developer with expertise in Tableau Reports development for health care domain.
• Extracting data from multiple sources like flat files, SQL server and transforming, validating data and loading into final Destination.
• Implementing the Business Requirements in Tableau Dashboards. Involved in creating calculated fields, mapping, hierarchies, Action filters in worksheets and dashboards
• Working on performance optimization of the reports and dashboard
• Working on Report migration with extracts from Development, ST, SIT & UAT environment
• Design and developed drill-through and drill-down enterprise reports.
• Creating Indexes, views, stored procedures, functions are used using the SQL Server.
• Involved in analyzing and decision making of the report designs to reach the desired output.
• Involved in gathering requirements, estimating the project plan and maintaining the reporting team and document designing.
• Worked on Migration of tableau reports to Power Bi as POC.
• Used Alteryx tool to transform data from MY Sql Server and oracle database and create Data Modelling and apply business logic in the workflow for smoother reporting process.

Tools: and Technologies: Tableau Desktop, Tableau server, Tableau Online, Power BI, MS Excel, Alteryx