SUMMARY

• Business Analyst with over 8 years of experience in the domains such as Property and Casualty Insurance, Commercial Banking.
• Experience to work with Business Stakeholder to Gathered the Business Requirements and Convert them into Functional Requirements for the Technical Side.
• Extensive experience in Conducting JAD Sessions, Feasibility Studies, Data Analyses, System Analyses, Gap Analyses, and Risks Analyses.
• Comprehensive experience in Requirements gathering and Business Processes management with a strong knowledge of Software Development Life Cycle (SDLC).
• Expertise in the Team Foundation Server (TFS) to update documents and Master Logical Data elements, turn the Functional Specifications Document to Development Team with Change set and Deliverables.
• Expertise in Project Management i.e., Project Scoping, Planning, Estimating, Scheduling, Organizing, Directing, Controlling, Budgeting and Drafting Remedy Procedures.
• Experienced in AGILE, Scrum, RUP, Client /server architecture providing a well - balanced understanding of business relationships, business requirements, worked for financial and technical solutions and helped the team at all levels until final product release.
• Proficient in Detecting, reporting and tracking several defects them using Jira and Well versed in project management tools like MS Project for project planning, Project scheduling.
• Proficient in Technical and Business Writing, Business Process Flow, Business Process Modeling, Business Analysis and Testing various methodologies.
• Experience in facilitating Joint Requirement Planning (JRP) sessions with Business User Groups, conducting Joint Application Development sessions with IT Groups and Conflict Management with Project team members.
• Expert in Commercial Property and Casualty, Commercial Lines and Personal Lines Insurance, Underwriting, Rating and Guidewire experience with national carriers.
• Vast Insurance business knowledge with project experience in various LOB's such as Personal (Auto, Dwelling, Home owner) and Commercial (Commercial Auto, Workers Compensation, Commercial Property, General Liability, Business Owners Policy (BOP), Commercial Package Policy (CPP).
• Expert in the Casualty, Annuities, Disability, and Supplemental Insurance policies include administration, sales, customization, claims, pensions and CMS.
• Strong knowledge in the development of Guidewire Billing Center, Billing Center - Policy Center User Stories and exposures pertaining to dwelling, personal property, other structures, loss of use, content, etc. relating to Homeowners Policy.
• Proficient to work closely 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.
• Expertise to work with the core development team to ensure the requirements are understood and incorporated into the development of project.
• Strong experience with Insurance/Finance tools in Life Sciences, Property and Casualty domains to develop methods to minimize errors in billings/claims.
• Strong Knowledge in the Analysis of Extracted data from different sources like Oracle and text files using MS Access, SQL procedures maintained key records for purposes of Compliance review, QA/QC, and/or regulatory inquiry. Performed data mapping, logical data modeling, involved in creating class diagrams and ER diagrams and used SQL queries to filter data.
• Highly skilled to work with team in such technical design, interface design, development standard designs, data conversions and component changes.
• Experience to write complex SQL queries for retrieving data from the database, generating ad-hoc reports, and conducting data validation testing.
• Proficient in creating test plans, preparing and executing test cases and wrote test summary reports using HP ALM, HP Quality Center, MS Test Manager 2013 and Jira.
• Responsible to Track, Document, Capture, Manage and Communicate the Requirements using Requirement Traceability Matrix (RTM) which helped in controlling numerous artifacts produced by the teams across the deliverables for a project.
• Highly motivated team player with excellent Interpersonal and Customer Relational Skills, Proven Communication, Organizational, Analytical, Presentation Skills, and Leadership Qualities.

PROFESSIONAL EXPERIENCE

Business Analyst

Confidential - IL

Responsibilities:

