Kishore. A

Orchestrated the complete SSIS lifecycle, developing, deploying, and executing packages across all environments to streamline data integration for the Admin Review System.

Monitored pipeline execution and managed run history to track status and performance, ensuring reliable data flow for critical administrative processes.

Developed Spark applications using PySpark and Spark-SQL for data extraction, transformation, and aggregation from multiple file formats, uncovering key customer usage patterns.

Transformed data through Azure Data Bricks notebooks and integrated them as activities for robust data factory workflows, improving data processing efficiency.

Developed PySpark scripts, created clusters, and managed jobs in Azure Databricks to facilitate large-scale dataset processing and manipulation.

Utilized Azure Data Factory for efficient data migration from On-Premise systems to Azure SQL Data Warehouse, ensuring seamless data availability.

Designed and developed various SSIS packages for ETL processes, ensuring efficient data extraction and transformation for wealth and private banking systems.

Migrated CSV files from Azure Blob Storage to Azure SQL Server and transformed data using Azure Data Factory (ADF) transformations, enhancing data accessibility.

Scheduled pipelines and monitored data movement from source to destination, maintaining data integrity and availability for critical business operations.

Developed Tabular and Matrix reports using SQL Server Reporting Services (SSRS) to meet diverse end-user requirements, improving reporting capabilities.

Authored stored procedures and user-defined scalar functions for SSIS packages and SQL scripts, optimizing data operations and system performance.

Gathered business requirements for data warehouse planning and implementation, facilitating strategic data initiatives and improving data-driven decision-making.

Created procedures for data manipulation on source tables and efficiently loaded data into destination tables for the Ericsson Configuration Portfolio (ECP).

Wrote complex T-SQL statements for data retrieval and performed performance tuning of T-SQL queries, improving system efficiency and data access speeds.

Performed extensive Data Extraction, Transformation, and Loading (ETL) using SQL Server 2008 R2 Integration Services for marketing research data.

Utilized containers like Foreach Loop and Sequence Container, along with tasks like File System, Bulk Insert, and Execute SQL, to manage complex data workflows.

Generated various Monthly, Quarterly, Bi-Yearly, and Yearly reports using different types of SQL Server Reporting Services (SSRS) reports to support marketing analysis.

Applied diverse transformations including Derive Column, Conditional Split, Aggregate, Lookup, and Merge to efficiently load data into the Data Warehouse.

Scheduled ETL packages monthly using SQL Server Management Studio, ensuring timely data updates and availability for market research projects.

Developed SQL Server Reports using stored procedures in the back-end, creating Table and Matrix reports as per specific business requirements.