OBJECTIVE:

Highly skilled and energetic individual, grown over 6.5 years experience in the Insurance Domain as a Business Analyst/Business System Analyst. Self motivated team facilitator with excellent inter personal skills. To be a part of a progressive corporate group having growth potential where I can contribute to the development of the group as well as can develop my domain of competence using my knowledge, skills and attributes.

PROFESSIONAL SUMMARY:

• Experience in requirements gathering, estimation, system implementation and pre - post implementation support.
• Rich experience and exposure to Confidential.
• Experience in Business Analysis across diverse assignments involving Project Planning/Coordination, Requirements Gathering, Documentation, Test planning, UAT, Implementation and Post-implementation support.
• Expertise in executing/implementing projects for Personal and Commercial Policy Admin Systems.
• Specialize in Rates & Forms Management for Commercial lines.
• Experience in writing requirements of ETL processes for application migration.
• Exposure to frequent client interactions.
• Experience in analyzing large Databases.
• Expertise in formulating SQL queries for data analysis.
• First class all along the academic career.
• Excellent analytical thinking ability and communication skills.

SKILLS:

Technical: Office 2007, Visio 2007, SQL, SnagIt, TopTeam, Salesforce, VSS, SharePoint, HP Quality Center.

Non Technical: Water Fall & Agile Methodology for Product Implementation, Use Cases.

PROFESSIONAL EXPERIENCE:

Confidential, Schaumburg, IL

Senior Business Analyst

Responsibilities:

• Reviewing Model Specs provided by the Actuaries.
• Preparation of high level estimation based on preliminary analysis.
• Analyze and update data warehouse to get all the data points required for the models.
• Reviewing Predictive Modeling Filters with Actuaries.
• Identifying the potential target loss calc fields used in experience variable calculations.
• Preparation of High level Requirements for the Business Team, Actuaries and Low Level Requirements for the Development team.
• Implementation testing - Validating implanted model against data for the Actuaries.
• Provide support for functional testing and UAT execution.

Confidential, New York City, NY

Responsibilities:

• Analysis of source system to identify scope and prepare high level system understanding document.
• Prepare high level estimates and timelines for each system.
• Create field level mapping document from source system to EDW.
• Identify any gaps in existing EDW system and suggest possible solutions.
• Coordinate between offshore team and tower SME.
• Preparation of System Requirements based on discussion with project architects and application team.
• Preparation of high level estimation based on preliminary analysis.
• Preparation of Data Mapping document based on understanding of source data (Mainframe files) and mapping to the destination database (Oracle database).
• Impact analysis of Change Requests.
• Provide support for functional testing and UAT execution.
• Analysis and documentation of all production issues and queries.
• Formulate SQL queries to fetch production data for all production issues, queries and data validation.
• Coordinating with cross commit teams.
• Risk management, facilitating issue resolution and ensuring timely delivery.

Confidential, Dallas, TX

Responsibilities:

• Executed projects across all lines of business (Auto, Homeowners, Renters/Condo, Earthquake and Umbrella) for various clients.
• Requirements Elicitation and Documentation.
• Conducted User Interviews to establish and document Business Rules.
• Preparation of high level estimation based on preliminary analysis.
• Impact analysis of Change Requests and preparation of Functional /Business Specification Document.
• Requirement Walkthrough with clients (Business Owners & QA teams).
• Extensively perform Gap analysis.
• Worked with various functional groups to understand the underlying Business concepts.
• Assisted the PM in developing high-level project plan.
• Worked with the PM in managing changes to the scope of the project.
• Involved in preparing Test Plans, Test Cases and Test Procedures.
• Actively involved in User Acceptance Testing (UAT).
• Obtained Sign-off on project requirements and scope.
• Triaged all production tickets/issues and queries.

Confidential

Responsibilities:

• Designed workflows for end to end implementation process.
• Designed Templates for Requirement Documents, Functional Log and Estimation Sheet etc.
• Conceptualized Tools and Accelerators for rates/forms implementation and manual/circulars analysis.
• Provided LOB Specific information for home grown tools, for rates and forms testing.
• Formulated Plan and documents for Business Analyst.

Confidential

Responsibilities:

• Documentation of all data elements in the source system (Legacy system, Mainframe) for all lines of business.
• Provided inputs to technical team for creation of scripts to port data from legacy system to the new product.
• Analyzed source policy data in case of failure of scripts, to identify gap in new and existing system or to identify bad data.
• Prepared RCA (Root Cause Analysis) document for all failures.
• Prepared Test plan to validate data correctness in the new system.
• Provided support for UAT execution.
• Executed projects in Personal Auto, Commercial Auto and Commercial Property Line of business involving changes across Rates, Forms, Rules, System and UI.
• Impact analysis of Change Notice received from the client and preparation of Business Requirement document.
• Preparation of project plan and estimation based on preliminary analysis.
• Provided first level draft for functional testing.
• Provided support for UAT execution.
• Participated in Pre-UAT activities-conference calls, overview sessions and any other forums with Business, and other teams concerned with the project.
• Ensured proper documentation of activities for subsequent review by the quality group.
• Signed off projects adhering to quality processes followed in the project.
• Prepared Knowledge Capture Document and updated every month for future .
• Production support: Handled user queries.