SUMMARY

• 7+ years of experience as a Business Data Analyst with solid understanding of Business Requirement gathering, Business Process flow, Business Process Modeling, 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
• Actively involved in Underwriting the rules for the Property & Casualty Insurances
• Planned, directed, and managed designated projects for the Property & Casualty application.
• Expert in commercial Property and Casualty and Personal Lines Insurance experience with national carriers.
• P&C and life Insurance Domain and Policy Management applications as my main experience area.
• Responsible for working with Business Owners/Client to capture the Business/Project Requirements.
• Experience with requirements specification and development for Process/Functional Requirements definition methods, JAD/RAD sessions, use case development, and process flow diagrams.
• Expertise in Functional and Database Testing related activities.
• Worked for major US based clients and Holds strong understanding and experience in all phases of SDLC such as waterfall model, agile model and V model.
• Experienced in requirements analysis, elicitation, BRD and FRD documentation, user stories creation, estimation activities, configuring the system for testing and coordination across teams, test planning, test design and preparation, test execution, defect management and test closure activities.
• Expertise to work on AWD to design processes,presentation flows,and implement predefined Web services.
• Major experience in Insurance suite product(s) like Guidewire, Insurity and with other proprietary insurance applications
• Experience in Data Profiling, Data Manipulating and Data Parsing using complex SQL queries against various Database Environments.
• Worked on relational database management systems like Oracle, TeraData, DB2, and SQL Server and extensively worked on DataIntegration using Informatica for the Extraction transformation and loading of data from various database source systems and mainframe COBOL files.
• Design and review of various documents including the Software Requirement Specifications (SRS), Business requirements document (BRD), Use Case Specifications, Functional Specifications (FSD), Systems Design Specification (SDS), Requirement Traceability Matrix (RTM) and testing documents.
• Experienced in facilitating JAD sessions, JAS sessions. Conducting Structural walkthroughs, surveys, questionnaires, interviews, brainstorming sessions.
• Good understanding of Data Modeling with Star and SnowFlake Schemas, FACT and Dimensions Tables, Physical and Logical Data Modeling using Erwin.
• Sound Knowledge of data architecture concepts, data warehouse and datamarts.
• Extensively used Rally for maintaining User Story Hierarchy, Backlog Grooming, Updating Tasks, Connecting Rallywith Jira and Quality Centre, Planning Iterations and Releases
• Good knowledge of Web Services, SOAP programming, WSDL, XML technologies DTD, SAX and XSLT
• Expert in the Property, Casualty, Annuities, Disability, and Supplemental Insurance policies include administration, sales, customization, claims, pensions and CMS.
• Worked on Property and Casualty insurance company as an Underwriter. Strong understanding of rating in Property and Casuality, Worked on business and functional requirements to identify potential enhancements to AWD .
• Planned and defined system requirements to Use Cases, Use Case Scenarios and Use Case Narratives using the UML methodologies. Created Process Diagrams,
• Use Case Diagrams, Activity Diagrams, Sequence Diagrams in MS Visio, created Wire Frames during the Elaboration Phase.
• Expertise ability to worked on system suite and it is mainly integrated within products like PolicyCenter, Claims Center, BillingCenter and Contact Management System in a Service Oriented Architecture.
• Analyzed standard industry practices of back office applications of Insurance Company including underwriting, policy & claims with the help of Subject Matter Expert.

PROFESSIONAL EXPERIENCE

Confidential, Bloomington

Business Analyst

Responsibilities:

• Worked on UAT testing and took signoff from the Commercial line of Property & Casualty business users.
• Used AWD to centralize all documents associated with a piece of work in an electronic folder for easy access and review.
• Strong experience with Guidewire and Insurance/Finance tools in Life Sciences, Property and Casualty domains.
• Worked on Property and Casualty insurance company as an Underwriter with Solid understanding in Property and Causality.
• Lead multiple project teams of technical professionals through all phases of the SDLC using technologies including Oracle, Erwin, DataStage, Data Warehousing, Websphere and Cognos.
• Used Data warehousing for Data Profiling to examine the data available in an existing database.
• Worked on data modelling and produced data mapping and data definition documentation
• Used Informatica to extract and transform data from various DB2 database to the data warehouse..
• Document software defects, using a bug tracking system, and also report defects to software developersInvolved in Planning, analyzing bugs, Execution and Bug Tracking.
• Monitor bug resolution efforts track successes. identify, analyze, and also document problems with program function, output, online screen, or content .
• Evaluate or recommend software for testing or bug tracking utilized Test Director for defect tracking, Excel for managing the test scripts.
• Created Process Flow diagrams, Use Case Diagrams, Class Diagrams and Interaction Diagrams using Microsoft Visio and Rational Rose.
• Involved in generating Test cases for property and casualty Insurances for Different Levels of Business.
• Provided key initiatives in working with users in defining project and system requirements.
• Responsible for testing the Quote & Purchase for both Auto and Home Property Insurance of the customers.
• Conducted Joint Application Development (JAD) sessions with IT groups. Identified the Key Changes, and participated in Stakeholder Management to communicate effectively with them
• Responsible for the development of a Data Warehouse for personal lines property and casualty insurance.
• Implement and maintain Property & Casualty (e.g. bug - fix, data integration, version release) systems of assigned customers.
• Resolved the data related issues such as: assessing data quality, data consolidation, evaluating existing data sources.
• Acted as primary liaison between 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.
• Gathered, analyzed and documented both business and technical requirements from formal and informal sessions and validated the needs of the business stakeholders.
• Interacting with the developers on resolving the reported bugs and various technical issues.
• Experience in testing applications for Commercial Lines Insurance such as Ocean Marine, Other Liability, Commercial Automobile, General Liability and Commercial Property.
• Assisted the QA team in designing the Test Plan and Test Cases for User Acceptance testing.
• Worked as a Personal line of Property and Casualty Expert for interface to Insurer Business Partner on all facets of system design.
• Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, OOD using UML
• Performed requirement analysis, went through all the use cases and issue logs.

