We provide IT Staff Augmentation Services!

Sr. Business Analyst Resume

Dover, NH

SUMMARY

  • A dedicated result driven professional with 8+ years of information technology consulting experience that has extensive Insurance background of Property & Casualty experience which includes Claims, Products and Pricing.
  • Extensive experience in Guidewire Insurance Suite for Personal Lines and Commercial Lines, Workers Compensation, General Liability and Commercial Package
  • Experience in Property and Casualty Insurance including Auto, Home, and Marine Life insurance.
  • Hands - on experience inend-to-endData warehousing process methodologies, which includes developing warehouse SQL scripts, ETL Ab Initio Routines, stress testing, and data quality processes.
  • Experience on Guidewire's UI testing in Policy Center and Billing Center Screens for Personal lines business Defined the page layouts, reports templates and dashboard layouts for reservation monitoring and for gathering usage statistics
  • Insurance experience includes Personal Property Casualty and Commercial Automobile Product knowledge, Reinsurance for Commercial Property Casualty, Group and Life Insurance Systems, Health Insurance, Auto Insurance Home Owner Insurance and Crop Insurance.
  • Hands on experience with Guidewire Policy Center and claim Center (Workers Comp Claims, General Claims) configuration and implementation.
  • Extensive experience in Agent Front End, ClaimCenter andBillingCenter.
  • Expert in commercial Property and Casualty, Commercial Lines and Personal Lines Insurance, Underwriting, Rating and Guidewire experience with national carriers.
  • Experience includes Personal Property &Casualty(P&C) and Commercial Automobile Product knowledge, Reinsurance for Personal Property &Casualty(P&C), surety insurance, Group and Life Insurance Systems.
  • Experience in commercial Property and Casualty, Commercial Lines and Personal Lines Insurance, Underwriting, Rating and Guidewire experience with national carriers.
  • Experience as a Business Analyst with expertise in business process analysis, business process modeling, business requirements, database design, strategic planning, and business analysis in the field of Insurance.
  • Work with Underwriting, Insurance Investigators, clients and General Counsel to understand and resolve all issues within the surety claim process
  • Expert in Object Oriented Analysis and Design, Waterfall, Agile Methodology, Jira, Confluence, JAD Sessions, Live Meetings and Interviews.
  • Extensively worked in the User Acceptance Testing Environment (UAT).
  • Strong experience inData Warehousing, Data Marts, Data Analysis with RDBMS databases.
  • Experienced in complete WATERFALL, AGILE, RUP, SDLC, Client /server architecture providing a well balanced understanding ofbusinessrelationships,businessrequirements, worked for financial and technical solutions and helped the teams at all levels until final product release.
  • Hands on experience using Jira for issue tracking, user stories, and requirements, as well as confluence.
  • Experienced Business/Data Analyst, with expertise in Data Analysis, Business Intelligence Solutions, Data Quality Analysis, Data Profiling, Database development, Data Integration.
  • Experience Work with JIRA filters, reporting, dashboards, workflows, fields, and JIRA administration.
  • Strong Ability to write custom JQL (Jira Query Language).
  • Experience in Summit trade capture systems, Bloomberg, Markit, DTCC, swapswire, Impact bond positioning & settlement system, Intellimatch, intermediate SQL
  • Proficient with Requirement Gathering and Project Management tools like Microsoft Project/Clarity/PlanView, Share Point 2007/2010 and Rational tools Requisite Pro/Clear Quest to manage schedules, deadlines and resources, collaborate with different teams and analyse project/program information.
  • Experience in working on Policy Administration System (PAS) system for P&C onDuckCreekTechnology
  • Proficient knowledge inGXmodels, SQl queries, Batch process analysis, populators.
  • Worked with scrum master on Sprint Planning, Sprint Review, Sprint Retrospective & daily stand up meetings in AGILE environment.
  • Proficient and Experienced in Agile Management and Software Development withExtremeProgramming, Scrum
  • Extensive experience in gathering system requirements, definingbusinessprocesses, UML modeling, sequence diagram and activity diagram.
  • Experience in Re-Insurance claims/Policy, banking applications, Personal Auto Insurance claims,WorkersCompensationInsurance claims, General Liability claims, Property Claims, HR application, telecoms ticketing, standalone and Web applications.
  • Knowledge of policy ratings, investigating claims, negotiating settlements, and authorizing payments
  • Business process analysis and modeling using UML.
  • Worked with Technical Writers to decide manual Guide wire policy ratings for claims and loss controls.
  • Experience in applying Rational Unified Process (RUP) methodology using Modeling and requirement documentation tools such as MS Office, MS VISIO, and MS Project.
  • Conducted JAD Session and communicated with Stakeholders, Development team, SMEs, System Analyst, Business Analystand Project Manager.
  • Involved in integration of Policy Center, Claim Center and Contact Manager.
  • In-depth knowledge of insurance coverage's and applicable statutes affecting claims.
  • Proficient in transforming business requirements into functional specifications, focusing on workflow analysis and design, business process reengineering, user interface design, portal design, and process flow modeling.
  • Excellent analytical skills for understanding the business requirements,business rules,businessprocess and detailed design of the application.
  • Excellent skills in Business Analysis, requirement analysis,Business modeling and Use Case development using UML Methodology.
  • Experienced in manual testing, recreating errors and provide support to programmers to correct defects in the system.
  • Facilitated UAT with the stakeholders and thebusinessusers
  • Created User Requirement Specification (URS), Functional Requirement Specification (FRS), business process flow System, change control & configuration management documents.
  • Facilitated JAD sessions withbusinessowners, IT team & Users to drive out detailedbusiness requirements.
  • Experienced in Systems Testing, Integration Testing, and Software Quality Standards, Training, Documentation and implementation in abusinessenvironment.
  • Knowledge of SQL and experience of writing SQL commands.
  • Extensive process analysis, data analysis and analytics, data mapping and data modeling skills (ERD) to develop solutions to complex application,businessand operational problems, and by performingbusinessprocess re-engineering and process improvements where necessary.
  • Performed data analysis, data and software conversions, and led multiple system implementations.

