Devi RagothamanPower

Developed and maintained SQL Server objects (tables, views, stored procedures, functions, triggers) and supported data security via views. Wrote T-SQL scripts for schema discovery (e.g., identity columns, missing primary keys) and improved query performance by reducing unnecessary UNION usage and using TOP to limit result sets. Created and tuned indexes on selective columns to speed up reporting and analysis. Implemented ETL/data integration patterns using SSIS and Azure Data Factory, including source-to-target mappings and ODS-to-DW loads. Designed relational and dimensional schemas (ODS and star schema) and supported Power BI semantic models and SSAS tabular models. Published Power BI dashboards/reports and configured an on-premises data gateway for Power BI Service. Collaborated with users, team leads, DBAs, and managers through JAD-style sessions, and reviewed performance across database, SSAS models, and SSRS/Power BI reports.

Produced SQL scripts and performed database development using joins, correlated/non-correlated subqueries, and procedural objects like stored procedures and triggers with business-rule enforcement through constraints. Created indexes to improve query execution time and reduced T-SQL overhead by avoiding unnecessary UNION operations and applying TOP to limit query results. Built logical and physical data models using ERwin, including source-to-target mapping and ODS-to-data-warehouse loading patterns. Supported maintenance and integrity of data marts/warehouses and implemented ETL workflows using SSIS. Supported analytics deliverables via SQL Server Reporting Services and Power BI dashboards and reports, including gateway setup for Power BI services.