SUMMARY

• 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.
• Diverse experience in Insurance industry.
• Proficient in Technical and Business Writing, Business Process Flow, Business Process Modeling, Data 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.
• 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.
• Strong understanding of project life cycle and SDLC methodologies including RUP, RAD, Waterfall and Agile.
• Experience in writing SQL queries and optimizing the queries in Sybase, Oracle and SQL Server 2000.
• Extensive experience in all aspects of consumer and real estate loan origination, underwriting and collections. Training and some experience in commercial lending, including financial statement and cash flow analysis.
• Extensive success in translating business requirements and user expectations into detailed specifications employing Unified Modelling Language (UML) in an SOA environment.
• Formulate project proposals, planning, organizing, and managing resources while insuring the successful completion of specific project goals and objectives for our clients Guidewire, HPM Networks and Infoparters.
• 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
• Competent in Creating Unified Modeling Language (UML) diagrams such as Use Case Diagrams, Activity Diagrams, Class Diagrams and Sequence Diagrams.
• Extensive experience with Content Management tools such as Interwoven, Filenet, Sharepoint and Documentum
• 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.
• Worked with Rational Suite of tools to create requirements documents (Requisite Pro), visual data models (Rose), manage and track defects (Clear Quest).
• Experienced in developing Work Flows and Activities, Rule based Business Process Management using Pega Rules Process Commander (PRPC), Decision tables, Decision Maps, Declarative expressions, Constraints, and Indexes.
• 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

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

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

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

Methodologies: RUP, OOAD, AGILE, UML & Business/Data Modeling

Systems Analysis: Requirement analysis, business rules, data flow diagram, flowcharts, business process modeling & improvement, gap analysis, cause and effect analysis, decision tree, BRD, BRS

Bug Tracking Tools: Mercury TestDirector, Rational ClearQuest

Content Management Tools: Documentum, Sharepoint, Interwoven, Filenet

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

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

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

PROFESSIONAL EXPERIENCE

Confidential, Keene, NH

Business Analyst

Responsibilities:

• Design and Architecture using BEA Weblogic’s latest features like Web Portal, Page Flow, Process Control, Java Control and Web - Services using Weblogic development IDE Workshop on Oracle database
• UAT testing performed along with call center managers to make sure that application meets their requirements.
• Responsible for the development of a Data Warehouse for personal lines property and casualty insurance.
• Responsible for gathering requirements, creating artifacts for Rational Unified Process (RUP) - use cases, system architecture document, supplemental requirements document, architecture diagrams; verifying technical production infrastructure; designing and executing performance tests; and documentation.
• Involved in creating automated Test Scripts representing various Transactions, Documenting the Load Testing Process and Methodology. Created meaningful reports for analysis and integrated the Performance Testing in the SDLC.
• Created RUP activity diagrams and sequence diagrams to analyse the requirements and recommend solutions.
• Prepared the project technical documentation in diagrams, flowcharts, sitemaps with detailed description with using Wireframes.
• Provided defect and test status reports to the project management team periodically through Rational Team Concert (RTC).
• Extensively used Ms SharePoint a content management platform, for managing content across the organization within a shared repository.
• Developed the workflow to produce the output for the user in Pega Systems using html.
• Responsible for creating test scenarios, scripting test cases using testing tool and defect management for Policy Management Systems, Payables/Receivables and Claims processing.
• Participated in the identification, understanding, and documentation of business requirements, including the applications capable of supporting those requirements.
• Identified Use Cases from the requirements. Created UML Diagrams including Use Cases.
• Interact with business users and provide Business Requirements, including identification of opportunities for Improvement and Optimization of Business Processes.
• Interfaced with the development team utilizing ASP, JavaScript and Visual Basic and produced detailed user-interface prototypes and performed usability testing.
• 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.
• Created automated Load test scripts using Load Runner.
• Analyzed system requirements and developed Test Plans, involved in developing Test Script for manual testing
• Assisted the IT team to develop service oriented architecture (SOA), and data warehouse system to utilize data mining for data analysis.
• Assisted PM in Developing Project plan and tracking project Process, Scheduling and organizing group meeting, as well as developed Risk Management Plan
• Provided clear and concise documentation regarding requirements management plans, Functional Requirements, supplemental Requirements, Test Plans and Test Cases.
• Developed test plans with QA team and helped to develop test cases for system testing,
• Create and maintain requirements, test cases and defects in Mercury Quality Center
• Maintained a close and strong working relationship with teammates, developers, testers and management staff by conducting regular one-to-one sessions and group meetings.
• Developed Business Requirement Documentation, Functional Specification Documentation, High Level Testing Plan, etc
• Involved in preparing a simple and detailed User manual and assisted training session of the new and improved system.

