SUMMARY

• Over 7 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 Modelling, Business Analysis and Testing various methodologies.
• Knowledge in the ETL (Extract, Transform and Load) of data into a data ware house/date mart and Business Intelligence (BI) tools like Business Objects Modules (Reporter, Supervisor, Designer, and Web Intelligence).
• Very strong knowledge of Commercial lines and claim processing and reinsurance.
• Strong understanding of project life cycle and SDLC methodologies including RUP, RAD, Waterfall and Agile.
• Expert in the Property, Casualty, Life Insurance, Annuities, Disability, and Supplemental Insurance policies include administration, sales, customization, claims, pensions and CMS.
• Used Query Analyser, Execution Plan to optimize SQL Queries.
• Expertise in development of High level design, Conceptual design, Logical and Physical design for Database, Data warehousing and many Distributed IT systems
• Strong business domain knowledge of Property and Casualty Insurance including risk, Policy Sales, Policy Administration System, Billing System, Receivables and Payments, across different lines of business.
• 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.
• Proven experience in driving various life cycle stages of an ITIL project from Service Transition, Service Operation to Continual Service Improvement using ITSM and Lean Six Sigma best practices
• 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.
• Strong experience in conducting User Acceptance Testing (UAT) and documentation of Test Cases. Expertise in designing and developing Test Plans and Test Scripts.
• Interface with clients from Operations, Marketing, Sales, Technologies, and Outside Vendors and act as their customer interface point as the lead of the Projects.

TECHNICAL SKILLS

Operating Systems: Windows 95/98/NT/XP/Vista, Linux

Languages: C, C++, SQL, HTML, XML

Database: SQL Server, Oracle, MS - Access

Testing: Win Runner, Load Runner, Quick Test Pro, Test Director, Rational Tools

Methodologies: Rapid Action Development (RAD), Joint Application Development (JAD), Rational Unified Process (RUP), Unified Modelling Language (UML), System Development Life Cycle (SDLC), Waterfall Model, Crystal Reports, Visual Source Safe.

Documentation Tools: MS - Office Suite (Word/Excel/Power Point), MS - Visio, MS - Project, Guidewire

Other Tools: Informatica, Adobe Photoshop, Dreamweaver4.0.

PROFESSIONAL EXPERIENCE

Confidential, OH

Business Analyst

Responsibilities:

• Analyzed clients systems and business processes.
• Managed General Liability, Commercial Property, Commercial Package, Commercial Auto and Workers Compensation policy lines.
• GuideWire Claim Center is the project which was undertaken to upgrade the current Claim System to track its claim for both their owned Policy holders and third party applications.
• Provide support across different domain areas such as Auto Assignment, Payments, Claims Data and Appointment Logs, Auto Estimations, Fire Claims etc.
• Analyzed the business rules for Auto claim assignments throughout the US, so as to have balanced work load for all the claims reps.
• Work on the key products comprises of Billing System, Insurance Claims Processing and Policy Administration System. This web based application can be customized as per client's business requirement. RENAISSANCE BILLING SYSTEM is an integrated web based P&C Insurance billing system.
• This application with Insurance billing modules like Account / Policy Billing, Third Party (Agency) Billing, List/Group Billing was a complete billing system for P&C Insurance companies.
• Prepared requirements document for Commercial Auto, Inland Marine, Crime, Worker’s Compensation, Umbrella, Business Owners Policy, Commercial Output Policy, and Commercial Property Package.
• Implemented the Electronic Funds Transfer feature in the billing system based on client request.
• Developed a file of ACORD Forms used as the standards in all Property and Casualty markets, for both Personal and Commercial Lines of Business.
• Responsible for testing the Quote & Online Purchase for both Auto and Home Property Insurance of the customers.
• Responsible for gathering and documented the business requirement and identified enhancements.
• 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 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.
• Actively involved in validating the requirements and applying the RUP framework throughout the SDLC.
• Used SDLC (System Development Life Cycle) methodologies like the RUP and the waterfall.
• Worked extensively with MS Excel and MS access
• Performed Requirement Analysis to Develop Use Cases, Activity Diagrams and Sequence Diagrams.
• Hence developed and documented conceptual design of Application in System Specification Document.
• Also Performed the as-is and to-be business processes, business rules, business and system requirements, user and system interface requirements.
• Integrated Rational Requisite Pro with Rational Rose, Clear Quest and Clear Case to provide the visibility to the teams and maintain traceability among Requirements, Use Cases, Change Requests and Configuration Changes.
• Data mapping, logical data modelling, created class diagrams and ER diagrams and used SQL queries to filter data within the Oracle database.
• Wrote Test plan and Test cases for the Integration testing and system testing.
• Designed the business requirement collection approach based on the project scope and SDLC Methodology.
• Clarified QA team issues and reviewed test plans and test scripts developed by QA team to make sure that all requirements will be covered in scripts and tested properly.
• Responsible writing Test Plans, Test Cases and Test Scripts using manual and automated testing tools from Rational and Mercury Interactive such as test Director, Win runner.
• Used Test Director and Mercury Quality Center for updating the status of all the Test Cases & Test Scripts that are executed during testing process.
• Conducted JAD sessions for communicating with Stakeholders and Project directors.

