Experience

• 

  Tata consultancy services

  Jun 2012 - Sept 2019

  Client: Nationwide Mutual Insurance• Analyzed the legacy policy administration system in mainframe and create functional requirements and data mappings for Guidewire Integration. • Coordinate the Integration with Cross Functional Teams, viz, Guidewire Policy Center, Claim Center, Billing Centre, PMIS, Enterprise Integration Services, Document Management System (DMS) etc. • Working on Onsite-Offshore model attending Daily Scrum Meetings, Post-Construction reviews and coordinating and collaborating with cross functional teams to achieve business objective and maintain customer satisfaction. • Defining and Mapping the XML request & response elements between external integration like LexisNexis, MVR, CLUE, Comp Rater, etc. and Guidewire Policy Center that consumed the Web Service. • Creating Requirement Tasks and User Story cards in JIRA and providing refinement sessions to Development and Quality Assurance teams. • Build scripts to measure, log, and report on the ETL flow of all data types. Automate the manual and time-consuming task. • Run and monitor batches to rerate the historical data to current or proposed rates for calculating off-balances, income effect, histograms, and rate capping. • Review the code and perform unit testing for the code developed. Show less Client: XL Catlin Insurance• Led an ETL team that performed GAP analysis against a warehouse that was being decommissioned and a new warehouse that was being built. • Developed workflows to pull the missing data into the new warehouse after consulting the business. • Coordinate with the business teams to ensure that all the data they need for reporting are available on the new data warehouse and decommission the components on the older data warehouse Work with the Business Analyst’s to fix defects reported by the business and documented the changes. • Work with the Business Analyst’s to fix defects reported by the business and documented the changes. • Work with DBA part to migrate the servers running on Windows 2003 Operating system. • Work with the Disaster Recovery team to perform DR testing of the Production environment. Show less Client: XL Catlin Insurance• Tuned mappings that loaded data into targets with indexes intact by using a pre-SQL to delete indexes and using a post-SQL to recreate them after the load. This was made a standard across all applications and interfaces subsequently. • Worked with the DevOps and Database Management teams and obtained query plans for the Procedures and SQL Scripts that were causing delays. Tuned and optimized them thereby reducing run times. • Dovetailed with the Reporting BI team and business to identify objects that were not required for reporting purposes but were being refreshed daily to the reporting layer. These redundant data refreshes were cut off thereby reducing the run times and saving space. • Converted full loads to Incremental loads to reduce runtimes. • Converted 80 + SSIS Packages to Informatica workflows to homogenize the loads. • Delivered 24/7 available reporting databases to users which could be used during the DB backup and restore process. • Spearheaded the SQL server file group structural changes to improve parallel processing performance and to provide the DB engine the ability to read and write data In Parallel. • Extensively used Informatica partitioning techniques to reduce the run times of long running workflows. • Used global key concepts in the transaction tables to track the data flowing downstream from staging database. • Set up Audit Balance and Controls at each layer to ensure data governance and ensure quality. • Created a front end using JSP and XML which would allow users to trigger the AutoSys jobs/Informatica workflows during month close processes. • Implement Informatica transformations such as Source qualifier, expression, router, sorter, update strategy, joiner widely. • Use tasks such as Control tasks, Event wait on files, email tasks to send emails upon completion of loads. • Create test plans and assist the Business Analysis team perform system testing. Show less

  • Technical Business Requirements Analyst

    May 2017 - Sept 2019

  • ETL Team Lead

    Mar 2016 - Apr 2017

  • Senior ETL Developer

    Aug 2013 - Mar 2016

  • ETL Production Support

    Jun 2012 - Aug 2013
• 

  Kforce inc

  Sept 2019 - now

  Client: StateAuto (Liberty) Mutual Insurance• Facilitate and coordinate workshop and interview sessions to expedite and streamline the requirement gathering process for technical implementations related to Commercial and Personal lines.• Facilitated scrum ceremonies (grooming, sprint planning, retrospectives, daily stand-ups, etc.)• Created work breakdown structure, and parent and child task items, identifying critical tasks and dependencies.• Collaborated with cross functional teams to achieve business objective and maintain customer satisfaction.• Use Jama, to define Use Cases to articulate new functional software needs. Designing Business Requirement Documents and Functional Specification documents.• Creating Epic, Story Tasks and User Stories in Jira and strategizing the impact of requirements on different platforms and applications.• Planning and developing test plans for various components, including User Acceptance Testing. Preparing test plans consisting of risks, assumptions, timelines, and dependencies of the projects divided into various platforms.• Worked on Product Configuration, Integrations, workflows, triggers, business rules, documents etc.• Worked on requirement for ISO (insurance Services Office, Inc.), NCCI (National Council on Compensation Insurance, Inc.), Wolters-Kluwer, AAIS (American Association of Insurance Services) and proprietary forms, including static and dynamic, countrywide and state specific forms outlining any unique or exception scenarios underwriting state-wise rules or rating information. Show less Client: Sedgwick Insurance• Spearheaded a business process re-engineering initiative, resulting in a 30% increase in operational efficiency by analyzing data trends, leading workshops, and implementing an Agile framework for continuous improvement.• Created visual Process flows using Visio stencils following DFD and BPMN. Developed Process flows, user interaction,and swim land diagrams for improved clarity and improved understanding by various stakeholders.• Worked with Project management tool MS Project for identifying tasks and deliverables, scheduling, and reporting.• Responsible for devising strategies and conducting agile ceremonies involving sprint planning, backlog grooming, carve-out sessions, and sprint retrospect. Used MS ADO as an agile project management tool.• Facilitate and coordinate workshop and Interview sessions to expedite and streamline the requirement gathering process.• Created Requirement Tasks and User Story cards in MS ADO and providing refinement sessions to Development and Quality Assurance teams.• Creating technical specification of API’s including Request, Response data mapping supporting XML and JSON formats.• Setting up touch-base meetings with vendor on need basis to clarify questions that gets uncovered during the development phase.• Performing Functional Sprint Testing, participate in Stabilization testing, End to End testing and assisting Business with UAT testing and reporting bugs. Show less Client: StateAuto Mutual Insurance• Implemented the Guidewire Policy Administration System for the following Line of Business - Commercial Property, General Liability, Inland Marine, Farm and Ranch and Workers Compensation. • Conducted Pre-RDW (Rapid Design Workshop) sessions as part of requirement elaboration and to elicit and document the detailed requirements with Business and seeking formal sign-off on the artifacts created. • Worked on Product Configuration, Integrations, workflows, triggers, business rules, documents etc. • Worked on requirement for ISO (insurance Services Office, Inc.), NCCI (National Council on Compensation Insurance, Inc.), Wolters-Kluwer, AAIS (American Association of Insurance Services) and proprietary forms, including static and dynamic, countrywide and state specific forms outlining any unique or exception scenarios underwriting state-wise rules or rating information. • Captured requirements in Jama and User Story cards in Jira and refined them to our Development and Quality Assurance teams. • Developing User Story Cards in “Gherkin” format, contains domain specific language having the business acceptance criteria. Show less

  • Senior Business Analyst

    Jun 2022 - now

  • Senior Business System Analyst | Scrum Master

    Mar 2021 - Jun 2022

  • Senior Business Analyst

    Sept 2019 - Mar 2021