TECHNICAL SKILLS

Requirements Management Tools: Power Designer, Rational Rose

SDLC Methodologies: RUP, Agile, Waterfall

GuidewireProducts: Policy Center, Claim Center, Billing Center and Contact Manager.

Business Modeling Tools: Smart Draw, MS Visio, Just in Mind Prototype, Snag it

Project Management Tools: MS Office Suite- Expert (Word, Excel, PowerPoint, Project, SharePoint, Access)

Adobe Acrobat Suite: (Illustrator, Dreamweaver CC, Photoshop CC)

Defect Management Tools: Bugzilla, Quality Center, JIRA, SILK Central

RDBMS: Oracle, MS Access, SQL Server 2000

Programming Languages: SQL, UML, XML, HTML

PROFESSIONAL EXPERIENCE

Confidential, Dover, NH

Sr. Business Analyst

Responsibilities:

  • Generating and performing policy coverage research from exposure data coming from Guidewire Policy Center for Property insurance for Policy Hold and Large Risk policies
  • Facilitated and conducted various working and review sessions with client SMEs and spoke to agents while gathering requirements for Gateway portal for Agents
  • Involved in documenting business processes for Homeowners Dwelling Fire- windstorms, hail, vehicles, aircraft, volcanic eruptions, etc, Umbrella and Auto insurance Model year, Make, Loyalty Discount, etc into the Business Requirement Document BRD .
  • Creating user stories and maintaining and tracking them using JIRA.
  • Created and optimized RDBMS objects (tables, materialized views, synonyms, indexes, triggers, procedures, functions) and Discoverer reports. Development of dashboard in Tableau for data visualization to expedite the data analysis process and report automation.
  • Worked extensively on the issue module of Homeowner, Umbrella and Auto insurance by gathering requirements from the business underwriting department.
  • Work closely with production underwriters to review commercial Surety insurance renewal and new business opportunities to ensure proper risk identification, analysis and assessment and the development and growth of a profitable portfolio of business.
  • Created Release Plan document using JIRA Dashboard reports, used Confluence for Release Notes, shared release documents with Product Owner and senior management and updated status at every Iteration on backlog status.
  • Created User Interface Documents (UID) of prototypes and wireframes of the software solution, Guidewire Policycenter, to help designing user interface
  • Managed the daily operations of the Centralized Commercial Insurance and Surety Bond teams with tasks such as renewing policies, invoicing and general customer support.
  • Documented and authored various user stories for agent portal - Quote and Policy Issuance track for several states
  • Created Use Case Diagrams, Activity Diagrams, Sequence Diagrams and ER Diagrams in MS Project
  • Worked on Guidewire Policy Center for Policy creation and maintenance using different Policy Transactions for Auto and Property (including Homeowners).
  • Utilized corporation developed Agile SDLC methodology. Used ScrumWork Pro and Microsoft Office software to perform required job functions.
  • Establish documentation for Agile methodology for implementation with a very water-fall-centric development team.
  • 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 training classes for Auto and Workers compensation rating.
  • Involved in project scope meetings with the Pricing manager to understand the type of requests and issues handled by the pricing team and documented the high level business requirements to the product backlog using JIRA Agile.
  • Worked with REST WEB API's to make calls to the web services using URLs, which would perform GET, PUT, POST and DELETE operations on the server
  • Involved in the Creation of stored procedure, trigger on the database to provide/insert specific data from multiple tables for Web API services.
  • Provided functional and testing support on the various user stories and discussion items on agent portal implementation Policy Center is integrated with this system for credentialing and administering of underwriters and some other admin users.
  • Prepared use cases and user stories, Investigates, processes and manages worker's compensation claims and processed worker's compensation claims, consistently communicating with third party vendor.
  • Analyzed bond claims, investigated validity of claims, and adjudicated surety insurance payments
  • Create and maintain Data model standards, including master Data management (MDM).
  • Performed Integration testing with Guidewire Claims System and Guidewire Billing System.
  • Performed User stories consisting of UI Mockups and Business Rules to capture the functional requirements of the Guidewire Billing Center
  • Worked withDuckCreekUser Interface includingDuckCreekBilling and Policy Administration System.
  • Understanding of ACORD XML business messages for Property & Casualty and Surety.
  • Involved in extracting the Data from various sources like Oracle, SQL, Teradata, and XML.
  • 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 nonfunctional requirements of the system including requirements and processes for life and annuity products.
  • Performed requirements modeling and develop analysis diagrams, activity diagrams, sequence diagrams, state diagrams, data models, and use-case realizations using RUP tools in Agile.
  • Examined automobileinsuranceclaims for both Personal and Commercial policy holders including coverage, liability investigations, and damage evaluations.
  • Conducted gap analysis and made As-is-to-be diagrams to understand newbusinessrequirements and challenges in implementing new modules of Billing Center and Claim center over the existing billing and claim management systems.
  • Rate and Issue complex General Liability, Commercial Automobile, Property and Workers' Compensation policies as directed by Senior Underwriters and UW Manager
  • Created user stories by actively interacting with SME's, Account specialists, Claim Specialists, Billing supervisors, claim adjusters,Guidewirespecialists.
  • Created UML diagrams including Activity and Sequence diagrams.
  • Actively participated in JAD sessions for overcoming project issues relating to data processing, user interface, and downstream system interactions.
  • Gathered business Requirements from all the stakeholders and interacting with the providers, managers, developers to develop the business Processes.
  • Participated and assisted the scum master in conducting daily Scrum meetings and Sprint review meetings to ensure development goals are met within four sprints.
  • Involved in mentoring specific projects in application of the new SDLC based on the Agile Unified Process, especially from the project management, requirements and architecture perspectives.
  • Utilized Agile/ SCRUM and PMI methodologies to monitor, steer and develop project objectives.
  • Executing test cases, test scripts and test plans. Collaborate with SharePoint admin, SQL admin, SharePoint developer and project management teams from the design to the delivery of SharePoint applications and portals.
  • Assisted QA team in developing test strategy, and test cases and actively monitored various types of testing - functional testing, Progression testing, system testing, load testing, smoke testing, and regression testing.
  • Collaborated with the development team in validating requirements for out of box requirements.
  • Involved in managing the defect lifecycle - conducting daily defect tracking meeting, reporting and reviewing the defects, assigning the open defects to developers, and re-testing the fixed defects.
  • Actively facilitated complete UAT process - creating UAT schedules, testing guidelines, managing feedback, follow-up, and resolving open issues.
  • Performed complex SQL queries for retrieving data from the database, generating ad-hoc reports, and conducting data validation testing.
  • Frequently presided over the BA touchpoint meetings and BA team meetings to listen to open concerns, document them and solution them

