SUMMARY

• Business Analyst with 6+ years of experience in Insurance (Life, Property & Casualty)
• Extensive experience and knowledge of insurance plans, premiums, and annuities
• Created and maintained data mapping documents, data dictionaries, and metadata documents to ensure a clear and uniform understanding of data entities
• Extensive experience of database management systems, enterprise data warehousing (EDW), data mining, data extraction, and data modeling
• Advanced skills in using SQL queries to create, extract, analyze, and update databases
• Experience and knowledge of Oracle databases
• Elicited business, functional, non - functional, and technical requirements using various techniques such as interviews, meetings, brainstorming, document analysis, and focus groups
• Created business requirement documents (BRDs), functional requirement documents (FRDs), and technical requirement documents (TRDs)
• Extensive experience in requirement analysis, Business Modeling, and Use Case development using UML
• Extensive experience in gathering system requirements, defining business processes, UML modeling, sequence diagram and activity diagram.
• Worked across functional teams to collect, match, consolidate, and confirm data and business elements
• Strong understanding of Software Development Life Cycle (SDLC) methodologies - Waterfall and Agile
• Worked with Scrum Team attending daily Scrum meetings, wrote user stories, and created Sprint burn-down charts
• Wrote use cases, test cases, and scripts as well as helped QAs to test the test cases
• Assisted the Project Manager in the development of SDLC methodology and documentation strategy and acted on behalf of the Project Manager during the PMs Absence.
• Experienced in developing project plans, validating requirements, and reengineering process.
• Worked for financial and technical solutions and helped the teams at all levels until final product release.
• Experienced using requirement documentation tools such as MS Office, MS Visio, and MS Project.
• Facilitated JAD sessions with stakeholders, SMEs, development team, and Project Manager to drive out detailed business requirements.
• Excellent analytical skills for understanding the business requirements, business rules, business process and detailed design of the application.
• Excellent skills in business analysis, Object Oriented analysis, requirement analysis, risk analysis, gap analysis, and stakeholder analysis
• Good experience and understanding of Java based applications and J2EE.
• Developed excellent professional skills by working independently and as a team member in designing, developing, and implementing innovative business process and system solutions.
• Excellent knowledge and experience with Service Oriented Architecture (SOA) concepts.
• Experienced in manual testing, recreating errors and provide support to programmers to correct defects in the system.
• Facilitated UAT with the stakeholders and the business users
• Experienced in Systems Testing, Integration Testing, Software Quality Standards, documentation, and implementation in a business environment.
• Performeddata analysis, data and software conversions, and led multiple system implementations.

TECHNICAL SKILLS

Requirement Tracking: Rational Requisite-Pro, Test Director, MQC and DOORS.

Operating Systems: MS Windows NT/98/2000/XP, UNIX

Databases: MS Access, SQL

Office Tools: MS Word, Excel, MS Project, MS Outlook

Methodologies: SDLC, RUP, UML, RAD, JAD and AGILE.

UML Diagram Tools: Rational Rose / Microsoft Visio.

PROFESSIONAL EXPERIENCE

Confidential, Minneapolis, MN

Business Analyst

Responsibilities:

• Performedrisk evaluationwith underwriting department to determine premium for potential clients for each of the policies.
• Worked in EDW to extract, update, and analyze data from data warehouse using advanced SQL queries
• Provided daily technical assistance by responding to inquiries regarding errors and problems while booking policies and claims inthe insurance systemfor commercial auto, general liability, and worker’s compensation package
• Used frequency and severity model to interpret and produce graphical representations of loss and distribution
• Worked extensively to write Use Cases and do the process flows for the Worker’s Compensation package.
• Supported full traceability among all artifacts throughout thesoftware development life cycle (SDLC)
• Extractedthe Business Requirementsduringvarious sessionswith business leads and tagged all requirements inRequisite Pro,tracing them all the way to the stakeholder requirements
• ConductedJAD sessionswith extensive involvement from Business,Development, Testingteams, Architects, SME’s, and Managers of various business units.
• Documented requirements for the Guidewire Claim Center claims management system
• Elicited requirements and providedspecific business and technicalrequirementsguidance for the construction of the system producing Business Requirements Document (BRD), Functional Requirements Document (FRD),and Business and System Use Cases.
• Worked closely with the QA team in the writing, reviewing, and executing test cases.
• UsedRational ClearCaseandClear Questas Configuration Management and Change control tools.
• Constructed and maintainedUML modelsusingRational Rose, and createduse case diagrams, class diagramsandsequence diagramsfor all the use cases
• Coordinated with multiple teams and integration architects, in performing analysis for issues regarding speed and stability
• Helped QAs to manage the whole testing process usingHPQuality Center.
• Helped QAs to tracked and document defects and communicate them to the developers.
• Assisted in scheduling batches backup process to maintain customers and clients database
• Participated inUAT (User Acceptance Testing)with all levels of User Groups.

Environment: Guidewire,Excel, Access, MS-Word, MS-Power Point, and SQL

Confidential, Bloomington, IL

Business (Systems) Analyst

Responsibilities:

• Analyzed standard industry practices of back office applications of insurance company, underwriting, billing, policy, and claims administration with the help of Subject Matter Expert (SME).
• Involved in processing of New Business, Renewal, Cancellation, Reinstatement, and Billing for various lines of business (Fire, Auto, Commercial)
• Responsible for creating a business process and workflow documentation using BPMN standards.
• Integrated a diverse set of requirements definition techniques to develop requirements with the use of Rational Requirements Pro.
• Involved in writing test cases for property and casualty insurances for different levels of business.
• Maintained a Requirements Traceability Matrix (RTM) and data mapping to various Data Reporting Manuals, User Guides.
• Performed Use Case Requirements Gathering and Use Case at all levels of the SDLC
• Performed workflow analysis toward automated disability claims process. Facilitated requirements definition for new system.
• Created Mock-up forms in MS word for better visualization and understanding of the software solution.
• Wrote BRD, FRD, use cases, test scenarios, test cases for testing the functional and non-functional aspects.
• Responsible for executing User Interface Testing, System Testing, and Data Quality Testing on the configuration design and prototypes.
• Involved in the creating the User Interface Specification Document and User Manual as per project specification with the help of development team.
• Performed the requirement analysis and documented the requirements using Rational Requisite Pro.
• Extensive experience in using collaborative tools like Mercury Quality Center to facilitate development across disparate teams.
• Followed a structured approach to organize requirements into logical groupings of essential business processes, business rules, information needs and ensured that critical requirements are not missed.

Environment: Windows 7, Fade Plus, Excel, Word, PowerPoint, Access,, MS Visio, MS Project, MS-SQL, .NET, RUP, JAD

Confidential, Boston, MA

Business Analyst

Responsibilities:

