Ing. Swapnil Janrao

Acted as liaison between business and project teams for requirements, sprint planning, and backlog grooming. Configured insurance products in Product Explorer, including dependencies, commissions, roles, and access. Managed static data, complex SQL corrections, and API/web portal needs. Built AI bot for data model/SQL support. Led user stories, BRD/FRD, UAT, KPI monitoring, and production issue resolution for motor insurance products.

Delivered full SDLC for insurance projects, from requirement elicitation to deployment. Estimated budgets and effort based on functional complexity and provided development logic. Guided team in business scenario creation to align with acceptance criteria.

Partnered with clients to gather requirements, define business scenarios, and deliver on time. Acted as SME for the Collection & Disbursement team, liaising between accounting, business events, and testing. Completed ABS L2 certification to understand insurance processes within ABS. Ensured correct postings of contracts, claims, and accounts to the general ledger across life, health, P&C, and collective insurance. Mentored junior analysts, handled reporting, risk mitigation, and stakeholder communication.

Created and executed manual/automated test cases using JIRA, HP ALM, and TOSCA. Supported test data prep through SQL and developed a VB-based tool that reduced prep time by 80%.