As a Senior Backend Developer at Appvestor, I was focused on optimizing the Doralytics (reporting and analytics system) and migrating finance.appvestor.com from PostgreSQL to MySQL. My main responsibilities included:

• Downsizing AWS resources and decommissioning obsolete system components.
• Migration of application vitals from Google APIs to AWS Step Functions (SFN) and moving credentials from EFS to MySQL.
• Developing Lambda functions to calculate campaign attribution on EC2 instances.
• Migrating insertion orders from finance.appvestor.com, creating an OpenAPI specification, and implementing an Insertion Orders REST API using Python and Flask.
• Enabling data synchronization from PostgreSQL to MySQL through the aws_lambda extension, executed within PostgreSQL triggers.
• Setting up a notifications Lambda function, triggered directly from MySQL via lambda_sync.

These efforts improved resource efficiency, streamlined data workflows, and strengthened backend system functionality.