Portfolio - Swetha Amuru

About Me

I'm a data enthusiast with over 3 years of hands-on experience in the IT industry, focusing on transforming data into impactful business insights.
At Dhatsol, I worked as a Data Analyst on a large-scale insurance web application-- designing and developing interactive dashboards in Power BI to support key business decisions. I was responsible for end-to-end data workflows, using SQL and Azure Data Factory for backend data integration. My work enabled stakeholders to monitor performance metrics, identify trends, and make data-driven improvements across multiple operational areas.

Previously, as a Senior Systems Engineer at Infosys, I focused on data extraction and reporting, leveraging Excel, SQL to build reports that guided business decisions.

I’m passionate about using Power BI, SQL, Excel, and Python to uncover stories hidden in data and help businesses make smarter, data-driven decisions.

Let’s connect if you're into data, dashboards, or love turning chaos into clarity.

Key Skills

MySQL

Microsoft Power BI

Microsoft Excel

Microsoft Power Query

Python

My Projects

Shield Insurance

Domain/Function: Insurance

Electric Vehicles Sales analysis

Domain/Function: Automotive Electric Vehicles

Sales Insights 360

Domain/Function: sales

Atliq Grand Hospitality Analysis

Domain/Function: Hospitality

Atliq Hardwares Sales Report

Domain/Function: Sales

Atliq Hardware Consumer Goods Ad-Hoc Insights

Domain/Function: Consumer Goods

My Experience

Data Analyst, Dhatsol IT Solutions Pvt Ltd.

· Developed 3 interactive Power BI dashboards by integrating MySQL data, reducing manual effort by 30%.

· Extracted, transformed, and cleaned over 500K+ records using SQL and Power Query for trend analysis across 8 insurance modules.

· Built 10+ KPIs for plan enrollment, caseworker performance, and eligibility pass/fail rates, improving operational visibility.

· Created DAX measures to calculate plan adoption trends, eligibility success rate, and monthly performance summaries.

· Scheduled auto-refresh in Power BI Service and added row-level security (RLS) for secured access by Admin and Caseworker roles.

· Optimized dashboard performance by aggregating data into summary tables, improving load times by 30%.

· Collaborated with dev and business teams to tailor insights, reducing case resolution time by 18% through better workload tracking.

Senior Systems Engineer at Infosys

· Validated and cleaned data during report migrations using Microsoft Excel and custom reporting tools, identifying critical bugs and enhancing report accuracy by 30%.

· Designed impactful data visualizations and dashboards using tools like Excel (PivotTables, Charts) and client-specific reporting platforms to facilitate informed decision-making, boosting performance by 50%.

· Wrote efficient SQL queries to extract and transform metrics from client databases, exporting data to Excel for further analysis and reporting.

· Managed Critical tasks, maintaining 95%+ on-time solution rate.

· Executed comprehensive UAT protocols to assess application functionality, identifying and resolving 15+ critical issues pre-launch, ensuring a seamless transition that boosted team productivity by 20 hours weekly.

· Developed data-driven insights, presented to the Infosys CSR team, that led to the implementation of three key sustainability initiatives, resulting in significant reductions in the company's carbon footprint.

Awards & Certificate