● Developed and automated the data extraction process from various Practice Management Systems using Azure Data Factory, PowerShell and Python scripts into Azure SQL Datawarehouse. This improved data availability, enhanced data integrations capabilities thereby enabling the company to leverage real-time data for strategic initiatives.● Write complex stored procedures, views, CTEs, to manipulate data representation and create data queries and logic for internal and external users. ● Introduced Git practices which increased code quality and reliability resulting in a 99.9% reduction in bugs. This also elevated team collaboration and code management, leading to an 85% code coverage rate.● Streamlined manual processes by implementing automated Power Automate flows which reduced operational costs and errors, achieved time savings and increased efficiency, allowing employees to focus on more value-added tasks.● Developed efficient data models in PowerBI and facilitated data-driven decision-making through the creation of user-friendly reports and dashboards.● Manage active directory groups and users and grant appropriate access to virtual machines, SQL databases and other azure resources.● Identified revenue and collections performance improvements through dashboards which increased revenue and collections efficiency through data-driven insights.● Work closely with various business teams like HR, Finance, Marketing, RCM, Business Development to enhance cross-functional collaboration by providing teams with tailored data representations.● Maintained ETL scripts and PowerBI reports to ensure data continuity and up-to-date reporting for informed decision-making.● Minimized disruption and downtime by proactively addressing scripts and report maintenance.● Create, maintain, and optimize resource allocation in Azure resulting in cost savings and ensuring a stable and reliable Azure environment for ongoing operations.

● Utilized best practices in developing data models and DAX measures to manipulate data into visualizations and reports.● Extracted, transformed, and cleaned data to generate datasets in addition to creating relationships and hierarchies to support consistency in analytics and visualizations.● Designed and created various SSRS reports such as sub-reports, parameterized reports, drilldown and drill through reports and dashboards using matrixes, gauges, graphs, and charts.● Optimized performance tuning using performance analyzer and other external tools such as DAX studio, tabular editor to improve performance.● Built PowerBI reports and dashboards to report Key Performance Indicators (KPI) and metrics that facilitated reporting and analysis of client’s data.● Interacted professionally with various business stakeholders to understand and analyze business problems to derive insights and recommend solutions.● Developed and maintained SSIS packages, configured the SSIS packages using C#, .NET, XML configuration file or SQL server to make data sources and other properties dynamic, and created Integration service deployment manifest for deployment to SSISDB. ● Wrote simple to complex queries to create T-SQL temporary tables, CTEs, stored procedures and views to implement medium to complex business logic for reporting and analysis purposes.

● Extracted data from multiple sources using SSIS such as Excel, SQL, Access, SharePoint, CSV into the data warehouse.● Developed and designed star schema data models for reporting purposes using SSRS.● Generated multiple Enterprise reports using SSRS from SQL Server Database and SQL Server Analysis Services Database (OLAP) and included various reporting features such as drilldowns, drill through, sub-reports, bookmarks.● Participated in daily scrum meetings with development team and senior architect.