Data Analyst Tableau Server

Srikanth, Cheguri

Professional Summary

** ***** ** ********** ** IT industry as Data Analyst, BI Developer with Tableau and Business Objects with strong background in Databases and Data warehousing concepts.

Worked on several interactive dashboards with Filtering, highlighting, ability to combine multiple data sources, fast creation by a business user, easy sharing with support for existing security using several visual analysis best practices

Setup and configuration of Tableau server 10.0/9.2 in various environments and used Tableau CMD and Tableau admin tools to configure the server according to best practices.

Worked on several interactive dashboards with Filtering, highlighting, ability to combine multiple data sources, fast creation by a business user, easy sharing with support for existing security using several visual analysis best practices

Used ETL process to Extract, Transform and Load the data into stage area and data warehouse.

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.

Designed, developed and implemented in R, RStudio Tableau Business Intelligence reports.

Create basic calculations including string manipulation, basic arithmetic calculations, custom aggregations and Experience in MS Access Support, Hadoop, Big Data.

Experience in analytical Database Design and Data Modelling skills using MS Visio and ERWIN.

Experience in creating different visualizations using Bars, Lines, and Pies, Maps, Scatter plots, Gantts,

Bubbles, Histograms, Bullets, Heat maps and Highlight tables.

Involved in Trouble Shooting, Performance tuning of reports and resolving issues within Tableau Server

and Tableau desktop report

Data Store concepts,

data marts and OLAP-Online Analytical Processing technologies.

Expert knowledge of Data Warehousing methodologies and concepts, including star schemas, snowflakes,

ETL processes, dimensional modelling and reporting tools.

Highly proficient in the use of T-SQL for developing complex stored procedures, triggers, tables, user

functions, user profiles, relational database models and data integrity, SQL joins and query writing.

Experienced in developing and modifying cubes using SSAS and transform into the pivot table.

Experienced in writing Parameterized Queries for generating Tabular reports, Formatting report layout,

Sub reports using Global Variables, Expressions, Functions, Sorting the data, Defining Data Source and

subtotals for the reports using SSRS [ ]

Used Tableau’s flexibility to build a tabbed application with wide range of options like quick filters, calculated fields, dynamic interaction, flexible ad-hoc capability in various functional areas like finance, sales, marketing and HR

Tableau and Arcadia

Power BI (get fast in Tableau/Power BI resources).

Enterprise Data Warehouse (EDW).

JIRA

Used SAML for configuration of Tableau Server SSO supplementing Kerberos authentication on the side

Used Kerberos for user authentication thru Active directory (Win AD).

Used Sign in Method using the REST API for successful sign in operations

Setup of SSO between Tableau portal and Oracle.

Used Kerberos for user authentication thru Active directory (Win AD).

Performance tuning for the Tableau Visualizations and Tableau server for more than 150 concurrent users.

Improved Reports performance in tableau using extracts and context filters.

Published Workbooks by creating User filters and sites (User groups, access) so that only appropriate teams can view it.

Created calculated fields to interact with parameters dynamically to visualize the data on the fly.

Used the Tableau Online sync application to schedule automatic refresh tasks for extracts of data and to maintain on local network.

Setup security profiles for various user groups and users using Tab admin and Tabcmd Tools.

Created various User groups by assigning row and column level security at application level, folder level and user level.

Configured the distributed Tableau Server environment for real-time replication and failover support.

involved in loading data from Hive and imported to R for data analysis and visualization

Involved in importing data from Hive to R for data exploration and data cleaning for developing predictive models as per requirements.

Created a form and integrate it with the client's everyday

Solved problems using a combination of JavaScript, JSON, and JQUER

Professional Experience

Sr. Business Intelligence and Data Service Aug 2023 – Present

Salesforce - Remote – Madison/WI

Experience in Data Analysis and Visualization Skilled in transforming raw data into meaningful insights through clear and impactful visualizations.

Worked on Advanced Data Modeling Proficient in building and optimizing data models to support large-scale Tableau deployments.

