Salil Agarwal Email & Phone Number

Pune, Maharashtra, India

Working as Engagement Manager and Lead BA on managed services Prod Support program for leading US Insurer/ Reinsurer supporting their suite of 50+ business critical Policy/ Claims/ Billing applications.

Working as a Senior Business Analyst for a US P&C insurer to support document management for Guidewire implementation. Responsibilities include:• Develop and maintain the inventory of Insurance policy forms, documents and letters• Review the Guidewire product model and analyze the coverages & coverage terms defined in product model• Develop the design specifications for Smart Communication (Thunderhead) document templates• Document the business rules for triggering the generation of policy forms and documents• Document the FTP specifications for sending the files to external systems• Identify the variable/prefilled data elements on the policy documents to assist in designing the Thunderhead data-model• Creating integration specifications and analyzing data processing problems, performing data gap analysis for downstream and interface systems, translate the Guidewire functional and interface requirements• Working with Guidewire policy admin and verifying/using the Guidewire XML for preparing the data mapping requirements for integrations• Prepare flowcharts and wireframes for programmers or architects to use when building the system• Maintain the requirements artifacts on Project SharePoint site for stakeholder’s access and future reference

Worked as a Lead Business Analyst for a leading US P&C insurer on their legacy modernization projects. Responsibilities include:• Discussion with business team to understand the current workflow of the applications• Work on the existing applications and current portal to understand the current functionality and screen flow• Document the current state flow of Data Depot and Form station applications• Identification of gaps, challenges and pain points in the As-Is process• Creating detailed requirements including UI mockups, identifying fields on screen, capturing validation rules• Functional testing of the new Form station forms created on existing portal• Provide overall project health and percent complete status• Provide information/update on open issues and open risks in project• Work closely with client stakeholders to answer any query related to application and requirement• Working with developers to have the issues fixed and retested

Worked as a Scrum Master & Business Analyst for a leading global consulting major on a project for their Australian Pension members to enhance the existing web portal and mobile app for their different clients. Responsibilities include:• Estimating and planning the work across the different release cycles with the project team• Interacting with client business for capturing the requirements to support enhancement for Pension members• Creating functional specification documents and user stories• Capturing the data specifications for the different UI fields including validations and default values• Walking the team through the requirements specifications and clarifying questions from developers and testers• Helping the team prioritize and focus on the tasks at hand• Keeping the client management updated with weekly status reports• Functional testing for the client portal and mobile apps for Android/IoS

Working as a Consultant with analytics team using the L&T analytics platform MOSAIC to build insurance solutions on Smart Underwriting and Connected Insurance. Responsibilities include:• Gathering requirements from internal stakeholders and understanding the concerns of customers for building the Insurance solutions• Coordinating with stakeholders to create real-life type insurance data to be used for creating analytical models• Research on possible solutions to be offered by going through industry reports/ reference material on web-books and getting insights from our partners• Capturing the requirements to be implemented in MOSAIC around the different data flows, internal & external data stores, data cleansing/ massaging/ conversion/ masking• Explaining the solution requirements and working with development team to have the solution build• Validating the built models• Integration of MOSAIC with internal underwriting platform and other third party vendors for demonstrating the solution to customers• Designing and creation of user dashboards for data visualization using tools such as Microsoft Power BI• Interacting and presenting the solutions being created with internal sales team, existing customers & prospects• Tracking and reporting the weekly solution built status with the management• Solution demos and training on built solutions for end customers

Pune Area, India

Working as a Senior Business Analyst for a leading Canadian insurer on a project to currently for moving auto insurance business onto Duck creek platform. Responsibilities include:• Estimating and planning the work across the different iterations with the project team• Interacting with client business for capturing the requirements to support auto business for small market • Creating functional specification documents and corresponding user stories in TFS• Capturing the data specifications for the different UI fields including validations and default values• Identifying the similarities and differences on the currently supported P&C business line and to be added auto business line on Duck Creek• Mentoring other Bas on the team and helping developers and testers with requirement related queries• Helping the team prioritize and focus on the tasks at hand• Keeping the management updated with weekly status reports

Pune Area, India

Working as a Business Analyst for a leading US based P&C insurance products company on a project to build new interfaces for one of their key customers. Responsibilities include:• Facilitating and running the client meetings – for daily touch-points, weekly status calls, query resolutions, walk through & reviews• Creating requirements documents based on the existing third party vendor interface documents and layouts received for the new interfaces to be migrated over to the claims system• Identifying the source to target database mapping for the existing fields to new claims system database fields• Identifying the gaps on existing claims database fields which are not present in new claims system and requesting the mapping• Identified issues with developed interfaces during integration and user testing• Appreciated by client business team for completing data mappings for critical & complicated ISO claim search interface within couple of weeks• Mentoring other BAs on the team and helping developers and testers with requirement related queries• Proposed logic for data comparison for matching vendor files which was appreciated by senior architect• Identified gaps in requirements and design for already delivered interfaces which were yet to go to production during review exercise which was appreciated by management.• Helping the team prioritize and focus on the tasks at hand• Keeping the management updated with weekly status reports

Pune Area, India

Working as a Scrum Master for an agile team of 9 spread across geographies for a leading US based insurer on a legacy modernization project. Responsibilities include:• Facilitating the different scrum meetings – daily stand-ups, release planning, sprint planning, retrospectives, backlog grooming• Helped the team prioritize and focus on the tasks at hand• Helped identify blockers, dependencies and having them addressed at the earliest• Helped maintain and keep up to date the burndown chart• Helped identify the team velocity and the work that could be taken up for a sprint• Mediating the general conflict of goals between development team (high technical quality) and product owner (more features)• Mediating through conflicts• Giving feedback to the team• Exchanging constantly with other Scrum masters in the organization• Helping to write or split user stories• Keeping the management updated with weekly status reports

Pune Area, India

L&T Infotech started a new Healthcare unit wherein as a Healthcare Consultant interaction and support is provided to onsite Healthcare sales team to help them get new business. Responsibilities include:• Creation of innovative accelerators which could be taken to market and help showcase capabilities• Creation of sales material including presentations for the different prospects• Identify themes for calling campaigns• Support creation of RFP responses• Creation of training materials and imparting training to folks new to Healthcare domain and onboard sales team• Creation of COEs • Reach-out and identification of prospective clients• Supporting sales team on prospective client calls• Interaction with analyst firms• Support account mining for existing clients

Hartford, Connecticut Area

Gathering business requirements, performing testing including UAT, managing offshore team, helping developers/testing teams with questions around requirements

Bhubaneshwar Area, India

Cobol, Mainframes developer

Post Graduate Program, Business Analytics & Business Intelligence, 80%

• Learnt R, regression methods, classifications tree techniques including Cart/ Random Forest/ Neural Networks, analytic tools Tableau &.

Bachelor Of Engineering (B.E.), Electronics And Communications Engineering, 75%

Electronics & Communication

Icse, 88%