Confidential, Nashville, TN

Business Analyst

Responsibilities:

• Interacted closely with End users from Underwriting & Claims teams and SMEs to understand and gather the business needs and requirements.
• Worked on Commercial lines Property and Casualty Insurance including both policy and claim processing and reinsurance.
• Worked on Property and Casualty insurance company as an Underwriter. Strong understanding of rating in Property and Casuality.
• Insurance experience includes Personal Property Casualty and Commercial Automobile Product knowledge, Reinsurance for Commercial Property Casualty, Group and Life Insurance Systems,
• Worked on Commercial lines Property and Casualty Insurance including both policy and claim processing and reinsurance
• 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.
• Worked on Property and Casualty insurance company as an Underwriter. Strong understanding of rating in Property and Causality.
• Designed the aggregation and refresh strategy of the data warehouse.
• Plan, design, and implement operational data store (ODS), data warehouses and data marts including capacity planning, dimensional data modeling, data analysis, schema design, batch and real-time load processes.
• Design and implement the Master Data Management (Informatica MDM, IDQ) and Meta Data Management systems as part of the Enterprise Data warehouse.
• Worked on UAT testing and took signoff from the Commercial line of Property & Casualty business users.
• Have sizeable adequate hands on exposure in Workmen Compensation, Commercial Insurance as well as Property & Casualty Insurance & its various intricacies.
• Worked on Commercial lines Property and Casualty Insurance including both policy and claim processing and reinsurance.
• Worked on UAT testing and took signoff from the Commercial line of Property & Casualty businessusers.
• Responsible for the development of a Data Warehouse for personal lines property and casualty insurance.
• Accumulated system requirements from various departments through surveys and interviews.
• Involved in prioritizing the defects and writing business requirements to resolve them.
• Conducted JAD sessions with management, SME, vendors, users and other stakeholders for open and pending issues.
• Planned and defined system requirements to Wire Frames with Use Case, Use Case Scenario and Use Case Narrative using the UML (Unified Modeling Language) methodologies.
• Created Use Case Diagrams, Activity Diagrams, Sequence Diagrams and ER Diagrams in MS Project.
• Analysis of business requirements and system requirements of the client and also for Property and casualty modules.
• Worked on the commercial property and casualty domain and made specific changes to the same for the smooth flow of the process.
• Worked for a project to customize and integrate a Business Process Management (BPM) solution.
• Developed automated Test Scripts in Win Runner using Test Script Language (TSL) for Functional Testing, Regression Testing, Data Driven Testing, Usability Testing, and Verifying Specific content through using Checkpoints
• Self taught intricacies of the Property & Casualty Insurance domain including the specialized forms of property
• Debugged and fixed several production issues. Created Struts actions which encapsulate business logic of the application.
• Worked extensively with MS Excel and MS access
• Extraction, Transformation was performed using SQL and PL/SQL embedded COBOL programs was used to build the company data warehouse.
• Responsible for special projects requested by company management or reinsurance broker involving analyzing underwriting revenue and financial performance for companys reinsurance broker.

Confidential, San Francisco, CA

Business Analyst

Responsibilities:

• Performed Gap Analysis to check the compatibility of the existing system infrastructure with the new business requirements.
• Analyzed system requirements and developed detailed Test plan and Test cases for testing the functionality.
• Responsible for meetings with users and stakeholders to identify problems, resolve issues and improve the process to ensure a stable and accurate solution.
• Applied Unified Modeling Language (UML) methodologies to design Use Case Diagrams, Activity Diagrams, Sequence Diagram and ER diagrams.
• Developed and enforced the Data Warehouse methodology - integrated data marts using Kimball methodology.
• Involved in preparing SDLC Documents such as Business Requirement document (BRD), Functional Specification document (FSD), Test Plan, Test Report.
• Extensively used Test Director to review and update the status of entire testing process.
• Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, OOAD using UML andBusiness Process Modeling.
• Ensured that the Data warehouse contains cleaned, integrated data so that it serves as the 'single source of truth' for all reporting and other downstream consumption.
• Query and analyze data from Oracle, legacy JDEdwards and proprietary property management database utilizing high-level Excel and Access functions.
• Responsible for implementing new Property & Casualty products to the center as directed by the regional offices, establishing best practices, clearly defined requirements and process flows to support the processing of new products.
• Followed solely RUP methodologies during the course of the project.
• Accumulated system requirements from various departments through surveys and interviews.
• Involved in prioritizing the defects and writing business requirements to resolve them.
• Conducted JAD sessions with management, SME, vendors, users and other stakeholders for open and pending issues.
• Liaison with Property & casualty underwriting to decide Eligibility rules for the new customers based on Customer Underwriting Index Model
• Experience in Property and Casualty (P&C) claims and working in Quality Center (QC) v11.0.
• Conducted extensive Joint Application Development (JAD) sessions for all business related issues.
• Planned and defined system requirements to Wire Frames with Use Case, Use Case Scenario and Use Case Narrative using the UML (Unified Modeling Language) methodologies.
• Created Use Case Diagrams, Activity Diagrams, Sequence Diagrams and ER Diagrams in MS Project.
• Research terms of property leases, subleases, collocation agreements and Management Service Agreements. Reviewed site-engineering reports to ascertain substantial completion dates in order to resolve commencement date and term discrepancies between vendor and Cingular.
• Documented the mappings used in ETL processes, worked extensively with MS Excel and MS access