Aarush Kotawar

• Maintained and optimized data quality (DQ) rule metadata in Collibra for data certification, addressing discrepancies, and enhancing data certification scores.
• Developed and implemented an API-driven control process to automate data comparison between Collibra and the datastore, resolving anomalies in over 3,000 rules, and categorizing them effectively.
• Automated the generation of efficacy reports using Alteryx, providing detailed summaries of rule effectiveness across various data subjects.
• Conducted comprehensive data profiling with Alteryx to assess data quality, and documented findings to support MDM, Data Quality, and Data Governance strategies.
• Developed and managed Informatica cloud applications, including Data Integration, Business 360, and Customer 360, and created accelerators for the Healthcare domain using Informatica 360 SaaS.
• Built and maintained data assets such as Business Entities, Hierarchies, Relationships, and Reference Data, and managed mappings, tasks, task flows, and projects.
• Created insightful data visualizations using Power BI to support data-driven decision-making.
• Mastered and integrated customer and supplier data to establish golden records, defining data quality rules, and performing essential data integration tasks.

• Contributed to requirements meetings and data mapping sessions to align technical solutions with business needs.
• Synthesized U.S. healthcare claims data using complex SQL queries to generate detailed reports and presentations, highlighting key business insights.
• Analyzed large datasets to identify patterns, interpret data, and provide actionable insights based on stakeholder requests.
• Filtered and cleaned data by reviewing multiple data sources and performance indicators to resolve data issues.
• Developed Tableau visualizations to analyze business flow and provide insights based on healthcare data.
• Analyzed claims data to assess time gaps between submission and payment, validating processing periods after implementing the Prior Authorization indicator.
• Achieved $380K in annual loss mitigation by implementing a project that ensured claims were reviewed for payment accuracy.
• Identified gaps in claims processing and achieved $5.9M in annual savings on inpatient claims, with Emergency Room Charges, through collaboration with the Claims Application team.
• Supported the development and maintenance of health insurance processes, including claim processing, eligibility checks, and network offerings.
• Managed business requirements, impact analysis, technical design, code changes, and end-to-end testing, including unit testing, SIT, UAT coordination, release testing, and post-install validation.

Provided updates during daily Scrum meetings as part of the Agile process.