SUMMARY

• Over 7 years of professional experience as a Business Analyst in Insurance domain and banking domains.
• Insurance experience includes Personal Property Casualty and Commercial Automobile Product knowledge, Worker’s compensation, Umbrella, Home Insurance, and Reinsurance for Commercial Property Casualty, Group and Life Insurance Systems.
• Expert in commercial Property and Casualty and Personal Lines Insurance experience with national carriers.
• Expert in commercial Property and Casualty and Personal Lines Insurance experience with national carriers.
• Extensive experience in conducting Market Research, Feasibility Studies, Data Analyses, Data Mapping, Data Profiling, Gap Analyses, Risk Identification, Risk Assessment, Risks Analyses, and Risk management.
• Strong experience in RUP SDLC methodology process and Agile Methodology.
• Proficient as Scrum Master and planning the Sprint meeting with the Agile Software life cycle method.
• Extensive experience in analyzing and requirements gathering and writing business requirement and functional specifications.
• Experience in designing and developing reports using Microsoft Reporting Services (MSRS), Crystal Reports, MS Access, and Data View web part
• Proficient in developing and debugging SAS/MACROS to access, extract, modify, merge, and analyze financial data and other SAS application for data updates, data cleansing, and reporting
• Expertise in broad range of technologies, including business process tools such as Microsoft Project, MS Excel, MS Access, MS Visio, technical assessment tools, MicroStrategy Data Warehouse Data Modeling and Design. Experienced in SQL Server Reporting Service (SSRS), Executing Queries and Running Store Procedures.
• Extensive experience in Strategic development of a Data Warehouse and in Performing Data Analysis and Data Mapping from an Operational Data Store to a Enterprise Data Warehouse
• Extensively worked on store procedures for new system changes and troubleshoot the existing store procedures to work more efficiently.
• Excellent knowledge and experience of creating source to target mapping, edit rules and validation, transformations, and business rules.
• Solid understanding of Business Process definition, Risk Analysis and SDLC methodologies.
• 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.
• Expertise in logical process & workflow modeling, including Flow Charts, Dataflow diagrams, Use Case diagrams, and Activity diagrams. Extensive experience with MS Visio
• Proven expertise in the various techniques of data collection & meeting facilitation, including Questionnaire, Personal Interviews and JAD Sessions.
• Excellent analytical skills and a proven ability to analyze business processes, gather requirements and interpret business objectives and data into Business Requirements and Functional specification documents
• Expertise in Technical advising, Team leadership and mentoring.
• Worked closely with team of Project Manager, Developers, users and testers throughout the entire software development lifecycle to identify problems and build solutions as a team.
• Excellent process management, communication and problem solving skills with remarkable ability in gathering requirements
• Efficient in planning, organizing and implementing a testing effort by working closely with the team and the project manager
• Smart in mastering new skills and adapting to new tools and ever changing technology
• Quick learner, good organization skills and a committed team member.

TECHNICAL SKILLS

Methodologies: SDLC, Waterfall, Agile - RUP, Scrum.

Operating System: Windows 2008/XP/2007/2003, Linux, Unix, Mac OS X

Project Management: MS Office suite, SharePoint & Project, Rational Rose, Requisite Pro, Lotus Notes, Guidewire, PeopleSoft, Crystal Reports.

Web Designing: MS Visual Studio, Adobe Dreamweaver, MS Expression web/blend, Balsamiq Mockups, iRISE, Axure RP, Adobe Photoshop.

Defect Tracking: Test Director/Quality Center, HP Quality Center, HP WinRunner, HP LoadRunner, Microsoft Test Management tools

Database: Microsoft SQL Server, MYSQL, Oracle 7i, 8i. MS Access.

Language: C#, .net, Java.,J2EE XML

Application environments: C#, .NET Framework, ASP.NET, PDF, .NET WebServic

PROFESSIONAL EXPERIENCE

Confidential, San Diego, CA

Business Analyst

Responsibilities:

