Post Job Free

Resume

Sign in

Project Sql Server

Location:
Bangalore, KA, India
Posted:
June 26, 2014

Contact this candidate

Resume:

Professional Background

. Over** years of experience in Software Testing in BFSI, Life Science and

Healthcare including both Manual and Automation Testing.

. Proficient in Web based Client Server related applications, Mainframe

Testing, and Database Testing and Good Hands on Experience in Automation

Testing using QTP, Win Runner and Silk Test.

. Thorough implementation of testing methodology, Planning and Meticulous

Tracking.

. Good Knowledge in Test Automation using Automation Tools like

WinRunner,QTP.

. Expertise in testing techniques and processes.

. Created Effort Estimation, Design, Development and Testing.

. Process oriented approach in accomplishing high quality deliverables

before timelines. Also involved in Metrics collection, Audits and KT

sessions.

. Good leadership skills and have lead the team and brought in lot of

appreciations from the client for the projects with good analytical,

technical and communciation skills.

Professional Experience

Name of the Designation From To Duration (Years)

Organization

Cognizant Senior Jan-2011 July-2013 2 Years 6 Months

Technology Associate

Solutions, Chennai

Polaris Software Consultant May-2006 Dec-2010 4 Years 9 Months

Lab, Chennai

Mastek Private Senior Oct-2005 April-2006 7 Months

Limited Software

Engineer

Ramnarayanan Software Sep- Sep-2005 4 Years 1 Month

Software Solutions Tester 2001

Private Limited

Educational Qualification

. MCA (Master in Computer Application) from Pondicherry University,

India

. Master of Commerce (Finance) from Pondicherry University, India

. Bachelor of Commerce from Pondicherry University

Professional Training and Certifications

. Attended Quick Test Professional 8.2 Training in Polaris Software Lab

Ltd., Chennai.

. Attended Treasury Management, Forex and Payment Systems in Polaris

Software Lab Ltd., Chennai.

. Polaris Certified Insurance Professional

. Trained in ETL Tool - Informatica 7.1.3

. I.C.W.A.I. (Inter) Certified by Institute of Cost Works Accountant of

India in 1996.

Roles and Responsibilities

. Test Planning, Effort Estimation, Work Allocation, Defect

Tracking and Status Reporting.

. Test Scenario Designing, Preparing, Reviewing and Executing

Manual Test Cases.

. Preparation of Automation Test Scripts and Execution of scripts

. Interaction with Business / Clients.

Technical Skills

Testing Tools QTP10.0, SilkTest 6.5, WinRunner 7.5 & SOAP UI

Operating System AIX 5.3, Windows NT4.0 / 2000 / XP, MVS OS/390

Programming C, C++, JCL

Languages

Databases and MS SQL Server7.0, MS SQL Server 2005, DB2, Teradata

Tools

Scripting ASP.NET, VB.NET, JavaScript, VBScript, XML

Languages

Defect Management QC10.0 and Clearquest 7.0

Tools

Certifcations

. Trained in ETL Tool - Informatica 7.1.3

. HP QC9.2 Certified Professional

. I.C.W.A.I. (Inter) Certified by Institute of Cost Works Accountant of

India in 1996

Project Experience :

Name of the Organization: Cognizant Technology Solutions - Jan'11 to

July'13

Project # 1

Name of the Client: Cigna

Project Name: IFP Project

Duration: Sep 2012 to June 2013

Technology: J2EE, SOAP UI, Oracle DB and QC10.0

Role: Project Lead

Project Description: IFP will materially grow its supplemental business

through product and geographic expansion as well as through a robust

marketing and sales/distribution model

The current IFP platform will not meet IFP's scale or multi-product

capability requirements nor the flexibility needed to effectively compete

as a retail consumer business.

Therefore, IFP must establish a modern platform to sell and administer

medical and supplemental products leveraging, where possible, existing

Enterprise solutions and investments

Project Role and Responsibilities:

. Assigning Task for the Team

. Helping the Team Members with regard to functionality

. Preparing the Status Report to the client

. Involved Process related Activities like metrics.

. Conducting Team Meeting Regularly, Coordinating and interacting with

the Team on daily basis

. Involved in Metric Collection Activity.

. Involved in Audits.

Project # 2

Name of the Client: Johnson and Johnson

Project Name: Digital Solutions Regression Project

Duration: July 2012 to Aug 2012

