Bryan Eichert Email & Phone Number

Louisville, Kentucky Area

liason with internal reporting customers to document and define analytical and reporting project requirementsmonitor production report failuresextensive development of scheduled, on demand and one time deep dive analytical reporting solutions using SQL Server Management Studio and business intelligence tools that include SQL Server Reporting Services, Oracle DB2, MS Office, and Oracle PL/SQL

Louisville, Kentucky Area

• Develop and execute metrics and analytics for Humana’s MarkePoint Retail Segmento Including, but not limited to: Owning assigned sales reports and processes for Medicare and Commercial insurance products Humana Call Center performance and sales Humana Guidance Center effectiveness and activity attendance Mailing list data pulls based on a member’s plan type and zip code being within specified radius of a Humana Guidance Center Ad hoc reporting requests as requested by MarketPoint leadership

Louisville, Kentucky Area

Shared Services Project Analyst (2010-04/2012)• Executed scheduled and ad-hoc data pulls from the Enterprise Data Warehouse using PL/SQL for the analysis and research of pharmacy claims, medication and member facing issues • Created of MS Access databases for the importation and analysis of EDW generated data, including the creation of multiple complex tables and querieso 2012 Protected Class Authorization process (3 million + authorizations entered)o Exit Reporting tracking (exiting groups requesting claims/authorization data)o IPNS Security Requests (tracking what current levels of access an associate has in IPNS)…execution of ad hoc requests against this database…including associates w/ Home Office access, requests from managers to verify an associates IPNS id and/or levels of access, and associates who do/do not have Quick Activation accesso IPNS Semi Annual Audit (CMS driven audit of all Humana associates w/ IPNS access & appropriateness of their current levels of access)• Executed data pulls from RxFocus (web based pharmacy claims retrieval tool)o member demographic informationo drug data (to include specific therapeutic class, allowed days supply/quantity)o prescriber and pharmacy information• Produced monthly production of metrics for User Acceptance Testing areao using Argus published CCB list to track number of items scheduled for installo number of items actually installedo Humana approvers (for install)o creation of QA Stats spreadsheet used to track number of items installed, number of defects reported (for each release (weekly & monthly) this information was additionally tracked & reported on a rolling monthly/quarterly/yearly basis

Louisville, Kentucky Area

Auditing of - Billing and Enrollment processes and outcomes including, but not limited to member refunds, member id cards, member addresses- Plan setup parameters- Special projects as designated by leadership

Associate’S Degree, Microcomputing, 4.0

Associate’S Degree, Paralegal Studies, 3.57

Bachelor’S Degree, Political Science And Government, 3.42