SUMMARY

• 8 years of Industry experience as a Business Analyst with solid understanding of Business Requirements Gathering, Business Process Mapping Evaluating Data Sources, Translating Requirements into Specifications, Application Design.
• Expert in commercial Property and Casualty and Personal Lines Insurance experience with national carriers.
• Experience in development methodologies like RUP, SDLC, AGILE, SCRUM and Waterfall
• Strong knowledge of Agile
• Proficient in Technical and Business Writing, Business Process Flow, Business Process Modeling, Business Analysis and Testing various methodologies.
• Very good understanding of Business Intelligence and Data Warehousing concepts with emphasis on ETL and Life Cycle Development including requirements analysis, design, development, testing and implementation.
• Experienced in SQL Server Reporting Service (SSRS), Executing Queries and Running Stored Procedures.
• Expert in the Property, Casualty, Annuities, Disability, and Supplemental Insurance policies include administration, sales, customization, claims, pensions and CMS.
• 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.
• Proficient in using Database Connectivity APIs (ADO, ADO.NET,LINQ) in Client Server and Web Applications.
• Experience in Agile methodology and creatinguserstories.
• Extensive experience in developing Use Cases, creating Screen Mockups, conducting Gap Analysis and Impact Analysis, SWOT analysis, Cost Benefit Analysis, Risk Analysis.
• 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.
• Interface with clients from Operations, Marketing, Sales, Technologies, and Outside Vendors and act as their customer interface point as the lead of the Projects.
• Highly motivated team player with excellent Interpersonal and Customer Relational Skills, Proven Communication, Organizational, Analytical, Presentation Skills, and Leadership Qualities.

TECHNICAL SKILLS

Business Tools: Rational Suite (Requisite Pro, Rose, Clear Quest, Clear Case), MS Visio, MS Project, MS Access, MS Office Suite, SharePoint, Visual Paradigm, Doors Erwin Data Modeller 4x, Business Object (Crystal Reports)

Business Skills: Business Definition Requirements, Business Process Analysis, Gap Analysis, Use Case Modelling & Analysis, Business Environment and Market Research Analysis.

Methodologies: RUP, OOAD, Agile, UML & Business/Data Modeling, Waterfall Model

Testing Tools: Win Runner, Load Runner, Test Director, Quick Test Pro, PR Tracker

Operating Systems: Windows XP/95/98/NT/2000, Mac OS X, DOS, UNIX, Linux

Databases: Oracle 8i/9i; SQL Server 7.0 & 2000; Access 2000, MS SQL Server, DB2

Languages: UML, C, C++, HTML, Java, SQL, PL/SQL, ASP.NET

PROFESSIONAL EXPERIENCE

Confidential, NJ

Sr. Business Analyst

Responsibilities:

• Wrote Test Plans in MS Word for Manual Testing, System Testing, Integration Testing, Performance Testing, Regression Testing & reviewed their consistency with the business requirements.
• Created Source to target data mapping documents identifying key data elements and prepared Data Flow Diagrams
• Establish documentation for Agile methodology for implementation with a very water - fall-centric development team
• Developed the ETL Informatica Mappings for importing data from ODS into subsequent data marts.
• Involved in generating Test cases for property and casualty Insurances for Different Levels of Business.
• Analysed the existing as-is system for Insurance Personal Lines, tracked defects, provided recommendations to make enhancements in the future to-be system.
• Participated in UAT and worked with Mercury Quality Center for bug and defect tracking.
• UAT testing performed along with call center managers to make sure that application meets their requirements.
• Performed workflow analysis toward automated disability claims process. Detailed comparison of two competing proposals, including HR interfaces. Facilitated requirements definition for new system.
• Created the Web Publishing configuration using Documentum Administrator for publishing content to the website by using Web Cache.
• Created/Reviewed data flow diagram to illustrate where data originates and how data flows within the Enterprise Data warehouse (EDW).
• Wrote BRD, FRD, use cases, test scenarios, test cases for testing the functional and non-functional aspects of both ETL jobs and Reporting jobs.
• Performed White Box, Black Box, and Usability Testing
• Prepared the Functional and Technical specification documents for transforming the Policy administration application from old legacy mainframe Vantage to Navisys system using the Textpad Macro's and UNIX scripts.
• Utilized Agile/ SCRUM and PMI methodologies to monitor, steer and develop project objectives
• Used BEA (BPM Tool) to map Process flows and migrated Visio Process flows into BEA Tool.
• Performed Requirement Analysis and developed Use Cases, Activity Diagrams using Rational Rose
• Responsible for Data Extraction, Data Compilation, Data Analysis, Data Manipulation and Data Validation using SQL queries in a MS SQL Server 2005 environment
• Used JavaScript for client side validations extensively along with .NET validation controls.
• Designed Functional and Business classes which involve LINQ to SQL/XML, Entity Framework implementation using ORM designer.
• Created screen-mockups using iRise to review the requirements and provide feedback on the screen design. Also, used Microsoft Paint to create ad-hoc screen mock-up to review with the users.
• Prepared PowerPoint slides of all the outcomes with the focus on defects and presented to the team of Business Analyst, VP of Human Resources, and the Developers
• Involved in creation and execution of manual test cases in Mercury Test Director and automated Test Cases in QTP and analyzed the Test Results.

