SUMMARY:

• Working as Tableau & Power BI reporting with over 8 years of IT experience analysis, design, testing, development, and implementation of client/server applications.
• Have extensive experience in sourcing, processing, managing, and distributing business - driven and actionable visual reports for key stakeholders in finance, retail, Health Care& insurance domain within omnichannel data-centered environments.
• Extensively worked on Tableau (Desktop, ERP, and Server)
• Experience in gathering Requirements, Analysis, Design, Development, Deployment, Testing, and Support of rich Interactive Dashboards and Workbooks using Tableau Desktop.
• Worked extensively on several projects in both OLAP and OLTP applications.
• Apply design patterns to develop BI solutions for delivery on web and mobile devices such as tablets and smartphones.
• Experience in Tableau functionalities like Tableau Extracts, Cross Database joins, Parameters, Filters, Contexts, Data Source Filters, Actions, Functions, Sets, Groups, Calculations, Data Blending, etc.
• Experience with creating the Tableau dashboards with relational and multi-dimensional databases including Oracle, MySQL, and HIVE, gathering and manipulating data from various sources.
• Experience in Performance Tuning of reports within Tableau Server and Tableau Dashboards
• Proficient in design and development of various dashboards, reports utilizing Tableau Visualizations like Dual Axis, Bar Graphs, Scatter Plots, Pie-Charts, Heat Maps, Bubble Charts, TreeMaps, Funnel Charts, Box Plots, Waterfall Charts, Geographic Visualization and other making use of Dashboard Action, Data Source, and Context Filters according to the end-user requirement.
• Practical understanding of the Data modeling (Dimensional & Relational) concepts like Star-Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables.
• Generated periodic reports based on the statistical analysis of the data from the various time frame and divisions using Pow

PROFESSIONAL EXPERIENCE:

Confidential

Tableau Developer

Responsibilities:

• Involved in reviewing business requirements and analyzing data sources from Excel/Oracle SQL Server for design, development, testing, and production rollover of reporting and analysis projects within Tableau Desktop. Generated advanced Tableau dashboards with quick/context/global filters, parameters, and calculated fields that allowed to track and improve customer units KPI. Excessively worked on Marketing and customer retention data, which aid in making key business decisions. Publish the Power BI Desktop models to Power BI Service to create highly informative dashboards, collaborate using workspaces, apps, and get quick insights about datasets. Used Power Query to acquire data and Power BI desktop for designing rich visuals. Supported the development and modification of Tableau views in Tableau Desktop 10, while preparing documentation and users from respective units Meeting directly with business users to understand and clarify reporting requirements and translate them to actionable visualization tools. Responsible to work as a leader inside Data Management to improve scalable Microsoft - based ETL using SSIS and reporting solutions using Power BI to meet the business needs of the organization for its data warehouse. Experience with creating the Tableau dashboards with relational and multi-dimensional databases including Oracle, MySQL, and HIVE, gathering and manipulating data from various sources. Create data models that ensure peak performance for Tableau dashboards.
• Build compelling, robust, effective interactive dashboards in Tableau that answer key business questions. Prepared Weekly Business Reviews and Quarterly Business Reviews on pricing, to analyze the most effective pricing by showing statistical trends over the weeks and through a quarter Tuned Tableau report performance and decreased 70% of executing time by optimizing DataMart and writing stored procedures. Responsible for the development of SSRS or Power BI reports by business requirements. Use multiple data sources like Salesforce, SAP, SQL Server, Oracle. Create reports in the Power BI preview portal utilizing the SSAS Tabular via Analysis connector. Develop and test various Power BI visualizations for the dashboard and ad-hoc reporting solutions by connecting different data sources and databases. Worked with Software Development Life Cycle, RDBMS, and Data Warehouse & Data Modeling concepts. Worked extensively in Informatica Power Center 8.6 9.1. Published dashboards to Tableau Server, scheduled auto-refresh base on the required frequency, and managed entitlement for different user groups Work with the Tableau Admin team to ensure the stability and performance of the Tableau Server Presented reports to internal stakeholders and trained users to have better utilization of the interactive dashboards The supported team as a subject matter expert (SME) through troubleshooting and identify o

