Skip to content

Yuva Varnika Samudrala

Data Analyst • y***********@gmail.com • 703****514 • linkedin.com/••••• • drivetube.ai/•••••

Professional Summary

Data Analyst with 1.5+ years of experience designing and implementing Python- and SQL-based data validation, transformation, and reporting solutions for insurance claims processing. Skilled in Pandas, NumPy, SQL and Excel to improve data accuracy, automate reporting, and support stakeholders with actionable insights.

Technical Skills

Programming Languages: Python,C,Java
Web Technologies: HTML,CSS
Frameworks and Libraries: Pandas,NumPy,Matplotlib,Seaborn,Bootstrap
Databases: SQL,MySQL
Data and Analytics: Data Cleaning,Data Validation,Excel Reporting,Data Transformation
Tools and Methodologies: VS Code,PyCharm,Git,Jupyter Notebook

Work Experience

Capgemini
Software Engineer
Dec 2024 – June 2026
Worked on an insurance claims processing engagement at Capgemini, supporting data validation, transformation and reporting for claims datasets.
Tech Stack: Python, Pandas, NumPy, SQL, VS Code, PyCharm, Git, Excel
  • Built end-to-end data cleansing and transformation pipelines using Python and Pandas to standardize incoming claims data and reduce manual correction effort in downstream workflows.
  • Authored complex SQL queries and joins to extract, aggregate and update claims records for reporting and reconciliation, enabling timely stake-holder insights.
  • Implemented automated validation rules to detect duplicate and invalid claims using Pandas and SQL-based checks, preventing invalid records from progressing to settlement.
  • Automated daily and weekly claims reports by combining Python scripts with Excel outputs, decreasing manual report preparation time and improving stakeholder visibility.
  • Optimized Python processing for large claim datasets by vectorizing operations and reducing memory overhead, improving processing throughput on dev environments.
  • Participated in Agile ceremonies, conducted code reviews, and collaborated with onsite clients to clarify business rules and translate them into data validation logic.

Projects

Assurant (Claims Data Validation)
Tools Used: Python, Pandas, NumPy, SQL, VS Code, PyCharm
  • Implemented data validation rules to identify invalid and duplicate insurance claims and flagged exceptions for manual review.
  • Cleaned and transformed large claims datasets using Pandas to improve data accuracy and reduce manual validation effort.
  • Integrated SQL queries to fetch and update claim records from backend tables used for reporting and reconciliation.
  • Generated daily and weekly claim status reports for business stakeholders to track validation progress and exceptions.
  • Optimized Python code paths for handling large files and improved processing time in the development environment.
Insurance Claim Validation System
Tools Used: Python, Pandas, NumPy, SQL, VS Code, PyCharm
  • Developed core modules to validate and normalize incoming insurance claim records before ingestion into downstream systems.
  • Designed SQL table schemas and CRUD queries to store products, transactions, and claim metadata for reporting.
  • Implemented stock/monitoring-style checks adapted to claims (status tracking and threshold alerts) to flag anomalies.
  • Built reporting extracts and automated summary generation to support business decision-making.
  • Performed testing, debugging and input validation to ensure system reliability and data accuracy across test datasets.
Alternate Index Concept (Internship - COBOL / VSAM)
Tools Used: JCL, VSAM, COBOL
  • Created KSDS base clusters and implemented alternate indexes to enable multi-key access to VSAM datasets.
  • Developed COBOL programs to insert, retrieve and manage records via alternate indexes to demonstrate multiple-key retrieval.
  • Tested index-based retrieval scenarios and validated correctness of record selection across sample datasets.
  • Documented dataset structures and retrieval logic to support future reference and code reuse.
  • Worked with mainframe utilities and JCL to load and manage test data sets for demonstration.

Education

Sri Venkateswara College of Engineering, Tirupati
B. Tech in Information Technology • Tirupati • 2024

Powered by Drivetube · Create your own profile at drivetube.ai