Business Analyst Resume Profile
PROFESSIONAL SUMMARY:
- 7 plus years experience as Business Analyst in directing cross-functional teams of technical experts to analyse systems processes and implement infrastructure improvements.
- 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
- Solid understanding of business intelligence BI dashboard tools such as OBIEE.
- Experience in development methodologies like RUP, SDLC, AGILE, SCRUM and Waterfall
- Expert in commercial Property and Casualty and Personal Lines Insurance experience with national carriers.
- In Depth understanding of the AS-IS and TO-BE business processes and experience in converting these requirements into technical specifications for preparing test plans.
- Knowledge of RDBMS, development platform and languages, web design.
- Experience in conducting Joint Application Development JAD sessions and White Board Sessions with end-users, Subject Matter Expert SMEs team, Architects and design group development and QA team for project meetings, walkthroughs and customer interviews commensurate with excellent communication skills.
- 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.
- Good knowledge of Web Services, SOAP programming, WSDL, XML technologies DTD, SAX and XSLT
- 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.
- 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 Mockups, conducting Gap Analysis and Impact Analysis, SWOT analysis, Cost Benefit Analysis, Risk Analysis.
- 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:
OOAD OOA/OOD , RUP, UML, SDLC, Agile, Waterfall, QA, WAP, CVS, TEAMMATE, MS Access, SQL Server, MySQL, PL/SQL, Oracle DBA, Java , Strut, Windows 98/2000/XP, basic SOAP, UNIX, HTML, basic DHTML, basic XML, MS Office Suite-Excel Macros, MS Project, MS Visio, Adobe Photoshop, Flash, Rational- Rational Rose, Clear Quest ,Rational, Cobol, Requisite Pro, CaliberRM, Omniture, Crystal Reports, various NIKU products, C, C , Sharepoint, Docushare, BASIC, Intermediate level-Visual Basic
PROFESSIONAL EXPERIENCE:
Confidential
Role: Sr.Business Analyst
Confidential is a property casualty insurance broker specializing in non-standard Home/Automobile insurance and a proven industry leader offering quality sales and service of comprehensive automobile coverage. It is providing Insurance for homes, cars and business. Automobile, homeowner, motorcycle, RV, and commercial coverage are custom-tailored to meet the needs of each insured, the trademark of Eastwood Insurance Automobile, homeowner, motorcycle, RV, and commercial coverage are custom-tailored to meet the needs of each insured,
Responsibilities:
- Understand the As Is system and develop the To Be system concept and also prepare the System Process Maps.
- Design and develop the data load process using XML Style sheets and ACORD.
- Responsible for developing annual and mid-year operating budgets by underwriting departments.
- Wrote Business Cases for the Stakeholders to understand the functioning of the new Underwriting System.
- Gathered requirements by conducting meetings and brainstorming sessions with end users and Subject Matter Experts SME and documented them using Borland Caliber RM.
- Provided domain understanding and subject matter expertise of payer and/or provider business processes, business rules and operations workflow.
- Captured requirements for monthly SL to GL postings, calculating GL beginning and ending balances.
- Executed all aspects related to employee health insurance, worker's compensation, life insurance, long/short term disability, employee discount/store benefits including company events coordination.
- 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.
- Responsible for special projects requested by company management or reinsurance broker involving analyzing underwriting revenue and financial performance for company's reinsurance broker.
- Worked on Regulatory Reporting RRD Data Warehouse for compiling Workers Compensation statistical reports to external regulators and states.
- Prepared Business Context Diagram, Use Case diagrams and corresponding Activity Diagrams using Rational Rose to depict the workflows to be incorporated into the development of Pega Business Process Management BPM tool.
- Involved with the technical team in understanding the XML file format required for Split loss process and Billing process.
- 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.
- Interacted closely with End users from Underwriting Claims teams and SMEs to understand and gather the business needs and requirements.
- Managed the day-to-day progress of product strategy and full life cycle product development/deployment of entire application including RSS and XML news feeds.
- Acted as primary liaison between the client departments and the Information systems IT department to perform analysis, review, and estimation of client requests, prepared and reviewed requirements and client documentation for Personal Lines Property and Casualty business.
- 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 in designing and developing Data Models and Data Marts that support the Business Intelligence Data Warehouse.
- Reviewed the data model and reporting requirements for Cognos Reports with the Data warehouse/ETL and Reporting team.
- Conducted user interviews, gathered requirements, analyzed the requirements by using Rational Rose, Visio and Requisite pro - RUP
- 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.
- Use of data transformation tools such as DTS, SSIS, Informatica or DataStage.
- Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, and OOD
- Authored various Use Cases and Activity diagrams, Sequence diagrams using Rational Requisite Pro and used UML methodology to define the Data Flow Diagrams DFD .
- Used Test Director and Mercury Quality Center for updating the status of all the Test Cases Test Scripts that are executed during testing process.
- 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, SQL, Java, J2EE, SOAP, Rose, MS Word, MS PowerPoint, MS Excel, MS Visio, LoadRunner, Mercury, WinRunner
Confidential
Role: Business Systems Analyst
The aim of the project was to retire the heritage Underwriting System and create a new Underwriting System for rating Property and Casualty policies. The entire Underwriting System was built on a .NET Framework. The system was designed for both domestic as well as foreign currency policies.
Responsibilities:
- Managed General Liability, Commercial Property, Commercial Package, Commercial Auto and Workers Compensation policy lines
- Interacted with the Subject Matter Experts SME and stakeholders to get a better understanding of client business processes and gather business requirements.
- Prepared requirements document for Commercial Auto, Inland Marine, Crime, Worker's Compensation, Umbrella, Business Owners Policy, Commercial Output Policy, and Commercial Property Package.
- Completed a build versus buy analysis, worked closely with functional heads and subject matter experts in matching the business requirements to identify suitable packages for the organization.
- Processing of New Business, Renewal, Cancellation, Reinstatement, Billing for various lines of business Fire, Auto, Commercial
- Examined various bottlenecks and points for automation to streamline the claims processing, underwriting and pre- and post-sales process.
- Analyzed standard industry practices of back office applications of Insurance Company, underwriting, billing, Payment, policy and claims administration with the help of Subject Matter Expert.
- Maintained a traceability matrix for all requirements and mapping to various Data Reporting Manuals, User Guides.
- Extensive involved in analysis of data elements from worker's compensation that includes various premium components and its calculations, loss amounts claim counts.
- Worked on Property and Casualty insurance company as an Underwriter. Strong understanding of rating in Property and Causality.
- Wrote Test Cases in Mercury Quality center that would test various Test scenarios.
- Involved in generating Test cases for property and casualty Insurances for Different Levels of Business.
- Captured and made executive presentations of the issues and risks inherent in as-is process for review by senior management.
- Worked on UAT testing and took signoff from the Commercial line of Property Casualty business users.
- Work closely with production underwriters to review commercial property 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.
- Provided key initiatives in working with users in defining project and system requirements.
- Involved in Logical Physical Data Modeling. Database Schema design and modification of Triggers, Scripts, Stored Procedures in Sybase Database Servers.
- Responsible for the development of a Data Warehouse for personal lines property and casualty insurance.
- Conducted user interviews, gathered requirements, analyzed the requirements by using Rational Rose, Visio and Requisite pro - RUP
- Conducted JAD sessions with CRM SMEs, system architects, technical teams and other stakeholders for open and pending issues.
- Worked on data modelling and produced data mapping and data definition documentation
- Helped with Data Mapping between the data mart and the Source Systems.
- Extensively used Test Director to review and update the status of entire testing process.
- Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, OOAD using UML and Business Process Modeling.
- Upgraded the existing Test Scripts and created new scripts for client application to be able to work for new versions and patches, which improved product quality.
- Coordinated re-architecturing the existing VBA/Access system into ASP.net environment and existing table structure, stored procedures, and functions in MS SQL environment.
- Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, OOD using UML
- Performed requirement analysis, went through all the use cases and issue logs.
- Worked extensively with MS Excel
- Provide customer service and support for Property Casualty risk management needs
Environment: Windows, MS Office MS Word, MS Excel, MS Powerpoint, MS Visio , GuideWire, .NET, Oracle, Oracle, Java, J2EE, RUP, UML, SQL, SWOT analysis, GAP Analysis, Win Runner
Confidential
Role: Business Analyst
Confidential a Fortune 500 company and a leading player in the Health Insurance and services market. UHCI specializes in Network based care co-ordination health care services for small groups, government and specialized groups and commercial employers. The system streamlined patient registration, patient scheduling, and medical insurance checking, claims processing, and reporting. The purpose of this project involves population of the Enterprise Data Warehouse EDW which is used in critical reporting and analysis. The data is pulled together from multiple, disparate systems.
Responsibilities:
- Gathered high-level requirement for all the external projects in a release.
- Responsible for physical/logical data modeling metadata documentation user documentation and production specs.
- Performed requirements modeling and develop analysis diagrams, activity diagrams, sequence diagrams, state diagrams, data models, and use-case realizations using RUP tools in Agile.
- Created DTS and SSIS Packages to vendors in which records were loaded Daily, also to other data resources such as Excel, Access, flat file, and XML in order to Create and maintain a centralized data warehouse.
- Write and execute positive and negative test cases to ensure the data originating from the data warehouse Oracle dB is accurate through to the SQL dB in the applications.
- Performed extensive data modelling to differentiate between the OLTP and Data Warehouse data models
- 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.
- Completed the documentation of Claims Scenario's for the source system
- Involved in formatting data stores and generate UML diagrams of logical and physical data.
- Worked extensively with MS Excel and MS access
- Responsible for acting as a liaison with operational and financial management, systems support and sales to identify business opportunities.
- 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 .
- Developed messaging services using JMS using soap and integrated with MQ to DB.
- Worked with developers and designers of BPM System to make sure development understands business process and detailed technical requirements.
- 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
- Used MS Visio for Process modeling and Business Process flow diagrams.
- Used MS Project to manage schedules, deadlines and resources and collaborate on the project.
- Communicate with Customer Service on ACORD Forms design and other technical problems
- 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, SOAP, Windows NT/XP, Oracle, SQL, SQL Server, Sybase, Db2, Oracle, Java, J2EE. Business Objects, TestDirector, LoadRunner
Confidential
Role: Business Analyst
Responsibilities:
- Worked directly with business users to gather, document and implement requirements to improve Marketing campaign delivery capabilities including enhancement project management.
- Accumulated system requirements from various departments through surveys and interviews.
- Involved in prioritizing the defects and writing business requirements to resolve them.
- Conducted JAD sessions with management, SME, vendors, users and other stakeholders for open and pending issues.
- 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.
- Part of team conducting logical data analysis and data modeling JAD sessions, communicated data-related standards
- Worked for a project to customize and integrate a Business Process Management BPM solution.
- Prepared requirements document for Commercial Auto, Inland Marine, Crime, Worker's Compensation, Umbrella, Business Owners Policy, Commercial Output Policy, and Commercial Property Package.
- Prepared requirements document for Commercial Auto, Inland Marine, Crime, Worker's Compensation, Umbrella, Business Owners Policy, Commercial Output Policy, and Commercial Property Package.
- Mapped all as-is business processes using BPMN standards on MS Visio.
- Developed automated Test Scripts in Win Runner using Test Script Language TSL for Functional Testing, Regression Testing, Data Driven Testing, Usability Testing, and Verifying Specific content through using Checkpoints
- Created and managed project templates, Use Case project templates, requirement types and traceability relationships in Requisite Pro.
- Debugged and fixed several production issues. Created Struts actions which encapsulate business logic of the application.
- Worked extensively with MS Excel and MS access
- 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.
- 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, ClearCase, ClearQuest , Casewise modeller, XML, Mercury, Java, Oracle, DB2, Sybase, SQL Server, WinRunner, LoadRunner, Quick TestPro
Confidential
Role: Business Analyst
Confidential operates as an insurance broker in the United States. The company offers affinity insurance programs that include commercial line property and casualty products such as business owners policy, general liability, crime/fidelity, directors and officers liability, errors and omission insurance, and malpractice insurance and individual benefit programs, which covers life, long-term disability, excess major medical, vision, dental, and long-term care.
Responsibilities:
- Managed the output requirement project for various Life insurance products.
- Conducted JAD sessions for communicating with Stakeholders and Project directors
- Interacted closely with End users from Underwriting Claims teams and SMEs to understand and gather the business needs and requirements.
- Prepared requirements document for Commercial Auto, Inland Marine, Crime, Worker's Compensation, Umbrella, Business Owners Policy, Commercial Output Policy, and Commercial Property Package.
- Coded the Interface Programs which process the incoming files and updating the data in NJKiDS and extracting data from NJKiDS sending the out going files to different External Agencies like IV-A - Public Assistance Agency, DV Domestic Violence, VOCA Victims of Crimes Act, AOC Administrative Office of Court, DMV Department of Motor Vehicles, Office of Family Assistance, Medicaid, FPLS Federal Parent Locator Service and Financial Institutions.
- Correspondence included solicitation letters, financial transaction confirmations, and quarterly
- Used Unified Modeling Language UML for process modeling and use cases.
- Coordinated participation and sign-off of various business partners and customers.
- Generated XML documents using the XML Output Stage.
- Interfaced between Business new product builders and System platform builders.
- Worked with systems area to translate business needs into system requirements.
- Made sure the test cases and test process guarantee accountability to business and systems requirements.
- 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, Oracle, DB2, Sybase, SQL Server Reports, WinRunner, LoadRunner, Quick TestPro