SUMMARY

• Versatile Industry experience as a Sr. Business Analyst wif 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.
• Major experience in Insurance suite product(s) like Guidewire, Insurity and wif other proprietary insurance applications
• Experience in development methodologies like RUP, SDLC, AGILE, SCRUM and Waterfall Strong experience in RUP Business Modeling process.
• Expertise in using Informatica Power center / Power Mart for data extraction, transformation and loading (ETL) from desperate data sources like oracle, SQL server, SAS, flat files, MS Access, JMS and XML files and load teh data into different target
• Worked extensively wif Guidewire software including claims center, policy administration, building center.
• Expertise in UML (class diagrams, object diagrams, GAP Analysis, use case diagrams, state diagrams, sequence diagrams, activity diagrams, and collaboration diagrams) as a data analysis methodology for application functionality designs using IBM's Rational Rose.
• Experience working on large datasets and data manipulation using complex SQL queries
• Competent in Creating Unified Modeling Language (UML) diagrams such as Use Case Diagrams, Activity Diagrams, Class Diagrams and Sequence Diagrams.
• Experience in Guidewire PolicyCenter and BillingCenter configuration and Integration.
• 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.
• Develop and implement load and stress tests wif Mercury LoadRunner, and present performance statistics to application teams, and provide recommendations of how and where performance can be improved
• Expert in writing SQL for validating for complex business rules based on ETL mapping documents
• Responsible to Track, Document, Capture, Manage and Communicate teh Requirements using Requirement Traceability Matrix (RTM) which helped in controlling numerous artifacts produced by teh teams across teh deliverables for a project
• Facilitated and managed JAD sessions wif committee of SMEs from various business areas including auto insurance, homeowners insurance
• Involved in Test Planning, Test Preparation, Test Execution, Issue Resolution and Report Generation to assure that all aspects of a Project are in Compliance wif teh 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.
• Extensive experience wif Data Warehousing, Extraction, Transformation and Loading (ETL) and Business Intelligence (BI) tools
• Insurance experience includes Personal Property Casualty and Commercial Automobile Product knowledge, Reinsurance for Commercial Property Casualty
• Highly motivated team player wif excellent Interpersonal and Customer Relational Skills, Proven Communication, Organizational, Analytical, Presentation Skills, and Leadership Qualities.

PROFESSIONAL EXPERIENCE

Sr. Business Analyst

Confidential, Fairfield, OH

Responsibilities:

• Responsible for interacting wif Business users & end users to gather & analyze Business Requirements (BR).
• Interacted wif teh Business Users, Developers and SME's to get a better understanding of teh Business Processes (BP)
• Performed Requirement analysis & meetings to review teh requirements and both in scope & out of scope.
• Performed GAP Analysis, Duration Analysis and Cost Benefit Analysis.
• Documenting data ware house requirement such as Data standards and quality rules.
• Data mapping - source to target - including of capturing data acquisitions and transformation rules by analyzing different data tables by writing SQL queries and creating mapping requirements
• Responsible for teh development of a Data Warehouse for personal lines property and casualty insurance.
• Facilitated in developing testing procedures, test cases and User Acceptance Testing (UAT)
• Coordinated and Conducted Joint Application Development (JAD) Sessions, Joint Application Solution (JAS) Sessions for teh business users
• Source to target mapping from teh ODS Legacy System to new EDW.
• Responsible for rating multi-line policies. Manual rated Property, Liability, Auto and Workers Compensation policies. Conducted training classes for Auto and Workers compensation rating
• TEMPHas also implemented customized Rating (in current organization we call it Non-ISO) for different clients for Commercial Auto (CA), Personal Auto (PA) and Homeowners (HO)
• Deliver end to end mapping from source (Guidewire application) to target (EDW)
• Assisted auditors in updating fields related to security related controls for accuracy during quarterly SOX financial and IT audit testing
• Arranged audit workpapers for staff auditors which were intended for quality evaluation and documentation throughout various audit testing
• Prepared story board for Property and Casualty (P&C) Insurance Processes including for Claims, New Business, Policy Administration, Underwriting, and Quote
• Worked on reporting and estimates for Property & Casualty (P&C) on Guidewire ClaimCenter implementation
• Worked on Property and Auto products using Guidewire Application
• Experience in Joint Application Development (JAD) sessions as facilitator wif end-users, Subject Matter Experts, Development and QA teams
• Implemented ISO Rates and Algorithms (ERC) of Commercial Auto as well as implemented client Rates and Algorithms of Personal Auto
• Deliver logical and physical data models for dimensions and facts to support EDW reports using PowerDesigner
• Collected and provided evidence of Mercury Application for IT Sarbanes Oxley (SOX) Compliance testing by Internal & External auditors Provided detailed walkthroughs to all stakeholders (Strategic Team, Business Users, development and testing teams) and ensured functional adherence for Guidewire Policy center implementation.
• Analyzed business requirements, developed detailed Test Plans and Test Cases. Solid experience of Quality Assurance (QA) in reviewing Test Procedures, defining Test cases, reviewing and maintaining Test scripts, analyzing bugs, interacting wif team members in fixing errors and User Acceptance Testing (UAT)
• Experienced in all phases of Software Development Life Cycle (SDLC), including Waterfall model, Rational unified process (RUP) and SCRUM methodology
• Used Data Flow approach, User-Interface approach and UML approach
• Lead Business Intelligence reports development efforts by working closely wif DataStage and ETL teams
• Performed Integration testing, System testing, Regression testing and Performance testing of Billing Center, Policy center and Payment manager in Guidewire application based on teh business requirements using LISA
• Created and build ETL Mapping sheets for Legacy to EDW Guidewire conversions
• Conducted Sarbanes Oxley (SOX) and SAS70 audits for commission, life and annuity applications
• Manage teh Production Operations Support mailbox across all product lines/regions to triage Duck Creek, Genius, ImageRight and Reports issues on a day to day workflow basis
• Lead teh analysis of configuring Guidewire Claim System and integrating teh third party vendor as required
• Developed and Analysis Use case diagrams, Activity Diagrams & Sequence diagrams.

Business Analyst

Confidential, Brea, CA

Responsibilities:

• Worked extensively on Integration of Policy and Billing center Systems for Workers Comp.
• Identifying external, internal Interfaces, data exchange points ECM and EDW requirements, work items, hand-offs, compliance rules, financial report requirements and documenting/managing deliverables
• Functioned as teh primary liaison between teh business user, project sponsor, operations team, and teh technical team throughout teh project life cycle for Property & Casualty (P&C) commercial lines of Insurance business unit.
• Elicited business requirements by conducting structured interviews, JAD sessions, and workshops across various Commercial and Personal lines wifin teh P&C business unit.
• Worked wif teh Guide wire specialists in order to gather teh GW requirements and implement those requirements successfully into teh new system
• Participated in Bug-Review meetings wif software developers, QA engineers, managers and suggested enhancements to teh existed application from business perspectives, provided solutions to existing bugsConducted Sarbanes Oxley (SOX) audits and provided interface to internal and external auditors
• Worked wif project sponsor, project team and other stakeholders to determine project milestones and report on progress; prepared communication and status reporting plan.
• Prepared business requirements document and functional specification documents; created Use Cases, Use Case Diagrams, State Diagrams, Activity Diagrams, and Screen mock-ups using Microsoft Visio
• Business Analyst for a client writing Personal Auto, Homeowners, Excess Liability; and Personal Inland Marine in 40+ States
• Conducting insurance rating on automobile policies. Going through numerous rating factors and coverage factors and creating excel worksheets to generate proper premium for customers.
• Resolution of disputes regarding premium increase from current to prior year for automobile policies. Having to manually rate current and prior year policies and submit a final report
• Gathered, captured and documented data requirements to develop a design that will integrate Duck Creek PAS data into teh current NJM Accounting process and support teh reporting requirements of teh internal business groups.
• Provide ETL logic to pull teh data from Guidewire application database to ODS layer and into Guidewire data marts and EDW (Enterprise Data Warehouse)
• Produced detailed systems and support documentation for implementation of a multi-server system to provide archiving and retrieval of emails for compliance purposes
• Provided postproduction support/analysis and assisted in performing User Acceptance Testing (UAT), performance testing and validated test plans
• Documented business processes for Auto insurance into teh Business Requirement Document BRD
• Participated in teh logical and physical design sessions, assisted and developed high and low level design documents
• In depth knowledge of Software Development Life Cycle (SDLC) and experience in management of requirements throughout SDLC.
• Extensively work on analyzing Warehouse (IWH) and Staging data to find expected results and document discrepancies
• Speaking customers wif inquiries and changes to homeowners and automobile insurance policies via telephone or written correspondence
• Used SQL to verify teh data from teh Oracle and MS SQL Server databases
• Used Test Case reports to track teh progress of test case planning, implementation and execution results
• Wrote Training and Procedure Manuals, verified continuity preparedness, and facilitated business users Training
• Performed task decomposition, delegated tasks and monitored project milestones using MS Project.

