Satya Kanth

Linkedin: linkedin.com/in/satya-kanth

Tableau Public: https://public.tableau.com/app/profile/satya.kanth.achanta.tishan

Ph: 301-***-****

Email ID: adxbuw@r.postjobfree.com

Professional Summary:

Around 9+ years of experience in IT industry as BI Developer with Tableau and Data Analyst with strong background in Databases and Data warehousing concepts.

Expertise in Tableau 9.3/10.2/10.3/10.5,2018.1,2018.2/2019.1/2020.1/2021.1/2022.1 Tableau Server, Tableau cloud, Tableau Online, Tableau Mobile, Tableau Public, Tableau Reader

Designed several business dashboards using Tableau Desktop, Tableau Server, Tableau reader and Tableau Cloud

Worked on different Tableau versions (Tableau 9.3/10.2/10.3/10.5,2018.1,2018.2/2019.1/2020.1/2021.1/2022.1)

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.

Involved in requirement gathering/analysis, design, development, testing and production support of reporting and analysis projects.

Used JavaScript API to integrate Tableau visualizations into web application.

Extensively worked on setting up of Sites, Projects, groups, Users, Schedule refreshes & subscriptions.

Experienced Hyper in 10.5, the powerful Tableau’s new in-memory data engine technology, with up to 3X faster extract creation and up to 5X increase in query performance. With no more data migration.

Experienced with the Tableau 10.5 web authoring improvements to edit dashboard titles, axis settings and text zones, and format lines across entire workbook directly on browser.

Strong skills in SQL development.

Used Alteryx to Cleanse Data and minimized risk of manual data manipulation.

Design and Develop ETL workflows and datasets in Alteryx to be used by the BI reporting tool. ETL specific for creating datasets (to be used by Tableau Data Extract for BI)

Writing complex SQL queries with multiple joins to automate/manipulate these extracts in Alteryx.

Translate business logic from one system (Excel, SQL, etc) into Alteryx in a quick and accurate manner.

Develop re-useable processes that can be leveraged and standardized for multiple instances in Alteryx.

Expertise in using Alteryx Data Blending tool.

In Alteryx created workflow using different functions like Select, Tool Container, Record ID, Filter, Joins, Unique (U & D stream) etc.

Displaying visualizations from Tableau Server in web pages using JAVA Script API.

An in-depth grasp of SQL reporting, analytics and business intelligence

Great expertise in processing data and flowcharting techniques

Excellent understanding of database structures, principles, theories and practices.

Export visualizations to an image or PDF file using JAVA Script API.

Created tableau reports keeping in mind Dashboard Life Cycle fundamentals.

Published Tableau dashboard on Tableau Server or Tableau Online and embedded them into portal.

Prepare dashboards and reports for internal and external audiences using Microsoft Power BI, Microsoft Power apps and other business analytics tools.

Create data dashboards, graphs and visualizations in Power BI Dashboard publishing to the server.

Created Operational Dashboards to track information throughout the course of daily operations, understanding the status of production, machine utilizations, web traffic, or other critical systems

Combined multiple data sources using blending in Tableau to keep track of sensor data, operator inputs, and real-time systems all in one dashboard.

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

Using the command line tools and configuration utility on the primary server pushed the updates to the workers.

Experience in SQL reporting skills with the ability to create SQL views and write SQL queries.

Good experience with Data Wrangling (merging, grouping, concatenating etc.) using Python.

Using Tableau data Prep Builder prepared data to analyses using Tableau.

Published output file from Tableau data Prep Builder to Tableau server (Published Data Source).

Using published data source created different reports in Tableau.

Developed new or modified existing SQL datasets for statistical data analysis to support client reporting solutions and wrote multiple SQL queries.

Plan and implement the overall analytics and business intelligence strategy.

Excellent communication and interpersonal skill, decision making skills, presentation skills along with management and ability to interact with end-users, managers and technical personnel

Experienced in Analysis, Development, Design and Maintenance of Business Intelligence applications

Experienced in writing queries, stored procedures and functions using SQL .

Experienced in developing Data Mapping, Performance Tuning and Identifying Bottlenecks of sources, mappings, targets and sessions.

