PHP Agency -Bamboo:•Designed and implemented a PostgreSQL database schema which included creation of tables, user defined table types, stored procedures, triggers, views, constraints, user defined functions, and indexes using T-SQL. •Developed, ran, and tested complex SQL queries against sales, management and hierarchical data to create high-level business reports for clients’ profit and production evaluation using PostgreSQL.•Performed data mapping and data migration using psql shell scripts and ETL tools to migrate data from multiple legacy applications.Lockton –RxMart and Stop Loss CMS:•Responsible for setting up, managing, and communicating the schedule, scope and budget of projects using project management software: Atlassian Jira, Confluence and Microsoft Project.•Created User Acceptance Testing (UAT) plans, test summary documents, conducted end-to-end integration testing and assured software delivery met requirements.•Created data dictionaries and mapping layouts using Sertics (in-house application) to load PHI claims data from several carriers into Vertica database to run trigger reports.•Installed, maintained, and scaled PostgreSQL and MySQL databases hosted remotely on AWS Relational Database Services (RDS).