Senior Mainframe Consultant +1-402-***-****

(ablo8o@r.postjobfree.com)

Professional Summary

. 9+ years of IT Experience, Strong technical expertise in IBM Mainframe

technologies with Data warehouse tools & concepts - Z/OS 390, MVS,

TSO, ISPF, VS COBOL II, VS COBOL for OS/390, Micro Focus Cobol, DB2,

IMS/DB, SQL, PL SQL, T-SQL, CICS, JCL, PROC, VSAM, TOAD, Business

Objects, Core Java, Advanced Java, Unix, Panvalet, File-aid (for Db2

as well), IDCAMS, SORT, IEBGENER, IEFBR14, QMF, SPUFI, FTP, ISPF, TSO,

Endevor, EXPEDITER (Batch & Online), Sync sort, Db2 stored procedures,

Omegamon, AbendAid, InterTest (Batch & Online), Star Tool, Db2 tools &

Utilities, CA-tools/data bases, SmartTest, In sync, SCLM, NDT2,

Easytrieve, ECOS, BMC Db2, Remedy, C.Support, Connect Direct, EDI,

HTML, Vb Script, Java script & SQL Server.

. 24x7 production support as a primary response for both batch & online

abends.

. Experience in all phases of Software Development Life cycle (SDLC) -

Requirements Gathering, Analysis, Construction, Unit Testing, and

Support to various Testing techniques - Integration, Quality Assurance

(QA) Test, User Acceptance (UAT) Test, Regression Test, and Production

support.

. Experienced in installing 3rd party tools like Xpeditor, File-AID,

Manugistics, and File-AID for IMS, Db2 UDB etc and had special

interest in learning more of type.

. Strong experience in Migration projects.

. Worked/Working with Database modeling.

. Roles played: Application Developer, Programmer Analyst, Technical

Lead, and Application Lead.

. Interested/Willing to learn new technologies based on the business

requirement (rapid adopting ability for the new technology).

. Worked in both Highly-Structured and less-Structured IT

Development/Maintenance environments.

. Attended training classes on six sigma.

. General skills - Good Analytical, Problem solving and learning

capabilities, Proactive, Result oriented, Team player, Effective

Technical writing, Impressive oral/written communication, Excellent

Interpersonal skills, strong relationship with

clients/subordinates/company associates along with Project management

skills.

. Exceptional ability in grasping/adapting new technology based on the

project requirement.

. Well experience in suggesting process improvements in technically &

environmentally.

. Played key roles as Team Lead and as well as Onsite coordinator

between the offshore team and the client team members.

. Developed database changes when applicable under the direction of I/T

Management.

. Analyzed problems and solve on a day to day basis with appropriate 360-

degree user communication.

. Served on on-call rotation, handling overnight problem calls.

. Create weekly status report and participation in team meetings.

. Develop and work with various Db2 database objects - tables, views,

indexes and with db2 utilities like load, unload, repair, runstats,

explain, imagecopy, reorg etc.

. Ability to prepare technical design, project plan, unit test case

development, test result capturing, status report documentation.

. Served as subject matter expert (SME) in assigned area.

. Strong knowledge of programming / systems analysis, as well as quality

assurance, prototyping, construction, integration, and migration

functions; possesses a strong understanding of programming languages,

development tools, and the current environment.

. Possesses problem solving and analytical skills, using them to resolve

technical problems; possesses a strong understanding of business

requirements and IT strategies.

Technical Skills:

Operating System: Z/OS, OS/390, MVS, WINDOWS NT/95/98/2000/XP,

MS-DOS & UNIX.

Programming Languages: COBOL II, JCL, PL1, MF COBOL, C, C++, Basic,

FORTRAN, Easytrieve & IDEAL.

OLTP Interfaces: CICS & Business Objects Data Integrator (BODI).

Database: DB2, SQL-Server, IMS-DB, Oracle, MS-Access, CA-DATACOM & Db2

