PROFESSIONAL SUMMARY:

• Over 8+ years’ experience as Business/Systems Analyst in directing cross - functional teams of technical experts to analyze systems & processes and implement infrastructure improvements. Familiar wif Prototyping, RUP, SDLC methodologies.
• General experience includes Business Process Analysis, Business Modeling, Business Intelligence, Data Warehousing, Data Modeling, User Acceptance Testing (UAT) and Implementation.
• Hands on exposure in Workmen Compensation, Commercial Insurance as well as Property & Casualty Insurance & its various intricacies.
• Managed Services for ISO Claim Search for Auto/ Property/Casualty Insurance's for improving Claim’s processing and fraud detection on filed claims.
• Extensive noledge of Policy Admin system and related operations like New Business, Endorsements, Billing and Claims in property and casualty - Personal Lines.
• Expertise in understanding the business needs, defining a creative and useful software solution to the management, implementing, and the application to the user community.
• Insurance experience includes Personal P&C and Commercial Automobile Product noledge, Reinsurance for Auto, Claims and Home Insurance Systems.
• Excellent noledge of various policy administration & industry standard tools such as Guidewire PolicyCenter, Guidewire ClaimCenter, Guidewire BillingCenter.
• Identified the options for potential solutions; assessed them for both technical and business suitability; applied technical as well as organizational changes according to the new system.
• Experienced in analysis of complex business problems; prioritizing, translating, organizing and documenting problem to the technical team.
• Expertise in Requirement Analysis, requirement modeling using Unified Modeling Language (UML) and Object-Oriented Analysis.
• Expert in commercial Property and Casualty and Personal Lines Insurance experience wif national carriers.
• Experienced requirement elicitation techniques like interviews, brainstorming, document & interface analysis and organizing sessions wif Subject Matter Experts (focus groups).
• Expert in MS SQL Server suite of products like SSRS, SSAS and SSIS of MS SQL Server 2005 & 2008.
• Senior level SQL query skills (Oracle and TSQL) in analyzing and validating SSIS ETL database data warehouse processes.
• Interacted wif all levels of the project development team like end users, Software Architects, Technical Lead, Database Administrators, and developers.
• Experience Preparing requirements document for Commercial Auto, Inland Marine, Crime, Worker’s Compensation, Umbrella, Business Owners Policy, Commercial Output Policy, and Commercial Property Package.
• Ensured that Product team, Dev team understand the 5 step Refinement of ISO Claim search and facilitated all 5 meetings.
• In-depth noledge of conducting User Acceptance Test (UAT), data quality checks using SQL, gap analysis and Requirement Traceability.
• Proficient in HP ALM Quality Center, IBM Rational Clear Quest and Rational RequisitePro for test designing, requirements mapping, traceability matrix, reports, test execution and defect tracking.
• Working noledge in the Enterprise Data Warehousing (EDW) and ETL (Extract, Transform and Load) of data into a data warehouse/date mart and Business Intelligence (BI) tools like Business Objects Modules (Reporter, Supervisor, Designer, and Web Intelligence) and Qlikview.
• Experienced in creating Data Flow Diagrams, Use Cases, Use Case Diagrams, Activity diagrams, Entity Relationship Diagrams, Data Mapping, Data Integration.
• Experience in Functionality Testing, User Acceptance Testing, Database Testing, Regression testing and Risk Based Testing.
• Experience in assuring the software quality standards.
• Extensive experience in verification, validation (cross-functional testing) and SDLC Process
• Excellent working experience wif SQL Server and SQL CE.
• TEMPEffectively use technology to increase profit, productivity, and competitive edge while simultaneously delivering significant reductions in cost of doing business.
• Analytical, methodical, and process-centric approach towards the problems, identifying the root causes, corrective actions to meet short term as well as long-term business requirements.
• Exceptional interpersonal, communication, organizational and decision-making skills.

TECHNICAL SKILLS:

Operating Systems: Windows, Linux, Pocket PC, Win CE

Servers: Citrix, Windows Server, SQL Server

Databases: SQL Server 2005/08, SQL CE, MS Access, Sybase and Oracle

Application development Tools: Visual Basic, Power Builder, .NET, Crystal Reports