• Worked with product SMEs to define product specifications in order to define Line of Business within Policy and Claims Center.
• Acted as a liaison between client and internal Developers to design software applications for Commercial Line Insurance such as Workers Compensation, Commercial Property and General Liability.
• Worked with the claims department for all property and casualty and liability lines.
• Defined customization product rules including coverable items, coverage, coverage terms, deductibles, and limitswithin the ClaimsCenter system.
• Involved in organizing various group organizations inPolicyCenterandClaimCenter, as indicated by the producer tree and definedrequirementsforintegration withBilling Center.
• Gathered the requirements from the business users, Compliance and Operations team.
• Involved in usingAGILEmethodology to manage the software development process and assisted as the Product owner in the iteration cycles.
• Conducted JAD sessions for communicating with Stakeholders and Project directors.
• Worked on Commercial line property and casualty insurance inAGILE methodology.Conducting grooming sessions and facilitated daily scrum calls.
• Worked onAGILEmethodology attending daily stand-up calls with a sprint timeline which were tracked with JIRA.
• Participated in product backlog grooming sessions, sprint planning meetings, sprint review meetings, sprint retrospective sessions.
• Workedwith the cross-functionalBilling Centerteam to be sure that LOB is in sync withPolicy Centeras configuration continues.
• Worked on Commercial lines Property and Casualty Insurance including both policies, claim and billing process.
• Worked on the business requirements and system requirements of the client and for Property and casualty modules.
• Involved with the team integratingPolicyCenterdocuments management system with Thunderhead and Captiva software for easy access of documents.
• Worked on implementing Plugins to generate Policy/Account Number inPolicyCenter, document template list and to generate Ad hoc documents using Thunderhead.
• Involved in documenting customization requirements and business rules for the Implementation of GuidewirePolicy Centerand Claims Center.
• Worked on Thunderhead custom XSD design and request builder for payload generation.
• Worked on providing Property and Casualty, Workers Compensation, Policy and Claims processing with subject matter expertise to the IT team throughout the project.
• Analyzed the existing reports of the reporting system in the database. Checked the consistency of the data after ETL process using SQL queries.
• Used Microsoft Office software to perform required job functions.
• Involvedin workingin a mainframe environment and used SQL to query various reporting databases.
• Worked on building a Business Analysis Process Model using Rational Rose and Visio.
• Worked on performing extensive Requirement analysis and developed use cases and workflows.
• Played a key role in the planning and Implementation of system enhancements and conversions.
• Involved in conducting System Testing & User Acceptance Testing (UAT) and documentation of test cases.
• Worked on providing clear and concise documentation regarding requirements management plans, Functional Requirements, supplemental Requirements, Test Plans and Test Cases.
• Worked on writing test plans, defining test cases, developing and maintaining test scripts.
• Actively Involved in Manual Testing Regression Testing of the Application and writing defects in QC.

Business Analyst

Confidential - Columbus, OH

Responsibilities:

• Worked throughout the SDLC, which included requirements, specifications, design, analysis and utilizing agile methodology.
• Utilize the guidelines and artifacts of the Agile Methodology to develop a detailed implementation process Guidewire, Claim Center Integration during different iterations and phases in Software Development Life Cycle (SDLC).
• Elicited requirements and provided specific business and technical requirements guidance for the construction of the system. The requirements set comprised of Business Requirements Document (BRD), functional requirements, Business and System Use Cases.
• Translated Business Requirements into functional and non-functional requirements using industry standard documentation processes like Data Flow Diagram (DFD) and UML Diagrams (Use Case, Sequence and Activities Diagrams).
• Performed Joint Application Development (JAD) sessions to identify the Key Changes, and participated in Stakeholder Management to communicate effectively with them.
• Assigned tasks among the development team, monitored and tracked progress of the project following agile methodology also attend agile iteration sessions and created documents on the status of various TFS tasks for the iteration.
• Assisted in the development of User materials for the upgraded version of the existing system technology and process improvements also worked on every Sprint that covered Elaboration and Configuration of the existing System.
• Created User Interface Documents (UID) of prototypes and wireframes of the software solution, Guidewire Policy center, to help designing user interface.
• Responsible for acting as a liaison with operational and financial management, systems support and sales to identify business opportunities. Developed a file of ACORD Forms used as the standards in all Property and Casualty markets, for both Personal and Commercial Lines of Business.
• Worked with cross-functional Claim Center team to be sure that LOB is in sync with Policy Center as configuration continues.
• Managed General Liability, Commercial Property, Commercial Package, Commercial Auto and Workers Compensation policy lines.
• Worked with various departments to perform analysis, review, and for the estimation of client request and also prepared requirements and client documents for Personal Lines Property and Casualty business.
• Hands on Inland Marine, Crime, Worker's Compensation, Umbrella, Business Owners Policy, Commercial Output Policy, and Commercial Property Package.
• Worked with team on the implementation of Claim Center, Docs and Forms, Rating, Portfolio management, Policy Service and Analytical systems.
• Worked with the Integration team for elaborating Billing Center integration user stories such as Integration to Agency Management system, Process commission payment via Enterprise Payment Services, Integration to commission management center and custom integrations, etc.#
• Work closely 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.
• Provided process improvement initiatives to promote efficiency within loan processing, underwriting, closing and meeting Service Level agreements.
• Created cross system data flow diagrams and flowcharts to depict the integration dependency of other applications with Guidewire Policy Center.
• Worked extensively in Data Analysis, Data Reconciliation and Data Mapping with ETL team (Extract Transfer and Load) for the elicitation of data as well.
• Used Test Director, PL/SQL for testing the application and developing Logical and Physical data models that capture current state/future state data elements and data flows using Erwin.
• Responsible for gathering requirements from users in the operations group and performing data mapping for the application, confirming and vacillating the requirement.
• Used JIRA for writing epic, user stories with acceptance criteria or user stories with use cases, used confluence for upload documents.
• Used SQL during to verify and validate that the correct information is being provided and also reviewed basic SQL queries and edited inner, left, right joins in Tableau Desktop by connecting live/dynamic and extracts.
• Developed test plans with QA team and helped test every scenario using Mercury Test Director Tool for system testing.
• Created UAT plans with several test cases to ensure that the system runs smoothly after the proposed enhancements or changes have been made.
• Worked with quality control teams to develop Test Plans, Test Cases and test scripts based on functional performance criteria and usability also used MS Visio for Process modeling, Business Process flow diagrams.

