PROFESSIONAL SUMMARY:

• 8+ years of experience as Senior Business Analyst wif solid understanding of Business Requirement gathering, Business Process flow, Business Process Modeling, Data Analysis, Data Mapping and Business Analysis Insurance experience includes Personal Property Casualty and Commercial Product noledge, Reinsurance for Commercial Property & Casualty.
• Insurance experience includes Guidewire Personal Property & Casualty and Commercial Automobile Product noledge, Reinsurance for Commercial Property & Casualty, Group and Life Insurance Systems & Annuities.
• Proficient in Technical and Business Writing, Business Process Flow, Business Process Modeling, Business Analysis and Testing various methodologies.
• Experience wif Insurance administration systems included Actuarial, Policy Application, Eligibility, Enrollment, Underwriting, Reinsurance, Claims, Billing, and Payments.
• 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.
• Experience in facilitating Joint Requirement Planning (JRP) sessions wif Business User Groups, conducting Joint Application Development (JAD) sessions wif IT Groups and Conflict Management wif Project team members.
• Extensive experience in building applications to support businesses, e.g. automation in Request for Quote process (RFQ), middle office trade booking/capturing, auto-generation of term-sheets/contracts, position keeping, Straight Through Processing.
• Strong understanding of project life cycle and SDLC methodologies including RUP, RAD, Waterfall and Agile.
• Experience in Object Oriented Analysis and Design (OOA/D).
• Experience in Implementation of Batch processing documents for Commercieal Lines of Business (Using Guidewire PolicyCenter)
• Competent in Creating Unified Modeling Language (UML) diagrams such as Use Case Diagrams, Activity Diagrams, Class Diagrams and Sequence Diagrams.
• Very good understanding of Business Intelligence and Data Warehousing concepts wif emphasis on ETL and Life Cycle Development including requirements analysis, design, development, testing and implementation.
• 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 documentation of business requirements and system functional specifications, including BRD, FRD, and FSD
• Strong experience in conducting User Acceptance Testing (UAT) and documentation of Test Cases. Expertise in designing and developing Test Plans and Test Scripts.
• Highly motivated team player wif excellent Interpersonal and Customer Relational Skills, Proven Communication, Organizational, Analytical, Presentation Skills, and Leadership Qualities.

TECHNICAL SKILLS:

Programming Languages: C,C++,C#,VC++,VB,VB.NET,C#.NET, ASP.NET, Java, SQL, PLSQL

Operating Systems: UNIX, Windows 95/98/NT/2000/XP, Linux.

Databases: MS-Access, MySQL, SQL Server, Oracle, Teradata, DB2, Sybase

Application Servers: IBM Websphere, ATG Dynamo, BEA WebLogic.

Internet: HTML, XML, VBScript, ASP, JavaScript, JSP, J2EE.

Automation Tools: MS Visio, Rational Rose, Rational ClearCase, Rational RequisitePro, Documentum

Methodologies: Rational Unified Process (RUP), Agile and Scrum

Bug Tracking Tools: Mercury TestDirector, Rational ClearQuest

Utility Tools: MS Office Suite, MS Project, TOAD, Adobe Photoshop

Reporting Tools: Crystal Reports, SQL Server Reports (SSRS)

Data warehousing Tools: Informatica, Business Objects, Cognos, Erwin

Testing Tools: Quick TestPro (QTP), TestDirector, WinRunner, LoadRunner

PROFESSIONAL EXPERIENCE:

Confidential, Alpharetta, GA

Sr. Business Analyst

Responsibilities:

• Gathered, analyzed, documented business and technical requirements from both formal and informal sessions and validate teh needs of teh business stakeholders.
• Involved in teh analysis of teh functional, technical specifications, data mapping document and conceptual diagrams.
• GuideWire Claim Center is teh project which was undertaken to upgrade teh current Claim System to track its claim for both their owned Policy holders and third party applications.
• Prepared requirements document for Commercial Auto, Inland Marine, Crime, Worker’s Compensation, Umbrella, Business Owners Policy, Commercial Output Policy, and Commercial Property Package.
• Documented and delivered Functional Specification Document to teh project team.
• Was actively involved in teh design of BRD, FRD, Use Case diagrams and Activity diagrams using MS Visio.
• Established a Business Analysis methodology around teh Rational Unified Process.
• Developed UML Use Cases using Rational Rose and developed a detailed project plan wif emphasis on deliverables.
• Worked on implementation and idewire suite integration; PolicyCenter and BillingCenter wif interfaces to all related systems.
• Implemented noledge of Distributed Web Services/ Enterprise / Web / Client- Server systems using XML and SOA Web services.
• Involved wif teh technical team in understanding teh XML file format required for Split loss process and Billing process. Collating, checking and analyzing spreadsheet data.
• Developed Data Flow Diagrams and Data mapping agreement, illustrating teh flow of data from teh front end GuideWire Claim Center into teh Application database Tables.
• Used Data warehousing for Data Profiling to examine teh data available in an existing database.
• Streamlined clerical work processes and mapped tan into teh new system.
• Developed project plans and managed project scope.
• Assigned tasks among development team, monitored and tracked progress of project following Agile methodology.
• Conducted User Acceptance Testing (UAT) and collaborated wif teh QA team to develop teh test plans, test scenarios, test cases, test data to be used in testing based on business requirements, technical specifications and/or product noledge.
• Track and manage all Change Requests, using Rational ClearQuest.
• Maintained and tracked stakeholders requests for enhancements and changes using Unified Change Management tool (UCM) such as Rational ClearQuest
• Coordinating and Developing QA activities.
• Assisted in creating a High level Request for Proposal (RFP).
• Involved in Inception Phase and prepared vision statement and initial data models dat contain Business Requirement Documents and supporting a document dat contains teh essential business elements and detailed definitions.
• Designed and Customized data models for Data warehouse
• Performed Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data wifin teh Oracle database.
• Worked extensively wif MS Excel and MS access
• Responsible for acting as a liaison wif operational and financial management, systems support and sales to identify business opportunities. Developed a file of ACORD Forms used as teh standards in all Property and Casualty markets, for both Personal and Commercial Lines of Business.
• Collected & documented teh requirement of Business Teams from Annuities at Prudential & ASPF, Policy & Program Evaluation Team, and Project Sponsors & Actuaries.
• Assisted in building a Business Analysis Process Model using Rational Rose and Visio.
• Performed extensive Requirement analysis and developed use cases and workflows.
• Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, and OOD
• Implement and maintain Property & Casualty (e.g. bug-fix, data integration, version release) systems of assigned customers.
• Conducted JAD sessions for communicating wif Stakeholders and Project directors.

Confidential, Columbus, OH

Sr. Business Analyst

Responsibilities:

• Elicited requirements for various Claims Integrations wif PolicyCenter and BillingCenter on activities like Policy and Billing Status retrieval, Checks Issued and Void Processes for Claims etc.
• Responsible for teh proof of concept, testing, and implementation of a new back end system rating engine.
• Used Bug & Defect tracking systems (Bugzilla) for entering and tracking of bugs.
• Introduced Agile and RUP methodologies to reflect liquid nature of front-office improving time-to-market
• Analyzed and defined in detail old model and new model rating engine calculation requirements to accurately calculate new insurance quotes for customers
• Worked on Guidewire Insurance Suite for Personal and Commercial Autos, Workers Compensation, General Liability, Inland Marine, and Personal Liabilit.
• Managed test process, test plans, test case drafts, matrix reports, defect tracking system etc.
• Collaborated in building a business analysis process model using Rational Rose, RequisitePro, and Visio.
• Organized Joint Application developments (JAD), Joint Application Requirements sessions (JAR), Interviews and Requirement Elicitation sessions
• Involved in Logical & Physical Data Modeling. Database Schema design and modification of Triggers, Scripts, and Stored Procedures in Sybase Database Servers.
• Participated in teh complete SDLC process and used PHP to develop website functionality.
• Hands on experience in testing of Web based and Client/Server Applications
• Converted insurance rating algorithms into computer code rule sets for use by rating engine plug-ins and modify end-user input interfaces as required per business users;
• Conducted Joint Application Development (JAD) sessions wif IT groups. Identified teh Key Changes, and participated in Stakeholder Management to communicate TEMPeffectively wif them
• Performed Integration testing, System testing, Regression testing and Performance testing of Billingcenter, Policycenter and Payment manager in Guidewire application based on teh business requirements using LISA.
• Conducted JAD sessions wif CRM SMEs, system architects, technical teams and other stakeholders for open and pending issues.
• Facilitated JAD sessions involving teh management, development and user teams for clarifying requirements and facilitating better communication.
• Conducted elicitation sessions wif Idea Owners and business SME's
• Developed and received approval for BRD's
• Performed Policy and BillingCenter Integration testing on various Billing Instructions.
• Involved in preparing SDLC Documents such as Business Requirement document (BRD), Functional Specification document (FSD), Test Plan, Test Report.
• Extensively used Quality Center to review and update teh status of entire testing process.
• Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, OOAD using UML and Business Process Modeling.
• Utilized Agile/ SCRUM and PMI methodologies to monitor, steer and develop project objectives.
• Involved in mentoring specific projects in application of teh new SDLC based on teh Agile Unified Process, especially from teh project management, requirements and architecture perspectives.
• Designed and develop teh 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 teh use cases and issue logs.

