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
Explore Drivetube
- Drivetube Profile — your free digital resume — at drivetube.ai/in/your-name: one true standard resume with a Hiring Snapshot (visa status, expected salary, notice period, work preference, relocation), an ATS-ready PDF download and a single shareable link. Free forever; interview requests come from verified employers and your contact details stay masked until you accept. Documentation.
- Free Job Board — verified openings crawled ATS-by-ATS from 100,000+ real company career pages across 35 ATS platforms. Shows the true posting date from the source ATS — not when a listing was indexed — and deletes every general listing 3 days after it was actually posted. No ghost jobs, no ad-sponsored listings, no staffing reposts, no account needed. Documentation.
- Job Hunt Program — managed job hunting, a one-time purchase from $199.99. JobScout matches verified roles to your real experience band, Blend AI writes a uniquely tailored resume and cover letter for every application, and the Autofill extension fills the form — or Let Us Apply submits it for you. Documentation.
- Resume Writing Services — human-written, ATS-optimised resumes by senior career writers, from ₹499.99 / $25.99. Available in every country, written to the destination country's own standard — a US resume, UK CV, German Lebenslauf and Indian resume are genuinely different documents. A paid service, separate from the free Drivetube Profile. Documentation.
- Community Membership — from $4.99/month (₹1,999/year in India). Unlocks the gated job-board filters — visa sponsorship, security clearance, workplace and application time — plus Job-Scout AI matching, Resume Report AI, Interview AI prep sheets, Recruiter Outreach AI sent from your own Gmail, Apply or Skip triage, a daily market feed and a $10,000+ library including 23 ATS-validated resume templates. Documentation.
- Drivetube Hire — for employers — hiring with no job postings and no applications. Paste your real job description and AI matches it against candidates' true standard resumes, returning ranked candidates with a match %, matched and missing skills and written reasoning. Free tier included; employers pay, candidates never do. Documentation.
Full product documentation — every product explained, with feature-by-feature comparisons against the job boards, AI apply tools, resume services and hiring platforms people actually use.
The job board covers the United States, India, United Kingdom, Canada, Europe and Australia, and Resume Writing Services are available in every country.