Abhishek Palagiri
Business Systems Analyst & Earnix Rate Testing Lead
Woodland Hills
Summary
Insurance Domain Expertise: Over 15 years of experience in the insurance industry, delivering strategic and technical solutions across rating, pricing, and product implementations with strong emphasis on testing and validation, backed by strong Data Business Systems Analyst skills in data mapping and lineage validation. Led 15+ onsite–offshore testers Validated pricing across 25+ states Supported migration of 5M+ policy records Reduced premium discrepancy defects by 30% Data Analysis & Systems Integration: Skilled in Snowflake SQL, source-to-target data mapping, data lineage validation, and enterprise data reconciliation across Guidewire PolicyCenter, A360 and FDP platforms. Guidewire Rating Expertise: Skilled in configuring and validating rating structures, rate impacts, rating algorithms, and pricing logic. Rate Order & Sequencing: Experienced in designing and validating rate sequencing logic to ensure accurate calculation order and consistent pricing outcomes. Rating Impact & Worksheet Validation: Conducted comprehensive rating impact tests and detailed worksheet/formula validations to ensure actuarial precision and deployment accuracy. Rate Table Governance: Managed creation, updates, and state-level maintenance of rating tables ensuring compliance and policy integrity. Pricing Implementations: Led end-to-end pricing rollouts integrating legacy systems with Guidewire for scalable, production-ready delivery. Earnix Integration: Leveraged Earnix ROC for pricing simulations, attribute mapping, rule configuration, and analytics across P&C products. Product Model & Rule Configuration: Applied deep understanding of Guidewire rule-based architecture to drive business outcomes. Agile Delivery Experience: 10+ years of Agile project execution with strong adherence to sprint planning, review cycles, and backlog management. Stakeholder Collaboration: Partnered effectively with actuaries, product owners, business sponsors, and technical teams to streamline requirements and accelerate execution. Onshore-Offshore Collaboration: Experienced in distributed delivery models ensuring smooth coordination, handoffs, and productivity. Documentation & Requirements Gathering: Delivered high-clarity artifacts including mockups, requirement specs, and traceability matrices. Testing Strategy & QA Leadership: Defined test scope, ensured functional coverage, and supported smooth UAT transitions.
Overview
3
3
Certifications
15
15
years of professional experience
Work History
Business Systems Analyst
Sapphire Software Solutions Inc
10.2025 - Current
- Analyze complex business requirements and convert them into detailed technical specifications, data transformation logic, and scalable data-driven solutions supporting enterprise reporting and analytics.
- Perform comprehensive source-to-target data mapping across Guidewire PolicyCenter (GWPC), A360, Operational Data Store (ODS), FDP, and enterprise reporting platforms to ensure accurate data flow, transformation, and downstream consumption.
- Develop, optimize, and maintain Snowflake SQL queries to support analytical workloads, operational reporting, data validation, and business operations.
- Conduct detailed data granularity analysis and reconciliation at the client, policy, driver, vehicle, quote, and transaction levels to validate data integrity, ensure reporting accuracy, and maintain consistent end-to-end data lineage.
- Analyze policy, driver, vehicle, rating, underwriting, claims, and incident-related data to support business reporting, operational analytics, and regulatory compliance.
- Evaluate Guidewire PolicyCenter data models, entities, and relationships to support reporting, analytics, integrations, and downstream data consumption.
- Define, document, and maintain business rules, transformation logic, technical specifications, source-to-target mappings, and end-to-end data lineage documentation to ensure transparency, auditability, and long-term maintainability.
- Collaborate with business stakeholders, data engineers, architects, and cross-functional teams to design, implement, troubleshoot, and support enterprise data solutions aligned with business objectives and governance standards.
- Maintain complete end-to-end data lineage by tracing data elements from source systems through transformation, integration, and reporting layers to ensure consistency, accuracy, auditability, and compliance with established business rules.
- Contracted to Tata Consultancy Services – Client: Farmers Insurance Group, Woodland Hills
Earnix Rate Testing Lead
Tata Consultancy Services
SAN ANTONIO, TX
01.2024 - 07.2025
- Earnix & Guidewire Integration
- Configure ROC in Earnix to support pricing strategies and sync with Guidewire.
- Align Guidewire attributes and business rules with legacy systems for consistency.
- Statewide & Countrywide Configuration
- Set up customer parameters to support state-level pricing and future changes.
- Apply Country Wide logic to efficiently replicate updates across similar states.
- Premium Validation & Analysis
- Extract, map, and validate premiums between Guidewire and Earnix ROC.
- Analyze mismatched member records to identify root causes and apply fixes.
- Compare legacy vs. Earnix premium breakdowns to resolve rating discrepancies.
- Attribute Mapping & Rule Management
- Sync legacy and Earnix attributes for seamless pricing deployment.
- Review and update ROC business rules to meet compliance and product standards.
- Cross-Team Collaboration
- Partner with actuaries, analysts, and developers to troubleshoot and enhance pricing.
- Monitoring & Performance Tracking
- Build dashboards to monitor pricing accuracy and flag anomalies in production.
- Optimized cross-departmental communication, fostering collaboration and driving efficient problem-solving.
- Executive Engagement & Advisory
- Acted as a strategic liaison for leadership, translating complex technical concepts into clear, actionable insights.
- Client: USAA Insurance – San Antonio
Onsite Rate Testing Lead
Tata Consultancy Services
03.2017 - 12.2023
- Test Planning & Execution
- Designed detailed testing scenarios aligned with business requirements.
- Built test cases derived from defined conditions to validate system behavior.
- Coordinated with stakeholders to grasp business logic and ensure proper implementation.
- Strategy & Reporting
- Formulated test strategy, planned batch execution, and participated in defect triage sessions.
- Delivered daily updates and weekly summaries capturing progress and results.
- Reviewed outcomes and initiated corrective actions to maintain high-quality standards.
- Provided consistent defect tracking and execution reports to clients.
- Project & Client Management
- Drafted project roadmaps based on client feedback and led ongoing coordination efforts.
- Ensured clarity across the team regarding objectives and scope throughout the development cycle.
- Managed resource distribution, timelines, and milestone achievement.
- Conducted sessions for onboarding, knowledge sharing, and client engagement.
- Implementation & Analysis
- Performed unit testing and deployed applications within designated areas.
- Executed in-depth evaluations to detect programming flaws.
- Translated business functionality into precise system specifications.
- Directed discussions on architectural updates, enhancements, and replacements.
- Leadership & Optimization
- Drove QA planning and leadership by aligning team capacity with timelines, mentoring team members, proactively detecting issues, documenting root causes, and enhancing user experience through collaboration and precision test execution.
- Client: Farmers Insurance Group – Woodland Hills
Test Analyst
Tata Consultancy Services
07.2011 - 02.2017
- Requirements & Planning
- Partnered with business analysts to clarify requirements, assessed applications through KT sessions, and delivered test estimates and technical design documents to clients with precision and clarity.
- Testing & Execution
- Conducted targeted testing for billing modules across diverse credit card platforms, including Amex and Discover, ensuring accurate functionality and seamless transaction handling through comprehensive validation and cross-system analysis.
- Quality & Documentation
- Ensured testing excellence by capturing key metrics, maintaining documentation for process integrity, authoring comprehensive test strategies and reports, and validating readiness through environment reviews and data checks.
- Analysis & Issue Resolution
- Spearheaded end-to-end testing and defect resolution by partnering with cross-functional teams, rigorously reviewing deliverables, and minimizing production issues through deep regression analysis and precision defect tracking.
- Offshore & Onsite Team Leadership
- Ensuring streamlined execution, strategic alignment, and consistent achievement of project goals through effective collaboration and resource management.
- Client: State Farm Mutual Automobile Insurance Company- Bloomington
Education
Master of Science - Computer Science
National Institute of Technology
Warangal06.2011
Bachelor of Science - Computer Science
Jawaharlal Nehru Technological University
Hyderabad06.2008
Skills
Property and Casualty Insurance
Pricing and Rating Strategies
Earnix Pricing Suite Expertise
Agile Expertise
Scrum Framework Knowledge
Effective Communication
Certification
Agile SAFe 5 Practitioner
Timeline
Business Systems Analyst
Sapphire Software Solutions Inc
10.2025 - Current
Earnix Rate Testing Lead
Tata Consultancy Services
01.2024 - 07.2025
Onsite Rate Testing Lead
Tata Consultancy Services
03.2017 - 12.2023
Test Analyst
Tata Consultancy Services
07.2011 - 02.2017
Bachelor of Science - Computer Science
Jawaharlal Nehru Technological University
Master of Science - Computer Science
National Institute of Technology
Best Employee award
From Client