worked on Custom SQL Queries Adept at writing complex SQL queries for data extraction, manipulation, and analysis.

Cross-functional Collaboration Collaborated with various departments (such as IT, marketing, and sales) to understand their data visualization needs and deliver tailored solutions.

Performance Optimization Expert in optimizing Tableau dashboard performance for faster data retrieval and efficient user experience.

Advanced proficiency in conceptual, logical, and physical data modeling, ensuring comprehensive data architecture.

Expertise in using ERWIN data modeling software to develop robust data models aligning with business intelligence strategies.

Extensive experience in designing and developing data warehouses, optimizing for both performance and scalability.

Profound knowledge of Oracle PL/SQL for advanced database management and manipulation.

Developed intricate conceptual, logical, and physical data models for business intelligence projects, considering all facets of data granularity and integrity.

Analyzed and refined logical and physical database models to ensure compliance with industry standards and business needs.

Led cross-functional teams in translating business requirements into sophisticated data model designs, fostering collaboration between business customers, IT staff, and stakeholders.

Spearheaded data warehousing initiatives, overseeing the system's reliability and the accuracy of information loaded into databases.

Translated complex data modeling concepts (such as facts, dimensions, "snowflaking") into understandable language for non-technical stakeholders, enhancing cross-departmental communication.

Advised on data maintenance strategies, focusing on managing slowly changing dimensions and data archival planning to optimize storage and retrieval.

Collaborated with the Enterprise Architecture team to ensure data model designs received approval and aligned with organizational standards.

Coordinated with Database Administrators (DBAs) to facilitate the creation of tables and other database objects, ensuring efficient data storage and access.

Designed data models that are optimized for both back-end storage efficiency and front-end user query performance.

Conducted thorough analysis and testing on relational databases to troubleshoot data load failures and resolve data retrieval issues, ensuring data accuracy and availability.

Leveraged Tableau for dynamic data visualization and reporting, transforming complex data sets into actionable business insights, and enhancing decision-making processes.Spearheaded the integration of the Tableau platform with Pega, enabling advanced analytics and streamlined business operations.

Customized Tableau dashboards and reports, providing tailored analytics solutions to meet diverse departmental needs.

Conducted training sessions for staff on leveraging Tableau features, enhancing team productivity and data-driven decision making.

Monitored and optimized Tableau server performance, ensuring high availability and reliability of the analytics platform.

Updating daily Dashboard by refreshing extract files

Sr.BI Engineer Data Analyst Tableau Oct 2020 – Aug 2023

Wisconsin Department of Health Services – Madison WI

This position will primarily be responsible for supporting DHS’ Tableau implementation by providing overall Data Analyst, SQl,AWS Python in Cloud maintaining security, reporting, and responding to customer’s requests related to DHS’ COVID-19 response. Additionally, this role role in developing and maintaining databases that are scalable, secure, and efficient. They design database applications and interfaces to ensure seamless access to the generic database structure. They possess in-depth knowledge of database technologies, programming, design, and system analysis skills. They understand professional concepts, standards, regulations, and operating standards, and make decisions regarding their work approach and priorities. Their work is guided by precedent, documented procedures, and professional standards, with some interpretation required.

Functional experience with database software, such as AWS Athena, Redshift, MySQL

Significant attention to detail and an ability to quickly spot and fix problems

Experience working in a team setting and desire to take leadership roles

build data pipelines and integrate data from external sources (EMR systems, flat files, JSON/API etc) into our data lake (AWS S3).

Utilized SQL and Python to apply engineering, reporting, and visualization expertise to solve complex business problems.

Developed scalable tools to optimize business operations and automate repetitive tasks.

Created scalable systems to extend reporting capabilities, enhance ad hoc analysis, and promote data-driven decision-making across all business levels.

Handled large, complex datasets efficiently, solving challenging data transformation problems using advanced analytical methods.

Experienced in designing and implementing efficient ETL processes using SQL Server Integration Services (SSIS) for data mart population and updates.

Skilled in collaborating with stakeholders to understand reporting and analytics needs, ensuring alignment with business objectives.

