Software Engineer
Kantar-FireflyJul, 2022 - Present3 yr 4 months
Developed and implemented Python-based automation scripts that streamlined workflows, significantly decreasing manual effort and improving overall task accuracy and processing speed. Architected and developed complex SQL queries, Stored Procedures, and Views to drive precise business logic, enabling efficient data manipulation and extraction to support key business operations. Engineered and refined database schemas for MSSQL and MySQL, achieving a 30% improvement in query performance through schema optimization and indexing strategies. Designed and deployed end-to-end data automation solutions using SSIS packages and Azure Data Pipelines, streamlining data processing, import/export workflows, and automating routine tasks by scheduling jobs in SQL Server Agent. Leveraged Python automation scripts to enhance project workflows, boosting overall operational efficiency by 40%. Collaborated closely with cross-functional teams in Agile and Scrum environments, actively participating in sprint planning, daily stand-ups, and requirements gathering to ensure timely and successful project delivery.