Environment: Guidewire 10, Policy Center,Java, Performance Plus (P+), Websphere Portal, HP-Extremes,WebMethods 9.0, PlanView, H2, XML, RAD., IBM WAS 7.0., Soap UI, MS Project, Altova XML Spy, SQL, Oracle PL/SQL

Confidential, Bel Air, MD

Business Analyst

Responsibilities:

  • Extensively involved in every phase of the RUP process starting from Inception to Transition
  • Interviewed Business Users to gather Requirements and analyzed the feasibility of their needs by coordinating with the project manager and technical lead.
  • Responsible for testing the Quote & Purchase for both Auto and Home Property Insurance of the customers. created design documentation related to system specifications including user interfaces, security and control, performance requirements and data conversion.
  • Performed data integration and data mapping management along with data cleansing while migrating data from legacy system toGuidewire Policy Center.
  • UsedJIRAtool to story point each story and prioritize story backlog based on Business Goals and objectives during the Sprint Workshop.
  • Involved in analysis and underwriting for Property Casualty Insurance, claims which offers personal lines auto, homeowners.
  • Used Data warehousing for Data Profiling to examine the data available in an existing database.
  • Conduct in-depth Data Profiling and Data Quality Assessment of the data in the Legacy Systems, to determine the current level of data accuracy, conformation to standards etc.
  • Created Projects and Tickets Exception Reports to improve the quality of the data being input in PlanView, which is used for Cognos Reporting.
  • Participated in Creation of various RAML resources to implement REST Based APIs as a part of project implementation.
  • Worked on Guidewire Policycenter for Policy creation and maintenance using different Policy Transactions for Auto and Property (including Homeowners).
  • Worked on RDBMS likeOracle DB2 SQL Server and My SQL database.
  • Involved in Guidewire Corporate on Guidewire Policy Center, Worked on Commercial Lines Property and Casualty Insurance.
  • Analyze surety Insurance forms and document forms requirements
  • Performed Project Management and Scrum Master duties for the JIRA Agile system managing Sprint Releases from start to implementation including promoting team and user communication throughout the process of a project.
  • Discussions with data architects, business stakeholders about the data quality results and have discussions about the data standards, and the kind of business rules to ensure efficient data quality standard in future.
  • Involved in business requirements documenting workflow and process, for migration of worker's compensation claims to Guidewire platform.
  • Captured User stories using guidewire template; few major stories worked on included Commercial Auto, Worker's Compensation, Business Owners Policy and Commercial Property Package.
  • Involved in daily scrums and all scrum activities-Sprint Planning, Sprint Reviews and Sprint Retrospectivesand works as agile coach throughout the project
  • Worked on Underwriting User Stories( Underwriting cancellation, Renewals)
  • Worked on GPA web portal using web services, helped with mapping and process flow diagrams,
  • Researched problem claims for benefit level, third party liability, overpayments, and inappropriate coding
  • Implemented and maintained the MDM (Master Data Management) in the data warehouse.
  • 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.
  • Organize requirements into high level Use Cases and low level Use Case Specifications and modelled them into UC, Activity and Sequence Diagrams using Rational Rose and MS Visio.
  • Used HP Quality Center to store Test Cases and Test Scripts.
  • Evaluated bond needs for customers and negotiated with Surety underwriters
  • Understanding compliance issues involving multi-state insurance agents licensing and adhered to Surety granted lines of authority
  • Performed GAP Analysis by working with the integration teams to identify the 'AS-IS' process and 'TO-BE' process using BPMN for front end systems (agent portal, customer portal, mobile application) and third-party applications (verisk, Cure Logic, ISO, document generation withThunderheadand Experian etc.)
  • Written and executed SQL queries and Joins, Group By clause, having clause etc. to validate the data.
  • Created and tracked defects in JIRA.
  • Responsible for providing internal support and sales on all types of Surety Bonds (permit bonds, contract bonds, bid, performance and payment, license and other miscellaneous bonds)
  • Involved in XML parsing, creatingGXmodels, relevant populators, SQL Queries.
  • Validated reports by executing SQL queries and compared the data using File comparison tool ExamDiff.
  • Created Test Data forQAand UAT.
  • Involved in Smoke Testing, Regression Testing and User Acceptance Testing.
  • Proficient in Duck Creek Session XML and Data Model for Commercial Auto, Commercial Property and General Liability
  • Interacted with users for verifying User Requirements, managing Change Control Process, updating existing Documentation. Created Test cases from scratch by using Business & Functional Requirement Specs, HLD and Wire Frames.
  • 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.
  • Wrote various SQL queries and statements for data reconciliation for Policy Administration System.
  • Collected user requirements through series of JAD sessions and identified functional and non-functional requirements
  • Produced FRD and system changes specifications based on the requirements identified during the JAD sessions
  • Involved inrequirementelicitationand conductingrequirementdiscovery meetings with SMEs, product owners, UX and the technical teams
  • Involved in all phases of Software development life cycle (SDLC) usingAgileScrum methodology.
  • Identify andtroubleshootbusinessdata issues, often collaborating with teams to solve issue.
  • Liaison betweenbusinessusers and project team for requirements management for Commercial, Personal,WorkersCompensation, and Specialty insurance documented "AS-IS" and "TO BE"businessprocess across various line ofbusiness
  • Validated the test data in DB2 tables on Mainframes and on Teradata using SQL queries.
  • Conducted Joint Application Development (JAD) sessions with IT groups. Identified the Key Changes, and participated in Stakeholder Management to communicate effectively with them.
  • Assisted to develop the Test Plan, Test Cases and Test Scenarios to be used in testing based on Business Requirements, technical specifications and/or product knowledge. Conducted User Acceptance Testing, gathered and documented User Manuals and Business Rules