Environment: Windows, MS Office(MS Word, MS Excel, MS Powerpoint, MS Visio), GuideWire, .NET, Oracle, Crystal reports, Mainframes,UNDERWRITING, Agile, COBOL, JCL, Db2, Oracle, Java, Cognos, RUP, UML, SQL, SWOT analysis, GAP Analysis, Win Runner

Confidential, Harleysville PA

Sr. Business Analyst

Responsibilities:

• I was responsible in performing testing for personal lines of business of client which includes both Property and Casualty for various states.
• Wrote Business Cases for the Stakeholders to understand the functioning of the new Underwriting System. involved in mentoring specific projects in application of the new SDLC based on the Agile Unified.
• Managed General Liability, Commercial Property, Commercial Package, Commercial Auto and Workers Compensation policy lines
• Worked on UAT testing and took signoff from the Commercial line of Property & Casualty business users.
• Involved in all stages of testing the Auto & Home Insurance application.
• Conducted user interviews, gathered requirements, analyzed the requirements by using Rational Rose, Visio and Requisite pro - RUP
• Developed Use Cases in Microsoft Visio along with Activity Diagram to present the workflow in a visual form.
• Applyunderwritingresults to groups to determine customer premiums
• Responsible for modeling detailed descriptions for user needs, tracking changes across business applications and data model program functions using Rational Rose.
• Performed extensive data modelling to differentiate between the OLTP and Data Warehouse data models
• Introduced Agile and RUP methodologies to reflect liquid nature of front-office improving time-to-market
• Developed UML Use Cases using Rational Rose and developed a detailed project plan with emphasis on deliverables.
• Collaborate with cross-functional teams to gatherbusinessrequirements related to ongoing development using Agile Estimating and AppliedUserStories
• Collected business requirements to set rules for proper data transfer from Data Source to Data Target in Data Mapping
• Developed project plans and managed project scope.
• Designed and Developed the Business Objects Universes which suit the standard, analytical and ad-hoc reporting requirements of the Business Objects users.
• Designed the universes by creating the Business Objects data model.
• Used SDLC (System Development Life Cycle) methodologies like the RUP and the waterfall.
• Coordinating and Developing QA activities.
• Introduced Agile and RUP methodologies to reflect liquid nature of front-office improving time-to-market
• Conducted presentations of the QA test results with analysis to the stakeholders and users and documented modifications and requirements.
• Designed DataStage ETL jobs for extracting data from heterogeneous source systems, transform and finally load into the Data Marts.
• Supported in the development, analysis and maintenance of automatedunderwritingsystem, web loan boarding process, and system of record and its interface.
• Worked extensively with MS Excel and MS access
• Assisted in building a Business Analysis Process Model using Rational Rose and Visio.
• Performed extensive Requirement analysis and developed use cases and workflows.

Environment: UML, RUP, Waterfall, Mainframes, Agile, COBOL, JCL, Db2, Java/J2EE, Oracle, Rose, MS Word, MS Excel, MS Visio,LoadRunner, UNDERWRITING, WinRunner.

Confidential, Kansas City, MO

Sr. Business Analyst

Responsibilities:

• Gathered high-level requirement for all the external projects in a release.
• 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.
• Prepared graphical depictions of Use Cases, Use Case Diagrams, State Diagrams, Activity Diagrams, Sequence Diagrams, Component Based Diagrams, and Collateral Diagrams and creation of technical design (UI screen) using Microsoft Visio.
• Work closely with production underwriters to review commercial 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.
• Used the DataStage Designer to develop processes for extracting, cleansing, transforms, integrating and loading data into data warehouse database. evelopedbusinessprocesses and established procedures to streamline and improve existing policies, recommended changes and provided structure to implement new efficientworkflow processes
• Responsible for Claims tracking view status of personal lines claims.
• Interacted with other Business Analysts for designing and implementation of Use Cases and Test Plans.
• Executedunderwritingof newbusinessand renewals of stop loss insurance policies for group medical plans
• Responsible for creating different sessions and workflows to load the data to Data Warehouse using Informatica Workflow Manager
• Performed requirements modeling and develop analysis diagrams, activity diagrams, sequence diagrams, state diagrams, data models, and use-case realizations using RUP tools in Agile.
• Worked on Agile methodology of SDLC with working onuserstories.
• Design components based on object-oriented design (Class, Sequence diagrams (UML, OOAD)) using Microsoft Visio.
• Created Data Stage jobs to extract, transform and load data into data warehouses from various sources like relational databases, application systems, temp tables, flat files etc.
• Responsible for special projects requested by company management or reinsurance broker involving analyzing underwriting revenue and financial performance for company’s reinsurance broker.
• Created functional requirement documents for the impacting projects
• Worked with SQL queries using MS Access for data manipulations.
• Facilitated and led JAD sessions aimed at functional requirement walkthroughs for all the impacting projects and updated the documents based on recommendations (if any).
• Reviewed test results and coordinated with testing and development team to correct the issues.

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

