Healthcare Data Analyst
Resume:
Mary Lou Whitelock
Aurora, CO *****
***********@**.***
Healthcare data analyst with over 20 years’ healthcare experience Qualifications Summary
Healthcare data analyst skilled in developing and implementing queries and reports, as well as documenting and presenting information for decision-making.
Completed online Data Management, Data Analytics and Data Reporting courses for CHDA (Certified Healthcare Data Analyst) certification, candidate for certification.
Respected by managers and peers for high level of professionalism.
Excellent collaborator who cultivates a strong network of resources.
Personable with a good sense of humor and a strong sense of commitment toward success. Professional Experience
MedAssets/Vizient, Centennial, CO 11/2014 to 3/2016 Business Analyst
Supported 24 clients across various states by analyzing reports using client hospital supply utilization data and made recommendations to eight consultants as appropriate. Researched supply item lists to identify best price for the hospital, specifically cardiovascular and orthopedic implants as well as hospital surgical supplies in order to reduce the total cost of care for the hospital.
Achieved 90% compliance goal for each quarter in 2015 as member of four person Cost team; goal had never been met previously.
Generated standard statistical and analytical reports for consultants using Navigator system, MS Access and basic SQL. Performed quality control assessment, identified opportunities for improvement based on benchmark comparison data, and made recommendations to consultants as appropriate.
Established and maintained solid relationships with consultants and peers, gained their trust and support.
Earned 16 Certificates of Recognition for going above and beyond in my role. Participated in Speakeasy to enhance public speaking skills, held officer role as Sergeant at Arms. Participated in cross-training, mentoring program, and company-endorsed volunteer work. SCL Health/Exempla Healthcare, Denver, CO 5/2012 to 11/2014 Associate Application Analyst
Successfully compiled data from numerous sources and systems in order to populate six monthly report cards, including four Best Patient Experience Report Cards using HCAHPS data (Inpatient, Outpatient, Ambulatory Surgery and Emergency Department), and two nursing service line report cards (Nursing Report Card and Falls Report Card) using MS Excel 2010. Report cards utilized by C-suite and Directors at the eight hospital care sites in the SCL Health system for quality improvement. Produced reports without a drop in quality or efficiency despite my manager changing jobs while I took over her tasks.
Served as support and acted as liaison between SCL Health System and hospital care sites to ensure that customer requests and needs were met in a timely manner.
Managed monthly and quarterly NDNQI (National Database of Nursing Quality Indicators) and CHA
(Colorado Hospital Association) databases. Worked collaboratively with Chief Nursing Officers and their leaders to improve nursing outcomes. Created reports and graphs from raw data for the purpose of performance monitoring and trending. Linked reports to decrease the amount of turnaround time from 2 days to 3 hours.
Built strong working relationships with colleagues at all hospitals, with outside vendors, as well as with co-workers and superiors within the department to ensure efficient and effective problem solving resulting in a successful work environment.
Attended basic Lean class-September 2013.
Mary Lou Whitelock, page 2 of 2
Centura Health, Englewood, CO
5/2011 to 5/2012
Payer Credentialing Specialist
Lead employee who directed and coordinated a comprehensive specialized credentialing program to ensure compliance with payer credentialing requirements and delegated carrier agreements in order to meet NCQA (National Committee for Quality Assurance) requirements that are built into policies and procedures.
Reduced commercial insurance backlog for six carriers by 90% by creating a spreadsheet to track provider applications.
Key player in the process that resulted in a score of 100% in delegated credentialing file audits.
Created reports from CACTUS software using MS Access and Excel. Coordinated follow up with physicians and allied health professionals to ensure accuracy and timeliness of information submitted to carriers.
Trained employees in delegated and non-delegated credentialing process.
Built strong relationships with commercial carriers to follow up on outstanding items.
Team captain who took first place in annual Centura food drive team competition. CIGNA/Great-West Healthcare, Greenwood Village, CO 2002 to 4/2011 Autoload Analyst June 2009 to April 2011:
Utilized autoload system in order to load provider data into various computer systems as an automated mass update for various departments. This saved analysts hundreds of hours of time by not manually updating systems. Used MS Access databases to load data and validate results. Reporting Analyst 2004 to 2010:
Promoted to Reporting Analyst and created all queries, reports and dashboards for credentialing department using Hyperion 9, MS Access, CAQH (Council for Affordable Quality Healthcare), and CACTUS (Computer Assisted Credentials Tracking and Update System) software; tested and validated results in order to ensure accurate results. Created recurring reports as well as many ad-hoc reports. Results used to meet department goals and track employee performance.
Designed and developed facility database to track information in order to meet compliance standards.
Created all queries for existing delegation database. Results used to produce committee reports, track audit schedules, and assist with CIGNA integration process. Credentialing Training Instructor 2002 to 2005:
Promoted to training instructor and trained 45 new and existing staff. Created and maintained all training materials and presentations. Coordinated follow up training as necessary.
Audited staff via custom reporting and hard file review. Identified interventions or corrective actions for credentialing supervisor. Communicated with staff to identify issues and made recommendations for improvement.
Excellent communication skills-verbal, written and training, along with solid presentation skills. Credentialing Coordinator 2002 to 2003:
Credentialed physicians and practitioners for acceptance into managed care network and ongoing network participation. Ensured credentialing files contained all necessary elements to comply with NCQA regulatory standards. Acted as team lead for credentialing department. Aetna Health Inc., Denver, CO
1997 to 2002
Credentialing Consultant
Developed, implemented and managed process for verifying credentials of physicians and practitioners. Ensured credentialing files contained all necessary elements to comply with NCQA regulatory standards. Achieved 100% score on credentialing compliance statements for mock NCQA survey. Coordinated and conducted monthly credentialing committee meetings; presented average of 225 files to review committee for decision. Managed MS Access database; prepared and presented reports to Credentialing Committee and Quality Oversight Committee. Managed department in absence of manager. Education
State University of New York at Geneseo, Geneseo, NY B.A., Sociology/Spanish
Barnes Business College, Denver, CO
Certificate, Office Specialist Program
Contact this candidate