SUMMARY

• Nearly 6+ years of Industry experience 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.
• Expert in commercial Property and Casualty and Personal Lines Insurance experience with national carriers.
• Expertise in UML (class diagrams, object diagrams, GAP Analysis, use case diagrams, state diagrams, sequence diagrams, activity diagrams, and collaboration diagrams) as a business analysis methodology for application functionality designs using IBM’s Rational Rose.
• Worked on Property and Casualty insurance company as an Underwriter. Strong understanding of rating in Property and Casuality.
• 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.
• Guidewire suite is a web - based underwriting and policy administration system for personal and commercial line carriers in the property and casualty insurance (P&C) industry lifecycle.
• Strong business domain knowledge of Property and Casualty Insurance including risk, Policy Sales, Policy Administration System, Receivables and Payments, across different lines of business.
• Expertise in broad range of technologies, including business process tools such as Microsoft Project, MS Excel, MS Access, MS Visio, technical assessment tools, MicroStrategy Data Warehouse Data Modeling and Design.
• Expert in the Property, Casualty, Annuities, Disability, and Supplemental Insurance policies include administration, sales, customization, claims, pensions and CMS.
• Knowledge in the ETL (Extract, Transform and Load) of data into a data warehouse/date mart and Business Intelligence (BI) tools like Business Objects Modules (Reporter, Supervisor, Designer, and Web Intelligence).
• Experience in Agile Methodology, XP (Extreme Programming), Six Sigma.
• Results-oriented Joint Application Development (JAD) Facilitator and meetings coordinator with excellent interpersonal skills.
• Extensive experience in Strategic development of a Data Warehouse and in Performing Data Analysis and Data Mapping from a Operational Data Store to a Enterprise Data Warehouse
• Used Query Analyser, Execution Plan to optimize SQL Queries.
• Well versed in project management tools like MS Project for project planning, Project scheduling.
• Interviewed SMEs and Stakeholders to get a better understanding of client business processes and gather business requirements.
• Insurance experience includes Personal Property Casualty and Commercial Automobile Product knowledge, Reinsurance for Commercial Property Casualty, Group and Life Insurance Systems, Health Insurance, Auto Insurance Home Owner Insurance and Crop Insurance.
• Created product rules and gathered requirements for the implementation of discounts, rating inputs, and reports for implementing Guidewire Policy Center. Presented functional documents to the Guidewire team for implementation
• Extensive experience in documentation of business requirements and system functional specifications, including BRD, FRD, and FSD
• Organized Joint Application developments (JAD), Joint Application Requirements sessions (JAR), Interviews and Requirement Elicitation sessions.
• Strong understanding of project life cycle and SDLC methodologies including RUP, RAD, Waterfall and Agile.
• Object Oriented Analysis and Design (OOA/D).
• Competent in Creating Unified Modeling Language (UML) diagrams such as Use Case Diagrams, Activity Diagrams, Class Diagrams and Sequence Diagrams.

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, Columbus, OH

Business Analyst

Responsibilities:

• Excellent Business writing skills in writing Business requirements document BRD, Use Case Specifications, Functional Requirement Specifications FRS, Software Design Specification SDS, Software Requirements Specification (SRS), Software External Specifications SES, Software Requirement Document(SRD), Data Dictionary, Business Continuity Plan (BCP), Workflows and Unified Modeling Language (UML) diagrams such as Activity diagrams, Class diagrams and Sequence diagrams.
• Extensively worked on the ETL mappings, analysis and documentation of OLAP reports requirements.
• Establish documentation for agile methodology for implementation with a very water-fall-centric development team.
• Extracted data from Oracle database with MS Access, and performed SQL query, data analysis and verification.
• Performed technical integrations to Guidewire applications using Eclipse, .NET, WSDL and SOAP
• Defined, developed specs for federal reporting specific to Medicare Advantage
• Designed and developed the policy rating system using Duck Creek.
• Responsible for the development of a Data Warehouse for personal lines property and casualty insurance.
• Analyzed user stories to develop acceptance test criteria in collaboration with product owners.
• Involved in the meeting with Business Process Owners, SME (Subject Matter Experts) and store users for Requirement gathering in Definition Stage.
• Analyzed scope of the Edge project was to create a Web-based application for agents to submit and maintain commercial insurance claims.
• Examined various bottlenecks and points for automation to streamline the claims processing, underwriting and pre- and post-sales process
• Assured that all Artifacts are in compliance with corporate AGILE Policies and guidelines.
• Conducted and participated in JAD/JAR Sessions periodically with various Subject Matter Experts at various phases of the Development Life Cycle to discuss open issues and resolve them.
• Assisted business users in identifying functional gaps, and developed detailed FSD for the gap
• Extracted the Business Requirements from the end users keeping in mind their need for the application and prepared Business Requirement Documents (BRD) using Rational Requisite Pro.
• 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.
• Interacted with the Subject Matter Experts (SMEs) and stakeholders, gathering business requirements to get a better understanding of client’s business processes.
• Elicited requirements and designed the functionality for Medical Case Management, claims processing and medical billing by integrating ClaimCenter with Rising Medical Solutions.
• Generated SQL queries to develop risk reports.
• Conducted JAD sessions for communicating with Stakeholders and Project directors.
• Claims management uses Guidewire

