Swathi Arava
Software Developer
Madison,WI
Summary
To associate with an organization, which dynamically gives me a chance to improve my knowledge, upgrade my skills and that enables me to take part in the growth of the organization.
Overview
18
18
years of professional experience
3
3
Languages
Work History
Software Developer
Symphony Corporation
09.2025 - Current
- Performed CMS ACO file QA using Databricks SQL Editor to validate CCLF, ALR, PSF, Participant, and Reference datasets after ingestion.
- Wrote SQL validation queries to check schema conformance, mandatory fields, null/blank rates, duplicates, and record-count reconciliation.
- Validated file ingestion completeness by reconciling record counts, file sizes, and load timestamps between source CMS files and Databricks tables.
- Performed schema validation to ensure column names, data types, field lengths, and formats aligned with CMS technical specifications.
- Executed cross-file reconciliation queries to verify beneficiary attribution and provider participation consistency across CCLF, ALR, PSF, and Participant tables.
- Validated code sets and business rules (ICD/CPT/HCPCS, date logic, eligibility/attribution windows) using reference tables in Databricks.
- Built reusable SQL views for standard QA checks and leveraged Databricks SQL dashboards to track data quality KPIs (completeness, duplicates, anomaly rates).
- Documented QA results, logged defects, and coordinated retesting after fixes with data engineering/analytics teams.
- Executed duplicate record detection at claim, line, beneficiary, and provider levels.
- Conducted cross-file reconciliation between CCLF, ALR, PSF, and Participant files to ensure consistency of beneficiary attribution and provider participation.
- Validated referential integrity between beneficiary, provider, and claim-level data.
- Logged data defects with clear root-cause analysis and supported retesting after fixes. Ensured compliance with CMS MSSP requirements.
- Client: Sound Physicians
Associate Architect - Health Data Integration
Wellstack AI Pvt. Ltd
02.2024 - 09.2025
- Lead analysis of complex healthcare datasets ingested from multiple clinical source systems (EHRs, labs, HL7 feeds) through Mirth Connect into Google Big Query.
- Mapped and validated raw healthcare data into a Unified Data Model (UDM) across clinical domains.
- Parsed, validated, and transformed HL7 messages (ADT, SIU, ORU, ORM, DFT etc.) into structured formats for downstream processing.
- Owned data quality, validation, and reconciliation of HL7 v2 messages (ADT, ORU, ORM), ensuring accurate and complete clinical data ingestion.
- Designed and executed advanced SQL analytics in Big Query to support clinical, operational, and regulatory reporting.
- Standardized heterogeneous clinical data into a Unified Data Model (UDM) to enable scalable, consistent analytics across patient, encounter, diagnosis, and observation domains.
- Defined and validated mapping logic between source systems, unified data models, and FHIR R4 resources (Patient, Encounter, Observation, Condition, Medication).
- Served as a subject matter expert for healthcare interoperability standards (HL7 & FHIR), advising engineering and product teams.
- Collaborated with clinical, engineering, and product teams to define data requirements and resolve data discrepancies.
- Implemented FHIR-compliant mappings and ensured adherence to interoperability and regulatory standards.
- Mentored junior analysts and reviewed analytical work for accuracy, performance, and compliance.
- Authored and maintained data documentation, definitions, and reporting standards.
- Client: Hartford Healthcare
Team Lead
Symphony Software Pvt Ltd.
02.2018 - 01.2024
- Responsible to accept the clinical data from multiple sources into patient portal through a concept of Enterprise-wide Master Patient Index of Empower.
- Responsible for setting up the interfaces by using the Mirth Interface Engine to receive the data from Third party labs to show them in the patient portal with the help of Empower.
- Will be responsible for handling the patient data like Demographics, Clinical Data, Secure messaging between the patient and physician, MU3 Reports and Scheduling information of the patient in patient portal.
- Responsible for providing the clients with the MU3 Reports generated through Tableau and handling any modifications or customizations required to those reports.
- Accept CCD’s (Clinical Data) and parse the different components of CCD to the respective tables.
- Responsible for providing customizable reports to the client as per their needs.
- Work with the Developing team and do the integration testing post the upgrades and during the Sprints.
- Work on scheduled jobs responsible to generate the process required modifications.
- Do the mirth transformations using JavaScript and XSLT.
- Give training to the new joiners on the process knowledge and monitor their work.
- Trained on the FHIR.
- Client: EMPOWER
Sr. Implementation Engineer - SME (ADC interface services and Pro Upgrades)
Sutherland Healthcare Solutions
04.2010 - 11.2016
- Leading a team of 10 resources and monitoring their KRA’s.
- Assisted team members when they have any technical challenges while performing upgrade.
- Upgrading Database Server & Application Server with the Latest Version and troubleshooting on the issue which raises while upgrading the application.
- Worked on setting up and testing the Interfaces post migrations.
- Manual testing of the applications and automating a few areas using Selenium as part of testing.
- Installing Middle -tier software for the proper dataflow between two systems.
- Hands-on experience on HL7 Messaging Standards, Database Design and Programming using SQL Server 2008/2005
- Providing outstanding client service and contributing to the organization’s mission of utilizing information technology. Identifying the areas of impact and type of changes required.
- Write and maintain accurate and current documentation regarding applications(S) supported by the team.
- Worked on window-based applications and on web-based applications.
- Responsible for the implementation of new applications, upgrades, and modifications to existing systems
- Giving live support and support users on applications, modules, and functionality.
- Providing outstanding client service and contributing to the organization’s mission of utilizing information technology.
- Create user-training materials and train the users in the use of the new system.
- Experience in performing regular Backups and scheduling tasks.
- Monitoring free space of database.
- Prepared SOP’s and checklist of the upgrade and Services process to make it simpler for the new resources to understand and perform upgrades.
- Working in tandem with support and development teams for seamless delivery of the service.
- Good exposure in the usage of Synapse, Clarity, and Salesforce and securelink applications.
- Training New hires on Interface Implementation’s.
- Remotely assisted clients with the Workflow of Interfaces.
- Remotely assisted Clients if they have any Application related issues and resolve them.
- Client: Allscripts
Sr. Implementation Engineer (Enterprise AMU)
01.2014 - 12.2014
- Implementation of Meaningful Use (MU2) components (ACDM and IR) for the Enterprise clients in test and live environment.
- Assisting team with the issues on the ACDM (Allscripts community Direct Messaging) in Touchworks application.
- Working with Development team and Allscripts team for the issue cases.
- Creating Documents of the process and sharing with the team.
- Responsible for testing the Touchworks application.
- Client: Allscripts
Sr. Interface Analyst (My Way Interface Team and Vulcan)
12.2010 - 12.2013
- Leading the team of Vulcan Interface Team with team size seven.
- Performing Quality checks for the complete team.
- Assisted team members when they have any technical challenges while testing the interfaces.
- Good Exposure on HL7 terminology
- Good exposure on applications like Rhapsody (Common Interface Engine), Allscripts Interface Engine (AIE), Allscripts MyWay and Misys Tiger.
- Test the MyWay interface configurations. Test the MyWay Interfaces and schedule the live date.
- Test the interfaces before Live and Test migration. Coordinate with Lab vendors to test the interface and make the interface live.
- Client: Allscripts
Interface Analyst (Professional Interface Team)
04.2010 - 12.2010
- Implementing the Professional Interfaces by setting up, testing, and making the interface live.
- Hands on experience with the ProPM, ProEHR and AIE applications.
- Good Exposure on HL7 terminology.
- Implemented interfaces between PM and ProEHR, ProEHR and Labs.
- Training New hires on Interface Implementation’s.
- Client: Allscripts
Junior Software developer
Progment Software Technologies Pvt Ltd.
11.2007 - 12.2009
- Involved in developing a claims module layer.
- Tested on the code functionality for a few months.
- Client: AABY
Education
Bachelor of Engineering - Electrical
Intermediate - undefined
Sri Chaitanya Junior College
S.S.C - undefined
St. Theresa’s girls High School
Skills
HL7
Timeline
Software Developer
Symphony Corporation
09.2025 - Current
Associate Architect - Health Data Integration
Wellstack AI Pvt. Ltd
02.2024 - 09.2025
Team Lead
Symphony Software Pvt Ltd.
02.2018 - 01.2024
Sr. Implementation Engineer (Enterprise AMU)
01.2014 - 12.2014
Sr. Interface Analyst (My Way Interface Team and Vulcan)
12.2010 - 12.2013
Sr. Implementation Engineer - SME (ADC interface services and Pro Upgrades)
Sutherland Healthcare Solutions
04.2010 - 11.2016
Interface Analyst (Professional Interface Team)
04.2010 - 12.2010
Junior Software developer
Progment Software Technologies Pvt Ltd.
11.2007 - 12.2009
Intermediate - undefined
Sri Chaitanya Junior College
S.S.C - undefined
St. Theresa’s girls High School