Amanda Walling Email & Phone Number

Franklin, TN

Franklin, TN

• Reporting to the CIO, supporting clinical business intelligence for Acadia's Clinical Services Department.
• Work with clinical and Information Technology teams, preparing data to support key clinical process development: report hospital performance, and work with other external entities on data issues.
• Understand and analyze hospitals’ population health, clinical productivity, key performance indicators, and operational improvement.
• Develop graphs, reports, and presentations to summarize key results, including but not limited to HBIPS measures.
• Oversee routine and ad hoc reports as needed.
• Identify opportunities for hospitals to make decisions by analyzing data gathered and to promote performance improvement.

Cool Springs, TN

• Managing components of the Coding Quality Assurance Operation including auditors that are contracted and full-time employees remotely and onsite.
• Creating the reports and performing the analytics necessary to provide recommendations and action plans to exceed client and program requirements.
• Responsible for capacity planning, production planning and project execution to meet capacity and production requirements.
• Diagnose process improvement opportunities and develop solutions using principles of process excellence and related tools.
• Ensure auditors are meeting production standards set by the department.
• Overall program and production management for specific programs and initiatives.

Franklin, TN

• Provides analyses and data-driven solutions to Fresenius Rx management pertaining to, but not limited to Fresenius Rx operational productivity, finance forecasting, clinical and quality outcomes, customer satisfaction.
• Understands and translates requests, identifying constraints and suggesting solutions related to data and reporting
• Works closely with IT Business Analyst and Finance/Operations Analyst to help structure and interpret business requests. Reviews requests and develops queries, reports, extracts, and interfaces to provide solutions and.
• Designs, develops, and tests complex SQL queries for Fresenius Rx reports, extracts, and interfaces.
• Collaborates with IT Business Analyst to document reporting/query requirements and create detailed specifications.
• Interprets data, performs quantitative analyses, and makes recommendations to Fresenius Rx management regarding findings, data collection and quality issues, and follow-up enquiries/work.

Franklin, TN

- Perform detailed data analysis to trouble shoot and identify issues by creating SQL queries and reports- Identified customer data discrepancies, new business rules, and defects in the monthly package- Troubleshoot data intake processes for multiple clients across multiple platforms- Create and update documentation for data intake processes and testing.

Greater Nashville Area, TN

• Advanced skills in analytical/problem solving, communication, presentations, organization, initiative, working independently as well as in teams, and managing and completing multiple tasks with tight deadlines
• Proficiency using advanced Excel features and techniques. Advanced proficiency with dataset application development. Experience working with a variety of information systems and data files, including large and complex.
• Proficient knowledge of Medicare Advantage terminology, CMS data files and concepts associated with risk adjustment (MMR, MOR, HCCs, and medical record diagnosis coding), medical terminology, cost components.
• Familiarity with various types and sources of health care information, including financial and patient-level data files
• Planned and facilitated meetings and presentations to staff and Executives
• Develops and analyzes functional and operational data, performance reports, and provides notations of performance deviations and anomalies

Franklin, TN

• Assign all health plan work received from internal Business Unit and Programming teams to the necessary resources while carefully balancing the workload and priorities
• Facilitate bi-weekly team meeting to keep eleven team members apprised of new corporate initiatives and goals, new incoming work, and policy or procedure updates
• Generate and audit daily sign off rotation calendar for the team
• Coordinate closely with the Implementations team to transition new health plan work to the Production Operations Team
• Conduct meetings to evaluate colleague engagement scores and derive an impact plan for improving the level engagement for the team
• Document, communicate, and distribute new processes and procedures for team

• Ad Hoc file moving requests received to the distribution group
• Monitor workflows and scheduled jobs and perform Daily Sign Off process for Legacy, Radical and Embrace
• Daily and Weekly Ad Hoc/Special Processing - loading, monitoring or processing if applicable
• Run scheduled reports on assigned accounts
• Ad Hoc documented scheduled reporting and or exports
• Manage workflows and assist team with production control assignments

Import Raw data from Health plans into the Healthways AlgorithmsStage data into the correct schemasPerform audits on data Download data to the call centersAnswer and questions from the call centers about the dataInvestigate anomalies in data using PL/SQLGenerate reports for monthly processesWork with Programmer/Developer when issues arise

Perform technical and Business analysis using MS Access, MS Excel & SQL Server Create and develop queries using SQLReport/query generation and data extracts for all Health Plan Services reporting functions including Regulatory reports to the State of Tennessee using member and provider dataDevelop and enhance automated tools for quality audits.

Answered providers inquiries via lettersEducated suppliers on coding using CPT and ICD-9 codesEducated and assisted suppliers on how to bill MedicareAdjusted claims using MCSTested the Part B Voice Response System and notified IT when problems arose

Answered incoming callsAssisted Medicare recipients with claims informationAssisted Medicare suppliers with claims information using VMSProvided technical support to suppliers on how to bill Medicare Educated Medicare suppliers about new rules and regulationsResearched and solved suppliers inquiriesTraining new hires

Answered incoming callsAssisted customers by looking up accounts on an IBM MainframeAssisted customers by accessing AS/400 to search accountsAssisted customers with their electronic ordersProvided technical support for Ingram's databases and softwareWrote and maintained reports in Microsoft ExcelTrained other associates

Master'S Degree, Healthcare Informatics

Bachelor Of Science, Computer Information Systems Minor In Art