← В ленту
Регистрация: 03.05.2024

Adi Madan

IT
middle
Специализация: Tableau Developer

Скиллы

Tableau
Tableau Prep
PowerBI
SQL
PL/SQL
Python
R
Java
SSRS
SSIS
SSAS
MS SQL Server
PL/SQL
SQL
MySQL
Snowflake
Python Pandas
Pyspark
Microsoft Office
Google Suite
AWS S3
AWS RDS
MS-DOS
WinNT/2000
UNIX MVS/ESA
OS/390 Mainframe
MSWINDOWS NT
IBM 3090
ES/9000
IBM PCs

Опыт работы

Tableau Developer
с 10.2023 - По настоящий момент |Excellerate Education
Tableau Desktop 2024.1, 2023.3, Tableau Public 2023.2, MySQL, AWS
● Design interactive dashboards in Tableau Desktop and published them to Tableau Server. ● Developed storytelling dashboards in Tableau Desktop and published them on Tableau Server, allowing end users to understand the data on the fly using quick filters for on demand needed information. ● Used scattered plots, bar graphs, and stack bars to create Tableau dashboards. ● Utilized Tableau desktop to create motion charts, bubble charts, and drill-down analyses. ● Generated Dashboards with Quick filters, Parameters, and sets to handle views more efficiently. ● Published Workbooks by creating user filters so that only appropriate teams can view them. ● Coordination for Integration testing, UAT, UTC, and resolving the support issues. ● Created reports using the databases AWS and MySQL data. ● Involving in writing complex SQL queries to verify data from Source to Target Performed data validation testing writing SQL queries. ● Accountable for creating Admissions and Admin Reports and Dashboards. Implemented the insights from these dashboards to help the Admissions team to plan the set of application changes to improve applicant tracking and improved admissions process.
Tableau Developer
01.2023 - 05.2023 |Wolters Kluwer Inc.
Tableau 2023.1, Excel, Google Suite, Microsoft Office Suite
● Create and publish interactive dashboards to Tableau Server using Tableau. ● Worked on motion chart, Bubble chart, and drill-down analysis using Tableau. ● Designed and deployed narrative dashboards from Tableau Desktop to Tableau Server, enabling end users to dynamically comprehend the data by employing expedient filters to retrieve information as required. ● Created Tableau dashboards using stack bars, bar graphs, scattered plots, and geographical maps. ● Worked on motion chart, Bubble chart, and drill-down analysis using Tableau desktop. ● Generated Dashboards with Quick filters, Parameters, and sets to handle views more efficiently. ● Coordination for Integration testing, UAT, UTC, and resolving the support issues. ● Identified and implemented 23 KPIs to optimize IT operations by gathering requirements, interviewing UIC’s IT Team representatives, and conducting market research. ● Designed new KPIs for every focus area in IT operations, resulting in 30% efficiency improvements and customer satisfaction. ● Provided insights to stakeholders associated with trends in incident resolve times helping drive measures like automated messages to improve Mean Time to Resolve (MTTR).
Data Analyst
10.2022 - 12.2022 |Digital Factory
AWS-S3, Python, PySpark, Tableau 2022.2
● Loaded and cleaned datasets from AWS S3 using Spark ETL pipelines. ● Using PySpark ETL resulted in efficient extractions of data by roughly 30%. ● Visualized customer visiting patterns like frequency of visits, and duration of stay in the store to optimize marketing efforts of targeting different customer groups using pandas, and matplotlib in Python. ● Design interactive dashboards in Tableau and published them to Tableau Server. ● Worked on motion chart, Bubble chart, and drill-down analysis using Tableau. ● Developed storytelling dashboards in Tableau Desktop and published them on Tableau Server, allowing end users to understand the data on the fly using quick filters for ondemand needed information. ● Created Tableau dashboards using stack bars, bar graphs, scattered plots, and geographical maps. ● Worked on motion chart, Bubble chart, and drill-down analysis using Tableau desktop. ● Produced dashboards incorporating quick filters, parameters, and sets to enhance the efficiency of view management. ● Developed statistical models like Decision Trees, and Random Forests in Python for predicting customers visiting the most stores frequently visited to boost customer offers. ● Built DBSCAN, knn-based clustering to help realize the various segments of customers based on their likelihood of visiting certain stores and their purchase activity. ● Increased customer engagement by 10% in the 4th quarter and enabled effective sales campaigns to notify customers about discount deals, and offers when they entered the store with time series analysis.
Tableau Developer
07.2018 - 07.2021 |Larsen and Toubro Infotech
Tableau Desktop 19.1, Tableau Desktop 18.1, SQL Server Reporting (SSRS), SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), Power Shell
● Boosted client operations with 99.9% uptime by effectively maintaining, and troubleshooting underlying IT infrastructure and implementing performance optimization strategies for databases. ● Create and publish interactive dashboards to Tableau Server using Tableau. ● Worked on motion chart, Bubble chart, and drill-down analysis using Tableau. ● Developed storytelling dashboards in Tableau Desktop and published them on Tableau Server, allowing end users to understand the data on the fly using quick filters for ondemand needed information. ● Created Tableau dashboards using stack bars, bar graphs, scattered plots, and geographical maps. ● Excel sheets, CSV files, and flat files were utilized to generate ad hoc Tableau reports. ● Worked on motion chart, Bubble chart, and drill-down analysis using Tableau desktop. ● Produced dashboards incorporating quick filters, parameters, and sets to enhance the efficiency of view management. ● Work with business stakeholders, application developers, and production teams across functional units to identify business needs and discuss solution options. ● Created and implemented the KPIs (Key Performance Indicators) to improve team engagement and team experience of using the meet application. ● Used Spark and SSIS to build scalable ETL pipelines to automate the process of Data extraction and loading. ● Used SQL Queries to build analytical workloads that answered important business questions related to the application.

Образование

Management Information Systems (Магистр)
По 2023
University of Illinois Chicago
Electronics and Telecommunication (Бакалавр)
По 2018
University of Mumbai

Языки

АнглийскийПродвинутый