UDB

Database Tools: QMF, TSO, ISPF, TOAD, SPUFI, File-Aid (for Db2/IMS-

DB), BMC Db2, Db2 Utilities & SQL.

Quality Process: CMMI, ISO and Six Sigma.

Special Tools and Software: TSO, ISPF, Expeditor (for batch & online),

SmartTest, VSAM, Omegamon, File-Aid (for Db2 & IMS-DB as well), Star

tool, NDT2, Insync, Panvelet, SAR, SCLM, Intertest (for batch &

online) & FileZilla for FTP, Connectdirect & EDI etc.

Job scheduling Tools: CA-7 & Control-M

Version Controlling/Configuration Tools: Endevor, SCLM, ChangeMan &

PANVALET.

Communication Tools: Lotus Notes R6, Lotus Notes Same Time Connect

2.5.

Microsoft Office Tools: MS Word, MS Excel, MS Project, MS Access, MS

PowerPoint.

Data warehouse tool: Business Objects Data Integrator (BODI).

Trained technology: Oracle SQL, Visual Basic, JAVA, Data warehousing

concepts & ASP

Education:

Master's degree in Computer Science (Master of Computer Applications - MCA)

Bachelor degree in Computer Science

Experience Profile - Key Projects

Project: FIM (Feed Ingredients Duration: Aug '09 - Till date

Management)

Customer name: Gavilon LLC

Location: Omaha, NE, USA

Project Description:

Gavilon LLC is a commodity trading company in US that does trading

mainly in Agricultural commodities, Electricity and Natural gas.

Feed Ingredients Merchandizing (FIM) application is a Mainframe based

application used by Gavilon to handle contracting, shipping and

invoicing of commodities. Gavilon deals with commodities, which can

be broadly classified into two type's viz. Agriculture and Energy.

The FI application handles both these commodity types.

Roles & responsibilities:

Gather requirements via discussions/meetings with users, IT

Management.

24x7 support to production, provide resolution to night-time

production job abends, attend conference calls with business

operations, system managers if any issues in batch stream.

Develop solutions to the business under the direction of IT

Management.

Serve on on-call rotation, handling overnight problem calls.

Develop database changes when applicable under the direction of I/T

Management.

Analyze problems and solve on a day to day basis with appropriate

360-degree user communication.

Involved in batch cycles monitoring and ABEND fixing which part of

production support is and creating ABEND logs for future reference.

Providing the permanent fix the frequently getting abends.

Working with CICS, IBM MVS, SPUFI, ISPF, COBOL, VSAM, JCL, DB2, SQL &

File-Aid, Panvelet, Xpeditor, Intertest, CA/Db2 tools, TSO, Sync

sort, Db2 stored procedures, Control-M, BMC Db2, TOAD, SQL Server,

FileZilla for FTP, EDI & Connect Direct etc.

Created regressive test plans and conduct unit testing.

Work with Client I/T Management & staff for co-ordination of System

and end user testing.

Participate in Client/Team meetings send regular status updates and

Task assignments to the Team members.

Implementation of application changes as required, in accordance with

Gavilon SDLC policy.

Assess user inquiries and work with I/T management to determine

priorities.

Create weekly status report and participation in team meetings.

Providing class room training related to technology & application to

the team and new joiners.

Project: Schneider Electric Duration: Nov'2008 - July '2009

Customer name: Schneider Electric, USA

Project Description:

As a global specialist in energy management with operations in more

than 100 countries, Schneider Electric offers integrated solutions

across multiple market segments, including leadership positions in

energy and infrastructure, industrial processes, building automation,

and data centers/networks, as well as a broad presence in residential

applications.

Schneider Electric is a manufacturing company having its plants in

various locations in USA and Canada. Schneider Electric North America

(SENA) 40+ of its applications is based in IBM Mainframe technology.

This project handles most of the small enhancements required to the

