SUMMARY

• Over 8 years of professional experience as a Business Analyst with expertise in business process analysis, business requirement and business analysis in the field of Insurance and Reinsurance.
• Experienced in all insurances such as Property and Casualty Insurance (P&C) including Auto, Home, and Marine; Life insurance (Individual, Group).
• Functional knowledge of various modules of insurance like channel management, claims management, underwriting and reinsurance.
• Worked with Guide wire Insurance suit (Policy Center).
• Strong business analysis skills and an understanding of the Software Development Life Cycle (SDLC) utilizing Rational Unified Process (RUP), Agile (Scrum, XP).
• Experienced in conducting requirement analysis, use case design, test plans and developed database schemas based on the logical models.
• Expert in requirement gathering and documenting the requirements in business requirement documents.
• Expertise in Data Quality Management, Data mapping, Data Modeling, Data Analysis, Requirement Analysis, Business Modeling, Data Migration, Data profiling, Dimensional Modeling.
• Worked extensively with Use Cases and Test cases and delivered Functional Specifications and Software Requirement Specification.
• Ability to gather business and technical requirements from both formal and informal sessions utilizing a variety of software tools including, Use Cases.
• Expertise with UML tools, applied for developing Use Case Diagrams, Activity and Sequence diagrams.
• Extensive experience with Data Warehousing, Extraction, Transformation and Loading process (ETL).
• Knowledge for working with User Acceptance Testing (UAT) and Functionality Testing.
• Deep understanding of Database management system, Data warehousing concepts, Business Intelligence technologies and Data mining.
• Experienced in Implementing Normalization/Denormalization techniques for optimum performance in OLTP/OLAP database environments for Business Intelligence’s function
• Excellent skills in writing Business Requirement Documents(BRD), Decision Documents, Functional Requirement Documents (FRD), SRS and diagramming skills for drawing UML diagrams such as Class diagrams.
• Developed efficient business relationships with various client teams in order to process and support requirements, develop tactical and strategic plans to implement technology solutions, and effectively manage client expectations.

TECHNICAL SKILLS

• Guide wire
• MS Visio
• Share Point
• QC
• Test Director
• MS SQL Server 2000/2005 (T - SQL)
• Load Runner
• MP
• Erwin
• Oracle
• Jira
• DB2
• SQL
• Microsoft Office
• MS Project
• HP Quality Center
• Web Services
• Waterfall Model
• Agile
• Methodology (SCRUM)
• Rational Unified Process (RUP).

PROFESSIONAL EXPERIENCE

Confidential

Business Analyst

Responsibilities:

• Worked with Scrum team to Keep Scrum process running and help the Team focused on the current Sprint to achieve Sprint goals.
• Worked with Personal lines in property and casualty ( Auto, Home, Watercraft ) with underwriters and marketing side.
• Worked with Guide wire team for eliciting the requirement for Alfa team.
• Interacted with the project team to define system objectives and scope, identified constraints and the measures of success for the system
• Conducted user interviews and JAD sessions to get an understanding of the client’s business process and preparing workshops for SMEs.
• Gathered primary input/output requirements and modeled the processes in context diagram using MS Visio.
• Gathered functional requirements from business users, Product Owners, Stakeholders.
• Assisted the Project Manager in understanding the project feasibility from Business view point and preparing meeting minutes and summery for team.
• Responsible for creating the Business Requirements Specification Document (BRD) and Decision Document in High level for legacy system of Alfa and working with business Leads of EY company for transferring GW Ideas to Alfas Legacy system.
• Worked directly with business groups to provide hands-on aged in project work.
• Participate in workshops for conducting the team of Policy center for running the project such big Gap analyses sessions.

Confidential, CT

Business Analyst

Responsibilities:

• Worked with Scrum team for running the project in reinsurance process.
• Facilitated JAD sessions to get an understanding of the client’s business process.
• Assisted the Project Manager in understanding the project feasibility from Business view point.
• Responsible for creating the Business Requirements Specification Document (BRD) and the Functional Requirement Document (FRD).
• Worked with property and casualty side for eliciting specific requirement for documentation.
• Liaised between technical and business teams for obtaining status/updates as well as sharing best practices.
• Worked directly with business groups to provide hands-on aged in project work.
• Working closely with users to ensure the project meets business needs and final approval of the Design Specification.
• Definition and management of the User Acceptance Testing program (UAT).
• Involved in maintaining the Requirements Traceability Matrix (RTM) across the deliverables for a project.
• Followed the UML based methods to create: Use Cases and Activity Diagrams.
• Conducted the requirements and design walkthroughs with designers, developers and management staff.
• Performed manual testing and recorded results.
• Executed the test scripts and test cases and validated the test output.

