Project Manager

Swapnil Sonal *

****************@*****.***

Contact Number: 630-***-****

Naperville, Illinois

SUMMARY

Page 1 of 8 1 –

2

• About 5 years of total software industry experience with Cognizant Technology

Solutions and other software consultancy firms.

• Swapnil works effectively with minimum supervision.

• Excellent know-how of Software Development Life Cycle (SDLC) and Lean

Principles, a thorough knowledge of various phases such as Requirements,

Analysis/Design, Development, Testing and Maintenance.

• Experienced in various categories of testing such as Functional, Regression,

Integration, System, Database, User Acceptance Testing and Performance Testing.

• Proficient in preparing Test Plans, Test Specifications, Test Case Development, Bug

Tracking & Reporting Systems and Traceability Matrix to map requirements to test

scenarios.

• Proficient in automated testing tools, especially QTP.

• Proficient in GUI testing by inserting various verifications and data driven testing for

functionalities that requires inputting dynamic data.

• Having good experience in product based testing with different builds and

configurations.

• Proficient in analyzing Business Requirements, Specifications, Development of Test

Strategy, Test Plans, Test Scripts, Test Cases.

• Knowledge in writing SQL queries for data verification and backend testing.

• Proficient in performing Black Box, Functional, Regression, User Acceptance,

Integration, System and Smoke Test.

• Highly self-motivated, task-oriented and has ability to drive tasks and activities to

closure. Recognized and appreciated for contribution for few financial domain

projects in Cognizant.

• Well organized and has capacity to multitask effectively.

• Have good analytical, critical reasoning with good written and oral communication

skills.

• Have willingness, ability and passion to work in a fast paced environment.

• Has ability to understand long-term and short term perspective of situations and look

thing in big-picture.

• Dedicated to quality and has attention to details. Believes in reviews and avoids

reworks.

• Works proactively and has capacity to visualize and act in time.

• Played following as in previous engagements:

o Developer and Tester

o Quality Analyst and single point of contact for Software Process Audits

CITIZENSHIP AND WORK STATUS

Citizenship: India

US Permanent Resident (Green Card Holder)

CERTIFICATIONS

• Cognizant – Entry Level Trainee – Course Completion Certificate

• Software Process SDLC Tool – Prolite Certification

• Cognizant – Dovetail Course Completion Certification

• Cognizant Certified Testing Professional

TECHNICAL SKILLS

Page 2 of 8 2 –

Swapnil Sonal 3

****************@*****.***

Contact Number: 630-***-****

Naperville, Illinois

VBScript, SQL, PL/SQL, Unix Shell Scripting, Perl Scripting, Java,

Programming and

Scripting Languages J2EE, HTML, Javascript, TSQL

PVCS, Visual Source Safe

Version Controlling Tools

Windows NT/95/98/2k, Unix

Operating System

Oracle 9i, MS SQL Server, MS Access, Sybase

Databases

HP’s Quick Test Pro, Rational Test Manager, Quality Center(Mercury

Testing Tools

Interactive)

Clear Quest, Quality Center, Test Director and Cognizant Prolite

Defect Tracking Tools

SDLC Concepts (Waterfall & Agile Testing Methodologies)

Methodologies and

Concepts DataWarehousing Concepts

EDUCATION

Year of passing Score

Qualifications Institutions

Percentage

Bachelor of Engineering (10+2+4)

Dibrugarh

(Electrical & Electronics 2006 72%

University, India

Engineering)

EMPLOYMENT SUMMARY

Organization Duration Role

Global Infotech Apr ’09 – Mar ‘10 Sr. QA Tester

Allsoft Corporation Apr ’08 – Mar ‘09 Quality Analyst

Cognizant Technology Solutions Jan ’07 – Mar ‘08 Programmer Analyst

Programmer Analyst

Cognizant Technology Solutions

Jun ’06 – Dec ‘06 Trainee

NTPC – IT Department Jul ’05 – May ‘06 Internship

PROFESSIONAL EXPERIENCE

Project Models worked on

