Business Analyst/systems Analyst Resume
Winston Salem, NC
SUMMARY
- 7 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
- Extensive experience with data modeling and defining the conceptual and logical model of the data warehouse.
- 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 Mock - ups, 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.
- 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
Process/Model tool/IDE: MS Visio, Rational Unified Process (RUP), Rational Rose, Rational Requisite Pro, Test Management, Doors, Class Diagrams, Use Case Diagrams, Sequence Diagrams, and Activity Diagrams.
Desk top software: MSOffice, MS Word, Power point, MS Visio, Adobe Acrobat, Ms Project … Crystal Reports
Project Management: MS Project, Excel spread sheets
Languages: Java, C/C++, SQL, JavaScript.
Operating System: Windows 95, NT/2000/XP, UNIX, MACINTOSH, DOS
RDBMS: MS SQL Server 2000, Oracle
Web Tools: Font Page, Photoshop.
Test Tools: Test director, Quality Center.
PROFESSIONAL EXPERIENCE
Confidential, Manchester, NH
Business Analyst
Responsibilities:
- Worked with the account managers, managements, and report requestors to gather requirements, get report requests.
- Worked on Personal & Commercial lines Property and Casualty Insurance including both policy and claim processing and reinsurance
- 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 & Commercial Lines Property and Casualty business
- Research and Analyze Business needs and objectives to improve Property & Casualty products, contracts, and processes.
- Worked on UAT testing and took signoff from the Commercial line of Property & Casualty business users.
- Identified Use cases from the Functional requirements and wrote Use Case Specifications and created business process workflow diagrams (Activity diagrams, Sequence diagrams, Collaboration diagrams)
- Used Agile Software Development process viz. Scrum, as this was a time bound project.
- Coordinating with the development team to set up test environment for issue escalation and issue resolution process for SIT and UAT testing to enable smooth operation
- Involved in development & documentation of Software Requirements Specification (SRS) using Borland Calibre RM.
- Prepared Need Analysis Documents of the requirements gathered through JAD sessions.
- Performed Gap Analysis to check the compatibility of the existing system infrastructure with the new business requirements.
- Prepared Functional Design Specifications employing Use case scenarios, sequence diagrams, ERD's, DFD's and class diagrams.
- Worked on broad range of technologies, including business process tools such as Microsoft Project, Primavera, Promodel, MS Excel, MS Access, MS Visio, technical assessment tools, Micro Strategy Data Warehouse Data Modeling and Design
- Interaction with underwriters to understand multiple data points. Prepared data flow diagrams using MS Visio for better clarity and to ensure documented process
- Wrote Business Cases for the Stakeholders to understand the functioning of the new Underwriting System.
- Performed Business Process Mapping and performed AS-IS and TO BE analysis
- Modified System flow diagrams using SDLC.
- Performed the following data-related tasks: analysis, cleansing mining and creation of schemas using MS SQL in order to create test documentation and design
- Helped with Data Mapping between the data mart and the Source Systems
Confidential, Fort Lauderdale, FL
Business Analyst
Responsibilities:
- Conducted elicitation sessions such as brainstorming, and focus group session to build user-stories based on their interest regarding business.
- Worked with the Guide wire specialists in order to gather the GW requirements and implement those requirements successfully into the new system
- Assisted in the documentation of requirements for the Guidewire ClaimCenter claims management system as a business analyst. Used the knowledge of ClaimCenter and past Workers Comp projects to assist the business units in defining needs and requirements
- Conducted Gap Analysis to gather the requirements, by comparing existing Legacy ClaimsCenter and Guidewire ClaimsCenter.
- Uses the Guidewire ClaimCenter for the claim management system for property and casualty insurance.
- Wrote specifications for configuring business rules and functionalities in Guidewire.
- Closely worked with and supported Product Owner to manage product backlog from user-stories.
- Followed the UML based methods using Microsoft Visio to create: Use Cases Diagrams, Activity Diagrams.
- Experience in agile team to ensure all team member to understand business need.
- Worked closely with developers in agile team to advice on business details.
- Ensured goals and objectives of the business to deliver functionality changes.
- Collaborating closely with PMO in Risk and SWOT Analysis.
- Prepared the sprint backlogs from Sprint Planning meeting to identify and monitor the activities performed in the time-boxes
- Created User Interface Documents (UID) of prototypes and wireframes to help designing user interface.
- Worked extensively with MS Excel and MS access
- Converted various SQL statements into stored procedures thereby reducing the Number of database accesses.
- Worked with the SQL developers to optimize the SQL queries, reviewed their stored procedures to understand their calculation processes, their entire ETL processes from staging to temporary location until the exposures and the calculated data was stored the final database for reports and extracts
- Walkthrough session with development team and QA team to understand the business requirement clearly.
Confidential, Winston Salem, NC
Business Analyst/Systems Analyst
Responsibilities:
- Gathered, analyzed, documented business and technical requirements from both formal and informal sessions and validate the needs of the business stakeholders.
- Plan and design modifications for a life insurance policy administration system, providing support to a major client throughout the project's System Development Life Cycle.
- Managed the output requirement project for various Life insurance Annuity 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.
- Responsible for converting for Mutual Life Insurance, the Fixed and Variable Annuities PC administrative system to the mainframe Vantage.
- Responsible for testing life insurance product transaction functionality in wmA (Vantage), reporting of defects in JIRA and tracking fixes
- Responsibility included modifications to a customer's Vantage system to support new product features or regulatory requirements and, in some cases, involved a system upgrade
- Conducted user interviews and documented business and functional requirements.
- Conducted User Acceptance Testing (UAT) and documentation of Test Cases.
- Expertise in designing and developing Test Plans and Test Scripts.
- Used MS Office for creating Vision, Use Cases, and Supplementary Specification Documents.
- Developed prototypes for the UI and also helped in development of screen navigation flows.
- Participated in requirements meetings, writing requirements in Calibre RM, converting requirements from Calibre RM to HP Quality Center.
- Created Business process workflow diagrams using IBM business process modeller
- Developed use cases, data mapping, screen mock-ups during the functional specifications.
- 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
- Developed detailed Test plan, Test Cases, Test scripts for testing the functionality, GUI and security testing.
- Documented the Use Cases and prepared the Use Case, Activity, Logical, Component and Deployment views using MS Visio and Rational Rose for a clear understanding of the requirements by the development team.
- Developed the Wire Frames, User Interfaces, AS-IS and TO-BE flows and the Use Cases to encapsulate the information with ease.
- Identified/documented data sources and transformation rules required populating and maintaining data warehouse content.
- Created DTS Packages for migration of data between MS SQL Server database and other databases like MS Access, MS Excel and Flat Files.
- Involved with all the phases of Software Development Life Cycle (SDLC) methodologies throughout the project life cycle.
- Queried database using SQL
Confidential, Dallas, TX
Business Analyst/Systems Analyst
Responsibilities:
- Review Mapping Documents formula and rule engine.
- Worked on Data Warehouse teams in analysis, design, development, testing, implementation and maintenance of enterprise universes and reports and accessing, analyzing and presenting information.
- Planned, designed and documented the optimum usage of space requirements and distribution of space for the Data Warehouse
- Initiated Project Plan for development of data warehouse
- Involved in Logical and Physical modeling of various Data marts as well as data warehouse
- Integrated multiple source receivable systems data from multiple platforms into one consolidated view and platform and sunset the existing legacy data warehouse for corporate finance and risk
- Also helped the business units understand how data warehousing and data mining techniques can help them do their decision making in a more organized and easy manner.
- Writing new mappings specification according to the business data requirements
- Prepared Requirement Traceability Matrix to ensure all the features for the project were captured and mapped as per the requirement in the BRD.
- Prepared Test data preparation strategy and data masking strategy for the shared test environment
- Involved in completing data testing before the UAT.
- Interact with clients/business users when issues arise on Data governance
- Involved in generation and execution of SQL queries
- Used Pivot tables, vlookups and conditional formatting to verify telemarketing data against data uploaded to proprietary database and online reporting.
Confidential, Cleveland, OH
Business Analyst
Responsibilities:
- Conducted one to one interviews with Portfolio Manager to gather System Requirements and was involved in the documentation of System Requirement Documents.
- Performed Requirement Analysis by gathering both functional and non-functional requirements based on interactions with the process owners & stake holders and document analysis, represented them in Requirements Traceability Matrix (RTM).
- Developed strategic partnerships with the Business units to develop a solid knowledge base of the Business line, including the Business Plan, Products, and Process.
- Translated the Business needs into system Requirements, communicating with the Business on a broader scale and with an in-depth view.
- Inserted Check Points to check the broken Links, Text, and standard properties of an object using Quick Test Pro.
- Conducted user interviews, gathered requirements, analyzed the requirements by using Rational Rose, Visio and Requisite pro - RUP
- Implemented and managed the formal SDLC implementation using the RUP Methodologies.
- Designed and developed Project document templates based on SDLC methodology.
- Developed System Requirement Document as well as High-Level Project Plan.
- Worked on data modelling and produced data mapping and data definition documentation
- Participated in UAT and worked with Mercury Quality Center for bug and defect tracking.
- Documented the entire testing process, test cases and test results.
- Managed the whole testing process using Mercury Interactive Test Management tool Quality Center.
- Participated in the Logical and Physical Design sessions and developed Design Documents.
- Worked with developers to make sure that they understood the Use Cases.
- Designed and implemented basic SQL queries for QA Testing and Report / Data Validation.
- Worked with Quality Control Teams to develop Test Plan and Test Cases.
- Develop User Manuals, and Training Manuals as per Project Specifications and timelines.