Environment: Windows, MS Office(MS Word, MS Excel, MS Powerpoint, MS Visio), .NET, Oracle, Crystal reports, RUP, UML, UAT, FVT, SQL, Agile,SWOT analysis, GAP Analysis, Win Runner, Team site Content Management Tool.

Confidential, Harrisburg, PA

Business Analyst

Responsibilities:

• Conducted user interviews, gathered requirements, analyzed the requirements by using Rational Rose, Visio and Requisite pro - RUP
• Gathering and documenting the requirements that are critical to the business mission and using those requirements to design application software using a Use Case in Requisite Pro.
• Established a Business Analysis methodology around the Rational Unified Process.
• Gathered requirements for business process flow and on screen flow for wizards driven products from products SME's and Sales people and created Requirements documents to implement in Pega PRPC.
• Interacted with client and the Technical Team for requirement gathering and translation of Business Requirement to Technical specifications.
• 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.
• Authored progress and completion reports which were then submitted to project management on a weekly basis in MS project.
• 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.
• Proven expertise in creating test plans, UML diagrams, flowcharts, screen mockups and systems requirements specifications.
• Worked in mainframe environment and used SQL to query various reporting databases.
• 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
• Worked with project management to analyze change requests to determine what is being requested and programming required.
• Formulate project proposals, planning, organizing, and managing resources while insuring the successful completion of specific project goals and objectives for our clients Guidewire, HPM Networks and Infoparters
• Conducted presentations of the QA test results with analysis to the stakeholders and users and documented modifications and requirements.
• Created source table definitions in the DataStage Repository by studying the data sources by importing the data from Mainframe.
• Adhere to the firm’s SDLC process and represent as the application business analyst
• Identify customer marketing opportunities by applying data mining models and writing advanced T-SQL stored procedures and queries.
• 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.
• Development to support Internet screen applications for a large project to rewrite the underwriting system.
• Designed and Customized data models for Data warehouse
• 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.
• Assisted in building a Data 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.
• Provided key input in working with users in defining project and system requirements.
• 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 MetLife agency sales force
• Documented and delivered Functional Specification Document to the project team.
• Conducted JAD sessions for communicating with Stakeholders and Project directors.

Environment: UML, RUP, Mainframes, COBOL, JCL, Agile,Db2, Oracle, Java/J2EE Rose, MS Word, MS Excel, MS Visio,LoadRunner, WinRunner, Windows NT 4.0,UNIX

Confidential, IL

Business Analyst

Responsibilities:

• Performed Gap Analysis to check the compatibility of the existing system infrastructure with the new business requirements.
• Participated in developing Source to Target mappings using ETL process into new Oracle database system.
• WriteNow is an easily used, Web-based underwriting system that allows agents, brokers, insurers, consumers and other users to qualify, rate, quote, bind and deliver policy documents virtually in minutes.
• Designed new database tables to meet business information needs. Designed Mapping document, which is a guideline to ETL Coding.
• Created custom content management system using Perl & MySQL to improve content updating and integrity.
• Followed solely RUP methodologies during the course of the project.
• Involved in prioritizing the defects and writing business requirements to resolve them.
• Conducted JAD sessions with management, SME, vendors, users and other stakeholders for open and pending issues.
• Developed RIA (Rich Internet Application) modules using Adobe Flex along with Java for Account Reporting (AR) and Billing web applications.
• Rational Rose to depict the workflows to be incorporated into the development of Pega Business Process Management (BPM) tool.
• Designed and Customized data models for Data warehouse
• Write and execute positive and negative test cases to ensure the data originating from the data warehouse (Oracle dB) is accurate through to the SQL dB in the applications.
• Gathered requirements and modeled the data warehouse and the underlying transactional database
• Responsible for identifying, documenting and testing the data mapping feeds from several reference data systems, to risk applications
• Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data within the Oracle database
• Defined and documented a clear set of policies and procedures for all facet of operation for all personnel.
• Conducted interviews, meetings and JAD sessions during the process of Requirement Gathering
• Well versed in project management tools like MS Project for project planning, Project scheduling.
• Implemented Web Services (SOAP, UDDI and WSDL) to integrate different applications.
• Utilized corporation developed Agile SDLC methodology. Used ScrumWork Pro and Microsoft Office software to perform required job functions
• Worked on Performance, Tuning and loading data for fast access of reports in Client/Database. Server balancing, business Rules Implementation, MetaData, Data Profiling.
• Developed small applications with Teradata at the backend.
• Created source table definitions in the DataStage Repository by studying the data sources.
• Created Use Case Diagrams, Activity Diagrams, Sequence Diagrams and ER Diagrams in MS Project.
• Created source table definitions in the DataStage Repository by studying the data sources by importing the data from Mainframe.
• Authored test plans, test cases for various test scenarios and helped testing team to better understand the test scripts.