Page 3 of 8 3 –

4

• Waterfall and Agile Model - Development & Testing Projects – Amex and ING

Projects

• Major Enhancement Projects – Amex

• Application Value Management projects –Amex

Fund Factsheets Automation - Testing

Project Name

Major Investment Bank in Midwest

Client

Apr ‘09 – Mar ‘10

Duration

• Review Project Plan, participate in Requirements Planning sessions

and ensure Testing Information is adequate

• Provide Test estimates and plan for resource requirements

• Create of Test Strategy

• Involve in System,Regression and Acceptance Test Planning

• Creation of System, Regression and Acceptance Test Plans

• Participate in test scenario’s and test cases review

• Creation of Test Coverage Matrix to ensure test coverage is adequate

•

Roles & Responsibilities Execute System and acceptance Testing

• Participate in Defect Management and problem resolution during test

execution

• Participate in Daily/Weekly Project team meetings

• Provide testing status to reporting manager and Project Team during

System, Regression and Acceptance test execution

• Communicating and documenting testing Risks and Issues

• Get Sign off from all stakeholders on the Test deliverables.

• Hand over the tested software to Production

Project Description

Investment Reporter (IR) application is a web application that generates

multi-product monthly & quarterly reports for banks' investors clients,

who are specifically set-up in the system for reporting. The underlying

database of IR gets performance, characteristics and commentary data

from various internal and external data sources. This data is received

from business partners, other internal systems and from third party

sources as well. Data is uploaded to the database using both manual

and automated feeds. Manual database upload is done either using

web-based tools or direct upload by the technology partners using Excel

macros typically. These reports are also archived and made available for

reference, historical reporting and compliance purposes. The reports are

generated in pdf format. Investment Reporter application features are

enhanced every year with new facilities for the clients.

Fund Fact Sheets (Marketing One Pager) Enhancements project is

being launched in an effort to accommodate NT growing Defined

Contribution business and the need to provide participant Fund Fact

Sheets. Currently, Fund Fact Sheets are being produced manually by

the NTGI Reporting Team. This development effort would automate the

process of creating Fund Fact Sheets for NT Defined Contribution

Product/Fund offerings. Testing effort involved automating the testing

script to generate fund factsheet based on the product category and the

product of the fund. Various front-end screens and backend data load

components were tested for functionality and correctness of the fonts,

Page 4 of 8 4 –

Swapnil Sonal 5

****************@*****.***

Contact Number: 630-***-****

Naperville, Illinois

colors, data content, dynamic menu options, graphs, charts and text

disclosures. Test scripts were automated using QTP tool to test varying

input data parameters like quarters

OneStop Reporting Center – Testing

Project Name

Major Financial Services Company

Client

Apr ‘08 – Mar ‘09

Duration

• Preparation of Test Plan

• Preparation of internal Test schedule from High level Project

schedule and adhere to the same.

• Escalate issues through Issue Tracker tool and track them to

closure

• Test Case Preparation / regular updation

• Test Case Execution, Regression testing, Performance testing

Roles & Responsibilities

and Adhoc Testing

• Log bugs and track them to closure

• DSR/WSR Preparation and forwarding for reporting manager’s

review

• Close interaction with the developers

• Participate in weekly team meetings

OneStop Reporting Center (ORC) will be the core reporting

application for all future reporting done by the investment bank to all

its clients and internal partners. It will combine several of the existing

products into a single access point which will greatly minimize the

training effort, operational effort, development effort and

inconsistencies across the various products related to viewing and

Project Description running reports while increasing the available functionality. The

project consisted of about 700 test cases. About 80% of the test

cases related to front end testing were automated using QTP. The

backend database objects and components were tested manually.

About 400 accounts were created as test data and inputted as testing

parameters to the online report generation system.

Email Manager System – Database Migration – Testing

Project Name

Major Financial Services bank

Client

Jan ‘07 – Mar ‘08

Duration

•

Roles & Responsibilities Analyzed the Business requirements, performed ambiguity

Page 5 of 8 5 –

6

