Sarika Srivastava

Email: accsza@r.postjobfree.com Mobile: 323- 325-5275/ 201-***-****

Employer id: accsza@r.postjobfree.com Mobile: 973-***-****

Experience Summary

I am a Test Engineer with a total experience of 7 years and my last organization is Computer Science Corporation Pvt Ltd. Earlier I

worked with Wipro Technology and Zensar Technologies Ltd. My focus area of experience has been software testing. I have worked

primarily in the insurance domain by using new business accelerator (nbA) to automate life insurance and underwriting activities. My

technical experience is nbA, Oracle PL/SQL, Oracle Portal, Java Script, and HTML. My recent Project is a Life Insurance project.

Skills:

Project Management: Project planning, Task allocation, Issue escalation, Quality management

System Design and Development: Requirement gathering and analysis, Impact Analysis, Test plan creation, Test Execution, Defect

cycle, Documentation

Programming: HTML, SQL, PL/SQL, JavaScript, Oracle Portal - Dynamic Pages, Database Objects

BUG Tracking Tool: Scarab, Bugzilla, Mantis, Test Track Pro

Configuration Tool: VSS

RDBMS/DBMS: Oracle 9i, Oracle 10g, accessing via TOAD and SQL server

GUI: Html

Domain Knowledge: Insurance

Career Profile:

Dec 2010 – Dec 2013 Computer Science Corporation Pvt. Ltd. As a Test Engineer

Feb 2010 – Dec 2010 WIPRO Technologies Software Engineer

Jan 2007 – Jan 2010 Zensar Technologies Ltd. Associate Software Engineer

Project Thesis:

Project Title: ONAT nbA Implementation

Company: CSC Pvt Ltd

Client: OHIO National Life Insurance Co. Cincinnati, USA

Period: Feb 2013 – Dec 2013

Role: Test Engineer

Team Size: 15

Project Description: Ohio National Financial Services, through its affiliated insurance companies (The Ohio National Life Insurance

Company and Ohio National Life Assurance Corporation), markets a variety of insurance and financial products in 47 states. Ohio using

new business Accelerator to implement following business areas:

Page 1 of 4

•Individual life insurance

•Individual disability income insurance

•Individual annuities

•Group annuities

•Broker/dealer services

Responsibilities:

• Involved with Business users for requirement gathering.

• Worked on Term Product and Permanent Product like VUL, IUL,

• AUL.

• Worked on different business area like Application Entry, Contract Validation, and Underwriter workbench, Amendment,

Reinsurance and Replacement.

• Test Plan prepared for all above functionality and testing also performed independently.

• Working directly with OHIO client’s QA team and meeting weekly to understand their concern, issues and discuss bugs.

• Prepared Quality/Process Improvement Document and started new processes in the team.

• Analysing xmls and logs file. Mentoring and assigning the work to testing. Bug reporting by using Bugzilla tool.

Project Title: nbA AXA Life Insurance

Company: CSC Pvt Ltd

Client: AXA Equitable, USA

Period: Dec 2010 – Jan 2013

Role: Test Engineer

Team Size: 30

Project Description: AXA Equitable Life Insurance Company, headquartered in New York, NY, is a leading financial protection

company and a premier provider of life insurance, annuities and related financial services.

The company’s products and services are offered to consumers by financial professionals through its retail and wholesale distribution

channel. AXA using CSC’s nbA for their Life insurance and Annuities product.

Term Plan phase already in production and Permanent Plan phase (VUL, AUL, and IUL) are going to production soon.

Software/Framework Used: Microsoft Office, RAD 6.0, and J2SE 1.4, Microsoft Office, Lotus Notes 8, Internet Explorer, and

SVN. Hardware Used: Intel Processor, 3 GB RAM, 19" Monitor.

Responsibilities:

• Created one of the biggest Test Plan independently which cover different product rules.

• Analysing VPMS model and accessing Database table.

• Responsible for individual enhancement Testing, Formal and Informal Regression testing and Regression cases etc.

• Engaged in execution of Test cases, reviewing & implementing Test cases.

• Handled the reporting and tracking of bugs through Scarab.

• Interaction with client and BA for issue resolutions clarifications.

• Mentoring and planning the work for junior members.

Project Title: MSA Insurance

Company: Wipro

Client: Main Street America Group, USA

Period: Feb 2010 – Dec 2010

Role: Test Engineer

Team Size: 20

Project Description:

MSA is an insurance company at Keen in US which deals in providing Personal and Commercial general insurance. The project includes

automating and building the personal line general insurance renewal system for Main Street America (MSA). The system will be build

Page 2 of 4

using One Shield Dragon insurance product which is build in J2EE technology that involves integration with Mainframe legacy system

and other system using web services. There is interaction with other systems like claims, Policy using Web Service

Responsibilities:

• Engaged in planning of Tests, preparing Test scripts Test case requirements and writing, reviewing & implementing Test cases.

• Responsible for front-end/Back-end Testing, Web, GUI, Functional and Regression testing etc.

• Handled the reporting and tracking of bugs.

• Database coding using Stored Procedures, functions and packages as the one shield product is Meta data driven

product.

• Design High Level as well as Low Level for the project.

Software/Framework Used: One Shield Dragon Insurance Product, Oracle 9i

Database Used: Oracle 9i

Project Title: VIDEOJET ORACLE PORTAL

Company: Zensar Technologies Ltd

Client: Videojet Technologies Inc. USA

Period: June 2008 - Jan 2010

Role: Oracle Portal Developer and Tester

Team Size: 2

Software/Framework: Oracle Portal

Database Used: Oracle 10g

Project Description:

Videojet Technologies Inc. is worlds-leading manufacturer of coding, printing and laser marking products, fluids, and accessories for the

product identification industry. As experts in continuous ink jet (CIJ), drop-on-demand (DOD), thermal-transfer overprinting (TTO),

array, and laser technologies, Videojet has over 275,000 units installed worldwide.

The VIDEOJET ORACLE PORTAL project is mainly a Development of Videojet Portal. It includes Development of portal pages and

creation of database objects

Responsibilities:

• Designing portal pages.

• Creating and maintaining database objects.

• Coding Stored Procedure,Functions, Cursors in PL/SQL

• Involved in developing the Test Cases.

• Involved in the test execution

• Bug reports preparation

• Testing using SQL.

• Communication with Onsite coordinator and client & reporting

• Prepare the test reports, logs and provide it to QA manager.

• Code review document

• Effort estimation and document analysis

• Documents for developed applications.

• Migration of portal pages and database objects.

Page 3 of 4

Qualifications

Master of Computer Application: Birla Institute Of Technology, India 2004-2007

Bachelor of Arts: University of Allahabad, India 2001-2004

DOEACC ‘A’ Level UPTEC Allahabad, India 2001-2003

DOEACC ‘O’ Level UPTEC Allahabad, India 2000-2001

Other: Certifications

FLMI Level 1

LOMA 280 (Life Insurance)

LOMA 290 (Life Insurance Operations)

Oracle 9i Certified Associate (OCP) in Developer Track

1. Oracle 9i Introduction to SQL

2. Oracle9i: Programming with PL/SQL

3. Forms and Reports: 9i

MCP (Microsoft certified Professional)

Page 4 of 4

Contact this candidate