We provide IT Staff Augmentation Services!

Business Analyst Resume

IA

SUMMARY

  • 6+ 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.
  • 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.
  • 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
  • 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.
  • 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.
  • 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
  • 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, Quality Center, MS Project, MS Visio, MS Office Suite, Bloomberg,VBA for Excel, SQL, PL/SQL, J2EE, C#, VB.NET, Adobe Acrobat, PhotoShop, AutoCAD, 3D MAX

Databases: Oracle 8i/9i, MS SQL Server, MS Access

Environments: Windows 9x/NT/2000/XP, UNIX (Sun Solaris, AIX, HP-UX), Linux, Mainframe

PROFESSIONAL EXPERIENCE

Confidential, IA

Business Analyst

Responsibilities:

  • Performed mapping of fields in Life Insurance application to New Business Submission Transaction (tc = 103) in the ACORD data model.
  • Explained Property & Casualty terms, Insurance Rules, Workers Compensation, Claim to the Dev team.
  • Managed General Liability, Commercial Property, Commercial Package, Commercial Auto and Workers Compensation policy lines
  • Documented Business requirements in Business Requirements document (BRD) for Property & Casualty - Personal and Commercial insurance lines: Workers compensation, Homeowners, General Liability.
  • Serve as Property & Casualty Insurance SME, reporting to the President, addressing various Insurance industry issues as they arise and the point person for the development and adoption of the ACORD xml standards
  • Extensively designed Data mapping and filtering, consolidation, cleansing, Integration, ETL, and customization of data mart.
  • Maintained the Product backlog of the application by constant interaction with multiple scrum teams using Rally Agile Central.
  • Involved with the technical team in understanding the XML file format required for Split loss process and Policy process.
  • Designs and develops the logical and physical data models to support the Data Marts and the Data Warehouse
  • Involved in Logical Physical Data store Modeling. Database Schema design and modification of Triggers, Scripts, Stored Procedures in Sybase Database Servers.
  • 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.
  • Worked with ClaimCenter integration requirement with Docs and Forms, BillingCenter, Rating, Customer DataHub, Risk Report, Portfolio management, Policy Service, Analytical systems and Defining rules and requirements.
  • Elicited, documented, modeled, validated and prioritized functional and non-functional requirements using interviews & datahub for policy lifecycle i.e. right from policy creation to policy renewal.
  • Working with integration requirement with Docs and Forms, Policy, Rating, Customer Data Hub, Risk Report, Portfolio management, Policy Service, Analytical systems and defining rules and requirements for online Sales portals
  • As a functional consultant, implemented Guidewire Policy Center through an Agile Scrum development model
  • 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.
  • Worked on Regulatory Reporting RRD Data Warehouse for compiling Workers Compensation statistical reports to external regulators and states.
  • Used JIRA to perform test management activities and used JIRA tool to track and maintain different versions of the project documentation.
  • Managed General Liability, Commercial Property, Commercial Package, Commercial Auto and Workers Compensation policy lines
  • Worked on an end-to-end project which dealt with the enhancement and maintenance of the existing internal electronic enrolment platform and Policy System for providing better services to the customers. The new Policy center implemented for the company had the purpose to migrate its legacy policy datahub to the policy center module of Guidewire Insurance Suite.
  • Extensive involved in analysis of data elements from worker's compensation that includes various premium components and its calculations, loss amounts claim counts.
  • Design and develop the data load process using XML Style sheets and ACORD.
  • Obtained Data requirements, identified data sources, determined the content of data fields and created Data Mapping Documents and performed Datahub Extraction using SQL queries.
  • Expertise in understanding Policy Administration System using Guidewire PolicyCenter especially in Commercial Lines (Business owners, Worker's Compensation, Business Auto).
  • Working as a Guidewire Business Analyst for the Advance Project in the Personal Lines PolicyCenter, which is a web-based policy administration system used for quoting and applications for all personal lines product

Confidential, Salem, OR

Business Analyst

Responsibilities:

  • As a functional consultant, implemented Guidewire Policy Center through an Agile Scrum development model
  • 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.
  • Provide Agile coaching to peer business analysts for Agile Scrum and Kanban best practices and Rally Software instruction.
  • Prepared requirements document for Commercial Auto, Inland Marine, Crime, Worker's Compensation, Umbrella, Business Owners Policy, Commercial Output Policy, and Commercial Property Package.
  • Extensive knowledge in Guidewire Insurance Suite for Personal Lines and Commercial Lines, Workers Compensation, General Liability and Commercial Package
  • Work on the Data Modeling, Entities and Attributes of the Data points and Templates. Building API in XML based on the requirements.
  • Involved with the technical team in understanding the XML file format required for Split loss process and Billing process.
  • Designed Data Stage ETL jobs for extracting data from heterogeneous source systems, transform and finally load into the Data Marts.
  • Coordinated re-architect ring the existing VBA/Access system into ASP.net environment and existing table structure, data store procedures, and functions in MS SQL environment.
  • Managing workers compensation policy and determining compensability. Develop and managing Policy resolution.
  • Configured GENIUS data base with new products and updates for General Liability, Commercial Automobile and Inland Marine
  • Developed web pages using JSPs and JSTL to help end user make online submission of rebates. Also used XMLBeans for data mapping of XML into Java Objects.
  • Creating various project documents like BRD, FRD, Data mapping, data definition document, Data migration related documents, Test Plan, Test case, UAT Document etc.
  • Reviewed and accepted completed User Stories and updated User Story status in Rally.
  • Worked with catastrophic risk assessment models, property exposure and loss Guidewire datahub along with other general insurance aspects. Uses the Guidewire Claim Center for the claim management system
  • Generated data mapping documents from production databases to the warehouse and from the warehouse to the policy and claims marts.
  • Acted as a liaison between client and internal Developers to design software applications for Commercial Line Insurance such as Workers Compensation, Commercial Property, General Liability and Commercial Auto.
  • Processing of New Business, Renewal, Cancellation, Reinstatement, Billing for various lines of business Fire, Auto Liability Commercial
  • Examined various bottlenecks and points for auto Liability to streamline the claims processing, underwriting and pre- and post-sales process.
  • Developed Web Services to communicate to other modules using XML based SOAP and WSDL protocols.
  • Provide data workflow, including legacy system profiling, mapping of data, documentation of business rule validations, and reconciliation of Guidewire datahub for an enterprise integration of Guidewire..
  • Validated policy and claim datahub to assure every detail are populated correctly from the legacy system WINS to Guidewire ClaimCenter.
  • Prepared the Integration Requirements for the Integration points between Guidewire Datahub ClaimCenter and Client's legacy systems and other 3rd party service providers
  • 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
  • Responsible for rating multi-line policies. Manual rated Property, Liability, Auto and Workers Compensation policies. Conducted training classes for Auto and Workers compensation rating.
  • Working as Business Analyst on implementation of Guidewire ClaimCenter for Auto, Property, General Liability and Workers Compensation lines of Business
  • Used XML Web Services using to transfer the amount to transfer application that is remote and global to different financial institutions.
  • Strong knowledge of working on JIRA and Tableau and rained the team on JIRA tool for Agile/ Scrum Methodologies.
  • Expertise in understanding Policy Administration System using Guidewire PolicyCenter especially in Commercial Lines (Business owners, Worker's Compensation, Business Auto).
  • Working as a Guidewire Business Analyst for the Advance Project in the Personal Lines PolicyCenter, which is a web-based policy administration system used for quoting and applications for all personal lines product

Confidential, Columbus, OH

Business Analyst

Responsibilities:

  • Performed extensive data modeling to differentiate between the OLTP and Data Warehouse data models
  • Provided business specifications for ETL Processing and report requirements tBusiness Intelligence team.
  • Identified the organizational needs and provided suitable agile system based solutions.
  • Define and created Rally project, product backlog, iterations and Kanban boards and provide artifact visualization
  • Created Technical specifications documents based on the functional design document for the ETL coding to build the data mart.
  • 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.
  • Involved in formatting data stores and generate UML diagrams of logical and physical data.
  • Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data within the Oracle database
  • Implemented data migration using Informatics on demand.
  • Develop source-to-target mapping documents by analyzing data content and physical data structures in the legacy and downstream applications. Develop mappings to enable data migration, application integration.
  • Generated automated scripts for Guidewire Quick Quote, Application and Policy Binding Processes.
  • Conducted JAD sessions with CRM SMEs, system architects, technical teams and other stakeholders for open and pending issues.
  • Testing of SSIS, DTS and Informatics ETL packages for loading of data into the Data Warehouse
  • Managed a Enterprise data warehouse implementation project for Dominion Capital, working with IBM and the CIO to assess, design and configure the servers, databases, applications and fail-over recovery process.
  • Developed comprehensive system test scenarios and test scripts. Responsible for performing back-end analysis and testing using SQL queries
  • Tracking business reporting issues on JIRA by creating problem statements that help breakdown the underlying issue.
  • Created Enterprise Data Warehouse to be used for ECommerce Created repositories using Informatics’ PowerMart and PowerCenter Repository Manager, Server Manager on Oracle 8i database NT platform.

Confidential, NY

Business Analyst

Responsibilities:

  • Build Platform features, user stories, and maintain backlog with priorities, using Rally and JIRA platforms; Drive HLD, Low Level, and Integration (SOAP, REST, JSON, XML etc) Designs
  • Working as a Guidewire Business Analyst for implementation of Guidewire ClaimCenter 9.0 and PolicyCenter 9.0 for Personal Lines for Business.
  • Lead team in release, iteration planning activities and daily stand up meetings. Monitor team user story task activities and update Rally software. Review and accept completed user stories. Track team's velocity and performance metrics.
  • Extensively designed Data mapping and filtering, consolidation, cleansing, Integration, ETL, and customization of data mart.
  • 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.
  • Develop source-to-target mapping documents by analyzing data content and physical data structures in the legacy and downstream applications. Develop mappings to enable data migration, application integration.
  • Ensured that all bugs are logged with adequate information into JIRA to assist developers in reducing the problem.
  • Managed and monitored various scrum events through agile delivery process, worked closely with project manager, product owner and stakeholders to ensure their expectations are met.
  • Conducted JAD sessions with CRM SMEs, system architects, technical teams and other stakeholders for open and pending issues.
  • Prepared the Integration Requirements for the Integration points between Guidewire ClaimCenter and Client's legacy systems and other 3rd party service providers
  • Writing user stories for Business Process Flow, System Integration Testing based on the Configuration requirements of Guidewire ClaimCenter for Personal Auto LOB
  • Involved with the technical team in understanding the XML file format required for Split loss process and Policy process
  • FTP process requirements for the Inbound and outbound files transfer between Guidewire and various 3rd party vendors like - Enterprise, Safelite, Quest, TransUnion, LexisNexis, General Ledger, ISO/Verisk, AIS.
  • Developed comprehensive system test scenarios and test scripts. Responsible for performing back-end analysis and testing using SQL queries
  • Continuous communication with the team to track requirements on rally and discuss to fix defects with JIRA tools, and corrected lesson learnt from each sprint.
  • Participated in techniques such as SPRINT planning, Product Backlog management, agile estimation, daily SCRUM, metrics such as Burn-down & Velocity charts, Sprint summary report, Sprint review/retro meetings etc
  • 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.
  • Completed various research and investigation activities for carrier's current policy renewal processes, underwriting guidelines, risk assessment tools, Auto symbols
  • Worked closely with the Enterprise Data Warehouse team and Business Intelligence Architecture team to understand repository objects that support the business requirement and process.

Hire Now