* **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.

Azure Synapse

* Web Application: Designed user-friendly web app to connect customers with architects. Implemented responsive design and ensured cross-browser compatibility for optimal user experience. Resulted in a highly functional and visually appealing web app, available at (yelloclay.com)

* MERN stack: Developed a full-stack e-commerce application prototype using the MERN stack from scratch to help customers find and purchase hardware for interior and house construction in one place. The prototype was designed to function like an Amazon for hardware. Technologies used include MongoDB Atlas, JavaScript, React, Bootstrap, Node, and Express.

* Security and APIs: Incorporated authentication and authorization mechanisms to enhance security of the application. Created RESTful APIs to allow communication between the front-end and back-end systems.

Yelloclay