• Building and improving databases, acquiring data, ETL/ELT, Big Data pipelines, and deploying cloud services on projects.

• Administering infrastructure solutions to improve data models, increase data accessibility, and foster data-driven solutions for clients.

• Implementing monitoring solutions to ensure data integrity and working closely with engineers, product managers, and other stakeholders.

Working on a data intelligence platform that revolutionizes modern data stack management by eliminating technical complexity, consolidating data sources, and enriching data with business insights.

• Created ETL workflows to migrate data from Big Query to Google's internal Dremel SQL environment for use in performance dashboards.

• Developed an operations dashboard to pull data on live bugs and report on KPIs and refactored the “milestone” workflow to notify users of progress more accurately.

• Built an audience sizing dashboard solution to give stakeholders a better understanding of their markets on the “Perk” campaign project.

• Led processes to remove legacy data-importer applications from Truveris' infrastructure and replaced them with the latest Foreign Data Wrappers (FDW).

• Designed a claims reversal algorithm to identify pairs of positive and negative transactions within a dataset using PostgreSQL window functions.

• Gathered and isolated slow and problematic queries for refactoring, reducing a long-running query's runtime by 46%.

• Migrated a product database to AWS RDS MySQL instance, improving the existing data schema with proper indexing for app performance, and logged data anomalies to MongoDB.

• Recommended solutions to align with business goals, interfacing with Salesforce systems for data hygiene and matching inconsistent client CRM data through SAS macros.

• Scheduled automated data transfers on the project via Shell Scripting.

• Analyzed financial adviser markets through proprietary data models and established data feeds for clients.

• Generated ROI reports on various trade shows.

• Established and managed FTP server for secure data transfer.

• Wrote ad hoc queries and T-SQL stored procedures to meet client needs, migrating time-sensitive claims into the adjudication system.

• Handled and managed FTP data feeds from various sites, maintaining client connectivity to MEDTRX systems.

• Produced final output reports for clients using Visual Studio 2005 Reporting Services and oversaw the printing of time-sensitive claims with legal deadlines.