We provide IT Staff Augmentation Services!

Sr.business Analyst Resume

3.00/5 (Submit Your Rating)

Pekin, IL

PROFESSIONAL SUMMARY:

  • A dedicated result driven professional with 8+ years of information technology consulting experience that TEMPhas extensive Insurance background of Property & Casualty experience which includes Claims, Products and Pricing.
  • Working noledge about policy Underwriting, Binding, Rate making rules and factors effecting it Rewriting and Worker's Compensation.
  • Hands on experience with various modules of DuckCreek Property and Casualty Insurance like Billing, Policy, Claims and Party. Experience with Auto, Fire CAT, Theft, personal and commercial line of business.
  • Expert in Water Fall and Agile/ Scrum methodology. Proficient in MS Project and JIRA for AgileProject
  • Expertise inInsuranceDomain and using policy center product developed byGuidewire.
  • Involved in creating dashboards, reports as needed using Tableau, Power BI, R Studio, SAS and MS Excel.
  • Experience in defining Integration and SIT (System Integration Testing) strategy and approach by acting as a Program Test Lead for Guidewire Claims Center and Guidewire Policy Center implementations.
  • Extensive experience in gathering system requirements, definingbusinessprocesses, UML modeling, sequence diagram and activity diagram.
  • Possess Knowledge and Experience with Personal and Commercial Lines of Insurance, including Auto and Home Insurance.
  • Good understanding of Duckcreek Technology me.e. Example (Express, Forms and Transact), Author Tool (Data/Table/Pages/Forms) and Manuscripts.
  • Produced reports and data analytics using Tableau, SQL, PL/SQL, SSRS, MS Excel, statistical, and reporting tools. Leveraged interconnectivity between multiple tools.
  • Knowledge of policy ratings, investigating claims, negotiating settlements, and authorizing payments
  • Experience inGuidewireconfiguration and integration experience with Claim Center, Policy Center and Billing Center.
  • Experienced in facilitating and conducting Joint Application Design (JAD), Rapid Application Development (RAD), interviews, workshops and requirement elicitation sessions with stakeholders and end - users.
  • Worked with Technical Writers to decide manual Guide wire policy ratings for claims and loss controls.
  • Experienced in complete WATERFALL, AGILE, RUP, SDLC, Client /server architecture providing a well balanced understanding ofbusinessrelationships,businessrequirements, worked for financial and technical solutions and halped teh teams at all levels until final product release.
  • Experience working with User Stories and Design Specifications based on Functional Requirements for Guidewire owned Policy Center Application.
  • 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 customization of UI ofGuidewirePolicy Center, Claim Center and Contact Manager.
  • Involved in integration of Policy Center, Claim Center and Contact Manager.
  • 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 thebusinessrequirements,businessrules,businessprocess and detailed design of teh application.
  • Excellent skills inBusinessAnalysis, requirement analysis,Businessmodeling and Use Case development using UML Methodology.
  • Thorough elaboration of change request story cards for both Guide Wire Policy Center 8.3 and Guide Wire Portal (GPA) on Commercial Auto and Workers Comp LOB's.
  • Facilitated UAT with teh 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.
  • 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.

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, Pekin, IL

Sr.Business Analyst