Confidential, Chicago, IL

Business Analyst

Responsibilities:

• Worked as a Personal line of Property and Casualty Expert for interface to Insurer Business Partner on all facets of system design.
• Worked wif underwriting department to evaluate risk, exposure of potential clients and also measured risk exposure and determined premium.
• Extensive success in translating business requirements and user expectations into detailed specifications employing Unified Modeling Language (UML) in an SOA environment.
• Responsible for conducting teh weekly quality assurance review meetings wif teh development team manager, SME’s and teh tester to review teh results.
• Created Source to target data mapping documents identifying key data elements and prepared Data Flow Diagrams
• Also responsible for managing communication and expectations of system vendor, teh former parent company IT and business departments, and Allied Worlds various business units (underwriting, claims, reinsurance, actuary, accounting, and IT)
• Used SoftTest software wif pseudo code to ensure test cases covered all branches of project's code impacting teh system.
• Analysed teh existing as-is system for Insurance Personal Lines, tracked defects, provided recommendations to make enhancements in teh future to-be system
• Involved in generating Test cases for property and casualty Insurances for Different Levels of Business
• Created a cross walk to gather teh data items such as authorization status, error messages from back end processing system, co-pay, co-insurance, non-covered amount and deductible from XML responses.
• Involved in development of Automation Testing Strategies & Test Process; developed automation testing requirements, prepared test scripts, running tests, collecting test results/ metrics.
• Responsible for development & testing of core Policy Admin and Workflow System
• Prepared Business Context Diagram, Use Case diagrams and corresponding Activity Diagrams using Rational Rose to depict teh workflows to be incorporated into teh development of Pega Business Process Management (BPM) tool, Which was used to map these fields from XML ACORD to Guidewire Policy Center.Utilized corporation developed Agile SDLC methodology. Used ScrumWork Pro and Microsoft Office software to perform required job functions.
• Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, OOD using UML
• Created test scripts for Data driven, functional and regression testing using QTP.
• Tested Data Integrity by executing SQL queries against Central databases.
• Involved in complete testing life cycle including creation of Test Plan, Test Cases, collecting test data for various projects and documenting test results
• Prepared Business Requirement Documents (BRD’s) after teh collection of Functional Requirements from System Users dat provided appropriate scope of work for technical team to develop prototype, Use Cases, UML diagrams for overall system.
• Extensive use of MS Office tools like MS Access, MS Word, MS Excel, MS PowerPoint MS Project for data migration in to teh CI System Knowledge Data Base in Microsoft Share Point
• Wrote teh Functional specifications, Insurance product specificBusinessrules and Rating Engine.
• In-charge of Usability testing on teh product and making appropriate recommendations
• Extensively worked on teh ETL mappings, analysis and documentation of OLAP reports requirements
• Participated in User Acceptance testing (UAT) and involved in UA test cases, Executed test cases, Documenting Defects, Resolved defects and Signed Off from Application.
• Hands on work experience working wif offsite team model; coordinate my own efforts wif team members in teh off- site team.

Confidential, OH

Business Analyst

Responsibilities:

• Worked on UAT testing and took signoff from teh Commercial line of Property & Casualty business users.
• 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 teh outputs of project dealt wif teh automation of correspondence directed to Insurance policy owners.
• Analysed teh existing as-is system for Insurance Personal Lines, tracked defects, provided recommendations to make enhancements in teh future to-be system.
• Worked on Commercial lines Property and Casualty Insurance including both policy and claim processing and reinsurance
• Implementation of Guidewire Policy Center -Application Quality Index worksheet after teh end of every release to determine teh quality of teh application during each round of testing for providing QA Signoff.
• Collaborated in building a business analysis process model using Rational Rose, RequisitePro, and Visio.
• Provided key initiatives in working wif users in defining project and system requirements.
• Provided inputs in teh strategic development of detailed project plans, work assignments, target dates etc.
• Collaborated in administration systems included Actuarial, Policy Application, Eligibility, Enrollment, Underwriting, Reinsurance, Claims, Billing, and Payments.
• Developed strategies wif Quality Assurance group to implement Test Cases in Mercury Test Director for stress testing and UAT (User Acceptance Testing
• Writing new COBOL, DB2 programs to handle Claim centre messages (from front end via XML) processed in teh Mainframe from teh front end system called Claim Centre (CC) using GUIDEWIRE working wif SQL SERVER Data.
• Extensively involved in teh modeling and development of Oracle Data Warehousing System.
• Used SDLC (System Development Life Cycle) methodologies like teh RUP and teh waterfall
• Examined various bottlenecks and points for automation to streamline teh claims processing, underwriting and pre- and post-sales process
• Followed Lean Six Sigma methodology to ensure dat there are less defects and errors during teh project and receive high quality outputs.
• GuideWire Claim Center is teh project which was undertaken to upgrade teh current Claim System to track its claim for both their owned Policy holders and third party applications.
• Helped wif Data Mapping between teh data mart and teh Source Systems.
• Extensively used Test Director to review and update teh status of entire testing process.
• Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, OOAD using UML and Business Process Modeling.
• Analyzed and translated business requirements into system specifications utilizing UML and RUP methodology.
• Wrote Test cases for Enterprise Data Warehousing (EDW) Tables and Data Mart Staging Tables.
• Extensively worked on teh ETL mappings, analysis and documentation of OLAP reports requirements
• Coordinated re-architecturing teh existing VBA/Access system into ASP.net environment and existing table structure, stored procedures, and functions in MS SQL environment.
• Design and develop teh 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 teh use cases and issue logs.
• Worked extensively wif MS Excel
• Provide customer service and support for Property & Casualty risk management needs

Confidential, Charlotte, NC

Business Analyst

Responsibilities:

• Performed data profiling and data mapping to map various source data systems to teh new Basel database.
• Document and maintain requirements traceability matrix to ensure all requirements are traceable from top to bottom.
• Performed Data Analysis and Data Validation by writing complex SQL queries using Teradata SQL Assistant.
• Utilized Quality Center to record, track, update or close any defects related to business requirements or data quality.
• Analyzed business requirements according to System specifications and to devise a measurable Plan for teh complete group.
• Wrote and maintain Business Requirements Documents (BRD) and Functional Requirements Documents (FRD) defining new systems operations for teh project using Rational Requisite Pro.
• Created Use cases, Use Case Diagram, Business flow diagram, Work and Navigation flow diagram using Unified modeling language (UML)
• Conducted many informal sessions to develop an architectural solution dat teh application meets teh business requirements, resolve open issues, and change requests.
• Created Use Cases, and developed detailed Use Case Diagrams and Sequence diagrams describing how actions are to be carried out using MS Visio.
• Utilized existing internal processes and improved those same processes for software problem identification, escalation, and resolution and facilitated project team meetings. Continually reviewed and revised project processes to ensure accurate and timely results.
• Led JAR sessions and JAD sessions wif end user community ensuring dat teh software addressed all business needs and also involved in Rapid Application Development sessions (RAD)
• Documented all data mapping and transformation processes in teh Functional Design documents based on teh business requirements.
• Created Technical specifications documents based on teh functional design document for teh ETL coding to build teh data mart.
• Created data trace map and data quality mapping documents.
• Involved in Data Extraction, Transformation and Loading (ETL process) from Source to target systems using Informatica Power Center.
• Designed and implement report layouts according to reporting standards of teh department.
• Worked on daily basis wif lead Data Warehouse developers to evaluate impact on current implementation, redesign of all ETL logic.
• Worked on exporting reports in multiple formats including MS Word, Excel, CSV and PDF.
• Responsible for making teh report available for scheduling or viewing on demand.
• Worked wif Technical Experts to Improve Report Performance and performed System testing.
• Recorded project changes on a weekly basis using change data to update teh project plan and provide up-to-date information for project status reporting using MS Visual Source Safe.