reviews and communicated the inconsistencies between the

requirements and application.

• Developed software test plans, test design specifications, and

test scripts for various test scenarios.

• Extensive knowledge of banking call center operations and as

extensively tested the functionality of email manager system

integrating with Web-based front-end applications and Customer

Relationship Management backend applications.

• Extensively tested the functionality of Email Manager System

like email bounces, email archivals and email repository.

• Analyzed the business requirements and developed

the Detail Test Plan and the Test Strategy.

• Performed Black Box Testing -Functional and System Testing

and UAT.

• Prepared Bug Report and Interacted with developers and

project manager.

• Performed module, Integration, system and regression

testing.

• Involved in writing SQL queries and compared the data from

Siebel database with the Siebel UI data

• Worked with management for compliance issue and

deliverables.

• Scheduling and estimation, requirements gathering,

functional specification, risk identification and management.

• Created and executed test scripts based on functional

requirements using Test Director.

• Reporting defects/problems into Test Director and document

steps required to analyze and resolve the defects.

• Involved in Test Data Preparation and Optimization.

• Responsible for all QA major release of the channels and

packets.

• Responsible for end to end testing of the new functionality to

be released.

• Tracking & communicating test plans, test results, analysis, &

unresolved problems.

• Providing testing and post verification support on system

post-implementations.

Amex business partners requirement was to ‘go-green’ and give their

customer an option to select either paper or paperless delivery of their

banking correspondence like Bank Statement and bank offers,

promotional and marketing requirements. The email addresses of all

the customers and their privacy options were stored on different

Project Description

system within the organization.

The goal of the project was to integrate all emails with their privacy

choices and customer details on a single database and make the data

available through XML- services to different applications within the

organization.

Credit Card Special Group

Project Name

Major Credit Card Companies

Client

Jun ‘06 – Dec ‘06

Duration

Page 6 of 8 6 –

Swapnil Sonal 7

****************@*****.***

Contact Number: 630-***-****

Naperville, Illinois

Team member – Developer/Tester

* Understanding detailed technical requirement and business

requirements,

* Coding and Unit testing of developed components

* Migration of developed components to UAT environment

Roles & Responsibilities

* Developing system test cases

* Supporting integration testing inquiries

* Providing post implementation support and production support to

the newly built system.

The project involved developing components for categorizing credit

card holders as Premium, Diamond and Gold card members. The

system involved merging and analyzing data from three different data

feeds and migrating to a database and running business rules engine

for categorizing card holders. Corresponding marketing emails were

Project Description

sent to the customers informing about the offers. A data warehouse

was also built to capture all base data used for categorizing the card

holders. The project involved mainly data migration and developing

scheduled processes around the database for updating, retrieving

and loading them on the data warehouse and data marts.

Project Name HR Training & Learning Management System – Backend Testing

Client NTPC – IT Unit

Duration Jul ‘05 – May ‘06

Team member – Developer/Tester

* Understanding detailed technical requirement and business

requirements of Training and learning Management System

* Creation of database objects using Oracle PL/SQL

* Migration of data to the database objects using bulk loading utilities

Roles & Responsibilities

* Creation of test strategy and test plans for Integration and UAT

* Creation of high level and detailed test conditions

* Identification and creation of test data

* Execution of test conditions, mark off results and submission of

testing status reports.

Project Description

The project involved setting up process and system for managing

training and learning requirements of the HR department. The project

involved studying the existing manual processes, mostly followed

using spreadsheets and word documents, and gathering detailed

system requirements. It involved setting up Oracle database to track

all the employee details and the mandatory training courses required

by each employee of the organization. The course completion

statuses of each employee are captured and regular reports of

Page 7 of 8 7 –

8

management usage are generated. All the front-end and backend

components were tested and handed over the systems and

infrastructure teams. The testing spanned for about 6 months

including System, Integration, User Acceptance Testing followed by

post-production verification. Most of the testing and screen navigation

was automated using QTP tool and test logs were verified using the

same.

Page 8 of 8 8 –

Contact this candidate