Home

Suresh - Tableau Developer

[email protected]

Location: Mount Airy, North Carolina, USA

Relocation:

Visa: H1B

Senior Lead BI Consultant PROFESSIONAL SUMMARY Having 16+ years of total IT experience in providing viable business solutions using Tableau, Power BI and SAP Business Objects. Experienced Tableau Developer with over 10 years of expertise in data visualization, business intelligence, and analytics. Skilled in optimizing data processes, collaborating with cross-functional teams, and leveraging advanced Tableau features to deliver actionable insights. Proficient in designing, developing, and managing complex data workflows using Alteryx Designer. Skilled in leveraging advanced data transformation techniques and providing actionable insights to drive business decisions. Strong problem-solving abilities with a focus on optimizing data processes and enhancing operational efficiency. Experience interacting with stakeholders, gathering requirements and assigning priorities to each of them. Good Experience in tableau for Data blending, Data transposing and for unstructured Data Standardizing. Expertise in trouble shooting of Alteryx/Tableau Prep performance issues which were associated with Tableau, Power BI Dashboards. Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau. Worked in all the phases of the project life cycle using Tableau, Power BI and SAP Business Objects technologies. Experience in defining and delivering complex applications and technical architectures in Business Intelligence using BO, Power BI and Tableau implementations. Good Experience in gathering, analyzing, and documenting business requirements, functional requirements and data specifications for Tableau/Power BI Dashboards, Business Objects Universes and Reports. Good Experience in BO universe, Tableau Dashboard, Alteryx work flows and reports performance tuning. Strong Analytical and problem solving skills with ability to work independently and in team environments, simultaneously on multiple projects with competing priorities. Expert in Data analysis, design and development of Power Query, Reports Pages Using Power BI Desktop. Excellent experience in designing Business Objects universes, complex BO reports both full client and Web Intelligence Reports. Experience in creating Xcelsius dashboards by using QAAWS and Live Office as data -connection. Proficient in creating BOBJ OLAP Universes on SAP BW Info cubes and BEx Queries and using them in Query As A Web Service (QAAWS), Live Office for data loading into Xcelsius. Experience on Tableau and BO support projects to handle issues or incidents on priority. Managed incident tickets or problems based on customer requirement. Managed Incidents to take care as per SLA and working towards to meet the project specific deadlines. Provided production support for the existing Alteryx Workflows, Tableau/Power BI dashboards and Business Objects contents and followed defect management process for defect resolution and change management process for any enhancements. Ability to quickly adapt to different project environments and an excellent team member. Possess excellent communication, decision-making, problem solving, analytical, and interpersonal skills, and Quick Learner with result oriented dedication towards goals. Page 2 Technical Skill ETL Alteryx, Tableau Prep Visualizations Tool Tableau 7.0.x/8.1.x/8.2.x/9.x/10.1/2019.x,/2020.x/2021.x/2022.x Xcelsius 2008, SAP Dashboard Designer, Power BI Data Modeling Star-Schema Modeling, Dimensional Modeling, Snowflakes Modeling, FACT & Dimensions. Business Intelligence SAP Business Objects XI R4/R3/R2 6.5 & 5.1, (Designer, Information Design Tool (IDT), DeskI, WebI, Infoview, WebI Rich Client, Report Conversion Tool, Import Wizard, CMC, CCM, Upgrade Management Tool, LCM, Crystal Reports, BO Explorer, OBIEE, SAP BI 7.0 RBDMS Oracle, MySQL, MS SQL Server 2008/2005/2000, MS Access 2003/2000/97, DB2, Toad, SQL Navigator, Tera Data, Hana. Languages Sql, Pl/Sql Operating Systems Windows 2000 Server/ 2003/ XP, Windows Vista, Windows NT/2000 PROFESSIONAL EXPERIENCE Fannie Mae, TX Mar 2024 Till Date Senior Tableau Consultant Responsibilities: Gathering and analyzing requirements, Prototypes, test plans, perform quality reviews, implementing and as well updating the solutions. Optimized data extraction, transformation, and loading (ETL) processes to ensure data accuracy and performance. Collaborated with cross-functional teams to gather requirements and deliver customized analytics solutions, resulting in improved decision-making capabilities. Led the migration project from OBIEE to Tableau, successfully converting 60 reports and dashboards, improving report performance and user experience. Implemented data quality checks and validation processes to ensure accuracy and reliability of data outputs. Well versed in handling user-based queries and access. Expertise in data preparation with experience in blending multiple data connections and creating multiple joins across same and various data sources. Designed and developed Tableau dashboards to replace legacy OBIEE reports, ensuring enhanced data visualization and interactivity. Conducted training sessions for end-users and technical teams on Tableau features and best practices, resulting in a smooth transition and high adoption rates. Design and Develop tableau interactive dashboards of Geo maps, Heat maps, Tree Maps, Packed bubbles, Histogram, box-and-whisker plot and customized maps etc to provide feasible solutions to Client. Developed Tableau workbooks to perform year over year, quarter over quarter, YTD, QTD and MTD type of analysis. Strong understanding of advanced Tableau features including calculated fields, parameters, table calculations, row- level security, joins, data blending, and dashboard actions. Page 3 Attending the project status meetings. Responsible to share the QA status and escalating any project issues and Risks to PM s Conducted training sessions and created documentation to support end-users in leveraging Tableau for their reporting needs. Implemented best practices for data visualization, including consistent design standards, user-friendly interfaces, and effective data storytelling techniques. Preparation of Issue/Defect logs document on the issues raised while doing migration and functional testing. Conducting QA Artifacts meetings with the Teams and analyzing the risks involved. Evaluate risks related to requirements implementation, testing processes, project communications, and training Environment: Tableau 2023.2, SQL Server, Alteryx, Oracle, Microsoft Excel, Big Data, PostgreSQL, AWS, JIRA Royal Bank of Canada (RBC), NJ Oct 2023 Feb 2024 Senior Tableau Lead Responsibilities: Developed and maintained Tableau dashboards and reports, providing critical insights to support decision-making across the organization. Worked closely with data analysts and business users to understand their needs and deliver tailored visualization solutions. Conducted data analysis and validation to ensure the accuracy and reliability of reports. Improved report performance by optimizing queries and using advanced Tableau features such as extracts, calculated fields, and parameters. Provided technical support and troubleshooting for Tableau users, resolving issues promptly to minimize downtime. Conducted training sessions and created documentation to support team members during the upgrade process. Gathering of business requirements, design document, planning, development, deployment and support of Tableau. Participate in design reviews and identify potential mitigation strategies for technical risks identified during the Unified Process phase reviews. Design and Develop tableau interactive dashboards of Geo/ Heat/Tree Maps, Packed bubbles, Histogram, and customized maps etc to provide feasible solutions to Client. Extensive experience in Extraction, Transformation, and Loading (ETL) data from various data sources into Data Warehouse using Alteryx (Data extraction, blending and Reporting). Generated Dashboards with Quick filters, Parameters and sets to handle views more efficiently. Strong understanding of advanced Tableau features including calculated fields, parameters, table calculations, row- level security, joins, data blending, and dashboard actions. Introduced Tableau to Client to produce different views of data visualizations and presenting dashboards on web and desktop platforms to End-user and help them make effective business decisions. To implement security levels on dashboards based on the business requirements. System testing, unit testing and UAT for deployed reports and dashboards in Alteryx workflows/Tableau UAT, QA and Production environments. Providing Estimation on Development and Testing of Alteryx workflows/Dashboards. To Perform root cause analysis for the challenging problems and to identify the work arounds. Evaluate risks related to requirements implementation, testing processes, project communications, and training Provide input into developing and modifying systems to meet client needs and develop business specifications to support these modifications. Page 4 Conduct 5+ levels of testing including functional, regression, user acceptance, integration and performance to verify the client s needs are met. Environment: Tableau 2023.2, Alteryx 2023.2, MySQL, SQL Server, Oracle, Microsoft Excel, PostgreSQL, Amazon Red Shift, Confluence, JIRA Credit Suisse, Morrisville, NC Nov 2020 Sep 2023 Senior Tableau/Power BI/SAP Business Objects Responsibilities: Interacted with Subject Matter Experts & End users and gathered business requirements and performed Gap Analysis. Developed and maintained Tableau dashboards and reports, providing critical insights to support decision-making across the organization. Developed and maintained Alteryx workflows for data extraction, transformation, and loading (ETL) processes, supporting various business functions. Worked with business analysts to identify data needs and create data models that aligned with organizational objectives. Improved existing workflows by optimizing performance and incorporating best practices, resulting in faster processing times. Integrated Alteryx workflows with Tableau dashboards to provide dynamic and interactive data visualizations. Expertise in data preparation with experience in blending multiple data connections and creating multiple joins across same and various data sources. Design and Develop tableau interactive dashboards of Geo maps, Heat maps, Tree Maps, Packed bubbles, Histogram, box-and-whisker plot and customized maps etc to provide feasible solutions to Client. Used multiple data sources to develop dashboards. Developed Tableau workbooks to perform year over year, quarter over quarter, YTD, QTD and MTD type of analysis. Strong understanding of advanced Tableau features including calculated fields, parameters, table calculations, row- level security, joins, data blending, and dashboard actions. Proficient in Full Life Cycle Development of Reporting Projects includes Requirement gathering/Analysis, Design, Development, Testing and Production Rollover. Standardized Power BI development by creating Design document, Dashboards and Reports checklist for functional testing. Used SQL intensively for ad hoc development, stored procedures, data validation and generating reports. To implement various security levels on dashboards based on the business requirements. Standardized Tableau Migration development by creating Design document, Dashboards and Reports checklist for functional testing. System testing, unit testing and UAT for deployed reports and dashboards in Tableau UAT, QA and Production environments. Providing Estimation on Development and Testing of Alteryx workflows/Dashboards. To Perform root cause analysis for the challenging problems and to identify the work arounds. Preparation of BRD and Technical design document for Tableau Dashboards. Correcting errors by making appropriate changes and rechecking the program to ensure that the desired results are produced. Evaluate risks related to requirements implementation, testing processes, project communications, and training. Page 5 Testing of dashboards which includes functional, regression, user acceptance, integration and performance to verify the client s needs are met. Environment: Tableau 2019.4, 2021.1.4, Alteryx, Power BI, SAP Business Objects, SQL Server, Oracle, Big Data, Amazon Red Shift, Snowflake, Microsoft Excel, Tableau Prep, PostgreSQL, AWS, Confluence, JIRA AcelRx Pharmaceuticals, Redwood City, CA Oct 2018 Oct 2020 Senior Tableau Developer Responsibilities: Worked closely with data analysts and business users to understand their needs and deliver tailored visualization solutions. Implemented predictive analytics models to forecast sales trends, providing valuable insights for strategic planning. Expertise in data preparation with experience in blending multiple data connections and creating multiple joins across same and various data sources. Researched data discrepancies and took corrective action hence improving performance and decision making. Participate in design reviews and identify potential mitigation strategies for technical risks identified during the Unified Process phase reviews. Gathering and analyzing of business and technical requirements To Design and Develop Tableau interactive dashboards based on the BRD and freeze it. Design and Develop tableau interactive dashboards of Geo maps, Heat maps, Tree Maps, Packed bubbles, Histogram, box-and-whisker plot and customized maps etc to provide feasible solutions to Client. Developed Tableau workbooks to perform year over year, quarter over quarter, YTD, QTD and MTD type of analysis. Generated Dashboards with Quick filters, Parameters and sets to handle views more efficiently. Strong understanding of advanced Tableau features including calculated fields, parameters, table calculations, row- level security, joins, data blending, and dashboard actions. Attending the project status meetings. Responsible to share the QA status and escalating any project issues and Risks to PM s Discussions on issues/risks and roadblocks while doing migration. Preparation of Issue/Defect logs document on the issues raised while doing migration and functional testing. Conducting QA Artifacts meetings with the Teams and analyzing the risks involved. Correcting errors by making appropriate changes and rechecking the program to ensure that the desired results are produced. Evaluate risks related to requirements implementation, testing processes, project communications, and training Provide input into developing and modifying systems to meet client needs and develop business specifications to support these modifications. Deployment of dashboards from DEV to QAT to PROD environments Environment: Tableau 10.3, 2019.1, 2020.2, SQL Server, Oracle, Microsoft Excel, Tableau Prep, PostgreSQL, AWS Portola Pharmaceuticals, South SanFrancisco, CA Aug 2017 Sep 2018 Senior Tableau Developer/Analyst Responsibilities: Interacted with business users and performed Gap Analysis of Client Requirements. Design and Develop tableau interactive dashboards of Geo maps, Heat maps, Tree Maps, Packed bubbles, Histogram, box-and-whisker plot and customized maps etc to provide feasible solutions to Client. Page 6 Standardized Tableau Migration development by creating Design document, Dashboards and Reports checklist for functional testing. Migration of Tableau content from 9.1 to 10.5 System testing, unit testing and UAT for deployed reports and dashboards in Tableau UAT, QA and Production environments. Implement security levels on interactive dashboards. Discussions on issues/risks and roadblocks while doing migration. Preparation of Issue/Defect logs document on the issues raised while doing migration and functional testing. Providing Estimation on Development and Testing of Dashboards. To Perform root cause analysis for the challenging problems and to identify the work arounds. Preparation of Technical design document for Tableau Dashboards. Conduct 5+ levels of testing including functional, regression, user acceptance, integration and performance to verify the client s needs are met. To Design and Develop Tableau dashboards based on the BRD and freeze it. Deployment of dashboards from DEV to QAT to PROD environments Environment: Tableau 9.1.1, 10.5, SQL Server, Microsoft Excel, Sales force, AWS, JIRA T-Mobile, Bellevue, WA July 2016 July 2017 Senior Tableau Consultant Responsibilities: Worked as a Tableau Consultant in Installing and configuring Tableau servers, along with configuring User groups, folder structures. Interacting with SME s to understand the business requirements and change requirements during the course of the project Involved in administering servers and implementing various security levels. Developed Tableau visualizations and dashboards using Tableau Desktop. Work closely with DBAs to create aggregate tables to support Tableau dashboards. 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 particular users using Row level security and User filters. Providing technical guidance and training the users on Tableau. Developed Tableau workbooks from multiple data sources using Data Blending. Developed Tableau workbooks to perform year over year, quarter over quarter, YTD, QTD and MTD type of analysis. Generated Dashboards with Quick filters, Parameters and sets to handle views more efficiently. Thorough analysis, unit testing and integrated testing with other applications of database objects before deployment to the production server. Strong understanding of advanced Tableau features including calculated fields, parameters, table calculations, row- level security, joins, data blending, and dashboard actions. Defined best practices for Tableau report development. Responsible for Developing Dashboard and preparing ad-Hoc Reporting. Use Tableau Desktop to analyze and obtain insights into large data sets. Developed various dashboards, used context filters, sets while dealing with huge volume of data. Page 7 Involved in System testing, unit testing and UAT for deployed reports and Tableau dashboards. Created Training manuals for the deployed User reports and conducted Status meetings with developers. Training end users on Tableau ad hoc reporting techniques. Preparing Technical design documents for Tableau Dashboards. Scheduling and Publishing of reports using Tableau Server. Tracking the project progress and working towards meeting the project specific deadlines consistently. Environment: Tableau 10.1, Teradata, SQL Server, Microsoft Excel, Toad, JIRA T-Mobile, Bellevue, WA Aug 2015 June 2016 Senior Tableau Consultant Project: Consolidated Subscriber Reporting Responsibilities: Interacted with business analysts in gathering, analyzing, and documenting business requirements, functional requirements and data specifications for Business Objects Universes and Reports and Tableau Dashboards. Good experience in Installation and configuration of Tableau Server and Desktop. Developed Tableau visualizations and dashboards using Tableau Desktop. Created Rich dashboards using Tableau Dashboard and prepared user stories to create compelling dashboards to deliver actionable insights. Strong understanding of advanced Tableau features including calculated fields, parameters, table calculations, row-level security, joins, data blending, and dashboard actions. To develop dashboards by using multiple data sources as per business requirements. Published Workbooks by creating user filters so that only appropriate teams can view it. Created Tableau Dashboards with interactive views, trends and drill downs along with user level security. Scheduling and Publishing of reports using Tableau Server and Info view. Interacted with business representatives for requirement analysis and to define business and functional requirements. Creation and maintenance of users, user groups, roles, assigning security on projects/sites and Automation of Repository Backup and Mail notifications. Create visually compelling and actionable interactive reports and dashboards and to manage ad hoc analytic requests from raw data through presentation quickly, efficiently and accurately. Extensively used hierarchies, attributes, measures, Calculations, Variables, Filters, Conditions, Sorting, Drill down, Parameters, Sets, Groups and Charts for creating Tableau reports. Demonstrate proficiency in analytics, trending, statistical analyses, interpretation of data and findings, and produce powerful visuals that present information in a meaningful and insightful way. Preparing Test Case document, BRD and Technical design documents for Dashboards. Optimizing the developing time and SQL Tuning to increase the query performance. Environment: Tableau 9.2, SAP BI 7.0, SAP Hana, Oracle 11g, SQL Server, JIRA Federal Home Loans Bank, Reston, VA Feb 2015 July 2015 Lead SAP BO Consultant Responsibilities: Worked as a BI and Tableau Consultant in Installing and configuring BO XI 4.1 servers, along with configuring User groups, folder structures. Interacting with SME s to understand the business requirements and change requirements during the course of the project. Page 8 Interacted with business representatives for requirement analysis and to define business and functional requirements.. Create visually compelling and actionable interactive reports and dashboards and to manage ad hoc analytic requests from raw data through presentation quickly, efficiently and accurately. Extensively used hierarchies, attributes, measures, Calculations, Variables, Filters, Conditions, Sorting, Drill down, Parameters, Sets, Groups and Charts for creating reports. Implemented Data level, Row Level and Column Level securities to restrict data. Involved in administering BO CMC servers and implementing various security levels. Migration of BO content from BOXI R3 to BOXI R4 using Upgrade Management Tool. Develop Universe, Dashboards and reports using SAP BO 4.1 and testing. Conversion of universes from .Unv to .Unx and expertise on multiple data source connections using IDT. Functional testing of BO content in all the environments. Provide Migration approach and Test plan. Delegating work to team members and mentoring them. Environment: :, SAP Business Objects XI 4.1, 3.1, Info view, WebI, CMC, CCM, Scheduling, Universe Designer, IDT, Upgrade Management Tool, Teradata, Oracle Collabera Solutions Pvt Ltd (Aka Brillio), Bangalore, India Mar 2008 Jan 2015 Lead Business Objects/Tableau Consultant Responsibilities: Worked as a Tableau Consultant in Installing and configuring Tableau servers, along with configuring User groups, folder structures. Interacting with SME s to understand the business requirements and change requirements during the course of the project. Involved in Installation and configuration of Tableau Server and Desktop. Interacted with business representatives for requirement analysis and to define business and functional requirements. Creation and maintenance of users, user groups, roles, assigning security on projects/sites and Automation of Repository Backup and Mail notifications. Using TABADMIN commands to change the default configuration changes and Creating Audit dashboards to get the details about the USER activities and Server details. Extensively used hierarchies, attributes, measures, Calculations, Variables, Filters, Conditions, Sorting, Drill down, Parameters, Sets, Groups and Charts for creating Tableau reports. Preparing Technical design documents for BO reports and dashboards. Scheduling and Publishing of dashboards using Tableau Server. Involved in Installation and configuration of BOXI 3.1 SP6 Servers and Client Tools. Interacted with business analysts in gathering, analyzing, and documenting business requirements, functional requirements and data specifications for Business Objects Universes and Reports. Analyzed the existing database and designed the Universes using Business Objects Designer Module for generating reports. Created Classes, Objects, Prompts, Pre-defined conditions, cascading List of Values, Custom Hierarchies for drill down. Traps, Aliases and Contexts used to resolve the loops in the Universe. Designed, developed, maintained and tested Universes for supporting adhoc queries. Implemented Aggregate aware function and set up aggregate navigation with objects derived from standalone tables within the universes. Page 9 Applied index aware functionality on non-indexed column objects to increase the performance by directing the report query to select the index fields from the database for faster retrieval of data. Created Cascading Prompts at universe level for dynamic selection of data within a hierarchy as per the user requirement. Built drill-down reports using Scope of Analysis and drill filters functionality within Business Objects Web Intelligence. Provide development approach and Test plan. Provide UAT and Production Support. Tracking the project progress and working towards meeting the project specific deadlines consistently. Environments: Business Objects 4.0/3.1/XIR2, Microsoft Sql Server 2008, Designer, Crystal Reports, Info View, WebI Rich Client, Import Wizard, Report Conversion Tool, SQL Developer, Tableau 7.1.x, 8.1.x, Vertica 5.1, Postgres SQL 9.1, BEx Queries, SAP BW 7, HANA HCL Technologies Pvt Ltd, Chennai, India Nov '06 - March '08 Business Objects Developer Responsibilities: Design, Develop, Maintain and testing of the Universe. Designed new Universes and modified the existing Universes based on the report requirements. Uses of Designer Module to implement Universe, Joining the Tables, Create Prompts and queries, parsing the Objects, apply Contexts and Alias Tables to remove cyclic dependencies. Created Classes, Sub Classes, Dimension Objects, Measure objects in multiple universes, checked the Integrity of the Universes and exported the Universes to Repository to make them available to users. Migration of all the 234 reports using Import Wizard in Business Objects XI R2. Conversion of Migrated Desktop Intelligence reports to WebI reports using Report Conversion Tool. Taking backup of all the servers with the help of Import Wizard using BIAR file. Prepared Unit test cases for the Development, Migration and Conversion Phases as per the functional requirements. Testing reports and create test case and test results document. Creating the Reports from Excel files using Business Objects through Personal data files Resolved Loops and Traps using the functionality of Aliases and Contexts. Environment: BOXI R2, BO 5.1.7, Universe Designer, Import Wizard, DeskI, WebI, Report Conversion Tool, Oracle 10g, SQL Developer, Windows XP/2003 server. Education Details Bachelor s in computers from Kakatiya University, Warangal, India Keywords: quality analyst business intelligence active directory information technology business works microsoft procedural language California New Jersey North Carolina Texas Virginia Washington