Sr QA Analyst

Yogesh Ramesh Kulkarni.

*** ****** ***,**********, ** 15108

Mobile: - +1-412-***-****

Email: - ****************@*****.***

Date of Birth: - 7-Aug-1977

TECHNICAL SKILLS

Front-End Visual Basic 6.0 (COM)/VBA, VB.NET

RDBMS Oracle 8 /8i /9i, MS-ACCESS, SQL Server 7.0 / 2000 / 2005 (SSRS), Informix 9.4

DBMS Dbase, FoxPro 2.5 / 2.6

Tools Crystal reports 7.0 / 8.5 / 9.0 / 11 / 12, AGS Server Studio 6.1

Web Technology ASP, Java Script, VB Script

Testing Tools Test Director 7.6 / 5.0, Win Runner 7.0

Operating System DOS, UNIX, Linux, Windows 95 / 98 / NT / XP

EMPLOYER HISTORY

Company Name Designation Duration

Cognizant Sr. Consultant 13 Aug 2007 to till date

TechMahindra Sr. Technical Associate 24 Apr 2006 to 10 Aug 2007

Symphony Services Software Product Engineer 22 Aug 2005 to 21 Apr 2006

WNS Global Services ltd. Application Administrator for British Airways 22nd Oct 2003 to 19th Aug 2005

ANAND ERP (INDIA) pvt ltd. Software Engineer 5 July 2000 to 20th Oct 2003

PROJECTS UNDERTAKEN

Name of the project Software Used Team

Size Nature of Work Onsite/Offshore location

CACTIS VB, SQL Server 2008, Crystal Reports 9.0 & 11.0 6 Onsite POC, Development & Enhancement Pittsburgh (USA),

Pune (India)

JPMC GEM MOSS - RAD MS Access, SQL Server 2000, VBA 3 Analysis, Enhancement, Development, support London (UK), Chennai (India), Pune (India)

Share Register Analysis (SRA) VBA, Sybase and Factset (third party application) 8 Analysis, Development, Documentation Singapore

TKI-Macros

VB 6.0, VBA, Informix 9.4, AGS Server Studio 6.1 3 Development, Documentation Erfurt (Germany),

Pune (India)

DSS – Decision Support System HTML. ASP, VB 6.0, MS Access, Oracle 9i, SQL Server 2000 3 Analysis, Development, Documentation Pune (India)

CPGNETWORK

VB 6.0, VBA, Oracle 9i, Oracle Express Server, Oracle Analyzer, UNIX, XML 30 Analysis, Development, documentation Bangalore (India)

Corporate Directory Maintenance System VB 6.0, Oracle 9i 1 Analysis, Development, Documentation Pune (India)

Macro Development for Travizon – Other Airlines Vertical VB 6.0, Oracle 9i 1 Analysis, Development, Documentation Pune (India)

Bulk revokes system accesses for BABS-RTZ & BABS-RTB VB 6.0, Ms Access 2000 1 Analysis, Development, Documentation Pune (India)

Gymnasium Automation System VB 6.0, SQL Server 7.0, Seagate crystal reports 9.0 3 Analysis, Development, Documentation Pune (India)

Medical Retailer Shop System VB 6.0, Oracle 9i, Seagate crystal reports 9.0 3 Analysis, development, documentation, Training Pune (India)

Chat System

VB 6.0 1 Development, Installation, Training Pune (India)

Barcode Generation System VB 6.0, SQL Server 7.0, Oracle 8i, Barcode layout software (third party application) 1 Development, Installation, Training Pune (India)

Purchase, Inventory Modules of ERP VB 6.0, SQL Server 7.0, Seagate crystal reports 7.0 10 Development, Installation, client side maintenance Pune (India)

PROJECT DETAILS

Company Name Cognizant

Project CACTIS

Client ServiceLink (The national lender platform for Fidelity National Financial)

Onsite/Offshore Pittsburgh (USA)

Role Onsite POC, Development & Enhancement

Description The CACTIS project is aimed at providing the maintenance and

enhancements of the CACTIS application used for title and closing services

in the mortgage domain.

Value addition I have developed a tool which retrieves all SQL, tables, views, store

Procedures, functions and parameters have been used in a particular

Crystal Report(s) without opening report(s) and sub report(s). This tool

helps for developers while doing analysis, development, comparison and

testing.

Software Used VB, SQL Server 2008, Crystal Reports 9.0 & 11.0

Team Size 6

Company Name Cognizant

Project GEM MOSS - RAD

Client JPMC

Onsite/Offshore London (UK) (1 month), Chennai (India), Pune (India)

Role Development, Enhancement, Communication with application uses

Description Working on GEM P&L application. Developed interface to import data (SWAP, Bond, Funds, Fut, FX, Kapital) from different source files, calculate adjustment, daily, MTD, YTD P&L for EMEA market. Worked on daily summery and detailed P&L reports. Worked on enhancement of existing process such as split database, auto kickoff users from application. Also, working on production support.

Software Used MS Access, SQL Server 2000, VBA