Confidential

Sr. Tableau Developer

Responsibilities:

• Created views in Tableau Desktop that were published to the internal team for review and further data analysis and customization using filters and actions. Created Heat Map showing current service subscribers by the color that were broken into regions allowing the business user to understand where we have most users vs. least users. Projected and forecasted future growth in terms of the number of subscribers based on upgrading to LTE by developing Area Maps to show details on which states were connected the most. Converted charts into Crosstabs for further underlying data analysis in MS Excel. Enabled the data security filters for the users/groups in an AD. Designed Reports in SSRS and Power BI and published them in the Power BI report server. Tuned the performance of the report using Cache options / Timely refreshes of data. 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 keys from each database for data validation. Designed and created data extracts, supporting SSRS, POWER BI, Tableau, or other visualization tools reporting applications.
• Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with the incremental load. 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. Developed SSIS packages using various Control and Data Flow items to Transform and Load Data using SSIS. 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. Installed and configured Enterprise gateway and Personal gateway in Power BI Services. Collaborate with the 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: Tableau Desktop 10.4/2018.3, SSIS, SSRS, Power BI, Tableau Server, MS Office Suite, Oracle SQL Server R2, MS Excel

Confidential

Tableau Developer

Responsibilities:

• Developed Reports/Dashboards with different analytics views like Pivot table, Graph, Column Selector, and View Selector, Action links by using drill and local filters Analyzed data successfully and revealed wasteful practices to patient care which helped in bending the cost curve downward around 30% Used Tableau Desktop for blending databases and creating different interactive views and dashboards. Created extract files for improving the performance. Used different Mark types and Mark properties in views to provide better insights into large data sets. Created various types of charts to provide better visualization. Provided continued maintenance and development of bug fixes for the existing and new SSRS/Power BI Reports. Developed the reports into Excel PowerPivot and connecting from SSAS. Using Tableau Desktop created Interactive reporting dashboards by combining multiple views. Review
• Vendors Status Reports with Project Team and a created visualization for budget forecasting. Published views and dashboards in Tableau Server for auditor review. Used ETL (SSIS) to develop jobs for extracting, cleansing, transforming, and loading data into the data warehouse. Prepared the complete data mapping for all the migrated jobs using SSIS. Performed data analysis on a daily, weekly, and monthly scheduled refresh of data based on that business or system change that has happened to ensure that the developed dashboards are displaying accurate and up - to-date live data and sent those into production after editing. Involved in troubleshooting and performance tuning of reports and resolving issues within Tableau Server and Reports. Participated in weekly meetings, reviews, and user group meetings as well as communicating with stakeholders and business groups.Environment: Tableau Desktop, Tableau Server, SSIS, SSRS, Oracle SQL Server, MS Excel SSRS reports.

Confidential

Tableau Consultant

Responsibilities:

• Installed SQL server 2008R2 with latest service pack and established connectivity with the database, created, configured, and maintained databases Created and handled maintenance plans for various tasks Maintained course addition and status update SSIS packages of daily feeds to source system via third party SQL server application Created packages with different control flow options and data flow transformations such as Conditional Split, Multicast, Pivot, Union etc. Created, tested, and deployed SSIS packages for data migration into facts and dimensions tables in the Data Mart from the source data warehouse tables

  Developed complex SSIS packages using various tasks, containers, data transformation like fuzzy lookup, for each loop and loop sequence container. Responsible for logical and physical data modeling, database design, star schema, data analysis, programming, documentation and implementation Created SSIS packages for incremental loading, slowly changing dimensions, data conversion, cleansing tasks Performed the tuning of existing ETL packages and reduced process time from 8 hours to approx.6 hours, a 25% gain in performance Defined report layouts for formatting the report design as per the need and identified and defined the data sets for report generation using SSRS 2008Environment: MS SQL Server 2005/2008/2008 R2, SQL Server Reporting Services (SSRS) 2005/2008, SQL Server Integration Services (SSIS) 2005/2008, MS Office