Debbie I Avery, 75333 Legion View Dr, San Antonio, TX 78244

Debbie I Avery75333 Legion View Dr San Antonio Tx 78244 000 000

Debbie I Avery75333 Legion View Dr San Antonio Tx 78244 000 000

Debbie I Avery75333 Legion View Dr San Antonio Tx 78244 000 000

Debbie I Avery75333 Legion View Dr San Antonio Tx 78244 000 000

Debbie I. Avery 75333 Legion view Dr. San Antonio, TX 78244 | ( | [email protected] Over 15 years of various customer service support, auditing billing, accounts payable, receivable, collections, call center support, in home work support, case management, retail management, public assistance and clerical/administrative experience providing exceptional service and support in fast paced environments. Organizational and proactive with ingrained strong interpersonal skills to perform effectively and efficiently. Skilled in developing collaborative relationships with company and with clients having minor to complex needs within societies including working relationships in reference to other relevant services.

Summary of Skills · Professional, responsible with proven customer service skills · Experience in auditing, support, assessment and duties involved billing · Customer interaction, Case management and organizational skills · Responsibility for client caseloads and the privacy Usage of proper practice, procedure and intervention. Education Associates Degree: Health Information Management; Graduation 05/2012 , Bachelor Degree : Sociology and Christian Studies, Graduation Date: 10/2015, Masters: Graduate Studies, Professional Psychology, Graduation: 2019 Experience Insight Global /Superior HealthPlan 09/2017–04/2018 Provider Services · Reference current materials to answer escalated and complex inquiries from members and providers regarding claims, eligibility, covered benefits and authorization status matters. · Educate members and/or providers on health plan initiatives Provide first call resolution working with appropriate internal/external resources, and ensure closure of all inquiries · Document all activities for quality and metrics reporting through the Customer Relationship Management (CRM) application · Research and identify processing inaccuracies in claim payments and route to the appropriate team for claim adjustment Omnicare Pharmacy 07/2015 – 03/2016 Billing Specialist · Prepared and examined daily financial billing records. Ensured that financial records were accurate and that accounts were paid properly and on time. · Verified insurances and maintained all accounts receivables for facility and /or private pay. · Reviews private pay billing statements for correctness and accuracy of charges, reviewed for misstatement, billing in compliance, review errors, reports, practices · Prepared billing correspondence, including notices, denial, discrepancies and payments, · Perform census of all assisted living facilities, reviewed new patient submission to make sure all information is correct received Assures timely, accurate billing of patient describe medications Public Health and Prevention Specialist 02/2015 Health & Human Services Commission Texas Work Advisor II Case Management · Performed eligibility determinations, based on requirements for state benefits · Evaluates applicant’s eligibility, case management · Researched additional resources, for food, shelter, and clinics · Advocate and workings along-side affiliated agencies and service recipients TruGreen Lawn Care 03/2004 – Billing and Audit Specialist · Daily review internal accounts to ensure the validity and legality of the offices financial records. · Regularly monitored potential billing issues for any overcharges and or mistakes · Responsible for validating of claims payments according to contractual terms in all pertinent agreements, which requires knowledge of contractual agreements. · Understanding of alternative Office financial resources and the ability to provide information and/or recommendations related to these sources of recovery are preferred.

Paper For Above instruction

Introduction

The management at Panther Memorial hospital has initiated a series of database queries to streamline communication, improve operational efficiencies, and support decision-making processes. As a database developer, the task involves creating specific SQL queries within Microsoft Access that address management’s specific informational needs. These queries are designed to retrieve, filter, and organize data from the existing tables to facilitate quick access to relevant information, thereby improving administrative workflows and enhancing service delivery.

Analysis of Query Requirements

The first query addresses the need to identify staff members—particularly providers—who are eligible to receive birthday cards, based on their job titles and personal information. The second query aims to improve communication by consolidating provider names into a single, readable format. The third query seeks to identify midwives for targeted recognition, displaying only their names and birth dates. The final query involves identifying patients with specific name patterns, which requires wildcard text criteria and a comprehensive view of patient data.

Design and Implementation of Queries

Question 1: Sorted List of Staff for Birthday Card

The first query retrieves staff members' Job Title, Courtesy Title, First Name, Last Name, and Birth Date, sorted primarily by Job Title in descending order, and secondarily by Birth Date in ascending order. This allows the Vice President to quickly identify staff to send birthday cards, with the highest-ranking titles appearing first, and within each title, the earliest birthdays appear at the top.

SELECT [Job Title], [Courtesy Title], [First Name], [Last Name], [Birth Date]


FROM Staff


ORDER BY [Job Title] DESC, [Birth Date] ASC;

Question 2: Concatenated Employee Names with Specific Fields

The second query creates a concatenated Employee Name field combining Courtesy Title, First Name, and Last Name, separated by spaces. It retains only the Job Title, this concatenated name, and Birth Date, meeting the VP’s requirement for a compact and readable list suitable for mailing labels or personalized correspondence.

SELECT [Job Title], [Courtesy Title] & " " & [First Name] & " " & [Last Name] AS [Employee Name], [Birth Date]


FROM Staff


WHERE [Job Title] = "Vice President";

Question 3: List of Midwives (excluding Job Title in output)

The third query filters for employees with the Job Title "Midwife", but does not display the Job Title column itself, only showing the Employee Name (concatenated from Courtesy Title, First Name, Last Name) and Birth Date. This supports targeted communications towards recognized midwifery staff.

SELECT [Courtesy Title] & " " & [First Name] & " " & [Last Name] AS [Employee Name], [Birth Date]


FROM Staff


WHERE [Job Title] = "Midwife";

Question 4: All Patients with 'Liz' in First Name

The fourth query retrieves all patient data (using SELECT *) for patients whose First Name includes the string "liz", in any position, without displaying the First Name twice. Wildcard criteria using LIKE with "%liz%" enables flexible matching while avoiding repetitive fields.

SELECT *


FROM Patients


WHERE [First Name] LIKE "%liz%";

Conclusion

By carefully constructing these SQL queries, the hospital management is equipped with precise and actionable information. The queries optimize the use of bidirectional data retrieval, string concatenation, filtering with criteria, and sorting techniques. In clinical and administrative contexts, such tailored queries support effective communication, improve service targeting, and facilitate compliance with management directives, exemplifying best practices in healthcare database management.

References

  • Harrington, J. L. (2016). SQL for Data Analysis. O'Reilly Media.
  • Kroenke, D. M., & Auer, D. J. (2019). Database Concepts (8th ed.). Pearson.
  • Mitchel, T. (2018). Mastering Microsoft Access 2016. Packt Publishing.
  • Rob, P., & Coronel, C. (2009). Database Systems: Design, Implementation, & Management (9th ed.). Cengage Learning.
  • Jelen, B. (2013). Microsoft Access 2013 Programming by Example. Sams Publishing.
  • Coronel, C., & Morris, S. (2015). Database Systems: Design, Implementation, & Management (11th ed.). Cengage Learning.
  • Hoffer, J. A., Venkataraman, R., & Topi, H. (2016). Modern Database Management (12th ed.). Pearson.
  • Sebhatu, R., & Smith, J. (2020). Effective Healthcare Data Management. Elsevier.
  • García-Milán, V., et al. (2019). Applications of SQL in Healthcare Data Analysis. Journal of Medical Systems, 43(7), 177.
  • Microsoft Corporation. (2021). Access help and learning. Retrieved from https://support.microsoft.com/en-us/access

Related Assignments