Dr. Lillian Mercer, DBA

Senior Revenue Cycle Analyst at Choctaw Nation Health Services Authority (CNHSA)
  • Claim this Profile
Contact Information
us****@****om
(386) 825-5501
Location
Denison, Texas, United States, US
Languages
  • Spanish Native or bilingual proficiency
  • English Professional working proficiency
Skills

Topline Score

Topline score feature will be out soon.

Bio

Generated by
Topline AI

You need to have a working account to view this content.
Join now
You need to have a working account to view this content.
Join now

Credentials

  • Database Administration
    Inter-American University of Puerto Rico - Metropolitan Campus
    Dec, 1999
    - Oct, 2024
  • General Lines: Life, Accident, Health and HMO
    Texas Department of Insurance
    Oct, 2018
    - Oct, 2024
  • Reporting Workbench
    Epic
    Jun, 2017
    - Oct, 2024

Experience

  • Choctaw Nation Health Services Authority (CNHSA)
    • United States
    • Hospitals and Health Care
    • 1 - 100 Employee
    • Senior Revenue Cycle Analyst
      • Jan 2021 - Present

      Blended management skills with technical expertise to provide weekly, monthly, quarterly, annual and ad-hoc consolidated reporting on key metrics to health system management. Compile and review monthly reporting packages for each assigned area while identifying areas that need further investigation prior to distribution. Use the power of in-person networking to meet regularly with assigned business and program management to review results, identify additional opportunities for analysis and communicate findings to appropriate organization personnel. Oversee the development of ad-hoc analysis tools for department heads and managers to evaluate performance, compare actual results to forecasts and provide trend analysis. Identify and research meaningful trends that require further review and analysis. Efficiently provide end users with a solid understanding of information available to them for review. Review and verify accuracy of reports and metrics generated by Business Analysts for the proper interpretation of data.

  • Jimmy John's
    • United States
    • Restaurants
    • 1 - 100 Employee
    • Franchisee Project Manager (Remote) Mercer Subs LLC
      • Dec 2019 - Present

      Implement multiple analytical techniques to streamline business transfer process, and prepare large volume of documentation to smooth franchise transfer process. Establish strong relationship through effective communication between Franchisor and Franchisee. Negotiate with multiple vendors to set up new infrastructure, and oversee periodical audits and reporting, P&L, travel arrangements, appointments, and conduct detailed research on emerging trends to enhance the business growth. Formulate On-Board documentation for new talent, including the I-9 and W-4 forms in line with health department and insurance company requirements. Lead inventory management, payroll, schedule planning for backups, and cultivate productive environment through comprehensive initiatives to achieve business success.

  • Angels of Care Pediatric Home Health
    • United States
    • Medical Practices
    • 700 & Above Employee
    • RA Coordinator
      • Oct 2020 - Dec 2020

      Establish tactful relationships through effective communication with nurses, parents, and Case Managers. Keep up to date documentation to track patients progress and reassessment needs. Effectively oversees phone calls, emails, and calendars in order to schedule a variety of reassessments according to established procedures. Develop meaningful connections with parents and Case Managers to help them comply with the designed plan of care.

  • Private Family Office
    • Financial Services
    • Executive Assistant
      • Dec 2017 - Oct 2020

      Lead attendance activities, prepare budget reports by making accurate forecasting, and showcase strong analytical influence in managing financial activities, periodical audits, and investment statements with statistical accuracy and precision. Display professional antiquates while overseeing phone calls, postal mails, emails, and calendars to ensure smooth operations. Efficiently administer travel arrangements, expense reports through effective use of computer technology.

  • JPS Health Network
    • United States
    • Hospitals and Health Care
    • 700 & Above Employee
    • EMR Report Analyst
      • Mar 2016 - Dec 2017

      Established metrics-based governance system, universes, dashboards and reports by using SAP Business Objects including Universe Designer Tool, Information Design Tool, Web Intelligence Rich Client, and BI Launchpad to ensure uninterrupted operations. Prepared reports in Hyperspace, and web intelligence reports for business users of rapidly growing business units. Led inventory reports, high volume of documentation regarding hospital certification projects, and communicated upward, downward, and laterally to resolve complex issues. Assessed test scripts, and verified results in line with SDLC steps for project completion within tight deadlines.

  • Innovative Risk Management
    • United States
    • Insurance
    • 1 - 100 Employee
    • Senior SQL Programmer
      • Aug 2011 - Jan 2016

      Built and executed enterprise data warehouse to assimilate the claims and policy data marts in a centralized environment to deliver accurate reports and electronic files for key clients. Delivered documentation of incoming data sources from third party administrators and carriers, and the outgoing data feeds from the data warehouse to meet business requirements. Established data structure of executive reporting in support of financial statements and important managerial decisions. Blended management skills with technical expertise to lead data flow and business process diagrams, ETL management analysis, and data transformation models as part of EDI re-write project to achieve specific project objectives. Directed financial monthly closing, electronic files, monthly reporting processes, and assisted executive management to formulate executive reports and multiple management reporting tools to elevate the business performance. Revitalized complex EDI processes, deployed automated data feeds by using SSIS packages in line with contractual EDI processes.

Education

  • Universidad del Turabo
    Doctorate in Business Administration, Management of Information Systems
    2005 - 2010
  • Inter-American University of Puerto Rico - Metropolitan Campus
    Master of Science (MS), Open Information Systems
    1998 - 2002
  • Universidad de Puerto Rico
    Bachelor of Science (BS), Mathematics
    1989 - 1994
  • Ramon J. Davila High School
    High School Diploma
    1986 - 1989

Community

You need to have a working account to view this content. Click here to join now