• DBA for all company PostgreSQL AWS RDS databases• Reviewed developer PostgreSQL PRs and suggested code adjustments to maintain high back end performance of all services• Optimized PostgreSQL code called throughout the tech stack by adding parameters to functions, rewriting heavy views, removing unneeded dependencies on plpgsql, adjusting indexes, and introducing optimizer hints where needed• Set up OpenSearch instance of ES on AWS and installed/configured Filebeat on 20+ Linux boxes to pull critical logs into Kibana per stakeholder specifications• Created preprocessing pipeline for Filebeat data to parse raw log information into usable fields using grok matching patterns and custom Painless scripts• Worked with stakeholders to create useful data visualizations in Kibana and set up alerting process to identify when issues arise on a box• Performed full database migrations via PSQL command line and AWS DMS Tasks• Set up Kafka Debezium connectors and created streaming jobs to pull in Postgres Data to Databricks via CDC in real time• Migrated code from Postgres to Databricks and wrote complex python jobs to batch in reference data at various time intervals based on need• Managed data information barriers in Databricks via Terraform, ensuring proper separation of data access by business team throughout the Data Lake

• Maintained and managed complex Jenkins ETL pipeline delivering critical, time sensitive Operational Efficiency data to business stakeholders • Created multiple T-SQL Stored Procedures involving looping, dynamic SQL, and complex conditional logic used to transform data from raw form into format needed for ingestion into Qlik Sense applications• Created archive process for key production SQL tables and deployed process with no user downtime and transparent logging to monitor progress• Continuously optimized back end processes by monitoring logical reads, adjusting indexes, and materializing sub-queries to improve performance as data volumes increase• Created and taught classes 'SQL Server for the Bloomberg Business Professional' and 'T-SQL Optimization Techniques and Tricks' to help up-skill colleagues on their T-SQL skills• Developed sustainable, scalable process for pulling unstructured data from Hive into Qlik Sense, involving exploding JSON array fields into name value pair records and repivoting to consume incrementally on the Qlik Sense side• Developed Python end points for in-house Automated Insights web application used to push key task productivity and timeliness data for stakeholder team management• Optimized Qlik Sense load scripts in various applications by removing redundancies, normalizing data, and minimizing transformations causing optimized load to break

• Developed back end (SQL Server) and front end of Qlik Sense BI applications aimed at improving worker efficiency across the organization• Created manual version control process to allow multiple users to develop Qlik Sense applications simultaneously without stepping on each other’s code • Regularly performed Qlik Sense releases from QA to Production environment• Performed extensive troubleshooting through all data layers of application to identify and address causes of missing or incorrect data• Optimized stored procedures to improve application reload times by analyzing SQL Server logical reads and execution plans• Performed QA on teammates’ code changes and identified issues to be addressed • Presented key application updates to product owner and team members at stakeholder meetings• Scheduled Stored Procedures to run automatically at regular intervals via Jenkins

Client: The Medicines Company, Parsippany NJ• Created complex SSIS dataflows in Visual Studio involving lookups, conditional logic, sql tasks, dynamic connection managers and multiple parameters/variables• Supported sales team with ad hoc queries and automated weekly reports run through SQL Server Agent• Performed database backup/restores on local and cloud servers • Migrated local SSIS integration packages to SAP S/4HANA Cloud Integration Platform • Developed and maintained SSRS reports using Visual Studio • Maintained version control for all local data flows and reports using Git

• Wrote fTbl functions and stored procedures used in our client facing application involving advanced conditional logic, multiple loops, and customized string parsers• Created automated jobs to pull data from DB at regular intervals and scheduled delivery to stakeholders via SQL Server Agent using SQL Server Email and Command Shell BCP functionalities • Wrote and automated stored procedures used for regular database cleanup and maintenance tasks • Regularly performed database staging and production releases• Wrote data conversion scripts to assist onboarding team in quickly absorbing and integrating new client data • Used SQL Server Profiler to identify and fix application issues in all environments and performed hot fixes to production

• Performed full migration of internal corporate data from Microstrategy BI Tool to Looker • Turned specific data requests from various internal teams into Looker dashboards, charts, and graphs with filterable inputs • Wrote SQL to generate complex persistent derived tables in Looker from tables in attached MySQL and Redshift databases and scheduled these tables to rebuild nightly• Supported internal and external clients with ad hoc data pulls, Looker 'Look' creations, and daily email scheduling • Educated fellow colleagues and supervisors on Looker functionality and usage

• Wrote scripts to pull data from Vertica and Oracle dbs into SQL Server environment for multiple reporting tools to access• Applied user specific calculations and logic to imported data sets and assisted users in making sense of this data• Created dynamic reports returning different data sets depending on run date• Wrote and adjusted complex stored procedures with multiple case statements and joins• Rewrote old quarterly data code to change dynamically, eliminating the need for manual quarterly code updates• Wrote code to automate reports that were previously made in excel with pivot tables and vlookup formulas• Regularly utilized programming techniques in stored procedures such as dynamic SQL, looping, and database triggers

• Imported raw client excel files into SQL Server and cleaned up data to account for misspellings and name variations• Mapped imported data to existing DB tables and modified fields to meet table requirements• Created stored procedures and fVal functions to increase data conversion speed and accuracy• Developed custom validation scripts to check converted data for accuracy against raw files