SUMMARY

• 6+ years of experience as a Business Systems Analyst with solid understanding of Business Requirement gathering, Business Process flow, Business Process Modeling, Data Analysis, Data Mapping and Business Analysis.
• Experienced in manual and automated testing for both front - end and backend. Extensively used automated test tools of Mercury like Quality Center, Quick Test Pro, Win Runner, Test Director, Performance and Load Runner Testing.
• Expert in the Property, Casualty, Annuities, Disability, and Supplemental Insurance policies include administration, sales, customization, claims, pensions and CMS.
• Proficient in all phases of Software Development Life Cycle (SDLC), which involves requirement gathering, requirement analysis, agile, functional design, implementation and enhancement of projects in SalesForce.com.
• 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.
• Extremely proficient in using Agile and XP methodologies performed roles of Scrum Master following sprint sessions and used Rally software extensively to write User Stories, assign tasks to individual team members.
• 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.

TECHNICAL SKILLS

Languages and Tools: UML, Rational Rose, RequisitePro, Rational SoDA, Rational Clear Case, Rational Clear Quest, Mercury Test Director, Quality Center, MS Project, MS Visio, MS Office Suite, Bloomberg,VBA for Excel, SQL, PL/SQL, Java, J2EE,, VB.NET, 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

Business Analyst

Responsibilities:

• Provide support across different domain areas such as Auto Assignment, Payments, Claims Documentation, and Appointment Logs, Auto Estimations, Fire Claims etc.
• Have worked in Guidewire Policy Center from End-to-End and involved in Policy Info, Person Info, Losses and Violations, Coverage's, Risk Analysis Customizations.
• Build new processes and functionalities using Batch Apex for Robust Email Integration between Salesforce Marketing Cloud and Salesforce.
• Successfully helped the organization to implement SalesForce.com. Provided strategic and tactical direction in terms of how and what to implement. Provided them with direction to implement Account, Contact, Donations and other CRM management.
• Data mapping, logical data modelling, created class diagrams and ER diagrams and used SQL queries to filter data within the Oracle database
• Used JIRA to perform test management activities and used JIRA tool to track and maintain different versions of the project documentation.
• Evaluated Business Development representative team needs while conveying the value of SalesCloud. Conducted Analysis and design of the Salesforce.com.
• Provided support ongoing salesforce.com maintenance and administration services including periodic Data cleansing, Custom objects, Workflows and Triggers.
• Analyzed the business rules for Auto claim assignments throughout the US, so as to have balanced work load for all the claims reps. Conducted JAD sessions with CRM SMEs, system architects, technical teams and other stakeholders for open and pending issues.
• Prepared test Data sets and performed data testing using the PL/SQL scripts. Also used MS excel for data mining, data cleansing, data mapping, and data dictionary and data analysis
• Interacted with various business user groups for gathering the requirements for Salesforce implementation and documented the Business and Software Requirements.
• Any formal qualifications in Agile, ISEB and/or Project Management would be of interest but by no means essential.
• Conduct requirements elaboration sessions in salesforce CRM platform to review and validate business requirements.
• Strong knowledge of working on JIRA and Tableau and rained the team on JIRA tool for Agile/ Scrum Methodologies.
• Analyzed standard industry practices of back office applications of Insurance Company, underwriting, billing, policy and claims administration with the help of Subject Matter Expert.
• Reported errors and defects via JIRA tool and kept an eye on its status to retest to determine final status of defects and errors.
• Involved in creating gap analysis document, clearly identifying the data, business process and workflows of the organization with respect to salesforce.com implementation.
• Have worked in Guidewire Policy Center from End-to-End and involved in Policy Info, Person Info, Losses and Violations, Coverage's, Risk Analysis Customizations.

Confidential

Business Analyst

Responsibilities:

• Performed mapping of fields in Life Insurance application to New Business Submission Transaction (Tc = 103) in the ACORD data model.
• Involve in analyzing defects that have been reported in the JIRA and sending them over to the developers for a fix.
• Implemented data access, storage and validation routines on the database server using Procedural Language/Structured Query Language PL/SQL
• Developed dynamic Salesforce.com Visualforce pages using Apex page functions and actions, designing them using HTML, CSS, and JavaScript.
• As a functional consultant, implemented Guidewire Policy Center through an Agile Scrum development model
• Have worked in Guidewire Policy Center from End-to-End and involved in Policy Info, Person Info, Losses and Violations, Coverage's, Risk Analysis Customizations.
• Extensive experience configuring and designing the Salesforce.com CRM solution to meet business requirements and support existing business processes.
• Provided support ongoing salesforce.com maintenance and administration services including periodic Data cleansing, Custom objects, Workflows and Triggers.
• Facilitating priority meetings with stakeholders to help business understand the impact of the JIRA in prioritizing them
• Converted various SQL statements into stored procedures thereby reducing the Number of database accesses.
• Explained Property & Casualty terms, Insurance Rules, Workers Compensation, Claim to the Dev team.
• Proficient in all phases of Software Development Life Cycle (SDLC), which involves requirement gathering, requirement analysis, agile, functional design, implementation and enhancement of projects in SalesForce.com.
• Aided the Product Owner for developing project plan as well as managing the project scope for the billing and policy center tool of the business insurance policies segment of property and casualty insurance
• Working as a Guidewire Business Analyst for the Advance Project in the Personal Lines PolicyCenter, which is a web-based policy administration system used for quoting and applications for all personal lines product
• A new Umbrella Policy Administration System was set up to issue/quote new Umbrella insurance Policies to provide higher liability coverage limits for members.
• Assisted in the implementation of Umbrella product from mainframe to a web based platform and rolling it out to a 24 state region.
• Continuous communication with the team to track requirements on rally and discuss to fix defects with JIRA tools, and corrected lesson learnt from each sprint.
• Created various Reports and Report folders to assist managers to better utilize Salesforce as a sales tool and configured various Reports for different user profiles based on the needs of the organization.
• Advanced knowledge of case law and state Workers Compensation laws, subrogation, reserve setting and litigation management
• Experience in commercial Property and Casualty, Commercial Lines and Personal Lines Insurance, Underwriting, Rating and Guidewire experience with national carriers.
• Good experience in Salesforce.com Configuration of roles, profiles, user accounts, implemented role hierarchies, sharing rules and record level permissions to provide shared access among different users.
• Analyzed standard industry practices of back office applications of Insurance Company, underwriting, billing, policy and claims administration with the help of Subject Matter Expert.

Confidential

Business Analyst

Responsibilities:

• Have worked in Guidewire Policy Center from End-to-End and involved in Policy Info, Person Info, Losses and Violations, Coverage's, Risk Analysis Customizations.
• Add the JIRA number, date, Initials and a brief description to the comments section when I modified, added or struck-thru a requirement.
• Involved in creating detailed test plans and testing strategies and ensure these are executed extensively, which includes executing SQL queries to retrieve data and test
• Aided the Product Owner for developing project plan as well as managing the project scope for the billing and policy center tool of the business insurance policies segment of property and casualty insurance
• Manage and maintain the standard, custom/generic, promotional, large buy,& deviated pricing within the Umbrella & JD Edwards pricing databases.
• Expertise in understanding Policy Administration System using Guidewire PolicyCenter especially in Commercial Lines (Business owners, Worker's Compensation, Business Auto).
• Working as a Guidewire Business Analyst for the Advance Project in the Personal Lines PolicyCenter, which is a web-based policy administration system used for quoting and applications for all personal lines product
• Advanced knowledge of case law and state Workers Compensation laws, subrogation, reserve setting and litigation management.
• Use JIRA to track and report defects to developers. Before Logging the Defect, working with BA people to find out any requirement changes.
• Developed comprehensive system test scenarios and test scripts. Responsible for performing back-end analysis and testing using SQL queries
• Experience in commercial Property and Casualty, Commercial Lines and Personal Lines Insurance, Underwriting, Rating and Guidewire experience with national carriers.
• Analyzed standard industry practices of back office applications of Insurance Company, underwriting, billing, policy and claims administration with the help of Subject Matter Expert.
• Have worked in Guidewire Policy Center from End-to-End and involved in Policy Info, Person Info, Losses and Violations, Coverage's, Risk Analysis Customizations.

Confidential, Columbus, OH

Business Analyst

Responsibilities:

• Worked closely with the Enterprise Data Warehouse team and Business Intelligence Architecture team to understand repository objects that support the business requirement and process.
• Ensured all bugs, requirements, mock-ups and test cases are logged with adequate information into JIRA to assist developers and the team in developing a sound product based on customer standards.
• Developed complex SQL for back-end testing on DB2 to ensure data consistency and data integrity.
• Validated Rating Algorithms for Schedule Rating, Experience Rating and Retrospective Rating using Guidewire Rating Management components.
• Developed User stories consisting of UI Mockups and Business Rules to capture the functional requirements of the Guidewire BillingCenter
• Performed on Expertise in Database Modeling, Data Mapping, ETL, Data Quality Management, Data Analysis, Requirement Analysis, Business Modeling, Data Migration, Data profiling, and Dimensional Modeling, Entity Relationship Diagrams ERD, SQL and reporting process.
• Attended requirements gathering sessions with the customer based on user feedback and new enhancements, which were entered into JIRA and tracked for future releases.
• Utilized the guidelines and artifacts of the Agile Methodology to develop a detailed implementation process Guidewire claim Center Integration during different iterations and phases in Software Development Life Cycle (SDLC)
• Collaborated with the business team in the creation and completion of project charters and project scope for Guidewire PolicyCenter.
• Identified gaps in existing Policy Administrating Systems and Guidewire PolicyCenter and diligently designed as-is and to-be process, in scope and out of scope documents.