Dublin, Ohio, United States- Built Power BI dashboards based on the data warehouse I created, with data relating to employee’s compensation decisions and financial KPI metric data for month over month and year over year comparisons.
- Wrote processes in Power Automate, processing and editing PDF files with an Azure Python Function and interaction with our file management system. Another process reads log files, looking...
Dublin, Ohio, United States- Created a data warehouse in SQL Server for multiple Practice Management systems, including external managed data sources via API endpoints and Microsoft Dynamics 365, utilizing SSIS. Took this project on as the only developer.
- Worked with RPA software Kryon, and was brought in to help it communicate with API endpoints and to move Tax documents through an automated process. Also suggested ...
Columbus, Ohio Area- Created a claims data warehouse in PostgreSQL for aggregated health-related data, with a central designed schema that contained different aspects of details and metrics, all derived from disparate data providers. Used as the backend to Tableau dashboards and reports to be created and used by clients.
- Wrote Python scripts and libraries for processing data from CMS and other health data pro...