Sr. Business Analyst/ Qa Analyst Resume
PA
PROFESSIONAL SUMMARY:
- 6+ years of experience as a Business 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
- Strong understanding of project life cycle and SDLC methodologies including RUP, RAD, Waterfall and Agile.
- Extensive experience in conducting Market Research, Feasibility Studies, Data Analyses, Data Mapping Gap Analyses, Risk Identification, Risk Assessment, Risks Analyses, and Risk management
- Analyzed and documented Reinsurance Claims, Billing Collections, and Accounting modules of the application.
- Expert in commercial Property and Casualty and Personal Lines Insurance experience with national carriers.
- Extensive experience with data modeling and defining the conceptual and logical model of the data warehouse.
- Expert in the Property, Casualty, Annuities, Disability, and Supplemental Insurance policies include administration, sales, customization, claims, pensions and CMS.
- In depth knowledge Rational Unified Process (RUP) methodology, Use Cases, Software Development Life Cycle (SDLC) processes, Object Oriented Analysis and Design (OOA/D).
- Facilitated Change Management across entire process from Project conceptualization to Testing through Project Delivery, Software Development and Implementation Management in diverse Business and Technical Environments.
- Extensive experience in developing Use Cases, creating Screen Mockups, conducting Gap Analysis and Impact Analysis, SWOT analysis, Cost Benefit Analysis, Risk Analysis.
- Responsible to Track, Document, Capture, Manage and Communicate the Requirements using Requirement Traceability Matrix (RTM) which helped in controlling numerous artifacts produced by the teams across the deliverables for a project
- Involved in Test Planning, Test Preparation, Test Execution, Issue Resolution and Report Generation to assure that all aspects of a Project are in Compliance with the Business Requirements.
- Highly experienced in DMAIC
- Strong experience in conducting User Acceptance Testing (UAT) and documentation of Test Cases. Expertise in designing and developing Test Plans and Test Scripts.
TECHNICAL SKILLS:
Languages and Tools: UML, Rational Rose, RequisitePro, Rational SoDA, Rational Clear Case, Rational Clear Quest, Mercury Test Director, MS Project, MS Visio, MS Office Suite, Bloomberg,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
PROFESSIONAL EXPERIENCE:
Confidential, PA
Sr. Business Analyst/ QA Analyst
Responsibilities:
- Analyzed clients systems and business processes.
- Prepared requirements document for Commercial Auto, Inland Marine, Crime, Worker’s Compensation, Umbrella, Business Owners Policy, Commercial Output Policy, and Commercial Property Package.
- 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)
- Conducted user interviews, gathered requirements, analyzed the requirements by using Rational Rose, Visio and Requisite pro - RUP
- Process and data flow models for STD (Short Term Disability), LTD (Long Term) and FMLA claims processes as well as interfaces to Human Resources.
- Performed workflow analysis toward automated disability claims process. Detailed comparison of two competing proposals, including HR interfaces. Facilitated requirements definition for new system.
- Designed and developed Project document templates based on SDLC methodology
- Assure that all Artifacts are in compliance with corporate SDLC Policies and guidelines
- Involved in Scrum development process and prepared Sprint burn down chart, product catalog and sprint backlog contain Business Requirements and supporting documents that contain the essential business elements and definitions as well as the tasks to be completed.
- Used Test Director and Mercury Quality Center for updating the status of all the Test Cases & Test Scripts that are executed during testing process.
- Performed Load and Stress Testing using Load Runner.
- Automated confidence tests that run on new builds on regular basis.
- Involved in setting up different configuration environment for compatibility testing and manual testing.
- Upgraded the existing Test Scripts and created new scripts for client application to be able to work for new versions and patches, which improved product quality.
- Evaluated testing results for each potential release build using Test Director, Quality Center and Bugzilla reports, listing summarized bug information in priority sequence, recommended viability of release for production.
- Conducted presentations of the QA test results with analysis to the stakeholders and users and documented modifications and requirements.
- Worked extensively with MS Excel and MS access.
- Created Use Case Diagrams, Activity Diagrams, Sequence Diagrams and ER Diagrams in MS Project.
- Involved in project management using MS Project.
- Responsible for acting as a liaison with operational and financial management, systems support and sales to identify business opportunities. Developed a file of ACORD Forms used as the standards in all Property and Casualty markets, for both Personal and Commercial Lines of Business.
- Implement and maintain Property & Casualty (e.g. bug-fix, data integration, version release) systems of assigned customers.
- Provided key input in working with users in defining project and system requirements.
Environment: Mainframes, COBOL, JCL, Db2, Oracle, Rose, MS Project, MS Word, MS Access, MS Excel, MS Visio , UAT, LoadRunner, WinRunner
Confidential, Salem, OR
Business Analyst
Responsibilities:
- 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.
- Met the Business development group and gathered the requirements for the developing Automatic Assignment of claims Involved in Logical & Physical Data Modeling. Database Schema design and modification of Triggers, Scripts, Stored Procedures in Sybase Database Servers.
- Established a Business Analysis methodology around the Rational Unified Process.
- Researched the various steps in the lifecycle and then constructed the system in a way that the high risk customers would be easily identified and monitored.
- Streamlined clerical work processes and mapped then into the new system.
- Developed project plans and managed project scope.
- Worked extensively with MS Excel and MS access
- Developed QA Test Plan, test conditions and test cases, as well as assisted with QA team in System Testing using Mercury Test Director
- 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.
- Assisted in building a Business Analysis Process Model using Rational Rose and Visio.
- Downloaded and tested the Billing and Booking reports against the Split Loss results.
- 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.
- Responsible for developing annual and mid-year operating budgets by underwriting departments and on a consolidated basis for review by reinsurance group senior management.
- Documented and delivered Functional Specification Document to the project team.
- 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, Rose, MS Word, MS PowerPoint, MS Excel, MS Visio, LoadRunner, WinRunner
Confidential, Harrisburg, PA
Business Analyst
Responsibilities:
- Analyzed clients systems and business processes.
- Provide support across different domain areas such as Auto Assignment, Payments, Claims Data 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.
- Developed front-end production entry screen and batch interfaces between remote AS/400s and the corporate mainframe
- Worked as a Personal line of Property and Casualty Expert for interface to Insurer Business Partner on all facets of system design.
- Collected & documented the requirement of Business Teams from Annuities, ASPF, Policy & Program Evaluation Team, and Project Sponsors & Actuaries.
- Implement and maintain Property & Casualty (e.g. bug-fix, data integration, version release) systems of assigned customers.
- Utilized corporation developed Agile SDLC methodology. Used ScrumWork Pro and Microsoft Office software to perform required job functions.
- Developed expertise with ACORD standard Life, Annuity & Health data model and data collection requirements, form models and archival stipulations.
- Working with clients to better understand their needs and present solutions using structured SCRUM approach.
- Using Shared Containers and creating reusable components for local and shared use in the ETL process.
- Established a Business Analysis methodology around the Rational Unified Process.
- 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.
- Developed project plans and managed project scope.
- Worked extensively with MS Excel and MS access
- Responsible for process modeling from inception through implementation and post implementation optimization along with associated UI design.
- 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.
- Assisted in building a Business Analysis Process Model using Rational Rose and Visio.
- Performed extensive Requirement analysis and developed use cases and workflows.
- Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, and OOD
- Played a key role in the planning, User Accepted Testing, and Implementation of system enhancements and conversions.
- Responsible for developing annual and mid-year operating budgets by underwriting departments and on a consolidated basis for review by reinsurance group senior management.
- Documented and delivered Functional Specification Document to the project team.
- 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, Java, J2EE, Rose, MS Word, MS PowerPoint, MS Excel, MS Visio, LoadRunner, WinRunner
Confidential, OH
Business Analyst
Responsibilities:
- Gathered high-level requirement for all the external projects in a release.
- Processing of New Business, Renewal, Cancellation, Reinstatement, Billing for various lines of business (Fire, Auto, Commercial)
- 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)
- Involved with the technical team in understanding the XML file format required for Split loss process and Billing process.
- Negotiated with teams from projects to decide if modules should be implemented independently, or Parallely
- Extracted data from Oracle database with MS Access, and performed SQL query, data analysis and verification.
- Created functional requirement documents for the impacting projects
- Performed criteria table updates for each project.
- Updated the impacted MS Access tables.
- Worked extensively with MS Excel and MS access
- Analysis of business requirements and system requirements of the client and also for Property and casualty modules
- Responsible for acting as a liaison with operational and financial management, systems support and sales to identify business opportunities. Developed a file of ACORD Forms used as the standards in all Property and Casualty markets, for both Personal and Commercial Lines of Business.
- Involved in generating Test cases for property and casualty Insurances for Different Levels of Business
- Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, OOD using UML
- Responsible for gathering requirements from users in operations group and performing data mapping for the application, confirm and vacillating the requirement at time of BA testing.
- Facilitated and led JAD sessions aimed at functional requirement walkthroughs for all the impacting projects and updated the documents based on recommendations (if any).
- 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.
- Provided data modelling support for numerous strategic application development projects.
- Reviewed test results and coordinated with testing and development team to correct the issues.
- Developed timelines for project delivery, and managed projects/resources
- Analyze business requirements and segregated them into Use Case Diagrams, Activity Diagrams, Sequence Diagrams, and OOD using Borland Together according to UML methodology thus defining the Data Process Models.
- 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.
- Responsible for creating Bordereau report on a monthly basis for reinsurance broker.
- Documented and delivered Functional Specification Document to the project team.
- Used MS Project to manage schedules, deadlines and resources and collaborate on the project.
- Interacting with the developers on resolving the reported bugs and various technical issues.
- Assisted the QA team in designing the Test Plan and Test Cases for User Acceptance testing.
Environment: Microsoft Office Suite, Microsoft Visio, Unix, Documentum, Windows NT/XP, Oracle, SQL, SQL Server, Sybase, VBScript, C#. DOORS, C++, NET, ASP.NET, Business Objects, TestDirector, LoadRunner
Confidential, Woodland Hills, CA
Business/ Systems Analyst
Responsibilities:
- Involved in the analysis of the existing credit card processing system, mapping phase according to functionality and data conversion procedure.
- Performed Gap Analysis to check the compatibility of the existing system infrastructure with the new business requirements.
- Correspondence included solicitation letters, financial transaction confirmations, and quarterly and annual policy statements.
- Followed solely RUP methodologies during the course of the project.
- Utilized the 80-20 rule to prioritize and incorporate the critical features. Used Time-Boxing techniques to finish within set time frames.
- 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.
- Assisted in the development, design and implementation of new relational or multi-dimensional databases, including the analysis of user needs.
- Created and managed project templates, Use Case project templates, requirement types and traceability relationships in Requisite Pro.
- Developed Systems Specifications document to define the impact of the new requirements on the existing system.
- Worked extensively with MS Excel and MS access
- Involved in Performance Measurement to develop measurable indicators that can be systematically tracked to assess progress made in achieving predetermined goals.
- Developed and managed creation of product documentation to communicate features, benefits, positioning and impacts to different audiences and ensured that documentation deliverables from various groups are produced as needed.
- Responsible for special projects requested by company management or reinsurance broker involving analyzing underwriting revenue and financial performance for companys reinsurance broker.
Environment: Rational Enterprise Suite (Rose, RequisitePro, ClearCase, ClearQuest), Casewise modeller, IBM WebSphere, XML, Java, Unix, C++, J2EE, JSP, Oracle, DB2, Sybase, SQL Server Reports, WinRunner, LoadRunner, Quick TestPro