PROFESSIONAL SUMMARY:

• Over 7+ years of Industry experience as a Business Analyst with solid understanding of Business Requirements Gathering, Evaluating Data Sources, Translating Requirements into Specifications, Application Design.
• Insurance experience includes Personal Property Casualty and Commercial Automobile Product knowledge, Reinsurance for Commercial Property Casualty, Group and Life Insurance Systems
• Proficient in Technical and Business Writing, Business Process Flow, Business Process Modeling, Business Analysis and Testing various methodologies.
• Expertise in Project Management i.e. Project Scoping, Planning, Estimating, Scheduling, Organizing, Directing, Controlling, Budgeting and Drafting Remedy Procedures.
• Working knowledge of Visio, and Argo UML.
• Having good knowledge of Property and casualty applications like Guidewire and Duck Creek.
• Experience in facilitating Joint Requirement Planning (JRP) sessions with Business User Groups, conducting Joint Application Development (JAD) sessions with IT Groups and Conflict Management with Project team members.
• Expert in the Property, Casualty, Annuities, Disability, and Supplemental Insurance policies include administration, sales, customization, claims, pensions and CMS.
• Extensive experience in building applications to support businesses, e.g. automation in Request for Quote process (RFQ), middle office trade booking/capturing, auto - generation of term-sheets/contracts, position keeping, Straight Through Processing.
• Strong understanding of project life cycle and SDLC methodologies including RUP, RAD, Waterfall and Agile.
• Experience in Object Oriented Analysis and Design (OOA/D).
• Competent in Creating Unified Modeling Language (UML) diagrams such as Use Case Diagrams, Activity Diagrams, Class Diagrams and Sequence Diagrams.
• 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.
• Proficient in DMAIC
• Extensive experience in documentation of business requirements and system functional specifications, including BRD, FRD, and FSD
• Strong experience in conducting User Acceptance Testing (UAT) and documentation of Test Cases. Expertise in designing and developing Test Plans and Test Scripts.
• Interface with clients from Operations, Marketing, Sales, Technologies, and Outside Vendors and act as their customer interface point as the lead of the Projects.
• Highly motivated team player with excellent Interpersonal and Customer Relational Skills, Proven Communication, Organizational, Analytical, Presentation Skills, and Leadership Qualities.

PROFESSIONAL EXPERIENCE:

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.
• Closely worked with and supported Product Owner to manage product backlog from user-stories.
• Performed the role of a primary Intermediary between the Subject Matter Experts, business user and technical SME's to identify the business needs, Business Rules, Business Processes & Interface Specifications for the New Claim module and Claims Assignment Module.
• Documented Policy integration and claims professional assignment details in Vision and Business Requirement Documents (BRDs), Functional Requirement Documents (FRDs) using Rational Requisite Pro and Power Designer.
• Assisted Scrum Master to facilitate scrum meetings such as Sprint Planning meeting, Daily Scrum meeting, Sprint Review meeting, Sprint Retrospective meeting, and Backlog Refinement meeting.
• 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.
• Transferred data (ETL) to Data ware house Environment using SSIS and SSAS.
• Building the cubes by using SSAS.
• Involved in Administration, Database Design, Performance Analysis, and Production Support for Large (VLDB) and Complex Databases up to 1 Terabytes.
• Analyzed long running slow queries and tune the same to optimize application and system performance.
• Maintaining the database consistency with DBCC at regular intervals.
• Used Log shipping for synchronization of database.
• Involved in generating various reports using the SQL Server Reporting Services.
• Conducted and led 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 non-functional requirements of the system including requirements and processes for insurance products.
• Expert in commercial Property and Casualty and Personal Lines Insurance experience with national carriers.
• Expert in the Property, Casualty, Annuities, Disability, and Supplemental Insurance policies include administration, sales, customization, claims, pensions and CMS
• Analyzed the as-is and to-be systems to perform GAP Analysis and make recommendation for system enhancement.
• Actively involved in creation of the UML diagrams such as sequence, activity and class diagrams for certain modules of the application using MS Visio and Rational Rose.
• Conducted and led 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 non-functional requirements of the system including requirements and processes for insurance products.
• As Scrum Master created and prioritized the Back Log in Rally, coordinated Planning Sessions and maintained User Stories and Acceptance Criteria.
• As Scrum Master moderated Spring Retrospectives, focused on results, to bring teams to a higher level of performance.
• Involved Java front-end developers work to create the best possible user experience.
• Assisted and directly involved with QA team in creation of Test Cases and tests implementation.
• Conducted UAT (User Acceptance Testing).
• Created User Interface Documents (UID) of prototypes and wireframes to help designing user interface.
• Created burn-down chart to monitor the completion of work within the time-boxes.
• Walkthrough session with development team and QA team to understand the business requirement clearly.
• Creates User Manual and trains Users to understand the new system.

