Samvida T.

Business Intelligence Developer @INTEGRIS Health

OK, US

Designed and developed complex T-SQL stored procedures, views, triggers, and table-valued functions to facilitate efficient data extraction, transformation, and loading (ETL) processes across various systems.• Generated and distributed reports in diverse output formats including Excel, PDF, fixed-width, tab-delimited, and pipe-delimited files to meet different business and compliance needs.• Built and maintained SSIS packages to load data from multiple sources such as SQL Server, Excel, flat files, and XML into structured destination tables with necessary transformations applied.• Created dynamic, interactive, and parameterized reports using SSRS, incorporating features like cascading prompts, sub-reports, conditional formatting, and visual elements such as charts.• Designed and published visually compelling Power BI dashboards, enabling stakeholders to gain real-time insights into business performance and operational metrics.• Authored detailed ETL mapping specifications, documenting data source systems, change data capture (CDC) logic, transformation algorithms, lookup logic, and target systems for each DataMart.• Connected SSRS to Analysis Services (SSAS) to generate multidimensional reports and supported OLAP-based data exploration.• Scheduled and monitored SSIS packages and report delivery jobs, ensuring consistent data refresh and automated distribution on a daily, weekly, and monthly basis.• Built advanced Power BI reports by writing complex DAX measures and calculated columns to support detailed data analysis and decision-making capabilities