S UNNY VASH ISHT +91-974*******) E XPER IENCE /
S UM MARY
M r. Sunny Vashisht is currently working as Mainframes Specialist(DB2 System
p rogrammer) in AXA- TECH and have 8 years of experience in IT. He has total IT
experience 8+ years with 3 years of extensive hands on experience in DB2 System
P rogramming.
D B2 System Programmer- Company-
A XA TECH
Period- 17/11/2010 till now
Installed DB2 v7 on z/os
Installed DB2 v8 on z/os
Migrated DB2 v7 to v8 on z/os
Install, support and customize licensed DB2 software and related tools (the client
& 3 rd party vendors).
Upgrade DB2 subsystem environments to newly released versions.
Apply planned maintenance refreshes to supported DB2 environments
Provide t imely resolution to DB2 software related problems, including 24/7 on
call support.
Work with the clients Level 2 and vendor technical support teams to identify DB2
software related problems.
Receive, apply and propagate software fixes across supported DB2 platforms,
using SMP/E, etc.
Build new DB2 subsystem environments, or relocate existing DB2 subsystem
environments upon request.
Work closely with Operations and Automations teams in defining operational
p rocedures involving the DB2 subsystems
Provide technical recommendations involving the DB2 environments and tools
u pon request.
Respond to, and assist, as necessary, on DB2 subsystem related performance
issues
Participate in the planning and recovery of the DB2 subsystems as part of
Recovery Services.
Participate in the Problem/Change management process
Create and maintain documentation in support of the DB2 environments. (e.g.
Account level doc, Team procedures, Operational procedures, etc.)
Install Software upgrades/fixes for software, hardware compatibility, new
customer requirements and/or platform compatibili ty
Project planning and management of z/OS upgrades & product implementation.
Create and maintain documentation in support of the DB2 environments. (e.g.
Account level doc, Team procedures, Operational procedures, etc.)
Leadership and Project management
DB2 System Programmer- Company- BANK OF
A MER ICA ( India)
Period- 17/11/2008 till 16/11/2010
24/7 Production Support.
Migration of DB2 from V7 to V8.
DB2 Maintenance.
DB2 IBM tools Maintenance.
Administration and Maintenance of DB2 Catalog, Directory and ISV databases.
Disaster Exercise on various environments.
Worked on SMP/E extensively to install and upgrade products.
Install APAR,PTF’s etc using SMP/E.
Backup tasks for SMP, Run time libraries using ADRDSSU.
Clone of Subsystem Applications using DSN1COPY and REXX.
ZPARM analysis and modifcation.
Catalog REORG.
Maintaining DUMPs and creating ETR t icket.
Mentoring DBAs and Developers.
Company – CSC(Computer Science cooperation) Period- 17/06/2006 till
10/11/2008
Production Support/Scheduling/Operations/Batch Monitoring
Scheduling jobs/Batches in test and production Lpars using batch cards and CA7
tool.
Creating, auditing of scheduling packages through CHANGEMAN tool
Scheduling jobs using CA7 TOOL and BATCH scheduling language.
Created GDG bases using File Aid.
Good working knowledge of FI LE AID tool.
Creation of New Job and modifying current JCL’s.Check mainframe batch job
s treams, observing the status of batch job scheduling, batch job exceptions, and
associated incident/failure
Perform required restarts and recovery activities for incident failures. Perform
z/OS JCL overrides during recovery activities, as required by documentation
and/or directed by the support application teams. Pro-actively monitor and assist
team members in performing restart/recovery procedures and validate
Demanding job, cancelling job and restarting it from particular step using CA 11.
Monitor and process mainframe customer requests for scheduling changes
Migrations of Parms, Procs and JCL’s.
Deploying packages on Production LPARS using CHANGEMAN.
Send Daily ABEND and Resolution log to the Clients.
Involved in Month/Year End changes schedule.
Forecasting and sending jobs as per client requirement
Resolving diff types of look back issues in CA7.
I have worked for WIPRO,V-Customer & SS Enterprises for 2.5 years as
T echnical support executive for Windows before coming into the world of
M ainframes. (These were BPO’s)
Academics
Degree/Standard Board/University
M.C.A (Master in Computers Application) Punjab Technical University
B hartiye Shikha Parishad University,
B.C.A (Bachelor in Computers Application) L ucknow
12th (Sr. Sec School) C.B.S.E.Board
10th (Sec. School) C.B.S.E.Board
Certifications
1. MCSE 2003 (Microsoft certified system engineer)
2. CLP (Certified Lotus P rofessional)
Trainings Completed -
Months Topics
4 Months Training Mainframes App Development
1 month Training CA7 Scheduling
4 Months Training Z/OS-System Programming Training
3 Months Training DB2 System Programming
5 Days Training Project Management Practices (PMP)
2 Days Training Six sigma Basic Training
3 Days Training IT I L Foundation
Personal Details-
Name Sunny Vashisht
Email Address *************@*****.***
Contact Number 974*******
Date Of Bir th 3rd Nov 1984
2/61 Bhim Street Vishwas Nagar,Delhi-
Permanent Address 32,India
REFERENCES:
I will provide the references if it is required.
DECLARATION:
I consider myself familiar with I nformation Technology Aspects. I am also
confident of
my ability to work in a team. I hereby declare that the information furnished
a bove is
t rue to the best of my knowledge.