Sowmya Karapakula

Data Analyst fresher with hands-on training in SQL, Excel, Power BI, Tableau, and Python. Skilled in data cleaning, exploratory data analysis, and dashboard design, with project experience turning raw datasets into clear, actionable business insights. Seeking an entry-level analyst role to apply strong analytical thinking and attention to detail.

Data Analyst Intern - AI Variant - Bangalore

(2026-03 - 2026-09)

• Building an Insurance Analytics Dashboard tracking 35 KPIs across 7 branches and 51 executives.
• Structuring a SQL data model across 10 relational tables to support Power BI/Tableau reporting.
• Developing SQL-based KPI logic for revenue, pipeline, and conversion metrics across 1,800+ transactions.
• Analyzing 5,000+ policy and claims records to calculate Loss Ratio, Claims Frequency, and Retention.
• Analyzed 134K+ booking records using SQL to generate business KPIs and performance insights.
• Built interactive Power BI, Tableau, and Excel dashboards for Revenue, ADR, RevPAR, and Occupancy analysis.
• Developed SQL queries using Joins, CTEs, Window Functions, and Aggregations for KPI reporting.
• Performed data cleaning, ETL, and data modeling to deliver actionable business insights.

Industrial Training – 33/11KV Substation - APSPDCL

(2022-06 - 2023-01)

• Completed industrial training with exposure to power generation processes.
• Acquired practical knowledge of generators, transformers, and switchgear.

B.Tech - Electrical & Electronics Engineering (EEE) - Siddartha Educational Group, Tirupathi (2023 - 2026)

Diploma - Electrical & Electronics Engineering (EEE) - Loyola Polytechnic College, Pulivendula (2020 - 2023)

Secondary School (SSC) - APSWR School, Gundlakunta (2019 - 2020)