OBJECTIVE:

To add value to the organization, by using the best of my Knowledge, Managerial skills, Various Database knowledge, Creative, Analytical and Automation ability to produce markedly improved results and to excel in the field through constant learning by experiences.

SUMMARY:

• 12+ years of experience in IT enabled services, Professional Management, including supervision of both local and regional Database such as Mainframe, DB2 UDB, Oracle and SQL Server.
• Managing different technologies such as Mainframe zOS DB2, Oracle, DB2 UDB and SQL Server.
• Managing and Leading a team of 22 + DBAs to support and drive them to achieve SLA targets.
• Familiar with all aspects of IT operations, ITIL Framework, Project Management, IT Helpdesk Management, Change Management, Performance Improvement Techniques.
• Keen learner with ability to grasp new technologies, software and hardware, have an ability to rapidly achieve organizational integration, assimilate job requirements and employ new methods and technology
• Energetic and self - motivated team player, proven ability to work in both independent and team environments.
• Ability to handle simultaneous and prioritize multiple projects and meet deadlines effectively with Time Management Skills.
• Effective and Efficiently Managed crisis situations to resume services within stipulated SLA time window that has been agreed with Business
• Good communication, interpersonal, leadership skills, adaptable and efficient in work situations with changing responsibilities.

SOFTWARE SKILLS:

Programming Languages: COBOL, JCL, Core Java 2.0, HTML, XML, Rexx

Operating Systems: Windows 95/98/NT/XP/7, Linux, MVS - OS/390.

Oracle Utilities: QMF, OEM, RMAN, Datapump, NID, DBverify and oerr

Tools: SPUFI, DCLGEN, FILEAID, INFOMAN, ManageNow, AWR and VMWare

Version controller: ENDEVOR, ChangeMan v5.2.5

Scheduling Tool: CA-7

RDBMS: Oracle9i/10g/11g, DB2 v7.1

EAI: Confidential MQ Series 5.3

PROFESSIONAL EXPERIENCE:

Technical Manager

Confidential

Responsibilities:

• Planning - Draft Project Plan for various stages of the Project Subsequently reviews and finalizes the project Plan.
• Effective and Efficiently Managed crisis situations to resume services within stipulated SLA time window that has been agreed with Business.
• Provide Guidelines & Inputs to Senior Technical Leads to subsequently review the Program Specifications and further mange the project schedule.
• Managing workloads.
• Support resource and vendor management.
• Insisting team members on Proactive monitoring and frequent health checks to attain the right functionality and also ensure quality in terms of optimization and performance.
• Managed high severity incidents by profiling the right solutions and resources at the right time.
• Subsequently finalize the requirements with the respective Project Managers to produce the finalized Business Requirement Document for signoff.
• Responsible for identifying training needs, tracking performance, coaching, and motivating direct reports.
• Responsible for Yearly Compensation, and Performance evaluation by conducting one on one.
• Responsible for Resource Hiring, Separation

DB Specialist and Technical Lead

Confidential

Platform: OS/390, COBOL, JCL, VSAM, DB2, Rexx, CA-7,BMC Software, Endevor, In-sync, File-Aid

Responsibilities:

• Lead a team to automate all the procedural activities that in turn fetched the expected ROI
• Managing and enforcing detailed project schedules from proposal to implementation, coordinating activities of project teams, identifying project issues, organizing and verifying documents, communicating project information and assuming additional responsibilities as assigned.
• Plan, coordinate & delegate work assignments for DBA Oracle/SQL team members.
• Formulate and define systems scope and objectives through needs analysis and business requirements.
• Manage and administer the study, analysis, and evaluation of current and projected computer-based applications systems and procedures, as well as the design, implementation, and maintenance of revised or new systems.
• Develop and establish department standards and procedures, and coordinate the technical support and direction to programming, operations and other departments.
• Responsible for leading and mentoring less experienced staff. Manages a work unit and/or group.
• Business Requirements Phase - Perform Techno-Functional role to facilitate the new Business requirements that evolve from the various Business Managers / Users and as well from the Central Clearance Management Team.
• Overall responsibilities for project status, meetings, reporting, scope changes, financials, administrative and technical issues.
• Perform DB2 LOADS, UNLOADS, Image copies, RUNSTATS, BINDS and other DB2 core utilities in developer test and staging DB2 environments.
• Establish, migrate and recover application baselines capturing structure and record definitions and data within a DB2 subsystem at a point in time.
• Provided analysis and programming utilizing COBOL II, VSAM, DB2, and IMS/DB in a TSO/ISPF JCL batch and CICS on-line environment.
• Provided on-call batch production support for clients CICS utility applications. Components include Billing and ordering system's executing in an IMS/DB, VSAM, DB2, CICS and JCL batch programming environment.
• Provide on-call production support and troubleshooting for COBOL, DB2, CICS Title Plant system and JCL nightly batch train.

Confidential

Platform: OS/390, COBOL, PLI, JCL, VSAM, DB2

Responsibilities:

• The work involves generating new QMF - Queries, PROC’ and Forms as per user’s requirement.
• Preparing Unit test cases, Testing and debugging the modified components
• Creating Load Cards for loading DB2 Tables

Confidential

Platform: OS/390, COBOL, Easytrieve, IMS DB/DC, JCL, VSAM

Tools: ChangeMan, FILEAID.

Responsibilities:

• Analysis of changes to be done
• Coding for CSR (Client Service Request) as per BSDR
• Modification of existing VSAM programs
• Preparing Unit test cases, Testing and debugging the modified components
• Mentoring IMR’s in InfoMan and ManageNow assigning to appreciate queues

Confidential

Platform: OS/390, COBOL, Easytrieve, IMS DB/DC, JCL, VSAM

Tools: ChangeMan, FILEAID.

Responsibilities:

• Coded JCL’s and PROC’s as per AID documents
• Modify code changes in Easytrieve program
• Prepared Unit test cases, involved in Unit testing and Integration and System testing.
• Provided support during for UAT Testing

Confidential

Platform: OS/390, COBOL, UNIX, JCL, Oracle Stored Procedure

Tools: CA-7 Scheduler, FILEAID, RSH and FT

Responsibilities:

• Analysis in GQTS Dual Environment Batch Jobs Strategy
• Involved in GQTS 6.x Mainframe Jobs Back Out Strategy
• Involved in preparing specification for System Installation Guide
• Involved in Unit testing phase
• Provided support during for UAT Testing
• Mentoring Job Queues in CA-7

Confidential

Platform: OS/390, COBOL, CICS, JCL, VSAM, DB2

Tools: FILEAID

Responsibilities:

• Modify JCL’s and PROC’s and code changes in CICS programs as per requirements.
• Writing of Test plans, scenario documents, and Test cases.
• Adhoc Testing of the application.
• Reporting the defects in the (Fast Bug) - Defect tracking tools
• Develops logical models, block diagrams and logic flow charts
• Involved in peer review of test cases prepared by other team members and gave review comments.

Confidential

Platform: OS/390, COBOL, CICS, JCL, VSAM

Responsibilities:

• Writing of Test plans, scenario documents, and Test cases.
• Adhoc Testing of the application.
• Reporting the defects in the (Fast Bug) - Defect tracking tools
• Develops logical models, block diagrams and logic flow charts
• Involved in peer review of test cases prepared by other team members and gave review comments.