PROFESSIONAL SUMMARY:

• 8 years of Industry experience as a Business Analyst with solid understanding of Business Requirements Gathering, Evaluating Data Sources, Translating Requirements into Specifications, Application Design.
• Diverse experience in Financial Services/Insurance/Healthcare.
• Proficient in Technical and Business Writing, Business Process Flow, Business Process Modeling, Business Analysis and Testing various methodologies.
• Expertise in Project Management i.e. Project Scoping, Planning, Estimating, Scheduling, Organizing, Directing, Controlling, Budgeting and Drafting Remedy Procedures.
• 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.
• Very strong knowledge of Commercial lines Property and Casualty Insurance including both policy and claim processing and reinsurance.
• 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.
• Experience in development methodologies like RUP, SDLC, AGILE, SCRUM and Waterfall
• Object Oriented Analysis and Design (OOA/D).
• Responsible to Track, Document, Capture, Manage and Communicate the Requirements using Requirement Traceability Matrix (RTM) which helped in controlling numerous artifacts produced by the teams across the deliverables for a project
• Involved in Test Planning, Test Preparation, Test Execution, Issue Resolution and Report Generation to assure that all aspects of a Project are in Compliance with the 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.
• 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:

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 RequisiteProDocumentum

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, IL

Sr. Business Analyst

Responsibilities:

• Analyzed clients systems and business processes.
• Prepared requirements document for Commercial Auto, Inland Marine, Crime, Worker’s Compensation, Umbrella, Business Owners Policy, Commercial Output Policy, and Commercial Property Package.
• Shopping for an annuity, start with basic insurance. It is called a “single premium, immediate, lifetime annuity with death benefit.
• Also responsible for managing communication and expectations of system vendor, the former parent company IT and business departments, and Allied Worlds various business units
• (underwriting, claims, reinsurance, actuary, accounting, and IT)
• Very strong knowledge of Commercial lines Property and Casualty Insurance including both policy and claim processing and reinsurance.
• Applications tested were integrated to mainframe Vantage system which included business applications for new sales, policies, quotes, and web based applications
• Gathered information for business requirement documents for both current and future state on annuity
• 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.
• 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.
• An insurance product that features a predetermined periodic payout amount until the death of the annuitant. These products are most frequently used to help retirees budget their money after retirement.
• Responsible for converting for Mutual Life Insurance, the Fixed and Variable Annuities PC administrative system to the mainframe Vantage.
• Researched the various steps in the lifecycle and then constructed the system in a way that the high risk customers would be easily identified and monitored.
• Established traceability matrix using Rational Requisite Pro to trace completeness of requirements in different SDLC stages.
• Designed and developed Project document templates based on SDLC methodology
• Assure that all Artifacts are in compliance with corporate SDLC Policies and guidelines
• Involved in Scrum development process and prepared Sprint burn down chart, product catalog and sprint backlog contain Business Requirements and supporting documents that contain the essential business elements and definitions as well as the tasks to be completed.
• Used Test Director and Mercury Quality Center for updating the status of all the Test Cases & Test Scripts that are executed during testing process.
• Performed Load and Stress Testing using Load Runner.
• Automated confidence tests that run on new builds on regular basis.
• Involved in setting up different configuration environment for compatibility testing and manual testing.
• 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
• Upgraded the existing Test Scripts and created new scripts for client application to be able to work for new versions and patches, which improved product quality.
• Evaluated testing results for each potential release build using Test Director, Quality Center and Bugzilla reports, listing summarized bug information in priority sequence, recommended viability of release for production.
• Conducted presentations of the QA test results with analysis to the stakeholders and users and documented modifications and requirements.
• Worked extensively with MS Excel and MS access.
• The prices of life annuities are composed of the money invested in the annuity but also the premium paid for these insurance components, so the more insurance components, the more expensive the annuity will be.
• Created Use Case Diagrams, Activity Diagrams, Sequence Diagrams and ER Diagrams in MS Project.
• Involved in project management using MS Project.
• Responsible for acting as a liaison with operational and financial management, systems support and sales to identify business opportunities. Developed a file of ACORD Forms used as the standards in all Property and Casualty markets, for both Personal and Commercial Lines of Business.
• Implement and maintain Property & Casualty (e.g. bug-fix, data integration, version release) systems of assigned customers.
• Provided key input in working with users in defining project and system requirements.

Environment: Mainframes, COBOL, JCL, Db2, Oracle, Rose, MS Project, MS Word, MS Access, MS Excel, MS Visio, UAT, LoadRunner, WinRunner

