Debug Azure Data Factory pipelines for a SQL Database warehouse. Configure and use Azure Blob Storage. Proactively find data and performance issues and communicate to DEV and BI teams. Create Python programs and scripts to check file cohesion, data variance, and show data outliers or anomalies. Create Python scripts that automate Excel file creation, with scripted formatting for ease of reading. Create dimensional models for use by Power BI. T-SQL scripting and stored procedure writing and debugging.

Create and improve speed of SSIS packages in a large-scale data environment. Learn, debug, and improve performance of Teradata queries. Troubleshoot complex procedures of multi-step ETL process. Transform monolithic bulk-load processes into smaller, parallel load processes. Use Change Data Capture to validate rows changing.

Create SSIS data extract system, which allows CareHere to export CSV and Excel file formats on any schedule (or ad-hoc) via SFTP, email, and Azure Blob Storage. Design and build import ETL processes, which allow rule-based data cleansing and data processing. Move from multiple code bases to a single code base. Design, update, and modernize many ETL processes to improve accuracy, maintainability, and speed. Create, unit test, and improve custom EMR for hundreds of clients. Diagnose and fix complex data and integration issues. Collaborate with internal and external teams to ensure data integrity. Improve database performance, debug complex SQL Server issues, and create backup and DR procedures using Availability Groups. Responsible for SQL Server administration including user configuration, performance, and backups. Configure Active Directory groups. Build and maintain HL7 message import/export using Mirth. Worked with senior leadership to establish and implement data governance principles for value and HIPAA compliance.

Build ASP.NET MVC and SQL Server-powered sites doing design, development and bug fixes. Improve user-centric and vertical systems integration and automation. Focus on building other team members' skills to foster a learning environment. Create SSIS packages to solve ETL data cleaning and validation issues. Create functions for SFTP and Encryption/Decryption of files. Create reports and dimensional models with SSRS. Create and maintain ASP.NET website. Create C# code to validate, clean, and improve SSIS package data.