Subash R Junuthula

Experience

1. Sr Bi Developer

   Prime Therapeutics

   Mar 2023 — Present · Dallas-Fort Worth, TX, US

   Created SOP’s and Detail Developer Documentations on Various Projects followed CI/CD Methodology for Business and IT. Worked Extensively on STAR, CHIP and CHIP Perinate Project for Texas Medicaid and CHIP Healthcare Partnership and Commercial line of Business (LOB). Extensive knowledge in Providers, Member, Claims, Finance (Payer Domain) and Encounters.Worked on multiple interfaces through SSIS and SQL Server scripts to provide multiple outbound files to different Vendors and schedule it through SQL Agent for multiple destinations. Extensive knowledge on QNXT database which includes Plandata, Plan Integration and QCSIDB. Experience working with EDI (270/271 and 837/835) files for claims (Institutional and Professional) processing from BizTalk server via File Manager and loaded claims data into internal SQL Server database. • Worked on EDI Mapping tools and Trading Partner Configurations in QNXT for Claims Rules (CARC and RARC Codes). Worked on Claim Check Installation, Knowledge base V56,57,58,60 and Integration Wizard and experience in migrating data in different servers through claim check load. Created logging for ETL load at package level and task level to log number of records processed by each package and each task in a package using SSIS, Stored Procedures and File Logs.Responsible for Scheduling Jobs, Alerting and Maintaining SSIS packages.Worked on MS Access (.accdb) databases and loaded them into SQL Server using SSIS.Worked on OIG Data from Office of inspector General and automated the data from excel to load in to Tables for data validation compared to Datawarehouse through SSIS packages and provided sql codes to the business in verifying the Encounter data. • Worked on Implementation documents and Training Documents for Encounter, Provider and Claims Projects for Dashboards for business users to execute from QNXT and SSRS Report server. Responsible for monitoring and making recommendations for performance improvement in hosted databases.