Languages: SQL, C, C++, C# & JAVA

Web tools: HTML, XML, MS Front Page

Reporting Tools: Crystal Reports, Cognos, Business Objects, SSIS/SSRS

Testing Tools: Test Director, Quality Center, Quick Test Pro, Load Runner

Methodologies: RUP, OOAD, UML & Business/Data Modeling

Business Modeling Tools: MS Office, BPMN, UML, DOORS, Rational Rose and MS Visio

Microsoft Office: Word, Excel (including the use of functions), Outlook, PowerPoint, and

Work Experience: -

Sr. Guidewire Business Analyst

Confidential -Lansing, MI

Responsibilities:

• 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 products.
• Worked on various Guidewire integration concepts like Messaging, Batch Processes, Web Services.
• Hands on experience wif Guidewire PolicyCenter and ClaimCenter (Worker's Compensation Claims, General Claims) upgradation.
• Conducted gap analysis and made As-is-to-be diagrams to understand new business requirements and challenges in implementing new modules of BillingCenter and Claim center over the existing billing and claim management systems.
• Requirements for various Vendor Integration points like Enterprise Car Rentals, Bulk Invoices integration for Enterprise/ Quest vendors, AIS Medical Bill Review, ISO, LexisNexis, Lawson General Ledger, ISO Liability Navigator (LNAV).
• Configured screen layouts, business logic, business rules, and operation parameters such as roles, permissions, user attributes, and regions as well as created new screens in Guidewire Studio as needed.
• Exposure to ACORD Property and Casualty Standards and ISO (Insurance Services Office) tools and conventions.
• Responsible for Documentation in each phase of RUP Methodology, Risk Assessment, and Validation & Verification process for capital asset and business owner insurance - commercial lines.
• Designed ETL processes using IBM DataStage to load data from disparate sources into data warehouse using various Database, Development/Debug, File and Processing stages
• Involved in Guidewire Corporate on Guidewire PolicyCenter, Worked on Commercial Lines Property and Casualty Insurance.
• Retrieve suspicious activities through Prime Compliance Suite, Fortent AML, Accuity, World Check, and Lexis Nexis.
• Performed JAD Sessions, walkthrough wif Business, Legacy, Configuration/Interface Developers and ETL Team to provide comprehensive data.
• Validated policy and claim data to assure every detail are populated correctly from the legacy system WINS to Guidewire ClaimCenter.
• Implemented integration wif ClaimCenter to retrieve Policy Period payload and account invoice payloads from Billing Center to send Wifdraw notices and Cancellation notices.
• Accurately performed initial risk analyses by monitoring files to obtain all needed underwriting information.
• Documented Business requirements in Business Requirements document (BRD) for Property & Casualty - Personal and Commercial insurance lines: Workers’ compensation, Homeowners, General Liability.
• Involved in driving the creation of Unified Modeling Language (UML) diagrams such as Activity Diagrams, Use Case Diagrams, Flow charts and Process Flow Diagrams.
• Actively participated in JAD sessions for overcoming project issues relating to data processing, user interface, and downstream system interactions.
• Designed and developed the data load process using XML Style sheets and ACORD.
• Performed complex SQL queries for retrieving data from the database, generating ad-hoc reports, and conducting data validation testing.
• Provided process improvement initiatives to promote efficiency wifin loan processing, underwriting, closing, and meeting Service Level agreements.

Business Analyst

Confidential -Phoenix, AZ

Responsibilities:

• Mainly responsible for working in migration from legacy system to Guidewire system.
• Utilized the guidelines and artifacts of the Rational Unified Process (RUP) to develop a detailed Implementation of Rational Unified Process effort for Guidewire ClaimCenter Integration in different iterations and phases of the Software Development Life Cycle (SDLC).
• Analyzed Business Requirements and created Use Cases, Use Case Diagrams, Navigation Flow, Business Flow Diagrams and Workflow Diagrams for applications, created Activity Diagrams / State Chart Diagrams using MS Visio and created conceptual model, behavior diagrams using SharePoint.
• Worked wif ClaimCenter integration requirement wif Docs and Forms, BillingCenter, Rating, Customer Data Hub, Risk Report, Portfolio management, Policy Service, Analytical systems and Defining rules and requirements.
• Supported and assisted in mapping of Revenue address file/data exchanges to Lexis Nexis and other federally mandated security requirements.
• Implemented ACORD standards to eliminate transfer of paper between medical vendor and the underwriting department.
• Worked wif Led regarding requirement gathering elicitation through open-ended discussions, brainstorming, and prototyping for the development and implementation of a new Guidewire PolicyCenter suite.
• Involved in the automated data collection and updating processes through SSIS packages for gathering data from different sources like SQL server, PostgreSQL, and flat files.
• Mapped legacy data wif PolicyCenter target tables in the required data dictionary and configured PolicyCenter wif tight document/imaging support, new screens, revised assignment logic.
• Created product rules and gathered requirements for the implementation of discounts, rating inputs, and reports for implementing Guidewire PolicyCenter.
• Conducted controlled brainstorming sessions wif project focus groups and documented business requirements wif wireframes and mockups to explain in detail the business implications and impacts.
• Using LEXIS NEXIS Interface to validate the customers Details.
• Created technical impact documents, data mapping documents and defines ACORD mappings for various interfaces based on noledge of business needs and working closely wif senior department managers and key department members wif limited supervision.
• Centralized the policy creation by integrating Guidewire PolicyCenter wif Guidewire Claim Center Systems, Billing System and other existing system supporting operations.
• Performed system analysis on Guidewire Billing Center based on each user story and presented results to SME's.
• Implemented UML, Use Case diagrams by using MS Visio in order to conduct a more TEMPeffective and healthy communication wif stakeholders and clients.
• Involved in interactions wif Subject Matter Expert, Project Manager, Developers, and the end-users in more TEMPthan one JAD sessions. MS Project proved useful in coordinating activities wif project manager and various another team.
• Assisted underwriting, claims, audit, and billing department in developing new or improved product for these LOBs.
• Generated Use case for business process and User Stories for Guidewire PolicyCenter 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.
• Obtained Data requirements, identified data sources, determined the content of data fields and created Data Mapping Documents and performed Data Extraction using SQL queries.
• Worked wif SQL Server Integration Services in extracting data from several source systems and transforming the data and loading it into ODS.
• Analyzed existing reports, redundancy, data flows using ER diagram, SQL, data mart used and design future reports using BO.
• Conducted detailed and comprehensive business analysis using RUP methodology.
• Elicitation sessions included meetings wif Stakeholders and end users in order to identify the new system and its operational requirements.

Business Analyst

Confidential -Purchase, NY

Responsibilities:

• Hands-on experience wif Guidewire PolicyCenter and ClaimCenter (Workers Comp Claims, General Claims) configuration.
• Utilized the guidelines and artifacts of the Rational Unified Process (RUP) to develop a detailed Implementation of Rational Unified Process effort for Guidewire ClaimCenter Integration in different iterations and phases of the Software Development Life Cycle (SDLC).
• Developed business requirements documenting workflow and process, for migration of worker's compensation claims to Guidewire platform.
• Performed GAP analysis on the traditional claims system and newly integrated ClaimCenter and carefully elaborated application enhancement specifications detailing in scope/out of scope items, as-is/to-be process maps and critical test scenarios.
• Migrated SQL Server Data Transformation Services (DTS) packages from SQL Server Enterprise manager to SSIS Packages by using DTS Package Migration Wizard tool.
• Performed Integration testing wif Guidewire Claims System and Guidewire Billing System.
• TEMPEffectively utilized Business Process Modeling techniques and enhanced the existing assembly to adapt to new process that involved GWBC Upgrade.
• 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.
• Established and maintained relationship between requirements for consideration during change management and requirements allocation using Team Foundation Server.
• Performed migration from the in-house legacy-based underwriting, policy center, claims center and billing center applications to Guidewire.
• Actively conducted SCRUM meetings and ensured all Agile project techniques are used in accomplishing the tasks based on the deadlines.
• Worked wif SCRUM Master, Business Owners, Project Sponsor, SME, and Guidewire Consultants to define Product Backlog, Sprint Backlog, estimate efforts for user stories.
• Worked wif the business and developers to test End to End Commercial Lines business processes.
• Involved in designing and developing new and enhanced existing ETL packages using SSIS for batch loads of the enterprise data warehouse, MDM system and related data marts used for retail sales analysis and marketing. Source data included flat files, database queries and XML files.
• Worked in Guidewire Claims Center Web Services, Event Messaging, XML parsing etc.
• Performed Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data wifin the Oracle database.
• Interacted wif business heads to finalize the product backlog for the Guidewire application.

Business Analyst

Confidential -Raleigh, NC

Responsibilities:

• Gathered, analyzed, documented business and technical requirements from both formal and informal sessions and validate the needs of the business stakeholders, thereby drafting the Technical Design Document (TDD) and System Specification Document (SSD).
• Hands on experience wif Guidewire PolicyCenter and ClaimCenter (Workers Comp Claims, General Claims) configuration and implementation.
• Experience in configuration on Guidewire ClaimCenter including working on UI and Business, Data model.
• Worked wif Technical and Business leads during Guidewire PolicyCenter implementation.
• Involved in designing, coding, testing, and implementing integration programs that will integrate Guidewire software.
• Created and configured PCF pages, workflows, entities, type lists, etc using Guidewire Studio.
• Worked on Commercial lines Property and Casualty Insurance including both policy and claim processing.
• Prepared business requirements document and functional specification documents; created Use Cases, Use Case Diagrams, State Diagrams, Activity Diagrams, and Screen mock-ups using Microsoft Visio.
• Carried out defect tracking using Clear Quest, wrote Test Cases and performed User Acceptance Testing
• Wrote SQL Queries in Oracle for data manipulations and created Logical Data Models of the Database
• Manage software system development and integration projects through all phases of Project Life Cycle - analysis, design, development, testing, implement data, and post-production support.
• Interacted wif Guidewire Development team on synchronizing the screens based on customizations.
• Designed and developed Use Cases and Use Case scenarios, Activity Diagrams, Sequence Diagrams, High Level and Low-Level Process Flow Diagrams, OOAD using UML and Business Process Modeling.
• Conducted surveys, interviews, and JRP, JAR and JAD sessions and translated them into system Requirements.
• Responsible for preparing Business Requirement Document (BRD), Functional Requirement Document (FRD) and then translating into functional specifications and test plans.
• Assisted in the development of project definitions, project scope, cost/benefit and risk analysis, work plans, daily and weekly progress reports, and presentations.

Business Analyst

Confidential - Bala Cynwyd, PA

Responsibilities:

• Worked as a Business Analyst to translate customer product requirements into comprehensive, complete, and accurate business requirements and functional specification.
• Conducted functional and technical requirement gathering sessions wif Stakeholders, Underwriting Managers and Operations Analysts for the Policy, Claims.
• Applied Unified Modeling Language (UML) methodologies to design Communication Diagram, Use Case Diagrams, Activity Diagrams, Sequence Diagram and ER diagrams.
• Acted as a liaison between client and internal Developers to design software applications for Commercial Line Insurance such as Workers Compensation, Commercial Property, General Liability and Commercial Auto.
• Responsible for rating multi-line policies. Manual rated Property, Liability, Auto and Workers Compensation policies. Conducted classes for Auto and Workers compensation rating.
• Prepared processes for underwriting systems incidence management and resolution. Also worked on framework to document underwriting resolutions.
• Acted as primary liaison between 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.
• Was responsible for halping to capture business requirements, identifying appropriate data sources, data quality issues, business transformation rules, mapping source to target.
• Worked wif Business Units and Clients to gather requirements for the Insurance product using Confluence.
• Coordinated and tracked project releases and progress using Jira.
• Responsible in managing and maintaining the defect tracking process.
• Involved in the weekly status meeting to discuss the upcoming releases and changes in the hardware requirements and other major issues.
• Worked on JIRA and Confluence for User stories and document management.
• Performed Unit and Integration testing wif the development team as well as User Acceptance Testing and Regression Testing of the application using QTP, Quality Center and Jira.
• Assisted wif user testing of systems (User Acceptance Testing), developing, and maintaining quality procedures, and ensuring that appropriate documentation is in place.