Customer plants & production support for the applications AMAPS, Bill

of landing & Q2C (quote to cash - Invoicing & Shipping). Most of the

assignments handling are the small enhancements & Quick hits.

Roles and Responsibilities:

Work in the project at various stages of SDLC - requirements

analysis, design, Coding, Programming, Implementation, Unit testing,

Integration testing, support to Quality Assurance, User Acceptance

testing & post-implementation support.

Interaction with business users to get the business requirements.

Worked with CICS, IBM MVS, QMF, SPUFI, ISPF, MF COBOL, VSAM, JCL,

DB2 & File-Aid, Endevor, Xpeditor, TOAD, IMS-DB, SQL, Control-M,

CA/Db2 tools, Sync sort, Db2 stored procedures, Eazytrieve & Database

Modeling etc.

Active role in resolving the production issues and recommendations

for permanent fixes through database/code/functionality changes.

Support for queries and production issues reported by business users.

Translated business and functional design needs into technical

requirements.

Prepare and used Load/unload/Repair Jobs of DB2 tables and explained

to team members.

Different FTP setups for mainframe, Windows, LAN and UNIX downstream

and upstream feeders.

Preparing High Level, Low-level Functional Specification documents.

Involved in Unit testing, system integration testing and user

acceptance testing.

Participated in test data and test case preparation and unit testing,

test results documentation, review and UAT support.

Effort estimations based upon the requirement analysis.

Managed team of 6 members to get work done explaining the

requirement.

Conduct defect prevention meetings to minimize the common repetitive

errors in system development.

Review and rework on the review comments.

Project: EUROMS and E1m Support Duration: NOV'2005 - OCT'2008

Customer name: 3M, Europe

Location: Milan, Italy

Project Description:

EUROMS stands for the European Order Management System and is

responsible for the handling of all orders received from Customers.

EUROMS-II is a large system and is made up of several components or

Modules. Some of these Modules are databases such as the Customer

Profile while others are concerned with major parts of the order

process such as Shipping, Invoicing and the main one is Order

Management itself. Shipping: As the delivery of goods to the customer

is the key process for any supply chain management system, shipping

module is created to fulfill the need of a good delivery tracking

mechanism. When a customer order item reaches the warehouse status

(WH status code), the EII Shipping module undertakes the

responsibility of progressing it to a different stage till it reaches

the customer.

Roles & Responsibilities:

Dual roles as Onsite co-coordinator (between Clients and Offshore

team) and as consultant to the 9 different 3M regions (9 different

countries in Europe for 3M facilities)

Work in the project at various stages of SDLC - requirements

analysis, design, Coding, Programming, Implementation, Unit testing,

Integration testing, support to Quality Assurance, User Acceptance

testing & post-implementation support.

Interact with SME's and gathered the requirement/knowledge from them.

Good role as consultant in understanding the different 3M regions

queries/issues and providing prompt responses/resolutions. Also as a

consultant, distributing fixes/new enhancements to different regions

explaining the need & priority by understanding their business.

Analysis and review of Business Requirements, prepare System

Specification documents, Functional Specification, Design, coding &

programming of modules.

Worked with CICS, IBM MVS, CA/Db2 tools & utilities, TSO, SPUFI, QMF,

ISPF, COBOL, VSAM, JCL, DB2 & File-Aid, Endevor, Smarttest, PL1,

TOAD, CA-Datacom, SQL, Control-M, CA-Ideal, Sync sort, Db2 stored

procedures, EDI, Ad-Migrate & Ad-Build etc.

Presentation about the new enhancement to the clients for formal sign

off.

Worked with E1m systems mainly with Mainframe - JDE interface using

ECOS.

Agreed and maintained SLA's based on the issues severity.

Explain the business requirement to the offshore team and get the

work done by issuing the resolutions for their queries in time.

Review the deliverables received from offshore before sending them

for Super user (QA) testing and before implementing them in the

production environment.