Strong understanding of Data Modeling in data warehouse environment such as star schema and snowflake schema.

Using Statistical files(.7bdat) created reports in Tableau.

Knowledge in creating Crystal Reports using crystal reports formulas, Grouping, Parameters, selection criteria to handle the customer’s requests from Tables, Views and command objects.

Quick Learner with excellent analytical and problem-solving skills with positive attitude towards new challenges.

Worked with Google Analytics in Masters.

Technical Skills:

Tableau Desktop 2022.1,2021.1,2020.1,2019.1,2018.3,10.5/10.4 /10.2/10.1/10.0/9.3, Tableau server, Tableau Online, Crystal Reports, Power BI, Google Analytics.

ETL Tools: Alteryx, Tableau Data Prep, Python (Jupyter Notebook)

Teradata, MS SQL Server, Oracle, HANA, SAS, SAP BW

Data Sources: MySQL, Hana, Teradata, Oracle, Amazon Redshift, Web Data Connector (Toad) etc.

Cloud Technologies, AWS.

Experiences:

Consumers Energy, MI May 2019 – Present

Tableau Developer/BI Developer

Design and develop consolidated reports to improve and streamline current processes, long term financial planning, monthly forecasting, performance metrics, and key performance indicators (KPI’s).

Worked closely with business stakeholders to gather the business requirements and understand the business terminology.

Created tableau reports keeping in mind Dashboard Life Cycle fundamentals.

Maintain and improve current financial reports and performance dashboards on various platforms.

Conduct initial in-depth analysis of the business.

Using Service Now created reports related to Tickets.

Did real time analysis using Service Now. Creating status of tickets.

Operational tracking using Service Now with Tableau.

Facilitate small working groups to standardize data and reports used in planning and forecasting.

Created reports using published Data sources.

Participate or lead special projects related to performance reporting and financial analysis.

Write quires that render efficient visualization across multiple data sources.

Prepare and review user stories and dashboards for multiple business groups at a time.

Developed interactive dashboards with quick filters, parameters and actions to handle views more efficiently and using context filters, sets while dealing with huge volume data.

Design and develop ETL workflows and datasets in Alteryx to be used by the BI reporting tool. ETL specific for creating datasets (to be used by Tableau Data Extract for BI)

Expertise in using Alteryx Data Blending tool.

Translate business logic from one system (Excel, SQL, etc) into Alteryx in a quick and accurate manner.

Worked on Maps using Map Services (Map box).

Created Polygon Maps in Tableau using Shape Files and Manually plotting Latitudes and Longitudes.

Displaying visualizations from Tableau Server in web pages using JAVA Script API.

Export visualizations to an image or PDF file using JAVA Script API.

Developing accurate and performance-oriented DAX calculations.

Designing effective dashboards with themes following UX guidelines set by customer and using latest features available in Power BI to guide readers through a compelling data-driven story.

Build dashboards, reports and cubes using SQL, MDX, DAX, Power BI.

Design and develop ETL Processes that will transform a variety of raw data, flat files.

Integrate different data sources and create data sets within Power BI.

Good experience with Data Wrangling (merging, grouping, concatenating etc.) using Python (Panda’s library), Tableau, Power BI.

Merging, joining, and transforming huge hunks of data with a single Python statement.

Used advanced SQL scripting writing custom quires using different functions like UNION, CASE, JOINS and DATE functions etc.

Using Tableau 2022.1,2021.1 and Power BI.

Bayer Corporation, Whippany NJ Oct 2018 – May 2019

BI Developer

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

Performed End to end testing using Teradata Queries in Teradata.

Created dashboard for key performance indicators (KPI’s).

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

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

Tested reports and uploaded tableau dashboards on to server and provided production support for tableau users.

Upgraded tableau 10.5 to tableau 2018.1 And gathered requirements, analyzed from raw data.

Use the Tableau JavaScript API to integrate Tableau visualizations into web application.

Have a good knowledge about Improved workbook version compatibility.

Created reports and implemented latest features like Viz in Tooltip, Nested projects.

Ability to work quickly and under tight delivery deadlines with focus on details.

Creating Capping Calculator for Bayer products for this year.

