Noelle Rao

Experience

• 

  UPMC

  Feb 1996 - Mar 1998

  Data Manager/Analyst

  • Managed clinical data for the Psychological and Neuropsychological Assessment Program.• Modified existing databases for patient records, publications, and fiscal accounts.• Managed clerical staff including hiring, assigning work, job training, performance appraisals, and pay increases.• Maintained finances for the Neurobehavioral Studies program and the Psychological and Neuropsychological Assessment Program including budgeting, purchasing, and expense reports.• Prepared and edited grant applications, IRB submission and manuscripts. Show less

• 

  Highmark Inc.

  Jun 1998 - Dec 2017

  • Develop and maintain moderate to complex computer programs using 4GL programming languages (SAS 9.2, SQL) and other database technology (DB2, Teradata, and Oracle).• Analyze health care cost and utilization trends, clinical and condition management, health care cost containment, quality measurement, and general research and decision support activities.• Develop and foster internal relationships across the corporation. Provide analytic and consultative support to internal customer areas and external business partners.• Mentor less experienced analysts through all stages of project design and analysis.• Provide assistance and interpretation of raw data, statistical results, identify follow-up action items and assist in the preparation of written reports.• Support corporate projects through all phases of the Software Development Life Cycle such as requirements, design, programming, testing, and implementation. Show less • Utilized project management methodologies, as an individual contributor and/or project lead on medium to large-sized projects, to produce project deliverables.• Analyzed complex data processes, business processes and interfaces to support Payment Policy and Reimbursement Management, Claims Services and Information Technology divisions.• Designed and implemented new reimbursement methods for new hospital contracts. Provided direction and analysis for forty existing Highmark hospital reimbursement methods.• Developed, maintained and monitored project plan and deliverables using SDLC documentation and Microsoft Projects software. • Coached, consulted and mentored team members on moderate to complex business/systems processes.• Provided estimates for departmental and strategic initiatives. Show less • Oversaw Blue Cross Blue Shield Association mandated projects from an operational perspective.• Led implementation of a new Blue Cross Blue Shield Web based application.• Liaison between Highmark and Blue Cross Blue Shield Association.• Managed projects based on the Software Developmental Life Cycle.• Monitored project budget and estimates.• Facilitated project status meetings.• Created project test plans.• Coordinated sign off procedures throughout the Software Developmental Life Cycle. Show less • Oversaw all quarterly projects for the Claims Services division through the design, analysis, coding, unit testing, acceptance testing, implementation and post implementation phases.• Analyzed existing department procedures and processes, recommending changes to aid in project support.• Functioned as a liaison between business analysts, systems analysts, management and customers.• Analyzed, designed, and coded the Lotus Notes database. The database stored all change requests for the claims payment system and supporting systems.• Facilitated meetings for quarterly project statuses, customer walkthroughs, system defects and project scheduling.• Managed all projects through various processes such as scheduling, appeals, delays and date changes.• Conducted project planning meetings 3 times per week. Participants negotiated project hours, cost, business/systems support, and implementation and research dates. Show less • Analyzed, designed, coded, unit tested and implemented changes to new and existing claims payment applications. These systems are written in COBOL with interfaces to DB2 and IMS databases.• Evaluated system functionality, performance tuned, and applied software upgrades to claims payment applications. • Prioritized numerous system issues of varying severity and effectively managed the resolution of all issues above acceptable service levels.• Provided excellent customer support, which included the creation of technical specifications, responsive follow-up, and advocacy for customer issues within the Claims Services division. • Interacted extensively with developers, managers, database administrators and data center technicians to resolve systems issues. • Coded ACF2 security to ensure compliance with internal and external standards. Show less • Functioned as a liaison between the customer and systems areas to define and create business process flows, specifications, and data requirements for future systems enhancements.• Led the conversion from the existing authorization/referral database to two new Oracle databases. Provided overall project management and coordination for users, systems analysts and the external behavioral health vendor.• Designed, supported and tested the implementation of system enhancements for claims payment applications and IMS/DB2 databases.• Analyzed and resolved critical systems issues for the CompIV claims payment system and the referral/authorization database. • Managed implementation of all corporate initiatives related to Accounts Receivable and Routing software.• Assisted in monitoring, documenting and clarifying system changes for audit.• Managed all aspects of the Provider Number Expansion project for the CompIV claims payment system. Responsibilities included analysis, design, testing, post implementation support and interaction with multiple departments. Show less

  • Senior Decision Support Analyst

    Jul 2014 - Dec 2017

  • Decision Support Analyst

    May 2012 - Jun 2014

  • Business Analyst

    Apr 2008 - May 2012

  • Technical Business Analyst (Project Lead)

    Apr 2007 - Apr 2008

  • Technical Business Analyst

    Nov 2004 - Apr 2007

  • Programmer Analyst

    Jun 2001 - Oct 2004

  • Business Staff Analyst

    Jun 1998 - May 2001
• 

  PNC

  Feb 2018 - now

  • Assistant Vice President, Business Systems Analyst Consultant

    Feb 2021 - now

  • Business Systems Analyst Consultant

    Feb 2018 - Feb 2021