Research Specialist
Stars Behavioral Health Group
Jan 2021 - Current (4 years 4 months)
• Automated reporting on service utilization, finance, and satisfaction for $40MM contracts with Microsoft Power Platform: SQL ETL, Power BI Dashboards, data modelling, and Power Automate Pushed Reports.
• Designed generalized CICD ETL to integrate external data into data warehouse using Power Platform. Designed Power Automate Flows to (1) retrieve data from SFTP and SharePoint, (2) run algorithms to validate data using m and OfficeScripts, (3) create correction processes for dirty data, (4) insert into database and run final ETL with SQL agents to integrate data into existing data models.
• Modernized data collection and ETL integration with Microsoft Forms API, OfficeScripts data manipulations, neural machine translation, and SQL ETL.
• D