Kellie Walker Email & Phone Number

Santa Rosa, Ca, Us

• Prepared and presented monthly revenue cycle reports for multiple clients, including KPI calculations and denial analysis, which required filtering through large amount of data to find trends and potential cost savings. Prepared client reports for their journal entries and accounting records. • Built pages in Power BI for the company and clients. Used Snowflake and SQL Server Management Studio (SSMS)for building other data summaries.• Played pivotal role in transitioning all reporting data from Domo/Clarity to Power BI. Managed this year-long process with hard date deadline that helped save the company $1M in fees each year. • Utilizing my SQL skills to extract, manipulate, and analyze data from multiple sources.• Developed a high level of proficiency in Excel over several years, using advanced functions to support and streamline processes. • Developed expense forecasting models for performance improvement, identify trends, potential issues, and developed action plans

• Tracked charge lags in EMR system and developed / trained employees on error reports to improve speed of charges and identifying problems, such as wrong ICD-10 codes, incomplete documentation, and CPT or NDC errors. • Assembled monthly financial reports for statistical tracking, which included charge, payments, adjustments, bad debt, and key performance indicators. • Maintained data dictionaries in software applications, which required working with the credentialing team and providers to mitigate billing issues.• Tracked statistical data to pinpoint areas of potential improvement.

Santa Rosa, California, United States

• Provided robust reporting to facilitate executive-level decision making. • Calculated contractual allowances to estimate future payments. • Performed ad-hoc reports on regular basis. • Summarized statistical data to provide meaningful performance reports • Prepared annual budget projections for multi-specialty medical group of physicians. • Estimated payments based on governmental changes.