Environment: Mainframes, COBOL, .NET, Rational Suite Agile, JCL, Db2, XML, Guidewire, Quality Center, Oracle, Rose, MS Word, MS PowerPoint, MS Excel, MS Visio, Load Runner, Win Runner

Confidential, RI

Business Analyst

Responsibilities:

• Established a RUP (Rational Unified Process) 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.
• Prepared Business Context Diagram, Use Case diagrams and corresponding Activity Diagrams using Rational Rose to depict the workflows to be incorporated into the development of Pega Business Process Management (BPM) tool.
• Responsible for the development of a Data Warehouse for personal lines property and casualty insurance.
• Prepared requirements document for Commercial Auto, Inland Marine, Crime, Worker’s Compensation, Umbrella, Business Owners Policy, Commercial Output Policy, and Commercial Property Package.
• 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.
• Analyzed standard industry practices of back office applications of Insurance Company, underwriting, billing, policy and claims administration with the help of Subject Matter Expert.
• Designed and Customized data models for Data warehouse
• Completed the documentation of Claims Scenario’s for the source system
• Worked on Commercial lines Property and Casualty Insurance including both policy and claim processing and reinsurance.
• Facilitated the User Acceptance Testing (UAT) with Pega System Administrators and Business Users, documented any issues or defects and eventually got sign off from the right parties.
• Exposed to Agile methodology.
• Designed the business requirement collection approach based on the project scope and SDLC methodology.
• Developed Data Flow Diagrams and Data mapping agreement, illustrating the flow of data from the front end GuideWire Claim Center into the Application database Tables.
• Processed annuitant transaction to move their payout investment from one separate account to another
• Experience in managing the changes in requirements by Unified Change Management Tools (UCM) like Rational Clear Quest.
• Tested validity and integrity of the calculation engines for Deferred Annuities, Past Services Pension adjustments.
• Design and develop the 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 the use cases and issue logs.
• 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.
• Helped design scope documents and the Request for Proposal (RFP) after extensive ROI analysis and coordinated with top management for the approval process.
• Functioned as the primary liaison between the business line, operations, and the technical areas throughout the project cycle. Worked with ODS and OLAP system. Worked with Data Extraction, Transformation and Loading. Metadata architecture was also provided, for the purposes of query enhancement and clarification of data relationships. Also built the foundation for process implementation in MS-SQL.
• Conducted mass user interviews with brokers, enterprise user representatives and SMEs.
• Worked extensively with MS Excel
• Partnered with the technical areas in the research and resolution of system and process problems especially related to Power Builder platform.
• Provide customer service and support for Property & Casualty risk management needs
• Played a key role in the planning, testing, and implementation of system enhancements and conversions.
• Performed analysis on enterprise data/report integration & provided functional specification to development team to build Enterprise Reporting Systems.
• Guided development team in the Oracle 9i based database.

Environment: Windows, MS Office(MS Word, MS Excel, Rational Suite MS PowerPoint, MS Visio), .NET, Oracle, Crystal reports, RUP, UML, SQL, SWOT analysis, GAP Analysis, Guidewire, Win Runner

Confidential, Silver Spring, MD

Business Analyst

Responsibilities:

• Networked with Subject Matter Experts, Project Manager, Developers, and Process Analysts to understand the business process, gathered Business Requirements and identified enhancements.
• Facilitated various sessions like JAD, JRP, JAM and RAD throughout the project.
• Planned and defined system requirements to Use Cases, Use Case Scenarios and Use Case Narratives using the UML methodologies. Created Process Diagrams, Use Case Diagrams, Activity Diagrams, Sequence Diagrams in MS Visio, created Wire Frames during the Elaboration Phase.
• Worked with underwriting department to evaluate risk, exposure of potential clients and also measured risk exposure and determined premium.
• Examined various bottlenecks and points for automation to streamline the claims processing, underwriting and pre- and post-sales process.
• Worked heavily on Union workers compensation obligations and their processing with thorough investigation.
• Heavily involved in building Disaster Recovery Plan (DRP) and formulated Business Continuity Plan (BCP).
• Extensively developed project documentation, process flow documents, formal proposals, RFQ’s and RFP’s.
• Authored Requirement Documents and analysed the possible solutions, gathered business requirements from SME’s and translated them into functional, non functional and technical requirements and quoted them into Business requirements document.
• Facilitated design reviews, peer reviews, sponsor reviews and user acceptance reviews through meetings, presentations and surveys for top level management, IT team, Business Team and business users.
• Interacted closely with End users from Underwriting & Claims teams and SMEs to understand and gather the business needs and requirements.
• Suggested and evaluated technical alternatives for the issues to the IT leads, stakeholders and business users with establishing consensus through various sessions.
• Formulated methodologies and developed SDLC phases, strategies, time & cost estimates with milestones for each phase.
• Performed root cause analysis and business impact analysis and communicated impacts of systems and projects throughout the company to various teams.
• Utilized SharePoint with a functional understanding in custom views, task lists, rpts, collaboration and Portal.
• Developed strategic business solutions which included: mission statements, value propositions, critical success factors, work break down structure, statements of work, project management,gap and risk analysis, process re-engineering, facilitated functional design meetings and documenting requirements, use cases and change management.
• Carried out OOAD (Object oriented analysis and design) to model the system architecture into a group of interacting objects by using UML.
• Involved and assisted in migration of frameworks like PHP to ASP and ASP to ASP.Net.

Environment: Oracle, Microsoft SQL, Rational Suite, XML, Visual Basic 6.0, Rational RequisitePro, MS Visio, MS Project, RUP, Windows 2000, vb.net

Confidential, Kansas City, MO

Business Analyst

Responsibilities:

• Performed Gap Analysis to check the compatibility of the existing system infrastructure with the new business requirements.
• Led project team for online purchase and implementation of RAD tools to establish data warehouse and Intranet processing concepts to consolidate data, enable access across various platform configurations, and replace legacy applications.
• Correspondence included solicitation letters, financial transaction confirmations, and quarterly and annual policy statements.
• Interacted closely with End users from Underwriting & Claims teams and SMEs to understand and gather the business needs and requirements.
• Utilized corporation developed Agile SDLC methodology. Used Scrum Work Pro and Microsoft Office software to perform required job functions.
• Very closely involved in all phases of SDLC from gathering requirements to testing.
• Authored the product backlog for the complete project, derived User Stories for individual iterations, assigned tasks and allocated appropriate resources for completion and acceptance of individual stories
• Created Use Case Diagrams, Activity Diagrams, Sequence Diagrams and ER Diagrams in MS Project.
• Assisting in developing object models from the functional requirements and architecture using UML methodologies and modeling tools knowledge Rational Unified Process (RUP).
• Prepared Business Context Diagram, Use Case diagrams and corresponding Activity Diagrams using Rational Rose to depict the workflows to be incorporated into the development of Pega Business Process Management (BPM) tool.
• Worked extensively with MS Excel and MS access
• Used XML for building and parsing of Application Configuration file.
• Involved in translating business requirements and user expectations into detailed specifications employing Unified Modelling Language (UML) in an SOA environment.
• Assist with user testing of systems (UAT), developing and maintaining quality procedures, and ensuring that appropriate documentation is in place.

Environment: J2EE technology, Test Director, Rational Suite, Windows 2000 Advanced Server, XML, UNIX / Oracle Platform, MS Visio, RUP 2002, Rational RequisitePro.

Confidential, Moosic, PA

Business Analyst

Responsibilities:

• Played key role in System Development Life Cycle (SDLC) Process consisting of: Design and Gap Analysis, Business Requirements, Systems Requirements, Test
• Analysis of business requirements and system requirements of the client and also for Property and casualty modules
• Criteria and Implementation to have the outputs of project dealt with the automation of correspondence directed to Insurance policy owners.
• Worked on data modelling and produced data mapping and data definition documentation
• Used MS SharePoint for the purpose of managing documents and for hosting websites which was used to access shared work spaces and documents.
• Created use case scenarios and documented work flow and business process.
• Assisted to develop the Test Plan, Test Cases and Test Scenarios to be used in testing based on Business Requirements, technical specifications and/or product knowledge.
• Assisted in building a Business Analysis Process Model using Rational Rose and Visio.
• Worked with systems area to translate business needs into system requirements.
• Coordinated defects routing in the team and created Excel macros to generate daily defects report status from Quality centre across multiple teams.
• Involved in the testing phase right from the Unit testing to the User Acceptance testing.
• Use Cases and other Process Flow Models were designed using Visio and Rational Rose.

Environment: Rational Enterprise Suite (Rose, RequisitePro, Clear Case, Clear Quest), Java,, Quality Center, Oracle,, SQL Server Reports, Win Runner, Load Runner, Quick TestPro