PROFESSIONAL SUMMARY

• Business Analyst with 7 years of professional experience in business analysis, business process analysis, business requirements, database design, business process modeling and strategic planning in the field of Insurance.
• Domain knowledge of insurance industry with very challenging and demanding work environment. Broad experience in Property and Casualty Insurance including Auto, Home, and Marine Life insurance/Annuities.
• Worked with various insurance policy admin system and map policy information to ACORD.
• Extensive skill on Guidewire Billing Center, Policy Center and Claims Center integrations.
• Strong experience in Software Development Life Cycle SDLC methodologies such as Agile, RUP and Waterfall.
• Strong documentation skills in developing Business Requirement Document, Functional and Non-Functional Specifications.
• Highly skilled in using Class Diagrams, Data Flow Diagrams, Sequence Diagrams, UML tools, Use Cases, Activity Diagrams, Wireframe Prototypes
• Participated with QA team to perform Integration/ Black Box / Unit/ UAT/ Functional /Stress/ Regression /Performance/ System Testing. Expert in Test driven development and testing methodologies for performing UAT, system integration testing SIT , business acceptance testing BAT and documenting test results.
• Expertise in Database Modeling, Data Mapping, ETL, Data Quality Management, Data Analysis, Requirement Analysis, Business Modeling, Data Migration, Data profiling, Dimensional Modeling, Entity Relationship Diagrams ERD , SQL and reporting process.
• Widespread experience with data warehousing, extraction, transformation and loading ETL and business intelligence BI tools.
• Exceptional communication, analytical, interpersonal, and presentation skills expert at managing multiple projects simultaneously.

BUSINESS TECHNICAL SKILLS

• UML, RUP, SQL, Six Sigma, Waterfall, Agile SCRUM , JIRA, BI, BOBJ,e-Room, Rational Suite Rose, Requisite Pro, ClearCase, ClearQuest , HP Quality Center, Clarity, Essbase, Rally, TestLink, Guidewire, MS Visio, Share Point, QC, UNIX, Rational Clear Case, Test Director, QTP, WinRunner, Load Runner, Erwin, Oracle, DB2, Microsoft Office Suite Word, Excel, Powerpoint, Visio, Project , MS Project, Web Services, Adobe Acrobat Suite, SQL Server 2008

PROFESSIONAL EXPERIENCE

Confidential

Sr. Business Analyst/Scrum Master

The project involved establishing a Finance Warehouse. It was designed to be the source of central Property Casualty Finance data. The main goal of the Finance Warehouse was to deliver an answer for Property Casualty Global FP A actuals, expense analytics, reporting, and other FP A business processes on a single data source platform. Experienced in insurance models such as life and annuity and P C. AIG is the world's largest insurance organization with more than 88 million customers around the globe. AIG's corporate headquarters are in New York City. The project followed Agile Scrum methodology.

Responsibilities

• Performed on the ETL mappings, analysis and documentation of OLAP reports requirements.
• Formulated the ER diagrams of Property and Casualty data and data flow diagrams in order to interact with database developers.
• Implemented UML, Use Case diagrams by using MS Visio in order to conduct a more effective and healthy communication with stakeholders and clients.
• Conducted JAD sessions, group workshops, individual and small team meetings, and conference calls with Property Casualty FP A teams, stake holders and developers to gather functional and nonfunctional requirements of the system including requirements and processes for life and annuity products.
• Involved annuity performance data process.
• Involved in scrum sprint planning sessions, backlog grooming, sizing, spring retrospectives and reviews, daily stand ups, user stories and acceptance criteria.
• Created and prioritized the back log in rally, coordinated planning sessions and maintained user stories and acceptance criteria.
• Communicated with product owner for organization and prioritizing the back log in rally, lead spring planning sessions to control and update user stories.
• Provided training to users and involved in conducting UAT sessions to gain user confidence and approval.
• Examined key Performance Indicators KPI for Property and Casualty such as Loss Ratio, General Operating Expense Ratio.
• Analyzed as-is and to-be systems to perform GAP Analysis and make recommendation for system enhancement.
• Extensively worked BI /BOBJ for multidimensional expenses actual reports.
• Extensively worked Cognos BI for international data.
• Documented report layouts and report mapping documents for ad hoc reporting based on Property Casualty FP A team's needs.
• Assisted and directly involved with QA team in creation of Test Cases and tests implementations.

