Rupali Vijay Avhad
Wichita, KS *************@*****.*** 316-***-**** www.linkedin.com/in/rupali03 PROFESSIONAL SUMMARY
Detail-oriented Data Analyst with hands-on experience in Power BI, Tableau, and other data visualization tools. Skilled in transforming complex datasets into clear, actionable insights to support strategic decision-making. Proficient in Python, SQL, and data cleaning, with a strong ability to create interactive dashboards and automate processes for enhanced efficiency. Passionate about leveraging analytical skills to drive business improvements and deliver impactful data-driven solutions. EXPERIENCE
Data Analyst- National Institute for Aviation Research, Wichita Oct’24 - Present
Developed a Python app with a multi-page GUI to manage crash test data, reducing manual errors and improving efficiency.
Designed pages for test information, ballast calculations and photo-metric data entry.
Created a utility functions module for shared tasks and integrated a database for data storage.
Improved crash test data management, enhancing accuracy for researchers and engineers at NIAR. Data Analyst Intern- VN Software Pvt Ltd, India Jan’24 - June’24
Developed and cleaned large datasets to prepare them for analysis and reporting.
Created interactive dashboards using Power BI and Tableau to visualize business trends.
Designed simple, easy to understand reports to help teams make better decisions.
Helped improve overall business planning by turning raw data into clear insights. Data Analyst Intern- Sai Info Solutions, India Jan’23 - Feb’23
Gained hands-on experience with IOT modules and python programming for industrial automation.
Cleaned and structured raw data to ensure accuracy and consistency for project use.
Supported the development team by preparing reliable datasets for analysis.
Improve data quality and helped simplify data handling in the automation project. TECHNICAL SKILLS
Languages: Python, SQL, C, C++
Databases: MySQL, SMicrosoftQLite, Microsoft SQL Server Visualization/Analytics Tools: Microsoft Power BI, Tableau, Excel, Qlik Sense Tools/Frameworks: Spyder, Visual Studio Code, Anaconda, Jupyter Notebook, Google Colab, SQLite, Turbo C, Microsoft Excel, Microsoft Word, Microsoft PowerPoint, Microsoft Outlook, Microsoft Teams EDUCATION
Masters in Data Science – Wichita State University, Kansas Aug’24 - May’26 Relevant Courses: Perspective on Data Science, Machine Learning, Programming for Computing, Power BI, Data Cleaning, Introduction to Database Systems, Introduction to Business Analytics. Bachelors in Instrumentation and Control Engineering – Pune University, India Aug’20 - June’24 ACADEMIC PROJECTS
Stock Price Prediction using ML Dec’24
Implemented a stock price predictionmodelusingtheLinearRegressionalgorithminPython. Analyzedhistoricalstockmarketdatatopredictfuturetrendsandpricesaccurately. Utilized Python libraries such as NumPy, Pandas and Matplotlib for data prepossessing, analysis and visualization
Demonstratedtheeffectivenessofmachinelearningtechniquesinfinancialforecasting. Solar Power Mobile Charger May’24
Analyzed solar panel efficiency and energy output using Python (Pandas, Matplotlib). Modeledenergyconsumptionpatternstooptimizechargerperformancefordiverseconditions. Derived insights from environmental data to enhance design and usability for rural and emergency applications.