Sr. Business Analyst Resume Profile
Profile Summary:
- 7 years of Industry experience as a Business Analyst with solid understanding of Business Requirements Gathering, Evaluating Data Sources, Translating Requirements into Specifications, Application Design.
- Insurance experience includes Personal Property Casualty and Commercial Automobile Product knowledge, Reinsurance for Commercial Property Casualty, Group and Life Insurance Systems, Health Insurance, Auto Insurance Home Owner Insurance and Crop Insurance.
- Strong understanding of project life cycle and SDLC methodologies including RUP, RAD, Waterfall and Agile.
- Extensive experience with data modeling and defining the conceptual and logical model of the data warehouse.
- Extensive experience in Business Requirements gathering and writing skills with expertise in developing and documenting Business Requirement document BRD , Functional Requirement Document FRD ,Software Requirement Specification SRS across the deliverables of a project.
- Experience in Business Process Analysis, Business Modeling, Business Intelligence, Data Warehousing, Data Modeling, User Acceptance Testing UAT and Implementation.
- Experience in facilitating Joint Requirement Planning JRP sessions with Business conducting Joint Application Development JAD sessions with IT Groups and Conflict Management with Project team members.
- Strong experience in conducting User Acceptance Testing UAT and documentation of Test Cases. Expertise in designing and developing Test Plans and Test Scripts.
- Wrote BRD, FRD, use cases, test scenarios, test cases for testing the functional and non-functional aspects of both ETL jobs and Reporting jobs.
- Expert in the Property, Casualty, Home/ Auto insurance, Annuities, Disability, and Supplemental Insurance policies include administration, sales, customization, claims, pensions and CMS. Knowledge in the ETL Extract, Transform and Load of data into a data ware house/date mart and Business Intelligence BI tools like Business Objects Modules Reporter, Supervisor, Designer, and Web Intelligence . Experienced in manual and automated testing for both front-end and backend.
- Extensively used automated test tools of Mercury like Quality Center, Quick Test Pro, Win Runner, Test Director, Performance and Load Runner Testing.
- Experience in creating custom site templates and list templates for developing web part pages for the portal using SharePoint Portal Server 2003.
TECHNICAL SKILLS:
- Languages and Tools: UML, Rational Rose, RequisitePro, Rational SoDA, Rational Clear Case, Rational Clear Quest, Mercury Test Director, Quality Center, MS Project, MS Visio, MS Office Suite, ,VBA for Excel, SQL, PL/SQL, Java, J2EE, C , VB.NET, C /CLI, Adobe Acrobat, PhotoShop, AutoCAD, 3D MAX
- Databases: Oracle 8i/9i, MS SQL Server, MS Access
Environments: Windows 9x/NT/2000/XP, UNIX Sun Solaris, AIX, HP-UX , Linux, Mainframe
Project Experience:
Confidential
Sr. Business Analyst
Assist in preparation of reinsurance submissions. Assist in underwriting assumed reinsurance for Liberty Mutual's international business unitsHandle reinsurance responses for the Statutory Annual Statement General Interrogatories, annual rating agency and state DOI requests. Manage placement of facultative reinsurance for the Personal Market division. Responsible for the management of all Liberty Mutual reinsurance treaty information in order to monitor and report on reinsurer concentrations, buying trends, and brokerage.
Responsibilities:
- Assure that all Artifacts are in compliance with corporate SDLC Policies and guidelines.
- Interacted with the Development team to help write technical specifications to describe Functional Requirement Documents FRD ,Business Requirement Documents BRD , design specifications and module specifications
- Responsible for Commercial Insurance Standards rating and risk factors for Auto and Garage commercial insurance.
- Designed and developed Project document templates based on SDLC methodology
- Lead and scheduled JAD sessions to gather requirements from business user and write effective BRD's and FRD's
- Analyzed clients systems and business processes.
- Provide support across different domain areas such as Auto Assignment, Payments, Claims Documentation, and Appointment Logs, Auto Estimations, Fire Claims etc.
- Analyzed the business rules for Auto claim assignments throughout the US, so as to have balanced work load for all the claims reps.
- Worked on an application that took care of online account services which included Bill paying, checking the bill history, changing customer profile, ordering auto insurance ID cards 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 business users.
- Developed and maintained Service Oriented Architecture SOA governance process costing models and metrics ensuring architecture compliance.
- Represented the business requirements in various alternative views such as analysis models, process flow diagrams and user stories.
- Worked extensively with MS Excel and MS access
- Translated high level business / data requirements into Process, Workflow, and Data Flow Diagrams using Rational Rose / MS Visio / BPMN towards facilitating clear understanding of the business process.
- Extensively involved in the modeling and development of Reporting Data Warehousing System.
- Conducted UAT User Acceptance Testing to make sure that all the user requirements are catered by the application.
- Collected Business requirements BRD from Business owners for applications
- Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, and OOD
- Analyzed standard industry practices of back office applications of Insurance Company, underwriting, billing, policy and claims administration with the help of Subject Matter Expert.
- Participated in creating custom site templates and list templates for developing web part pages for the portal using SharePoint Portal Server 2003.
- Used Test Director and Mercury Quality Center for updating the status of all the Test Cases Test Scripts that are executed during testing process.
- Conducted JAD sessions for communicating with Stakeholders and Project directors.
- Developed business requirement specification documents as well as high-level project plan.
Environment: Mainframes, COBOL, .NET, Agile, JCL, Db2, SDLC, Quality Center, Oracle, Rose, MS Word, MS PowerPoint, MS Excel, MS Visio, LoadRunner, WinRunner
Confidential
Business Analyst
- The Robert Plan Corporation, Robert Plan is a leading provider of insurance services to the property-casualty insurance industry and it is an acknowledged expert in managing assigned risk auto insurance industry and offers a variety of services including integrated indemnity and group life and health insurance for employees primarily offered through their employer. Their products and services include managed and indemnity health care coverage group life, accident and disability insurance retirement services and investment management. They also offer life insurance and employee benefits in selected international markets.
- The existing application AIMS caters to the business requirements of three states NY, CA and VT. In this project, AIMS functionality will be enhanced to cater to seven more states CT, TX, PA, WV, NM, NJ, and CA . The new functionality of 7 states shall be implemented in 2 phases. The first phase will consist of states CT, TX, PA and phase-2 will consist of WV,
Responsibilities:
- Analysed User Requirement Document, Business Requirement Document BRD , Technical Requirement Specification and Functional Requirement Specification FRS .
- Facilitated the User Acceptance Testing UAT with Pega System Administrators and Business Users, documented any issues or defects and eventually got sign off from the right parties.
- Established traceability matrix using Rational Requisite Pro to trace completeness of requirements in different SDLC stages.
- Prepared Business Requirement Documents BRD's after the collection of Functional Requirements from System Users that provided appropriate scope of work for technical team to develop prototype and overall system.
- Responsible for requirement gathering, code freeze, conducting the risk calls for production integration. Reviewing created test plans, test cases and responsible for executing the Test Scripts.
- Responsible for Quality Management Life cycle.
- Conducted Code Review meetings.
- Responsible for timely delivery of projects estimating the time required for requirement analysis, coding, testing.
- Processing of New Business, Renewal, Cancellation, Reinstatement, Billing for various lines of business Fire, Auto, Commercial
- Helped with data modeling and defining the conceptual and logical model of the data warehouse.
- Used external data sources to feed in product systems catering to Brokerage , Mutual Funds and Annuities.
- Maintained benchmark controls to policies, company standards and contracts, performed vendor sourcing, pricing and contract negotiation, performed procurement, ensured compliance with service/joint interest contracts.
- Designed the business requirement collection approach based on the project scope and SDLC methodology.
- Conducted UAT facilitated discussion between business team and QA team on determine the test requirements and pass/fail criteria documented and reported user feedbacks to management team.
- Wrote Business Cases for the Stakeholders to understand the functioning of the new Underwriting System.
- Correspondence included solicitation letters, financial transaction confirmations, and quarterly and annual policy statements.
- Followed solely RUP methodologies during the course of the project.
- Performed Smoke, Integration, functional, Regression, and system testing.
- Interacted with Business users and Technical team in providing clear solutions to requirements.
- Responsible for timely Code delivery of the Team Members.
Environment: RUP, UML, Windows NT, Java Script, SDLC, Rational Suite Rational Test Manager, Rational Robot, Rational Clear Quest MS Project, MS Visio, Visual Basic, Win Runner, Test Director, Windows XP, J2EE
Confidential
Business Analyst Westfield companies serve commercial, institutional and individual customers through the most extensive worldwide property-casualty and life insurance networks of any insurer. I was responsible for providing Quality Assurance for software products and also involved in requirement analysis, test case design, test script design, performing Functional Testing and extensive Data Testing. The detailed Data Testing involved calculating and splitting the losses of each claim, in each policy, through a process called Split Loss Calculation. I was also involved in downloading and testing the Billing and Booking Reports, cross verifying them with the Split Loss results.
Responsibilities:
- Involved with all the phases of Software Development Life Cycle SDLC methodologies throughout the project life cycle.
- Gathered requirements, organized team meetings requirements from business users, generated business process models, use-case models, and created business requirements document BRD functional requirements document FRD .
- Created UAT plans with several test cases for each project to ensure that the system runs smoothly after the proposed enhancements or changes have been made.
- Gathered user and business requirements through interviews, surveys, prototyping, and UI User Interface .
- Stored and modified requirements in MS Word.
- Involved in full system Development Life Cycle of the project.
- Analyzed and prioritized user and business requirements as system requirements that must be included while developing the software.
- Responsible for special projects requested by company management or reinsurance broker involving analyzing underwriting revenue and financial performance for companys reinsurance broker.
- Prepared Logical Data Models that contained set of diagrams, Business Requirement Documents, and supporting documents containing the essential business elements, detailed definitions, and descriptions of the relationships between the actors.
- 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.
- Worked on Wire frames during the Elaboration Phase.
- Conducted JAD sessions with management, SME, vendors, users, underwriters and other stakeholders for open and pending issues.
- Responsible for preparing Business Requirement Document BRD and then translating into functional specifications and test plans. Closely coordinated with both business users and developers for arriving at a mutually acceptable solution.
- Gathered requirements and modeled the data warehouse and the underlying transactional database.
- Facilitated transition of logical data models into the physical database design and recommended technical approaches for good data management practices.
- Created and managed project templates, Use Case project templates, requirement types, and traceability relationships in RequisitePro.
- Authored progress and completion reports, which were then submitted to project management on a weekly basis.
- Extensive experience in all phases of RUP and SDLC processes
- Performed Unit testing using the Team Track debugging tool, job monitoring and SQL queries supporting functional, UTA, regression, and performance testing.
- Created test cases and test scripts to check the functionality of application UAT .
- Performed manual front-end testing to check all functionalities of different modules.
- Suggested measures and recommendations to improve the current application performance
Environment: Rational Enterprise Suite Rose, RequisitePro, ClearCase, ClearQuest , Java, , Quality Center, Oracle,, SQL Server Reports, Win Runner, Load Runner, Quick TestPro
Confidential
Business Analyst
Nationwide is one of the largest insurance and financial services companies in the world, focusing on domestic property and casualty insurance, life insurance and retirement savings, asset management, and strategic investments. The company also provides third party administration services and disability management. GuideWire Claim Center is the project which was undertaken to upgrade the current Claim System to track its claim for both their owned Policy holders and third party applications.
Responsibilities:
- Wrote Test Cases in MS Excel for user registration, access to training material, and activity log-in, reviewed the test cases and finalized
- Worked with cross functional teams in order to establish comprehensive business and functional requirements.
- Performed the QA and UAT test case reviews.
- Assigned tasks among development team monitored and tracked progress of project following agile methodology.
- Prepared Business Requirement Documents BRD's after the collection of Functional Requirements from System Users that provided appropriate scope of work for technical team to develop prototype and overall system.
- Performed in depth gap analysis with different business groups to ensure that the system initiatives are met. Analyzed, documented, and managed all project requirements with RUP methodologies.
- Worked closely with users to understand the functionality of the current system and additional functionality required of the new system.
- Utilized corporation developed Agile SDLC methodology. Used ScrumWork Pro and Microsoft Office software to perform required job functions.
- Provided the expertise to QA and UAT groups for test planning.
- Conducted data driven testing using QTP to conduct backend testing
- Designed and developed Use Case Diagrams, Activity Diagrams, Sequence Diagrams, using MS Visio.
- Automation of test scripts was done using QTP for test re-usability of different online transaction modules.
- Assure that all Artifacts are in compliance with corporate SDLC Policies and guidelines.
- Involved in complete testing life cycle including creation of Test Plan, Test Cases, collecting test data for various projects and documenting test results.
- Facilitated User Acceptance Testing by creating Test plan and Test cases for the business users.
- Tracked all defects using Quality Center and communicated the test results to various groups by creating reports from HPQC.
- Perform Source-to-Target Data Mapping Data Lineage Analysis and documentation using the Enterprise Metadata Repository.
- Developed data mapping documents between Legacy, Production, and User Interface Systems
- Documented the outcomes of all the testing in MS Word and MS PowerPoint
- Established a Business Analysis methodology around the Rational Unified Process.
- Used Rational Requisite Pro to improve the communication of project goals, enhance collaborative development, reduce project risk and increase the quality of application before deployment.
- Worked extensively with MS Excel and MS access
- 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.
- Assisted in on-going process improvement efforts to ensure Test Planning, Execution, and Reporting is effective, efficient, standardized, coordinated, and integrated.
- Conducted JAD sessions for communicating with Stakeholders and Project directors.
- Developed business requirement specification documents as well as high-level project plan.
Environment: Mainframes, COBOL, JCL, Db2, Oracle, Agile, SQL, PL/SQL, SDLC, Rose, MS Word, MS PowerPoint, MS Excel, MS Visio, LoadRunner, WinRunner