← Back to list
middle
Registration: 03.05.2024

Adi Madan

Specialization: Tableau Developer
— Tableau Developer wit 4 years experience in Business Intelligence Reporting. I have mainly Tableau, Tableau Prep, SSRS, SSIS, and SSAS, Python along with other tools to develop BI reports and dashboards to highlight important insights. — I believe that given my analytical and problem solving skills, I can help make a huge impact on the organization's operational success. — Tableau Experience: Extensive Experience of 4+ years in Tableau Desktop and Tableau Server Administration in various versions of Tableau 2024.1, 2023.2, 2020.4, 2020.2.1, 2019.1, 2018.1. — Has installed and upgraded the Tableau environment and created the security. — Proficient in creating Calculations (Hide Columns, Creating/using Parameters, Table Calculations, Totals) and Formatting (Annotations, Layout Containers, Mark Labels, Mark Card Changes, Rich Text Formatting, Shared Encoding) using Tableau Desktop. — I have experience working mainly in the IT domain and also on the business side where I had the opportunity to perform requirement gathering and work towards examining and amending the existing business operations and achieving new levels of efficiency. — As a Data Analyst Involved in designing the Aggregates for the Dimensions in the data warehouse as per the Business requirement. Analyzed the data to come up with the report fields for the reports. Databases: MS SQL Server, PL/SQL, SQL, Snowflake, MySQL. Other tools: Microsoft Office, Google Suite, AWS S3, AWS RDS. — Expertise in preparing Test Plans, Use cases, and data validation practices for application performance. — Worked on T-SQL commands, stored procedures, functions, and packages. — Has worked on Data Modelling in SQL Server, and MS Access which uses physical, conceptual, and logical data model. — Created the schedules and scheduled the Extracts and Subscriptions. — Used the TSM commands and scripts for automation. — Upgraded the Tableau server from older versions to the latest versions. — Helped development teams to resolve their environmental issues. Certifications: — AWS Certified Cloud Practitioner Tableau for Data Science A-Z. — Introduction to Alteryx. — PowerBI DAX Functions.
— Tableau Developer wit 4 years experience in Business Intelligence Reporting. I have mainly Tableau, Tableau Prep, SSRS, SSIS, and SSAS, Python along with other tools to develop BI reports and dashboards to highlight important insights. — I believe that given my analytical and problem solving skills, I can help make a huge impact on the organization's operational success. — Tableau Experience: Extensive Experience of 4+ years in Tableau Desktop and Tableau Server Administration in various versions of Tableau 2024.1, 2023.2, 2020.4, 2020.2.1, 2019.1, 2018.1. — Has installed and upgraded the Tableau environment and created the security. — Proficient in creating Calculations (Hide Columns, Creating/using Parameters, Table Calculations, Totals) and Formatting (Annotations, Layout Containers, Mark Labels, Mark Card Changes, Rich Text Formatting, Shared Encoding) using Tableau Desktop. — I have experience working mainly in the IT domain and also on the business side where I had the opportunity to perform requirement gathering and work towards examining and amending the existing business operations and achieving new levels of efficiency. — As a Data Analyst Involved in designing the Aggregates for the Dimensions in the data warehouse as per the Business requirement. Analyzed the data to come up with the report fields for the reports. Databases: MS SQL Server, PL/SQL, SQL, Snowflake, MySQL. Other tools: Microsoft Office, Google Suite, AWS S3, AWS RDS. — Expertise in preparing Test Plans, Use cases, and data validation practices for application performance. — Worked on T-SQL commands, stored procedures, functions, and packages. — Has worked on Data Modelling in SQL Server, and MS Access which uses physical, conceptual, and logical data model. — Created the schedules and scheduled the Extracts and Subscriptions. — Used the TSM commands and scripts for automation. — Upgraded the Tableau server from older versions to the latest versions. — Helped development teams to resolve their environmental issues. Certifications: — AWS Certified Cloud Practitioner Tableau for Data Science A-Z. — Introduction to Alteryx. — PowerBI DAX Functions.

Skills

Tableau
Tableau Prep
PowerBI
SQL
PL/SQL
Python
R
Java
SSRS
SSIS
SSAS
MS SQL Server
PL/SQL
Tableau
MySQL
SQL
Python Pandas and Pyspark
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

Work experience

Tableau Developer
since 10.2023 - Till the present day |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.

Educational background

Electronics and Telecommunication (Bachelor’s Degree)
Till 2018
University of Mumbai
Management Information Systems (Masters Degree)
Till 2023
University of Illinois Chicago

Languages

gbAdvanced