Environment: Mainframes, COBOL, JCL, Db2, Oracle, GuideWire, Java, J2EE, Rose, MS Word, MS PowerPoint, MS Excel, MS Visio, LoadRunner, WinRunner

Confidential, OH

Business Analyst

Responsibilities:

• Involved in Troubleshooting, Debugging and Performance Tuning of code and supporting users by incorporating specific requests
• Performed Requirement Analysis and developed Use Cases, Activity Diagrams using Rational Rose
• Involved in the creation for Manual Raters for OneShield Personal Lines homeowners product
• Utilized corporation developed Agile SDLC methodology. Used ScrumWork Pro and Microsoft Office software to perform required job functions.
• Conducted JAD sessions with management, SME, vendors, users and other stakeholders for open and pending issues.
• Worked as a Personal line of Property and Casualty Expert for interface to Insurer Business Partner on all facets of system design.
• Analyzed standard industry practices of back office applications of Insurance Company, underwriting, billing, policy and claims administration with the help of Subject Matter Expert
• Managed the Order Management team for the in time delivery of the User Stories and faults.
• 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.
• Analyzed scope of the Edge project was to create a Web-based application for agents to submit and maintain commercial insurance claims.
• Analyzed standard industry practices of back office applications of Insurance Company, underwriting, billing, policy and claims administration with the help of Subject Matter Expert
• Worked extensively with SME in understanding and documenting their requirements pertaining to monitoring changes and portraying a trend to maintain and analyze customer needs and many other business areas.
• Involved in assigning the appropriate benefit accumulators and member group ids for corporate and nationals in the genotable and dedmax using claims processing system.
• Prepared Business Requirement Documents (BRD’s) after the collection of Functional Requirements from System Users that provided appropriate scope of work for technical team to develop prototype and overall system.
• Performed Data Analysis of existing data through SQL and experience with EDI & ETL.
• Writing new COBOL, DB2 programs to handle Claim centre messages (from front end via XML) processed in the Mainframe from the front end system called Claim Centre (CC) using GUIDEWIRE working with SQL SERVER Data.
• Analysis of business requirements and system requirements of the client and also for Property and casualty modules
• Responsible for creating test scenarios, scripting test cases using testing tool and defect management for Policy Management Systems, Payables/Receivables and Claims processing.
• Created cross systemdata flow diagramsandflowchartsto depict the integration dependency of other applications withGuidewire PolicyCenter
• Created the User Acceptance Test Plan and conducted the user acceptance testing (UAT) for the final confirmation of the project from the Business and SME.
• Extensively involved in Guidewire Insurance Suite Application.
• Preparing BRD, Business Cases, and presentation to the clients, Business Re-engineering proposals.
• Involved in creating business processes and modeling diagrams using Rational Unified Process (RUP).
• 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.

Environment: RUP, UML, Windows NT, Java Script, Rational Suite (Rational Test Manager, Rational Robot, Rational Clear Quest) MS Project,Agile/Scrum,MS Visio, Guidewire, Visual Basic, Win Runner, Test Director, Windows XP, J2EE

Confidential, Chicago IL

Business Analyst

Responsibilities:

• Wrote Statements of Work, Business Specification Documents, Test Plans and Test Reports.
• Worked with software engineers and business units, assisted in formulating and defining system scope and objectives through research and fact-finding, combined with a basic understanding of business systems and industry requirements.
• Converted Business Requirements to the Functional Specification and Conducted JAD Sessions to develop an architectural solution that the application meets the business requirements, resolve open issues, and change requests.
• Introduced Agile and RUP methodologies to reflect liquid nature of front-office improving time-to-market
• Serve as Property and 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 ACCORD xml standards.
• Worked on Commercial lines Property and Casualty Insurance including both policy and claim processing and reinsurance
• In absence of formal training process, trained peers in the use of the Guidewire Software after just a few months on the job.
• Involved in the meeting with Business Process Owners, SME (Subject Matter Experts) and store users for Requirement gathering in Definition Stage.
• Used different ad-hoc analysis, the Reports assist in defining strategy for each customer category. Informatica was used for ETL process and Business Objects 6.5.1 & XI R2 are used for Reporting duties
• Wrote BRD, FRD, use cases, test scenarios, test cases for testing the functional and non-functional aspects of both ETL jobs and Reporting jobs.
• Developed data conversion programs for membership, claims, and benefit accumulator data - converted thirteen corporate acquisitions. Developed data field mappings. Provided programming and support for claims processing functions and auto-adjudication
• Analyzed standard industry practices of back office applications of Insurance Company, underwriting, billing, policy and claims administration with the help of Subject Matter Expert.
• Organized and conducted extensive JAD sessions with users to identify, understand and document requirements.
• Involved in every Sprint that covered Elaboration, Configuration and Testing of theGuidewirePolicyCenterfollowingAGILEapproach
• 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.
• Gathered requirements and modeled the data warehouse and the underlying transactional database
• Responsible for scheduling meetings with users, SME’s and stakeholders to identify problems resolve issues and improve the process to ensure a stable and accurate solution.
• Responsible for testing the Quote & Purchase for both Auto and Home Property Insurance of the customers.
• Provide implementation assessment, strategy, and mentoring services for Rational Rose, UML and RUP.
• Daily conducted Scrum to take updates from team members and attended Scrum of Scrums to give User Story status updates as well prepared burn down charts to know the daily progress of work.

