We provide IT Staff Augmentation Services!

Sr. Business System Analyst Resume

2.00/5 (Submit Your Rating)

New York, NY

SUMMARY

  • 7+ years of experience as a Business Analyst with solid understanding of Business Requirement gathering, Business Process flow, Business Process Modelling, Data Analysis, Data Mapping and Business Analysis.
  • Insurance experience includes Personal Property Casualty and Commercial Automobile Product knowledge, Reinsurance for Commercial Property Casualty, Group and Life Insurance Systems
  • Extensive experience in conducting Market Research, Feasibility Studies, Data Analyses, Data Mapping Gap Analyses, Risk Identification, Risk Assessment, Risks Analyses, and Risk management
  • Diverse experience in Property and Casualty, Underwriting, Guidewire, Rating, Reinsurance and Life Insurance.
  • Knowledge of Guidewire Insurance Suite for Personal and Commercial Autos, Workers Compensation, General Liability, Inland Marine, and Personal Liability.
  • Experience in gathering business requirements for Duck creek, PEGA, .NET, Angular JS, EXT JS and mainframe applications, based front end and back - end application, client/server architectures, legacy and web-based system.
  • Expert in the Property, Casualty, Annuities, Disability, and Supplemental Insurance policies include administration, sales, customization, claims, pensions and CMS.
  • Extensive knowledge of Life Insurance Platform which supports Life products (Universal Life & Variable Universal Life) and Annuity Products (Variable and fixed annuities).

TECHNICAL SKILLS

Operating Systems: Microsoft Windows, Mainframe

Databases & Tools: SQL, Access, MYSQL, Oracle

Quality Management: HP ALM/Quality Center, Rational Test Manager, QTP/UFT, Rally, MS Test Manager (MTM), Team Foundation Server (TFS)

Business Modeling Tools: Rational Rose, Microsoft Visio, MS Excel, MS PowerPoint

Project Management: Microsoft Project Professional

SDLC Methodologies: Agile, RUP, Waterfall, Spiral, Iterative, UML, Six Sigma, CMM

PROFESSIONAL EXPERIENCE

Confidential, New York, NY

Sr. Business System Analyst

Responsibilities:

  • Proficient in Duck Creek Session XML and Data Model for Commercial Auto, Commercial Property and General Liability.
  • Interacted with business heads to finalize the product backlog for the Guidewire application. Working on Voided Claims, Subrogated Claims and Multiple Claims in a Single Incident.
  • Formulated the ER diagrams of Property and Casualty data and data flow diagrams in order to interact with database developers.
  • Examined key Performance Indicators KPI for Property and Casualty such as Loss Ratio, General Operating Expense Ratio.
  • Worked with automation team to identify Duck creek functionalities & test scripts for automation using HP QTP.
  • Working as a Guidewire Business Analyst for the Advance Project in the Personal Lines Policy Center, which is a web-based policy administration system used for quoting and applications for all personal lines products.
  • Executed all aspects related to employee health insurance, worker's compensation, life insurance, long/short term disability, employee discount/store benefits including company events coordination.
  • Worked on Regulatory Reporting RRD Data Warehouse for compiling Workers Compensation statistical reports to external regulators and states.
  • Established and manage application processes, best practices and continuous improvement aligned with Agile-Scrum methodology.
  • Managing production design of the Duck Creek infrastructure, capacity planning and performance management.
  • Elicited business requirements by conducting structured interviews, JAD & JRP sessions, and workshops across various Commercial and Personal Auto lines within the Property & Casualty (P&C)business unit
  • Good experience in a full software development lifecycle / SDLC project environment (Agile and/or Waterfall) through to UAT and training in some cases.
  • Extensive involved in analysis of data elements from worker's compensation that includes various premium components and its calculations, loss amounts claim counts.
  • Experience in working on Policy Administration System (PAS) system for P&C on Duck Creek Technology
  • Experienced in documenting customization requirements, business rules and data migration requirements for the Implementation of Duck Creek Policy and Billing
  • Implement and maintain Property & Casualty (e.g. bug-fix, data integration, version release) systems of assigned customers.

Confidential, Princeton, New Jersey

Business System Analyst

