Mahek Dave
Do Not Require Sponsorship | Business Leadership Strategy & Data Analytics | Business Intelligence & Reporting | Healthcare Domian
- Role
- Senior Business Strategy Analyst Leadership Analytics Team at IEHP
- Location
- Rancho Cucamonga, CA, US
- LinkedIn followers
- 500 followers
About Mahek Dave
Leveraging strategic vision and problem-solving acumen to deliver impactful business…
Experience
Senior Business Strategy Analyst Leadership Analytics Team
Nov 2024 — Present · Rancho Cucamonga, CA, US
Collaborate with executive leadership (VPs, CEO) and cross-functional departmental heads (Eligibility & Outreach, Enrollment, Member Services, Finance, Sales, Claims) to gather, document, and analyze data requirements for both adhoc and recurring reporting needs adhering to HIPAA rules and validating with CMS and DHCS. • Translate complex business questions into data-driven insights by performing end-to-end data analysis, including data extraction, transformation, validation, and reporting. • Utilize T-SQL in SQL Server Management Studio (SSMS) to write complex queries, create stored procedures, and automate data pipelines for enhanced reporting efficiency and scalability. • Conduct data cleaning, integrity checks, and validation to ensure high data accuracy and quality for decision-making processes. • Build advanced Excel models using PivotTables, Power Query, VLOOKUP/HLOOKUP, and formulas for departmental performance reports and membership analytics. • Design and develop interactive dashboards and KPI visualizations in Power BI to provide real-time insights into membership trends, Inflow-Outflow Membership, DHSC provisions, team productivity, and product line performance across Medi-Cal, Medicaid, Medicare, D-SNP, and Covered California. • Analyze healthcare data sources including 834 enrollment files, HEDIS metrics, and revenue datasets to generate performance reports and compliance insights. • Proactively identify performance trends, operational inefficiencies, and business opportunities through exploratory data analysis and provide actionable recommendations. • Support Old system transition to CRM Microsoft Dynamics by gathering user requirements, drafting Business Requirements Documents (BRDs), flowcharts, participating in Agile sprint reviews, executing UAT (User Acceptance Testing), and validating final implementations.
Find verified contacts for anyone on LinkedIn
Unifers gives sales teams verified emails and direct dials, enriched profiles, and outreach that lands in the inbox.
Free plan included · No credit card required
This profile is compiled from publicly available professional sources. Unifers is not affiliated with or endorsed by LinkedIn. Request removal of this profile.