Environment: Java, SQL, Oracle, MS Office, MS Project, Mercury Quality Center, Business Process, Rational ClearCase,Agile, Agile/Scrum,Rational Requisite Pro, Guidewire, Rational Rose, MS Visio.

Confidential, Springfield Illinois

Business Analyst

Responsibilities:

• Gathered high-level requirement for all the external projects in a release.
• Involved in all stages of testing the Auto & Home Insurance application.
• Responsible for testing the Quote & Purchase for both Auto and Home Property Insurance of the customers.
• Involved in Risk Assessment for each project.
• Investigated, understood and analysed the current underwriting and disparate manual sales process.
• Met with report users and stakeholders to understand the problem domain, gathered customer requirements through surveys, interviews (group and one-on-one) along with JAD sessions.
• Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data within the Oracle database.
• Developed the ETL Informatica Mappings for importing data from ODS into subsequent data marts.
• Gather final requirement and draft the BRD and Business Data Flow Diagrams
• Conducted JAD sessions with SMEs and technological experts to gather data requirements such as securities pricing, corporate actions, trade and custodial data.
• Developed variousUser StoriesconsistingUI Mockups and Business Rulesto capture the functional requirements oftheGuidewire PolicyCenter
• Charged with providing deep industry knowledge and technical expertise on all Guidewire solution products. Engage side by side with prospective clients, while offering business consulting activities and conducting prospect interviews.
• Involved in generating Test cases for property and casualty Insurances for Different Levels of Business
• Develop and maintain sales reporting using in MS Excel queries, SQL in Teradata, and MS Access.
• Worked on an application that took care of online account services which included Bill paying, checking the bill history, changing customer profile, ordering auto insurance ID cards Worked on Commercial lines Property and Casualty Insurance including both policy and claim processing and reinsurance.
• Facilitated JAD sessions with SMEs and business analysts from other feeder systems for a detailed analysis and a better understanding of impact of various projects on each other.
• Schedule SMEs for Business Process Validation Meetings
• Used SDLC (System Development Life Cycle) methodologies like the RUP and the waterfall.
• Created functional requirement documents for the impacting projects
• Utilized Agile/ SCRUM and PMI methodologies to monitor, steer and develop project objectives.

Environment: UML, RUP, Microsoft Office Suite, Microsoft Visio, Unix, Documentum, Windows NT/XP, Oracle, SQL, SQL Server,Agile/Scrum, Sybase, Guidewire, VBScript, C#. DOORS, C++, NET, ASP.NET, COBOL, JCL, Business Objects, TestDirector, LoadRunner

Confidential, Nashville, TN

Business Analyst

Responsibilities:

• Interfaced with the client as part of the Requirements Engineering team to finalize the project scope.
• Assisted the PM in developing Use Cases and project plans and also managed changes to the scope of the project.
• Conducted user interviews, gathered Requirements, analyzed the Requirements and managed changes using Rational Suite.
• Conducted interviews with end-users to collect requirement and business process information.
• Requirements Elicitation, Analysis, Communication, and Validation according to Six Sigma Standards.
• Wrote BRD, FRD, use cases, test scenarios, test cases for testing the functional and non-functional aspects of both ETL jobs and Reporting jobs.
• Working knowledge of implementing software development projects using methodologies such as Waterfall, Rational Unified Process, Agile/Scrum
• Organized and conducted extensive JAD sessions with users to identify, understand and document requirements.
• Distribute Business Process Templates to SME’s for completion prior to validation meetings with SME’s input
• Used SQL to test various reports and ETL load jobs in development, QA and production environment
• Business lead for the implementation of the Guidewire System
• Performed Integration testing, System testing, Regression testing and Performance testing of Billing Center, Policycenter and Paymentmanager in Guidewire application based on the business requirements using LISA.
• Managed and administrated the MS SQL Server 2005 and 2000 servers.
• Implemented data access, storage and validation routines on the database server using Procedural Language/Structured Query Language (PL/SQL).
• Developed business process models in RUP to document existing and future business processes.
• Performed extensive Requirement Analysis including data analysis and gap analysis.
• Prepared requirements document for Commercial Auto, Crime, Worker’s Compensation, Umbrella, Business Owners Policy, Commercial Output Policy, and Commercial Property Package.
• Facilitated SME interviews and assisted in identifying and analyzing the possible technical solutions.
• Designed and developed project document templates based on SDLC methodology.
• Developed business requirement specification documents as well as high-level project plan.

Environment: Microsoft Office Suite, Microsoft Visio, Documentum, UML, J2EE, Windows NT/XP, Oracle, SQL, SQL Server, Sybase, PL/SQL, UNIX, VBScript, C#. NET, ASP.NET, Business Objects, TestDirector, LoadRunner