Team Size 3

Company Name Cognizant

Project Share Register Analysis (SRA)

Client Credit Suisse

Onsite/Offshore Singapore (5 months)

Role Development and communication with the Factset helpdesk for queries related with third party application

Description SRA (Share Register Analysis) application manages corporate clients and

their share holding information. It helps Credit Suisse team to provide data

and analysis on corporate clients shares. The System consumes data from

different register systems and also custom data provider like FactSet and

generates different reports which helps corporate client in their decision

making. SRA application has to view share register information and

analyses for Corporate Broking clients (generated from registrar data from

SRA and holdings data from an external source).

Worked on designing user interface and 28 reports using VBA in Excel and

written stored procedures in Sybase which retrieves critical data from

multiple joins and tables. Displays the data in presentable formats and

graphs and convert the entire report into PDF file.

Software Used VBA, Sybase, Factset (third party application)

Team Size 8

Company Name Cognizant (T-Systems)

Project TKI Macro

Client T-COM

Onsite/Offshore Erfurt (Germany) (2 months), Pune (India)

Role Went to Germany for knowledge transition. Develop and maintain the applications. Prepare estimation sheet, understanding of requirement document and delivery document. Maintain timesheets, MOM, MIS, status reports, QC documents, pre & post translation of documents, invoicing. Also, handled a team (3 members).

Description T-COM currently provides several products like land-line and

Internet connections etc. Besides T-Com, there are several other services providers who also support such products. However, those other service providers are using T-Com infrastructure. In the above mentioned scenario, there are several processes that are running for various business cases (e.g.: new order, cancellation, change in service, billing information).

Sometimes processes in customer application cannot support certain

business cases in the given time frame. Thus processes for business

scenario need to be customized to suit the requirements of the end user of

customer application.

Software Used VB 6.0, VBA, Informix 9.4, AGS Server Studio 6.1

Team Size 3

Company Name TechMahindra Ltd

Project DSS – Decision Support System

Client AT&T (SBC)

Onsite/Offshore Pune (India)