Created Contract Calculator, Contract Performance dashboard.

Women health care products Daily Sales Dashboard and applied User Security.

Published reports to production and test servers and assigned users to the reports and subscribed them.

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.

Connect to Teradata directly, created the dimensions, hierarchies, and levels on Tableau desktop.

Plan and implement the overall analytics and business intelligence strategy.

Created and documented Standard Operating Procedures (SOP) for Capping Calculator.

Plan and implement the overall analytics and business intelligence strategy.

Used Alteryx to Cleanse Data and minimized risk of manual data manipulation.

In Alteryx created workflow using different functions like Select, Tool Container, Record ID, Filter, Joins, Unique (U & D stream) etc.

Using Xtract Universal connected SAP Data (SAP BW), SPSS file(.sav) created workflow in Alteryx and used that output to create Tableau reports.

Morgan Stanley, NYC Jan 2018 – Oct 2018

Tableau Developer

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.

Analyzed and used Tableau Server system requirements based on many factors, including the number of users and target workload.

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 financial department of Morgan Stanley.

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.

Tested reports and uploaded tableau dashboards on to server and provided production support for tableau users and assisting users in creating and modifying worksheets and data visualization dashboards.

Defined and created procedures to install Tableau desktop in silent mode and best practices for Tableau report development.

Created Data Integrator mappings to load the data warehouse, the mappings involved extensive use of simple and complex transformations like Key Generator, SQL Query Transform, Table Comparison, Case, Validation, Merge, lookup etc. in Data flows.

Created Metrics, Analytics, Rules, Goals for the Corporate Dashboard.

Develop and maintain reporting and analytical tools, including Business Objects.

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 with business owners to identify information needs and develop reporting; primary partners include the management team, finance & accounting, marketing, online retail, merchandising and operations.

GE Healthcare, Boston Nov 2016 – Dec 2017

Tableau Developer

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.

Used various ETL tools to extract data into Tableau Desktop and data wrangling using SSIS in data preparation phase.

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.

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 read 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 various locations.

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.

Amazon Dec 2015 – June 2016

Data Analyst

Managing customer concerns and making dashboards using reports with the objective of maintaining positive customer relationships with an organization.

Build data pipeline to extract data from multiple sources and transformed data using pandas to enable automated customized reporting system for retail and corporate customers.

Interact directly with customers to listen to concerns, resolve problems, and recommend products and services according to the needs of everyone.

Critical role in delivering timely, accurate and professional customer service to Amazon customers, helping solve problems such as: connecting an Echo to a Fire TV.

Recommends potential products or services to management by collecting customer information and analyzing customer needs.

Prepares product reports by collecting and analyzing customer information.

Well-versed with all stages of Software Development Life Cycle (SDLC) and Software Testing Life Cycle (STLC).

Proactively analysed data using SQL, Python, R and Microsoft Excel to answer key questions from clients to monitor product sales.

Reviewed complex SQL queries and edited inner, left, and right joins in Tableau Desktop by connecting live/dynamic and static datasets.

Support the SQL analysis by implementing exploratory data analysis.

WIPRO Technologies INDIA Mar 2012 – Nov 2015

Senior Associate (Data Analyst)

Liaised with project management and development teams to identify and implement reporting, control, and automation

Mentored a team of 12-15 associates on generating solid internal sales leads.

Reduced Bank fees by 18% by switching some vendor payments from check to ACH and removing unnecessary bank services.

Writing complex SQL queries for checking the counts and for validating the data at field level (Oracle, DB2, Teradata).

Plan, design, and implement application database code objects, such as stored procedures and views.

Build and maintain SQL scripts, indexes, and complex queries for data analysis and extraction.

Monitored and provided front-line support of daily processes.

Helped create process logging and new monitoring tools, integrity reports, and mapping tools.

Develop new processes to facilitate import and normalization, including data file for counterparties.

Work with business stakeholders, application developers, and production teams and across functional units to identify business needs and discuss solution options.

Provide database coding to support business applications using Sybase T-SQL.

Perform quality assurance and testing of SQL server environment.

Masters in Information Systems Aug 2016 – May 2018

University of Mary Hardin Baylor,Texas

Contact this candidate