Associate Senior Software Engineer with 3+ years of experience building cloud-based data solutions. Skilled in Azure Data Factory, Databrick, and SQL for ETL development and optimization. Experienced in cloud migrations such as SSIS to ADF and SQL Server to Snowflake. Proficient in automating workflows using Python, and Azure Logic Apps. Committed to delivering scalable, efficient, and reliable data solutions for business intelligence and reporting.
Overview
4
4
years of professional experience
4
4
years of post-secondary education
Work History
Associate Senior Software Engineer
Customer Analytics Pvt. Ltd.
Chennai
01.2021 - Current
Project: Ashley - Worked extensively with SQL and Azure SQL Database for data storage, querying, and optimization. Developed and maintained Azure Data Factory pipelines for loading data into Azure Data Warehouse. Migrated on-premise databases to Azure cloud, ensuring smooth transitions with minimal downtime. Implemented monitoring and alerting for ETL pipelines to detect and resolve data issues quickly. Improved data processing speed and supported business reporting with reliable data pipelines.
Project: Gmmco – Data Warehousing Played a key role in developing and delivering a large-scale data warehousing solution. Designed ETL pipelines using Azure Data Factory and SQL to centralize and manage business data. Optimized database performance for faster reporting and analytics. Integrated data from multiple systems into a unified data warehouse. Recognized with a Team Achievement Award for outstanding contribution to the project's success.
Project: RBS - Analyzed SQL database structures and identified performance bottlenecks. Suggested and implemented optimizations to improve query performance and reduce processing time. Fine-tuned SQL queries and optimized indexing for better database performance. Helped improve the efficiency of applications and reporting systems.
Project: TempurSealy – ETL Setup and Product Data Automation Designed and built complete ETL workflows using Azure Data Factory for better data warehousing. Integrated multiple data sources into Azure Data Warehouse to support advanced analytics. Automated the update of non-promo and promo prices in the application using APIs. Retrieved and analyzed pricing data from SQL tables to ensure consistent and up-to-date product information. Enhanced data pipeline performance, supporting business intelligence and reporting needs.