Vamshi Krishna Somala

About Vamshi Krishna Somala

Turning complex data into clear business insights — that’s what I do.As a Power BI Developer | Business Intelligence Developer | Data Analyst with 3.8 years in analytics, I help businesses uncover trends, track performance, and make smarter, faster decisions with data.Results-driven Power BI Specialist with proven expertise in designing, developing, and enhancing business intelligence solutions for a global product manufacturing client. Specialized in transforming raw data into actionable insights across Product Analytics, Sales Analytics, and Financial Reporting.Skilled in Power BI, Microsoft Fabric, Power Query, DAX, and SQL, with hands-on expertise in data modelling, performance tuning, and implementing Row-Level Security (RLS). Proficient in integrating data from SQL databases, Excel, and CRM platforms to deliver accurate, visually compelling, and interactive reports.Proven track record in collaborating with cross-functional teams — including product managers, sales leaders, and finance stakeholders — to understand requirements, ensure data accuracy, and deliver impactful reports that support strategic decision-making.Key Expertise: Power BI Development & Report Optimization Data Modeling & Dataflows KPI Tracking & Business Performance Analysis Financial, Sales, and Product Reporting🧪 User Acceptance Testing (UAT) & Production Deployment🤝 Stakeholder Collaboration & Requirement GatheringAlways eager to leverage modern BI tools and best practices to deliver high-quality, scalable analytics solutions that drive business growth.Let’s connect! Feel free to DM me here.

Experience

1. Senior Software Engineer

   HCLTech

   Nov 2021 — Present · Chennai, IN

   Designed, developed, and maintained interactive Power BI dashboards to track KPIs, trends, and performance metrics• Gathered requirements from stakeholders and translated them into technical specifications for report development• Performed data extraction, transformation, and loading (ETL) from multiple sources including SQL databases, Excel, and CRM platforms using Power Query and Dataflows• Built optimized data models (star schema) with calculated measures in DAX to improve report performance and accuracy• Created KPI tracking, variance analysis, and forecasting solutions for strategic decision-making• Implemented Row-Level Security (RLS) and managed access in Power BI Service for secure data distribution• Automated data refresh schedules and monitored pipelines to ensure timely updates• Collaborated with product managers, sales leaders, finance teams, QA, and business analysts to validate outputs and refine KPIs• Supported UAT cycles, handled bug fixes, and managed production deployments• Applied performance tuning techniques to enhance dashboard load times and usability• Ensured adherence to data governance and compliance standardsTools & Technologies:Power BI • Microsoft Fabric • Power Query • DAX • SQL • Dataflows • Excel • CRM Systems • Jira • ServiceNow

Education

• Dr Mgr Educational and Research Institute

  Bachelor of Technology, Cse

  2017 — 2021