Environment: Agile (Scrum) Methodology, Microsoft Office Suite (Word, Excel, Outlook, PowerPoint, SharePoint), SnagIt, HTML, SQL, .NET, Bug Zilla.

Business Analyst/Data Analyst

Responsibilities:

• Worked on UAT testing and took signoff from the Commercial line of Property & Casualty business users.
• Played key role in System Development Life Cycle Process consisting of: Design and Gap Analysis, Business Requirements, Systems Requirements, Test Criteria, and Implementation to have the outputs of project dealt with the automation of correspondence directed to Insurance policy owners.
• Analysed the existing as-is system for Insurance Personal Lines, tracked defects, provided recommendations to make enhancements in the future to-be system.
• Communicate professionally with law firms, claims examiners and auditors to verify contracted rate agreements
• Collaborated in building a business analysis process model using Rational Rose, RequisitePro, and Visio.
• Provided key initiatives in working with users in defining project and system requirements.
• Provided inputs in the strategic development of detailed project plans, work assignments, target dates etc.
• Developed strategies with Quality Assurance group to implement Test Cases in Mercury Test Director for stress testing and UAT (User Acceptance Testing
• Performed Integration testing, System testing, Regression testing and Performance testing of Billing Center, Policy center and Payment manager in Guidewire application based on the business requirements using LISA.
• Writing new COBOL, DB2 programs to handle Claim centre messages (from front end via XML) processed in the Mainframe from the front end system called Claim Centre (CC) using GUIDEWIRE working with SQL SERVER Data.
• Combining MDD with a test-driven development methodology by defining unit tests for the software up front gives the acceptance criteria to the development organization prior to the commencement of development, creating even less doubt of what is expected.
• Working with Agile/Scrum methodology, I organize daily scrum sessions with the off - shore team in India.
• Examined various bottlenecks and points for automation to streamline the claims processing, underwriting and pre- and post-sales process
• Followed Lean Six Sigma methodology to ensure that there are less defects and errors during the project and receive high quality outputs.
• Responsible for the development of a Data Warehouse for personal lines property and casualty insurance.
• Developed the QA test plan, test conditions and test cases to be used in testing based on business requirements, technical specifications and/or product knowledge by using Test Director.
• Helped with Data Mapping between the data mart and the Source Systems.
• Extensively used Test Director to review and update the status of entire testing process.
• Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, OOAD using UML and Business Process Modeling.
• Worked on several mainframe based applications running on an AS/400 platform.
• Extensively worked on the ETL mappings, analysis and documentation of OLAP reports requirements
• Coordinated re-architecting the existing VBA/Access system into ASP.net environment and existing table structure, stored procedures, and functions in MS SQL environment.
• Design and develop the data load process using XML Style sheets and ACORD.
• Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, OOD using UML
• Performed requirement analysis, went through all the use cases and issue logs.
• Worked extensively with MS Excel.
• Provide customer service and support for Property & Casualty risk management needs.

Environment:: Windows , Guidewire, MS Office(MS Word, MS Excel, MS Powerpoint, MS Visio), .NET, Oracle, Crystal reports, Mainframes, Agile/SCRUM, COBOL, JCL, Db2, Oracle, Java, J2EE, RUP, UML, SQL, SWOT analysis, GAP Analysis, Win Runner

Business Analyst

Responsibilities :

• Worked on SQL Server 2005 Database Administration.
• Managed the migration of SQL Server 2000 databases to SQL Server 2005
• Involved in Source Data Analysis, analysis and designing mappings for data extraction also responsible for Design and Development of SSIS Packages to load the Data from various Databases and Files.
• Expert in Using DMV’s, Performance dash board, Mirroring, database snapshot.
• 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.
• 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
• Developed front-end production entry screen and batch interfaces between remote AS/400s and the corporate mainframe.
• Integrating functionality for multiple components for achieving the ability to send and receive currency/ cash via various EFT (electronic funds transfer) systems e.g. ACH, Wire, CHAPS.
• Worked as a Personal line of Property and Casualty Expert for interface to Insurer Business Partner on all facets of system design.
• Implement and maintain Property & Casualty (e.g. bug-fix, data integration, version release) systems of assigned customers.
• Developed expertise with ACORD standard Life, Annuity & Health data model and data collection requirements, form models and archival stipulations.
• Worked on Client/Server tools like SQL Server Management Studio to administer SQL Server.
• Evaluated data storage considerations to store databases and transaction logs. Created databases using SQL Server Management Studio, Database Wizard and Transact SQL Statements.
• Did trouble shooting of Client connections, viewing error log and applications.
• Performed daily tasks including backup and restore by using SQL Server 2005 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.
• Expert in implementing the snapshot isolation and DDL triggers.
• Responsible for monitoring and making recommendations for performance improvement in hosted databases. This involved index creation, index removal, index modification, file group modifications, and adding scheduled jobs to re-index and update statistics in databases.
• Implemented in new T-SQL features added in SQL Server 2005 that are Data partitioning, Error handling through TRY-CATCH statement, Common Table Expression (CTE).
• Implemented Snapshot replication.

Environment:: Windows , MS Office(MS Word, MS Excel, MS Powerpoint, MS Visio), .NET, Oracle, Crystal reports, RUP, UML, SQL, SWOT analysis, GAP Analysis, Win Runner.

Data Analyst

Responsibilities :

• Analyzed clients systems and business processes.
• Prepared requirements document for Commercial Auto, Inland Marine, Crime, Worker’s Compensation, Umbrella, Business Owners Policy, Commercial Output Policy, and Commercial Property Package.
• Conducted user interviews, gathered requirements, analyzed the requirements by using Rational Rose, Visio and Requisite pro - RUP
• Was actively involved in the design of BRD, FRD, Use Case diagrams and Activity diagrams using MS Visio.
• Established a Business Analysis methodology around the Rational Unified Process.
• Developed UML Use Cases using Rational Rose and developed a detailed project plan with emphasis on deliverables.
• Worked on implementation and Guidewire suite integration; PolicyCenter and BillingCenter with interfaces to all related systems.
• Researched the various steps in the lifecycle and then constructed the system in a way that the high-risk customers would be easily identified and monitored.
• Streamlined clerical work processes and mapped then into the new system.
• Developed project plans and managed project scope.
• Assigned tasks among development team, monitored and tracked progress of project following Agile methodology
• Track and manage all Change Requests, using Rational ClearQuest.
• Maintained and tracked stakeholders requests for enhancements and changes using Unified Change Management tool (UCM) such as Rational ClearQuest
• Coordinating and Developing QA activities.
• Assisted in creating a High level Request for Proposal (RFP).
• Conducted presentations of the QA test results with analysis to the stakeholders and users and documented modifications and requirements.
• Conducted UAT; facilitated discussion between business team and QA team on determine the test requirements and pass/fail criteria; documented and reported user feedbacks to management team.
• Involved in Inception Phase and prepared vision statement and initial data models that contain Business Requirement Documents and supporting a document that contains the essential business elements and detailed definitions.
• Designed and Customized data models for Data warehouse.
• Worked extensively with MS Excel and MS access
• Responsible for acting as a liaison with operational and financial management, systems support and sales to identify business opportunities. Developed a file of ACORD Forms used as the standards in all Property and Casualty markets, for both Personal and Commercial Lines of Business.
• Collected & documented the requirement of Business Teams from Annuities at Prudential & ASPF, Policy & Program Evaluation Team, and Project Sponsors & Actuaries.
• Assisted in building a Business Analysis Process Model using Rational Rose and Visio.
• Performed extensive Requirement analysis and developed use cases and workflows.
• Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, and OOD
• Played a key role in the planning, User Accepted Testing, and Implementation of system enhancements and conversions.
• Implement and maintain Property & Casualty (e.g. bug-fix, data integration, version release) systems of assigned customers.
• Provided key input in working with users in defining project and system requirements.
• Developed strategic partnerships with the business units to develop a solid knowledge base of the business line; including the business plan, products, and process and revenue streams.
• Managed the development and implementation of the Independent Agent payroll system, Property & Casualty Specialist compensation system, Telesales compensation system, contingent and bonus compensation system and several compensation contract agreements with the MetLife agency sales force
• Documented and delivered Functional Specification Document to the project team.
• Conducted JAD sessions for communicating with Stakeholders and Project directors.

Environment:: UML, RUP , Mainframes, COBOL, JCL, Db2, Oracle, Rose, MS Word, MS Excel, MS VisioLoadRunner, WinRunner

Business Systems Analyst

Responsibilities :

• Conducted one to one interviews with Portfolio Manager to gather Business Requirements and was involved in the documentation of Business Requirement Documents.
• Developed requirement for the migration of 400,000 policies from an AS400 based legacy system to guidewire based Policycenter.
• Developed mapping document from AS400 to guidewire, designed technical specification in guidewire billingcenter.
• Assisted the Project Manager in setting realistic Project expectations and in evaluating the impact of changes on the organization and plans accordingly and conducted Project related presentations.
• Identified internal and external system Requirements, design and configuration set-up.
• 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.
• Extracted the Business Requirements from the end users keeping in mind their need for the application and prepared Business Requirement Documents (BRD) using Rational Requisite Pro.
• Responsible for database backups, restoration and scheduling backup strategies.
• Created new database objects like Tables, Procedures, Functions, Indexes and Views using T-SQL in Development and Production environment for SQL Server 2005.
• Conducted user interviews, gathered requirements, analyzed the requirements by using Rational Rose, Visio and Requisite pro - RUP
• Actively involved in implementing Agile/XP software development practices.
• Converted various SQL statements into stored procedures thereby reducing the Number of database accesses.
• Designed and developed Project document templates based on SDLC methodology.
• Developed Business Requirement Document as well as High-Level Project Plan.
• Functioned as the primary liaison between the Business line, operations, and the technical areas throughout the Project Cycle.
• Tuned DataStage transformations and jobs to enhance their performance.
• Wrote PL/SQL statement and stored procedures in Oracle for extracting as well as writing data.
• Defined the test criteria and project schedules, and baseline the Test Plan with the help of project meetings, walkthroughs.
• Documented the entire testing process, test cases and test results.
• Developed Functional Specification Document and Supplementary Specification (non-functional) Document.
• 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.
• Partnered with the Technical Areas in the research and resolution of System and User Acceptance Testing.
• Worked with Quality Control Teams to develop Test Plan and Test Cases.
• Develop User Manuals, and Training Manuals as per Project Specifications and timelines.

Environment:: UML, RUP, Microsoft Office Suite, Microsoft Visio, Unix, Documentum, Windows NT/XP, Oracle, SQL, Agile-Scrum, Quality Center, MS-Visio, SAP BI, BOBJ, e-Room, Cognos BI, Clarity, Essbase, Rational ClearQuest, Base Clear case, DB2, MS Project, MS Office Suite.