Power Bi Data Analysis

Rushabh Udani

Union, New Jersey 631-***-**** www.linkedin.com/in/rushabh-udani ****@***********.*******.*** EDUCATION

Rutgers University, New Jersey Expected: Dec 2024

Master’s in Information Technology and Analytics GPA: 4.0

● Coursework – Business Forecasting, Data Analysis and Visualization, SAP – supply chain solutions University of Mumbai, India May 2023

Bachelor of Computer Science Engineering

● Coursework – Big Data Analytics, Database Management, Data Warehousing, statistics SKILLS & INTERESTS

Data Analysis and Visualization: Power BI, Tableau, Excel (Pivot table, VLOOKUP, Power Query) Programming languages: Python (numpy, pandas, matplotlib, streamlit), R (forecasting, multi variate analysis) Database: SQL, MySQL, Microsoft SQL Server Management Studio ERP system: SAP (Sales & Distribution, Materials Management, Production Planning modules) PROFESSIONAL TRAINING EXPERIENCE

ICT Academy Jan 2023-Mar 2023

Power BI Intern

● Designed interactive Power BI dashboards for sales and profit analysis, resulting in a 25% enhancement in executive decision-making processes through precise and clear data presentation.

● Enabled self-service data exploration by conducting training sessions and implementing the Power Q&A tool for internal teams, improving overall data accessibility by 40%.

● Configured Power Query to automate data extraction from 10+ sources, reducing time spent on manual data queries across the organization by 25% and facilitating efficient data migration.

● Analyzed key data visualization requirements, managed data governance, and data transformation processes resulting in cost saving opportunities.

Trainity Ed-Tech program Jan 2022-Mar 2022

Data Analyst Trainee

● Analyzed IMDB movie rating data using Tableau to identify trends and patterns, streamlining reports and improving efficiency by 20% through advanced data visualization techniques.

● Created interactive Tableau dashboards that reduced analysis time by 25% for sales leaders, facilitating quick insights into profit, sales, and budget comparisons for movies from 1920 to 2010.

● Enhanced data accuracy by 15% through the cleaning and standardizing of 20,000-rows of IPL dataset using Python and advanced Excel techniques like pivot tables and lookup values.

● Implemented advanced SQL queries in MySQL and MS SQL Server to enhance data retrieval efficiency and improve visualization techniques.

PROJECT EXPERIENCE

Citi Bike Sharing Data Visualization Project

● Conducted in-depth Exploratory Data Analysis (EDA) using Tableau on the Citi Bike dataset, revealing a 22% decline in customer numbers relative to members, offering actionable insights on subscription trends and urban mobility improvements.

● Developed a predictive model using Python, connected with Tableau, to evaluate user mobility trends; yielded precise monthly trip insights, improving urban mobility efficiency by 35%. Amazon e-commerce Data Warehousing Project

● Led a pivotal database management task, employing Microsoft SQL Server Management Studio to import Kaggle e-commerce datasets and design an ER diagram, improving data integrity and analysis efficiency by 40%.

● Implemented SQL queries to extract, transform, and load (ETL) raw datasets into a centralized data warehouse, thus optimizing efficiency and accessibility for analysis by 10%. LEADERSHIP/NETWORKING ACTIVITIES

Teaching Assistant - Information Technology for Managers Rutgers University Provide progress updates and grading assistance with Microsoft Suite and Outlook to professor for student assignments. Vice Chairperson of Student Registration Computer Society of India Achieved 25% optimization in registration experience through collaborative cross-functional efforts, leveraging user friendly Google Forms and Excel integration.

Contact this candidate