Data Modeler III at Mediquant

Loaded and integrated data from source database structures and legacy loading scripts, analyzed for best strategies to extract and load data into the target Data Ark database by modules. Collaborated with implementation consultants and clients to understand data structures and ensure alignment with project goals. Built and ran loading scripts and pipelines to populate various clinical and patient accounting modules in the Data Ark database, rendered via the Data Ark web interface. Developed automated, parameterized pipelines in Azure Data Factory and Azure Synapse to load data into Azure SQL. Implemented data transformations in DBT to load data into Snowflake. Designed and maintained PowerShell scripts to dynamically load data from server files into Azure SQL databases. Created a Power BI dashboard to monitor loading processes. Adopted CI/CD using Azure DevOps and GitLab. Developed validation scripts to identify and resolve data issues, wrote training docs, and mentored junior develope

Database Developer & SQL Report Specialist at U.S. Medical Management

Provided health care data analytics to support management, with emphasis on value-based care (VBC). Designed and implemented ETL processes (SSIS packages) for data delivery, with data-driven configuration, logging, and notifications. Designed and maintained SSIS data flows into a data warehouse. Loaded data into databases and scheduled SSIS jobs; scheduled SQL Server Agent jobs for daily data processing. Recreated Cognos and Crystal reports as SSRS reports deployed on SharePoint. Configured and maintained secure file exchange via Automate for delivery and retrieval over SFTP. Built reports on SSRS using SQL Server 2012 and updated existing reports on SharePoint. Wrote reports for EMR systems, practice management systems, service desk tickets, and phone management. Generated quality reports (HEDIS) and MIPS; used JIRA for project management and Confluence for documentation.