Technology: J2EE and QC 10.0

Role: Project Lead

Project Description: Manual Test Execution for the Trident Pro Application.

Converting the Test Case Document (Word Document) into Quality Center using

Excel Macros.

Project Role and Responsibilities:

. Assigning Task for the Team

. Coordinating and interacting with the Team on daily basis

. Helping the Team Members with regard to functionality

. Preparing the Status Report(daily and Weekly) and presenting the

Weekly Status Report to the client

. Involved Process related Activities like metrics.

. Conducting Team Meeting Regularly and adhering their issues.

. Helped the Corporate Application Group in issue faced in oracle

integration related tickets.

. Worked in Report Data extract (RDE), Trial data extract (TDE) and all

kinds of Integrations and prepared Design Document for different

activities.

. Development of custom Reports.

. Involved in Metric Collection Activity.

. Involved in Audits.

Project # 3

Name of the Client: Walgreens

Project Name: Pharmacy Account Receivable System

Duration: Jan 2012 to June 2012

Technology: J2EE, Oracle9.1, UNIX

Role: Project Lead

Project Description: Pharmacy Accounts Receivable System (PARS) system is

used to ensure that Walgreens get paid for every prescription it fills. It

handles the claims made by customer while purchasing medicines. These

claims are provided by the insurance companies to the customers. The

insurance companies provide the amount of these claims to the bank and in

turn bank provides the amount to PARS. PARS primarily take care of the

rebilling of the claims which did not match with the deposits received from

the bank.

Project Role and Responsibilities:

. Assigning Task, Coordinating and interacting with the Team on daily

basis

. Helping the Team Members with regard to functionality

. Preparing the Status Report(daily and Weekly) and presenting the

Weekly Status Report to the client

. Involved Process related Activities like metrics.

. Conducting Team Meeting Regularly and adhering their issues.

. Involved Process related Activities like metrics and Conducting Team

Meeting Regularly and adhering their issues.

Project # 4

Name of the Client: Take Care Health Systems

Project Name: OHM Web

Duration: Sep 2011 to Jan 2012

Technology: QTP10.0 and Craft Technology

Role: Project Lead

Project Description: Take Care Health occupational platforms Medgate

and OHM are consolidated into one web based application in order to

create one standard platform for all the clients. Pure Safety hosts

this brand &

the objective would be to test the key requirements which are

specific the needs of TCHS clients and

ensure all the existing data has been migrated properly from existing

application to new application

