Sr. Business System Analyst/data Analyst Resume
4.00/5 (Submit Your Rating)
Raleigh, NC
SUMMARY:
- 7+ years of experience as a Business System Analyst/Data 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.
- Well versed in claim management i.e. FNOL, Claim Setup, Payment and Recovery, Fraud Detection Tools, Litigation, Subrogation and Salvage.
- Comprehensive knowledge of Software Development Life Cycle (SDLC) and various methodologies such as Agile, RUP, Waterfall.
- 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.
- Expert in Data Visualization, Data Analysis, Business Intelligence.
- 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.
- Exceptional in creating screen mock-ups, wire frames, User Interface/Graphic User Interface (UI/GUI), context diagrams, business process flows, and in developing Use Case Diagrams, Behavior Diagrams (Sequence Diagrams and Activity Diagrams) based on the UML Methodology.
- 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.
- 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.
- Good understanding of Object Oriented Analysis and Design (OOAD)
TECHNICAL SKILLS
- Property and Casualty
- claims
- billing
- policy
- guidewire
- insurance
- Ba ke keywords
- etc etc
- and search others in dice portal
- Smart Draw
- MS Visio
- Just in Mind Prototype
- Snag it
- Axure
- MS Office Suite - Certified Expert (Word
- Excel
- PowerPoint
- Access)
- SharePoint
- Confluence
- Bugzilla
- Quality Center
- JIRA
- SILK Central
- RDBMS Oracle
- SQL
- UML
- B FRD XML
- Java
- HTML
- COBOL
- CICS
- VSAM
- Mainframe
- Windows 8.1
- 8
- Vista
- XP
- Unix
- Mac OS X
- Data Hub Center
- SSIS
- Tableau
- R Studio
- Power BI
- MS Excel (VLOOKUP
- Report and Dash Boards
- Pivot Tables)
- SSAS
- SSRS
- MS Access
- IBM DB2
- SQL Server 2000
- Testing
- Aml
- Documentation
- Excel
- BI
- Coda
- Cognos
- Ibm
- Stress Testing
- Cognos
- Data Management
- DI
- PowerPoint
- Jira
- Power Designer
- Gap Analysis
- Data Migration
- Sprint
- Smoke Testing
- Forecasting
- UAC
- Rational Unified Process (RUP)
- Waterfall
- Agile
- SDLC
- SharePoint Documentation
PROFESSIONAL EXPERIENCE
Confidential, Raleigh, NC
Sr. Business System Analyst/Data Analyst
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)
- Worked closely with PM during RACI review process and release management for seamless integration.
- Investigate, evaluate, negotiate, and settle auto claims. This includes application and knowledge of policies, procedures, laws, statutes, and insurance regulations when determining coverage, liability, and property damage. Utilization of general computer applications (MS Word, Excel, Outlook, and Power Point) as well as computer applications specific to the role
- Build report and establish relationship with customer as you work to formulate insurance policies to fit their individual needs
- Managed all levels of injury claims ranging from minor to catastrophic injuries requiring home office reporting and excess carriers.
- Handled Private insurance information, provided policies for home owners, updated policy information, and took incoming calls during entire shift.
- Makes strategic recommendations for reducing the frequency and severity of losses through the use of a workers' compensation database and/or other claims data reports; designs and develops data bases, performs integrated data analyses, and prepares reports.
- Lead all areas of Workers' Compensation administration, to include the building and establishment of the program, complex data collection, report review, claims investigation, expedited information sharing, problem resolution and all aspects of record keeping to meet employee health needs in accordance to the Enterprise Risk Management plan.
- Investigate and evaluate Worker's Compensation claims, proactively identify injury trends, and assist in creating action plans and strategies to reduce employee injuries; compile data for OSHA reporting.
- 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.
- 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.
- 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 Claim Center 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.
- 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 ClaimCenter.
Environment: RUP methodology, Power Designer, MS Visio, UML, SQL, MS Excel, MS PowerPoint, SharePoint.
Confidential, Dublin, OH
Sr. Business Analyst
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.
- Multi-tasking in a high volume call-center while assisting clients with any changes to their autoinsurance policy.
- Thoroughly explaining/answering any inquiries the client may have about their auto policy.
- Responsible for ordering, following up and processing home owners insurance documents
- Contact home owner insurance companies and agents to obtain and verify client's policies
- Determines appropriateness and amount of worker's compensation claims; investigates individual claims for eligibility for workers' compensation benefits; ensures that all legal and procedural requirements are met for the processing of claims, in order to ensure proper and timely payment to employees and medical facilities.
- Provides authoritative advice and counsel to Manager on the interpretation and application of worker's compensation policies, legislation, regulations, and processes.
- Coordinates and participates in strategic planning aimed at reducing the incidence of worker's compensation-related injuries onsite.
- 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.
- 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.
- 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.
- 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.
Confidential, Pekin, IL
Business Analyst
Responsibilities:
- Worked as Business Analyst for the project on Workers Compensation line of business to gather and document as is flow and future business flow using Guidewire PolicyCenter.
- Conducted gap analysis and documenting pain points with legacy system.
- Worked on documenting product model using GW template and gather prequalification questions, coverages, conditions, exclusions, modifiers, schedule rate factor.
- Documented "Accounts type', Submission Wizard', process for 'cancellation, adjustment', BPR, Product Model & form inference rules, Risk score, Rate Books, UWI approvals, UW Authority limits based on roles & Groups, user administration load, activity pattern, workflow rules, and documenting requirement.
- Facilitated JAD session with stake holders to identify new requirements not available within Guide wire and write use case.
- Documented configuration & data migration/conversion requirement for available functions within Guidewire PC including users, roles, permissions, regions, Managing Catastrophes and business types.
- Developed Data Flow Diagram and data mapping documents
- Identified issues and troubleshoots to provide timely resolutions and performs root cause analysis.
- Ensured validity, quality and accuracy of internal and external data reports, files and all other deliverables.
- Working with underwriter managers, underwriters and associates to gather the requirements.
- Worked with Rating team to gather requirements for Rating Engine (rate books, rating table, rate parameters, versioning, rating routine, rating worksheet, import and export of XML and correcting per specifications.
- Facilitated JAD/RDW session with stakeholders to identify new requirements not available within Guide wire and write use cases, wireframes and FLS (Field Level Specifications).
- Worked with QA team for test scenarios, test scripts, defect triage and documents update.
- Orchestrated User Acceptance Testing (UAT) 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 policyholders and created thorough documents.
Environment: GW-Policy Center 8.0, FileNet, MS Office Suite (Word, Excel, Access, PowerPoint, and Outlook), MS-Project, Visio, HP Quality Center, SharePoint.
Confidential, Montgomery, AL
Business Analyst
Responsibilities:
- Utilize the guidelines of Agile to develop a detailed implementation process ofGuidewire Claim Center Integration during different iterations and phases in Software Development Life Cycle (SDLC).
- 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.
- Documented Policy integration and claims assignment details in Vision and User Stories.
- Successfully implemented call center CRM solutions related to assessment of loan applications for claim investigation and loan payment tracking.
- Successfully led and conducted JAD sessions to facilitate business process agility and to identify the content flows and processes.
- 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.
- 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.
- 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) 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 policyholders and created thorough documents.
Environment: Agile Methodologies, Windows, MS-Visio, Microsoft office, Guidewire.