Responsibilities:

  • Worked on Commercial lines Property and Casualty Insurance including both policy and claims processing and reinsurance.
  • Analysis of business requirements and system requirements of the client and also for Property and casualty modules
  • Also responsible for managing communication and expectations of system vendor, the former parent company IT and business departments, and Allied Worlds various business units (underwriting, claims, reinsurance, actuary, accounting, and IT).
  • Interacted with the client departments and the Information systems IT department to perform analysis, review, and estimation of client requests, prepared and reviewed requirements and client documentation for Personal Lines Property and Casualty business.
  • Utilized the guidelines and artefacts 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)
  • Responsible for special projects requested by company management or reinsurance broker involving analyzing underwriting revenue and financial performance for company’s reinsurance broker.
  • Coordinated User Acceptance Testing for all product lines and liaise with the business testers and IT with regards to Duck Creek monthly maintenance releases.
  • Worked with developers for SQL Server - database and ETL development on XML data from Duck Creek system.
  • Performed backend testing to check the system data integrity for insert, update, delete and retrieve transactions by writing complex SQL queries including joins, group by, having clause etc.
  • Worked on Property and Casualty insurance company as an Underwriter. Strong understanding of rating in Property and Causality.
  • Extremely proficient in using Agile and XP methodologies performed roles of Scrum Master following sprint sessions and used Rally software extensively to write User Stories, assign tasks to individual team members.

Confidential, New York, NY

Business System Analyst

Responsibilities:

  • Senior level SQL query skills Oracle and TSQL in analyzing and validating SSIS ETL database data ware house processes.
  • Documented report layouts and report mapping documents for ad hoc reporting based on Property and Casualty FP A team's needs.
  • Write and execute positive and negative test cases to ensure the data originating from the data warehouse Oracle dB is accurate through to the SQL dB in the applications.
  • Performed the requirement analysis, impact analysis and documented the requirements using Rational Requisite Pro and Utilized Agile experience with large and small teams.
  • Prepared requirements document for Commercial Auto, Inland Marine, Crime, Worker's Compensation, Umbrella, Business Owners Policy, Commercial Output Policy, and Commercial Property Package.
  • Involved in requirement gathering and database design and implementation of star-schema, dimensional data warehouse using Erwin Configured the Data mapping between Oracle and SQL Server.
  • Responsible for doing the strategy and business plan for CRM and campaign management solution of one business unit.
  • A new Umbrella Policy Administration System was set up to issue/quote new Umbrella insurance Policies to provide higher liability coverage limits for members.
  • The application would let customers submit online claims for Worker's Compensation Property and Casualty and the Non-worker's Compensation. The project followed Agile Scrum methodology.
  • Writing Epics and user stories, managing sprints and backlog grooming, and tracking project progress in JIRA and Performed Defect Tracking and Project Tracking using Jira

Confidential, Boston, MA

Business System Analyst

Responsibilities:

  • Gathered Business Requirements, interacted with the Users, Designers and Developers, Project Manager and SMEs to get a better understanding of the Business Process.
  • Interacted with the client departments and the Information systems IT department to perform analysis, review, and estimation of client requests, prepared and reviewed requirements and client documentation for Personal Lines Property and Casualty business.
  • Extensive involved in analysis of data elements from worker's compensation that includes various premium components and its calculations, loss amounts claim counts.
  • Conducted and participated in walkthroughs to discuss certain issues with the development, design team and QA team.
  • Extensive backend testing using SQL queries, generating the reports to ensure the data integrity and validate the business rules.
  • Helped lead the transition of Requirements Management in the Business Analyst Team to the agile methodology by creating and managing user stories and Requirements Traceability Matrices in the JIRA toolset.
  • Analyzed and optimized the process to prepare Business Requirement Document and then converted the business requirements into Functional Requirements Specification.
  • The application would let customers submit online claims for Worker's Compensation Property and Casualty and the Non-worker's Compensation.
  • Extensive involvement in Data Analysis Activities including Data Visualization, Data Profiling, Data Quality, Data Governance, Source to Target Data Mapping, Data Testing.
  • Designed Created and deployed Star Schema for data flow diagram to illustrate where data originates and how data flows within the Enterprise Data warehouse (EDW).
  • Dexterously helped development teams to break down large user stories beginning with a 'Single Sign-On' to 'Credential Manager' for execution.

We'd love your feedback!