Responsibilities:

  • In collaboration with a Confidential BA team, developed teh Business Analysis Plan by interacting with Stakeholders, Business Users, and Subject Matter Experts (SME's) to identify business needs, business rules, business process specifications, and project timeline.
  • Using SharePoint access, conducted document analysis before requirement workshop (Onboarding documentation, inception documentation, Implementation documentation, Staffing document).
  • Worked on GPA web portal using web services, halped with mapping and process flow diagrams,
  • Coordinated daily Meetings (Agile methodology), Project Planning, sprint planning, sprint review and sprint retrospective
  • Worked extensively on Integration ofPolicyand BillingCenterSystems for Personal Insurance andPolicycenter's rating engine.
  • Created various use cases related to GPA functionalities for business users (agents) ; new claims, quotes, access to updated business products
  • Analysis of teh business requirements and preparing/understanding business specifications for migration of a Mainframe based insurance application to a new Duckcreek based application.
  • Work with teh core Duckcreek development team to ensure teh business requirements are understood and incorporated into teh software development project.
  • 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 teh existing billing and claim management systems.
  • Created user stories by actively interacting with SME's, Account specialists, Claim Specialists, Billing supervisors, claim adjusters.
  • Involved in gathering requirements for both Personal and Commercial lines Property and Casualty Insurance including both policy and claim processing and reinsurance.
  • Worked with requirements management, workflow analysis, sourcedataanalysis,datamapping, Metadata management,dataquality, testing strategy and maintenance of teh model.
  • Documented both out of box and customized requirements.
  • Worked on reporting and estimates for Property & Casualty (P&C) on Guidewire ClaimCenter implementation.
  • Worked ondatamodellingand produceddatamapping anddatadefinition documentation
  • Used Informatica to extract and transformdatafrom various DB2 database to thedatawarehouse.
  • Responsible forDataExtraction,DataCompilation,DataAnalysis,DataManipulation andDataValidation using SQL queries in a SQL Server Management Studio (SSMS).
  • Created UML diagrams including Activity and Sequence diagrams.
  • Worked with Rating team to gather requirements for Rating Engine (rate books, rating table, rate parameters, versioning, rating routine, rating worksheet, import and export of XML and correcting per specifications.
  • Actively participated in JAD sessions for overcoming project issues relating to data processing, user interface, and downstream system interactions.
  • Worked with end users to gain an understanding of information and coredataconceptsbehind their business.
  • Identify teh coverage changes in thePolicycenterand its impacts on teh comparative rater.
  • Participated and assisted teh scum master in conducting daily Scrum meetings and Sprint review meetings to ensure development goals are met within four sprints.
  • Applying statistical logics on SAS reports and crating dashboards.
  • Loading staging tables on Teradata and further loading target tables on SQL server via DTS transformation Package.
  • Documented Requirement Traceability Matrix (RTM) for requirement elicitation and linkup to deliverables.
  • Provides authoritative advice and counsel to Manager on teh interpretation and application of worker's compensation policies, legislation, regulations, and processes.
  • Prepared teh Business Workflow and processmodellingusing MS-Visio with input, output, conditions.
  • Coordinates and participates in strategic planning aimed at reducing teh incidence of worker's compensation-related injuries onsite.
  • 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.
  • DataModelling: Analyzeddataefficiently and prepareddatafordatavisualization, actionable intelligence and Analytics; improved enterprise productivity. Created design documents in Visio to map thedatabase requirements
  • Collaborated with teh development team in validating requirements for out of box requirements.
  • Involved in managing teh defect lifecycle - conducting daily defect tracking meeting, reporting and reviewing teh defects, assigning teh open defects to developers, and re-testing teh fixed defects.
  • Managed Requirement Traceability Matrix to ensure test cases are traceable to requirement specifications.
  • 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 teh database, generating ad-hoc reports, and conducting data validation testing.
  • Frequently presided over teh BA touchpoint meetings and BA team meetings to listen to open concerns, document them and solution them

Environment: Rational Enterprise Suite (Rose, ClearCase, MS excel, ClearQuest), RUP, MS PowerPoint, Visual Basic, SQL, UNIX, SAS, SQL Server, Duck Creek 6.0, MS Visual Studio.NET2012, SQL server 2008,Oracle, Agile,C#.Net, VBA, MS Project, MS Office, Adobe Photoshop, Windows Forms, Web Forms, LoadRunner, WinRunner, DOORS, Project Management.

Confidential, Honolulu, HI

Business System Analyst

Responsibilities:

  • Gathered user andbusinessrequirements through interviews, surveys and prototyping. Stored and modified requirements in MS Word.
  • Primary responsibility includes writingbusinessrules and creating system requirements by setting up meetings with project managers, architects, developers, testers,business, designers, legal, and other stakeholders. It also includes creating and updating user stories.
  • Discuss out of teh box (OOTB) features withbusinessand development team. Proposed and implemented minimal changes to save development time and satisfybusinessneeds.
  • Worked on coverages and exposures pertaining to dwelling, personal property, other structures, loss of use, content, etc. relating to Homeowners Policy.
  • Discussed incident story cards for Homeowners policy like personal property incident, dwelling incident and liability incident. payments, commissions, trouble tickets, payment plans and billing plans.
  • Having served onbusinessas well as technology teams, gives me an added advantage of understanding both sides and makes me an excellent liaison.
  • Created translation document for requirements between Policy Center and Billing Center systems
  • Worked on Property and Casualty insurance company as an Underwriter.
  • Strong understanding of rating in Property and Causality.
  • Discuss and document any system related issues and resolved any open issues by conducting meetings regularly. Responsibility also included working on change requests.
  • Proactively identify inefficiencies in system and proposed changes to increase system accuracy and cost effectiveness.
  • Utilized Microsoft SQL 2005 and associated business intelligence tools (SSIS, SSAS, SSRS) to provide focused transaction and task monitoring and error handling on an enterprise level.
  • Validated web services manually and through automation using SOAP UI (XML)
  • Wrote test cases and test scripts for teh User Acceptance testing (UAT) and supported unit, integration and regression testing.
  • PerformedDatamapping, logicaldatamodeling, created class diagrams and ER diagrams and usedSQLqueries to filterdata.
  • Conducted JAD sessions with management, SME, vendors, users and other stakeholders for open and pending issues.
  • Conducted Change Analysis for teh improvement of teh existing system and recommended teh required changes using Rational Clear Case.
  • Worked in an agile environment in teh billing center team to gather business and system requirements. Elicited requirements from subject matter experts from billing, commercial lines, policy, customer care and legal.
  • Created and submitted SQL queries to extract Loan information from teh Teradata database
  • Created and provided Excel reports from SQL query results forbusinessusers to utilize for analyzing data integrity issues,accountingissues, and general inquiries
  • Conducted Gap Analysis, and Gathered User Requirements by Interviews, user meeting, JAD session, and Requirement Elicitation Sessions.
  • Created DTS Packages for migration of data between MS SQL Server database and other databases like MS Access and MS Excel.
  • Analyzed and prioritized user andbusinessrequirements as system requirements that must be included while developing teh software.
  • Work on Conversion polices from Mainframe to Duckcreek.
  • Planned and defined system requirements to Use Case, Use Case Scenario and Use Case Narrative using Rational Rose.
  • Scheduled meetings with developers, systemanalystand testers to collaborate resource allocation and project completion using MS Project.
  • Involved in teh entire project life cycle (SDLC) from evaluation, installation, configuration and development of end user reports.
  • Defined data requirements and elements used in XML transactions.
  • Gathered and analyzed thebusinessreporting requirements with teh existing Data source and suggested teh changes in teh data source.
  • Created teh universes based on teh user classes and their hierarchy in teh organization at different aggregations.
  • Specified teh standards for universes, Classes, Aliases, Help text, Simple and complex objects.
  • In Info View, implemented customized logins at application level and provided password reset options to teh users.
  • Created user groups and managed access privileges usingBusinessObjects Supervisor.
  • MaintainedBusinessObjects universes.
  • Created teh Test cases and SQL scripts to verify teh results and performed bug tracking using Clear Quest.

Environment: Agile, Power designer, Smart Draw, Microsoft Visio, XML,UML, JIRA, Oracle DB, Java, HTML, SQL.

Confidential, Brentwood, TN

Business System Analyst

Responsibilities:

  • Worked with product SMEs to define product specifications in order to define Line ofBusiness within Policy Center
  • Defined customization product rules including coverable items, coverage, coverage terms, deductibles, and limits within Policy Center system
  • Organized various group organizations in PolicyCenter, as indicated by teh producer tree and defined requirement for integration them with BillingCenter
  • Worked with cross-functional ClaimCenter team to be sure that LOB is in sync with Policy Center as configuration continues
  • Discussed with teh Business groups to understand requirements. Translate requirements to agile stories
  • Worked in a fast paced atmosphere SCRUM and studied business processes, legacy application, and teh correspondingGuidewirefunctionality and conducted requirements sessions.
  • Underwrite workers compensation applications, Set appointments, meet monthly sales goals
  • Extensive hands on XML import/export, deployment groups, query generation, migration using Informatica repository manager.
  • Definedbusinessrules for account and agent set-up within PC and integration requirements for downstream applications including BillingCenter
  • Write business and functional requirements for enhancements to teh customer portal and quoting software
  • Createdbusinessrequirements for PolicyCenter to has a producer management system to track detailed information about producers.
  • Worked on UAT testing and took signoff from teh Commercial line of Property & Casualty business users.
  • Involved in designing a new replacement requirements template which could be used across all lines of businesses to maintain consistency
  • Worked in mainframe environment and used SQL to query various reporting databases.
  • Assisted in building aBusinessAnalysis Process Model using Rational Rose and Visio.
  • Performed extensive Requirement analysis and developed use cases and workflows.
  • Performed Requirements Elicitation by conducting interviews, surveys, workshops and created BRD and FRD
  • Define and implement security profiles and procedures and maintain teh integrity of theDuckCreek Suites(Policy, Rating, Claims and Billing)
  • Created DTS Packages for migration of data between MS SQL Server database and other databases like MS Access, MS Excel, andFlat Files.
  • Interacted with Product Specialists and Product Analysts to identify teh changes in teh existing system and additional features required in new system
  • Performed Data mapping, Data analysing,logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data.
  • Developed Use Cases, Activity Diagrams, Sequence Diagrams, etc.
  • Played a key role in teh planning, User Accepted testing (UAT), and Implementation of system enhancements and conversions.
  • Analyzed system performance and initiated process improvement measures for mainframe and Web-based applications.
  • Actively involved in Defect Management Process and actively involved in Bug Review meetings.
  • Experience in writing test plans, defining test cases, developing and maintaining test scripts.
  • Actively Involved in Manual Testing Regression Testing of teh Application and writing defects in QC
  • Strong experience in conducting System Testing & User Acceptance Testing (UAT) and documentation of test cases.

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

Confidential, Harrisburg, PA

Business Analyst

Responsibilities:

  • Analyzed clients systems andbusinessprocesses.
  • Provide support across different domain areas such as Auto Assignment, Payments, Claims Data and Appointment Logs, Auto Estimations, Fire Claims etc.
  • 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 teh US, so as to has balanced work load for all teh claims reps.
  • Interacting with teh clients for requirement gathering and business related clarifications.
  • InvolvingGuidewireawareness meetings with E&Y team to understand thePolicyCenterstructure
  • Involving functional analysis ofPolicyCenterDataMapping between Rating engine andPolicyCenterscreens
  • Requirements elicitation and gathering for teh migration from teh legacy tool to new version
  • 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 teh corporate mainframe
  • 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.
  • Implement and maintain Property & Casualty (e.g. bug-fix, data integration, version release) systems of assigned customers.
  • Analyze teh business requirements and translating them into technical requirements and preparation ofDataMappingspecifications.
  • Involved in testing teh conversion of teh application into web application using XML web services
  • Utilized corporation developed Agile SDLC methodology. Used ScrumWork Pro and Microsoft Office software to perform required job functions.
  • Conducted demo/conference pilot sessions to present both custom and Out of teh box Billing Center functionality to business.
  • Created process flowcharts for various issues in Billing Center functionality and halp perform gap analysis.
  • Extensively involved in Writing Test cases and Test scripts to perform Manual Testing of teh new billing system withDuckCreekSoftware.
  • 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 teh 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 teh ETL process.
  • Established aBusinessAnalysis methodology around teh Rational Unified Process.
  • Created UAT plans with several test cases for each project to ensure that teh system runs smoothly after teh proposed enhancements or changes has 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.
  • Planned and defined system requirements to Wire Frames with Use Case, Use Case Scenario and Use Case Narrative using teh 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.
  • Performed extensive Requirement analysis and developed use cases and workflows.
  • Developed Use Cases, Activity Diagrams, Sequence Diagrams, and OOD
  • 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 teh project team.
  • Conducted JAD sessions for communicating with Stakeholders and Project directors.
  • Developedbusinessrequirement specification documents as well as high-level project plan.

Environment: GuidewireClaimCenter, ContactCenter, Claims Systems, Mail Merge, RUP, AGILE/Scrum, Mainframes, COBOL, JCL, Db2,Windows, MS Visio, MS SharePoint, MS-Office Suite, Rational Clear Quest, and UML.

Confidential, Ewing, NJ

Business Analyst

Responsibilities:

  • Functioned as teh liaison between teh business line, operations, and teh technical areas throughout teh project life cycle.
  • Interfaced with teh client as part of requirements gathering and elicitation to finalize teh project scope.
  • Conducted JRP sessions with SME and manager to understand business processes, functionality detail.
  • Developed business process models in Scrum environment.
  • Worked to ensure high levels of data consistency between diverse source systems including flat files, XML and SQL Database.
  • Performed Functionality testing, Integration testing, System and UAT. Documented and logged teh results and defects.
  • Worked closely with teh SMEs in teh development and management of requirements through elicitation sessions, analysis and requirement specifications and support teh development life cycle.
  • Designed and documented Business Requirement Documents, Functional Specifications and Technical maps for Asset Management stream.
  • Closely interacted with business leaders, subject matter experts (SMEs), software developers and designers, to understand application functionality and navigational flow and keep them updated about Business users' requirements through JAD sessions.
  • Worked with workers compensation insurance carriers to establish Data Acquisition and Data receipt timelines to ensure meeting submission guidelines.
  • Implemented and followed a ScrumAgiledevelopment methodology within teh cross functional team and acted as a liaison between teh business user group and teh technical team
  • Analysis of thedataidentifying source ofdataanddatamappings of BHC.
  • Worked extensively in documenting teh Source to Target Mapping documents withdatatransformation logic.
  • Extended Documental In corporation of teh underwriting policy (Property and Causality) changes to teh QA team while checked conversion changes and their rate of success.
  • Developed and designed Use Cases and Use Case diagrams, business flow diagrams, Activity/ Workflow diagram, Collaboration diagrams and Sequence diagrams using Rational Rose.
  • Reviewed and provided feedback on APIs written in XML and JSON.
  • Worked on Plan reporting. Prepared and presented system requirement specification (SRS) and functional requirement document (FRD)
  • Helped to create and translate user stories to define teh functions teh system must provide, and to facilitate requirements management.
  • Assisted scrum master to facilitate teh scrum and halped to act as a buffer between development team and non-development distractions.
  • Assisted to conduct daily scrum to summarize what TEMPhas been done, plan what needs to be done, and recognize impediments.
  • Helped to create burn down charts to show remaining work in teh sprint backlog.
  • Identified "As is" process and "To be" process as parts of gap analysis for new functionality requirements, as well as prioritizing them based on actual business needs so as to align them with teh project roadmap.
  • Created Unified Modeling Language (UML) diagrams for Business Process Modeling like Activity Diagrams, Sequence Diagrams, Data Flow Diagrams, and Flow Charts.
  • Created Mock-up forms in Just in Mind for better visualization and understanding of teh GUI
  • Assisted teh Project Manager to develop both high-level and detailed application architecture to meet user requests and business needs.

Environment: Agile-Scrum, Microsoft Office Suite, Microsoft Visio, UML, Windows XP, SQL Server, Power Designer, Microsoft Project.

We'd love your feedback!