Reporting Analyst
CurrentPerform quantitative and qualitative analysis of healthcare claims data using MS SQL Server & Excel.Produce ad-hoc reports for clients on utilization, enrollment, claims, administrative expenses & cost projections.Share responsibility for maintaining the data warehouse, including monitoring & troubleshooting data exchange feeds with trading partners as well as nightly warehouse refresh.Produce custom monthly reports using SQL & SSRS, delivered via secure FTP.Develop & maintain DTS & SSIS packages to exchange data feeds consisting of eligibility and claims information with Case Management, Clinical Analysis, and Pharmacy Benefit Management trading partners.Safeguard Protected Health Information (PHI) in compliance with HIPAA regulations.Produce and transmit State-mandated proof-of-coverage forms and data feeds to MA Dept of Revenue.Developed reporting interface for MaxxVault document management system using SQL Server Reporting Services.Developed a process to parse and process incoming HIPAA-compliant ANSI standard 837 claims transaction EDI file and produce a daily outbound 835 payment advice file.