Summary
Overview
Work History
Education
Skills
Websites
Certification
Personal Information
Timeline
9b

Rishitha Kosuri

TX

Summary

Business Analyst with 4+ years of experience in healthcare, insurance, and digital payments. Skilled in gathering and documenting requirements, creating process models, and supporting UAT while also leveraging SQL, Python, Excel, Tableau, and Power BI for data profiling, reporting, and performance tracking. Adept at collaborating with cross-functional teams to translate business needs into actionable solutions that improve efficiency, compliance, and decision-making. Experienced in handling large datasets, building dashboards, and conducting root-cause analysis to provide insights that directly support business strategies. Known for bridging gaps between business users and technical teams while ensuring timely delivery of highquality deliverables.

Overview

4
4
years of professional experience
3
3
Certification

Work History

Business Analyst

MetLife
, TX
12.2024 - Current
  • Analyzed 80,000+ insurance claims using SQL and Excel, identifying 14% error in payments; collaborated with audit to recover discrepancies and update validation logic across five business units.
  • Built Power BI dashboards for underwriting metrics, automating manual report generation; reduced analyst workload by 9 hours weekly and improved visibility into pending cases and resolution times.
  • Supported UAT for Salesforce CRM upgrade, logging 70+ defects and retesting post-fixes; improved production stability by 18% after rollout and reduced downstream ticket creation.
  • Conducted gap analysis between legacy tools and new systems, reducing data duplication by 23% and standardizing data collection across six departments.
  • Created BRD and FRD for compliance workflows, capturing 65+ requirements and ensuring version control in Confluence; reviewed by regulatory team and approved within 11 business days.
  • Coordinated workshops with stakeholders and presented actionable insights, leading to quicker decision-making and reduced turnaround time for cross-department approvals.
  • Partnered with IT and product teams to align reporting logic with business rules, improving accuracy of quarterly executive dashboards used for regulatory compliance.

Business Analyst

Hexaware Technologies
, India
12.2020 - 07.2023
  • Defined 120+ healthcare business rules for claims engine, improving adjudication accuracy by 17% and enabling faster payment processing across three payer systems integrated via APIs.
  • Designed pharmacy workflow wireframes in Visio and Figma; reduced prescription fulfillment cycle time by 24% and improved handoff clarity for development and QA teams.
  • Audited EMR data for inconsistencies across pilot hospitals; resolved mismatches affecting 5.2% of KPI metrics in performance dashboards used for regulatory reporting.
  • Wrote SQL queries to extract monthly audit reports from 200,000+ rows; reduced compliance review cycle by 22% through automated exception flagging and data aggregation.
  • Facilitated UAT for three system modules covering 40+ test scenarios; ensured alignment with contract rules and reduced escalation from operations team by 27%.
  • Collaborated with senior stakeholders to prioritize backlog items and refine business requirements, leading to improved sprint velocity and reduced rework.
  • Documented workflow improvements and created training materials, enhancing adoption of new processes across three client teams.

Business Analyst

Genius SoftTech
, India
11.2019 - 11.2020
  • Documented 85+ functional requirements for digital payments system; enabled early stakeholder signoff and reduced clarification delays during sprints across dispute management and merchant integration workflows.
  • Analyzed 400K+ transaction disputes using Excel pivot tables and SQL queries; discovered 3 recurring failure trends that led to 11% drop in chargeback incidents.
  • Created detailed FRDs and workflow diagrams for onboarding modules; enabled rollout across 5 branches with customized fields to meet local regulatory and tax requirements.
  • Coordinated sprint ceremonies across QA and development teams; reduced defect leakage rate by 15% over four sprints and improved communication using JIRA and Microsoft Teams.
  • Maintained centralized change log and traceability matrix; avoided 9 weekly hours of rework by proactively tracking requirement impacts and flagging conflicts during development.
  • Assisted product team with competitive analysis of digital payment platforms, providing insights that influenced design decisions for dispute resolution workflows.
  • Partnered with business users to conduct UAT sessions, gathering feedback and ensuring alignment with regulatory compliance before deployment.

Education

Master of Science - Information Science/Studies

University of Texas at Arlington
05.2025

Skills

  • Requirements Gathering
  • BRD/FRD Documentation
  • User Stories
  • Process Modeling (BPMN/UML)
  • Gap Analysis
  • Workflow Optimization
  • Change Management
  • Requirements Traceability Matrix (RTM)
  • Functional Specifications
  • UAT Support
  • SQL (Joins, Subqueries, Aggregations)
  • Python (Pandas, NumPy)
  • Excel (Pivot Tables, Power Query, VLOOKUP)
  • R (basic)
  • Data Profiling
  • Data Cleaning
  • Data Transformation
  • KPI Tracking
  • Forecasting
  • Claims Auditing
  • SLA Monitoring
  • Tableau
  • Power BI
  • Oracle BI
  • Microsoft Excel Dashboards
  • Google Data Studio
  • Visio
  • Figma
  • Healthcare Claims Processing
  • Electronic Health Records (EHR)
  • Medicaid Policy
  • Pharmacy Workflow
  • Regulatory Compliance
  • Digital Payments & Transaction Disputes
  • JIRA
  • Confluence
  • ServiceNow
  • SharePoint
  • CRM Platforms
  • Trello
  • Git
  • EMR Systems
  • AWS
  • Microsoft Azure
  • Snowflake (basic)
  • Databricks
  • SQL Server
  • UAT Execution
  • Test Scenario Development
  • Defect Tracking
  • Root Cause Analysis
  • Regression Testing
  • Data Pipeline Validation
  • Stakeholder Management
  • Cross-functional Team Coordination
  • Requirement Walkthroughs
  • Executive Reporting
  • Client Review Sessions
  • Agile/Scrum Ceremonies

Websites

Certification

  • Microsoft Certified: Azure Fundamentals
  • Microsoft Certified: Azure Data Fundamentals
  • Introduction to AWS for Non-Engineers: Cloud Concepts

Personal Information

Title: Business Analyst

Timeline

Business Analyst

MetLife
12.2024 - Current

Business Analyst

Hexaware Technologies
12.2020 - 07.2023

Business Analyst

Genius SoftTech
11.2019 - 11.2020

Master of Science - Information Science/Studies

University of Texas at Arlington
Rishitha Kosuri