PROFESSIONAL SUMMARY:

• 7 years of experience as a Business Analyst with solid understanding of Business Requirement gathering, Business Process flow, Business Process Modeling, Data Analysis, Data Mapping and Business Analysis.
• Insurance experience includes Personal Property Casualty and Commercial Automobile Product knowledge, Reinsurance for Commercial Property Casualty, Group and Life Insurance Systems
• Strong understanding of project life cycle and SDLC methodologies including RUP, RAD, Waterfall and Agile.
• Extensive experience in conducting Market Research, Feasibility Studies, Data Analyses, Data Mapping Gap Analyses, Risk Identification, Risk Assessment, Risks Analyses, and Risk management
• Expert in commercial Property and Casualty and Personal Lines Insurance experience with national carriers.
• Extensive experience with data modeling and defining the conceptual and logical model of the data warehouse.
• Expert in the Property, Casualty, Annuities, Disability, and Supplemental Insurance policies include administration, sales, customization, claims, pensions and CMS.
• In depth knowledge Rational Unified Process RUP methodology, Use Cases, Software Development Life Cycle SDLC processes, Object Oriented Analysis and Design OOA/D .
• 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.
• Extensive experience in developing Use Cases, creating Screen Mockups, conducting Gap Analysis and Impact Analysis, SWOT analysis, Cost Benefit Analysis, Risk Analysis.
• 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.

TECHNICAL SKILLS:

Languages and Tools: UML, Rational Rose, RequisitePro, Rational SoDA, Rational Clear Case, Rational Clear Quest, Mercury Test Director, MS Project, MS Visio, MS Office Suite, Bloomberg,VBA for Excel, SQL, PL/SQL, Java, J2EE, C , VB.NET, C /CLI, Adobe Acrobat, PhotoShop, AutoCAD, 3D MAX

Databases: Oracle 8i/9i, MS SQL Server, MS Access

Environments: Windows 9x/NT/2000/XP, UNIX Sun Solaris, AIX, HP-UX , Linux, Mainframe

PROFESSIONAL EXPERIENCE:

Confidential

Role: Sr. Business Analyst

Responsibilities:

• Analyzed clients systems and business processes.
• Provide support across different domain areas such as Auto Assignment, Payments, Claims Documentation, 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.
• Met the Business development group and gathered the requirements for the developing Automatic Assignment of claims Involved in Logical Physical Data Modeling. Database Schema design and modification of Triggers, Scripts, and Stored Procedures in Sybase Database Servers.
• Utilized corporation developed Agile SDLC methodology. Used ScrumWork Pro and Microsoft Office software to perform required job functions.
• 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.
• Established a Business Analysis methodology around the Rational Unified Process.
• Working with clients to better understand their needs and present solutions using structured SCRUM approach.
• Comprehensively work with requirement gathering for Enterprise reporting system using RequisitePro.
• Developed business process models in RUP to document existing and future business processes.
• Developed project plans and managed project scope.
• Worked extensively with MS Excel and MS access
• Developed QA Test Plan, test conditions and test cases, as well as assisted with QA team in System Testing using Mercury Test Director
• Established a business analysis methodology around the RUP Rational Unified Process . Helped develop use cases, project plans and manage scope.
• 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.
• Assisted in on-going process improvement efforts to ensure Test Planning, Execution, and Reporting is effective, efficient, standardized, coordinated, and integrated.
• 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 developing annual and mid-year operating budgets by underwriting departments and on a consolidated basis for review by reinsurance group senior management.
• 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.

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

Confidential

Sr. Business Analyst/Systems Analyst

Responsibilities:

• Played key role in System Development Life Cycle Process consisting of: Design and Gap Analysis, Business Requirements, Systems Requirements, Test Criteria, and Implementation to have the outputs of project dealt with the automation of correspondence directed to Insurance policy owners.
• Involved in requirement gathering and database design and implementation of star-schema, dimensional data warehouse using Erwin.
• Led the development of a training program to train users on a custom web application and a Cognos ad-hoc reporting environment.
• Design, development, implementation and roll-out of Microstrategy Business Intelligence applications
• Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, OOAD using UML and Business Process Modeling.
• Excellent in Developing and evaluating business process Models.
• Conducted Functional Walkthroughs, User Acceptance Testing UAT , and supervised the development of User Manuals for customers.
• Extensively involved in data modeling
• Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data within the Oracle database
• Gathered requirements and modeled the data warehouse and the underlying transactional database
• Perform Gap Analysis of the processes to identify and validate requirements.
• Identified/documented data sources and transformation rules required populating and maintaining data warehouse content.
• Wrote PL/SQL statement and stored procedures in Oracle for extracting as well as writing data.
• Use Cases and other Process Flow Models were designed using Visio and Rational Rose.
• Designed workflows and allocated permissions within SharePoint.
• Used MS Sharepoint for the purpose of managing documents and for hosting websites which was used to access shared work spaces and documents.
• Used SDLC System Development Life Cycle methodologies like the RUP and the waterfall.
• Involved in the testing phase right from the Unit testing to the User Acceptance testing.
• Implemented data access, storage and validation routines on the database server using Procedural Language/Structured Query Language PL/SQL .
• Involved in jobs and analyzing scope of application, defining relationship within between groups of data, Star Schema etc
• Followed the UML based methods using Rational Software Modeler/MS Visio to create: Use Cases, Activity Diagrams / State Chart Diagrams, Sequence Diagrams, and Collaboration Diagrams.

Environment: RUP, UAT, GAD Gap Analysis Document , Microsoft Office 2003 Professional Outlook, Word, Excel, Visio, Access , Microsoft SharePoint 2003, ERWIN, SQL, PL/SQL.