Tools Technologies

Agile-Scrum, Rational ClearQuest, Rally, MS Office Suite, Essbase, MS-Visio, BI, DB2, BOBJ, e-Room, Cognos BI ,Clarity, Base Clear case, , MS Project.

Confidential

Sr. Business Analyst

This primary goal of the project is to support variety of property and casualty insurance and Life Annuities insurance reporting and analytical requirements of American Family Insurance - WI by establishing Enterprise Data Warehouse EDW Business Intelligence layer. This EDW is executed by acquiring data from multiple RDBMS sources such as billing database, financial database, producer database, customer database, policy database and claims database for BI layer requirement to serve as central source of data. Business Objects BO is used to execute the BI layer in order to fulfill reporting and analytical requirements such as analytical reporting, audit reporting, operation reporting, management reporting and state filing reporting. The project followed RUP methodology.

Responsibilities

Inception

• Defined project scope, risks and determined appropriate methodologies to apply based on Scope/Vision documents, and developed project time lines for on time delivery based on SDLC methodology.
• Executed discussions with stakeholders from both business side and IT side in order to elicit high level requirements and estimate project feasibility.
• Conducted surveys among different end users in order to gather detailed requirements, and documented business requirements.
• Carried out Order Management System OMS in order to make sure compliances with upgrade requirements.
• Determined the data warehouse business requirements as the foundation for database design, data extraction and analysis by working with the end users.
• Performed JAD Joint Application Development sessions to resolve conflicts between business requirements and technical design.

Elaboration

• Created detailed various UML models including use case diagram, activity diagram, and sequence diagram while working with software developers to make sure that the applications fit in to the requirements and worked on the business flow and account relationships in accordance to the specific databases and tables involved in progress.
• Created the design of the data warehousing snowflake schema logical database model.
• Established report specifications, cube and ETL by working with the Data Architects and used Six Sigma and tools for profiling, data mapping and monitoring data by tracking and improving enterprise data.

Construction

• Used Traceability Matrix intensively for the business processes and expected changes.
• Coordinated with QA in order to establish test plans and test scenarios for performance testing, system testing, integration testing.
• Worked with the business testing team to generate Test Plans, Test cases, Testing Evaluation strategy and methods for user acceptance testing UAT .
• Worked closely with the project manager to observe project progress and status using MS Project, delivered high level estimates for analysis, delivery schedule and resource allocation.
• Cooperated with the team members and the project manager in defect review meetings to find, track, identify, prioritize and remove bugs.

Transition

Acquired user feedbacks, coordinated UAT, and used training materials for various end users and assisted in User Training for the system.

Tools Technologies

MS Office Suite, Clarity, RUP, MS-Visio, MS Project, BI, Essbase, Rational ClearQuest,DB2, e-Planning, , Six Sigma, , Erwin, Cognos BI.

Confidential

Sr. Business Analyst/Scrum Master

The main goal of the project was to build an Internet based application by using the Guidewire Policy Center and Billing Center which are product platforms provided by Guidewire Software Inc. The application would let customers submit online claims for Worker's Compensation Property and Casualty and the Non-worker's Compensation. The project followed Agile Scrum methodology.

Responsibilities

• Executed personal interviews, brainstorming sessions, JAD sessions, focus groups and personal interviews to be able to help the client with the business process.
• Documented and developed formulas for the calculation of premiums and losses statistics in the marts Written Premium, Earned Premium, Unearned Premium
• Prioritized functional and non-functional requirements via data analysis, interviews and different modeling tools.
• Generated business requirement documents, functional requirement documents and data mapping documentation.
• Generated automated scripts for Guidewire Quick Quote, Application and Policy Binding Processes.
• Performed in depth data analysis identifying data issues in legacy system and worked with business to develop resolutions to those issues.
• Conducted MS Project to report status and planning.
• Involved in migration process from Mainframe, policy legacy systems to Guidewire applications.
• Used MS Visio, designed Activity Diagrams, Use Case Diagrams and Sequence Diagrams
• Generated data mapping documents from production databases to the warehouse and from the warehouse to the policy and claims marts.
• Worked with the team to implement SCRUM methods for project implementation and development.
• Generated test data by using TestPatrner on Guidewire Policy Center.
• Created various tests for System Architects and Quality Assurance Analysts.
• Established Data Driven Automation Framework to be able to perform UI testing on Guidewire applications.
• Checked the compliances of corporate SDLC policies and guidelines.
• Involved in defect tracking to encounter specific requirements for a successful project implementation.
• Conducted UAT with business users.
• Tools Technologies
• Microsoft Office Suite, Microsoft Visio, Windows NT/XP, SQL, Agile-Scrum, Rally, Commercial Edge, SharePoint.

