Sr. Business Systems Analyst Resume
NY
PROFESSIONAL SUMMARY:
- 8+ years of experience as a Business Systems Analyst with solid understanding of Business Requirement gathering, Business Process flow, Business Process Modeling, Data Analysis, Data Mapping and Business Analysis.
- Strong understanding of project life cycle and SDLC methodologies including RUP, RAD, Waterfall and Agile.
- Experienced in manual and automated testing for both front - end and backend. Extensively used automated test tools of Mercury like Quality Center, Quick Test Pro, Win Runner, Test Director, Performance and Load Runner Testing.
- Experience in creating custom site templates and list templates for developing web part pages for the portal using SharePoint Portal Server 2003.
- Expert in commercial Property and Casualty and Personal Lines Insurance experience with national carriers.
- Extensive experience with data modeling and defining the conceptual and logical model of the data warehouse.
- Expert in the Property, Casualty, Annuities, Disability, and Supplemental Insurance policies include administration, sales, customization, claims, 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/D).
- Facilitated Change Management across entire process from Project conceptualization to Testing through Project Delivery, Software Development and Implementation Management in diverse Business and Technical Environments.
- Utilized the guidelines and artifacts of the Agile Methodology to develop a detailed implementation process Guidewire Claim Center Integration during different iterations and phases in Software Development Life Cycle (SDLC).
- 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.
- Extremely proficient in using Agile and XP methodologies performed roles of Scrum Master following sprint sessions and used Rally software extensively to write User Stories, assign tasks to individual team members.
- Extensive experience in developing Use Cases, creating Screen Mockups, conducting Gap Analysis and Impact Analysis, SWOT analysis, Cost Benefit Analysis, Risk Analysis.
- 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.
- Experience in providing actuarial and business consulting in Annuities & Life Insurance domain.
- Domain knowledge of insurance industry with very challenging and demanding work environment. Broad experience in Property and Casualty Insurance including Auto, Home, and Marine Life insurance/Annuities.
- Coordinating with admin systems for Life Insurance, Long term Care, Health and Annuities.
- Technically competent in Workers Compensation Case Management including complex claims, disputes, Regulatory matters, common law and litigated claims.
- Advanced knowledge of case law and state Workers Compensation laws, subrogation, reserve setting and litigation management.
- Responsible to Track, Document, Capture, Manage and Communicate the Requirements using Requirement Traceability Matrix (RTM) which helped in controlling numerous artifacts produced by the teams across the deliverables for a project.
- Extensively interacted with the designers, developers to ensure functional implementation of business requirements and QA Team in executing Test Plans, Test Scenarios and Test Cases for Claim Center Module using Guidewire.
- Experienced with Rational tools like Rational Req Pro, Clearquest, ClearCase, JIRA, Rational Rose, and FACETS.
- Experience in facilitating the test process by using bug tracking tool JIRA.
- Have worked in Guidewire Policy Center from End-to-End and involved in Policy Info, Person Info, Losses and Violations, Coverage's, Risk Analysis Customizations.
- Developed User stories consisting of UI Mockups and Business Rules to capture the functional requirements of the Guidewire Billing Center.
- Experience in delivering products using agile methodology.
- Ability to work with functional teams in an Agile/SCRUM and SAFE environment.
- As a functional consultant, implemented Guidewire Policy Center through an Agile Scrum development model.
- Involved in the UAT Testing for Guidewire policy/billing centers during the production run.
- 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.
- Highly experienced in DMAIC
- Strong experience in conducting User Acceptance Testing (UAT) and documentation of Test Cases. Expertise in designing and developing Test Plans and Test Scripts.
- Understanding Trizetto Clinical Care Advance/ MaxMC Landacorp Data model and helping business to understand and implement the same in new environment.
- The analyst will be intimately involved with Trizetto, and EMR system, providing reimbursement analysis reporting.
- Knowledge of TriZetto products and applications helpful.
TECHNICAL SKILLS:
Languages and Tools: UML, Rational Rose, RequisitePro, Rational SoDA, Rational Clear Case, Rational Clear Quest, Mercury Test Director, Quality Center, MS Project, MS Visio, MS Office Suite, Bloomberg,VBA for Excel, SQL, PL/SQL, 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
Sr. 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.
- Experience with MS Office, Agile software development (SCRUM), JIRA.
- Created, assigned, and maintained tickets in JIRA for bugs and defects.
- Performed mapping of fields in Life Insurance application to New Business Submission Transaction (tc = 103) in the ACORD data model.
- Analysis and documentation of the business requirements for Policy conversion to Guidewire Policy Center at the time of renewal.
- 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.
- Extensive knowledge in Guidewire Insurance Suite for Personal Lines and Commercial Lines, Workers Compensation, General Liability and Commercial Package.
- Developed a Business Acceptance testing strategy and plan. 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.
- 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.
- 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
- Analyzed 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 Modeling. 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.
- Experience with Trizetto Facets 4.71, 4.81 and 5.01.
- Extensive working experience with TriZetto's Facets tool.
- Healthcare Tools Trizetto Facets 4.51, Claredi, Amisys, QNXT.
- 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
- Analyzed 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.
- Analyze Annuities accumulation and payout lifecycles: cash flows, terminations, selections, and utilizations.
- Worked on Life Insurance and Annuities domain for big Insurance players such as Ameriprise Financial Services, Met life, American General AIG, Foresters, Pacific life, Phoenix insurance, Transamerica and American Family.
- Map actuarial concepts (annuities valuation, reserving, reinsurance) to data model structures: identification of existing, or creation of new business terms their descriptions and sourcing.
- Used Test Director and Mercury Quality Center for updating the status of all the Test Cases & Test Scripts that are executed during testing process.
- 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.
- 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, JIRA, Rose, MS Word, MS PowerPoint, MS Excel, MS Visio, LoadRunner, WinRunner
Confidential, Bethlehem, PA
Business Analyst
Responsibilities:
- Established a RUP (Rational Unified Process) centric business analysis methodology.
- Prepared High Level Logical Data Models and BRD’s (Business Requirement Documents) supporting documents containing the essential business elements, detailed definitions, and descriptions of the relationships between the actors to analyze and document business data requirements.
- Knowledge of requirements management and/or prototyping (ALM, Jira, RallyDev, Balsamiq, iRise).
- Capable of leveraging a deep functional knowledge of the solution/platform to clearly articulate via stories in JIRA what the desired end state of a feature is to software engineer.
- Collaborated in building a business analysis process model using Rational Rose, RequisitePro , and Visio.
- Provided key initiatives in working with users in defining project and system requirements.
- Wrote Business Cases for the Stakeholders to understand the functioning of the new Underwriting System.
- Involved in the End to end testing of the project and also actively involved in SAT support for fixing the SAT logs on a time critical basis.
- Technically competent in Workers Compensation Case Management including complex claims, disputes, Regulatory matters, common law and litigated claims.
- Prepared requirements document for Commercial Auto, Inland Marine, Crime, Worker's Compensation, Umbrella, Business Owners Policy, Commercial Output Policy, and Commercial Property Package.
- Created different users, roles, Document libraries, Form Libraries, Team sites for projects, Issue Lists on SharePoint Server 2003
- Provided clear and concise documentation regarding requirements management plans, Functional Requirements, supplemental Requirements, Test Plans and Test Cases.
- Helped with Data Mapping between the data mart and the Source Systems.
- Participated in UAT (User Acceptance Testing) with all levels of User Groups.
- Processed annuitant transaction to move their payout investment from one separate account to another
- Tested validity and integrity of the calculation engines for Deferred Annuities, Past Services Pension adjustments.
- Extensively used Test Director to review and update the status of entire testing process.
- Create and maintain requirements, test cases and defects in Mercury Quality Center
- Design and develop the data load process using XML Style sheets and ACORD.
- Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, OOD using UML
- Performed requirement analysis, went through all the use cases and issue logs.
- Extensive understanding & experience of migrating insurance suite solutions to Guidewire solutions
- Experience working on Guidewire Claim Center, Policy Center and Billing Center.
- Experience with MS Office, Agile software development (SCRUM), JIRA.
- Utilized corporation developed Agile SDLC methodology. Used ScrumWork Pro and Microsoft Office software to perform required job functions.
- 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.
- Managed the Order Management team for the in time delivery of the User Stories and faults.
- Conducted mass user interviews with brokers, enterprise user representatives and SMEs.
- Worked extensively with MS Excel.
- Identify, manage and document the status of open issues. Develop and utilize reports to analyze and stratify data in order to address gaps and provide answers to issues identified within the department or by other departments, utilizing TriZetto or Optum for research and correction.
- Vendor management between TriZetto and CareSource.
- Knowledge of TriZetto products and applications helpful.
- Provide customer service and support for Property & Casualty risk management needs
Environment: Windows , MS Office(MS Word, MS Excel, MS Power point, MS Visio), .NET, JIRA, Oracle, Crystal reports, RUP, UML, SQL, Quality Center, SWOT analysis, GAP Analysis, Win Runner
Confidential
Business Analyst
Responsibilities:
- Gathered high-level requirement for all the external projects in a release.
- Processing of New Business, Renewal, Cancellation, Reinstatement, Billing for various lines of business (Fire, Auto, Commercial)
- Also responsible for managing communication and expectations of system vendor, the former parent company IT and business departments, and Allied Worlds various business units (underwriting, claims, reinsurance, actuary, accounting, and IT)
- Worked on SAT (System Acceptance Testing) and SIT (System Integration Testing) in production like environments.
- Negotiated with teams from projects to decide if modules should be implemented independently, or Parallely
- Performing Unit testing, Integration testing and support SAT (System Acceptance Test), TFP (Test for Production), Load testing, and Regression testing of the application.
- Created functional requirement documents for the impacting projects
- Performed criteria table updates for each project.
- Experience with MS Office, Agile software development (SCRUM), JIRA.
- Experience using BI Tools, Java, Redis/Kafka, Confluence, SQL, Jira and other technology systems relevant to the position.
- The application would let customers submit online claims for Worker's Compensation Property and Casualty and the Non-worker's Compensation.
- Worked on Regulatory Reporting RRD Data Warehouse for compiling Workers Compensation statistical reports to external regulators and states.
- Worked extensively to write Use Cases and do the Process flows for the Worker’s Compensation package.
- Updated the impacted MS Access tables.
- Worked extensively with MS Excel and MS access
- 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.
- 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.
- Developed timelines for project delivery, and managed projects/resources
- Participated in meetings to establish and enforce SharePoint best practices and standards manage proper security group naming conventions & security assignment processes
- Participated in requirements meetings, writing requirements in CaliberRM, converting requirements from Caliber RM to HP Quality Center.
- 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.
- Extensive knowledge in Guidewire Insurance Suite for Personal Lines and Commercial Lines, Workers Compensation, General Liability and Commercial Package.
- Participated in Agile Planning Sessions and assumed the Product Owner role for the Agile initiative.
- Responsible for creating Bordereau report on a monthly basis for reinsurance broker.
- Documented and delivered Functional Specification Document to the project team.
- 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, Windows NT/XP, JIRA, Oracle, SQL, SQL Server, Sybase, VBScript, C#. DOORS, C++, NET, ASP.NET, Quality Center, Business Objects, Test Director, Load Runner
Confidential, NJ
Business Analyst
Responsibilities:
- Played key role in System Development Life Cycle Process consisting of: Design and Gap Analysis, Business Requirements, Systems Requirements, Test.
- The analyst will be intimately involved with Trizetto, and EMR system, providing reimbursement analysis reporting.
- Responsible for the development of a Data Warehouse for personal lines property and casualty insurance.
- Worked on Commercial lines Property and Casualty Insurance including both policy and claim processing and reinsurance.
- Criteria and Implementation to have the outputs of project dealt with the automation of correspondence directed to Insurance policy owners.
- Used MS Share point for the purpose of managing documents and for hosting websites which was used to access shared work spaces and documents.
- Created business requirement documents and integrated the requirements and underlying platform functionality.
- Collected & documented the requirement of Business Teams from Annuities, ASPF, Policy & Program Evaluation Team, and Project Sponsors & Actuaries.
- Expertise in the Property, Casualty, Annuities, Disability, and Supplemental Insurance policies and having good command on SWIFT messaging and commercial Property and Casualty and Personal Lines Insurance experience with national carriers.
- Responsible for converting for Mutual Life Insurance, the Fixed and Variable Annuities PC administrative system to the mainframe Vantage.
- Interfaced between Business new product builders and System platform builders.
- Worked with systems area to translate business needs into system requirements.
- Coordinated defects routing in the team and created Excel macros to generate daily defects report status from Quality center across multiple teams.
- 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.
- 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.
- Experience in commercial Property and Casualty, Commercial Lines and Personal Lines Insurance, Underwriting, Rating and Guidewire experience with national carriers.
- Experience with MS Office, Agile software development (SCRUM), JIRA.
- Used Agile - Scrum methodology and worked in short Sprints to achieve goals.
- 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, Clear Case, Clear Quest), Case wise modeller, IBM Web Sphere, Quality Center, Oracle, DB2, Sybase, SQL Server Reports, WinRunner, LoadRunner, Quick TestPro
Confidential, Cleveland, OH
Business Analyst
Responsibilities:
- Involved in the analysis of the existing credit card processing system, mapping phase according to functionality and data conversion procedure.
- Analysis of business requirements and system requirements of the client and also for Property and casualty modules
- Created program with complex business functionality for generating quarterly and annual statements for various kinds of Annuity products.
- Involved in generating Test cases for property and casualty Insurances for Different Levels of Business
- Used external data sources to feed in product systems catering to Brokerage, Mutual Funds and Annuities
- Correspondence included solicitation letters, financial transaction confirmations, and quarterly and annual policy statements.
- Followed solely RUP methodologies during the course of the project.
- Utilized the 80-20 rule to prioritize and in corporate the critical features. Used Time-Boxing techniques to finish within set time frames.
- Accumulated system requirements from various departments through surveys and interviews.
- Involved in prioritizing the defects and writing business requirements to resolve them.
- Authored the product backlog for the complete project, derived User Stories for individual iterations, assigned tasks and allocated appropriate resources for completion and acceptance of individual stories
- 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.
- Created Use Case Diagrams, Activity Diagrams, Sequence Diagrams and ER Diagrams in MS Project.
- Assisted in the development, design and implementation of new relational or multi-dimensional databases, including the analysis of user needs.
- Created and managed project templates, Use Case project templates, requirement types and traceability relationships in Requisite Pro.
- Developed Systems Specifications document to define the impact of the new requirements on the existing system.
- Worked extensively with MS Excel and MS access.
- Knowledge of Guidewire integration framework and various integration methods (Web service APIs, Plugins, Messaging code, Guidewire XML models, templates etc.).
- Prepared the Integration Requirements for the Integration points between Guidewire claim Center and Client's legacy systems and other 3rd party service providers.
- Working as Business Analyst on implementation of Guidewire claim Center for Auto, Property, General Liability and Workers Compensation lines of Business.
- Identify source systems, and designate data points files for annuities modeling and experience studies efforts.
- Knowledge of personal retirement space / product solutions (e.g., Savings Accounts, Individual Retirement Accounts, Annuities, Life Insurance).
- Involved in Performance Measurement to develop measurable indicators that can be systematically tracked to assess progress made in achieving predetermined goals.
- Developed and managed creation of product documentation to communicate features, benefits, positioning and impacts to different audiences and ensured that documentation deliverables from various groups are produced as needed.
- Strong understanding of various SDLC methodologies such as Waterfall and Agile with hands on experience in all of them.
- Well versed with AIM/SDLC/Agile Methodologies.
- Utilized the guidelines and artifacts of the Agile Methodology to develop a detailed implementation process Guidewire Claim Center Integration during different iterations and phases in Software Development Life Cycle (SDLC).
- Assist with user testing of systems (UAT), developing and maintaining quality procedures, and ensuring that appropriate documentation is in place.
- Responsible for special projects requested by company management or reinsurance broker involving analyzing underwriting revenue and financial performance for companys reinsurance broker.
Environment: Rational Enterprise Suite (Rose, RequisitePro, Clear Case, Clear Quest), Case wise modeller, IBM Web Sphere, XML, Java, Unix, C++, J2EE, JSP, Oracle, DB2, Sybase, SQL Server Reports, Win Runner, Load Runner, Quick Test Pro