Environment: Java/J2ee,HTML, XML, SQL, Oracle, Performance Plus (P+), Rational Suite (Requisite Pro, Rose, Clear Quest, Clear Case), Excel, Access, PlanView, MS Project, MS-Word, MS-Outlook, MS-Power Point.

Confidential, Schaumburg, IL

Business Analyst

Responsibilities:

  • Gathered high-level requirement for all the external projects in a release.
  • 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.
  • Responsible for investigation, analyzing, and managing all necessary underwrit-ing/accounting/work flow issues, within framework of Surety policies and procedures.
  • Utilized Agile Methodology to configure and develop process, standards and procedures.
  • Performed GAP analysis to compare the existing system with the proposed system and documented new requirements and features.
  • Data quality analysis and Data profiling of the various data sources to determine adherence to standards. Perform data scrubbing, cleansing and standardization to prep data prior to the load.
  • Used JIRA to create and assign User Stories and maintain test cases, requirement backlog.
  • Involved in and worked on the integration of Policy Center with other applications of the Guidewire.
  • Conducted Agile Scrum Meetings to review the day to day progress.
  • Interacted with Guidewire Development team on the synchronizing the screens based on the customizations.
  • Created translation document for requirements between Policy Center and Billing Center systems
  • Worked on Property and Casualty insurance company as an Underwriter.
  • Define the review procedures for disposition of cases and identify the issues with data quality and accuracy and rectify it.
  • Associated with Managing the portfolio forDuckCreekPolicy administration system implementation.
  • AuthoredBusinessRequirement Documents that enhanced base functionality ofDuckCreekP&C Policy Administration System.
  • Documented Business requirements in Business Requirements document (BRD) for Property & Casualty - Personal and Commercial insurance lines: Workers compensation, Homeowners, General Liability.
  • Tested the data converted from legacy (IMS/CASE) application to Guidewire Policy Center and Guidewire Billing Center, validating the conversion, documenting and resolving data conversion issues.
  • Strong understanding of rating in Property and Causality.
  • Worked closely with Billing center, Customer Portfolio, and Forms team to test the integration between these services.
  • Captured User stories using guidewire template few major stories worked on included Commercial Auto, Worker's Compensation, Business Owners Policy and Commercial Property Package.
  • Worked on Client/Servertools likeSQLServerEnterprise Manager and Query Analyzer to AdministerSQLServer.
  • Investigated questionable claim items by corresponding with agents and claimants.
  • Negotiated with teams from projects to decide if modules should be implemented independently, or Parallely
  • Assessment of risks/Monitoring Risks / Claims reviews / Collection/Debt Management
  • Extracted data from Oracle database with MS Access, and performed SQL query, data analysis and verification.
  • Collaborated withScrumteam (developers,businessanalyst, quality assurance, product owner,scrummaster) andbusinessproducts managers to provide solutions that were aligned withbusinesss needs.
  • Worked with ETL Developers and designed mapping documents to extract the data from different data sources like Oracle, Teradata, DB2, Flat files andXML.
  • Used ETL inInformatica, Python and SQLto transform and prepare the data for furtherstatistical analysis.
  • Worked extensivelywith MS Visio, MS Project, MS Office suite,IBM Collaborative Tools Lotus Notes, Web conferencing Net meeting, Office Communicator Ms SharePoint, Quality Center
  • General and professional liability, errors and omissions title protection, surety and fiduciary bonds, other financial bonds nonprofit and church insurance programs
  • Prepared Technical Documentation for code and design changes, completing Policy Center configuration changes and Unit Testing the changes.
  • Conducted functional and technical requirement gathering sessions with Stakeholders, Underwriting Managers and Operations Analysts for the Policy, Claims and Point-of-sale related modules.
  • Involved in integration between Policy Center, Claim Center and Billing Center.
  • Worked on Validation Framework, Validation levels.
  • Conducted in depth testing processes forWorkersCompand Insurance forms issues
  • Worked on Message Transport Plugins, Request and Messaging as part of Policy Center communication with Passport, PARAGON, Allegient, CAM.
  • Responsible for creation of Collaboration Diagrams, Activity Diagram, Project Flow Diagram in MS Visio
  • Worked extensively with MS Excel and MS access
  • Involved inRequirementElicitationand Analysis and preparingBusinessRequirementDocuments, Functional Specification Documents, user stories, use cases, design sheets etc.
  • Analysis of business requirements and system requirements of the client and also for Property and casualty modules
  • Responsible for acting as a liaison with operational and financial management, systems support and sales to identify business opportunities.
  • Involved in generating Test cases for property and casualty Insurances for Different Levels of Business
  • 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.
  • Participated in Commercial Lines Product Underwriting meetings to establish system rating and declaration changes as necessary based on states requirements.
  • 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.
  • Provided data modelling support for numerous strategic application development projects.
  • Reviewed test results and coordinated with testing and development team to correct the issues.
  • Analyze business requirements and segregated them into Use Case Diagrams, Activity Diagrams, Sequence Diagrams, and OOD using Borland Together according to UML methodology thus defining the Data Process Models.