Proficient in developing and maintaining robust data models, ensuring data integrity and consistency across the Enterprise Data Warehouse (EDW).

Expertise in creating and optimizing SQL queries for effective data extraction, transformation, and loading processes.

Adept in designing, developing, and enhancing reports and dashboards, providing meaningful insights to end-users.

Experienced in performing data analysis to identify trends, patterns, and anomalies, contributing valuable insights for informed decision-making.

Collaborative work with IT teams to maintain the health and performance of the data warehouse.

Engaged in partnerships with business analysts and data scientists to foster data-driven decision-making processes.Will utilize Excel, Access, Power Query, Reporting Workbench, Datawatch Monarch, Tableau, Crystal Reports, Clarity, SQL and/or other programming, database and data visualization applications.

Expert in using Microsoft Excel: Pivot Tables, Conditional Formatting, Sorting and Filtering, Basic Math, Mixed Type Charts/Graphs, Lookup Excel Functions, Array Formulas, Naming Fields,, Data Analysis Excel Tools, and Microsoft Power Add-In’s.

Performs research and data analysis for events.

Analyzes and defines problems and researches possible solutions that afford maximum probability for success and Acted as a communication bridge between internal and external clients to understand business needs, providing effective analytical solutions.

Utilized leading-edge tools and languages, including Python, R, and SQL to design and validate predictive models.

Collaborated in an agile environment, partnering with stakeholders and engineers to bring analytical rigor and statistical methods.

Created comprehensive reports and presented information using various data visualization tools and techniques.

Proposed strategic solutions to complex business challenges, contributing positively to the overall growth of the company.

Managed data integrity, data storage efficiency, and overall data ecosystem efficiency, ensuring streamlined operations. Results oriented with an ability to work in team and individual contributor work environments.

Involved tableau server creating architecture, design, and development skills.

Performed data analysis on daily, weekly, and monthly scheduled refresh of data based on that

business or system change to ensure that the published dashboards are displaying accurate and upto-date information.

Driving analysis of financial and operational performance data through modeling and predictive analytics to identify key insights and opportunities for improving the end-to-end transportation network.

Developing detailed annual and 3-year freight spend forecasts as part of contributions to the North American Finance team.

Identified and resolved discrepancies in the migrated data, ensuring full data integrity in the nCino Salesforce system.

Collaborated with system developers to design and implement data validation scripts, further ensuring data In-depth knowledge of various database technologies (e.g., SQL Server, Oracle)

Proficient in SQL programming and query optimization Enterprise Data Warehouse (EDW).

Solid understanding of system analysis principles

Excellent communication and teamwork abilities

Detail-oriented with strong organizational skills Developing and maintaining a centralized hub for Transportation-related data consumption and reporting layers to enhance the accessibility and visibility of key data.

Sr. BI Engineer /Tableau/Python March 2019 – Oct 2020

WellCare Health Plans – Tampa FL

Collects, analyzes, and shares data to help business teams drive improvement in key business metrics, customer experience, and business results.

Works with the BI Analyst during implementation, gathering additional information when needed and keeping the business Led the initiative for conversion/data initializations from various CRM platforms into nCino Salesforce, ensuring smooth and secure data transition.

Using Tableau Desktop 2020.2.4 Version

Implements data structures using best practices in data modeling, processes, and technologies.

Performs data conversions, imports and exports of data within and between internal and external software systems.

Implements tools and frameworks for automating report generation, identification of data-quality issues, and data governance.

Demonstrated experience in designing and optimizing data models for performance and scalability.

Proficient in report development and maintenance using tools like Power BI and Tableau.

Excellent analytical and problem-solving abilities with a focus on detail.

Effective communicator, capable of working with cross-functional teams and stakeholders.

Flexible and adaptable to rapidly changing priorities and deadlines in a dynamic work environment. Experience in creating various views in Tableau like bubble, donut, tree map, bar chart etc.

Also Developed custom USA Geo Coding map & with help of WMS Servers, illustrating the potential

revenue change across different geographic markets.

