Sign in

Life Insurance Data

Toronto, ON, Canada
March 27, 2018

Contact this candidate


Shilpa Mittal

** ******** *****, ****** ******* Canada L1R0K3

Home: 647-***-**** Cell: 647-***-****


Skilled Senior Business Analyst with diverse experience in Insurance products and IT industry. Rich experience in elicitation and documentation of business requirements, gap analysis, data mapping, conversion. Well versed with Policy Administration System and Software Development Life Cycle and AGILE methodology. Expertise in client relations management. Capability to multi-task efficiently and learn quickly.

Permanent Resident of Canada.

Domain Skills Technical Skills

Insurance –Life Insurance and Property and Casualty Client Web Based Applications, ALM

AGILE, SDLC, Policy Administration System MS-Office Suite – Excel; Powerpoint; Visio; Access

Requirements Documentation; DNG, Blueprint SQL Queries; Testing - Backend and Frontend

JAD sessions, Non-functional requirements Skilled in Problem solving; ServiceNow Incidents

Business Process Flow, Data Mapping Software Development Life Cycle; UAT

Test Cases; Test Matrix; Test Scenarios Mainframe – JCL, ISPF, TSO, CICS; Fileaid

Functional Documentation, Storyboards, Use cases Sharepoint


I)Senior Business Analyst – September 2014 to Present

Client – Intact Financial Corporation – Toronto Canada

Cognizant Technology Solutions – Toronto Canada

Elicitation of business requirements with various Stakeholders for Homeowner and Automobile

Product catalogue for Intact. Conducting JAD sessions with business users using various techniques

to understand end to end business needs and write high level and detailed requirements in DNG.

Presenting and reviewing the High Level requirements, Scope and Vision documents during the Business Peer Review and Solution Forum to the Client Directors and Vice Presidents.

Performed the gap analysis of requirements between the current system functionalities and the new system.

Building business requirements for different transactions in Policy Administration System for Quote, Coverages, Product Catalogue, Rating, Billing and Claims for Homeowner, Tenant, Condominium and Miscellaneous Property policies.

Worked on gathering Requirements both Functional and Non-functional for Intact Canada to assess gaps across all Intact provinces Canada wide.

Prepare Business Process flows for simplifying complex business processes.

Performed Data mapping and Conversion exercise for data flow from new system (upstream) to old legacy system (downstream) application. Review SRS documents pertaining to conversion of data from old system to new system and vice-versa.

Analyzing the Policies suspended in the existing legacy system and recommending solutions to mitigate the suspensions.

Managing the business requirements in the Blueprint and DNG (Doors Next Gen) tools.

Delivering business requirements in various phases to IT for functional analysis and providing business justifications for the business requirements to IT.

Reviewing and approving the IT functional documents (Storyboards and Use cases) to ensure solution meets the business needs and there are no gaps.

Managing change requests on requirements through change management process

Knowledge transfer within the team on the insurance domain topics.

Managing documents latest versions in Sharepoint

II)Business Analyst – June 2014 to August 2014

CIBC – Retail Banking – Toronto Canada

Worked closely with stakeholders in the Business Analytics and Intelligence department to elicit the requirements on Loss Management.

Analysis of the business requirements and preparation of the BRD

Guided the design and architecture for the implementation of the requirements and business need

Coordinated the activities of data architects, ETL, developers and QA team

Prepared Test Matrix and Test cases

III) Business Analyst - March 2007 to January 2014

IBM Global Business Services-Bengaluru, India

Client – Fireman’s Fund Insurance Company (FFIC) – Mainframe platform– Novato California USA

Projects – Personal Property Insurance; Homeowners Insurance; Financial Reporting; Agents commission

•Performed gathering; analysis; review and signoff of business requirements for Property and Casualty Insurance.

•Work collaboratively with the clients and technical team to perform business analyst activities like identify business requirements and documentation.

•Creating Business Requirement Documents and providing the inputs for the Functional Specification Documents.

•A thorough understanding of the Software Development Life cycle (SDLC) and involved in various phases such as Analysis in Policy Administration System; Requirement Gathering; Testing; Deployment.

•Examined existing processes and evaluated them within the context of the project requirement and helped in improvising them.

•Developing efficient business relationships with various client teams in order to process and support

requirements, effectively manage client expectations.