(New Occupational Health Manager (i.e. OHM Web). At the end of the

project development cycle,

the user should find that the project has met or exceeded all of

their expectations as detailed in the

Requirements.

Project Role and Responsibilities:

. Role Creation and Assignment for the Projects.

. Involved Process related Activities like metrics.

. Conducting Team Meeting Regularly and adhering their issues.

. Involved in preparing PMR

Project # 5

Name of the Client: Bayer Health Care

Project Name: Bayer Abbi Itrak Reports

Duration: Jun 2011 to Aug 2011

Technology: Itrak Tool and Teradata

Role: Project Lead

Project Description: Cognizant's pharmaceutical data management product

components iTrak and CODE collectively forms the core of ABBI solution

architecture and helps in answering the business needs of Bayer ABBI. CODE

will drive the ABBI data repositories while iTrak will drive the reporting

layer integrated to the CODE repository structure. Both these platforms

comprehensively provide for ABBI's platform components in an integrated

manner ranging from back end data processing to data storage to front end

reporting

Project Role and Responsibilities:

. Understanding of Business Requirements

. Execution of Regression Test cases in UAT Environment

. Raising Defects and shared with the Development Team

. Prepared Regression Project Closure Report - Findings and

Recommendations

Project # 6

Name of the Client: TIAA, USA

Project Name: Web Projects

Duration: Jan 2011 to May 2011

Technology: Java Web Application and Mainframe

Role: Project Lead

Project Description: Teacher's Insurance Annuity Association (TIAA) is a

Fortune 100 financial services company and a leading provider of retirement

benefits nationwide. TIAA is providing service, support and the value that

you need to effectively manage practice and their client relationships.

Regional Directors meet with interested advisory firms to discuss all

aspects of their relationship, including the many potential ways that you

can partner with TIAA-CREF Asset Management.

Advisor Sales Consultants establish and maintain relationships, ensuring

that each firm thoroughly evaluates its needs and maximizes the benefits of

TIAA-CREF's investment expertise.

Project Role and Responsibilities:

. Role Creation and Assignment for the Web Projects.

. Involved Process related Activities like metrics.

. Involved in Billing Advice and Invoice Creation.

. Conducting Team Meeting Regularly and adhering their issues.

. Involved in preparing PMR.

Name of the Organization: Polaris Software Lab - May'06 to Dec'10

Project # 1

Name of the Client: DTCC, USA

Project Name: NYPC Engine Reporting

Duration: March 2010 to Jan 2011

Technology: Java Web Application, QTP 10.0 and Mainframe

Role: Project Lead

Project Description: New York Portfolio Clearing (NYPC) combines the

clearing expertise of DTCC's Fixed Income Clearing Corporation (FICC) with

the market expertise of NYSE Euro next's NYSE Life U.S.

Futures exchange to offer innovative risk management, clearing and

settlement efficiencies

for U.S. fixed income securities and derivatives. By margining cash and

derivatives in a

"single pot," NYPC will bring together the cash positions with their

natural derivatives hedge

in a manner designed to substantially improve operational and capital

efficiency. It will

provide a single view of risk across asset classes and provide regulators

the ability to

monitor market participants' total exposure across multiple interest rate

asset classes.

Changes include new and altered reporting, changes to Master files and CFM

systems, and

changes to various risk systems to support MSA obligations.

Project Role and Responsibilities:

. Understanding of Business Requirements

. Preparation of Test cases and Test data for UAT

. Functional and Regression Testing for UAT

. Raising Defects in Clear Quest

. Preparation Of Status Reports

Project # 2

Name of the Client: DTCC, USA

Project Name: DTC Phase

Duration: Dec 2009 to Feb 2010

Technology: Java Web Application and Mainframe

Role: Project Lead

Project Description: The aim of this project is to further enhance Risk

Management's ability to monitor risk exposure and concentration at DTC.

This project will enhance certain market risk and securities valuation

functions and provide advanced reporting capabilities for DTC positions.

iDTC Phase 2 will use the existing reporting infrastructure successfully

completed in the pilot program to now build active monitoring tools. The

reports will also be enhanced to include other available data.

Project Role and Responsibilities:

. Understanding of Business Requirements

. Preparation of Test cases and Test data for UAT

. Functional and Regression Testing for UAT

. Raising Defects in Clear Quest

. Preparation Of Status Reports

Project # 3

Name of the Client: DTCC, USA

Project Name: Customer Reporting

Duration: June 2009 to Nov 2009

Technology: Java Web Application

Role: Project Lead

Project Description: Fixed Income Clearing Corporation (FICC) is to develop

central counterparty (CCP) capabilities for the clearance and settlement of

mortgage-backed securities and government securities. The main objectives

of the project are Implement new FICC Hermes Calculated Components Logic,

Develop GSD and MBSD Clearing Fund Required Deposit and Funds on Deposit

Report full and half letter, Modify/Develop various internal (WEB) and

external (Report Center, E-Mail) Enterprise, GSD and MBSD Reports and

Screens. This project also provides all the reporting requirements, the

remaining internal and all customer facing/external, needed to support FICC

Portfolio Margining Implementation to customers. Hermes is a report

generating application used by the Clearing Houses such as GSD, NSCC and

MBSD.

Project Role and Responsibilities:

. Understanding of Business Requirements

. Preparation of Test cases and Test data for UAT

. Functional and Regression Testing for UAT

. Raising Defects in Clear Quest and Preparation Of Status Reports

Project # 4

Name of the Client: SJP, UK

Project Name: SJP-MIS Reporting

Duration: Jan 2009 to June 2009

Technology: SQL server 2005 environment

Role: Project Lead

Project Description: The proposed system design should help produce a

simple and effective multi-dimensional Client Data Mart that will achieve

the following objectives for SJP's MI Division:

. To automate and generate reports that will help produce business

analytics on various dimensions identified in this document

. To make report generation from Client data mart easier than CDB

. To Support business analytics across multiple dimensions like time,

geography

. To replace the existing MS-Access Database that will reach its

capacity limits very soon

Project Role and Responsibilities:

. Understanding of Functional Requirements

. Preparation of Test cases and Test data.

. Uploaded the Test scenarios and Test cases to QC 9.2

. Functional and Regression Testing

. Logging the defects in IPlan

Project # 5

Name of the Client: CITIGROUP, USA

Project Name: SME Poland Portal Construction

Duration: May 2006 to December 2008

Technology: C#, .Net, SQL server 2005 environment, Team Track

Role: Project Lead

Project Description: The growth and market expansion of the Small and

Medium Enterprise (SME) market has mandated the need to restructure the

current Citi Direct Offerings to match the client's need to manage their

Cash Flow more effectively and efficiently. The Business Requirements from

the SME market detail the need for a single system approach that provides

various Services like DDA, Payments, Direct Debits, Loans and Investments

all under one roof. The SME Poland Portal is a single application, which

will be customised to accommodate the business requirements from SME

market. The various modules involved in this Portal are Homepage, Cash

Accounts, Payments and Collections. This Portal also includes the

navigation to other single sign-on application such as Delphi, GIP and OLT.

Project Role and Responsibilities:

. Understanding of Functional Requirements

. Preparation of Test scenarios, Test cases and Test data.

. Updation of Traceability Matrix

. Uploaded the Test scenarios and Test cases to QC 9.2

. Functional and Regression Testing

. Logging the defects in Team Track

Name of the Organization: Mastek Private Limited- Oct'05 to April'06

Name of the Client: Provident Financial, UK

Project Name: Fund Lending System

Duration: Oct 2005 to April 2006

Technology: VB6.0, SQL Server2000, Windows 2000

Role: Senior Tester

Project Description: The Home Banking Credit System is for lending of

credit to Home users. The available roles are Performance, Security &

Administration. All Fields in the System are created in Primary New Field

System. The Consolidated Data are transferred to CNFS and can be viewed in

reports. All the functions are performed in LNFS where a New Agent, Agency

& Branch could be created. The Project consists of Primary Modules, Primary

New Field System (PNFS), Local New Field System (LNFS), Consolidated New

Field System (CNFS) and Data Migration.

Project Role and Responsibilities:

. Performed Requirement study to identify Test Scenarios

. Preparation of Test cases, Test Data and Execution of Test Cases of

Data Migration

. Preparation of Defect Tracking and Reporting

Name of the Organization: Ramnarayanan Software Solutions Private Limited-

Sep'01 to Sep'05

Project # 1

Name of the Client: Arya Vysa Bank

Project Name: Direct Banking System

Duration: June 2003 to Sep 2005

Technology: VB.NET, MS SQL Server 2000, Windows 2000, WinRunner 7.5

Role: Tester

Project Description: DBS is an integrated modular core banking software

application designed for medium sized Banks, incorporating sophisticated

accounting procedures tailored to specific banking needs. This system has

a front-end interface for all Processes of bank, with other bank related

transactions activities to provide meaningful interaction between different

types of Customers and Banks. This system allows Customers for new

memberships, Loans, Deposits, Accounts and Investments etc. the officer

will make the Transactions and will be crosschecked by the Manager. Major

Modules are Loans, Deposits, Accounts and Investments and Credits.

Project Role and Responsibilities:

. Performed Requirement Study

. Preparation and Execution of Test Cases & Test Data

. Preparation of Test Script for Automation, Defect Identification,

Logging and Defect Reporting

Project # 2

Name of the Client: Suraksha Medicare System

Project Name: MedicalCare System

Duration: Sep 2001 to May 2003

Technology: Windows 2000 & J2EE, JSP, TomCat 5.0, MS SQL Server

Role: Tester

Project Description: The Suraksha Medicare Systems (SMS) Ltd. envisages

providing the medical services globally through the electronic media with

minimum human intervention. The system involves networking of the doctors,

the consultants, the Pharma companies and the patients in a nutshell

economically. The motto is to empower doctors to deliver best treatment to

his/her patients through SMS.

The Medicare System is related to day-to-day healthcare process so as

to give the best healthcare solutions to their clients to implement

sophisticated solutions that support experienced physicians in working

smarter and more productively. This software allows doctors to reduce

the time they spend on administration and free them to focus on safe,

effective patient care. It is a consulting service, which links

Doctors, Specialists and Patients globally.

Project Role and Responsibilities:

. Assisting in developing the coding

. Executing Unit Test cases

. Preparation of Defect Logging and Defect Reporting

Personal Details

Name : B. Karthikeyan

Address : A3, Kamala Homes, Elim Nagar Second Cross,

Perungudi,

Chennai 600 096.

Phone Number : 91-988*******



Contact this candidate