Business Systems Analyst Resume
NY
PROFESSIONAL SUMMARY:
- 6+ years of experience as a Business Analyst with solid understanding of Business Requirement gathering, Business Process flow, Business Process Modelling, Data Analysis, Data Mapping and Business Analysis.
- Insurance experience includes Personal Property Casualty and Commercial Automobile Product knowledge, Reinsurance for Commercial Property Casualty, Group and Life Insurance Systems
- Extensive experience in conducting Market Research, Feasibility Studies, Data Analyses, Data Mapping Gap Analyses, Risk Identification, Risk Assessment, Risks Analyses, and Risk management
- Expert in commercial Property and Casualty and Personal Lines Insurance experience with national carriers.
- Proficiency with Rational Enterprise Suite (Requisite Pro, Rational Rose, Clear Case, Clear Quest) in support of the RUP methodology.
- Experience in facilitating Joint Requirement Planning (JRP) sessions with Business User Groups, conducting Joint Application Development (JAD) sessions with IT Groups and Conflict Management with Project team members.
- Extensive experience with data modelling 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, pensions and CMS.
- In depth knowledge Rational Unified Process (RUP) methodology, Use Cases, Software Development Life Cycle (SDLC) processes, Object Oriented Analysis and Design (OOA/
- Extensive experience in Testing, Manual and Automated using tools Win Runner, Load Runner, Quick Test Pro, TestDirector, Rational Robot or Web and Client/Server Applications & Mainframes
- Extensive experience in developing Use Cases, creating Screen Mock - ups, conducting Gap Analysis and Impact Analysis, SWOT analysis, Cost Benefit Analysis, Risk Analysis.
- Worked on the Guidewire Policy Center 8.0, Billing Center 7.0, Claims Center 8.x/7.x
- 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
- Worked on Worked on documentation of the following Screens in Billing Center:
- Testing the following in Billing Center:
- Defined Billing Center Users, Authorities etc.
- 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 claim Center and carefully elaborated application enhancement specifications detailing in
- Performed Integration testing with Guidewire Claims System and Guidewire Billing System.
- Extensive understanding & experience of migrating insurance suite solutions to Guidewire solutions
- Experience working on Guidewire Claim Center, Policy Center and Billing Center
- Developed Strategies, Manuals, Process flows and Job aides on Guidewire projects
- Analyze the feasibility of and develop requirements for enhancements and defects related to the current Guidewire claims system
- Worked on the Guidewire Policy Center 8.0, Billing Center 7.0, Claims Center 8.x/7.x
- Interacted with business heads to finalize the product backlog for the Guidewire application.
- 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
- Utilize the guidelines and artifacts of the Agile Methodology to develop a detailed implementation process Guidewire ClaimCenter Integration during different iterations and phases in Software Development Life Cycle (SDLC).
- Responsible to Track, Document, Capture, Manage and Communicate the Requirements using Requirement Traceability Matrix (RTM) which helped in controlling numerous artefacts 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, MS Project, MS Visio, MS Office Suite, Bloomberg, VBA for Excel, SQL, PL/SQL, Java, J2EE, C#, VB.NET, C++/CLI, Adobe Acrobat, PhotoShop, AutoCAD, 3D MAX
Databases: Oracle 8i/9i, MS SQL Server, MS Access
Environment: s: Windows 9x/NT/2000/XP, UNIX (Sun Solaris, AIX, HP-UX), Linux, Mainframe
PROFESSIONAL EXPERIENCE:
Confidential, NY
Business Systems Analyst
Responsibilities:
- Analyzed clients systems and business processes.
- Provide support across different domain areas such as Auto Assignment, Payments, Claims Documentation, and Appointment Logs, Auto Estimations, Fire Claims etc.
- Performed mapping of fields in Life Insurance application to New Business Submission Transaction (tc = 103) in the ACORD data model.
- Experience in commercial Property and Casualty, Commercial Lines and Personal Lines Insurance, Underwriting, Rating and Guidewire experience with national carriers.
- Knowledge of Guidewire integration framework and various integration methods like Web service APIs, Plugins, Messaging code, Guidewire XML models, templates etc.
- Strong working knowledge in Guidewire Policy Center product & Billing Center.
- Extensive knowledge in Guidewire Insurance Suite for Personal Lines and Commercial Lines, Workers Compensation, General Liability and Commercial Package
- Working as a Guidewire Business Analyst for implementation of Guidewire Claim Center and Policy Center for Personal Lines Auto, Home and Umbrella/Liability Plus lines of Business.
- Analysis and documentation of the business requirements for Policy conversion to Guidewire Policy Center at the time of renewal.
- Prepared Source to Target mapping documents in Excel. Understanding of WSDL, XML, and XSD for creating the mapping documents for 'Guidewire-ESB layer-Vendor' and vice versa.
- Worked in Simplified Accounts opening project that used E-forms that the Financial advisors use to open Brokerage, Annuity, Insurance and other securities accounts automatically and then submit them electronically
- Analysed the business rules for Auto claim assignments throughout the US, so as to have balanced work load for all the claims reps.
- Managed the output requirement project for various Life insurance products.
- Met the Business development group and gathered the requirements for the developing Automatic Assignment of claims Involved in Logical & Physical Data Modelling. Database Schema design and modification of Triggers, Scripts, Stored Procedures in Sybase Database Servers.
- Established a Business Analysis methodology around the Rational Unified Process.
- Represented the business requirements in various alternative views such as analysis models, process flow diagrams and user stories.
- Streamlined clerical work processes and mapped then into the new system.
- Developed project plans and managed project scope.
- Worked extensively with MS Excel and MS access
- Developed QA Test Plan, test conditions and test cases, as well as assisted with QA team in System Testing using Mercury Test Director
- Responsible for designing, executing and recording results for manual test cases in SAT (System Acceptance Testing) & UAT (User Acceptance Testing)
- Manage Content Entry phases of projects including content loading and UAT scheduling
- 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.
- Reviewed Integration/SAT test results with the clients
- Assisted in building a Business Analysis Process Model using Rational Rose and Visio.
- Conducted UAT (User Acceptance Testing) to make sure that all the user requirements are catered by the application.
- Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, and OOD
- Analysed standard industry practices of back office applications of Insurance Company, underwriting, billing, policy and claims administration with the help of Subject Matter Expert.
- Participated in creating custom site templates and list templates for developing web part pages for the portal using SharePoint Portal Server 2003.
- Used Test Director and Mercury Quality Center for updating the status of all the Test Cases & Test Scripts that are executed during testing process.
- Working as Business Analyst on implementation of Guidewire claim Center for Auto, Property, General Liability and Workers Compensation lines of Business
- Working closely with Business, Product Management and development engineers to understand Guidewire claim Center features, performing Gap analysis to identify features, gathering and analyzing business requiremen.
- Conducted JAD sessions for communicating with Stakeholders and Project directors.
- Developed business requirement specification documents as well as high-level project plan.
Environment: Mainframes, COBOL, JCL, Db2, Quality Center, Oracle, Rose, MS Word, MS PowerPoint, MS Excel, MS Visio, LoadRunner, WinRunner
Confidential, Harrisburg, PA
Business/ Data Analyst
Responsibilities:
- Analyzed clients systems and business processes.
- Responsible for the Definition of Base Product for 2009 releases for multistate One Shield implementation
- Involved in the creation for Manual Ratters for One Shield Personal Lines homeowners product
- Analysed the business rules for Auto claim assignments throughout the US, so as to have balanced work load for all the claims reps.
- Examined, analyzed and model Test plans, Use Case Model cases & Test procedures based on RUP methodology.
- Developed Web Intelligence reports for Sales and Sub-Sales reports for Daily, Weekly, MTD and YTD
- Experience in preparing different documents like the User Requirement List/document (URL/URD), Business Requirement List/document (BRL/BRD), Wire Frames to illustrate the functionalities, Test Case Scenarios & Test Plan documents, Requirements Traceability Matrices (RTM), Use Cases, Issue Logs and other documents as needed.
- Modified and executed test cases based on SR's (Special Request) and PCR’s (project change request) using Quality Center.
- Proficient as long time liaison between business and technology with competence in Full Life Cycle of System (SLC) development with Waterfall, Agile, RUP methodology, IT Auditing and SOX Concepts as well as broad cross-functional experiences leveraging multiple frameworks.
- Strong understanding of the administration of group Life and/or group Annuity products
- Several years of experience with group life and annuity products is a must have
- Proven experience with Life and Annuity Administrative systems, Vantage/wmA preferred
- Proven experience with Life and Annuity Insurance framework surrounded applications; customer service, claims, call center, accounting, etc.
- Proven experience with life and annuity administrative systems: wmA and Vantage preferred
- Proven experience with life and annuity web/self-service platforms
- Proven experience with life and annuities forms repositories and correspondence applications, including system generated and processor/ad hoc generated
- Senior-level professional with a successful history in financial management across life insurance, finance, and annuity industries in both institutional and retail settings.
- Develop and maintain strategic relationships with MLR sales force and account executives to assist with acquisition of new plans and retention of existing plans. Plan and approve pricing on new and existing stable value, general account, variable annuity, and mutual fund.
- Developed front-end production entry screen and batch interfaces between remote AS/400s and the corporate mainframe
- Worked as a Personal line of Property and Casualty Expert for interface to Insurer Business Partner on all facets of system design.
- Collected & documented the requirement of Business Teams from Annuities, ASPF, Policy & Program Evaluation Team, and Project Sponsors & Actuaries.
- Utilized corporation developed Agile SDLC methodology. Used ScrumWork Pro and Microsoft Office software to perform required job functions.
- 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 insurance
- Analyze, review and consult on Worker's Compensation Cases, bodily injury and other commerce of the most serious and complex nature requiring investigation, liability evaluation, commercial property damage evaluation, and negotiation.
- The application would let customers submit online claims for Worker's Compensation Property and Casualty and the Non-worker's Compensation.
- Analysis of business requirements and system requirements of the client and also for Property and casualty modules
- Developed a file of ACORD Forms used as the standards in all Property and Casualty markets, for both Personal and Commercial Lines of Business.
- Analysis of business requirements and system requirements of the client and for Property and casualty modules
- Provided daily technical assistance by responding to inquiries regarding errors and problems while booking policies and claims in Wheatley insurance system for commercial auto, general liability, worker compensation, and commercial package.
- Technically competent in Workers Compensation Case Management including complex claims, disputes, Regulatory matters, common law and litigated claims
- Working with clients to better understand their needs and present solutions using structured SCRUM approach.
- Analyzed and translated systems requirements into system specifications utilizing UML and RUP methodology
- Using Shared Containers and creating reusable components for local and shared use in the ETL process.
- Established a Business Analysis 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.
- Involved with the technical team in understanding the XML file format required for Split loss process and Billing process.
- 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.
- Implemented integration with ClaimCenter to retrieve Policy Period payload and account invoice payloads from Billing Center to send Withdraw notices and Cancellation notices.
- Centralized the policy creation by integrating Guidewire PolicyCenter with Guidewire Claim Center Systems, Billing System and other existing system supporting operations.
- Performed system analysis on Guidewire Billing Center 8.0.3 based on each user story and presented results to SME's.
- Assisted underwriting, claims, audit and billing department in developing new or improved product for these LOBs
- Performed Integration testing with Guidewire Claims System and Guidewire Billing System.
- 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.
- Create Oracle Business Intelligence Reports\dashboards to be used by the NetApp Sales Team.
- Assisted in on-going process improvement efforts to ensure Test Planning, Execution, and Reporting is effective, efficient, standardized, coordinated, and integrated.
- Assisted in building a Business Analysis Process Model using Rational Rose and Visio.
- Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, and OOD
- Conducted and Managed JAD sessions with SMEs and Business departments, for planning and Requirements Gathering.
- Documented and delivered Functional Specification Document to the project team.
- Conducted JAD sessions for communicating with Stakeholders and Project directors.
- Developed business requirement specification documents as well as high-level project plan.
Environment: Mainframes, COBOL, JCL, Db2, Oracle, Java, J2EE, Rose, MS Word, SOX, MS PowerPoint, MS Excel, MS Visio, LoadRunner, WinRunner
Confidential, Kansas City, MO
Business Analyst/Data Analyst
Responsibilities:
- Gathered high-level requirement for all the external projects in a release.
- Analyzed the existing as-is system for Insurance Personal Lines, tracked defects, provided recommendations to make enhancements in the future to-be system.
- Created functional requirement documents for the impacting projects
- Updated the impacted MS Access tables.
- Conducted interviews with Process Owners, Administrators and Functional Heads to gather audit-related information and facilitated meetings to explain the impacts and effects of SOX compliance
- Established a Business Analysis methodology around the RUP (Rational Unified Process)
- Worked extensively with MS Excel and MS access
- Extensive experience with data modelling and defining the conceptual and logical model of the data warehouse.
- Involved in defining the source to target data mappings, business rules and data definitions.
- Responsible for defining the key identifiers for each mapping/interface.
- Document all data mapping and transformation processes in the Functional Design documents based on the business requirements
- Created data trace map and data quality mapping documents.
- Extensively designed Data mapping and filtering, consolidation, cleansing, Integration, ETL, and customization of data mart.
- Document various Data Quality mapping document.
- Performed data mapping from source to target.
- Conducted a comprehensive use case analysis to determine key abstractions such as loan underwriting, loan-closed, borrowers-info, mortgage-payments etc, and their mapping for standard analysis.
- Create various Data Mapping Repository documents as part of Metadata services (EMR).
- Responsible for acting as a liaison with operational and financial management, systems support and sales to identify business opportunities.
- Insurance experience includes Personal Property Casualty and Commercial Automobile Product knowledge, Reinsurance for Commercial Property Casualty, Group and Life Insurance Systems.
- Expert in commercial Property and Casualty and Personal Lines Insurance experience with national carriers.
- Expert in the Property, Casualty, Annuities, Disability, and Supplemental Insurance policies include administration, sales, customization, claims, pensions, and CMS.
- Worked on UAT testing and took sign-off from the Commercial line of Property & Casualty business users.
- Responsible for the development of a Data Warehouse for personal lines property and casualty insurance.
- Prepared requirements document for Commercial Auto, Inland Marine, Crime, Worker's Compensation, Umbrella, Business Owners Policy, Commercial Output Policy, and Commercial Property Package.
- Worked on Commercial lines Property and Casualty Insurance including both policy and claim processing and reinsurance.
- Experience with commercial multifamily property and general liability insurance.
- The application would let customers submit online claims for Worker's Compensation Property and Casualty and the Non-worker's Compensation.
- Experience in report, manage, and process routine general product liability, premises liability, marine/cargo, and property claims.
- Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, OOD using UML
- 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.
- Document and submit Project Change Request (PCR), which explains the reason, description, requested party, risks and impacts of the project’s scope change and identify possible workaround.
- Astute knowledge about the policy rules and proficient at creating innovative policy plans to attract customers. Strategic thinker with excellent problem-solving abilities and ability to possess healthy relationships with clients.
- Reviewing client's case for redemption of policy amount for accidental cases, and implementing appropriate rules for the same
- Providing and mentorship to junior analysts by supervising their tasks to convert new customers for taking company's vehicle insurance policy
- Maintained updated database of clients, informed monthly, quarterly, half-yearly, or annual premium, and avoided policy lapse
- Coordinated with the team to understand business needs and processes from end users' perspective and proposed policy changes for non-gear vehicles
- Worked as a liaison between the insurance agents and policy holders to ensure availability, and effectiveness of the services provided
- Performed periodic analysis, supported the team for policy ratings, and implementation of issuance system to maintain proper work-flow
- Provided analysis on clients' needs, newly initiated policy specifications, and detailed logic flows for implementation increasing company revenue by 43%.
- Developed timelines for project delivery, and managed projects/resources
- Used MS Visio for Process modelling, Process mapping and Business Process flow diagrams.
- Responsibility included modifications to a customer’s mainframe system to support new product features or regulatory requirements and, in some cases, involved a system upgrade
- Ensured verification and sign-off of business requirements by various stakeholders/investors under SOX Compliance.
- Experienced in conducting GAP Analysis, System Integration Testing (SIT), and User Acceptance Testing (UAT). Proficient in developing test scenario and test cases and verifying test results.
- Used MS Visio for Process modelling and Business Process flow diagrams.
- Used MS Project to manage schedules, deadlines and resources and collaborate on the project.
- Interacting with the developers on resolving the reported bugs and various technical issues.
- Assisted the QA team in designing the Test Plan and Test Cases for User Acceptance testing.
Environment: Microsoft Office Suite, Microsoft Visio, Unix, Documentum, SOX, Windows NT/XP, Oracle, SQL, SQL Server, Sybase, VBScript, C#, DOORS, C++, NET, ASP.NET, Mainframes, COBOL, JCL, Db2, Oracle, Java, J2EE. Business Objects, Test Director, LoadRunner
Confidential, Columbus, OH
Business Analyst
Responsibilities:
- Managed the output requirement project for various Life insurance products.
- Played key role in System Development Life Cycle Process consisting of: Design and Gap Analysis, Business Requirements, Systems Requirements, Test Criteria, and Implementation to have the outputs of project dealt with the automation of correspondence directed to Insurance policy owners.
- Conducted JAD sessions for communicating with Stakeholders and Project directors
- Involved in generating Test cases for property and casualty Insurances for Different Levels of Business.
- Performed Business Process Mapping and performed AS IS and TO BE analysis.
- Worked on Commercial Lines Property and Casualty Insurance including both policy and claim processing and reinsurance.
- Developed a file of ACORD Forms used as the standards in all Property and Casualty markets, for both Personal and Commercial Lines of Business.
- Worked on UAT testing and took sign-off from the Commercial line of Property & Casualty business users.
- 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.
- Worked on UAT testing and took signoff from the Commercial line of Property & Casualty business users. Extensive involved in analysis of data elements from worker's compensation that includes various premium components and its calculations, loss amounts & claim counts.
- Writing new COBOL, DB2 programs to handle Claim center messages (from front end via XML) processed in the Mainframe from the front end system called Claim Centre (CC) using GUIDEWIRE working with SQL SERVER Data.
- Provided data workflow, including legacy system profiling, mapping of data, documentation of business rule validations, and reconciliation of historical claims data for an enterprise integration of Guidewire Claim Center.
- Experience in commercial Property and Casualty, Commercial Lines and Personal Lines Insurance, Underwriting, Rating and Guidewire experience with national carriers.
- Applications tested were integrated to mainframe Vantage system which included business applications for new sales, policies, quotes, and web based applications.
- Correspondence included solicitation letters, financial transaction confirmations, and quarterly and annual policy statements.
- Used Unified Modelling Language (UML) for process modelling and use cases.
- Coordinated participation and sign-off of various business partners and customers.
- Interfaced between Business new product builders and System platform builders.
- Worked with systems area to translate business needs into system requirements.
- As a functional consultant, implemented Guidewire Policy Center through an Agile Scrum development model
- Incorporated Agile (Scrum) methodology to create BRD, FSDs using MS Visio and MS Word.
- Assigned tasks among development team, monitored and tracked progress of project following Agile methodology
- Worked under Agile/Scrum methodology with Sprint based goals.
- Gathered and prioritized requirements based on agile principles.
- Used Agile to configure and develop process, standards and procedures.
- Worked in accordance with the Agile-Scrum methodology for various phases of the business and created business vision, business architecture documents and mock reports.
- Worked on Agile Methodology in the process of the project management based on SDLC.
- As a functional consultant, implemented Guidewire Policy enter through an Agile Scrum development model.
- Utilized corporation developed Agile SDLC methodology. Used Scrum Work Pro and Microsoft Office software to perform required job functions.
- 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.
- Strong understanding of project life cycle and SDLC methodologies including RUP, RAD, Waterfall and Agile
- Strong understanding of project life cycle and SDLC methodologies including RUP, RAD, Waterfall and Agile.
- Involved in the testing phase right from the Unit testing to the User Acceptance testing.
- Used SDLC (System Development Life Cycle) methodologies like the RUP and the waterfall.
- Use Cases and other Process Flow Models were designed using Visio and Rational Rose.
Environment: Rational Enterprise Suite (Rose, RequisitePro, ClearCase, ClearQuest), Casewise modeller, Sybase, SQL Server Reports, WinRunner, LoadRunner, Quick TestPro.
