SUMMARY:

• Over 8+ years of Industry experience in Property and Casualty domain as a Business Analyst with solid understanding of Business Requirements Gathering, Evaluating Data Sources, Translating Requirements into Specifications, Application Design.
• Proficient in Technical and Business Writing, Business Process Flow, Business Process Modeling, Business Analysis and Testing various methodologies.
• 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.
• Worked on Property and Casualty insurance company as an Underwriter. Strong understanding of rating in Property and Causality.
• Hands on experience and expertise in Guidewire Policy Center implementation and integration by leveraging Agile Methodology.
• Proficiency with Microsoft Office applications (Word, Excel, PowerPoint, and Visio and Project Management Software), and Atlassian (JIRA, and Confluence)
• Experience in Guidewire suite (PolicyCenter, ClaimCenter, BillingCenter and Contact Center) integrations.
• Experience in Statistical Analysis and predictive modelling of large datasets.
• 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.
• Expertise in validation of ETL process by writing SQL queries using complex joins and Analytic functions against Oracle & SQL Server databases.
• Explored Mercury Interactive Tools (QTP, Quality Center and Load Runner) and Rational tools (Clear Case, Clear Quest, Test Manager and Functional Tester), JIRA for Client/Server and Web - Based Applications.
• Knowledgeable in principles, working and structure of databases like Oracle, SQL Server and MySQL.
• Experience working with Guidewire for Claims, Billing and policy management
• Well versed in project management tools like MS Project for project planning, Project scheduling.
• Insurance experience includes Personal Property Casualty and Commercial Automobile Product knowledge, Reinsurance for Commercial Property Casualty, Group and Auto Insurance Home Owner Insurance and Crop Insurance.
• Expertise in understanding Policy Administration System using Guidewire PolicyCenter especially in Commercial Lines (Businessowners, Worker's Compensation, Business Auto)
• Extensive knowledge in Guidewire Insurance Suite for Personal Lines and Commercial Lines, Workers Compensation, General Liability and Commercial Package.
• Strong understanding of project life cycle and SDLC methodologies including RUP, RAD, Waterfall and Agile.
• Competent in Creating Unified Modeling Language (UML) diagrams such as Use Case Diagrams, Activity Diagrams, Class Diagrams and Sequence Diagrams.
• Business domain knowledge of Property and Casualty Insurance including risk, Policy Sales, Policy Administration System, Receivables and Payments, across different lines of business.

WORK EXPERIENCE:

Business System Analyst

Confidential, Springfield, IL

Responsibilities:

• Performed Source to Target Mappings (STTM) for disparate policy admin system data residing within their individual database environments. Thereby facilitated and drove numerous STTM clarifications and mapping sessions.
• Responsible for reviewing requirements, analyzing the requirements for implementing them using Guidewire Policy Center either by using the out-of-box solutions in Guidewire Platform or providing custom solutions on a case to case basis. As he has been trained in Policy Center
• Created complex SQL queries using TOAD & SQL Navigator to validate the Oracle & MS SQL Server databases for ETL data loads.
• Created User Stories based on the discussions with SME's for the customization of Guidewire Product for the Policy center application, Billing Center and Claims Center.
• Worked with ClaimCenter integration requirement with Docs and Forms, BillingCenter, Rating, Customer Data Hub, Risk Report, Portfolio management, Policy Service, Analytical systems and Defining rules and requirements.
• Conducted JAD sessions with CRM SMEs, system architects, technical teams and other stakeholders for open and pending issues.
• Report on project status to appropriate project management chain using Jira
• Document and track application failures and bugs using tools like Jira and Confluence
• Working as Business Analyst on implementation of Guidewire ClaimCenter for Auto, Property, General Liability and Workers Compensation lines of Business.
• Worked with developers in writing of complex SQL queries to resolve data issues in source system databases.
• Created cross system data flow diagrams and flowcharts to depict the integration dependency of other applications with Guidewire Policy Center
• 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 products.
• Performing mapping on "Individual" roles for Client UI application, policy status mappings for PLS & ORCA admin systems. Participated in designing Generic File layouts for the mappings from pre-landing to landing tables.
• Querying the large datasets from upstream systems and transforming the same and loading it to the analytical software like R, Rapid miner for predictive modelling.
• Gathered requirements for the Guidewire Billing & Policy Center Integration Team by coordinating with SMEs from external systems and also with the Billing & Policy Center functional and configuration teams.
• Ensured all bugs, requirements, mockups and test cases are logged with adequate information into JIRA to assist developers and the team in developing a sound product based on customer standards.
• Attended requirements gathering sessions with the customer based on user feedback and new enhancements, which were entered into JIRA and tracked for future releases.
• Used Informatica Power center in data warehouse to map data coming through different input sources to the target data marts.
• Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data within the Oracle database
• Captured User stories using guidewire template; few major stories worked on included Commercial Auto, Worker's Compensation, Business Owners Policy and Commercial Property Package.
• Involved in every Sprint that covered Elaboration, Configuration and Testing of the Guidewire Policy Center following AGILE approach
• Monitored claims operations metrics to ensure the operational effectiveness of the captive insured's business units and stakeholder medical malpractice claims operations.
• Data Hub testing scope included testing Data Hub requirements, documenting and testing source system records, change requests and assisting SMEs with validation of daily error files.
• Communications liaison between business managers of assigned CRM applications and software engineering team, ensuring alignment of technology solutions to business strategy and facilitating project execution.
• Worked with servers with different configurations such as Application server, mobile server.
• Regularly submitted defect reports and conducted meetings to communicate with the development team about the defects. Also, Reviewed Business Rules written for middle tier and validated XML schema for system data documentation including the requirement data document.

Business System Analyst

Confidential, Bay Area, CA

Responsibilities:

• Analyzed User Requirement Document, Business Requirement Document (BRD), Technical Requirement Specification and Functional Requirement Specification (FRS).
• Prepared and analyzed AS IS and TO BE in the existing architecture and performed Gap Analysis. Involved in creating workflow scenarios, designed new process flows and documented the Business Process and various Business Scenarios and activities of the Business from the conceptual to procedural level.
• Managed cutover of existing business processing done in outgoing information system to SAP system at go-live.
• Used the guidelines and artifacts of the Rational Unified Process (RUP) to strategize the Implementation of RUP effort in different iterations and phases of the Software Development Life Cycle.
• Involved with all the phases of Software Development Life Cycle (SDLC) methodologies throughout the project life cycle.
• Translated high level requirements into functional and technical user stories in JIRA.
• Performed Database integrity testing by executing SQL statements and checked for database transactions at every stage of business flow.
• Used different joins on the tables to retrieve information from different tables in database to check the database on a regular basis using SQL queries.
• Managed/coordinated key claims operations projects including creating and maintaining project plans and schedules from concept to final implementation.
• Gathered Data Hub requirements and created Test Cases and Test Scripts under Quality Center Test Plan and Test Lab modules.
• Performed Business End-User testing of all Guidewire Policy Center/Business Objects claim reports.
• Worked in the designed and implementation of new complex features in Guidewire Policy Center like Policy Cloning feature, which involved writing code on both web front-end and backend parts of the system and creating related test cases according to functional specifications.
• 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.
• Involved in multiple project teams of technical professionals through all phases of the SDLC using technologies including Oracle, Erwin, Data Stage, Data Warehousing, WebSphere and Congo’s.
• Created test plans and executing testing for application enhancements for captive claims operations.
• Perform analysis of the given data by predictive modelling and draw accurate inferences by visualizing the data in Tableau and generate reports, in accord with the objectives of the analysis.
• Involved in creating source table definitions in the Data Stage Repository by studying the data sources.
• Wrote Test Cases in Mercury Quality center that would test various Test scenarios.
• Used Query Analyzer, Execution Plan to optimize SQL Queries.
• Involved in Data mapping, logical data modeling, and creating class diagrams and ER diagrams and used SQL queries to filter data within the Oracle database.
• Mapped legacy data with PolicyCenter target tables in the required data dictionary and configured PolicyCenter with tight document/imaging support, new screens, revised assignment logic.
• Created mockups for functional user stories implemented in JIRA.
• Detect fraud using historic data and predictive modelling using Matlab to automate identification and classification of anomalous behavior and strengthen the ability to respond to fraud in real time
• Used XML for building and parsing of Application Configuration file.
• Owned the entire reporting process. Interacted with the ETL team, developer(s), management, and account holders to get the requirements, document them, design templates, and write specifications.
• Identified/documented data sources and transformation rules required to populate and maintain data warehouse content.
• Facilitate JAD sessions involving the management, development and user teams for clarifying requirements and facilitating better communication.
• Responsible for rating multi-line policies. Manual rated Property, Liability, Auto and Workers Compensation policies. Conducted classes for Auto and Workers compensation rating.
• Worked closely with the Enterprise Data Warehouse team and Business Intelligence Architecture team to understand repository objects that support the business requirement and process.
• Identified as well as documented data sources and transformation rules required to populate and maintain data warehouse content.
• Created acceptance criteria for functional and technical user stories in JIRA.

Business System Analyst

Confidential, Tallahassee, FL

Responsibilities:

• Expert in commercial (P&C) Property and Casualty and Personal Lines Insurance experience with national carriers
• Analysis of business requirements and system requirements of the client and also for Property and casualty (P&C) modules
• Wrote SQL statements in script to retrieve data from database in order to verify accurate data stored in database as well as back end testing.
• Responsible for acting as a liaison with operational and financial management, systems support and sales to identify business opportunities. Developed a file of ACORD Forms used as the standards in all (P&C) Property and Casualty markets, for both Personal and Commercial Lines of Business.
• Capture Feature/Function information at varying levels of granularity and document them in a requirements management tool (e.g. Microsoft TFS, JIRA, etc.)
• Familiarity with a requirements management tool like MS Team Foundation Server, JIRA or the like
• Gathered requirements for the Guidewire Billing & Policy Center Integration Team by coordinating with SMEs from external systems and also with the Billing & Policy Center functional and configuration teams.
• Involved in generating Test cases for (P&C) property and casualty Insurances for Different Levels of Business
• Identify business rules for data migration and Perform data administration through data models and metadata.
• Process mapping, data cleansing, data migration and validation of data table structure in areas of sales, inventory, procurement, production and distribution.
• Analyzed the business rules for Auto claim assignments throughout the US, so as to have balanced work load for all the claims reps. The Guidewire Claim center application uses Java to write data from Claim Center to Staging Tables as part of Distributed Team.
• Involved in Guidewire Corporate on Guidewire PolicyCenter, Worked on Commercial Lines Property and Casualty Insurance.
• Responsibilities include gathering business requirements, developing strategy for data cleansing and data migration, writing functional and technical specifications, creating source to target mapping, designing data profiling and data validation jobs in Data Stage, and creating ETL jobs in Data Stage.
• Elicited requirements and provided specific business and technical requirements guidance for the construction of the system. The requirements set comprised of Business Requirements Document (BRD), functional requirements, Business and System Use Cases.
• Constructed and maintained UML models using Rational Rose, and created use case diagrams, class diagrams and sequence diagrams for all the use cases
• Co-ordination with multiple teams and integration architects, in performing analysis for issues regarding speed and stability
• Worked on SQL server performing the basic level of database testing. Also worked on security testing techniques like SQL injection.
• Utilized Clear Case software configuration management tool as source safe repository to store all valuable code for reusability and disaster recovery purpose.
• Conducting user interviews at both in-house and client locations, gathering and analyzing requirements using Agile and requisite pro.
• Involved in documenting customization requirements, business rules and data migration requirements for the Implementation of Guidewire ClaimCenter and PolicyCenter.
• Involved in Inception Phase and prepared Logical Data Models that contains set of diagrams and BRD (Business Requirement Documents) supporting documents containing the essential business elements, detail definitions, and descriptions of the relationships between the actors to analyze and document business data requirements.
• Scheduled meetings with developers, System Analysts (SA) and testers to collaborate resource allocation and project completion using MS Project.
• Researched the various steps in the lifecycle and then constructed the system in such a way that the riskier claims could be easily identified and monitored.
• 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
• Created targeted Questionnaires for SME's to gather requirements. Collaborated with business owners, SME's, project managers and IT personnel to define project objectives,

Business System Analyst

Confidential, West Bend, WI

Responsibilities:

• Gathered the high-level business needs from the directors and prepared the High-level Business Needs.
• Work 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.
• Worked with Billing center, Customer Portfolio, Forms team to test the integration between these services.
• Aligned with the Guidewire Policy Center work stream and worked closely with Billing Center, Integration, Rating, Claim Center, Data Hub, and Agent Portland Forms streams.
• Performed Data Cleaning, Data Profiling, and Data Analysis and Data Mapping operations to bring more insights onto the raw finance data.
• Worked on a project, which dealt with the Production Stabilization and Defect Tracking of the newly migrated Guidewire Billing Center.
• 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
• Elicited requirements for various Claims Integrations with Policy Center and Billing Center on activities like Policy and Billing Status retrieval, Checks Issued and Void Processes for Claims etc.
• Involved in testing the Quote & Purchase for both Auto and Home Property Insurance ratings of the customers.
• Extracted data Analysis from different sources like Oracle and text files using MS Access, SQL procedures Maintained key records for purposes of Compliance review, QA/QC, and/or regulatory inquiry. Performed Data mapping, logical data modeling, involved in creating class diagrams and ER diagrams and used SQL queries to filter data
• Worked on conducting User Acceptance Testing (UAT) and documenting test cases in both personal commercial line of property and casualty insurance
• Used JIRA for User Story requirements management throughout the Agile Sprints and development life cycle.
• Involved in creating Data Stage jobs to extract, transform and load data into data warehouses from various sources like relational databases, application systems, temporary tables, flat files etc.
• Responsible for writing and modification of PL/SQL stored procedure, functions, packages and Database triggers
• Identify customer-marketing opportunities by applying data mining models and writing advanced T-SQL stored procedures and queries.
• Prepared requirements document for Commercial Auto, Inland Marine, Crime, Worker's Compensation, Umbrella, Business Owners Policy, Commercial Output Policy, and Commercial Property Package.

Business Analyst

Confidential, Columbia, MO

Responsibilities:

• Established a RUP centric business analysis methodology
• 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
• Provided inputs in the strategic development of detailed project plans, work assignments, target dates etc.
• Created, iterated, prioritized and groomed user stories that make up the Scrum project& product backlog.
• Gathering requirements from the business & underwriting department.
• Understanding of underwriting process including policy lifecycle, issue, coverage and rating.
• Worked on developing a new policy system for quote, new business, endorsements, cancellations, reinstatements and renewals.
• Involved in designing and developing Use Cases, Activity Diagrams, Sequence Diagrams, OOD using UML
• Performed requirement analysis, went through all the use cases and issue logs
• Organized UAT sessions and made presentations to the users on the project and the changes implemented
• Developed strategic partnerships with the business unit to prepare a solid knowledge base of the business line, including the business plan, products, and process and revenue streams aimed towards problem solving
• Assisted with user testing of systems, developing and maintaining quality procedures, and ensuring that appropriate documentation was in place
• Developed the test plan, test conditions and test cases to be used in testing based on business requirements, technical specifications and/or product knowledge
• Played a key role in the planning, testing, and implementation of system enhancements and conversions
• Participated in writing data mapping documents and performing gap analysis on the systems.
• Wrote and Enhanced test cases and test scripts to meet new functional requirements for Data validation.
• Performed analysis on enterprise data/report integration & provided functional specification to development team to build Enterprise Reporting Systems
• Presented reports and analysis to help guide the management
• Organized cross of team members and users to become more responsive
• Assisted development of materials for new technology and process improvements