Back to Developers
Soujanya B

Soujanya B

Data Analyst

Hyderabad, Telangana 5+ yrs exp 90 · Outstanding

About

Results-driven Data Analyst with 5+ years of experience in business intelligence, data analysis, ETL processes, and dashboard development. Proven expertise in SQL, Power BI (DAX, Power Query), and Advanced Excel for transforming complex datasets into actionable business insights. Skilled in automating reporting pipelines and reducing manual effort by up to 40%. Strong track record across Healthcare and BFSI (Banking, Financial Services & Insurance) domains, managing large-scale datasets, maintaining data integrity, and delivering strategic insights to senior stakeholders.

Skills & Expertise (23)

Power BI Advanced
8.5/10
5
Years Exp
SQL Advanced
8.2/10
5
Years Exp
Advanced Excel Advanced
8.0/10
5
Years Exp
Pivot Tables Advanced
8.0/10
5
Years Exp
MS Excel Advanced
8.0/10
5
Years Exp
Data Validation Advanced
8.0/10
5
Years Exp
DAX Intermediate
7.5/10
5
Years Exp
Macros Intermediate
7.5/10
5
Years Exp
VBA Intermediate
7.5/10
5
Years Exp
SQL Server Intermediate
7.5/10
5
Years Exp
ETL Intermediate
7.5/10
5
Years Exp
Data Modeling Intermediate
7.0/10
5
Years Exp
SQL Query Optimization Intermediate
7.0/10
5
Years Exp
Looker Studio Intermediate
7.0/10
5
Years Exp
Power Query Intermediate
7.0/10
5
Years Exp
Tableau Intermediate
6.5/10
3
Years Exp
Python Intermediate
6.5/10
3
Years Exp
MySql Intermediate
6.0/10
3
Years Exp
R Studio Intermediate
6.0/10
3
Years Exp
Stakeholder Management Cross-Functional Collaboration Data Storytelling Requirements Gathering

Work Experience

Data Analyst

Chesa Dental Care Services

Mar 2021 - Dec 2023

Analyzed patient, financial, and operational data to generate insights supporting management decisions; delivered 50+ monthly reports to senior stakeholders. Developed and maintained 10+ interactive Power BI and Looker Studio dashboards for daily income tracking, performance metrics, and KPI monitoring. Automated monthly and annual reporting pipelines using Advanced Excel and VBA macros, reducing manual effort by 40% and improving accuracy to 99.5%. Implemented comprehensive data validation and QA checks, ensuring 100% data accuracy across all reports and ETL workflows. Designed employee performance dashboards tracking 15+ KPIs, enabling management to identify and address productivity gaps proactively. Maintained confidential medical data in compliance with internal data security policies. Extracted, transformed, and analyzed 50,000+ patient records monthly to support strategic business decisions and operational planning.

MIS Executive

Sub-K Impact Solutions Limited

Apr 2018 - Jul 2020

Gathered and analyzed business requirements from BFSI clients; developed and delivered 30+ customized MIS reports monthly. Wrote and optimized 100+ SQL queries to extract, transform, and validate data from SQL Server databases, improving query efficiency by 30%. Designed comprehensive Excel and Power BI reporting solutions for daily, weekly, and monthly performance tracking across 5+ business lines. Developed branch-wise and state-wise analytical dashboards for senior leadership, reaching 15+ stakeholders across the organization. Managed incentive calculations for 200+ field employees with 99.9% accuracy; processed payouts worth INR 2M+ annually. Conducted in-depth analysis of disbursement, overdue, and bounce data; identified high-risk segments, reducing portfolio losses by 15%. Collaborated with cross-functional teams to translate complex business requirements into scalable technical reporting solutions.

Education

Bachelor of Technology (B.Tech) — Electronics & Communication Engineering - Sri Indu Institute of Engineering & Technology

- 2016 · 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 15/15
💰 Rate 0/5
🏆 Certs 0/5
Verified 5/5
Total Score 90/100

Profile Overview

Member sinceJun 2026