A healthcare organization had an opportunity to take advantage of a recent drug rebate policy. However, the client needed to pull data from multiple sources, format customer claims, validate rebate eligibility and process them within their system.

Y&L built a robust ETL package for the client to pull claims from mulitiple sources and generate claims files. Claims and rebate files now seamlessly flowed through sFTP between the vendor and the client.

The processed output data is stored in their database and accurate reports can now be generated. The system now automatically consolidates claims files, dropping and picking-up from sFTP folders, exchanging information between the client and vendor systems and processing the output files.