Data Analyst Power Bi

Vidya Dhare Ravishankar

Sanford, FL ****************@*****.*** 689-***-**** www.linkedin.com/in/vidya-dhare PROFESSIONAL EXPERIENCE

Polk State College, FL, USA Mar 25 – Present

Data Analyst

• Perform data cleansing, transformation, and validation using SQL and Excel to ensure accuracy in state-mandated reports.

• Analyze complex datasets using SQL (JOINs, subqueries) and Excel (Pivot Tables, VLOOKUP) for institutional reporting.

• Design Power BI dashboards to present insights and support faculty and administrative decision-making.

• Manage ETL workflows, integrating data from Ellucian Banner (SIS), ERP systems, and other sources into Ellucian Insights

(SaaS-based reporting).

• Resolve data discrepancies and integration issues across SIS, ERP, and data lake environments.

• Work independently on student data, ensuring accuracy and timely reporting to meet institutional requirements.

• Collaborate with stakeholders to automate reporting processes and communicate findings clearly to non-technical audiences.

Arts Automation, India Mar 20 – Jul 23

Data Analyst

• Extracted, transformed, and analyzed large datasets using SQL and Python (Pandas, NumPy, Matplotlib), improving the process efficiency by 30%.

• Created dynamic dashboards in Tableau to visualize KPIs and business metrics, enhancing stakeholder insights and data- driven decisions.

• Developed and maintained ETL pipelines, reducing data processing time and ensuring data quality.

• Conducted ad-hoc analysis and generated reports identifying cost-saving opportunities, reducing operational expenses by 10%.

• Implemented CI/CD pipelines using Jenkins, worked within Agile/SCRUM teams, and followed Test Driven Development

(TDD) principles.

EDUCATION

University of Central Florida, Orlando, FL Aug 23 – Dec 24 Master of Science in Data Analytics

Visvesvaraya Technological University, India Aug 18 – Aug 22 Bachelor’s in Information Science and Engineering

SKILLS

Technical Skills: SQL, Python (Pandas, NumPy, Matplotlib, Scikit-learn), Microsoft Excel Business Intelligence & Visualization: Power BI, Tableau Data Engineering: ETL, Data Cleaning, Data Modelling, Data Mining, Data Management, Data Quality Management Tools & Platforms: Ellucian Insights (SaaS), Banner (SIS/ERP), CRM, JIRA, Jenkins, Splunk Methodologies: Agile/SCRUM, CI/CD, Test Driven Development (TDD) ACADEMIC PROJECTS

University of Central Florida, Orlando, Florida

PlaceWise: Proximity-Based Real Estate Recommendation Tool- Aug 24 – Nov 17

• Developed PlaceWise, a real estate tool that predicts property sale and rent prices using Random Forest Regression and forecasts trends with ARIMA models.

• Integrated location-based scoring to evaluate proximity to amenities, providing personalized recommendations through Python, Power BI, SQL, and Excel for data-driven decision-making. Optimizing Airbnb Revenue - Sep 23 – Dec 23

• Analyzed Airbnb listings in Broward County to identify key pricing factors and optimize revenue using Tableau, Excel, and Python.

• Provided data-driven pricing strategies, recommending dynamic pricing, amenity improvements, and professional photography to maximize earnings.

LEADERSHIP & ACTIVITIES

• Lions Club of Bangalore Ullal, Former Vice President

• Aikya, Former Campus Ambassador

Contact this candidate