SUMMARY

• Senior Tableau Developer/Data Visualization consultant with 11+ years of BI experience in Analysis, Design, Development, Testing and Implementation.
• Over 8 years of extensive experience in developing dashboards using Tableau Desktop/Tableau Server in various versions of Tableau (7.x to 2020.x) across various industries such as, Investment, Banking/Finance, Retail, Manufacturing, Telecommunication and Pharmaceutical Industry.
• Proficient in design and development of various dashboards, reports utilizing Tableau visualizations like bar graphs, line diagrams, pareto charts, funnel charts, scatter plots, pie - charts, donut charts, bubble charts, funnel charts, heat maps, tree maps according to the end user requirements.
• Expertise in using advance Tableau features like Calculated fields, Sets, Groups, Parameters, context filters, quick filter, global filters, custom geo coding, Actions, LOD, Adhoc Calculations, etc.
• Experience in aggregating data and configuring reports from different data sources using data blending and cross data base joins.
• Expertise using Tableau API Such as Python, R and Web Data Connector and expertise in designing dashboards using mobile app lay out such as Tablet, iPhone and iPad.
• Extensive Tableau Experience in Enterprise Environment and Tableau Administrator Experience including technical support, troubleshooting, report design and monitoring of system usage.
• Extensive used Alteryx for Data manipulation, reporting and ETL jobs.
• Experienced in designing rich Interactive reports and dashboards integrating various reporting components from multiple sources.
• Hands on experience in embedding Tableau reports and dashboards on external websites using Java API and Java API Scripting.
• Expertise in Trouble Shooting, Performance tuning of reports and resolving issues in Tableau Server and Reports.
• Experience in working on generating various dashboards to Tableau Server using different data sources such as Teradata, SQL Server, AWS, Sales force, Oracle, DB2, Teradata, SAS datasets, MS Excel etc.
• Worked on integrating several data sources like BIGDATA, Excel, SSAS, and HADOOP into Tableau reporting.
• Highly Proficient in Agile and Waterfall software development life cycles.
• Extensively developed Business Requirements Documents, Functional Design Documents and Technical Design Documents.
• Interviewed SMEs and Stakeholders to get a better understanding of client business processes and gather business requirements.
• Experience with Crystal Reports, Business Objects, Xcelsius, Informatica Power Center, Alteryx, SQL Server, Oracle, Teradata, Hadoop and Hive.
• Proficient in writing complex SQL queries, scripts in Python & automating the data pulling from multiple sources by creating Alteryx workflows.
• Outstanding Data analysis skills including Data mapping from source to target database schemas, Data Cleaning and processing, writing data extract scripts/programming of data conversion and researching complex data problems.
• Extensive experience on designing database using ER modeling and Normalization.
• Hands-on experience using Dimensional Data Modeling, Star Schema Modeling, Snow-Flake Modeling, Fact and Dimension Tables, Physical and Logical Data Modeling.
• Possess strong knowledge of database management in writing complex SQL queries, Stored procedures, database tuning, query optimization and resolving key performance issues.
• Highly motivated team player with excellent Interpersonal and Customer Relational Skills, Proven Communication, Organizational, Analytical, Presentation Skills, and Leadership Qualities.

TECHNICAL SKILLS

Analytical Tools: Tableau 2020.x/ 2019/2018/10. x, 9.x, 8.x, 7.x (Desktop/Server/Reader/Public/Online), Google Analytics, Adobe Analytics, Power BI, Business Objects.

Data Integration Tools: Alteryx, Informatica, Tableau Prep,SSIS

Data Modeling /UML Tools: Power Designer, MS Office (Visio, Word, Excel)

RDBMS: Teradata, Oracle, MS SQL Server, DB2, Sybase, Access, SAP HANA

Big Data: Hadoop, Spark, Hive, Impala.

SQL Tools: Teradata SQL Assistant, PL/SQL Developer, Toad, SQL Server Management Studio, Query Analyzer

Document Management: SharePoint, JIRA, Version One

Scripting Languages: SQL, T SQL, PL SQL, Stored Procedure, Python, R

Operating Systems: Windows, Linux, Unix