Role Creation, enhancement, and maintenance of the DSS web sites development and support of DSS for all managed services (past, present and emerging. Answering end-user questions with respect to report query logic and site navigation. Performing standard troubleshooting practices to resolve physical and logical issues/problems.

Description DSS – Decision Support System. This application is primarily directed to

DSS and DCC systems, but may require extension into any intervening

systems that inhibit the ability to serve DSS and DCC end-users. This

application provides a variety of reports in EXCEL format to help MNS

teams better manage the business and track workflow for individual

projects/sites. Reports are generated automatically via daily, weekly, and

monthly batch processes.

Software Used HTML. ASP, VB 6.0, MS Access, Oracle 9i, SQL Server 2000

Team Size 3

Company Name Symphony Services

Project CPGNETWORK

Client Information Resources Inc, USA

Onsite/Offshore Bangalore (India)

Role Create objects in Oracle Express Server for data extraction from Oracle and DB. Development & troubleshooting of Script for data extraction and post processing in UNIX OS. Development of web user interface for clients. Development of VB cartridges. Design the Database. Testing and reviewing of the reports and documentation.

Description CPGNetworks is the first integrated business intelligence resource for

Consumer Packaged Goods Industry. It has more than 200 clients who

use this site to extract information to analyze product performance, market

share, improve business and make better business decisions. Data is

stored in the Oracle Data Warehouses. XML Job cards are created to

extract, manipulate & format the data. These jobs are submitted to

mainframe queues for batch processing. The format of the extracted data

is XML. This is further processed by Visual Basic and VBA cartridges &

executables and the output is made available to the client in the form of

Excel, Word and Power point reports. Successfully completed modules for

PEPSI, Campbell and Bruce Foods.

Software Used VB, VBA, Oracle 9i. Oracle Express Server, Oracle sales Analyzer, PERL,

UNIX, XML

Team Size 30

Company Name WNS Global Services LTD.

Description Working as an Application Administrator for British Airways in Information

Security Department. Have been administrating softwares such as

Amadeus, BABS-RTZ, COPYZ, UAT, PDT, MIG, BABS-RTB and COPYB

Responsibilities Provide system accesses as per requirements.

Provide support to international / domestic users.

Setting up system terminal’s access.

Resolving issues via emails and telephone calls.

Discuss with Customer about updates and queries.

Taking authorizations from concern authorizes for restricted accesses.

Maintenance and trouble shooting of various systems.

Sending reports to customer and programmer team.

Quality Testing.

Developing macros for process improvement.

Maintaining MIS of Team.

Maintaining DBR (Daily Business Report) of team.

Team Size 35

Company Name WNS Global Services LTD.

Project Corporate Directory Maintenance System

Client British Airways

Onsite/Offshore Pune (India)

Description System provides the discrepancy between the HR BA data (Mumbai,

Pune) and the Corporate Directory data of British Airways. Approximately

1500 staff working on BA vertical (Pune, Mumbai). HR BA data and the

Corporate Directory data will be updated into Oracle 9i and implementing

macros in MS Excel, will generate discrepancy report.

Software Used VB 6.0, Oracle 9i

Team Size 1

Company Name WNS Global Services LTD.

Project Macro Development for Travizon – Other Airlines Vertical.

Client Travizon – Other Airlines

Onsite/Offshore Pune (India)

Description In “Travizon Process” in the other airlines vertical, the report generation is

a repetitive task carried out at least 240 times in a day by the team.

However, the macro created reduces the processing time taken for

generating reports. Have developed this macro, which will automatically

transfer and filter the data from CSV and RTF files on entering the file

name. Automatically generates the Exception Report in the same excel file.

Software Used VB 6.0, Oracle 9i

Team Size 1

Company Name WNS Global Services LTD.

Project Bulk revokes system accesses for BABS-RTZ & BABS-RTB

Client British Airways

Onsite/Offshore Pune (India)

Description The macro accumulates the system profile’s that have not been used more

than six months and revokes them from the BABS-RTZ and BABS-RTB

systems.

Software Used VB 6.0, MS Access 2000

Team Size 1

Company Name ANAND ERP (INDIA) PVT. LTD

Project Gymnasium Automation System

Onsite/Offshore Pune (India)

Description This software is a total automation of the gymnasium. Software keeps

track of all members from the day of Enquiry, Admission, Medical history,

Training schedule, Measurement chart and Daily attendance.

This software also manages accounts of members in the Gymnasium. This Software provides reports like Bill generation of members, member wise attendance report, date wise attendance report, measurement report, enquiry report, membership expiry report, member wise payment report and date wise income report. I have worked on Enquiry process, registration process, progress card, attendance, Member wise payment, date wise income reports and bill generation process of members.

Software Used VB 6.0, SQL Server 7.0, Seagate crystal reports 9.0

Team Size 3

Company Name ANAND ERP (INDIA) PVT. LTD

Project Medical Retailer Shop System

Onsite/Offshore Pune (India)

Description This software is a total automation of the Medical retailer shop.

Software keeps track on Purchase, Sales and Daily accounting modules.

Above modules are linked with each other. I have worked on each and

every process on the software like Purchase process, Sales process,

inventory calculation process, and accounting process. Reports like expiry

items report, min/max order quantity report, generation of sales bill,

monthly purchase report, wholesaler wise purchase report, wholesaler wise

accounting status, daily income and expenditure status. I have also

customized reports as per client’s requirement; provide training of the

software to clients.

Software Used VB 6.0, MS Access 2000, Seagate crystal reports 9.0

Team Size 3

Company Name ANAND ERP (INDIA) PVT. LTD

Project Chat System

Onsite/Offshore Pune (India)

Description By using this software user can communicate information amongst each

other and broadcast Information and message. This software is for making

paperless communication, for BC Components Loni, Pune.

I have created user interface that provides list of users and notepad

facilities like cut, copy, paste, search, font style, size, and colors. Have

used Winsock control for communication between computers. Have

worked on development of the software and registered the same at client

side. Job responsibility also provides training of the software to users.

Software Used VB 6.0, Microsoft Visual Studio Help Workshop

Team Size 1

Company Name ANAND ERP (INDIA) PVT. LTD

Project Barcode Generation System

Onsite/Offshore Pune (India)

Description This software is for generating barcode for BC Components Loni, Pune.

Production Dept. Barcode label contains item code, type, quantity, rate,

and date. I have worked on data import utility. This utility imports data from

flat files of AS 400 to SQL Server 7.0 and then use for barcode generation.

Software Used VB 6.0, SQL Server 7.0, Barcode Layout Software

Team Size 1

Company Name ANAND ERP (INDIA) PVT. LTD

Project Purchase, Inventory Modules of ERP (Enterprise Resource Planning)

for the product Upcrest Software Solution.

Onsite/Offshore Pune (India)

Description In Purchase module, I have worked on Purchase requisition, purchase

Order with purchase requisition/ without purchase requisition and Goods

Receipt Report with PO/without PO by using DLL components for client

server technology. In Inventory module, I have worked on reports like

Stock List below min level, Stock List below re-order level and Stock List

above max level, Serial listing of Stock List. Job responsibility was carried

out by customizing reports as per client’s requirement solve their queries;

rectify errors and training of the software for Siro Plast Ltd., Pimpri, Pune.

Software Used VB 6.0, SQL Server 7.0, Seagate crystal reports 7.0,

Microsoft Visual Studio Help Workshop.

Team Size 10

EXTRA CURRICULAR ACTIVITIES

I have played Table Tennis for my school and college, and have been awarded as a

Runner-up for Inter college tournaments in the years 1995-96, 1996-97 and 1997-98 consecutively.

EDUCATIONAL QUALIFICATION

Masters in Computer Management, Pune University, Year 1998-2000 63.23%

ITIL V3 Foundation Certification Year 2008, March 70%

Attended training on Microsoft Project 2007 Year 2008, December

Contact this candidate