SriHari M

Designed and developed SQL Server stored procedures, functions, and views to support complex ETL processes.

Engineered robust SSIS/SQL ETL solutions, acquiring and preparing data from numerous upstream systems for CRM processing.

Built comprehensive data transformations with SSIS, facilitating seamless data movement across database platforms and file imports.

Debugged and tuned SSIS and other ETL processes, ensuring accurate and efficient data movement and integrity.

Designed, implemented, and maintained critical database objects including tables, views, and indexes to optimize data storage and retrieval.

Led the design and implementation of advanced Microsoft Fabric-centric data platforms and data warehouses.

Ensured stringent data integrity, quality, and governance standards across all Microsoft Fabric environments.

Collaborated effectively with stakeholders to translate complex business needs into actionable and scalable data solutions.

Troubleshot and optimized existing Fabric implementations, significantly enhancing performance and reliability.

Developed and optimized intricate ETL/ELT processes within the Microsoft Azure ecosystem, leveraging relevant Fabric solutions for efficiency.

Migrated SQL databases to Azure Data Lake, Azure Data Lake Analytics, Azure SQL Database, and Azure SQL Data Warehouse.

Developed Spark applications using Spark-SQL in Databricks for data extraction, transformation, and aggregation from multiple file formats.

Designed and developed comprehensive Reports and Dashboards using POWER BI Desktop to meet specific business requirements.

Created and managed groups for sharing Power BI Dashboards with team members, enhancing collaboration and accessibility.

Published Power BI reports to online services, ensuring broad access and utilization for end-users.

Provided comprehensive technical support to developers, ensuring successful project execution and issue resolution.

Directed the extraction and transformation of large data volumes from diverse sources into target databases using SQL Server Integration Services (SSIS).

Optimized stored procedures for report generation, significantly improving data retrieval efficiency and performance.

Developed and deployed Power BI reports and dashboards from multiple data sources, utilizing advanced data blending techniques.

Spearheaded onshore/offshore coordination, ensuring seamless project deliverables and effective team collaboration.

Implemented Row Level Security (RLS) in Power BI, ensuring data governance and controlled access for sensitive information.

Designed and created new Calculated Columns and Measures using DAX Expressions, enhancing data model capabilities.

Extracted and loaded large volumes of data from various sources into target databases using SSIS transformations.

Configured and scheduled automatic data refreshes from on-premise sources using Data Gateways, ensuring up-to-date reports.

Presented weekly reports to business users, effectively communicating insights and changes to drive informed decision-making.

Implemented logging and deployment strategies for SSIS packages, ensuring robust error handling and tracking.

Managed end-user application support and enhancement requests, improving user satisfaction and system functionality.

Utilized best practices for SSIS package design, dataflow techniques, deployment, and management.

Developed Power BI reports and dashboards from multiple data sources using advanced data blending techniques.

Achieved expertise in writing complex DAX functions in Power BI and Power Pivot for sophisticated data analysis.

Implemented SSIS packages to load claims details into databases, including PDF compression and decompression.

Designed and developed SQL Server stored procedures, functions, and views for ETL processes, optimizing data handling.

Built data transformations with SSIS, including importing data from files and migrating between database platforms.

Debugged and tuned SSIS and other ETL processes to ensure accurate and efficient data movement.

Analyzed and developed strategies for data import and transfer between source, staging, and Data Warehouse destinations.

Gained extensive experience in Data Migration, Data Conversions, and ETL using SSIS packages and T-SQL scripts.

Transformed unstructured data from diverse sources using SSIS Transformations like Conditional Split, Lookup, Merge Join, and Aggregation.

Configured SSIS packages with logging, breakpoints, checkpoints, and event handling for robust error resolution.

Developed stored procedures, functions, tables, views, and indexes using T-SQL for efficient database operations.

Experienced in creating Report Models and generating reports for business analysis using SQL Server Reporting Services (SSRS).