Business Analyst /data Analyst (property And Casualty) Resume
Raleigh, NC
SUMMARY:
- Around 5+ years of experience as a Business Analyst in the Insurance - Property & Casualty, Reinsurance & Banking domain .
- Expertise and hands on experience of migrating and upgrading insurance suite solutions to Guidewire solutions as well as integrating third party solutions to Guidewire solutions.
- Working knowledge about policy Underwriting, Binding, Rate making rules and factors affecting it, Rewriting and Worker's Compensation. Good understanding of Object Oriented Analysis and Design (OOAD)
- Well versed in claim management i.e. FNOL, Claim Setup, Payment and Recovery, Fraud Detection Tools, Litigation, Subrogation and Salvage and Expert in Data Visualization, Data Analysis, business Intelligence
- Through knowledge about financial services and financial instruments.
- Comprehensive knowledge of Software Development Life Cycle (SDLC) and various methodologies such as Agile, RUP, Waterfall.
- Hands on experience on Banking Retail
- Experience in working in close proximity with business users, project stakeholders, Subject Matter Experts (SMEs) and staff to understand high level business requirements and minute level specifications for new applications, and to modify existing applications.
- Adept in performing GAP Analysis to check the compatibility of the prevalent system infrastructure with new business requirements.
- Proficient in Requirements Gathering, Surveys/Questionnaire Development, business Requirement Documents (BRD), Functional Requirement Specifications/Documents (FRS/FRD )
- Extensively experienced at convening Joint Requirement Planning (JRP ) sessions with business User Groups, conducting Joint Application Development (JAD) sessions with IT Groups, and Conflict Management.
- Cogent facilitation skills in Use Case walkthroughs, requirements elicitation sessions, and knowledge transfer sessions for personal and commercial lines of business.
- Exceptional in creating screen mock-ups, wire frames, User Interface/Graphic User Interface (UI/GUI), context diagrams, business business process flows, and in developing Use Case Diagrams, Behavior Diagrams (Sequence Diagrams and Activity Diagrams) based on the UML Methodology.
- Experienced in Software Development Life Cycle methodologies (Waterfall Model, Iterative, Agile SCRUM)
- Quality Assurance experience in formulating and reviewing test plans, test scripts, test requirements, test cases, test reports, and adept in using defect-tracking tools to address issues as required by the project.
- Demonstrated experience in conducting User Acceptance Testing (UAT) and documenting test cases in both personal commercial line of property and casualty insurance.
- Using knowledge and ability to execute projects using various Software Development Life-Cycle (SDLC) methodologies - WaterFall, Iterative, Agile (Scrum/Kanban), provided Agile Coaching and transition/transformation from full SDLC Waterfall to 100% Agile.
- Actively participating in Post Production Validation (PPV), production support, and handling of issues.
- Expert in tracking and managing requirements through Requirement Traceability Matrices (RTM)
- Handling Change Management by conducting Impact Analysis & facilitating Change Control Board (CCB) Meetings .
- Excellent technical skills in SQL to extract, transform and loading data to the database using tools such as Guidewire Data hub.
- Proven track record in project execution, end-to-end project delivery, and refinement and enhancements using various iterative models within the stipulated time, resources, and cost constraints.
TECHNICAL SKILLS:
Management Tools: Power Designer, Rational Rose, Visio
Methodologies: RUP, Scrum (Agile), Waterfall, SDLC, KANBAN Waterfall
Business Modeling/Project Tools: Smart Draw, MS Visio, Just in Mind Prototype, Snag it, Axure, MS Office Suite-Certified Expert (Word, Excel, PowerPoint, Access), SharePoint, Confluence
Database: RDBMS Oracle, MS Access, IBM DB2, SQL Server 2000
Programming Languages: SQL, UML, XML, Java, HTML, COBOL, CICS, VSAM, Mainframe, C, C++, Java, Python
Defect Tracking Tools: HP Quality Centre, ALM, QTP, Jira, SixSigma, Bugzilla, Mercury
Data Analysis/ Defect Management Tools: Tableau, R Studio, Power BI, MS Excel (VLOOKUP, Report and Dash Boards, Pivot Tables), SSAS, SSRS
ETL Tools: Guidewire Data Hub Center, SSIS, Bugzilla, Quality Center, JIRA, SILK Central
Operating Systems: Windows 8.1, 8, Vista, XP, Unix, Mac OS X
PROFESSIONAL EXPERIENCE:
Confidential - Raleigh, NC
Business Analyst /Data Analyst (Property and Casualty)
Responsibilities:
- Utilized the guidelines and artifacts of the Rational Unified Process (RUP) to develop a detailed implementation process of Guidewire ClaimCenter Integration during different iterations and phases in Software Development Life Cycle (SDLC)
- Managed Lean Six Sigma, Agile, Scrum, Kaizen and Kanban-based systems in a Scaled Agile Framework (SAFe) and business process improvement programs.
- Designed and wrote use cases with Rational Rose activity diagrams and use case models as illustrations.
- Designed automated test cases using Rational TestManager and Rational Robot.
- Performed as a liaison between Stakeholders, Subject Matter Experts (SMEs) business users, and Development Team to identify the business needs, business rules and business process specification for the implementation.
- Worked closely with both internal and external business units of the firm to design custom reports, and use-case models, adhering strictly to the allocated budget and standard accounting principles.
- Participated in writing SQL queries for Data Loading along with the databases team
- Used advanced excel to aggregate and analyze data structures, formats, missing data, and other issues.
- After some tests and bug fixes, finally implemented the new Database Management system to full capacity, giving the firm a whole new way to serve their growing list of clients.
- Documented Claims assignment details in Vision and business Requirement Documents (BRDs), Functional Requirement Documents (FRDs) using Rational Requisite Pro and Power Designer.
- Performed GAP analysis on the traditional claims system and newly integrated ClaimCenter and carefully elaborated application enhancement specifications detailing in scope/out of scope items, as-is/to-be process maps and critical test scenarios.
- Designed Use Case modeling originating from First Notice of Loss (FNOL) to Claim-case closure, drafted Narrative Use Cases and created UML diagrams such as Use Case Diagrams, Sequence diagrams and Flow Diagrams (business /System) using MS Visio.
- Shared and tracked updated versions of project specific documents such as business Requirement Documents (BRDs), Functional Requirement Documents (FRDs), RTM, using SharePoint.
- Dispensed automated claim segmentation and assignment, automated triggers and escalations and seamless integration based structured walkthrough to the developers to understand the Use Cases.
- Worked with quality control teams to develop test plans, test cases and test scripts based on functional performance criteria and usability.
- Implemented Software Quality Assurance development policies and test procedures. Documented test scripts according to the business specifications and design documents.
- Systematized and Executed UI/GUI Testing, Progression, Regression testing and provided support for User Acceptance Testing (UAT) for multiple iterations involving the entire Policy Holder environment setup.
- Garnered technical prowess on Change Management by performing Impact Analysis for Change Requests obtained during Claims processing lifecycle.
- Frequently used Requirements Traceability Matrix (RTM) for identifying and tracing the linkages among PolicyCenter, BillingCenter and ClaimCente
- Conducted policy holder's standpoint based manual application tests.
- Extensive experience in extracting UI based information by querying the Oracle database using SQL queries.
- Used SQL during the testing phase to verify and validate that the correct information is being provided.
- Orchestrated User Acceptance Testing (UAT) and Post production validation (PPV) of premium pricing, reimbursement rules to guarantee that all the data model, business rules, workflows and user interface requirements have been fulfilled by the web application.
- Worked closely with PM during RACI review process and release management for seamless integration.
- Fully engaged in product release and deployment to end-users after successful development and testing of the product. Participated in preparing training material for agents and policy holders and created thorough documents.
Environment: RUP methodology, Power Designer, MS Visio, UML, SQL, MS Excel, MS PowerPoint, SharePoint.
Confidential - Dublin, OH
Business Analyste /Data Analyst (Property and Casualty)
Responsibilities:
- Researched and Analyzed business needs and ways to improve property and casualty specifically policy contracts and processes administration
- Collaborated with the business team in the creation and completion of project charters and project scope for Guidewire PolicyCenter.
- Captured business requirements in form of user stories using JAD sessions, brain storming sessions, focus groups and personal interviews to understand current policy administration system and ensured coverage on business values, story points and acceptance criteria.
- Optimized Lean Six Sigma resources, speeding projects up to 3x. Lean Six Sigma studies resulted in consistently long deliveries
- Responsible for developing a Survey of a large sample of certified internal users to establish risk assessment guidelines for Lean projects .
- Identified gaps in existing Policy Administrating Systems and Guidewire PolicyCenter and diligently designed as-is and to-be process, in scope and out of scope documents.
- Created Use Case models for policy creation to policy end using UML diagrams like Use Case Diagrams, Sequence diagrams and Flow Diagrams using Rational Rose.
- Analyzed and checked for missing values, data structures, data sanity of the legacy system's data using R Studio.
- Trouble shoot overlap and data quality issues by looking through the office of existing policy administration's data lineage, systems, and triggers for signs of bugs and malfunction.
- Performed data integration and data mapping and data extraction management along with data cleansing while migrating data from legacy system to Guidewire PolicyCenter with Guidewire Data Hub.
- Elicited, documented, modeled, validated and prioritized functional and non-functional requirements using interviews & data analysis for insurance policy lifecycle i.e. right from policy creation to policy renewal.
- Helped the product owner in creating product backlogs and Sprint Backlogs.
- Collaborated with the Scrum Master and Scrum teams in Estimation and Velocity planning. Also, participated in conducting Sprint Planning, Daily Stand Up, Sprint Review & Retrospective meeting.
- Assisted the Scrum Master to prepare and monitor burn-down charts for the successful completion of tasks within the time-boxes.
- Managed sprints i.e. burn down charts, project velocity, sprint backlogs and product backlogs using JIRA.
Managed, Shared and tracked version histories of product backlog documents, sprint backlog documents and burn down charts with Confluence tool.
- Performed data integration and data mapping management along with data cleansing while migrating data from legacy system to Guidewire PolicyCenter.
- Performed Walkthroughs of business requirements and functional requirements with the development and testing teams.
- Set up definitions and process for scoping, document test cases, test phases included integration testing, end to end testing and user acceptance test (UAT) and documenting the results for policy underwriting rules, rewriting rules, policy rate making and pricing.
- Analyzed data patterns and trends using Power BI at the time of analysis and UAT.
- Validated Rating Algorithms for Schedule Rating, Experience Rating and Retrospective Rating using Guidewire Rating Management components.
- Facilitated the Post Production Validation and actively participated in production call support whenever necessary and ensure smooth running of the system in real time
- Created training guides, assisted in deployment with step-by-step instructions and created appropriate GUI screenshots for underwriters, agents, claim staff, auditors.
Environment: Agile Methodology, SQL Server, MS Office, MS SharePoint, Power BI, Guidewire Policy Center 8.0, Confluence by Atlassian, JIRA.
Confidential - New York, NY
Business Analyst/ Guidewire Consultant
Responsibilities:
- Interacted with the project team to assign priority to Projects based on dependency and criticality
- Conducted JAD sessions with extensive involvement from business, Development, Testing teams, Architects,
- SME's (Subject Matter Experts) and Managers of various business Units
- Documented requirements associated change requests with requirements and connected requirements with Use cases.
- Involve in UAT Testing. Responsible in preparing personal and team' s daily and weekly status report
- Regarding the process of UAT testing process.
- Developed a thorough and repeatable software requirements methodology utilizing the Rational Unified
- Process (RUP) and Unified Modeling language (UML)
- Defined the project methodology from RUP. Analyzed and redefined the business processes with specific UML documentation
- Responsible for defining the scope of the project on Defined Benefit plans, Qualified Plans and Non-Qualified plans and gathering business requirements and doing gap analysis.
- Understood and articulated business requirements from user interviews and then converted requirements into technical specifications.