Industries /Domains: Financial/Investments, Banking, Pharmaceutical, Retail, Manufacturing, Telecommunication

PROFESSIONAL EXPERIENCE

Confidential, New York, NY

Sr. Tableau Developer/ BI Developer

Responsibilities:

• Worked on designing and development of Tableau visualization solutions and Created Business requirement documents and plans for creating dashboards.
• Involved in creating database objects like tables, views, procedures, triggers, and functions using Oracle to provide definition, structure and to maintain data efficiently.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Restricted data for users using Row level security and User filters.
• Developed Tableau visualizations and dashboards using Tableau Desktop.
• Developed Tableau workbooks from multiple data sources using Data Blending.
• Provided 24/7-production support for Tableau users.
• Working with team of developers designed, developed and implement a BI solution for Sales, Product and Customer KPIs.
• Developed a 360-business dashboard with multiple panels and parameters that became a favorite sales tool.
• Implemented Tableau mobile dashboards via Tableau mobile application.
• Designed the architecture of Tableau security by customizing the access levels and creating various user groups by assigning row and column level security at application level, folder level and user level.
• Worked on creating interactive, real-time dashboards using drilling downs and customizations.
• Published Tableau dashboard on Tableau Server or Tableau Online and embedded them into portal.
• Used Business Objects universes and webi report as data sources for Tableau dashboards.
• Designed and setup user securityfor the entire landscape to facilitate Windows AD login.
• Interacted with Business Analysts and Data Modelers and defined Mapping documents and Design process for various Sources and Targets.
• Good SQL reporting skills with the ability to create SQL views and write SQL queries.
• Extensively worked on micro strategy administration that includes intelligence server administration, configuration of memory settings and performance monitoring.
• Handled user licenses for projects.
• Identify opportunities to develop forecasts, statistical models, segmentation schemes, and data-driven analyses to drive marketing and merchandising efforts around customer acquisition and conversion.
• Used Alteryx to automate, Analyze and generate reports from various sources.
• Involved as a technical expert providing input to application design regarding production tuning and administration requirements.
• Lead the design and development of analytical projects designed to understand key business behaviors that drive customer acquisition, retention, and engagement.
• Partner with the Technology teams to deliver a stable and highly available reporting platform.
• Plan and implement the overall analytics and business intelligence strategy.
• Worked with the administrator to monitor and fine tune SQL queries for better performance of reports.

Environment: Tableau (Desktop/ Server) 2020.x/2019.x, 10.5, SQL, SSIS, Excel, Alteryx, Windows and SSMS.

Confidential, New York, NY

Sr. Tableau Developer/ Data Visualization Expert

Responsibilities:

• 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
• Performed Python and R integration in Tableau for statistical analysis.
• Used Google and Adobe analytics data to build the dashboards in Tableau for enterprise website analysis.
• Performeddata analysisanddata profilingusingSQLon various sources systems including Oracle andTeradata.
• Used Data Blending and combined Adobe Marketing Cloud data with other aggregated data, to compare and analyze data in different perspective using Alteryx.
• Developed Alteryx modules for big data analysis of geospatial information and SQL queries
• Wrote SQL code with multiple joins to pull the data from multiple Oracle Database. Optimized and automated the query in Alteryx.
• Developed Tableau Data Extracts for dashboards by creating ETL workflows in Alteryx from multiple data sources and customized data.
• Created extract files for improving the performance. Used different Mark types and Mark properties in views to provide better insights into large data sets.
• Actively involved in the creation of users, groups, projects, workbooks and the appropriate
• Maintained and Installed Tableau Server in all the environments.
• Involved in Performance Tuning of the database, which included creating indexes, optimizing SQL statements and monitoring the server.

Environment: Tableau 2018.x/10.5 (Desktop/Server), AWS, Teradata, Oracle 12g, JIRA, Alteryx, Python (Tabpy), SharePoint, MS Office Suite (Word, Excel, PowerPoint).

Confidential, New York, N.Y

Senior Tableau Developer/ Data Visualization Consultant

Responsibilities:

• Involved in full project lifecycle of SDLC and coordinated with all project teams.
• Created business requirements and analyzed data sources from Excel/Oracle SQL Server for design, development, testing, and production rollover of reporting and analysis projects within Tableau Desktop.
• Created dashboards by extracting data from various sources using parameters, sets, groups and calculations.
• Developed interactive dashboard and applied actions (filter, highlight and URL) to dashboard and created calculated fields, mapping, hierarchies and drilling through reports in dashboard.
• Built complex calculations using advance functions (ATTR, LOD, DATEDIFF, Ifs, Nested Ifs, RANK DENSE, OR, NOT, AND, and Quick Table calculations).
• Used Python integration in tableau using Script bool, Script Int, Script real and Script string and performed Statistical/predictive analysis.
• Generated guided navigation links for Interactive dashboards in Tableau.
• Developed Charts like, Bar over bar, Butterfly chart, Donut Chart, dual-axis bar chart with multiple measures and data blending in case of merging various sources.
• Used Data Blending, groups, combine fields, calculated fields, and aggregated fields and spotlighting to compare and analyze data in different perspectives.
• Performed extraction, transformation and loading of data directly from different source systems like flat files, Excel, Oracle and SQL Server.
• Performed Tableau type conversion functions when connected to relational data sources.
• Used Web data connector and developed Tableau dashboards using various websites based on Json and HTML.
• Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.
• Gathered data from different data sources like MySQL, Excel, Oracle, MSSQL,Hadoop and Hive etc.
• Created extracts and scheduled data refresh on Tableau Server for weekly and monthly increments based on the new changes to ensure that the views and dashboards were displaying the changed data accurately.
• Utilized Alteryx for blending data from multiple databases to create a single source of truth.
• Data Manipulation using Oracle, SQL and automated creation of Tableau Data Extract by creating ETL workflow using Alteryx.
• Created Scripts to load data from one server to another server using Alteryx.
• Created visual workflows in Alteryx for data blending and analysis using data quality, integration and transformation. .
• Provided post implementation production support.

Environment: Tableau 9.x/8.x (Desktop/ Server), Alteryx, JavaScript, SQL Server, Oracle, SQL Server, Bigdata/Hadoop, Jira, VISIO, MS Office Suite (Word, Excel, PowerPoint).

Confidential, New York NY

Tableau Developer

Responsibilities:

• Developed Tableau BI Dashboard reporting solution for different Stakeholders in the organization and Published Dashboards onto Tableau Server.
• Created calculated fields using Tableau for implementation of color coding and proper aggregations for data coming from Oracle.
• 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.
• 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 and assisted users in Tableau dashboard development.
• Worked with production team to implement UI and create enhancements to optimize user experience.
• 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.
• Leveraged advanced features of tableau such as calculated fields, parameters, and sets to support data analysis and data mining.
• 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 troubleshoot performance, scheduling, and server related issues.
• Tested Dashboard for data accuracy and Functionality.
• Migrated Reports & Universes from Development to Testing and to Production Environment sing Import Wizard.
• Created canned reports in Web Intelligence, Created New Universes and supported existing Business Objects Universes using Universe Designer and IDT.

Environment: Tableau Desktop/server 6.X/7.X, Business Objects 4.X/3.X, Universe Designer, Oracle 10G, UNIX, SQL Server 2005, Excel PivotTable reports.

Confidential, New York, N.Y

Tableau Developer / Data Analyst

Responsibilities:

• Developed an end to end solution for Finance Stakeholders in Tableau.
• Created Data Connections, published on Tableau Server for usage Finance and Sales and Marketing Stakeholder.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Resolved various performance issues and analyzed the best process distribution for different projects.
• Created and assisted users in Tableau dashboard development.
• Administered and provided production support for Enterprise wide Tableau application consisting of multiple key functional business domains.
• Extensively used analytical features in Tableau like Statistical functions and calculations, trend lines, forecasting etc. in many tableau reports.
• Publish the developed dashboard, reports on the Tableau Server so that the end users having access to the server can view the data.
• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-2005.
• 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 Microsoft Reporting Services.
• Created various complex SQL Queries, Stored Procedures, CLR Procedures, Views and User Defined Functions to implement the business logic.
• Used Stored Procedures to pull the data from the Production server and scheduled jobs to run the Stored Procedures.
• Optimized queries by looking at Execution Plan for better tuning of the database and Tableau Dashboards.

