SUMMARY

• Experienced and distinguished Business Systems Analyst/ Business Analyst with 6+ years of experience in Software Development Life Cycle (SDLC) and Business Process Re - engineering.
• Worked throughout SDLC process from initiation/discovery phase to production release and provided post production support.
• Highly experienced in Doors/Rally/JIRA/HPALM for requirements management and defects tracking.
• Experience in documenting, analyzing, and producing key documents such as Business Requirements Document (BRD), Functional Requirements Document (FRD), and System Requirement documents (SRD), Requirements Traceability Matrix (RTM) and Data Dictionary.
• Extensive experience with life insurance products like term life, whole life and variable life products and annuity products like fixed and variable annuities.
• In depth knowledge in software development methodologies like Agile/SCRUM AGILE and project management principles.
• Experienced in working throughout the project lifecycle, starting from the initiation phase to project go-live and providing post production support.
• Experience in working with PMO office for facilitating in managing multiple projects by monitoring project milestones, highlighting project progress, risk/issues and maintaining an appropriate level of project progress reporting.
• Involved in test planning, test preparation, test execution and issue resolution and report generation to assure that all aspects of the project are in compliance with the business requirements.
• Experience in development methodologies like RUP, SDLC, AGILE, SCRUM and Waterfall
• Strong organizational and planning skills, ability to work well under pressure, result-oriented, self-motivating and versatile in problem solving.
• Strong experience using Guidewire tool for operational management in the insurance domain.
• Skillfully used techniques like interviews, surveys, workshops and JAD sessions by using design modeling tools like Microsoft Visio.
• Involved in creating various artifacts like BRD, functional specifications, Use Cases, UML diagrams, data mapping documentation, pre and post RTM, weekly reports etc.

TECHNICAL SKILLS

Business Modeling Tools: MS Visio, MS Word, MS Excel, MS PowerPoint, Outlook express, MS Project.

Software Dev Methodologies: Agile, Waterfall, RUP

Testing tools: ALM/Quality Center, Quick Testing Professionals, Clear Quest.

Requirement Managerial Tools: Requisite Pro, Doors.

Database: MS SQL Server, MS Access.

Language: SQL, #C, .net, JAVA

Reporting Tools: Cognos, SAP Business Objects, SAS, Crystal

PROFESSIONAL EXPERIENCE

Confidential, Boston, MA

Business Analyst

Responsibilities:

• Created mapping documents for the Comparative Raters, and provided business variable name, business variable ID, and transformation logic for the One Shield Dragon.
• The application would let customers submit online claims for Worker's Compensation Property and Casualty and the Non-worker's Compensation.
• Processed of New Business, Renewal, Cancellation, Reinstatement, Billing for various lines of business (Fire, Auto, and Commercial).
• Created technical impact documents, data mapping documents and defines ACORD mappings for various interfaces based on knowledge of business needs and working closely with senior department managers and key department members with limited supervision.
• Documented the Use Cases and prepared the Use Case, Activity, Logical, Component and Deployment views using MS Visio and Rational Rose for a clear understanding of the requirements by the development team.
• Applications tested were integrated to mainframe Vantage system which included business applications for new sales, policies, quotes, and web based applications.
• Facilitating priority meetings with stakeholders to help business understand the impact of the JIRA in prioritizing them
• Responsible for maintaining and providing research and audits for Reconciliation between systems used.
• Created DTS Packages for migration of data between MS SQL Server database and other databases like MS Access, MS Excel and Flat Files.
• Responsible for creating test scenarios, scripting test cases using testing tool and defect management for Policy Management Systems, Payables/Receivables and Claims processing.
• Worked closely with the Enterprise Data Warehouse team and Business Intelligence Architecture team to understand repository objects that support the business requirement and process.
• Gathered analyzed, documented business and technical requirements from both formal and informal sessions and validate the needs of the business stakeholders.
• Involved in all SDLC stages under Agile process requirement analysis, implementation, testing (functional and use acceptance) and deployment.
• Prepared requirements document for Commercial Auto, Inland Marine, Crime, Worker's Compensation, Umbrella, Business Owners Policy, Commercial Output Policy, and Commercial Property Package.
• Prepared Business Requirement Document (BRD) and Functional Requirement Document (FRD) for the enhancement of the existing services.
• Performed Gap Analysis to check the compatibility of the existing system infrastructure with the new business requirements.
• Shopping for an annuity, start with basic insurance. It is called a "single premium, immediate, lifetime annuity with death benefit.
• Involve in analyzing defects that have been reported in the JIRA and sending them over to the developers for a fix.
• Executed all aspects related to employee health insurance, worker's compensation, life insurance, long/short term, variable life, disability, employee discount/store benefits including company events coordination.
• Performed extensive data modelling to differentiate between the OLTP and Data Warehouse data models
• Proficient in creating Use Cases, Sequence Diagrams, and Collaboration diagrams, Activity Diagrams, Class Conferring with QA and Dev teams in both Agile and Waterfall work environments
• Experience in commercial Property and Casualty, Commercial Lines and Personal Lines Insurance, Underwriting, Rating and Guidewire experience with national carriers.
• Involved in writing SQL queries to validate backend systems and different integration points with One Shield.

Confidential

Business System Analyst

Responsibilities:

• Responsible for elaborating Billing Center integration user stories such as Integration to Agency Management system, Process commission payment via Enterprise Payment Services, Integration to commission management center, BC to PC custom integrations, etc.
• Acted as Guidewire Policy Center SME for Claims Center, Billing Center, Report Center and Duck Creek application resources
• Prepared requirements document for Commercial Auto, Inland Marine, Crime, Worker’s Compensation, Umbrella, Business Owners Policy, Commercial Output Policy, and Commercial Property Package.
• Performed extensive testing on the Integration between One Shield Policy Center and Guidewire Claim Centre to make sure all the da Requirements and responsible for identifying and closing gaps in the requirements.
• Worked closely with the Enterprise Data Warehouse team and Business Intelligence Architecture team to understand repository objects that support the business requirement and process.
• Continuous communication with the team to track requirements on rally and discuss to fix defects with JIRA tools, and corrected lesson learnt from each sprint.
• Used Agile methodology to gather requirements and work with the development0 and testing team Produced requirements and system work products including: Business process and data flow diagrams, Use cases/User Stories, Wireframe
• Perform Quality Audits. Ensure audits are completed accurately and are maintained consistently as per established procedures
• Communicate with Customer Service on ACORD Forms design and other technical problems.
• Involved in documenting customization requirements, business rules and data migration requirements for the Implementation of Guidewire Claim Center and Policy Center.
• Expert in Insurance Technology solutions like Guidewire suite and PEGA with in-depth knowledge in the Underwriting, policy administration, billing, rating, reinsurance and claims process.
• Expertise in understanding Policy Administration System using Guidewire Policy Center especially in Commercial Lines (Business owners, Worker's Compensation, Business Auto).
• Reviewed the data model and reporting requirements for Cognos Reports with the Data warehouse/ETL and Reporting team.
• Add a comment to the JIRA that need more Clarification if the Business Owner is not reflected in the JIRA.
• Managed General Liability, Commercial Property, Commercial Package, Commercial Auto and Workers Compensation policy lines.
• Involved in co-coordinating with different comparative rating vendors to implement with One Shield system for Auto & Home.
• Analyzed scope of the Edge project was to create a Web-based application for agents to submit and maintain commercial insurance claims.
• Worked on the commercial property and casualty domain and made specific changes to the same for the smooth flow of the process.

Confidential, Columbus, OH

Sr. Business System Analyst

Responsibilities:

• Strong ability in developing advanced SQL queries to extract, manipulate, and/or calculate information to fulfill data and reporting requirements including identifying the tables and columns from which data is extracted
• Use JIRA to track and report defects to developers. Before Logging the Defect, working with BA people to find out any requirement changes.
• Created product rules and gathered requirements for the implementation of discounts, rating inputs, and reports for implementing Guidewire Policy Center.
• Centralized the policy creation by integrating Guidewire Policy Center with Guidewire Claim Center Systems, Billing System and other existing system supporting operations.
• Generated Use case for business process and User Stories for Guidewire Policy Center to understand the various possible scenarios and dependency among various line of Business (LOB).
• Captured User stories using guidewire template; few major stories worked on included Commercial Auto, Worker's Compensation, Business Owners Policy and Commercial Property Package.
• Executed SQL queries for data analysis and documented them as part of validating the Business reports and for testing purposes.
• 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.
• Facilitated and led JAD sessions aimed at functional requirement walkthroughs for all the impacting projects and updated the documents based on recommendations (if any).
• 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.
• Preferred experience in audit, compliance, control, governance and within multiple servicing and default areas
• Facilitated JAD sessions with SMEs and business analysts from other feeder systems for a detailed analysis and a better understanding of impact of various projects on each other.
• Design and develop the data load process using Informatica PowerCenter and XML Style sheets and ACORD XML. Followed a structured approach to organize Requirements into logical groupings of essential Business Processes, Business Rules, and Information needs that insures any Critical Requirements are not missed.
• Systems Documentation included Business Requirements Document (BRD), Systems Requirement Specification (SRS) and test plans using Requisite Pro.
• Performed the requirement analysis, impact analysis and documented the requirements using Rational Requisite Pro and Utilized Agile experience with large and small teams
• Performed gap and impact analysis for new functionality requirements, as well as prioritized them based on actual business needs so as to align them with the product release roadmap.
• Involved in requirement gathering and database design and implementation of star-schema, dimensional data warehouse using Erwin Configured the Data mapping between Oracle and SQL Server.
• Add the JIRA number, date, Initials and a brief description to the comments section when I modified, added or struck-thru a requirement.
• Review requirements and understand technical recommendations and constraints, and develop comprehensive and accurate functional specifications; Data Mapping, and process flows.
• Gathered business requirements through interviews, surveys, JAD sessions and observations and created the Business Requirements documentation for building UI for viewing data through Guidewire Claim Center.
• Updated the impacted MS Access tables Worked extensively with MS Excel and MS access Analysis of business requirements and system requirements of the client and also for Property and casualty modules.
• Maintained on-going technical assistance and provided help desk support to customer's mainframe. Systems software that included problem determination and resolution.
• Authored various Use Cases and Activity diagrams, Sequence diagrams using Rational Requisite Pro and used UML methodology to define the Data Flow Diagrams (DFD).
• Participated in all Iteration, Scrum, Daily stand-ups and Iteration review meetings working in an agile development methodology.