SUMMARY

• 20 years of progressive experience in software analysis, design, coding, testing including ten years as Business System Analyst in P & C Insurance & Telecom domains.
• Scrum Master / Business Analyst skills - Requirement gathering and documentation of BRD, User Guide, defect triage and Jira Issues; responsible for QA, UAT and Agile ceremonies - Sprint Planning, Daily Scrum, Sprint Review and Sprint Retrospective.
• Data Skills - Analytics approach in all projects using SQL coding, Excel and database expertise.
• Worked o n projects in Data warehousing, and Business Intelligence, Data analysis & migration, Reporting, Visualization and Analytics with strong SQL skills.
• Experience working in Commercial Insurance, TPA Administration and Personal Insurance - Auto, Home & Renters.
• Elicited requirements from Actuaries, Underwriters and Management Executives.

TECHNICAL SKILLS

• Cobol, DB2, ISPF, JIRA, HP Quality Center, MS-Office, MS-Visio, PL SQL, XML, API, MS SQL Server, UDB-DB2, Oracle and SAS Enterprise Guide.

PROFESSIONAL EXPERIENCE

Confidential

Senior Business Analyst

Responsibilities:

• Business Analyst for Confidential Wireless Chatbot project built on top of Google DialogFlow.
• Met with various Business teams to understand the requirements for new Conversation flows f or various functions in Chatbot application and enhancements to existing ones.
• Responsible for updating Jira User Stories, grooming the User Stories with Development and QA teams, interaction with various Ver izon teams to understand their APIs to be used in Chatbot application, documenting necessary APIs, guiding te ch team towards North Star Architecture, resolving their questions and timely delivery of monthly Sprints.

Confidential

Business System Analyst

Responsibilities:

• Met with SMEs to understand the requirements for the Rate Repository project. Created a BRD and User Guide along with performing UAT testing with users. Source data came from three different systems - Premium Monitoring Report (PMR), Actuarial Price Monitoring (APM) & Tracker application with distinct database systems - Oracle, SQL Server and Netezza respectively. I used SAS Enterprise Guide as a tool to successfully build a Repository to client’s satisfaction with implementation of 50+ SAS SQL queries. This project was about creating repository for the rate change in renewal policies for various Confidential products - General Liability, Property, Surety, Cyber, Environmental, Excess & Surplus, Professional Liability, Management Liability and Product Recall.
• As Senior Business Analyst supporting the Westchester Data Hub project. Responsible for enhancements, issue resolution, reconciliation with source and downstream financial applications. Elicited Reporting requirements from Actuaries and Underwriters . Worked with developers for SQL Server - database and ETL development on XML data from Duck Creek system, SQL development, with business for UAT and sign-off. Interacted with senior executive management for status reporting and budgeting of the project. This project dealt with data for the Westchester group of Confidential companies corresponding to products Commercial Lines, Specialty Property & Casualty, Select Binding & Professional Lines.

Confidential

Senior Business Analyst

Responsibilities:

• Senior Business Analyst supporting the Data Solutions’ Visualization team with requirement elicitation and documentation in product backlogs, conducting daily scrums, backlog grooming as a Scrum Master for projects in POC / delivery stage. Created BRDs and FSDs for the multiple dashboard projects that were successfully deployed to production, to client’s satisfaction. Worked with developers for QlikView and Tableau based dashboards in identifying data sources, data cleaning and SQL development. Worked with developers in designing the data model for Big Data (Hadoop) and integration with QlikView dashboard. Interacted with senior executive management for requirement gathering. Created user guides and conducted training for dashboard users. The data in these projects belonged to International Commercial Insurance products.

Confidential

Business System Analyst

Responsibilities:

• Confidential Claims Component, Database Model Business Analyst supporting the Conversion team in its efforts to convert legacy client claims data to Confidential Claims Component database. Helped the team with information on metadata of the target database; data mapping of source to target data fields, interpretation of the target fields in terms of business & technical functionality . Trained the team on Insurance basics and explained the significance of data fields. Worked with the development team to resolve defects by guiding them in root cause analysis.
• Client Customer Driven Experience, Business Analyst for a Sales Force implementation project, working with the offshore development team and responsible for attending daily SCRUM meetings with business users, documenting the requirements and developing design documents. Followed the standards set in the Playbook per Agile methodology setup for this project. Interacted with other DC projects and State Farm application teams to share the necessary documentation for APIs.
• Atlas Reconciliation project for ACE, as the Business Architect focused on building an offshore team and process to complete financial and non-financial reconciliation between the new system and the old legacy system. Interface daily with senior level clients, wrote functional use cases, designing SQL based technical components to execute comparisons and identify variances.
• EMI Program project for XL Group, developed requirement specifications. Identified gaps in existing functionality and frame this problem in Technology terms. Develop business cases and support the prioritization process.
• Confidential Conversion & PMO setup projects for ProSight, assisted the Project Manager with the setting up of a new PMO. For the Confidential Conversion project, designed & implemented a strategy to retain the data of applications that were to be shutdown . Identified NY Magic critical reports; analyze and determine the usability of these reports during the conversion phase. Completed the translation of data values for important reporting fields.