Helped/Supported the super users in doing tests in QA environment for

the fixes/enhancements.

Primary responsible for AD-Migrate activities in migrating the

changes to the production and in distributing the changes to the

regions using AD-Build tools.

Created and updated the SMTD's regularly whenever there is a new

enhancement or major fixes.

Project: GTIN Conformance Duration: AUG'05 - OCT'05

Customer name: Albertson, USA

Location: Bangalore, India (offshore)

Project Description:

The Global Trade Item Number (GTIN) is EAN. UCC System identifier for

trade items that encompasses both products and services. To meet the

need for improving commerce efficiency, the Uniform Code Council,

Inc. (UCC) has announced that by the Sunrise Date of January 1, 2005;

all U.S. and Canadian companies must be capable of scanning and

processing EAN-8 and EAN-13 symbols, in addition to 12-digit UPC

symbols, at point-of-sale. GTIN compliant systems would allow

retailers to accept the complete family of EAN, UCC data carriers,

including all levels of packaging. GTIN compliance would also help

incorporate emerging technology such as RSS (Reduced Space Symbology)

that would bring 14-digit scanning capability to small items.

Additionally, to facilitate global data synchronization, retailers

and trading partners are encouraged to migrate to the 14-digit Global

Trade Item Number (GTIN) data structure for all product and services

codes. Albertson's has recognized the need to adopt GTIN standards

for its data. It would help Albertson's to engage in smooth

international trade across the world and lay the foundation to its

Global Data Synchronization (GDS) initiative.

Roles & Responsibilities:

Implementation of application changes as required, in accordance with

Albertson's SDLC policy.

Identifying the impacted elements in the system in phase wise as per

the requirements.

Unit testing the changes developed as per the requirement and

implementation in the production.

Post implementation support for some period of time after

implenetating the changes into production.

Worked with CICS, COBOL, VSAM, JCL, DB2 & File-Aid, ChangeMan &

Xpeditor etc.

Providing the resolutions for the queries raised by the business

users.

Integration & System testing for the changes developed as part of

multiple phases.

Involved in regression testing phase for the changes developed.

Participated in reviewing the developments by the other team members.

Implemented FTP jobs and Connect Direct jobs in transferring the

files to different platforms (Mainframe, Unix, LAN Server etc)

Project: IFEM (Internet Duration: June'2004 - Jul'2005

forecasting & event management)

Customer name: JCPenney, USA

Project Description:

JCPenney intends to replace its Mainframe based Demand and

Forecasting system with MANUGISTICS a new supply chain management

application with advance demand and forecasting and additional

features which are not available in the existing system. It is

required for JCPenney to Migrate data from existing legacy system to

the new Manugistics application to generate forecasts. The generated

forecast data needs to be supplied to the Legacy system which would

be used for their reorder of items. Data would be extracted from the

Mainframe system either from DB2 databases and flat files using ETL

tool. Transformation logic will be applied to the extracted data and

migrated to Manugistics application. The Manugistics application will

generate forecasts based on the input data received from the

Mainframe system. This forecast data would be migrated back to the

Mainframe system to be used for reorder of items.

Roles & Responsibilities:

Application enhancements in the System which involves various stages

of SDLC - requirements analysis, design, Coding, Unit testing,

Integration testing, support to Quality Assurance, implementation &

post-implementation support.

Participated in reviews & bug fixing activities.

Worked with CICS, IBM MVS, CA/Db2 tools & Utilities, SQL, DB2 UDB,

TSO, ISPF, QMF, SPUFI, TOAD, COBOL, VSAM, JCL, DB2, Sync sort, Db2

stored procedures, Control-M, Endevor, Star Tool, Insync & NDT2 etc.

Participate in Client/Team meetings send regular status updates to

the project manager.

Interaction with business users to get the business requirements.

Translated business and functional design needs into technical

requirements.

Prepare and used Load/unload/Repair Jobs of DB2 tables and explained

