System Data Analyst
• Extracted and analyzed complex Electronic Health Record (EHR) datasets to uncover valuable insights and trends, contributing to data-driven decision-making and improved patient care outcomes.• Employed advanced functions and formulas in Excel to conduct data analysis, identify trends, and forecast healthcare utilization and cost containment strategies.• Utilized Power BI trend analysis capabilities to identify patterns and predict future trends, supporting business teams in proactive decision-making.• Analyzed demand patterns, consumption trends, and lead times using SQL queries and advanced statistical techniques, providing actionable recommendations for inventory replenishment and procurement strategies.• Leveraged data visualization tools such as Power BI and Tableau to effectively communicate complex data insights and facilitate data-driven decision-making.• Created Tableau dashboards and reports to facilitate easy visualization and analysis of key financial metrics in healthcare claims.• Wrote SQL queries involving sub-queries, joins, and aggregations to retrieve data from legacy databases.• Utilized SSIS to manage data encryption and decryption, ensuring compliance with data security to secure sensitive healthcare information.• Created and customized PivotTables to analyze large datasets and extract meaningful insights, enabling informed decision-making.• Documented database management procedures and standards to ensure consistency and compliance with regulatory requirements.• Designed interactive dashboards and reports using Excel's advanced features, such as conditional formatting, data validation, and dynamic charts.• Partnered with data governance, data stewards, and subject matter experts to create and maintain business definitions.