Environment: Rational Enterprise Suite (Rose, RequisitePro, ClearCase, ClearQuest), XML, Java, Unix, C++, J2EE, JSP, Oracle, DB2, Sybase, Agile,MS Office, Teradata, Mainframe, SQL Server Reports, WinRunner, LoadRunner, Quick TestPro

Confidential, Houston, TX

Business Analyst

Responsibilities:

• Actively participated in all phases of SDLC.
• Gathered analyzed and documented both business and technical requirements from formal and informal sessions and validated the needs of the business stakeholders.
• Conducted user interviews with various stakeholders and documented business and functional requirements.
• Analysis of business requirements and system requirements of the client and also for Property and casualty modules
• Develop Logical and Physical data models that capture current state/future state data elements and data flows using Erwin
• Worked on establishing and demonstrating a thorough understanding of the business models, processes, and priorities, and leveraged that knowledge in the development and delivery of scalable system solutions.
• Wrote Business Cases for the Stakeholders to understand the functioning of the new Underwriting System.
• Responsible for Commercial Insurance Standards rating and risk factors for Auto and Garage commercial insurance.
• Analyzed system performance and initiated process improvement measures for mainframe and Web-based applications.
• Conducted user interviews, gathering requirements, analyzing the requirements using Rational Rose, Requisite Pro - RUP.
• Used the DataStage Designer to develop processes for extracting, cleansing, transforms, integrating and loading data into data warehouse database.
• Worked in mainframe environment and used SQL to query various reporting databases.
• Performed Gap Analysis of the processes to identify and validate requirements.
• Have sizeable adequate hands on exposure in Workmen Compensation, Commercial Insurance as well as Property & Casualty Insurance & its various intricacies
• Articulated and presented key findings, possible alternatives and recommendations to senior level management.
• Provided SharePoint administration to insure efficient content management for the knowledge Management team.
• Involved in Service Oriented Architecture (SOA) of the claims processing system
• Establish documentation for Agile methodology for implementation with a very water-fall-centric development team.
• Managed timely completion of multiple projects in parallel- worked in close conjunction with the Project Management Office (PMO) to define scope of the project and its deliverables
• Involved in Managing Data modeling project from Logical design and implementation of Sybase Database
• Wrote detailed specifications and led the development for various reports generated using Cognos.
• Performed Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data and perform validation.
• Facilitated mapping sessions and identified/documented data ‘Source-Target’ mapping and for populating and maintaining reports on Cognos environment.
• Facilitated training programs to familiarize users on the Cognos ad-hoc reporting environment.
• Provided technical oversight and clear communication of problem/resolution process to customers and management.
• Directed the creation of software test plans and coordinated UAT sessions with the client documenting detailed results.
• Reviewed the Test Plans developed by the testing team for accuracy in testing the application.

Environment: Mainframes, COBOL, JCL, Db2, Oracle, Rose,Agile,MS Word, MS Excel, MS VisioLoad Runner, Win Runner, UNIX, MS Power Point, MS Excel, Rational Rose, Caliber RM, System Analysis,Crystal reports, SQL.