• Involved with all the phases of Software Development Life Cycle (SDLC) Scrum methodology throughout the project life cycle
• Experience with Guidewire claim center and INLIAS (Insurance Product)
• Studied and assessed the clients systems and business processes
• Coordinated with different business entities and came out with a better solution
• Interviewed client for project requirements
• Conducted JAD sessions with business sponsors, developers and testing team
• Assisted project team with gathering requirements in requisite pro
• Spearheaded work sessions between business users, operational groups, business line and various other stakeholders to finalize business requirements, resolve issues, track project status and provide framework for future steps
• Developed and prepared business requirement and procedure to process data
• Conducted walkthroughs with the different department heads to have a deeper understanding of the requirement
• Involved in the meeting with Business Process Owners, SME (Subject Matter Experts) and store users for Requirement gathering in Definition Stage.
• Responsible for writing Functional Requirement Specifications (FRS)
• Conducted the FRS reviews and walkthroughs with designers, developers and stakeholders.
• Analyzed Business Requirements and segregated them into high level and low-level Use Cases, Activity Diagrams/State Chart Diagrams (UML).
• Work closely with production underwriters to review commercial property insurance renewal and new business opportunities to ensure proper risk identification, analysis and assessment and the development and growth of a profitable portfolio of business.
• Mapped the old requirements with the new requirements and communicated it with the business groups for the gap analysis.
• Assisted PM in creating project plans taking into consideration projects’ mission, process flows, timelines, and requirements to document them
• Created and Reviewed Use Cases
• Facilitated Joint Application Development sessions to identify business rules and requirements and then documented them in a format for inter and intra departmental review
• Documented the User Manual and trained the end users for the application
• Involved in full Software Development Life Cycle
• Created System Requirements and Use Cases
• Coordinated with different team members to resolve the issues that are related to the new application.
• Created User Story’s based on the discussions with SME’s for the customization of GuideWire Product for the Policy center application.
• Prepared Test Strategy, Test Plan, test report and Gap Report
• Performed UAT based on Requirements Document and prepared the Test Cases using Quality Center.
• Handled the requirement traceability and defect tracking thru Quality center
• Maintained Traceability Matrix in Excel.
• Created the Test Cases for functional testing of the system.
• Performed Automated testing using Quick Test Pro and load testing using Load Runner
• Worked with the other team members in order to maintain the Change control process and Version Control.
• Collaborated with developers as needed to determine the root cause of defects
• Validated the application against the requirements.
• Review requirements and create a test strategy to be implemented.
• Created presentation for the high-level management demos.
• Demonstrated the application to the top management.

Environment: Windows, MS Office(MS Word, MS Excel, MS Powerpoint, MS Visio), GuideWire, .NET, Oracle, Crystal reports, Mainframes, COBOL, JCL, Db2, Oracle, Java, Cognos, RUP, UML, SQL, SWOT analysis, GAP Analysis, Win Runne

Confidential, Madison, WI

Business Analyst/Data Analyst

Responsibilities:

• Conducted meetings with the IS Subject Matter Experts for understanding the flow of the Use Cases in order to update the Use Cases for the new system.
• Conducted Use case walkthrough meetings with the Business Experts (Client team), in order to update the Business Rules and flows of the Use cases and add more enhancements to the System to make it more User friendly and efficient.
• Conducted review meetings with the team members and the Project Manager in order to update the status of the project.
• Involved in preparing the User stories and UI wireframes for the new system based on existing system screen shots.
• Worked extensively on Guidewire Billing Center from the inception of the project.
• Worked closely with Guidewire Developers to understand the GW Billing center functionalities.
• Worked closely with Guidewire Policy Center and Payment Manager Teams to co-ordinate the requirements.
• Conducted Gap Analysis to gather the requirements, by comparing existing Legacy billing center and Guidewire Billing center.
• Worked closely with the QA team after the requirements build in order to provide sign off for the PBI’s after testing the requirements.
• Worked on Agile methodology to keep the whole team involved in the project in terms of communication.
• Was involved in daily stand up meetings with both the Technical team and the QA team to provide the document artifacts and defects for the release.
• Was extensively involved in preparing new Use cases and updating the existing Use cases for the applications.
• Was extensively involved in System testing the Development tier of the system after the first phase of coding in order to track defects.
• Extensively used JIRA (defect tracking tool) in order to track the defects for the Technical team to work on.
• Coordinated with the Project Manager in order to set up meetings with different Users and Clients in order to gather the requirements for updating the System.
• Worked on different prospective of Gap Analysis like Organization and Business Processes.
• Performed the Project Management duties in the absence of the Project Manager to ensure project coordination in order to meet Client deadlines.
• Also worked as a Release Coordinator in order to manage the coordination of three different projects (ICS Financials 8.0, ICS Non-Financials 8.0 and Claim Office Reconsolidation 8.0) which are going into Production with the same release.
• As a Release Coordinator, conducted daily walk through meetings with the Project Managers, Technical and QA Leads of the projects in order to track the progress of their projects and update the Release Coordination artifacts.
• Prepared and updated various excel sheets for Project Coordination and Project Management such as ICS Security Matrix, Activity Record Matrix, Claim Details and Valid values sheet, System messages matrix and Error messages matrix.