• Elicited business requirements from business users and stakeholders using JAD sessions, brain storming sessions, focus groups and personal interviews on AGILE/ SCRUM methodology
• Gathered and documented requirements for creating bureau reports and bureau reporting marts (ISO, Mass Auto, DMV)
• Performed in-depth data analysis identifying data issues in legacy system and worked with business to develop resolutions to those issues.
• Created business requirements document (BRD) and functional requirements document (FRD) after gathering both functional and non-functional requirements as well as writing user stories.
• Actively involved in data warehouse and mart design sessions for both Logical and Physical designs.
• Communicated logic for the parsing of data to ETL team.
• Created data mapping documents for the movement of data from production databases to the warehouse and from the warehouse to the policy and claims marts.
• Defined logic for Extraction, Transformation and Loading (ETL) of data into Warehouse and Marts.
• Worked closely with the client's developers to define the purpose and use of database tables and attributes in their existing systems where documentation was lacking
• Assisted developers in writing of complex SQL queries to resolve data issues in source system databases.
• Developed and executed test cases verifying data transfer quality.
• Worked closely with offshore development team.
• Analyzed standard industry practices of back office applications of insurance company, underwriting, billing, policy, and claims administration with the help of Subject Matter Expert (SME).
• Processing of New Business, Renewal, Cancellation, Reinstatement, Billing for various lines of business (Property & Casualty, Fire, Auto, Commercial)
• Worked in eliciting, analyzing, and documenting requirements for Guidewire Claims management system as well as conducted stakeholder analysis, gap analysis, and risk analysis for the system
• Wrote advanced SQL test scripts to access, analyze, and update data from databases and generated reports for the business purposes
• Responsible for creating a business process and workflow documentation using BPMN standards.
• Involved in generating test cases for property and casualty insurances for different levels of business
• Maintained a traceability matrix for all requirements and mapping to various Data Reporting Manuals, User Guides
• Wrote BRD, FRD, use cases, test scenarios, test cases for testing the functional and non-functional aspects.
• Responsible for executing User Interface Testing, System Testing, and Data Quality Testing on the configuration design and prototypes.
• Involved in the creating the User Interface Specification Document and User Manual as per project specification with the help of development team
• Performed the requirement analysis and documented the requirements using Rational Requisite Pro.

Environment: SQL Server, UML, Cognos, UNIX, HTML, MS Visio, Clear Quest, Quality Center, MS SharePoint, RTM, Erwin, MS Word/Power Point.

Confidential, Warren, NJ

Business Analyst

Responsibilities:

• Developed the scope and vision document that defined the primary goals, objectives, and scope of the project.
• Designed and worked on successfully developing web applications that allow independent sales agents and underwriters for quoting, rating, processing and tracking applications.
• Developed the integrated development life cycle by integrating Rational Requisite Pro, Rational Quality Manager, and Rational Requirements Composer (RRC) with Rational Team Concert
• Created screen-mockups using iRise to review the requirements and provide feedback on the screen design.
• Also, used Microsoft Paint to create ad-hoc screen mock-up to review with the users.
• Responsible for Data Manipulation and Data Validation using SQL queries in a MS SQL Server environment
• Experienced creating Business Requirements Documents (BRDs), Functional Requirement Documents (FRDs), and Technical Requirement Documents (TRDs) for Guidewire Claims management system
• Created data mapping, data dictionary, and Requirement Traceability Matrix (RTM) for Guidewire claims system
• Used advanced SQL queries to extract data from databases and generate reports
• Prepared business requirements Documents (BRD) and got sign off to be used by the developers.
• Designed and developed Use Cases, Activity Diagrams, and Sequence Diagrams using Unified Modeling Language (UML) and Rational Rose.
• Used the BPMN to conduct GAP Analysis to identify and document the gaps between business processes.
• Created prototypes of the GUI environment using iRise to be used by the developers during the design phase.
• Documented, analyzed, and defined the user and system requirements and used Rational Requisite Pro to manage the requirements.
• Developed detailed class diagrams and sequence diagrams using Rational Rose.
• Developed as-is and to-be business processes using BPMN standards.
• Identified and established scope and parameters of requirements analysis in order to define impact, outcome criteria, and measure-taking actions through interface analysis, prototyping and JRP/JAD sessions with focus groups.
• Worked with the development team during the Design, Build and Test phases of system projects to clarify business requirements as required.
• Used MS Project to manage schedules, deadlines, and resources and to collaborate on the project.
• Acted as a liaison to the team to facilitate them to deploy the .
• Worked with the Policy and Procedure team as required to define new/updated policies and procedures.
• Provided post production support/analysis and assisted in performing User Acceptance Testing (UAT) and performance testing and validating test plans.

Environment: Rational Rose, Rational Requisite Pro, Rational Clear Quest, SharePoint, HTML, MS Project, MS Office, Macromedia Flash, M.S. Visio, M.S. Project, Dreamweaver, J2EE, SQL, Agile, Oracle