Power Bi Data Analyst

ARYAN PATEL

New York, NY 848-***-**** ********@****.*** www.linkedin.com/in/aryu001

EDUCATION

Pace University, New York, NY 05 2025

Masters of Science in Data Science, 3.83

SGM English Medium College of Commerce and Management, Anand, Gujarat 05 2023

Bachelor of Computer Application, 3.7

SKILLS

Programming Languages: Python, R, Scikit Learn, Jupyter, SQL, VB.NET

Data Analysis and Visualization: Microsoft Excel, Power BI, Google Analytics, Apache Spark

Database Management: SQL Server, Data Cleaning

Statistical Analysis: Hypothesis Testing, Regression Analysis, Descriptive, Inferential Statistics

Financial Analysis: Budget Tracking, Revenue Forecasting, Cost Optimization

Automation & Reporting: Excel Macros, SQL Queries, Power BI Dashboards

Languages: Gujarati, Hindi and English

EXPERIENCE

Data Analyst Intern

Gypsy Tours and Travel, Anand, Gujarat 01 2022 - 06 2023

Collected, cleaned and analyzed financial and operational data using Microsoft Excel and SQL, involved processing

over 5,000+ records to ensure 98% accuracy and consistency in monthly reports.

Automated bill tracking and payment reconciliation by designing structured Excel spreadsheets, resulting in a 35%

reduction in processing time.

Conducted a comprehensive trend analysis on over 10,000 travel bookings and expense records, uncovering cost

saving opportunities resulted in a 15% reduction in expenses and increased revenue forecasting accuracy.

Designed dashboards and reports in Power BI and Excel, visualizing monthly revenue, customer booking patterns

and expense distribution, led to 25% increase in decision-making speed.

Applied data validation techniques to minimize errors and improve accuracy of transaction records, contributed to

30% reduction in transaction record and an impressive 99% data accuracy.

Streamlined financial data organization using Pivot Tables and VLOOKUP, making invoice tracking 20% more

efficient.

Exceeded in generating monthly revenue reports, providing management with insights into profit margins and

customer spending patterns.

PROJECTS

Canteen Management System 01 2023 - 04 2023

Built and deployed an automated billing system decreased manual errors by 40% and enhanced operational

efficiency.

Engineered a robust database deploying VB.NET and SQL, improved data retrieval speed by 50% and minimized

system downtime by 75%.

Created interactive Power BI dashboards to monitor real-time inventory levels, sales transactions and customer

purchasing patterns, drove to 25% reduction in stock shortages and increased order fulfillment efficiency.

Applied data validation techniques, including setting constraints on transaction entries, checking for duplicate

records, and standardizing data formats, resulted in a significant reduction of financial discrepancies by 30%.

Optimized SQL retries to reduce response time by 60%, leading to faster decision-making and improved system

performance.

Formulated a user-friendly interface, increasing ease of use and reducing training time for new employees by 30%.

Sales Data Analysis Project 08 2022 - 11 2022

Analyzed sales data from an online dataset to identify trends in customer purchasing behavior, revealing seasonal

demand shifts.

Cleaned and processed over 50,000 records using Python (Pandas, NumPy) to handle missing values, remove

duplicates, and standardize formats.

Performed exploratory data analysis (EDA) to uncover key sales drivers and regional variations, enhancing sales

strategy alignment.

Applied statistical techniques, including mean, median, and standard deviation analysis, to evaluate sales

performance.

Developed a Linear Regression model to forecast sales, improving demand predictions by 20%.

Created interactive Power BI dashboards and Excel reports to visualize revenue trends, top-selling products, and

customer demographics, making data more accessible to stakeholders.

Optimized SQL queries for faster data retrieval, resulting in a 30% improvement in query execution time.

VOLUNTEER EXPERIENCE

Green Festival Cvm 12 2022 - 02 2023

Science Exhibition

Focused on pioneering energy-saving initiatives to promote sustainability by developing and carrying out practical

strategies for reducing daily energy consumption.

Led a team of over 10 students in creating and presenting interactive models showcased renewable energy

solutions, raising awareness among attendees.

Researched solar energy, waste management, and water conservation, leading to the implementation of a solar

lighting system that reduced energy consumption by 30% and a waste segregation model that enhanced recycling

efficiency by 40%.

Contact this candidate