to team members.

Different FTP setups for mainframe, Windows, LAN and UNIX downstream

and upstream feeders.

Preparing High Level, Low-level Functional Specification documents.

Involved in Unit testing, system integration testing and user

acceptance testing.

Participated in test data and test case preparation and unit testing,

test results documentation, review and UAT support.

Effort estimations based upon the requirement analysis.

Review and rework on the review comments.

Project: Account Receivables & Duration: Jan'2004 - May'2004

Credit utilities

Customer name: Citi Bank, USA

Location: Pune, India (offshore)

Project Description:

Account Receivables:

This is a conversion project for the Account Receivables (Citi Cards)

of Citi Bank, U.S.A. It converts all the program modules related to

Account Receivables which already exist in PL/1 to COBOL.

Credit Utilities:

This is a development project for the Credit Utilities of Citi Bank,

U.S.A. It provides the functionality to

support the Core Business Card Application Processing needed to

support, Centrally Billed business accounts, specific Business Card

functionality and the various Business Card product types.

Roles & Responsibilities:

Application enhancements in the System which involves various stages

of SDLC - requirements analysis, design, Coding, Unit testing,

Integration testing, support to Quality Assurance, implementation &

post-implementation support.

Actively participated in the migration process, converting COBOL

programs into PL1.

Worked with PL1, COBOL, IBM MVS, Control-M, CA-7, QMF, SPUFI, ISPF,

TOAD, SQL, VSAM, JCL, DB2 & File-Aid, Endevor, Xpeditor etc.

Involved in Unit testing

Participated in reviews & bug fixing activities.

Participate in Client/Team meetings send regular status updates to

the project manager.

Interaction with business users to get the business requirements.

Translated business and functional design needs into technical

requirements.

Different FTP setups for mainframe, Windows, LAN and UNIX downstream

and upstream feeders.

Participated in test data and test case preparation and unit testing,

test results documentation, review and UAT support.

Effort estimations based upon the requirement analysis.

Review and rework on the review comments.

Project: 550 Retirement Project. Duration: Jun'2001 - Dec'2003

Customer name: Pershing, Florham Park, USA

Location: Chennai, India (offshore)

Project Description:

A conversion type of project involved in expanding the 550 bytes

trade file to 1200 byte trade file according to the business

requirement of Pershing, Florham Park (USA). The first phase of the

project involves analysis of the impact on the system and identifying

system applications, programs, procedures, JCL and other elements in

ENDEVOR that will be affected by converting the 550 files to the new

trading file. The second phase is the Design phase and the main

deliverables include System External Specifications (High level

Design) & System Internal specifications (Low level Design). The

third phase involves coding, Unit testing. After this, few fixes and

enhancements to this project as per the client specifications.

Roles & Responsibilities:

Interaction with business users to get the business requirements.

Work in the project at various stages of SDLC - requirements

analysis, design, Coding, Programming, Implementation, Unit testing,

Integration testing, support to Quality Assurance, User Acceptance

testing & post-implementation support.

Translated business and functional design needs into technical

requirements.

Identifying the impacted elements in the system in phase wise as per

the requirements.

Preparing High Level, Low-level Functional Specification documents.

Worked with CICS, COBOL, VSAM, JCL, DB2 & File-Aid, Java, HTML, Java

Script, SQL, IBM MVS, TSO, ISPF, QMF, SPUFI, TOAd, CA-7, Db2 tools &

Utilities, Endevor & Xpeditor etc.

Involved in Unit testing, system integration testing and user

acceptance testing.

Participated in test data and test case preparation and unit testing,

test results documentation, review and UAT support.

Effort estimations based upon the requirement analysis.

Post implementation support for some period of time after

implenetating the changes into production.

Conduct defect prevention meetings to minimize the common repetitive

errors in system development.

Review and rework on the review comments.

Involved in regression testing phase for the changes developed.

Contact this candidate