Business System Analyst

Confidential, Omaha, NE

Responsibilities:

• Conducted JAD sessions and analyzing and documenting teh business requirements and user stories from various teams, business partner, SME and stakeholders
• Facilitate working/ discussion/ review sessions wif Business Partners, Subject Matter Experts (SME) to discuss on teh improvement/ changes that needed to be implemented
• Verified test plans and test results provided by Quality Assurance team properly tested modifications to teh Personal Lines Data Warehouse, specified in requirements documentation
• User Guidewire's Claim Center to see if teh activities are created for teh claims submitted online
• Writing user stories for Business Process Flow, System Integration Testing based on teh Configuration requirements of Guidewire Policy Center for Personal Auto LOB
• Developed current and future state workflows practices in MS Project
• Capture Business Volume Metrics (BVM) data including User groups, Business Drivers, Business Activities, Use Cases & Deployment Data into teh BVM Repository
• Collaborated wif Project Manager on tasks related to teh planning, scheduling and coordination of project activities, estimated resource time and costs
• Performed trial functionality testing of Duck Creek Rating App & provided feedback to management
• Developed complex SQL queries for extensive data quality checks on outbound files and inbound files
• Strategize and test implementation of RUP effort throughout SDLC
• Responsible for identifying opportunities for business-rule verifications by meeting wif business members and other DW personnel
• Created quote, issue, endorse transactions using Duck Creek policy administration system. Evaluated policy XML data structure to map and create source Duck Creek data requirements and system descriptions
• Worked extensively on OSCAR, EDW database for Data Management and Data extraction
• Involved in creating test scenario, test cases and test plan and reviewed teh test cases written by teh test team
• Designed DataStage ETL jobs for extracting data from heterogeneous source systems, transform and finally load into teh Data Marts
• Perform/Execution of System, Regression, and User acceptance testing (UAT) wif teh test team and business partners and facilitate signoff
• Participate in teh implementation and provide post-implementation support if defects are discovered in production

Data Analyst

Confidential, Utica, NY

Responsibilities:

• Performed GAP analysis by identifying existing technologies, documenting teh enhancements to meet teh end state requirements.
• Facilitated numerous Joint Application Development (JAD) sessions and walkthrough meetings for teh creation of design documents, gathering requirements from users, mainly pricing, operating and marketing professionals.
• Developed High Level Business requirement and changed them into functional specifications.
• Designed and developed project documents templates based on Agile SDLC methodology.
• Created and communicated teh prototype requirements to teh development team.
• Liable for maintaining teh Change Request Document and communicate wif teh developers in each iteration review meetings
• Partnered wif teh technical areas in teh research, resolution of system and User Acceptance Testing (UAT)
• Studied in-house requirements for teh Data warehouse to be developed
• Developed strategic partnerships wif teh Business units to develop a solid knowledge base of teh Business line, including teh Business Plan, Products, and Process
• Translated teh Business needs into system Requirements, communicating wif teh Business on a broader scale and wif an in-depth view
• Developed a file of ACORD Forms used as teh standards in all Property and Casualty markets, for both Personal and Commercial Lines of Business
• Extensively involved in Data mapping, Data modeling and data Validations in all of ETL process.
• Established extensive top, down and across communication including sponsors, users, SMEs, DBA, developers and QA
• Acquired signoffs at teh beginning and end of each process from teh project sponsors.
• Integrated wif EDW team to make sure teh data fields are mapped properly and for creating reporting Data-mart for Growth Enterprises for Finance Team