Ravula Sai Krishna
Hyderabad
Summary
Data Analyst with 3.2 years of experience in Python, SQL, Power BI, and Excel. Proficient in cleaning and analyzing large datasets to enhance business decision-making. Expertise in automating reports and developing interactive dashboards that reveal trends and boost operational efficiency. Proven ability to optimize SQL queries and deliver actionable insights that drive measurable business results.
Overview
3
3
years of professional experience
1
1
Certification
Work History
Data Analyst
L&T Technology service
Mysore
09.2022 - Current
- Cleaned, transformed, and validated over 5 million patient, claims, and appointment records using Python and SQL.
- Supported data extraction from multiple sources, including structured databases and Excel files, ensuring smooth data integration.
- Automated recurring healthcare operations reports in Power BI and Excel, minimizing manual effort by 40%.
- Optimized complex SQL queries for enhanced performance, improving access to key performance indicators by 45%.
- Conducted root-cause analysis on operational inefficiencies using historical healthcare data, supporting leadership decisions to improve patient throughput, and reduce delays.
- Collaborated with clinical and management teams to convert reporting requirements into actionable dashboards.
- Designed interactive Power BI dashboards to enhance operational visibility and track service utilization metrics.
- Developed Python-based frameworks for data cleaning, increasing dataset completeness by 28%.
- Created standardized reporting templates for medical leadership, reducing ad-hoc report requests by 2%.
- Performed ad-hoc analysis for management requests, identifying trends, anomalies, and cost drivers in healthcare operations.
- Maintained data documentation and metric definitions, ensuring consistency across dashboards and reports.
- Provided insights on patient flow and treatment outcomes during monthly and quarterly performance reviews.
- Worked closely with business users to gather requirements, define success metrics, and deliver iterative dashboard enhancements based on feedback.
- Mentored junior team members on SQL query optimization, Excel automation, and Power BI best practices.
Education
B.Tech - Computer Science and Engineering Hons
Lovely Professional University
05-2022
Skills
- Python and SQL
- Data validation and cleaning
- Analytical thinking
- Version control with Git
- Power BI and Power Automate
- Microsoft Excel and PowerPoint
- SQL optimization
Certification
- SQL - Hackerrank
- Python - Hackerrank
- DataScience - Forage
Projects
Customer churn analysis dashboard using telecom data
Python | SQL | Power BI
- Performed exploratory data analysis (EDA) to uncover churn drivers related to tenure, contract type, monthly charges, service usage, and payment methods
- Analyzed churn behavior across customer demographics, billing patterns, internet services, and support interactions
- Designed SQL queries to extract, aggregate, and join customer, billing, and service datasets for analytical modeling
- Built Power BI data models with optimized relationships to support fast, scalable dashboard performance
- Implemented drill-through and slicer-based analysis to enable stakeholders to explore churn at customer segment and service level granularity
- Identified key churn drivers, such as month-to-month contracts, high monthly charges, and short tenure, enabling targeted retention strategies
Real-time sales and demand forecasting analysis
Python | SQL | Power BI
- Analyzed large-scale historical and near real-time sales datasets across multiple product categories and regions using Python (Pandas, NumPy)
- Cleaned and standardized transactional sales data by handling missing dates, inconsistent product hierarchies, and duplicate transactions
- Performed time-series exploratory analysis to identify long-term trends, seasonality, cyclic patterns, and demand spikes
- Designed SQL queries to aggregate daily, weekly, and monthly sales metrics for forecasting and reporting
- Integrated forecast outputs into Power BI using structured datasets for visualization and decision-making
- Analyzed the impact of promotions, discounts, and seasonal events on sales performance and demand volatility
Timeline
Data Analyst
L&T Technology service
09.2022 - Current
B.Tech - Computer Science and Engineering Hons
Lovely Professional University