Environment: Rational Enterprise Suite (Rose, Requisite Pro, Clear Case, Clear Quest), XML, Java, Unix, C++, J2EE, JSP, Oracle, DB2, Sybase, MS Office, MS Project, Teradata, Mainframe, PlanView, SQL Server Reports, Win Runner, Load Runner, Quick Test Pro

Confidential, Brentwood, TN

Business Analyst

Responsibilities:

  • Analyzed clients systems and business processes.
  • Provide support across different domain areas such as Auto Assignment, Payments, Claims Data and Appointment Logs, Auto Estimations, Fire Claims etc.
  • Created cross-system data flow diagrams and flowcharts to depict the integration dependency of other applications with Guidewire PolicyCenter
  • Implemented Master Data Management (MDM) for all entities in the project by maintaining a master hub for improving the data quality by following various data governance techniques and data dictionary standards.
  • Performed data analysis, data reconciliation and data retrieval from various systems along with identification of data gaps and data quality.
  • Prepared requirements document for Commercial Auto, Inland Marine, Crime, Worker's Compensation, Umbrella,BusinessOwners Policy, Commercial Output Policy, and Commercial Property Package.
  • Created and maintainedBusinessRequirements document and System Requirements document. In addition, was responsible for getting appropriate sign-offs and approvals
  • Conducted interviews with key business users to collect requirements and generate business process information.
  • Actively conducted SCRUM meetings and ensured all Agile project techniques are used in accomplishing the tasks based on the dead-lines.
  • Participated in review sessions on the GuideWire Data Model and coordinated testing of all data points in Data Model mapped in legacy system.
  • Responsible for elaborating Billing Center integration user stories such as Integration to Agency
  • Worked as a Personal line of Property and Casualty Expert for interface to InsurerBusinessPartner on all facets of system design.
  • Reviewed and analyzed surety and bond claims including performance bonds, motor vehicle dealer, sales tax, license and permit in a high-volume setting.
  • Processed surety bonds for clients.
  • Involved in the development of new line of business - Commercial Auto, property and Umbrella.
  • Worked with Technical and Business leads during Guidewire Policy Center implementation.
  • Analyzed client financial statements for surety bonding capacity and credit.
  • Involved in the implementation of the Guidewire Policy Center for Commercial Lines and bespoke policy admin system.
  • Working knowledge on different data sources as Flat files, Oracle, SQL Server, RDBMS, Teradata and have knowledge in Data extraction, profiling, identifying data quality issues.
  • Worked with Guidewire Claim Center's rich functional depth to end-to-end claims lifecycle management improvements and gathered requirements around Underwriting, Billing, Insurance Claims Processing and Policy Administration System.
  • Identified high level requirements in Inception for Guidewire PolicyCenter and BillingCenter
  • Involved in all phases of Software development life cycle (SDLC) usingAgileScrum methodology. Conducted and participated in sprint planning meeting
  • Implement and maintain Property & Casualty (e.g. bug-fix, data integration, version release) systems of assigned customers.
  • Analyze the business requirements and translating them into technical requirements and preparation ofDataMappingspecifications.
  • Involved in testing the conversion of the application into web application using XML web services
  • Executed requirements, use cases and iterative/incremental project and requirements management to their projects in the context of the SDLC.
  • Created process flowcharts for various issues in Billing Center functionality and help perform gap analysis.
  • Wrote various SQL queries and statements for data reconciliation for Policy Administration System.
  • Created workflow scenarios, designed new process flows and documented theBusinessProcess and variousBusinessScenarios and activities of theBusinessfrom the conceptual to procedural level.
  • Working with clients to better understand their needs and present solutions using structured SCRUM approach.
  • Using Shared Containers and creating reusable components for local and shared use in the ETL process.
  • Established aBusinessAnalysis methodology around the Rational Unified Process.
  • Identified, researched, investigated, analyzed, defined and documented business processes and Use Case Scenarios.
  • 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.
  • Worked extensively with MS Excel and MS access
  • Responsible for process modeling from inception through implementation and post implementation optimization along with associated UI design.
  • Excellent knowledge of Enterprise Portfolio Management systems like Clarity, PlanView and MS Project Server.
  • Managed the daily operations of the Centralized Commercial Insurance and Surety Bond teams with tasks such as renewing policies, invoicing and general customer support.
  • Planned and defined system requirements to Wire Frames with Use Case, Use Case Scenario and Use Case Narrative using the UML (Unified Modeling Language) methodologies.
  • Assisted in on-going process improvement efforts to ensure Test Planning, Execution, and Reporting is effective, efficient, standardized, coordinated, and integrated.
  • Assisted in building aBusinessAnalysis Process Model using Rational Rose and Visio.
  • Worked on National workers compensation guidelines
  • Responsible for developing annual and mid-year operating budgets by underwriting departments and on a consolidated basis for review by reinsurance group senior management.
  • Documented and delivered Functional Specification Document to the project team.
  • Conducted JAD sessions for communicating with Stakeholders and Project directors.

