SUMMARY

• 8+ years of experience in Data warehousing and Business Intelligence technologies along with strong experience of data visualization using Tableau.
• Extensive Tableau Desktop, Tableau Server Experience in Enterprise Environment, in various Tableau versions of 6.x, 7.x, 8.x, 9.x and 10.x as a developer and Administrator.
• Experience in working with Tableau Desktop, Tableau Server, Alteryx, and Tableau Reader in various versions of Tableau 2020/2019/10 x/9x/8x.
• Experienced business analyst specializing in requirements analysis and SDLC documentation. Waterfall, UP, Agile and Scrum methodologies.
• Experience gathering customer requirements, writing test cases, and partnering with developers to ensure full understanding of internal/external customer needs.
• Creation of metrics, attributes, filters, reports, and dashboards created advanced chart types, visualizations, and complex calculations to manipulate the data.
• MS Office Suite Skills, especially SharePoint, PowerPoint & Excel (including pivot tables, charts etc.)
• Connected Tableau server to publish dashboard to a central location for portal integration.
• Employed various Tableau functionalities like Tableau Extracts, Parameters, Filters, Contexts, Data Source Filters, Actions, Functions, Trends, Hierarchies, Sets, Groups, Data Blending and Maps etc.,
• Expertise in Performance Tuning Tableau Dashboards and Reports built on huge Data sources.
• Extensive experience in creating logical tables and columns, Dimensional Hierarchies, Level Based Measures, Time series data for complex data analysis.
• Experience in creating different visualizations using Bars, Lines and Pies, Maps, Scatter plots, Gantt charts, Bubbles, Histograms, Bullets, Heat maps and Highlight tables.
• Proficient in creating Tableau scorecards, Tableau dashboards using advance Tableau functions like calculated fields, LOD (Level of Detail), Ad - hoc Calculations, etc.
• Experience in development of user defined reports to provide on demand data analysis using excel and created charts and pivot tables in Excel.
• Strong Analytical and Problem-Solving Skills with ability to work independently and in team environments, simultaneously on multiple projects with competing priorities.
• Used Data Blending, groups, calculated fields, and aggregated fields and spotlighting to compare and analyse data in different perspectives.
• Experienced in designing customized interactive dashboards in Tableau using Actions, filters, parameter, Security Concepts, calculations, and Relationships.
• Strong understanding of advanced Tableau features including calculated fields, parameters, table calculations, row-level security, R integration, joins, data blending, and dashboard actions.
• Designed and Optimized Connections, Data Extracts, Schedules for Background Tasks and Data Refreshes for corporate Tableau Server.
• Reviewed basic SQL queries and edited inner, left, and right joins in Tableau Desktop by connecting live/dynamic and static datasets
• Interacted with the users and troubleshooting the problems involved with the reports, dashboards and problems related to the privileges.
• Hands-on development assisting users in creating and modifying worksheets and data visualization Dashboards.
• Quickly and effectively diagnose and respond to service desk requests regarding data integrity and functional or interactive issues in existing and future dashboards in Finance and Funds sector.
• Worked in Tableau environment to create dashboards like weekly, monthly, daily reports using Tableau desktop & publish them to server.
• Understanding and translation of the current existing reporting system SSRS reports to convert them as Tableau reports and dashboards.

TECHNICAL SKILLS

BI Tools: Tableau 9x, 10x (Desktop, Server, Public), Looker.

Business Intelligence: Development Studio (SSRS), SSIS, Alteryx, Qlik sense, Einstein Analytics and Power BI, Crystal Report, Cognos.

ETL tool: Informatica Power Centre 7/8, SQL Server Integration Services (SSIS), OLAP(Cubes)

Databases: Teradata, SQL Server, MySQL, SQLite, AS, Hadoop/HBase, Hive, MS Access, Oracle 12c, Vertica, Salesforce, DB2.

Applications: Microsoft Office, MS Visio, Visible Analyst, Share point

Web Technologies: HTML, CSS, JavaScript

Languages: C, C#, Core Java, Python, R (BIGDATA)

Web Scripting: XML, XHTML, JavaScript, Ajax, J Query, ASP 3.0, Visual Studio 2003/2005

Web Tools: MS-Front Page, Dream Weaver

PROFESSIONAL EXPERIENCE

Confidential, Greensville, SC

Data warehouse developer / BI Visualization Developer

Responsibilities:

• Created different KPI's using Table calculations, Level-of-Detail (LOD) expressions, Actions, Sets, Parameters, ad hoc reports, calculated key figures manipulating strings, arithmetic calculations, aggregation options, and logical functions.
• Developed Tableau workbooks to perform YTD, QTD, and MTD type of analysis.
• Extensively used advance chart visualizations in Tableau like dual-axis, Box Plots, Bullet Graphs, Tree Maps, Bubble charts, Waterfall charts, funnel charts, etc.
• Assisted business users in solving complex problems. Familiarity with best practices around visualization and design.
• Connecting to Einstein analytics through Tableau and start performing amazing explorations leveraging power of tableau directly against salesforce CRM data.
• Predictive Capabilities from Einstein Discovery into Tableau.
• Developed, published customized interactive reports and dashboards, and managed report scheduling using Tableau.
• Worked extensively with advanced analytics like reference lines and bands, trend lines.
• Expertise in working with data building Groups, Hierarchy, and sets.
• Created BSC 2.0 Dealer Performance Dashboards, and migrating Salesforce Einstein Reports to Tableau and Power BI Using Big Data, Cloud data Hub (Amazon Athena) created Tableau dashboards.
• Actively involved as part of a team for gathering and analysing the needs of End User Requirement and System Specifications Designed various practical Data Visualizations, Charts, Dashboards, Prototypes and Demos, published it in various Tableau workbooks.
• Extensively used analytical features in Tableau like Statistical functions and calculations, trend lines, forecasting etc. in many Tableau reports.
• Leverage Tableau and Salesforce Einstein, giving more action ability of data using salesforce Einstein prediction data in tableau.
• Connecting to Einstein analytics through Tableau and start performing amazing explorations leveraging power of tableau directly against salesforce CRM data.
• Predictive Capabilities from Einstein Discovery into Tableau.
• Involved extensively for building the dashboards such as creating Tableau Extracts, refreshing extracts,
• Tableau Layout designing, Tableau Work Sheet Actions, Tableau Functions, Tableau Connectors (Live and Extract), Dashboard color coding, formatting, and report operations (sorting, filtering ranking, Top-N Analysis, hierarchies).
• Develop Tableau reports that provide clear visualizations of various industry specific KPIs.
• Involved in Publishing of various kinds of Live, Interactive data visualizations, Dashboards, reports, and workbooks from Tableau Desktop to Server.

Environment: Tableau Desktop 2020.4, Tableau Server, Salesforce, SQL, ETL Tableau Prep, SharePoint, MS Visio, Jira Microsoft Office Suite (Word, Excel, PowerPoint).

Confidential, Austin, TX

Sr. Tableau Developer/Admin

Responsibilities:

• Participated in Regulation W Banking Project and requirements gathering and translate business requirements into report visualization specifications design documents.
• Translate business requirements into Tableau Dashboards.
• Using Tableau Prep for Data preparation and combine them into single source of data using joins and unions.
• Extensive experience in Tableau Administration (TSM) Tool for Configuration, adding users, managing licenses and data connections, scheduling tasks, embedding views by integrating with other platforms like SharePoint.
• Extensive usage of Amazon web services (AWS) for connecting to the data sources on cloud using Amazon redshift services.
• Connected to the AWS Redshift directly from Tableau to access cloud data warehouse and quickly perform visual analysis.
• Extensively used Tab admin and Tab cmd commands in creating backups and restoring backups of Tableau repository.
• Setting up active directory on the tableau server for the effortless password management for the single sign on (SS0) in the Salesforce and to view the embedded dashboards.
• Expertise in performance tuning of the Tableau infrastructure including the application configurations and the interaction.
• Developed Python application for Google Analytics aggregation and reporting.
• Developed complex SQL scripts for Teradata database.
• Effectively involved in the data migration from Teradata server to MySQL Server of other reporting Systems.
• Responsible for working with our Enterprise BI Team and Deploying the Thought Spot in Cloud (AWS).
• Experienced with reporting tools, software, and other applications, including SQL Database, Looker, Tableau and Salesforce dashboards (reports designing tool) &Experience on snowflake.
• Worked in Requirement Collections, Analysis, Development and Customization of the Application and implementing Requirements for the Project.
• Advise Business users on data quality requirements for Thought Spot.
• Developed Parameters and Dimension based reports, drill down reports, matrix reports, charts, and Tabular reports using Tableau Desktop.
• Produce high quality and high value visualizations in Tableau that are Regulation W restricts certain kinds of transactions between banks and their affiliates.
• Alteryx to changed unstructured to structured data for better Tableau reporting and data analysis.
• Experience in integrating Alteryx and Tableau, publishing data extracts from Alteryx to tableau server, Pulling data from Alteryx App on the server though Web data connector into Tableau Desktop.
• The main scope of this project is Regulation W aims to protect banks and federal deposit insurance funds from undue financial risk.
• Develop Tableau reports that provide clear visualizations of various industry specific KPIs.
• Use various data source like SQL server, Google Analytics, App Dynamics, Hadoop, and Hive.
• Accessed and transform massive datasets through filtering, grouping, aggregation, and statistical calculation.
• Created a dashboard on Transactions Between Member Banks and Their Affiliates and Intercompany
• Transactions (Transactions Between Member Banks and Their Affiliates - Sections 23A and 23B of the Federal Reserve Act.
• Creating Alters for Transactions between a bank and its nonbank affiliates must occur according to arm’s- length terms and circumstances.

Environment: Tableau Desktop 2019.4, 10x, Tableau Server, SQL Server 2008/2008 R2, Netezza, Tableau Prep, SharePoint, MS Visio, SAS, spark, Agile, Looker, Linux, Jira Microsoft Office Suite (Word, Excel, PowerPoint).

Confidential, San Antonio, TX

Sr. Tableau Developer/Admin

Responsibilities:

• Participated in requirements gathering and translate business requirements into report visualization specifications design documents.
• Translate business requirements into Tableau Dashboards
• Created and managed plans using JIRA Portfolio.
• Assigned the appropriate resources to the JIRA agile Portfolio - Story, Epics.
• Experience in using python API, java script API.
• Produce high quality and high value visualizations in Tableau that are widely adopted by CPI
• Facilitated discussion, decision making, and conflict resolution to ensure consistent progresses.
• Tracked metrics that are important to the team to deliver success and continuous improvement.
• Helped the scrum team ensure they meet the definition of 'done' for each product feature and removed internal and external impediments to their progress.
• Design the ThoughtSpot solution for performance and scalability.
• Quickly resolve any internal customer’s issues raised and publish new versions of dashboards on a regular basis.
• Conducted stakeholder Joint Application Design (JAD) interviews and facilitated meetings with project teams.
• Translated business user concepts and ideas into comprehensive business requirements and design documents.
• Extensive practical knowledge in importing data for use in reporting software (Tableau & Looker) graphs, and flowcharts.
• Planned, facilitated, and reported on quality assurance testing efforts.
• Created Tableau scorecards, dashboards using stack bars, bar graphs, scattered plots, geographical maps, Gantt charts using show me functionality.
• Work with existing data model to produce accurate dashboards with respect to Rally and other tools.
• Involved in the user requirement gathering and Design meetings. Translate business needs into reporting and analytic requirements.
• Created different views in workbook to visually analyse the data.
• Created extracts, published data sources to tableau server, refreshed extract in Tableau server from Tableau Desktop.
• Gathered user requirements analysed and designed software solution based on the requirements.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Created Tableau worksheet which involves Schema Import, Implementing the business logic by customization.
• Created many Dashboard reports for company's decision-making purpose and made them Key Performance Indicators (KPI).
• Created various SSRS Reports involving variety of features like Reports, Charts, Filters, Sub-Reports, Drilldown, Drill-Through, Multi-valued parameters etc.
• Created action filters, parameters, and calculated sets for preparing dashboards and worksheets in Tableau.
• Involved in creating database objects like tables, views, procedures, triggers, functions using T-SQL to provide definition, structure and to maintain data efficiently.
• 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.

Environment: Oracle11g, ABC 11g, OWB 10g Release2, TOAD, PL/SQL, Big data (python, java) JDE, S3, SQL Loader, Microsoft SQL Server, Unix

Confidential, Chicago, IL

Tableau Developer

Responsibilities:

• Created worksheets reports and converted into interactive dashboards by using Tableau Desktop and provided to Business Users, Project Managers and End Users.
• Experienced in designing and developing multiple analytical reports from multiple data sources by using Alteryx data blending on a single worksheet in Tableau Desktop.
• Involved in Interacting with business users and performed Gap Analysis according to Client requirements.
• Created various interactive reports/dashboards using tableau desktop.
• Expertise in Creating Heat Maps showing registers service subscribers by using parameters, colors that were broken into regions allowing business users to make better decisions and improve data performance.
• Used advance features of Tableau like to link data from various sources merged on one dashboard and to filter data in multiple views at once.
• Created different Calculation fields according to requirement, various conditions and applied multiple Filters for various analytical reports and dashboards.
• To estimate profit generation by creating calculated fields and calculation across the table on the data from Micro SQL Server and MS Excel.
• Tableau visualization solutions and looker workflows for XMRCC Mobile Launches (Samsung, Apple, and LG).
• Customer Support calls were recorded in this project and analysis is performed to check the overall satisfaction of the customer.
• Depending on the call logs analysis is performed to check out most frequent questions asked by customers and their solutions are implemented in automated manner in the form of IVR.
• Responsibilities: Involve in Planning, Defining and Designing data based on business requirements and provide documentation.
• Perform Tableau Server admin duties; add users/groups from Active Directory; and schedule instances in Tableau Server including weekly data dump.
• Optimize Indexes, Views, Stored Procedures and Functions using Oracle.
• Create Schedules and extract the data into Tableau Data Engine.
• Building, publishing customized interactive reports and dashboards, report scheduling on Tableau server.
• Worked Data Team to understand business logic behind each report and identified all end users for Migrating tableau reports from one model to other data model.
• Extensively working with User stories and user acceptance criteria, release planning, iteration planning and tracking in RALLY tool for the Tableau Report requirements.
• Assisted clients with physical database modelling, data archiving strategies, data purges and disaster recovery planning.
• Experienced in writing SQL queries to extract data from databases and connecting live/dynamic and static datasets to tableau desktop.
• Experienced on creating, executing test Cases, and documenting the Test Results.
• Involved in scheduling data refresh on Tableau Server for weekly and monthly basis on business change to ensure that the views and dashboards were displaying the updated data accurately.

Confidential

SQL Developer/BI Developer

Responsibilities:

• Gathered user requirements, analysed, and designed software solution based on the requirements.
• Played critical role in establishing best practices for tableau Reporting by conduct meeting with the clients for gathering reporting requirements; identify the KPI's and developing POC Dashboards.
• Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics, and Log Axes. Groups, hierarchies, sets to created summary level and detailed Reports.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Created Relationships, actions, data blending, filters, parameters, hierarchies, calculated fields, sorting, groupings, live connections, and in memory in both tableau and excel.
• Tested Dashboards to ensure data was matching as per the business requirements and if there were any changes in underlying data
• Extensive usage of Amazon web services (AWS) for connecting to the data sources on cloud using Amazon redshift services.
• Connected to the AWS Redshift directly from Tableau to access cloud data warehouse and quickly perform visual analysis.
• Created organized, customized analysis and visualized projects and dashboards to present to executive leadership.
• Created Complicated Calculation Based LOD (Level of detail) feature.
• Expert in SAP Service Connections, Applying support packages, Add-on components, Kernel Upgrades and SPAM updates
• Designing and developing data warehouse and Amazon Redshift BI based solutions.
• Created and documented Standard Operating Procedures (SOP) for Enterprise Monitoring.
• Automated the incoming data intake using R Programming.
• Involved in managing the application's users, groups, and integration with Active Directory
• In-depth knowledge of T-SQL, SSAS, SSRS, SSIS, OLAP, BI suite, Reporting and Analytics.
• Evaluated database performance issues and executed database optimization.
• Prepared backups using Tab admin and Tab cmd commands.
• Developed Scatter Plots and Area Maps to show states utilizing the Mobile App.
• Complied interactive dashboards in Tableau Desktop and published them to Tableau Server which allowed Story Telling behind the Mobile App usage with Quick Filters for on demand needed information with just a click of a button.
• Participated in weekly meetings, reviews, and user group meeting as well as communicating with stakeholders and business groups.
• Prepared project reports for management and assisted the project manager in the development of weekly and monthly status reports, policies, and procedures.
• Good Experience in publishing reports and dashboards to tableau server.
• Found ways to make graphs and tables visually exciting, and aesthetically pleasing, while at the same time maintaining the accuracy of the core information content that is being communicated.

Environment: Tableau (Desktop and Server), SQL Server, JIRA, Oracle, SharePoint, Agile, Tableau.