Confidential

Business/Systems Analyst

Responsibilities:

• Interviewed Business Users to gather Requirements and analyzed the feasibility of their needs by coordinating with the project manager and technical lead.
• Collects requirements from department managers and users for enhancements. Acts as liason between clients and development. Facilitates sessions to bring business requirements and functionality into SAP system development and enhancement.
• 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.
• Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data within the Oracle database.
• Served as a resource for analytical services utilizing SQL Server, and TOAD/Oracle.
• Run the SQL queries using TOAD and SQL Navigator.
• Identified/documented data sources and transformation rules required to populate and maintain data warehouse content.
• Was responsible for indexing of the tables in that data warehouse.
• Reverse Engineered the existing ODS in to Erwin.
• 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. Used the ODBC/SQL to migrate all data to one database before uploading it into the Knowledge Base.
• Uploaded documents produced onto SharePoint, an intranet website for all Technology Information Group members to download, revise and upload shared documents. Various versions of the documents generated during the project were maintained and managed using Rational ClearCase and end users Change Request for enhancement and scope items are maintained and tracked using Rational ClearQuest.
• Worked on data modeling and produced data mapping and data definition documentation
• Configured the Data mapping between Oracle and SQL Server 2005.
• Tested Performance Accuracy related queries under SQL Server
• Wrote PL/SQL statement and stored procedures in Oracle for extracting as well as writing data.
• Designed and implemented basic SQL queries for testing and report/data validation
• Created relationships in Requirement Traceability Matrix linking Business Requirements to Functional requirements and Functional Requirements to Systems Requirements.
• Conducted Joint Application Development JAD sessions with IT groups. Identified the Key Changes, and participated in Stakeholder Management to communicate effectively with them
• Developed and Documented timelines for Project Delivery, and managed Projects and Resources to successful completion.
• Used Data warehousing for Data Profiling to examine the data available in an existing database.
• 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.

Environment: Microsoft Office Suite, Microsoft Visio, Documentum, Windows NT/XP, Oracle, SQL, SQL Server, PL/SQL, Sybase, MS SharePoint.

Confidential

Business Analyst

Responsibilities:

• Responsible for gathering user requirements and specifications for designing a mortgage based loan system using and documenting the same.
• Extensively involved in maintaining requirements traceability and communicating any changes to these requirements to different business groups and programmers.
• Worked on HL7 and xml interface messaging.
• Prepared Demo on MS share point 2007 for various Business to get new approvals like the Therapist and Nursing divisions.
• Led and conducted JAD sessions for requirements gathering, analysis and design of the system.
• Designed DataStage ETL jobs for extracting data from heterogeneous source systems, transform and finally load into the Data Marts.
• Created context and workflow models, information and business rule models, Use Case and Object Models during the analysis using Rational tools.
• Provide implementation assessment, strategy, and mentoring services for Rational Rose, UML and RUP.
• Designed the system, prepared UML and sequence diagrams using Rational Rose.
• Responsible for writing detailed descriptions of user needs, program functions, and steps required for developing or modifying software programs using Rational Rose UML .
• Prepared Functional Specification Documentation FSD and communicated these to the stakeholders.
• Actively interacted with different business groups to perform Gap analysis to identify the deficiencies in the system by comparing the actual objectives with the system objectives desired.
• Conducted Business Requirements, Functional and Technical meetings with Business groups.
• Used MS Visio for Process modelling and Business Process flow diagrams.
• Extensively involved in regression testing during various phases of the application.
• Used Aggregator stages to sum the key performance indicators used in decision support systems.
• Troubleshot the designed jobs using the DataStage Debugger.
• Tuned DataStage transformations and jobs to enhance their performance.
• Wrote PL/SQL statement and stored procedures in Oracle for extracting as well as writing data.

Environment:

Rational Enterprise Suite Rose, RequisitePro, ClearCase, ClearQuest UAT, RUP, WinRunner, LoadRunner, MSOffice2000, MS SharePoint

Confidential

Role: Business Analyst

Responsibilities:

• Gathered high-level requirement for all the external projects in a release.
• 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
• Extracted data from Oracle database with MS Access, and performed SQL query, data analysis and verification.
• Created functional requirement documents for the impacting projects
• Performed criteria table updates for each project.
• Updated the impacted MS Access tables.
• Worked extensively with MS Excel and MS access
• Analysis of business requirements and system requirements of the client and also for Property and casualty modules
• 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.
• Involved in generating Test cases for property and casualty Insurances for Different Levels of Business
• Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, OOD using UML
• Responsible for gathering requirements from users in operations group and performing data mapping for the application, confirm and vacillating the requirement at time of BA testing.
• Facilitated and led JAD sessions aimed at functional requirement walkthroughs for all the impacting projects and updated the documents based on recommendations if any .
• Created UAT plans with several test cases for each project to ensure that the system runs smoothly after the proposed enhancements or changes have been made.
• Provided data modelling support for numerous strategic application development projects.
• Reviewed test results and coordinated with testing and development team to correct the issues.
• Developed timelines for project delivery, and managed projects/resources
• Analyze business requirements and segregated them into Use Case Diagrams, Activity Diagrams, Sequence Diagrams, and OOD using Borland Together according to UML methodology thus defining the Data Process Models.
• Responsible for preparing Business Requirement Document BRD and then translating into functional specifications and test plans. Closely coordinated with both business users and developers for arriving at a mutually acceptable solution.
• Responsible for creating Bordereau report on a monthly basis for reinsurance broker.
• 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, Unix, Documentum, Windows NT/XP, Oracle, SQL, SQL Server, Sybase, VBScript, C , DOORS, C , NET, ASP.NET, Mainframes, COBOL, JCL, Db2