Created Monthly PTD analysis Dashboard to monitor the application status based on specific Doses .

Designed Whole sale inventory Based on budget and LE.

Developed different types of Tableau Reports like Cross tab.

Creation and modification of some of the existing reports and dashboards.

Utilizing capabilities of Tableau such as Forecasting, Table Calculations, Basic Arithmetic

Enterprise Data Warehouse (EDW).Daily use of complex Excel formulas and pivot tables to manipulate large datasets

Taking existing data from a separate document and inputting it into Excel

Created External filter, internal filter, and Context filter to improve performance.

Used Data Blending, groups, combine fields, calculated fields, and aggregated fields and spotlighting to compare and analyze Collaborated with cross-functional teams to develop and implement data migration strategies, in CRM systems to nCino Salesforce

Used dimension on Page shelf for a detailed analysis of the view by members of the dimension.

experience in data conversion and initialization from CRM systems to nCino Salesforce. Demonstrated proficiency in managing complex data migration projects, optimizing CRM processes, and enhancing system performance. Adept at collaborating with cross-functional teams to achieve project goals

Published Workbooks and Dashboards to the Tableau server.

Designed and setup user security for the entire landscape to facilitate Windows AD login.

Used Tableau Cmd for various Dashboard migrations from one environment to another.

Setup of Distributed Server environments for optimum load balancing.

Business Analyst/Tableau Nov 2018 – Feb 2019

Data Transformation

Fannie Mae - Washington, DC

Gathers business requirements from different Department in single family & Creating Data Structure According in Spread Sheets & Creating Scripts in Oracle Database.

Experienced working with unstructured data creating workflows in Alteryx software with documentation and implementation of the processed data.

Worked on visualization using technology such as R, RStudio and QlikView

Design, develop, and deliver interactive data visualizations using Tableau desktop and Tableau server and also design, develop, and deliver reports using other business intelligence tools

Designed and Optimized Data Connections, Data Extracts, Schedules for Background Tasks and Incremental Refresh for the weekly and monthly dashboard reports on Tableau Server.

Successful and rapid conversion of Legacy BO XI 3.1 Reports to BI 4.1 SP3

Collaborated with cross-functional teams to develop and implement data migration strategies, in CRM systems to nCino Salesforce

Enhanced report performances by tuning the derived tables and join structures

Provided technical guidance and solutions to peer technical teams

Created Dashboards for tracking live data which are highly optimized for faster runtime

Advised top management on Appropriate Employee Corrective actions in Alteryx

Created organizational flow charts in Single Family score cards to path reports

Working with Mortgage Loan payment processing, Accounting and reporting etc

Worked with senior-level management to create fair and consistent HR policies and procedures.

Used to be Maintains security permission structure in Tableau server and in Bi Tools

Worked on Data consulting Activities & in client support

Conducts other data analysis and data consulting activities as required to support client delivery.

Create dashboards and reports within Tableau used Design and implement proof of concept solutions and create advanced BI visualizations

Sr. Data Analyst III/Tableau Developer Jan 2018 – Oct 2018

Analysis & Process Transform

Capital One - Richmond, VA

Creating tables in database in Aws Redshift Cloud by using SQl Workbench, and also objects like tables, views, procedures, triggers, and functions.

Writing python script to Automate the data from Teradata to cloud Environment.

Configure the VPC, EC2 instances, S3 buckets, RDS (MySQL)

Configuration of AWS in built SNS/SQS setup for job scheduling

Create required shell or python scripts for data push from Tableau/Teradata to S3

Developed Tableau visualizations and dashboards using Tableau Desktop.

Experience in SQL development with understanding of relational and multi-dimensional design.

I used work Hadoop Table,Impala and HVE update the table and create Tables, Insert, Delete etc

Worked on Smart forms and Sap Scripts. Module pool Programming.

Participate in client meetings to understand project definitions and offer design reviews.

We Use agile methodology for Project related issues and Monitor according to that. I used to slove according to that issues immediately.

Expert in optimization and query performance tuning in Netezza using various techniques involving distribution analysis, data-type analysis, zonemaps, CBTs, configuration parameters etc.

