Business Intelligence Analyst
● Extracted, transformed, and manipulated 20M+ rows of cloud data using SQL, Excel, and Power BI to consolidate administrative space, operate cost, and optimize the space of building for 1,000+ clinical properties and 7,000+ providers● Reconciled and designed innovative and valuable visualizations using Power BI to manage bed inventories and room capacity across 7 regions and 50+ hospitals which enabled Executive Directors and Managers to make decisions on future assets… Show more ● Extracted, transformed, and manipulated 20M+ rows of cloud data using SQL, Excel, and Power BI to consolidate administrative space, operate cost, and optimize the space of building for 1,000+ clinical properties and 7,000+ providers● Reconciled and designed innovative and valuable visualizations using Power BI to manage bed inventories and room capacity across 7 regions and 50+ hospitals which enabled Executive Directors and Managers to make decisions on future assets management●Responsible for standardizing tools (Genesis & eBuilder) and data accuracy for trending, budget variances, purchase orders, and cash flow forecasting for use by other program analysts, regional and system leadership● Collaborated with rotation analyst and core-leaders to plan, create baselines, and build metrics for advance reporting capabilities and descriptive analytics● Provided first line support for troubleshooting for data and reporting issues as well as monitored & inspected data to evaluate quality or performance● Established great rapport with the development team and stakeholders to gather requirements/business rules and ensured they align with the client/users Show less