Environment: Tableau Server 5.x, Tableau Desktop 6.x, MYSQL Server, MS SQL Server 2008, Oracle 10g, Excel, TSQL, UNIX, SQL Server 2008, Oracle 9i, Toad, MS Office, Visual Studio.

Confidential, Basking Ridge, N.Y

Business Objects Developer

Responsibilities:

• Interacted with the management and business Decision-makers to identify business requirements.
• Documented reporting needs of the Business Service and Support Organization and disseminate those requirements into a data warehouse strategy resulting in both operational and analytical reporting.
• Used Restricted and Calculated Key Figures, Virtual Key Figures, Formulas, Variables, Replacement path Variables, Customer Exit Variables, User entry Variables in the Query Designer.
• Involved in developing, designing and maintaining new and existing universes by creating joins and cardinalities responsible for creation of the universe with Classes, Objects and Condition Objects.
• Created Aliases and Contexts to resolve the Loops and Traps (fan traps and chasm traps).
• Leveraged BW queries in to generate WEBI reports using BI Launch Pad in BO to meet user requirements.
• Created monthly and summary reports in WEBI for the different domains like Finance, Marketing and Sales.
• Used Variables, User defined objects, Scope of analysis, Drill mode, Slice and dice mode, Prompts, and Conditions to make reports accurate and easier for analysis.
• Created WEBI reports & Crystal reports and deployed them through Info view with BEX as source
• Exclusively used QAAWS and Live Office to import data to spreadsheet and develop visually rich dashboards.
• Worked on optimizing the performance of the dashboards. Reduced the dashboard loading time by scheduling the backed source webi reports and by selecting the filter option changing with refresh on trigger option to pick from the latest instance.
• Created Dynamic Dashboards using SAP BI data/ BEX Queries.
• Extensively worked on Xcelsius Dashboard using Components like Charts, Selectors (Filters, label Based menus), Tab Sets, Canvas Containers.

Environment: BusinessObjectsXIR3, UDT, Teradata, MySQL, DB2 Crystal Reports, Xcelsius, Web Intelligence.

Confidential, Bentonville, AR

Business Objects Developer

Responsibilities:

• Worked with end users to gain an understanding of information and core data concepts behind their business.
• Developed Adhoc reports in Business Objects Webi and used Xcelsius for Visualization.
• Responsible for installing Business Objects, Xcelsius, Toad and Crystal Report client tools for different users.
• Implemented security set up for users and Groups.
• Unit tested, and fixed issues identified in BOXI 3.1 universes and reports migrated from BOXI R2.
• Fixed the bugs caused after migration in dashboards.
• Used life cycle manager to promote the jobs from DEV to QA.
• Assisted in defining business requirements for the IT team and created BRD and functional specifications documents along with mapping documents to assist the developers in their coding.
• Analysis of functional and non-functional categorized data elements for data profiling and mapping from source to target data environment. Developed working documents to support findings and assign specific tasks
• Worked on claims data and extracted data from various sources such as flat files, Oracle and Mainframes.
• Worked with data investigation, discovery and mapping tools to scan every single data record from many sources.
• Performed data analysis and data profiling using complex SQL on various sources systems including Oracle and Teradata.
• Extensively used Informatica Power Designer to pull the data from various data bases and integrate the data.
• Design, Create and Monitor workflows using workflow designer and workflow monitor.
• Performed data management projects and fulfilling ad-hoc requests according to user specifications by utilizing data management software programs and tools like Perl, Toad, MS Access, Excel and SQL
• Written SQL scripts to test the mappings and developed Traceability Matrix of Business Requirements mapped to Test Scripts to ensure any Change Control in requirements leads to test case update.
• Involved in extensive data validation by writing several complex SQL queries and Involved in back-end testing and worked with data quality issues.
• Identify & record defects with required information for issue to be reproduced by development team.

Environment: Webi, Crystals, Xcelsius, SQL Server 2008, MS SQL, Informatica, Windows XP, MS Office Suite (Word, Excel, PowerPoint).