• Designed and built a greenfield trade reconciliation and settlement system in F#, which integrated order management systems with outside settlement vendors. Interfaces with SQL Server backend, as well as internal RabbitMQ and external IBM MQ (message queue) services.
• Worked collaboratively with development team and business side on proprietary analyst portal, which is built out on Angular, C# / F#, and SQL Server; worked on features such as rewriting and extending analyst report generation, creating custom notifications for field updates, manipulating and extending metadata system for clients, creating custom functionality on frontend, designing APIs, and other tasks.
• Developed 2 standalone projects in F# and SQL, one for ingesting external APIs and the other for loading data for compliance testing. They handle RabbitMQ messages, conduct data processing, and use database backend for status tracking and data storage; fully asynchronous and multithreaded handling of each message enables fast and efficient operations even with high data throughput.
• Created proof of concept ETL pipeline in Python to upload and transform data from local SQL servers to cloud based servers (Snowflake)
• Used and configured DevOps tools such as Git, TeamCity, Octopus, and SQL Compare to manage and automate code deployment