•Analysing policy premium differences and the cause of the difference by using CSC Rating engine algorithms. Investigating various incidents/tickets in the ServiceNow tool and providing best solutions to the development team. Updating the ServiceNow with the latest progress in the incident and closing the incidents with proper resolution.

•Coordinating the onsite-offshore model by interacting with client on the daily basis and effectively communicating to the offshore team.

Production table updates in CICS region

•Test data creation and executing JCL jobs to accomplish successful testing.

•Performed data changes in CICS environment as per user’s request and browsing CICS to view the real-time production data.

•Commission Rate changes in CSC system

•Worked at the client site to understand the client needs on the existing undergoing projects and successfully implemented the projects before the deadline dates.

•Participated in the walkthroughs with the clients and technical team and provided inputs.

•Work with developers, analysts and consultants during the development and implementation phase to ensure

requirements are being met and present any change requests.

•Used SQL queries to do data analysis. Also performed front-end testing in project applications.

•Prepared knowledge sharing documents related to the project work which is useful for the team.

•Organize monthly training session on the topic related to the project.

•Mentoring new team members.

•Participated in IBM FFIC Ignite idea and successfully got approval from the clients for the proposed idea.

IV) Business Analyst and Onsite Coordinator - June 2004 to February 2007

Computer Sciences Corporation (CSC) - Mainframe platform - Dallas USA

Projects – Life Insurance; CyberLife; Worker’s Compensation; VP/MS Models

•Worked on CyberLife Enhancements with complete responsibility for the quality of the deliverables. Preparation of Test plan, test data and test matrix.

•Assisted in creating Cyberlife user manual

•Worked on the projects pertaining to system changes for worker’s compensation functionality in CyberLife product.

•Testing and Sign off the enhancements in QA after ensuring that the quality of deliverables is as per

requirement of the client.

•Recreating the System Problem reports in co-ordination with the developer.

Simulated business scenarios in Mainframe and ran JCLs to recreate the business problem.

Production table updates in CICS region

•Documentation and Analysis of Miscompares for the CyberLife demonstration data.

•Maintenance of Demonstration data and CyberLife reference library.

•Performing QA testing at the end of the release to ensure that nothing is broken.

•Communication with the client on requirements, assignments, clarification on queries and deliveries.

•QA testing of STP (Strategic Technology Program) Browser.

•Providing assistance to the development team in understanding the business requirements.

•Conducting knowledge sharing sessions and preparation of knowledge documents

•Mentoring new BA resources in the team

•Worked as the onsite coordinator thereby coordinating with the team at offshore and onsite and ensuring maximum efficiency and timely deliveries to the client.

•Conducted and participated in walkthroughs to discuss certain issues with the development, design team and QA


Worked on VP/MS Model Calculation Project

Responsibilities include:

•Working independently from the offshore team for this project. Working as the co-coordinator between the offshore and the onsite team for project planning, estimation, assigning the tasks and tracking. Providing estimates in terms of efforts, duration and cost for the change request.

•Well versed with the model calculations and with the debugging of the problems.

V) Operations Executive - February 2003 to May 2004

Allianz Bajaj Life Insurance Co. Pvt. Ltd.-Pune, India

•Policy related matters like Policy Issuance, Printing and Dispatch and Policy Servicing with in the service

standards as defined by the company.

•Underwriting of the proposals upto a defined limit of Sum Assured

•Follow up of requirements pertaining to new business with Head Office, Sales Staff, Insurance Consultants and


•Resolution of customers and intermediaries queries.

•Agency management (scrutiny of agency forms, licensing, & Coordinating sources for training and recruitment of Agents)


PGDBA: Marketing and Systems,2001

MITSOM-Pune, Maharashtra, India

Specialization in Marketing and Systems

Maharashtra Institute of Technology (MITSOM), Pune (Maharashtra)

Obtained 76% aggregate percentage

Bachelor of Commerce: Bachelor of Commerce,1999

BSSS-Bhopal, Madhya Pradesh, India

Bhopal School of Social Sciences, Bhopal (Madhya Pradesh)

Obtained 78% aggregate percentage

Additional Qualifications:

Completed Advanced Diploma course in Computer Applications from TULEC

Associate Life Management Institute – FLMI LOMA;

Guidewire Trained (Policy centre)

Contact this candidate