SUMMARY

• 8 of Experience years as a Business Analyst in Insurance domain.
• Ability to gather Business and Functional requirements from both technical and non technical audiences using a broad array of tools and techniques.
• Strong experience in Requirements elicitation techniques such as conducting user interviews and JAD sessions
• Experience developing web - based applications, wireframes, mock-ups etc.
• Experience in creating Business requirements and Functional requirement documents and managing the requirements using Rational Requisite Pro.
• Insurance experience includes Personal Property Casualty and Commercial Automobile Product knowledge, Reinsurance for Commercial Property Casualty, Group and Life Insurance Systems
• Extensive success in translating Business requirements and user expectations into detailed specifications employing Unified Modeling Language (UML).
• Familiar with SOX Compliances and Basel II standards. Worked on data analysis of Mantas - Anti-Money Laundering (AML) Compliance data and supported user requirements.
• Solid background in Software Development Life Cycles such as the Agile, Waterfall, RUP and other iterative methodologies.
• Experience in writing SQL queries and optimizing the queries in Sybase, and SQL Server
• Experience in creation of artifacts and management of various roles specified by the Agile Methodology.
• Expertise in integrating Rational Requisite Pro with Clear Quest and also expertise in generating the rational soda reports.
• Experience in working on Clear case to keep track the versions of which files were used for each release.
• Ability to work on Oracle e business suite applications to create competitive advantage.
• Experience in Gap Analysis to check the compatibility of existing systems and simple addon’s with new business requirements.
• Involved in QA Life Cycle, which includes Designing, Developing and execution of the entire QA Process and documentation of Test Plans, Test Cases, Test Procedures and Test Scripts.
• Proficient in facilitating User Acceptance Testing (UAT) with the SME’s or clients.
• Diverse experience in working with Banking, Pharmacy and Telecom environments.
• Effective in executing multiple tasks and assignments ahead of schedule.
• Reputation for dedicated teamwork, high energy, work ethics and commitment with capability to handle new technologies and situations. A Team player, result-oriented, fast learner, excellent communication skills with strong analytical capability.

TECHNICAL SKILLS

• Rational Requisite Pro
• Rational Rose
• Rational Clear Quest
• MS Visio
• MS Project
• Erwin
• UML 2.0
• Rational Clear Case
• Test Director
• Rational Performance Studio
• SharePoint
• Mercury Win Runner
• Load Runner
• Quick Test Pro
• Regression and Performance testing
• J2EE Technologies
• SQL
• PL/SQL
• Visual Basic
• HTML
• MS Access
• Excel
• MS SQL Server 2000
• Sybase
• MS-DOS
• Windows 95/ 98/ 00/NT/XP
• TQM
• SSIS
• SSRS
• JIRA
• Quality center

PROFESSIONAL EXPERIENCE

Confidential, Charlotte, NC

Sr. Business Analyst

Responsibilities:

• Gathered and documented requirements for creating bureau reports and Bureau Reporting
• Conducted analysis studies that serve as input to the strategic planning, goal setting, and approach to achieving the goals.
• Helped the PM in initiating the project, preparing the Business case and planning it.
• Defined existing business process (BPM-Business Process Modeling) and identified the gap (Gap Analysis) between the existing & improved business process.
• Identified and defined Business analyst work Strategy and requirements risk approach and determine planning considerations finalized (RUP).
• Collected requirements (using) Brain storming, Document analysis, Focus Groups, Interface analysis, Interviews, JAD, prototyping, survey, reverse engineering and user task analysis for various reporting types like CLUE (Comprehensive loss underwriting exchange, Change Report, Claim Count, Claim summaries).
• Explained the solution model, analyze the functional requirements, prepared the Use cases, defined user profiles, defined the supplementary requirements, defined assumptions and prepare the traceability matrix and validate the requirements.
• Wrote business requirements specification (BRS) and functional requirements specification (FRS) documents as per the business requirements and process flow.
• Created Business Intelligence reporting for better understanding of business process and data.
• Assisted System Architects and Quality Assurance Analysts in creation of various tests by using Quality center.
• Assured that all artifacts are in compliance with corporate SDLC policies and guidelines.
• Assisted in deletion of defects and bugs, in order to meet specific requirements and deadlines for successful execution of the project.

Environment: Visual Basic, MS-Project, MS-Visio Windows 2000 Server, Windows 2000, Rational Tools, RUP, HPQC

Confidential, Overland Park, KS

Business Analyst

