ResumeON
Active
Lavanya Reddy

Lavanya Reddy

Technical Business Analyst

On-site

LinkedIn profile
Projects

Credit Card Financial Dashboard

Developed an credit card transactions dashboard using SQL database, driving a 28.8% WoW revenue increase • Identified regional trends, with TX, NY, and CA contributing 68% of transactions, and highlighted key performance metrics such as an activation rate of 57.5% and delinquency rate of 6.06

View
sqlpythonexcelpowerbi

Revenue Insights Hospitality Domain

Analyzed trends across weeks & recommended pricing structures that led to 20% increase in weekly revenue. • Identified the impact of hotel ratings on occupancy rates, and proposed strategies for improving customer satisfaction and online portrayal to boost booking conversion rates.

View
sqlpowerbiexcelpython

PwC Switzerland PowerBI Job Simulation

Created Call Centre analysis report which gives 3.4/5 average customer rating to see performance trends by setting KPI • Designed Churn analysis report for 7043 customers, resulting 26.54% churn rate by using charts and DAX functions which helps in data-driven decision making to operability. • Crafted Diversity & Inclusion report, harmonizing the workforce based on gender for 500 employees.

View
sqlpythonpowerbiexcel
Stack & AI tools
apisqlpythonexcelpowerbiuatbrdfrdagile
Contact via ResumeON