Confidential, RI

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.
• Each type of life annuity has its own advantages and disadvantages, depending on the nature of the annuitant.
• Developed a file of ACORD Forms used as the standards in all Property and Casualty markets, for both Personal and Commercial Lines of Business
• Involved in Risk Assessment for each project.
• 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.
• Negotiated with teams from projects to decide if modules should be implemented independently, or Parallely
• Lead JAD Sessions, business requirement analysis, project estimations, implementation analysis, GUI design, technical and functional specifications, including data mapping for Insurance, Reinsurance, Fixed Income Products (Annuities) and Suspicious Activity Monitoring
• Performed custom data conversions and developed custom software for risk management applications including general claims, vehicle accident and administrative tracking. Performed all data field mappings.
• Completed the documentation of Claims Scenario’s for the source system
• Analyzed the existing claims process and specific business rule logic will be applied in the ACP model
• Communicate with Customer Service on ACORD Forms design and other technical problems
• Used SDLC (System Development Life Cycle) methodologies like the RUP and the waterfall.
• 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.
• Designed and developed use cases, activity diagrams, and sequence diagrams using UML.
• Used the DataStage Designer to develop processes for extracting, cleansing, transforms, integrating and loading data into data warehouse database.
• Develop Logical and Physical data models that capture current state/future state data elements and data flows using Erwin.
• Worked on Commercial lines Property and Casualty Insurance including both policy and claim processing and reinsurance
• Thoroughly studied the requirements for the process re-engineering
• Developed test plans with QA team and helped to develop test cases for system testing, integration testing and performance testing.
• Created and managed project templates, use case templates, requirement types and tractability matrix in Requisite Pro
• Analysis of business requirements and system requirements of the client and also for Property and casualty modules
• Documented and delivered Functional Specification Document to the project team.
• Used MS Project to manage schedules, deadlines and resources and collaborate on the project.
• Interacting with the developers on resolving the reported bugs and various technical issues.
• Assisted the QA team in designing the Test Plan and Test Cases for User Acceptance testing.

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

Confidential, Cleveland, OH

Business Analyst

Responsibilities:

• Reviewed and analyzed the business environment and identified process improvements.
• Interacted with Business Users to conduct thorough Requirements Analysis.
• Implemented Web Services (SOAP, UDDI and WSDL) to integrate different applications.
• Perform GUI, Integration, white box, middle ware and web service testing.
• Implemented the entire Rational Unified Process (RUP) methodology of application development with its various workflows, artifacts and activities.
• Analyzed Business Requirements performed gap analysis and segregated them into high level and low level Use Cases, Activity Diagrams / State Chart Diagrams using Rational Rose according to UML methodology thus defining
• Created use-case scenarios and storyboards in MS Word and MS PowerPoint for better visualization of the application and managed them using Rational Requisite Pro.
• Advanced ad-hoc and standard report development, including data analysis through the use of Oracle Discover, Business Objects, TOAD, Excel, Access, SPSS, SQL, and Oracle Reports.
• Assist other project teams with data analysis, data mining and data profiling as needed
• Implemented new integrated Savings, CD, IRA system; new Leasing system; first Consumer Loan Securitization; numerous acquisitions; new Credit Scoring system; new Commercial Loan Accounting system; new Collections system
• Defined web service interfaces using WSDL and XML schemas
• Met with stakeholders and users to review / manage expectations and identify opportunities to improve ROI.
• Involved in interactions with the Subject Matter Expert, Project Manager, Developers, and the End-Users.
• Dealt with the Society for Worldwide Interbank Financial Telecommunication (SWIFT) in creating the criteria for the auditing of the TQR and Q-Gate review processes.
• Coordinated activities with project manager and various other teams using MS Project.
• Interacted with other Business Analysts for designing and implementation of Use Cases and Test Plans.
• Assisted in on-going process improvement efforts to ensure Test Planning, Execution, and Reporting is effective, efficient, standardized, coordinated, and integrated.
• Assisted the Senior Business Analyst in writing Functional Requirement Specifications (FRS) and User Requirement Specification (URS).
• Involved in gathering and preparing the requirements documents for replacing the existing commercial lines of businesses from legacy to web-based system
• Developed Test Plans and Test Cases according to Business Requirements.
• Provided clear and concise documentation regarding requirements management plans, Functional Requirements, supplemental Requirements, Test Plans and Test Cases.
• Acted as User Acceptance Testing coordinator and monitored business testing and interfaced with the development team regarding defect status and fixes on a daily basis.
• Involved in generation and execution of SQL queries.

Environment: Microsoft Office Suite, MS Visio, Java, C, Windows NT, JavaScript, UNIX, HTML, Oracle, SQL, Mercury TestDirector, Mercury LoadRunner

Confidential, Newark, NJ

Business Analyst

Responsibilities:

• Analyzed clients systems and business processes.
• Conducted user interviews, gathered requirements, and analyzed the requirements by using Rational Rose, Visio and Requisite pro - RUP Established a Business Analysis methodology around the Rational Unified Process.
• The purchase of an insurance or annuity product is not a condition of any bank loan, service or product.
• Researched the various steps in the lifecycle and then constructed the system in a way that the high risk customers would be easily identified and monitored.
• Streamlined clerical work processes and mapped then into the new system.
• Developed project plans and managed project scope.
• Assigned tasks among development team, monitored and tracked progress of project following Agile methodology
• 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
• Designing and customizing data models for Data warehouse supporting data from multiple sources
• Expertise in development of High level design, Conceptual design, Logical and Physical design for Database, Data warehousing and many Distributed IT systems
• Coordinating and Developing QA activities.
• Assisted in creating a High level Request for Proposal (RFP).
• Conducted presentations of the QA test results with analysis to the stakeholders and users and documented modifications and requirements.
• Conducted UAT; facilitated discussion between business team and QA team on determine the test requirements and pass/fail criteria; documented and reported user feedbacks to management team.
• Worked extensively with MS Excel and MS access
• Responsible for acting as a liaison with operational and financial management, systems support and sales to identify business opportunities. Developed a file of ACORD Forms used as the standards in all Property and Casualty markets, for both Personal and Commercial Lines of Business.
• Collected & documented the 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
• Played a key role in the planning, User Accepted Testing, and Implementation of system enhancements and conversions.
• Responsible for continuous process improvement by using SDLC methodology
• Participated in integrating Prudential’s purchase of All states Variable Annuity business. This effort entailed interviewing technical and senior management staff
• Implement and maintain Property & Casualty (e.g. bug-fix, data integration, version release) systems of assigned customers.
• Involved in creating reports for the end users using Crystal reports from the gathered requirements.
• Provided key input in working with users in defining project and system requirements.
• Developed strategic partnerships with the business units to develop a solid knowledge base of the business line; including the business plan, products, and process and revenue streams.
• Managed the development and implementation of the Independent Agent payroll system, Property & Casualty Specialist compensation system, Telesales compensation system, contingent and bonus compensation system and several compensation contract agreements with the Confidential agency sales force
• Documented and delivered Functional Specification Document to the project team.
• Conducted JAD sessions for communicating with Stakeholders and Project directors.
• Developed business requirement specification documents as well as high-level project plan.
• Assist the PM in setting realistic project expectations and in evaluating the impact of changes on the organization and plans accordingly and conducted project related presentations.
• Conducted benchmarking activities to identify best practices.

Environment: Mainframes, COBOL, JCL, Db2, Oracle, Rose, Crystal Report, MS Word, MS Excel, MS Visio, SDLC, RUP, UML, UAT.LoadRunner, WinRunner

Confidential, Moosic, PA

Business Analyst

Responsibilities:

• Worked with the account managers, managements, and report requestors to gather requirements, get report requests.
• Responsible for converting for Mutual Life Insurance, the Fixed and Variable Annuities PC administrative system to the mainframe Vantage.
• Wrote Business Requirements, analyzed them and tested them.
• Each type of life annuity has its own advantages and disadvantages, depending on the nature of the annuitant.
• Managed the output requirement project for various Life insurance products
• Managed the development and implementation of the Independent Agent payroll system, Property & Casualty Specialist compensation system, Telesales compensation system, contingent and bonus compensation system and several compensation contract agreements with the Confidential agency sales force
• 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
• 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.
• Identified Use cases from the Functional requirements and wrote Use Case Specifications and created business process workflow diagrams (Activity diagrams, Sequence diagrams, Collaboration diagrams)
• Extensive use of MS Office tools like MS Access, MS Word, MS Excel, MS PowerPoint MS Project for data migration in to the CI System Knowledge Data Base in Microsoft SharePoint Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, OOD using UML
• Designed workflows and allocated permissions within SharePoint.
• The new system will provide with an underwriting platform to automate policy administration functions.
• Conducted Functional Walkthroughs, User Acceptance Testing (UAT), and supervised the development of User Manuals for customers.
• Also responsible for managing communication and expectations of system vendor, the former parent company IT and business departments, and Allied Worlds various business units (underwriting, claims, reinsurance, actuary, accounting, and IT)
• Interacted with business partners to perform the Initial Project Analysis define new and document retail sales reporting requirements and Change Requests (CRs) in Borland CaliberRM.
• Involved in development & documentation of Software Requirements Specification (SRS) using Borland Caliber RM.
• Prepared Need Analysis Documents of the requirements gathered through JAD sessions.
• Performed Gap Analysis to check the compatibility of the existing system infrastructure with the new business requirements.
• Reviewed Requirements & deliverables for delivery timeline.
• Used MS Visio to create Flow diagrams and Use Case Diagrams.
• Prepared Functional Design Specifications employing Use case scenarios, sequence diagrams, ERD’s, DFD’s and class diagrams.
• Involved with the technical team in understanding the XML file format required for Split loss process and Billing process.
• Worked on broad range of technologies, including business process tools such as Microsoft Project, Primavera, Promodel, MS Excel, MS Access, MS Visio, technical assessment tools, MicroStrategy Data Warehouse Data Modeling and Design
• Interaction with underwriters to understand multiple data points. Prepared data flow diagrams using MS Visio for better clarity and to ensure documented process
• Wrote Test Cases in Mercury Quality center that would test various Test scenarios.
• Wrote Test plan and Test cases for the Integration testing and system testing.
• Wrote Business Cases for the Stakeholders to understand the functioning of the new Underwriting System.
• Performed Business Process Mapping and performed AS-IS and TO BE analysis
• Modified System flow diagrams using SDLC.
• Worked with ETL team during the upload process.
• Helped with Data Mapping between the data mart and the Source Systems.