Merlin A

Detail-oriented Developer with 3+ years of hands-on experience in SQL Server and a growing specialization in ETL development. Good experience in SQL Server, SSIS, Azure Data Factory (ADF) and Snaplogic for building seamless ETL workflows and integrating data landscapes. Good communication skills with experience collaborating across teams to support project coordination and delivery.

Adept at multitasking and managing multiple responsibilities effectively. Passionate about leveraging data-driven solutions to support business growth and operational efficiency.

SQL Development & Reporting at Newdream Data Systems (2023-03 – Present)

• Develop and maintain SQL Server and Azure-based database solutions, including tables, views, functions, stored procedures, ETL processes, and production database support.
• Optimize SQL queries and database processes for enterprise workloads, with a focus on performance, reliability, and maintainability.
• Design and support Azure Data Factory pipelines for data ingestion, transformation, file processing, and automated reporting workflows
• Collaborate with application, API, AI, and reporting teams to deliver database changes and resolve production issues.
• Build dynamic SQL and stored procedures for data comparison, validation, cleansing, and report-data generation across multiple systems.
• Support report automation and Power BI data preparation for retail and insurance business requirements.
• Reduced runtime of a long-running Azure Data Factory pipeline by 75% through query optimizations and indexing.
• Built a workaround to generate XML output in Azure Data Factory despite no native XML write support, avoiding a custom Azure Function or third-party connector.
• Automated comparison report generation and delivery, saving approximately 4 hours per week of manual effort

Master of Science in Computer Science – St. Joseph’s College (2023)