-
Code Migration: Led end-to-end SAS-to-Azure Synapse migration, conducting analysis and implementing best practices for data warehousing/ETL. Automated data extraction from Oracle/Salesforce using Azure Synapse’s advanced capabilities for improved performance and scalability. Developed complex stored procedures in T-SQL and developed Azure Pipelines for automation of data processes.
-
Collaboration: Worked closely with cross-functional teams at Oxford Research Global to understand the business requirements and translate them into technical solutions. Conducted presentations and demos to stakeholders to gather feedback and fine-tune the solution. Acted as a subject matter expert in both SAS and Azure Synapse to provide guidance and support to other members of the team.
-
Infrastructure Optimization: Utilized expertise in Azure Synapse to optimize the infrastructure, reducing costs and improving data processing speeds. Developed and executed test plans to validate the solution, ensuring high data quality and accuracy. Managed ongoing support and maintenance of the code migration, monitoring the system for any issues and implementing fixes as needed.