Expertise in working with different databases like Netezza, Teradata, MS

SQL Server 2008 R2, Oracle 10g/9i/8i and tools like Aginity, Toad, SQL

Navigator, Teradata SQL Assistant

I am working on opens workbook in Tableau Desktop 10.7, refreshes the. tde extract, publishes to Tableau Server 10.7

Working on Tableau Desktop 10.7 and Tableau Server 10.7 can read. tde and. hyper extracts, so you can open and view workbooks with extracts in either format.

Enterprise Data Warehouse (EDW) - Build and maintain SQL scripts, indexes, and complex queries for data analysis and extraction.

Sr. Data Analyst/Tableau Developer Nov 2016 - Dec 2017

Business Object Developer

Lincoln Financial Group, Radnor, PA

Involved in creating database objects like tables, views, procedures, triggers, and functions.

By using T-SQL to provide definition, structure and to maintain data efficiently. Create Oracle SQLs/Pl SQL procedures and queries.

Experience on the health information technology (HIT), Medicaid reporting and creating the Dashboards

Ability to write complex queries and use MS Excel for executing comparisons. CMDB knowledge (HP/Service Now)

Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.

Extensive GAP analysis in the project.

Design, build and run Tableau Dashboards

Assisted business analysts with requirements gathering and in design and development of ETL processes.

Develop documentation as required and implements standards as well as complex modeling and enhance the capacity and performance of the Tableau environments.

Worked on the Medicaid and Medical Care

Developed Tableau workbooks from multiple data sources using Data Blending.

Tableau migration and scheduling.

Validated the schema and found the errors present in the ETL and also took part in giving the recommendations to fix the problem.

Developed Tableau visualizations and dashboards using Tableau Desktop.

Experience in SQL development with understanding of relational and multi-dimensional design.

In Server provide production support for Tableau users. Troubleshooting issues and engages with Tableau Support if necessary.

Having knowledge on DVO in Informatica

Participate in client meetings to understand project definitions and offer design reviews

In source data and give input to help DBAs structure the best SQL and Excel data sources

In Tableau desktop server schedule exports of your views (PDF, image, CSV) and distribute them via email through a simple web interface.

I am working on opens workbook in Tableau Desktop 10.5, refreshes the. tde extract, publishes to Tableau Server 10.5

Working on Tableau Desktop 10.5 and Tableau Server 10.5 can read. tde and .hyper extracts, so you can open and view workbooks with extracts in either format.

Tableau Developer March,2016 – Oct 2016

Comcast, PHL, PA

Responsibilities:

Experience in designing and development of Tableau visualization solutions and Created Business requirement documents and plans for creating dashboards.

Setup and configuration of Tableau server 9.3 in various environments and used Tableau CMD and Tableau admin tools to configure the server according to best practices.

Hands on experience with Tableau 10.0

Used the multiple data sources joins in Tableau 10.0

Build from the ground up reliable infrastructure services in AWS to deliver highly scalable services.

Configure the VPC, EC2 instances, S3 buckets, RDS (MySQL)

Configuration of AWS in built SNS/SQS setup for job scheduling

Create required shell or python scripts for data push from Tableau/Teradata to S3

Provide the user access to team for AWS console and SSH connectivity to the Edgenode

Used Tableau to provide the standard user interfaces for visualizing and filtering date/time data, and Hive will construct the Map/Reduce jobs necessary to parse the string data as date/time to satisfy the queries Tableau generates.

Used Hive to have native support for date/time as a data type, but it does have very rich support for operating on date/time data stored within strings, changed the data type of a string field to Date or Date/Time to work with pure date or date/time data stored in strings.

Worked with Microsoft Power BI for visualizing and filtering date/time data, and Hive will construct the Map/Reduce jobs necessary to parse the string data as date/time to satisfy the queries Tableau generates.

Used Hive and Hadoop configuration variables for a given connection from Tableau to tune performance characteristics

Used additional UDFs which Tableau does not yet expose as formulas for use in calculated fields in HIVE.