Business Analyst

Confidential - Lansing, MI

Responsibilities:

• Collaborated with Stakeholders and SMEs to define product specifications in order to define Line of Business within Policy Center.
• Worked closely with the project manager, business lead and technical lead to identify, research to escalate issues and risks to the appropriate work stream for resolution. Also perform overall Requirements Management and built the Requirements Traceability Matrix.
• Performed Gap analysis on customization of product rules including coverable items, coverage, coverage terms, deductibles, and limits within Policy Center system.
• Worked closely with project manager to determine time required to accomplish project and led weekly meetings to determine scope, issues and limitations of project.
• Responsible for collecting and analyzing the metrics and then submitting the reports, which kept track of the status and progress using JIRA.
• Conducted JAD sessions for communicating with Stakeholders and Project directors to utilized corporation developed Agile SDLC methodology also used scrum work Pro and Microsoft Office software to perform required job functions.
• Conducting project kickoff meetings and Solution meetings with team members to explain roles / responsibilities, relationships with other groups, deliverables, timelines, assignments and status reporting.
• Worked on the implementation of online web-portal used for submitting new business Application, Policy change, Pay online, Add Jewelry, submit claims and Express Apps.
• Assisted in the documentation of requirements for the Guidewire, Claim Center and claims management system as a Quality analyst also used the knowledge of Claim Center to assist the business units in defining needs and requirements.
• Worked in Guidewire Policy Center from End-to-End and involved in Policy Info, Person Info, Losses and Violations, Coverage's and Risk Analysis Customizations.
• Involved with team for the integration of the process to change all the policy administration systems from their legacy mainframe systems to Guidewire's web based system.
• Involved with GPA UX/UI teams to help them with wireframes and prototypes to achieve desired business objective also worked on GPA web portal using web services, helped with mapping and process flow diagrams.
• Interacted with Guidewire Development team on synchronizing the screens based on customizations and responsible for Scoping and created the Project Initiation Document (PID).
• Responsible for analyzing the development of Data Warehouse structure also Used SQL and MS Excel for all Data validation based on the Business Rules.
• Involved with the ETL team to create macros in order to make data migration testing more useful and compared results from the legacy databases to the new CRM database.
• Developed SQL Queries and stored procedures to fetch complex data from different tables in remote databases using joins, database linked servers and formatted the results.
• Helped in creating the data-mapping for practices documents including visual processes and trained team members on data mapping process and tools.
• Working closely with development and Testing Team to iteratively implement and deliver functional modules throughout the duration of the project.
• Actively Involved in Manual Testing Regression Testing of the Application and writing defects in Quality Checking.
• Involved with the Quality Assurance team to finalize confirmation criteria to make sure all scenarios are covered.
• Played a key role in the planning of User Accepted Testing (UAT), and Implementation of system enhancements and conversions.

Business analyst

Confidential -Worcester, MA

Responsibilities:

• Gathered Business Requirements and documented into System Requirements to Identified, analyzed, researched, defined, investigated and documented business processes for Use Case Scenarios.
• Applied the Agile methodology for the project, guided the team to document epic, stories and requirement maintenance using tools like JIRA
• Acted as the primary liaison between the business line, operations, and the technical areas throughout the project cycle.
• Performed Gap analysis to get BRD’s business requirements through surveys, prototyping and observing from portfolio managers and UI (User Interface).
• Actively worked during analysis phases and supported development team during design and implementation phases of agile development process.
• Worked on the established Scrum methodology processes to ensure that developed capabilities met the documented requirements.
• Developed strategic partnerships with the business unit to prepare a solid knowledge base of the business line, including the business plan, products, and process' and revenue streams aimed towards problem solving.
• Assisted Project Manager to perform various project management activities such as developing & maintaining Project Plan, monitoring & controlling project tasks, scheduling iterations, identifying project key milestones, and managing change requests.
• Worked on various policy administration & industry standard such as Guidewire Policy Center, Guidewire Claim Center and Guidewire Billing Center.
• Gained Functional knowledge of various modules of insurance like channel management, policy servicing, claims management, underwriting, reinsurance and finance.
• Interacted with team to finalize the product backlog for the application and worked on Voided Claims, Subrogated Claims and Multiple Claims in a Single Incident.
• Involved in creating the workflow for Delinquency Process in Billing center, assignment/Trouble ticket assignment in billing center.
• Involved in migration process from Mainframe, policy legacy systems to System.
• Hands on Customizing Charge Invoicing process in Billing center and update Renewal Process in Policy Center. Provide officially update logic in Policy Center.
• Worked with ETL (Extract Transfer and Load) team for the elicitation of data and Created job schedules to automate the ETL process.
• Extensive use of MS Office tools like MS Access, MS Word, MS Excel, and MS PowerPoint MS Project for data migration.
• Converted complex Excel spreadsheet to MS Access for project estimations Conducted Functional Walkthroughs, User Acceptance Testing (UAT), and supervised the development of User Manuals for customers.
• Performed data analysis and data validation by writing SQL queries using ORACLE database and used Query Analyzer, Execution Plan to optimize SQL Queries.
• Involved in creating different reports based on the change request and ad hoc requirements using Tableau, Power BI desktop and Prepared financial deliverables for funding agencies; as well as proof of concept, and solution mockups.
• Managed Parameters in Power BI Desktop for changing the source with different environments such as development, test and production.
• Minimized defects in software application by collecting, reviewing, managing, and monitoring software application defects in JIRA through resolution as reported by various internal and external customers as Defect Manager
• Worked with various bug tracking tools like HP Quality Center and Rational Clear Quest for the good understanding of the SDLC (System development Life Cycle).
• Involved in creating automated Test Scripts representing various Transactions, Documenting the Load Testing Process.
• Worked closely with Quality Assurance (QA) and testing team to facilitate and undertake User Acceptance Testing (UAT).

Business Analyst

Confidential - Cincinnati, OH

Responsibilities:

• Actively involved in brainstorming and JAD session with the client in order to identify all the business requirements for P&C project development.
• Successfully performed Requirements Gathering and Analysis, interviewed the SME (Subject Matter Experts), both personal and commercial, and ensured that contributors and all key stakeholders were motivated to complete assigned tasks.
• Effectively managed all the project lifecycle using RUP. Created the rules engine and the laid down the guideline for the smooth flow of the different project elements in P&C domain.
• Ensure timely and quality deliveries. Track and report project data/milestones.
• Additionally, work as a control owner for different Risk(s) Test Evidences and install processes under SOX compliance for Confidential Auto and Boat policy administration system (PAS) team.
• 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.
• Developed Process Work Flows, Functional Specifications, and responsible for preparing Software Requirement Specifications (SRS), Functional Specification Document (FSD).
• Performed Gap Analysis to identify the deficiencies of the current system and to identify the requirements for the proposed system for Treaty and Facultative Reinsurance.
• 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.
• Performed Defect Tracking and Change Control Procedures using Rational Clear Quest and Configuration Management and Version Control using Rational Clear Case.
• Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, OOD using UML.
• Responsible for gathering requirements from users in the operations group and performing data mapping for the application, confirming and vacillating the requirement at time of BA testing.
• Involved in the development of Test Plans, Test Cases and Expected Results, and coordinated the tests with the QA team to verify implementation of new features and enhancements.
• Involved in creating reports for business analysis purposes using Crystal Reports and Microsoft Excel.
• Involved in generating Test cases for property and casualty Insurances for different Levels of Business.