Senior Business Analyst
Current- Engineered SQL databases and tables to store and manipulate patient and provider data for 60 entities, ensuring data integrity and security under HIPAA guidelines. Managed datasets from emergency departments in Los Angeles County, hospitalist departments, anesthesiology centers, and inpatient/outpatient mental health services across multiple states.- Developed a reporting platform in Tableau for daily C-suite utilization, tracking key financial and volume metrics. Implemented nontraditional Tableau methods to create a function to alert stakeholders when collections fell below an acceptable standard deviation based on historical trends. Delivered a mobile-friendly version for on-the-go access to metrics.- Utilized SQL and Tableau to engineer a KPI reporting platform that is utilized by 1000s of physicians and medical staff to reference their KPIs, individual and group performance based on staffing, billing, and encounter data.- Created financial models and pro forma analyses for prospective acquisitions or clients to determine profitability of initiating a relationship with a new hospital or business lines.