benefitrelay bazzini consulting, llc
TRANSCRIPT
benefitRelaybenefitRelay
Bazzini Consulting, LLCBazzini Consulting, LLC
http://www.BazziniConsulting.comhttp://www.BazziniConsulting.com
Copyright (c) Bazzini Consulting, 2006 - 2008Copyright (c) Bazzini Consulting, 2006 - 2008 22
benefitRelaybenefitRelay Features Features
Electronic Data Exchange of enrollment & Electronic Data Exchange of enrollment & eligibility data with Insurance Carrierseligibility data with Insurance Carriers
Reconciliation of Bills, Claims, and Census DataReconciliation of Bills, Claims, and Census Data Creation of monthly self bills Creation of monthly self bills Data Warehouse for Reporting and AnalysisData Warehouse for Reporting and Analysis
Copyright (c) Bazzini Consulting, 2006 - 2008Copyright (c) Bazzini Consulting, 2006 - 2008 33
Electronic Data ExchangeElectronic Data Exchange
Deliver enrollment & eligibility data electronically to Deliver enrollment & eligibility data electronically to insurance carriersinsurance carriers
HIPAA X12 834HIPAA X12 834 Proprietary formatsProprietary formats
benefitRelaybenefitRelay can connect directly to and extract can connect directly to and extract enrollment data from any existing HRIS in real-timeenrollment data from any existing HRIS in real-time
Electronically connect any enrollment source to any carrierElectronically connect any enrollment source to any carrier benefitRelaybenefitRelay can also load data from hosted systems can also load data from hosted systems
or third party administratorsor third party administrators All formats supported – if it’s in an electronic format, All formats supported – if it’s in an electronic format,
benefitRelaybenefitRelay can load it! can load it!
Copyright (c) Bazzini Consulting, 2006 - 2008Copyright (c) Bazzini Consulting, 2006 - 2008 44
Electronic Data ExchangeElectronic Data Exchange
One-click file generation for your carrier
Quick link to carrier web site for file delivery
Enrollment summary for current or any previous enrollment period
Copyright (c) Bazzini Consulting, 2006 - 2008Copyright (c) Bazzini Consulting, 2006 - 2008 55
Connect directly to your HRIS or import Connect directly to your HRIS or import data from your third party administratordata from your third party administrator
benefitRelay extracts all necessary enrollment & eligibility data from your HRIS as of the selected date and stores it in the benefitRelay data warehouse, locking down a copy of exactly what was in effect as of the selected date
Alternatively, you can import enrollment & eligibility information from XML, Access, Excel or ASCII files
Copyright (c) Bazzini Consulting, 2006 - 2008Copyright (c) Bazzini Consulting, 2006 - 2008 66
Claims &Billing
Connect any enrollment source to any carrierConnect any enrollment source to any carrier
Enrollment &Eligibility
benefitRelay
Data Warehouse
CeridianHR/PayrolleSource
ADPUltiProAbra
PeopleSoftOracleSAP
SHPSEmployeaseHewitt
Blue Cross
Aetna
VSP
Cigna
Input•Real time connection
•XML data
•Excel file
•ASCII data
•SQL Query
Output•HIPAA X12 834
•Vendor Proprietary
•XML
•Excel
Billing & Claims files•Vendor Proprietary Formats
Examples of benefit enrollment sources
Examples of target Insurance Carrier
Copyright (c) Bazzini Consulting, 2006 - 2008Copyright (c) Bazzini Consulting, 2006 - 2008 77
Carrier ReconciliationCarrier Reconciliation
benefitRelaybenefitRelay allows you to identify adds, allows you to identify adds, changes, terminations and missing data changes, terminations and missing data beforebefore sending to the carriersending to the carrier
benefitRelaybenefitRelay can load bill files, claim files, and can load bill files, claim files, and census roster files and instantly compare them census roster files and instantly compare them to the enrollment data in your HRISto the enrollment data in your HRIS If your carrier can give you an electronic file, If your carrier can give you an electronic file,
benefitRelaybenefitRelay can load it! All formats are supported can load it! All formats are supported
Copyright (c) Bazzini Consulting, 2006 - 2008Copyright (c) Bazzini Consulting, 2006 - 2008 88
Carrier ReconciliationCarrier Reconciliation
Employee detail is readily available, along with “drill down” of additional information including history and covered dependents
Quickly identify new enrollments (“Adds”), terminations (“Terms”), and any employees that were expected but missing compared to the previous period. Reconcile your enrollment data before you send it to the insurance carrier!
HyperlinkClick for more info
Copyright (c) Bazzini Consulting, 2006 - 2008Copyright (c) Bazzini Consulting, 2006 - 2008 99
Carrier ReconciliationCarrier ReconciliationbenefitRelay can create a side-by-side comparison in Excel of your enrollment data and the carrier list bill! Two-way matching provides quick identification of
•Enrollment data your carrier has that you don’t (premium overpayment)
•Enrollment data that you have that your carrier doesn’t (missing covered employees)
Match/No MatchRed for employees that
don’t match up, Green forthose that do
Side by Side ComparisonLine up your enrollment dataside by side with data from
your insurance carrier
Insurance CarrierData
Your EnrollmentData
Copyright (c) Bazzini Consulting, 2006 - 2008Copyright (c) Bazzini Consulting, 2006 - 2008 1010
Data Warehouse Reporting & AnalysisData Warehouse Reporting & AnalysisbenefitRelay keeps a copy of all enrollment data that is never changed or deleted. Full historical data is available for reporting and analysis.
One-click access to enrollment data delivered in Excel format. List Bill can be customized for each carrier and contain any information you require
Copyright (c) Bazzini Consulting, 2006 - 2008Copyright (c) Bazzini Consulting, 2006 - 2008 1111
Additional CapabilitiesAdditional Capabilities Once implemented, many customers have found that Once implemented, many customers have found that benefitRelaybenefitRelay
is an ideal platform for many other HR/Benefit/Payroll purposes:is an ideal platform for many other HR/Benefit/Payroll purposes: Total Compensation StatementsTotal Compensation Statements: a custom solution was delivered that : a custom solution was delivered that
uses an extended version of the uses an extended version of the benefitRelaybenefitRelay data warehouse to data warehouse to generate and store all data required for a Total Compensation generate and store all data required for a Total Compensation Statement, and also output a fully customized personalized statement Statement, and also output a fully customized personalized statement that can be easily updated using MS Office toolsthat can be easily updated using MS Office tools
Payroll Analysis and ReportingPayroll Analysis and Reporting: another customer asked if : another customer asked if benefitRelaybenefitRelay could help them get more useful reports out of their could help them get more useful reports out of their payroll system, resulting in an advanced payroll analysis modulepayroll system, resulting in an advanced payroll analysis module
Other HR system connectivityOther HR system connectivity: many customers have found that : many customers have found that benefitRelaybenefitRelay can just as easily send and receive data from other “best can just as easily send and receive data from other “best of breed” HR products, including Payroll, Recruiting, Performance of breed” HR products, including Payroll, Recruiting, Performance Evaluation, Pension and EAP, among othersEvaluation, Pension and EAP, among others
Copyright (c) Bazzini Consulting, 2006 - 2008Copyright (c) Bazzini Consulting, 2006 - 2008 1212
benefitRelaybenefitRelay Results Results
Proven resultsProven results Documented savings of up to 3% - 5% of annual premiumsDocumented savings of up to 3% - 5% of annual premiums Dramatic decrease in time spent managing insurance carriersDramatic decrease in time spent managing insurance carriers Substantial increase in accuracy and timeliness of enrollment & Substantial increase in accuracy and timeliness of enrollment &
eligibility information to all carriers from a single source of dataeligibility information to all carriers from a single source of data Single source of data ensures consistency across all carriersSingle source of data ensures consistency across all carriers Platform for plan analysis and ad-hoc reportingPlatform for plan analysis and ad-hoc reporting Complete audit history to document and quickly resolve Complete audit history to document and quickly resolve
enrollment issuesenrollment issues Satisfied customer references availableSatisfied customer references available
Copyright (c) Bazzini Consulting, 2006 - 2008Copyright (c) Bazzini Consulting, 2006 - 2008 1313
Case Study: Take Two InteractiveCase Study: Take Two Interactive
(Creator of Grand Theft Auto)(Creator of Grand Theft Auto)
EnvironmentEnvironment Previous administrator fired, T2 needed full implementation fast - before Previous administrator fired, T2 needed full implementation fast - before
next billing cycle (4 weeks)next billing cycle (4 weeks) benefitRelaybenefitRelay implemented for 5 carriers, including electronic bill implemented for 5 carriers, including electronic bill
reconciliation and consolidationreconciliation and consolidation Connected with UltiPro (hosted by UltiPro) using standard Cognos reporting Connected with UltiPro (hosted by UltiPro) using standard Cognos reporting
tools to output data in Excel formattools to output data in Excel format Connected with 5 carriers in four weeks by working very closely with carriers Connected with 5 carriers in four weeks by working very closely with carriers
and consultant through development and testing phases, minimal customer and consultant through development and testing phases, minimal customer HR and IT involvementHR and IT involvement
Created monthly summary bills with complete accounting/GL integration Created monthly summary bills with complete accounting/GL integration without missing a premium bill due datewithout missing a premium bill due date
Automated reconciliation of monthly list bills immediately identified Automated reconciliation of monthly list bills immediately identified substantial premium overpayments and ineligible coveragessubstantial premium overpayments and ineligible coverages
Data security and integrity imperative – benefitRelay has helped identify and Data security and integrity imperative – benefitRelay has helped identify and resolve many UltiPro data and configuration issuesresolve many UltiPro data and configuration issues
Copyright (c) Bazzini Consulting, 2006 - 2008Copyright (c) Bazzini Consulting, 2006 - 2008 1414
Case Study: Take Two InteractiveCase Study: Take Two Interactive
(Creator of Grand Theft Auto)(Creator of Grand Theft Auto)
ResultsResults Began project 4/30, all carriers in full live production by 7/1Began project 4/30, all carriers in full live production by 7/1 Billing reconciliation for all carriers in place by 5/30Billing reconciliation for all carriers in place by 5/30 No interruption in enrollment processing or billingNo interruption in enrollment processing or billing Immediate improvement of data accuracy – many account/structure and setup issues Immediate improvement of data accuracy – many account/structure and setup issues
with carriers identified and correctedwith carriers identified and corrected Immediate improvement in billing accuracy – premium credits identified and verified Immediate improvement in billing accuracy – premium credits identified and verified
within first billing cyclewithin first billing cycle Immediate improvement in UltiPro configuration and data accuracy – many specific Immediate improvement in UltiPro configuration and data accuracy – many specific
employee data issues cleaned up, several significant UltiPro setup issues found/fixedemployee data issues cleaned up, several significant UltiPro setup issues found/fixed All carriers are now receive data from the same source – major improvement in data All carriers are now receive data from the same source – major improvement in data
integrity and consistency. Issues now fixed once in a single place, ensuring all integrity and consistency. Issues now fixed once in a single place, ensuring all carriers have accurate and timely informationcarriers have accurate and timely information
Consolidated bill is far more flexible than previous solution – accounting can easily Consolidated bill is far more flexible than previous solution – accounting can easily group and view billing information in unlimited ways using standard Excel pivot tablegroup and view billing information in unlimited ways using standard Excel pivot table
Copyright (c) Bazzini Consulting, 2006 - 2008Copyright (c) Bazzini Consulting, 2006 - 2008 1515
Case Study: Take Two InteractiveCase Study: Take Two Interactive
(Creator of Grand Theft Auto)(Creator of Grand Theft Auto)
““Show me the money”Show me the money” Within 4 weeks of implementation, Within 4 weeks of implementation, benefitRelaybenefitRelay was directly was directly
responsible for identifying and documenting enrollment and billing responsible for identifying and documenting enrollment and billing issues that resulted in the following premium credits:issues that resulted in the following premium credits:
Medical Provider: $140,000 credit issuedMedical Provider: $140,000 credit issued Dental Provider: $13,000 credit issuedDental Provider: $13,000 credit issued Life/AD&D/LTD provider: $20,000 credit issuedLife/AD&D/LTD provider: $20,000 credit issued
What makes the above numbers even more amazing is that the What makes the above numbers even more amazing is that the client had a professional employee benefit services firm managing client had a professional employee benefit services firm managing their enrollment and billing data directly with each carrier!their enrollment and billing data directly with each carrier!
Copyright (c) Bazzini Consulting, 2006 - 2008Copyright (c) Bazzini Consulting, 2006 - 2008 1616
Partial Vendor ListPartial Vendor List
A few of the vendors A few of the vendors benefitRelaybenefitRelay has connected with: has connected with:
Copyright (c) Bazzini Consulting, 2006 - 2008Copyright (c) Bazzini Consulting, 2006 - 2008 1717
Partial Customer ListPartial Customer List
A few of the clients that have realized the value of A few of the clients that have realized the value of benefitRelaybenefitRelay::
Copyright (c) Bazzini Consulting, 2006 - 2008Copyright (c) Bazzini Consulting, 2006 - 2008 1818
benefitRelaybenefitRelay – More info – More info
For more information and pricing:For more information and pricing:
Robert BazziniRobert Bazzini
Bazzini Consulting, LLCBazzini Consulting, LLC
(610) 696-3311(610) 696-3311
[email protected]@BazziniConsulting.com
http://www.bazziniconsulting.comhttp://www.bazziniconsulting.com