| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateRuchi Sharma US CitizenEmail : EMAIL AVAILABLE Cell: PHONE NUMBER AVAILABLECurrent location: Street Address long pond trail, Flower Mound, TxPROFESSIONAL SUMMARYExperience in commercial Property and Casualty, Commercial Lines and Personal Lines Insurance, Underwriting, Rating and Guidewire experience with national carriers7 plus Years of Professional Experience as Business System Analyst/ Data Analyst with strong knowledge of Property and Casualty industry with Guidewire Products.Strong experience working on Guidewire ClaimCenter and PolicyCenter.Extensive experience in analysing and requirements gathering and writing system functional specifications.Good Working experience of Extraction Transformation and Loading (ETL) Process using Informatica. Designed, developed and implement staging tables, cursor, stored procedure and views using SQL.Experience in commercial Property and Casualty, Commercial Lines and Personal Lines Insurance, Underwriting, Ratingand Guidewire experience with national carriers.Extensively worked on store procedures for new system changes and troubleshoot the existing store procedures to work more efficiently.Solid understanding of Business Process definition, Risk Analysis and SDLC methodologies.Experience in Functionality Testing, User Acceptance Testing, Database Testing, Regression testing and Risk Based Testing.Agile/Scrum, Jira, MS Project, RUP, UML, HP ALM/QC, Rational Suite, Test Director, Visio, SharePoint, SQL, etc.SKILL MATRIXSkillExperienceSkill LevelP&C Insurance industry7 YearsExpertGuidewire Policy & ClaimCenter6+ YearsProficientData Mapping/Data Flow/Data Transformation5 YearsProficientRequirements Documentation (BRD)6+ YearsExpertSystem Design Documentation (SRS)6+ YearsExpertJira6 YearsProficientSQL/ETL4 YearsExpertAgile Scrum6+ YearsExpertQA/UAT5+ YearsAdvancedJAD sessions6 YearsExpertPROFESSIONAL EXPERIENCECiti Bank, Dallas, TX (Remote Dallas, Texas) Oct 2022 to PresentBusiness Analyst / Data AnalystThe project involved creating a web-based policy-issuing application for Commercial line of business and the migration from the existing Dos into the Web environment. I worked on test the claims on Personal lines of Home and Auto. I was working with Guidewire PolicyCenter module, Guidewire ClaimCenter module and associated with Guidewire BillingCenter module as well.ResponsibilitiesGathered the high-level business needs from the directors and prepared the High-level Business Needs.Work with production underwriters to review commercial property insurance renewal and new business opportunities to ensure proper risk identification, analysis and assessment and the development and growth of a profitable portfolio of business.Worked as Business Analyst for the project on Personal line of business to gather and document as is flow and future business flow using Guidewire PolicyCenterWorked on a project, which dealt with the Production Stabilization and Defect Tracking of the newly migrated Guidewire BillingCenter.Worked on integration with business rules with FICO Decision management platformDeveloped Business Requirements Document (BRD), Functional Specifications (FSD) and technical documentation for business processes.Created test cases and test scripts to check the functionality of application (UAT)Worked with underwriting department of Property & Casualty (P&C) business unit to evaluate risk, exposure of potentialclients and measured risk exposure and determined premium.Conducted User Acceptance Testing (UAT) and collaborated with the QA team to develop the test plans, test scenarios, test cases, test data to be used in testing based on business requirements, technical specifications and/or product knowledge.Gathered business requirements through JAD sessions, walkthroughs, interviews, and observations.Generated reports as per adhoc request from the client through data extraction, data mapping, Extraction, Transformation, and Loading through by using Informatica Tool (ETL).Elicited requirements for various Claims Integrations with PolicyCenter and BillingCenter on activities like Policy and Billing Status retrieval, Checks Issued and Void Processes for Claims etc.Worked on Automation of complex rules to provide capability of managing decision rules by the policy managers.Involved in testing the Quote & Purchase for both Auto and Home Property Insurance ratings of the customers.Created test plans, test scenarios, test cases for the ClaimsCenter and the BillingCenter.Prepare data models and perform data analysis. Document metadata, including domains, definitions, and business rules.Used JIRA for User Story requirements management throughout the Agile Sprints and development life cycle.Involved in creating Data Stage jobs to extract, transform and load data into data warehouses from various sources like relational databases, application systems, temporary tables, flat files etc.Tracked UAT issues/bugs and prepared reports.Created UAT Test Strategies, Test Plans, Test Scenarios, Test Cases, Test Scripts, and Test SummariesCreated a test plan and a test suite to validate the data extraction, data transformation and data load and used SQL and Microsoft Excel.Managed Quality Assurance activities for system interfaces including management of project and consultant staff through the QA phase of the System Development Life Cycle (SDLC).Agile/Scrum, Jira, MS Project, UML, HP ALM/QC, Rational Suite, Test Director, Visio, SharePoint, SQL, etc.Travelers Insurance, Frankenmuth, MI Feb 2020 to Sep 2022Guidewire Business System AnalystThe scope of the project was to consolidate multiple Policy Administrating Systems in Guidewire Policy enter and the application tested was a web-based Claims application known as Guidewire ClaimCenter. The project involved implementing Guidewire Policy enter, for Personal Auto Insurance Line of Business, for both new business and policy renewal business. Also worked to build an Enterprise Reporting System to support asset management and credit risk management. Any application has three major components ETL i.e. Extraction of data from data source, transformation, loading in to the database and then reporting on it.Responsibilities:Assisted in the formulation and definition of system scope and objectives through research and fact-finding to develop or modify moderately complex Guidewire ClaimCenter and PolicyCenter package application in an Agile environment.Created user stories from requirements, developed Business Requirements Documentation (BRD) and technical documentation for business processes related claims life cycle and policy life cycle for Property & Casualty (P&C) - Personal and Commercial insurance lines: Workers Compensation, Homeowners, Inland Marine, General Liability.Prepared requirements document for Commercial Auto, Crime, Business Owners Policy, Commercial Output Policy, and Commercial Property Package.Worked closely with the Enterprise Data Warehouse team and Business Intelligence Architecture team to understand repository objects that support the business requirement and process.Provided Data and field mapping and JSON to the IT team to successfully integrate with systems.Worked on multiple streams ranging from: Guidewire ClaimCenter application, Integration& document management forWorkers Compensation Underwriting & Personal Auto.Implemented Guidewire vendor software upgrading current legacy system. Generated Use case for business process and User Stories for Guidewire PolicyCenter to understand the various possible scenarios and dependency among various line of Business (LOB).Worked on creating Data Flow Diagrams, Use Cases, State Diagrams, Sequence Diagrams, Component Diagrams, Use Case Diagrams & Activity diagrams.Conduct JAD sessions, walkthroughs, workshops, and interviews with business users, experts, Dev & QA teams.Worked in data analysis, data reconciliation and data mapping for ETL process.Performed Integration testing, System testing, Regression testing and Performance testing of ClaimCenter, PolicyCenter and Payment Manager in Guidewire application based on the business requirements using LISA.Worked on Automation of complex rules to provide capability of managing decision rules by the policy managers.Acted as a liaison between client and internal Developers to design software applications for Commercial Line Insurance such as Workers Compensation, Commercial Property, General Liability and Commercial Auto.Writing SQL queries to retrieve metadata using TOAD from different data sources like Active Directory, LDAP (Lightweight Directory Access Protocol), RAM, Unix, Sybase.worked on test the claim on Personal lines of Home as well Workers Compensation Underwriting, Personal Auto -Guidewire PolicyCenter implementation.Used SQL's for validating the data. Created UAT Test Strategy, UAT Test Plans and UAT defect reporting. Complete UAT support interacting with end-business users and organize the UAT approvals in project shared repository for each story (requirement). Performed Acceptance test (UAT) beforePerformed requirement analysis & meetings to review the requirements and both in scope & out of scope.Implemented and maintained Property & Casualty (e.g. bug-fix, data integration, version release) systems of assigned customers.Created workflow scenarios, designed new process flows and documented the Business Process and various Business Scenarios and activities of the Business from the conceptual to procedural level.Assisted the team in determining if and how new systems may improve process flow and business function.Prepared and maintained weekly status reports regularly to communicate project status to key stakeholders.Prepared and reviewed test plans and facilitate test execution to ensure the system meets requirements.Prepared and documented the Test Scripts and User Training documents.Reviewed reported defects and determine the defects category (missed requirement vs. Enhancement requirement vs. Defect).Agile/Scrum, Jira, VersionOne, HP ALM, TFS, UML, Rational Rose, Visio, Excel, and other tools.Star Intl Group Jacksonville, FL Nov 2018 to Jan 2020Business System AnalystThe project was to work through challenges in Property & Causality (P&C) Insurance Policy and to create solutions. This involved the design and development of a Policy Rating System using Guidewire PolicyCenter.Responsibilities:Worked as Business Analyst for the project on Personal Auto line of business to gather and document as is flow and future business flow using Guidewire PolicyCenter.Communicated with Customer Service on ACORD Forms design and other technical problems.Worked on documenting product model using Guidewire template and gather prequalification questions, coverage's, conditions, exclusions, modifiers, schedule rate factor. Worked on configuration user stories around PolicyCenter and BillingCenter during the development sprints.Developed a file of ACORD Forms used as the standards in all Property and Casualty markets, for both Personal and Commercial Lines of Business.Documented the Forms screen design and identified that zero, one, or more, forms have been associated with the policy.Worked closely with the product owners to understand the business requirements and technical documentation; requirement gathering, analysis and closure of related to the Policy life cycle and claims life cycle processes for Property & Casualty (P&C) Insurance policies: Workers compensation, Property, Inland Marine in Guidewire PolicyCenter and Guidewire ClaimCenter application.Well versed in authoring Business Requirements Document (BRD), Functional Specification Document (FSD), Software Requirement Specifications (SRS), Use Case, Business case and Data mapping document.Acted as a liaison with operational and financial management, systems support and sales to identify business opportunities.Developed the commercial account managers in the interpretation of commercial coverages, specific policy forms, and actual coverage applications.Conducted requirement sessions with business to elicit future state requirements. Created UI mockups based on PolicyCenter OOTB functionality user requirement.Working with Quality Assurance team to provide input to testing activities, co-ordinate the User Acceptance Testing (UAT) with the business users, validate test results and resolving issuesPerformed Unit testing, job monitoring, SQL queries supporting functional, UAT and regression testing.Actively worked during analysis and testing phases and supported development team during design and implementation phases of agile development process.Fill out forms requested by claim representatives, request for police reports, title history on specific vehicles and insurance verification.Worked on data mapping artifact to provide target system requirements at the field level. Involved in integration and data content discussions with various teams for various integration points to and from the system.Collected requirements from department managers and users for enhancements.Documented and provided traceability for requirements being delivered by other subject areas Identify source data per requirements.Agile/Scrum, Jira, VersionOne, HP ALM, TFS, UML, Rational Rose, Visio, Excel, and other tools.Brotherhood Mutual Insurance Company, Fort Wayne Indiana Nov 2017 to Oct 2018Jr. Business AnalystThe project was a Web Based Portal for online submission of the insurance claims for property and causality for personal lines and Specialty lines.Responsibilities:Worked extensively with MS Excel and MS access. Analysis of business requirements and system requirements of the client and also for Property & casualty modules.Gathered the high-level business needs from the directors and prepared the High-level Business Needs.Gathered user requirements and directed developers for practical deliverables.Worked with senior business executives/Insurance Underwriting team in capturing the KBRs for documenting the business requirements document (BRD)Primarily responsible for Documentation in each phase of RUP Methodology, Risk Assessment, and Validation & Verification process for capital asset and business owner insurance - commercial lines.Worked with the Project Manager on various Project Management activities like keeping track of Commercial line modules, Project Status, Deadlines, Environment Request, and Compliance Issues.Worked on UAT testing and took signoff from the Commercial line of Property & Casualty business users.Created document for web analytics implementation, tagging and testing.Assisted the QA team in designing the Test Plan and Test Cases for User Acceptance testing.TECHNICAL SKILLSMS Office: MS Visio, MS Project, MS AccessProject Methodologies: Agile, Scrum, WaterfallDefect Tracking Tools: HP ALM, Redmine, RallyTesting Tools: SOAP UI, QTPPolicy Admin: Created policy transactions/jobs in Guidewire PolicyCenter & ClaimCenter Integration Points, Message Queues, Web Services, ConductData Model Configuration: Data Entity Creations & Extensions, Type List creation, Defining SubtypesData Analytics Tools: Google Analytics, Tableau, QlikViewEDUCATIONBachelors in business studies from Tribhuvan University, Kathmandu, Nepal 2013 |