Environment: Windows, MS Visio, MS SharePoint, SQL,Agile,SDLC,.NET.SCRUM,XML,MS-Office Suite, Rational Clear Quest, and UML.

Confidential, Fairfield,OH

Business Analyst

Responsibilities:

  • Documented all system changes and request for user access using Change Management Forms in the SharePoint document library
  • Used the guidelines and artifacts of the Agile Process to strategize the Implementation in different sprints of the Software Development Life Cycle.
  • Assigned tasks among development team monitored and tracked progress of project following agile methodology.
  • Worked on an application that took care of online account services which included Bill paying, checking the bill history, changing customer profile, ordering auto insurance ID cards Worked on Commercial lines Property and Casualty Insurance including both policy and claim processing and reinsurance.
  • Involved in Joint Application Development sessions with SMEs and development teams and documented functional business requirements as product backlogs using JIRA
  • Gathered requirements for the Guidewire Billing & Policy Center Integration Team by coordinating with SMEs from external systems and with the Billing & Policy Center functional and configuration teams.
  • Worked on different modules of Web based application which wasportalfor Agents such as Insurance Application, Declarations, Discounts, ID Cards, and Various Endorsements Form Order Testing etc.
  • Analyzed thebusinessrules for Auto claim assignments throughout the US, so as to have balanced work load for all the claims reps.
  • Worked with business owners to identify key data elements that will be monitored on an on-going basis to ensure a high level of data quality within the Warehouse.
  • Worked on Regulatory Reporting RRD Data Warehouse for compiling Workers Compensation statistical reports to external regulators and states.
  • Responsible for Commercial Insurance Standards rating and risk factors for Auto and Garage commercial insurance.
  • Prepared requirements document for Commercial Auto, Inland Marine, Crime, Worker's Compensation, Umbrella,BusinessOwners Policy, Commercial Output Policy, and Commercial Property Package.
  • Created and maintainedBusinessRequirements document and System Requirements document. In addition, was responsible for getting appropriate sign-offs and approvals
  • Involved in developing front-end production entry screen and batch interfaces between remote AS/400s and the corporate mainframe
  • Responsible for elaborating Billing Center integration user stories such as Integration to Agency
  • Implement and maintain Property & Casualty (e.g. bug-fix, data integration, version release) systems of assigned customers.
  • Worked closely with the Product owners to understand thebusinessrequirements and technical documentation requirement gathering user stories documentation, analysis and closure of requirements related to the Policy life cycle and Claims life cycle processes for P&C Insurance policies/ claims for Personal and Commercial lines inGuidewirePolicy center andGuidewireclaim center applications.
  • Analyze the business requirements and translating them into technical requirements and preparation ofDataMappingspecifications.
  • Worked inGuidewirepolicy center projects both in integration and configuration.
  • Implemented the functionality to renderdatausing XML files and format them usingXSLT.
  • Involved in testing the conversion of the application into web application using XML web services
  • Created process flowcharts for various issues in Billing Center functionality and help perform gap analysis.
  • Wrote various SQL queries and statements for data reconciliation for Policy Administration System.
  • Created workflow scenarios, designed new process flows and documented theBusinessProcess and variousBusinessScenarios and activities of theBusinessfrom the conceptual to procedural level.
  • Working with clients to better understand their needs and present solutions using structured SCRUM approach.
  • Using Shared Containers and creating reusable components for local and shared use in the ETL process.
  • Established aBusinessAnalysis methodology around the Rational Unified Process.
  • 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.
  • Worked extensively with MS Excel and MS access
  • Created deliverables for all aspects of business analysis and functional design for application development,systemintegration, anddatamigration initiatives.
  • FollowedAgile Methodologyand extensively worked with tools like MS Office suiteMS Project,MS Visio,MS Outlook, MS PowerPoint,Snag it,PhotoScape, Skype, Quality Center,Web conferencing Net meeting, Office Communicator, SQL Server.
  • Responsible for process modeling from inception through implementation and post implementation optimization along with associated UI design.
  • Created strategic roadmap utilizing Microsoft Project and Planview Enterprise, consumer data governance end to end business process workflow diagram, business requirements document, project charter and capital request appropriation excel sheet for consumer data governance program.
  • Planned and defined system requirements to Wire Frames with Use Case, Use Case Scenario and Use Case Narrative using the UML (Unified Modeling Language) methodologies.
  • Assisted in on-going process improvement efforts to ensure Test Planning, Execution, and Reporting is effective, efficient, standardized, coordinated, and integrated.
  • Assisted in building aBusinessAnalysis Process Model using Rational Rose and Visio.
  • Worked on National workers compensation guidelines
  • Responsible for developing annual and mid-year operating budgets by underwriting departments and on a consolidated basis for review by reinsurance group senior management.
  • Documented and delivered Functional Specification Document to the project team.
  • Conducted JAD sessions for communicating with Stakeholders and Project directors.

Environment: Java/J2ee,HTML,SCRUM, XML, SQL, Oracle,Agile,Rational Suite (Requisite Pro, Rose, Clear Quest, Clear Case), Excel, Access, MS-Word, MS-Outlook, MS-Power Point.

Hire Now