Back to Developers
BHAVANA PENMATSA

BHAVANA PENMATSA

Data Analyst

Hyderabad, India 2+ yrs exp 85 · Excellent

About

Analytical professional with experience building optimized database systems and BI dashboards. Proficient in SQL, PL/SQL, Power BI, and Tableau, with hands-on expertise in performance tuning, KPI reporting, and converting complex business requirements into actionable data solutions. Driven to continuously enhance my technical and analytical capabilities while adapting to evolving data technologies and industry best practices.

Skills & Expertise (17)

SQL Advanced
8.0/10
2
Years Exp
Power BI Advanced
7.8/10
1
Years Exp
Python Intermediate
5.5/10
1
Years Exp
Tableau KPI Reporting Performance Tuning Row-Level Security Subqueries Aggregations Window Functions CTEs DAX Excel Microsoft SQL Server MySql Oracle SQL Developer PLSQL

Work Experience

Data Analyst

Digital Innovation Lab SDSU

Oct 2023 - Sep 2024

Designed and implemented a normalized Microsoft SQL Server relational database schema to store mentor-mentee interactions, conversation transcripts, performance feedback, hike discussions, and workplace issue logs. Developed SQL queries using CTEs, window functions, aggregations, and subqueries to analyze mentorship engagement trends and conversation frequency metrics. Implemented Row-Level Security (RLS) in Power BI to ensure managers could only view data related to their respective mentees. Optimized Power BI data models by reducing cardinality, implementing relationships effectively, and using calculated columns vs. measures strategically to enhance report performance. Created DAX measures (YTD interactions, Average Resolution Days, Interaction Growth %, and SLA Compliance metrics) to analyze mentorship effectiveness and employee growth patterns.

Associate Engineer

Virtusa Consulting Services Private

May 2022 - Jun 2023

Developed and optimized complex SQL queries, subqueries, and joins, ensuring high data accuracy and efficient retrieval for business-critical reports. Maintained Oracle PL/SQL packages, procedures, functions, and cursors, enabling seamless automation and minimizing manual intervention. Performed query tuning and performance optimization, reducing query latency and boosting system responsiveness across core banking modules. Coordinated with stakeholders and business teams to clarify reporting requirements and translate them into structured SQL solutions. Collaborated with cross-functional teams to resolve high-priority production incident tickets through proactive root cause analysis and quick issue remediation, strengthening database reliability and client satisfaction.

Database Engineer, Intern

Virtusa Consulting Services Private

Dec 2021 - Mar 2022

Designed and delivered a relational banking database model aligned with client requirements, implementing relationships, constraints, and indexes for optimal performance. Developed PL/SQL scripts and stored procedures supporting data preparation and transformation processes. Participated in debugging, testing, and validating database outputs to ensure alignment with expected transformation rules. Collaborated under senior team guidance to document database workflows and technical specifications.

Education

Bachelor of Technology - Information Technology - Institute of Aeronautical Engineering

2018 - 2022 · Afghanistan

Certifications

No certifications added yet

Interested in this developer?

Profile Score Breakdown

📷 Photo 10/10
📄 Resume 10/10
💼 Job Title 10/10
✍️ Bio 10/10
🛠️ Skills 20/20
🎓 Education 10/10
⏱️ Experience 10/15
💰 Rate 0/5
🏆 Certs 0/5
Verified 5/5
Total Score 85/100

Profile Overview

Member sinceMay 2026

Availability Details

Relocation

Open to Relocation