Sandip Agarwala

Sandip Agarwala

Followers of Sandip Agarwala1000 followers
location of Sandip AgarwalaAustralia

Connect with Sandip Agarwala to Send Message

Connect

Connect with Sandip Agarwala to Send Message

Connect
  • Timeline

  • About me

    Insurance Domain, COTS (Duck Creek, Exigen, Vantage, wmA) Specialist And Transformation Champion at Cognizant Technology Solutions

  • Education

    • Netaji Subhash Engineering College

      2000 - 2004
      Bachelor of Technology (BTech) Information Technology
    • Jitendra Lal Vidyabhaban

      1992 - 1999
  • Experience

    • Cognizant

      Oct 2004 - now

      KEY ACHIEVEMENTS IN RECENT ENGAGEMENTSBusiness Development:• In 2016 AIG floated a large RFP – Played Key Solution Architect for overall QA. RFP went for 7 months, during the time created various solution documents, and covered multiple Orals, Due Diligence. Finally won 100% QA (450 FTE) by eliminating 8 other vendors• Ramped up 350+ FTEs across various geographies within 8 weeks• Played overall Transition Director, finished successful Transition of 250+ applications within 16 Weeks • Expanded business further in last 4 years by winning 10+ other deals (28 MN Managed Service Deal,1 MN Agent Portal Creation, 2 Mn Cloud Migration, 6 MN Platform Migrations are some of the key deals)Delivery Transformation:• 50+ projects successfully transformed to Agile from Waterfall that result in 95% Agile Adoption• 100% SLA Adherence – covering 35 Stringent SLAs• 180K Positive SLA Credit in consecutive 3 Years• > 15% Productivity Improvement, resulting 10-12% FTE reduction each year• 50% Reduction in Cycle timeTechnology Transformation:• Institutionalized BDD across Bus, >50% CI-CD pipeline, 65% InSprint Automation from 0% 3 years ago• Multi-Tier Automation Strategy covering DB, Web Service/Middle Layer and UI. Another dimension from Smoke, Regression, Build Verification, Functional, End-End• 100% API Automation across BUs• Budget Neutral Automation Strategy• Implementation of Automated Accessibility Testing through AXE tool• > 500K years Hard Dollar Saving and 3 MN Soft Dollar Saving each yearSkill Transformation:• Started with 70-30 Functional to Techno-Functional Resource mix and converted the same to 15-85% Show less Project Summary: - Variable product implementation in wmA platform, GMIB Phase II, May Fund 2013, MGIR Rate Update• Effort and Cost estimation• Analyze the product Spec and Solution Spec• Working with BA and SME to gather and help preparing Business Requirement• Resource planning• Onboarding resource• Grooming resource• Prepare Test Strategy and Test Plan• Build Automation Plan• Reusability of existing artifacts• Cost Benefit analysis• Creation of daily report and Summary Report• Co-Ordination with Offshore Manager• Issue/Risk Management• Scope Management• Change Management• Version Control• Build Management• Team counseling• Preparing and Reporting of different metrics Show less Project Summary: - Retire Ease and Retire Ease Choice Product Implementation in new wmA platform, RMD Enhancement, GMIB Enhancement, Fund Simplification, Business Maintenance, Sales Illustration• Effort and Cost estimation• Analyze the product Spec and Solution Spec• Working with BA and SME to gather and help preparing Business Requirement• Resource planning• Onboarding resource• Grooming resource• Prepare Test Strategy and Test Plan• Build Automation Plan• Reusability of existing artifacts• Cost Benefit analysis• Creation of daily report and Summary Report• Co-Ordination with Offshore Manager• Issue/Risk Management• Scope Management• Change Management• Version Control• Build Management• Team counseling• Preparing and Reporting of different metrics Show less Project Summary: - StarDust Project. During the admin platform conversion, Customer came out with lot of data issue. This project was to clean all the data in the existing admin platforms before converting them to wmA platforms• Analyze all the products maintained in all the admin platform• Prepare Data Cleanup Strategy• Prepare Test Strategy and Test Plan• Build Automation Plan• Creation of daily report and Summary Report• Co-Ordination with Onsite Manager• Prepare Implementation Plan• Provide KT to the new joinees• Team counseling• Preparing and Reporting of different metrics Show less Project Summary: ULA Conversion. US based major Ins client was having 9 different legacy platforms. As part of Strategic decision and cost saving, the project was to convert all the admin platforms into 2 new admin platforms. ULA was the 1st admin platform which got converted to wmA. • Analyze all the products maintained in the ULA admin platform• Prepare conversion strategy• Prepare Test Strategy and Test Plan• Build Automation Plan• Defect Management• Creation of daily report and Summary Report• Partner with vendor to ensure timely delivery of code• Prepare Implementation Plan Show less

      • Program Test Manager

        Mar 2023 - now
      • Associate Director

        Jan 2021 - Feb 2023
      • Senior Manager - Projects

        Jul 2016 - Dec 2020
      • Manager - Projects

        Jul 2013 - Jun 2016
      • Manager - Projects

        Jul 2012 - Jun 2013
      • Senior Associate - Projects

        Jul 2010 - Jun 2012
      • Associate - Projects

        Jul 2008 - Jun 2010
      • Associate - Projects

        Jun 2007 - Jun 2008
      • Programmer Analyst

        Apr 2005 - May 2007
      • Programmer Analyst Trainee

        Oct 2004 - Mar 2005
  • Licenses & Certifications

    • ACS 100

      LOMA
    • LOMA 310

      LOMA
    • Associate, Life Management Institute (ALMI)

      LOMA
    • LOMA 280

      LOMA
    • LOMA 301

      LOMA
    • ISTQB

      ISTQB® - International Software Testing Qualifications Board
    • ACS

      LOMA
    • LOMA 290

      LOMA
    • Associate, Annuity Products and Administration (AAPA)

      LOMA
    • LOMA 356

      LOMA