Environment: Microsoft Office Suite, SOAP UI, SQL, Microsoft Visio, UNIX, Windows NT/XP, Agile, Project Management, Adobe Photoshop, Sessions Manager.

Confidential, CA

Business Analyst

Responsibilities:

• Analyzed clients systems and business processes.
• Managed General Liability, Commercial Property, Commercial Package, Commercial Auto and Workers Compensation policy lines.
• 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.
• 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.
• 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.
• Prepared requirements document for Commercial Auto, Inland Marine, Crime, Worker’s Compensation, Umbrella, Business Owners Policy, Commercial Output Policy, and Commercial Property Package.
• Implemented the Electronic Funds Transfer feature in the billing system based on client request.
• Developed a file of ACORD Forms used as the standards in all Property and Casualty markets, for both Personal and Commercial Lines of Business.
• Responsible for testing the Quote & Online Purchase for both Auto and Home Property Insurance of the customers.
• Responsible for gathering and documented the business requirement and identified enhancements.
• Analyzed standard industry practices of back office applications of Insurance Company, underwriting, billing, policy and claims administration with the help of Subject Matter Expert.
• 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.
• Actively involved in validating the requirements and applying the RUP framework throughout the SDLC.
• Used SDLC (System Development Life Cycle) methodologies like the RUP and the waterfall.
• Worked extensively with MS Excel and MS access
• Performed Requirement Analysis to Develop Use Cases, Activity Diagrams and Sequence Diagrams. Hence developed and documented conceptual design of Application in System Specification Document.
• Also Performed the as-is and to-be business processes, business rules, business and system requirements, user and system interface requirements.
• Integrated Rational Requisite Pro with Rational Rose, Clear Quest and Clear Case to provide the visibility to the teams and maintain traceability among Requirements, Use Cases, Change Requests and Configuration Changes.
• Used SQL queries to filter data within the Oracle database.
• Wrote Test plan and Test cases for the Integration testing and system testing.
• Designed the business requirement collection approach based on the project scope and SDLC Methodology.
• Clarified QA team issues and reviewed test plans and test scripts developed by QA team to make sure that all requirements will be covered in scripts and tested properly.

Environment: Quality Center, Quick Test Pro, Load Runner, MS Project, MS excel, MS Word, MS Visio, MS .NET, MS SQL, MS FrontPage, MS Power Point.

Confidential, Columbus, OH

Data Analyst/ System Analyst

Responsibilities:

• Reviewed and analyzed the business environment and identified process improvements.
• Interacted with Business Users to conduct thorough Requirements Analysis.
• Used DataStage Manager for importing metadata from repository, new job categories and creating new data elements.
• Work closely with production underwriters to review commercial property insurance renewal and new business opportunities to ensure proper risk identification, analysis and assessment and the development and growth of a profitable portfolio of business. Involved in Data Modeling of both Logical Design and Physical design of data warehouse and data marts in Star Schema and Snow Flake Schema methodology.
• Performed backend testing using SQL queries and analyzed the server performance on UNIX.
• Coordinated activities with project manager and various other teams using MS Project.
• Assisted in on-going process improvement efforts to ensure Test Planning, Execution, and Reporting is effective, efficient, standardized, coordinated, and integrated.
• Assist other project teams with data analysis, data mining and data profiling as needed.
• Developed the ETL Informatica Mappings for importing data from ODS into subsequent data marts.
• Involved in Managing Data modelling project from Logical design and implementation of Sybase Database. Performed GAP analysis of system rules, system and system process flows, user administration, and requirements
• Acted as User Acceptance Testing coordinator and monitored business testing and interfaced with the development team regarding defect status and fixes on a daily basis.
• Involved in generation and execution of SQL queries.

Environment: Microsoft Office Suite, MS Visio, Java, C, Windows NT, JavaScript, UNIX, HTML, Oracle, SQL, Mercury TestDirector, Mercury LoadRunner