AVIK KUMAR BISWAS

Cognizant Technology Solutions

Corporation

V 7.5 years of professional expertise in Database & Mainframe Performance

engineering

V Highly proficient in DB2 for LUW & z/OS Database administration &

Maintenance

V Expertise in development of DB2 v9.7,v10.5 for LUW

V Highly proficient in handling Performance Issues for mainframe Batch

window running long or having significant CPU consuming jobs

V Proficient in System performance monitoring using a variety of tool

V Involved in short term consulting assignments for Capacity planning &

Load testing

V Worked with different clients in various capacities in different domains

V Languages speak-English, Hindi, Bengali

Mobile: +1-602-***-****

Home: +1-602-***-****

E-mail: acedkx@r.postjobfree.com

Location: Phoenix, Arizona

1. Career Objectives

. I intend to establish myself as a software architect with an integrated

business solution provider through a long time commitment, contributing

to the company's growth and in turn emerging as a flourishing software

engineer.

2. Technical Competencies

DB2 for z/os V7, V8, V9 DB2 for LUW V9.7,V10.5

Enterprise COBOL Vmstat, IOstat,Topas

JCL,VSAM Snapshot for DB2

SMF-RMF DB2TOP, IBM Optim

ENDEVOR, Omegamon for DB2 Jmeter v 2.4

BMC tools for DB2 MONGO DB

FILE Manager TMON for DB2

EXPLAIN, BMC InTune SPUFI,QMF

IBM APA, Compuware Strobe ORACLE

3. Other Competencies

. Operating Systems: Windows, OS/390,Linux (Red Hat Enterprise Linux 4)

Unix (IBM AIX on pSeries, SunOS on Sunfire V440 sever)

. Programming Language: C, C++, Core Java, PERL, Unix scripting

. Tools: Mercury Load runner V8.0, Jmeter, TIBCO HAWK, VMware Server, IBM

Tivoli Provisioning Manager, TCS core banking product BANCS, Erwin data

modeler, OPC

4. Educational Qualifications

. B.Tech in Mechanical Engineering from National Institute of Technology,

Jamshedpur (From 2002 to 2006)- CGPA 8.87

. Higher secondary- West Bengal Board of Higher Secondary Education -79.5%

. Secondary- West Bengal Board of Secondary Education - 88%

5. Professional Experience

. Cognizant Technology Solutions India Pvt. Ltd. (August 2009 to till date)

. Tata Consultancy Services (September 2006 to August 2009)

6. Onsite Experience

. American Express - Database Performance Tuning, Load testing, Stored

procedure Development, Database Administration (March 2011- Till Date)

. Bank Of China- Database Administration & Application Enhancement

(Nov 2008-May 2009)

7. Clients & Domain of work

. American Express - Banking

. QWEST Communications - Telecom

. Kohl's - Retail

. Bank Of China - Banking

. Capital One - Banking

. United Health Group-Healthcare & Insurance

. British Telecom- Telecom

. GE Money - Financial services

. Legal & General - Insurance & Financial Services

. Cingular AT&T- Telecom

. Union Bancaire Priv e - Banking

8. Responsibilities

Performance Engineer :

. Managing team members for successful execution of assignments in Onsite

. Analysis of applications/Database codes for enhancing the performance by

reducing execution time

. Analysis of snapshot, Optim data, db2top to truobleshoot the CPU hoggers

in the database

. Analysis of Job flow & implementation of parallel execution

. Analysis of SMF-RMF Data to extract the data for finding system

bottlenecks

. Analysis of APA/Strobe/InTune report to drill down the job level

consumption details

. Providing recommendations in COBOL by changing code logic

. Analysis of SQL using EXPLAIN & QMF

. Online monitoring of DB2 query & system performance using TMON for DB2

. Provide recommendations for writing SQL for optimum CPU utilization

. Analysis of Batch Job for Batch Window Reduction

. Quantification of the recommendations provided for calculating the

average savings in CPU/Elapsed time

. Analysis of Language Environment variables & Cobol Runtime parameters for

improving performance

. Analysis of DASD & Cache subsystem parameters for finding opportunities

for improvement

. Involved in Capacity planning, Load testing, Reliability & Availability

testing

. Mainframe job scheduling or changing flow diagram using OPC

Database Administration:

. Creation/Alteration of DB2 objects(i.e. table,tablespaces, bufferpool,

Index)

. Analysis of Deadlock & Timeout in DB2 subsystem

. Implementation of table Archival policy

. Implementation of DB2 new features wherever applicable for performance

gain

. Development of process for routine REORG, RUNSTATS for required tables in

a database

. Backup of Databases, Clearing archive logs, analysis of DB2DIAG log

. Tune zPARM of DB2 subsystem

. Analysis of Query access path by executing EXPLAIN

. Execution of FLASH COPY/Image Copy of Database

. Data modeling using Erwin data modeler

Development/Testing:

. Development of Stored procedures in PL-SQL in DB2 for LUW v 9.7

. Running Load testing using Jmeter tool

. Development of COBOL & SQL code provided for performance tuning

recommendation

. Execution of testing for the changed codes & Guiding team members for

enhancing application codes

System Analysis:

. Identification, categorization and rationalization of client's

application portfolio & provide strategic roadmap for short & long term

gains

. Integration of application modules with Mainframe in distributed platform

ensuring system Availability & scalability as per business requirements

. Involvement in Performance assessments & health check of system

. Involvement in Capacity Planning assignments to forecast database

headroom capacity

9. Other Details

. Visa: H1B valid till Dec 2015

. Date of Birth: 23rd May 1983

. Native: Kolkata, West Bengal, India

1

Contact this candidate