Confidential

Business Analyst

The scope of project was to establish a Property and Casualty enterprise data warehouse and Data Marts in order to meet the data management and reporting requirements. The Data Warehouse was created around the Accord Messaging Standard with extensions where necessary Workers Compensation, Commercial and Personal Lines Auto .

Responsibilities

• Used JAD sessions, brainstorming sessions and personal interviews to acquire business requirements from business users and stakeholders.
• Generated financial forecasts for the given project by using the scope of the system.
• Conducted Visio to develop use case model. Produced a development plan for the overall project and prototypes.
• Created UML diagrams including activity and sequence diagrams by using MS Visio.
• Determined the functional requirements, non-functional requirements and user stories.
• Created business requirements document and functional requirements document.
• Worked intensively on data warehouse and mart design sessions for both Logical and Physical design.
• Established ETL for Warehouse and Data Marts.
• Assisted developers to determine the purpose of database tables and attributes in their existing systems where documentation was lacking.
• Worked with developers in writing of complex SQL queries to resolve data issues in source system databases.
• Established and implemented test cases that verifies data transfer quality.
• Worked with offshore development team.
• Tools Technologies
• MS Visio, Waterfall, Rational Clear Case, J2EE, Java, JSP, XML.

Confidential

Business Analyst

The Farm Family group of insurance companies' headquartered in Glenmont, New York, is part of the American National Family of Companies. Farm Family has been providing insurance protection for families and businesses since the 1950s. The main purpose of the project was to develop forecasting, investments, financial reporting, cost accounting, and overall performance of operations.

Responsibilities

• Gathered business requirements through brainstorming, interviews and surveys.
• Managed financial services and planned analysis. Involved in Task Board updating as a team member.
• Planned and defined system requirements to Use Case, Use Case Scenario and UML Unified Modeling Language methodologies
• Estimated precise expenses for operating and annual budgets.
• Involved in training material preparation and managed comprehensive accounting matters including accounting receivable and payable to ensure proper resource allocation.
• Determined functional and nonfunctional requirements with the help of user interviews.

Tools Technologies

MS Visio, Microsoft Office Suite, Adobe Photoshop, Waterfall, SQL, Windows XP, ASP, DreamWeaver, XML.

Confidential

Jr. Business Analyst

The main goal was to automate the claims processing systems and enhance the CRM by providing real time monitoring for its auto insurance division. The project involved developing system in place for online quote applications to obtain reliable quotes in real time from Liberty Mutual Insurance's existing web portal. The Project was undertaken to enhance the existing functionality of convenient access to real-time quote information, ability to download quote information. The application also helped agents to obtain quotes for their customers.

Responsibilities

• Interacted with 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 Lines Property and Casualty business.
• Extracted the Business Requirements from the end users keeping in mind their need for the application and prepared Business Requirement Documents BRD using Rational RequisitePro.
• Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams using UML and Business Process Modeling.
• Performed Business Process Mapping and performed as is and to-be analysis
• Develop test plans in conjunction with team leads and business personnel and perform unit, integration, regression testing.
• Analyzed the business and functional requirements of the application and developed detailed test plans, test cases in Test Director.
• Reviewed Development Plans, Quality Assurance Test Plans and User Documentation to ensure correct interpretation of original specifications.
• Conducted Functional Walkthroughs, User Acceptance Testing UAT , and supervised the development of User Manuals for customers.

Tools Technologies

Waterfall, Rational Clear Case, XML, Java, J2EE, JSP, MS Visio.