Confidential, NH

Business Analyst

Responsibilities:

• Managed and worked on various projects such asInsuranceScoring, Credit Scoring, Rate Revision, and Identity theft.
• Involved in discussions and meetings regarding the architecture and various interfaces for the application.
• Worked onBusinessProcess Modeling Notations (BPMN) and created process designs and work flows
• Interacted closely with various teams and departments including development, testing, andbusiness operations teams to discuss on the requirements and production issues.
• Gathered, analyzed, prioritized and managed the requirements from various departments.
• Worked on Claims handling, Rating Algorithms, rules, and underwriting guidelines of various insuranceproducts.
• Managed various updates including VIN table updates, and Rating factors.
• Analyzed and tested the application while working on the Fixes and Enhancements.
• Created and Reviewed the Test Plans to guide and support the testing effort.
• Analyzed and created the write-ups (documented) to support and guide the development team while working on projects dealing with fixes and enhancements such as Screens Display Modification, Adverse Action Notice, SSN Masking, and SSN Input format.
• Worked on enhancements to the document generation process and designed various documents such as Quote Proposal Letter, Adverse Action Notice, andInsuranceScore Quote Reports.

Environment: indows XP, UNDERWRITING,Agile, MS Project, MS Excel, MS Word, MS Visio, XML, VB, SQL, .Net, SQL Server.

Confidential, IA

Business Analyst

Responsibilities:

• Performed Requirement Analysis by gathering both functional and non functional requirements based on interactions with the process owners & stake holders and document analysis, represented them in Requirements Traceability Matrix (RTM).
• Responsible for the development of a Data Warehouse for personal lines property and casualty insurance.
• Assisted in acquisition integration projects for the Operations department, which included documenting and maintaining processes andworkflows.
• Responsibility included modifications to a customer’s mainframe Vantage system to support new product features or regulatory requirements and, in some cases, involved a system upgrade
• Examined various bottlenecks and points for automation to streamline the claims processing, underwriting and pre- and post-sales process.
• Extensive involved in analysis of data elements from worker's compensation that includes various premium components and its calculations, loss amounts & claim counts.
• Worked closely with the Enterprise Data Warehouse team and Business Intelligence Architecture team to understand repository objects that support the business requirement and process.
• Updating Requirements/Rules for Enterprise Data Warehouse and Business Intelligence Tools.
• Involved in designing and developing Data Models and Data Marts that support the Business Intelligence Data Warehouse.
• Led a large, highly visible project to identify aBusinessProcess Management (BPM) solution to facilitateworkflowand bridge gaps betweenbusinesssystems. Wrote theBusinessRequirements
• Lead multiple project teams of technical professionals through all phases of the SDLC using technologies including Oracle, Erwin, Data Stage, Data Warehousing, Websphere and Cognos.
• 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.
• Collaborated in building a business analysis process model using Rational Rose, RequisitePro, and Visio.
• 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.
• Created GUI specifications with Page flows, page business actions and screen mockups
• Designed, developed, and maintained various Business unit reports by using Teradata, SQL, and Ms Excel.
• Developed Test cases for manual testing and automated them using Win Runner, Silk, Load Runner, Silk performer and QTP.
• Advised various lines ofbusinesseson improvement opportunities involving issues of varying complexity, both on the training front and withworkflowprograms.
• Used Rational Requisite Pro to improve the communication of project goals, enhance collaborative development, reduce project risk and increase the quality of application before deployment.
• Created Process Flow diagrams, Use Case Diagrams, Class Diagrams and Interaction Diagrams using Microsoft Visio and Rational Rose.
• Provided clear and concise documentation regarding requirements management plans, Functional Requirements, supplemental Requirements, Test Plans and Test Cases.
• Conducted UAT to confirm that all derivative products can be successfully processed through stages of the trade life cycle
• Create and maintain requirements, test cases and defects in Mercury Quality Center
• Designed and implemented basic SQL queries for QA testing and report / data validation.

Environment: MS Project, MS Office Suite, RUP, Agile, UML, Rational Rose, Waterfall, Requisite Pro, Clear Case 2002, Rational Clear Quest 2002, MS office suite, UNDERWRITING, MS Visio 2003, SharePoint, Mercury LoadRunner, Mercury Testdirector