SUMMARY:

• 6+ years of experience as a Business Systems Analyst with solid understanding of Business Requirement gathering, Business Process flow, Business Process Modeling, Data Analysis, Data Mapping and Business Analysis.
• Experienced in manual and automated testing for both front - end and backend. Extensively used automated test tools of Mercury like Quality Center, Quick Test Pro, Win Runner, Test Director, Performance and Load Runner Testing.
• Expert in commercial Property and Casualty and Personal Lines Insurance experience with national carriers.
• Extensive experience with data modeling and defining the conceptual and logical model of the data warehouse.
• Expert in the Property, Casualty, Annuities, Disability, and Supplemental Insurance policies include administration, sales, customization, claims
• 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.
• Extremely proficient in using Agile and XP methodologies performed roles of Scrum Master following sprint sessions and used Rally software extensively to write User Stories, assign tasks to individual team members.
• Extensive experience in developing Use Cases, creating Screen Mockups, conducting Gap Analysis and Impact Analysis, SWOT analysis, Cost Benefit Analysis, Risk Analysis.
• Responsible to Track, Document, Capture, Manage and Communicate the Requirements using Requirement Traceability Matrix (RTM) which helped in controlling numerous artifacts produced by the teams across the deliverables for a project
• Involved in Test Planning, Test Preparation, Test Execution, Issue Resolution and Report Generation to assure that all aspects of a Project are in Compliance with the Business Requirements.
• Strong experience in conducting User Acceptance Testing (UAT) and documentation of Test Cases. Expertise in designing and developing Test Plans and Test Scripts.

TECHNICAL SKILLS:

Languages and Tools: UML, Rational Rose, RequisitePro, Rational SoDA, Rational Clear Case, Rational Clear Quest, Mercury Test Director, Quality Center, MS Project, MS Visio, MS Office Suite, Bloomberg,VBA for Excel, SQL, PL/SQL, J2EE, C#, VB.NET, Adobe Acrobat, PhotoShop, AutoCAD, 3D MAX

Databases: Oracle 8i/9i, MS SQL Server, MS Access

Environments: Windows 9x/NT/2000/XP, UNIX (Sun Solaris, AIX, HP-UX), Linux, Mainframe

PROFESSIONAL EXPERIENCE:

Confidential, Bethlehem, PA

Business Analyst

Responsibilities:

• Performed mapping of fields in Life Insurance application to New Business Submission Transaction (tc = 103) in the ACORD data model.
• Extensively designed Data mapping and filtering, consolidation, cleansing, Integration, ETL, and customization of data mart.
• Working with integration requirement with Docs and Forms, Policy, Rating, Customer Data Hub, Risk Report, Portfolio management, Policy Service, Analytical systems and defining rules and requirements for online Sales portals
• Have performed work in all phases of a CRM, Software Development and Validation Lifecycle SDVLC project lifecycle .
• As a functional consultant, implemented Guidewire Policy Center through an Agile Scrum development model
• Have worked in Guidewire Policy Center from End-to-End and involved in Policy Info, Person Info, Losses and Violations, Coverage's, Risk Analysis Customizations.
• Provide support in developing and maintaining ETL processes that extract data from multiple SOR's residing on various technology platforms then transport the data to various delivery points such as data marts
• Used JIRA to perform test management activities and used JIRA tool to track and maintain different versions of the project documentation.
• Explained Property & Casualty terms, Insurance Rules, Workers Compensation, Claim to the Dev team.
• Aided the Product Owner for developing project plan as well as managing the project scope for the billing and policy center tool of the business insurance policies segment of property and casualty
• Strong knowledge of working on JIRA and Tableau and rained the team on JIRA tool for Agile/ Scrum Methodologies.
• Expertise in understanding Policy Administration System using Guidewire PolicyCenter especially in Commercial Lines (Business owners, Worker's Compensation, Business Auto).
• Working as a Guidewire Business Analyst for the Advance Project in the Personal Lines PolicyCenter, which is a web-based policy administration system used for quoting and applications for all personal lines product
• Advanced knowledge of case law and state Workers Compensation laws, subrogation, reserve setting and litigation management
• Managed a Enterprise data warehouse implementation project for Dominion Capital, working with IBM and the CIO to assess, design and configure the servers, databases, applications and fail-over recovery process .
• Experience in commercial Property and Casualty, Commercial Lines and Personal Lines Insurance, Underwriting, Rating and Guidewire experience with national carriers.
• Created Technical specifications documents based on the functional design document for the ETL coding to build the data mart.

Confidential, Salem, OR

Business Analyst

Responsibilities:

• As a functional consultant, implemented Guidewire Policy Center through an Agile Scrum development model
• Have worked in Guidewire Policy Center from End-to-End and involved in Policy Info, Person Info, Losses and Violations, Coverage's, Risk Analysis Customizations.
• Analyzed the business rules for Auto claim assignments throughout the US, so as to have balanced work load for all the claims reps.
• Generated data mapping documents from production databases to the warehouse and from the warehouse to the policy and claims marts.
• Any formal qualifications in Agile, ISEB and/or Project Management would be of interest but by no means essential.
• Explained Property & Casualty terms, Insurance Rules, Workers Compensation, Claim to the Dev team.
• Aided the Product Owner for developing project plan as well as managing the project scope for the billing and policy center tool of the business insurance policies segment of property and casualty
• Strong knowledge of working on JIRA and Tableau and rained the team on JIRA tool for Agile/ Scrum Methodologies.
• Expertise in understanding Policy Administration System using Guidewire PolicyCenter especially in Commercial Lines (Business owners, Worker's Compensation, Business Auto).
• Working as a Guidewire Business Analyst for the Advance Project in the Personal Lines PolicyCenter, which is a web-based policy administration system used for quoting and applications for all personal lines product
• A new Umbrella Policy Administration System was set up to issue/quote new Umbrella insurance Policies to provide higher liability coverage limits for members.
• Assisted in the implementation of Umbrella product from mainframe to a web based platform and rolling it out to a 24 state region.
• Advanced knowledge of case law and state Workers Compensation laws, subrogation, reserve setting and litigation management
• Experience in commercial Property and Casualty, Commercial Lines and Personal Lines Insurance, Underwriting, Rating and Guidewire experience with national carriers.

Confidential, NJ

Business Analyst

Responsibilities:

• Performed extensive data modeling to differentiate between the OLTP and Data Warehouse data models
• Provided business specifications for ETL Processing and report requirements tBusiness Intelligence team.
• Identified the organizational needs and provided suitable agile system based solutions.
• Develop source-to-target mapping documents by analyzing data content and physical data structures in the legacy and downstream applications. Develop mappings to enable data migration, application integration.
• Generated automated scripts for Guidewire Quick Quote, Application and Policy Binding Processes.
• Conducted JAD sessions with CRM SMEs, system architects, technical teams and other stakeholders for open and pending issues.
• Testing of SSIS, DTS and Informatics ETL packages for loading of data into the Data Warehouse
• Managed a Enterprise data warehouse implementation project for Dominion Capital, working with IBM and the CIO to assess, design and configure the servers, databases, applications and fail-over recovery process.
• Developed comprehensive system test scenarios and test scripts. Responsible for performing back-end analysis and testing using SQL queries
• Tracking business reporting issues on JIRA by creating problem statements that help breakdown the underlying issue.
• Created Enterprise Data Warehouse to be used for ECommerce Created repositories using Informatics’ PowerMart and PowerCenter Repository Manager, Server Manager on Oracle 8i database NT platform.

Confidential, NY

Business Analyst

Responsibilities:

• Build Platform features, user stories, and maintain backlog with priorities, using Rally and JIRA platforms; Drive HLD, Low Level, and Integration (SOAP, REST, JSON, XML etc) Designs
• Working as a Guidewire Business Analyst for implementation of Guidewire ClaimCenter 9.0 and PolicyCenter 9.0 for Personal Lines for Business.
• Ensured that all bugs are logged with adequate information into JIRA to assist developers in reducing the problem.
• Managed and monitored various scrum events through agile delivery process, worked closely with project manager, product owner and stakeholders to ensure their expectations are met.
• Conducted JAD sessions with CRM SMEs, system architects, technical teams and other stakeholders for open and pending issues.
• Prepared the Integration Requirements for the Integration points between Guidewire ClaimCenter and Client's legacy systems and other 3rd party service providers
• Writing user stories for Business Process Flow, System Integration Testing based on the Configuration requirements of Guidewire ClaimCenter for Personal Auto LOB
• Involved with the technical team in understanding the XML file format required for Split loss process and Policy process
• FTP process requirements for the Inbound and outbound files transfer between Guidewire and various 3rd party vendors like - Enterprise, Safelite, Quest, TransUnion, LexisNexis, General Ledger, ISO/Verisk, AIS.
• Developed comprehensive system test scenarios and test scripts. Responsible for performing back-end analysis and testing using SQL queries
• 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.
• Participated in techniques such as SPRINT planning, Product Backlog management, agile estimation, daily SCRUM, metrics such as Burn-down & Velocity charts, Sprint summary report, Sprint review/retro meetings etc
• Write and execute positive and negative test cases to ensure the data originating from the data warehouse Oracle dB is accurate through to the SQL dB in the applications.
• Completed various research and investigation activities for carrier's current policy renewal processes, underwriting guidelines, risk assessment tools, Auto symbols
• Worked closely with the Enterprise Data Warehouse team and Business Intelligence Architecture team to understand repository objects that support the business requirement and process.