Published Workbooks and Dashboards to the Tableau server.

Designed and setup user security for the entire landscape to facilitate Windows AD login.

Used Tableau Cmd for various Dashboard migrations from one environment to another.

Setup of Distributed Server environments for optimum load balancing.

Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.

Creating New Schedule's and checking the task's daily on the server.

Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.

Tableau Admin Oct,2015 – March2016

Kimberly Clark, Charlotte, NC

Responsibilities:

Upgraded tableau 7.0 to tableau 8.0. And gathered requirements, analyzed from raw data.

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.

Created customized reports using various chart types like, text tables, bar, pie, tree maps, heat maps, line charts, pivot tables, combination charts in excel and tableau.

Worked on motion chart, Bubble chart, Drill down analysis using tableau desktop for Amazon.

Involved in created stored procedures, views, and custom sql queries to import data from sql server to tableau.

Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps.

Worked on Business Intelligence standardization to create database layers with user friendly views in Teradata that can be used for development of various Tableau reports/ dashboards.

Working on generating various dashboards in Tableau server using various sources such as Teradata Created Data

Got involved in designing the Data model for the Data warehouse and for different Data marts

Performed End to end testing using SQL Queries in Oracle.

Prepared many other reports by using master details, cross-tabs, slice and dice and drill mode as per the requirement of the end-uses

Work experience in advanced Xcelsius concepts like, what if analysis, dynamic visibility, narratives, interactive charts, hierarchies and experience in connecting Xcelsius/ QaaWS, live office

Work with business owners to identify information needs and develop reporting; primary partners include the management team, finance & accounting, marketing, online retail, merchandising and operations

Tableau Developer May,2015 – Sep,2015

NC dot, Raleigh, NC

Responsibilities:

Deep experience with the design and development of Tableau visualization solutions.

Created extracts, published data sources to tableau server, refreshed extract in Tableau server from Tableau Desktop.

Importing data from HDFS to Hive using Sqoop The connector then gets the closing price for the specified company for one year back from today's date.

Created External filter, internal filter and Context filter to improve performance.

Used Data Blending, groups, combine fields, calculated fields, and aggregated fields and spotlighting to compare and analyze data in different perspectives.

Used data connectors that are already available in Tableau, to create web data connector (WDC) that reads data from virtually any site that publishes data in JSON, XML, or HTML.

Used Tableau and Google Analytics to analyze web traffic and make business decisions on the traffic coming from different locations.

Configuring and creating reports based of Hive.

Big Data Ecosystems: HDFS, MapReduce, Hive, Pig, Sqoop

Used the Web Data Connector JavaScript library for enabling the app to interface with the Tableau API

Used dimension on Page shelf for a detailed analysis of the view by members of the dimension.

Created parameters and quick filters. Created sets to display top products based on their sale.

Created Actions in Worksheets and Dashboards for interactivity and to compare data against different views.

Created Dashboards with interactive views, trends and drill downs.

Published Workbooks and Dashboards to the Tableau server.

Combined visualizations into Interactive Dashboards and publish them to the web.

Created groups and users in Tableau server

Used commands in Tab cmd. and Tab admin utility tool and migrated Workbooks and Dashboards

Environment: Oracle 11g, Python, Chef, Puppet, Kickstart, Cron, Perl, Tableau Desktop 8.2, Tableau server, Oracle SQL developer, SQL Server 2012, Oracle 10g, PL/SQL, T-SQL,MS Access, Windows 2007 server, Teradata, MS Office 2007

Data analyst Oct,2010 – Nov,2013

Intergraph Hyderabad, India

Responsibilities

Installed and configured Oracle 10g/11g RAC databases as per company standards.

Installation, Configuration, upgradation and administration of Sun Solaris, Linux.

Implemented and managed Oracle 10g RAC and 11g RAC databases on UNIX, LINUX and Windows platforms.

Manipulating, cleansing & processing data using Excel, Access and SQL. Responsible for loading, extracting and validation of client data.

Liaising with end-users and 3rd

Contact this candidate