Responsibilities:

• Conducted detailed and comprehensive business analysis by working with end users, and other stake holders to identify the system, operational requirements, and proposed enhancements.
• 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.
• Configured the Data mapping between Oracle and SQL Server 2005.
• Gathered business requirements from business users such as insurance policy managers, and drafted business requirement specification (BRS).
• Lead multiple project teams of technical professionals through all phases of the SDLC using technologies including Oracle, Erwin, Data Stage, Data Warehousing, Websphere and Cognos.
• Performed Requirement Analysis and developed Use Cases, Activity Diagrams using Rational Rose
• Used Query Analyzer, Execution Plan to optimize SQL Queries
• Identified all necessary Business and System Narrative Use Cases from requirements, created UML diagrams including Use Case Diagrams, Activity Diagrams, and Sequence Diagrams using Microsoft Visio.
• Assisted to develop the Test Plan, Test Cases and Test Scenarios to be used in testing based on Business Requirements, technical specifications and/or product knowledge.
• Converted various SQL statements into stored procedures thereby reducing the Number of database accesses.
• Performed initial manual testing of the application as part of sanity testing
• Wrote BRD, FRD, use cases, test scenarios, test cases for testing the functional and non-functional aspects of both ETL jobs and Reporting jobs.
• Developed reports including line and pie charts, trend analysis and sub-reports using SQL Server Reporting Services (SSRS).
• Assisted in developing test scenarios, test scripts, and test data to support unit and system integration testing.
• Involved in testing of the system to check it satisfies functional specifications.

Environment: UML, RUP, Windows 2000, Rational Rose, RequisitePro, ClearCase, ClearQuest, MS Project, MS Word, MS Excel, Java, Web Logic, DB2.

Confidential, Philadelphia, PA

Business Analyst

Responsibilities:

• Provide support across different domain areas such as Auto Assignment, Payments, Claims Data and Appointment Logs, Auto Estimations, Fire Claims etc.
• Developed front-end production entry screen and batch interfaces between remote AS/400s and the corporate mainframe
• Collected & documented the requirement of Business Teams from Annuities, ASPF, Policy & Program Evaluation Team, and Project Sponsors & Actuaries.
• Collaborated in building a business analysis process model using Rational Rose, RequisitePro, and Visio.
• Work on the key products comprises of Billing System, Insurance Claims Processing and Policy Administration System. This web based application can be customized as per client's business requirement. RENAISSANCE BILLING SYSTEM is an integrated web based P&C Insurance billing system. This application with Insurance billing modules like Account / Policy Billing, Third Party (Agency) Billing, List/Group Billing was a complete billing system for P&C Insurance companies.
• Analyzed the system from both Technical and Business perspectives and prepared Business Requirement Document (BRD), including downstream and upstream interface requirements.
• Involved in the analysis of the data in the existing system, decoding the COBOL AS400 programs from the mainframes applications.
• Worked on data modelling and produced data mapping and data definition documentation
• Used SQL and MS Excel using macros for all Data validation based on the Business Rules.
• Utilized corporation developed Agile SDLC methodology. Used Scrum Work Pro and Microsoft Office software to perform required job functions.
• 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.
• Design and develop the data load process using XML Style sheets and ACORD.
• 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.
• 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.
• Developed a file of ACORD Forms used as the standards in all Property and Casualty markets, for both Personal and Commercial Lines of Business.
• Generated XML documents using the XML Output Stage.
• Helped with Data Mapping between the data mart and the Source Systems.
• Involved in data migration design so that the data can be exchanged from other systems in standard ACORD XMLife standards.
• Used Test Director and Mercury Quality Center for updating the status of all the Test Cases & Test Scripts that are executed during testing process.
• Responsible for process modelling from inception through implementation and post implementation optimization along with associated UI design.
• Provided clear and concise documentation regarding requirements management plans, Functional Requirements, supplemental Requirements, Test Plans and Test Cases.
• Performed extensive Requirement analysis and developed use cases and workflows.
• Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, and OOD
• Conducted and Managed JAD sessions with SMEs and Business departments, for planning and Requirements Gathering.
• Facilitated JAD sessions with end users, development and QA teams.
• 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: MS Access 2000, MS Excel, MS Project, RUP, Oracle, UML, Rational Rose, Requisite Pro, Clear Case 2002, Rational Clear Quest 2002, MS Office suite, MS Visio 2003.

Confidential, NJ

Business Analyst

Responsibilities:

• Analyzed and prioritized user and business requirements as system requirements that must be included while developing the software.
• Worked on development & maintenance teams for various insurance applications (Auto, Home and Fire).
• Awarded special recognition for creating the initial Resource Plan and the Business Process Models for Corporative Insurance for the following departments: Fire, Marine, Motor, Miscellaneous, Reinsurance and Auto.
• Successfully completed the Detail Requirement Specifications for all the 128 auto products of Corporative Insurance.
• Identify customer marketing opportunities by applying data mining models and writing advanced T-SQL stored procedures and queries.
• Received special recognition for presenting the structural differences of the ‘Life Insurance’ domain and ‘Auto’ Insurance domain to the management team that decided to develop the Life Insurance System as a separate system without developing as another module to the existing INFOINS system.
• Involved in testing the conversion of the application into web application using XML web services.
• 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.
• Created specification documentsfor various batch processes (data loads and data feeds) that transmit the product information to and fromAS400
• Database table review and data mapping for large scale data conversion project Oracle database to Mainframe.
• Involved in Inception Phase and prepared Logical Data Models that contains set of diagrams and BRD (Business Requirement Documents) supporting documents containing the essential business elements, detail 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.
• 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.
• Created Use Case Diagrams, Activity Diagrams, Sequence Diagrams and ER Diagrams in MS Visio.
• Worked with underwriting department to evaluate risk, exposure of potential clients and also measured risk exposure and determined premium.
• Performed Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data
• Created Data mapping documents; featuring end to end source to target level mapping
• Created Mock-up forms in MS Access for better visualization and understanding of the software solution.
• Created and managed project templates, use case project templates, requirement types and traceability relationships in RequisitePro.
• Utilized corporation developed Agile SDLC methodology.
• Assisted system analyst to create Sequence Diagrams and Class Diagrams to show the individual flow of activity and define functionalities of various processes in policy administration.
• Used SQL for Data manipulation and data analysis
• Authored progress and completion reports, which were then submitted to project management on a weekly basis.
• Suggested measures and recommendations to improve the current application performance

Environment: Windows XP Professional, Win Runner, Load Runner,SQL, Caliber RM, MS Access 2000, MS Excel, RUP, UML, Rational Rose, Requisite Pro,Powerpoint, web services, Rational Clear Quest 2002, XML, MS Office suite, MS Visio

Confidential, PA

Business Analyst

Responsibilities:

• Worked with the account managers, managements, and report requestors to gather requirements, get report requests.
• Responsible for converting for Mutual Life Insurance, the Fixed and Variable Annuities PC administrative system to the mainframe Vantage.
• Wrote Business Requirements, analyzed them and tested them.
• Managed the output requirement project for various Life insurance products.
• Responsibility included modifications to a customer’s mainframe Vantage system to support new product features or regulatory requirements and, in some cases, involved a system upgrade
• Designed and assited intergration of underwriting/policy admin system with 3rd party systems via web services and data feeds.
• Designed workflows and allocated permissions within SharePoint.
• The new system will provide with an underwriting platform to automate policy administration functions.
• Conducted Functional Walkthroughs, User Acceptance Testing (UAT), and supervised the development of User Manuals for customers.
• Worked with the development team to assist in the design of the database schema and ETL work flows
• Also responsible for managing communication and expectations of system vendor, the former parent company IT and business departments, and various business units (underwriting, claims, reinsurance, actuary, accounting, and IT)
• 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.
• Reviewed Requirements & deliverables for delivery timeline.
• Used MS Visio to create Flow diagrams and Use Case Diagrams.
• Prepared Functional Design Specifications employing Use case scenarios, sequence diagrams, ERD’s, DFD’s and class diagrams.
• Involved with the technical team in understanding the XML file format required for Split loss process and Billing process.
• Interaction with underwriters to understand multiple data points. Prepared data flow diagrams using MS Visio for better clarity and to ensure documented process
• Wrote Test Cases in Mercury Quality center that would test various Test scenarios.
• Wrote Test plan and Test cases for the Integration testing and system testing.
• Wrote Business Cases for the Stakeholders to understand the functioning of the new Underwriting System.
• Modified System flow diagrams using SDLC.
• Worked with ETL team during the upload process.
• Helped with Data Mapping between the data mart and the Source Systems

Environment: Windows 2000/XP, Agile, UML, Visio, Rational Suite (Rational Requisite Pro, Rational Clear Case), Regression Test, and Quick Test Pro, MS-Office 2003.