ETL lifecycle Management for Revenue Cycle Analytics platform

About the client:
A leading financial and clinical cloud- based BI solutions provider in the United States

Business problem:

  • Traditional processes
  • Manual interventions at every step
  • Delay in data processing
  • High Total Cost of Ownership (TCO)


Business solution:

  • Automated data cleansing and validation
  • Data warehouse
  • Star schema modeling
  • Optimization of the ETL tool
  • Performance tuning of SSIS and stored procedures
  • Error queue analytics


Process automation Business impact:

  • Optimized business processes
  • Brought about significant gain for the end client’s data ETL runtime
  • Had more than 50 percent time saved in ETL processing time and data load
  • Delivered 100 percent data accuracy
  • Ensured scalability of resources
  • Reduced cost of ownership


Tools and Technology:
SSIS, SQL Server, ASP.NET, MVC Framework