Confidential, IL Chicago

Business Analyst

Responsibilities:

• Facilitated (JAD) Joint Application Development sessions to resolve issues relating to difference between business requirements and technical design based on all line of business in property and casualty side.
• Interacted with the end users to define and document data warehouse business requirements as the foundation for database design, data extraction and analysis.
• Examined Enterprise Data Warehouse (EDW) to ensure compliances with upgrade requirements, and generated documents for the workflow of existing system and desired system that involve multiple RDBMS sources like policy database, billing database.
• Derived functional specifications using UML models including use case diagram, activity diagram, and sequence diagram, and collaborated with software architects and developers to ensure that the applications conform to the requirements and helped to understand the business flow.
• Designing and creating the architecture of data warehousing star schema logical database model.
• Developed detailed ETL process.
• Maintained Traceability Matrix for the current business processes and proposed changes.
• Coordinated with the business testing team to explain and develop the Test Plans, Test cases, Testing & Evaluation strategy and methods for user acceptance testing (UAT).
• Developed test plans with QA team and helped to develop test scenarios for system testing, integration testing and performance testing.
• Conducted UAT, documented and reported user feedbacks to management team, and developed materials for different end users and assisted in User for the new system.

Confidential, TX Austin

Business Analyst

Responsibilities:

• Worked with Agile methodology (Scrum) to Keep project process running and help the Team focused on thecurrent Sprint to achieve the goal of project.
• Conducted user interviews and JAD sessions with end users, stake holders and developers to gather functional and nonfunctional requirements of the system, and creation of user stories for property and casualty side.
• Assessed the flaws in the existing as-is system and made clear recommendations of business process improvements and incorporated them in the to-be system design.
• Wrote business requirement Document (BRD) and functional requirement specification (FRS) documents as per the business requirements and process flow.
• Developed UML Use Case diagrams for faster and more efficient communication with stakeholders, by utilizing MS Visio.
• Making sure current project requirements are being met by using Requirement Traceability Matrix (RTM)
• Actively involved in creation of the UML diagrams such as sequence, activity and class diagrams for certain modules of the application using MS Visio.
• Assisted and directly involved with QA team in creation of Test Cases and tests implementations.
• Presented and assisted end users for and about the new system.

Confidential

Business Analyst

Responsibilities:

• Gathered business requirements through interviews, surveys, prototyping and observing from account managers and UI (User Interface) of the existing broker portal system. Worked with Agile (Scrum) to keep project process running.
• Conducted JAD sessions with management, SME (Subject Matter Expertise), vendors, users and other stakeholders for open and pending issues to develop specifications.
• Worked with all lines of property and casualty and underwriting team.
• Conducted controlled brainstorming sessions with project focus groups.
• Created job schedules to automate the ETL process.
• Worked on data modeling and produced data mapping and data definition documentation
• Configured the Data mapping between Oracle and SQL Server 2005.
• Designed and implemented basic SQL queries for testing and report/data validat.
• Developed strategies for Data Scrubbing, Cleansing, Enriching, transforming and loading Data in Staging/Data warehouse.
• Prepared high-level Logical Data models and BRD’s (Business Requirement Documents) supporting documents containing the essential business elements, detailed definitions, and descriptions of the relationships between the actors to analyze and document business data requirements.
• Planned and defined system requirements to Use Case, Use Case Scenario and Use Case Narrative using the UML (Unified Modeling Language) methodologies
• Created Use Case Diagrams, Activity Diagrams, Sequence Diagrams in MS Visio.
• Used the Data Stage Director and its run-time engine to schedule running the solution, testing and debugging its components, and monitoring the resulting executable versions on an ad hoc or scheduled basis.
• Enhanced the job properties for performance tuning.
• Conducted User Acceptance Testing on the application - resolved issues from the participants, prepared and submitted Test Analysis Reports and participated in Product Readiness Review.
• Prepared the documentation of Data Acquisition and Interface System Design.