* *******

IT Professional with over **+ years as a DBA within DB UDB and Z/OS environment and MSSQL Server 2005/2008

environments. I have over 10+ years’ experience in the IBM ZOS mainframe environment full knowledge of application

environments in Cobol, CICS, VSAM, MQ and JCL. As an Information Technology professional with a strong

background in the IT industry, I learned that the best way to achieve success was to be in a motivated environment when

one has with well-defined objectives and empowerment. A belief based on integrity, quality, and service, along with a

positive attitude, an aptitude for strategic thought and planning, and the ability to adapt quickly to new ideas and situations

allows me to achieve consistent and significant successes in multiple projects.

SUMMARY:

• Over 10+ years of experience in the Design, Development, Testing, Implementation and Maintenance of

Mainframe applications.

• Expertise in mainframe environment with COBOL, JCL, VSAM, CICS, DB2, IMS DB/DC, SQL

SERVER, SAS, EZTRIEVE, JES2, TSO, ISPF, SDSF, MQ,WEB SERVICES, SQL STORED

PROCEDURES.

• Worked on databases DB2, IMS, SQL Server 2005 to 2008.

• Expertise in Database tools like EXPLAIN PLAN, LOAD, UNLOAD, IMAGE COPY, DESCRIBE etc.

• Expertise in BMC products like CATALOG MANAGER,,BMC SQL EXPLORER etc

• Expertise in Configuration Management tools like CHANGEMAN, CA Panvalet, ENDEVOR and sharepoint.

• Extensively worked on BMS Mapping, TSQ, TDQ and CICS programming to develop Online screens and CICS

application programs.

• Expertise in BMC, SPUFI, IBM DB2 editor, QMF, STARTOOL, MANVIEW monitors, FAD, COMPAREX,

DFSORT, ICETOOL, Fault Analyzer, File manager and FILE-AID for data manipulation and Data cleansing

• Experienced in working with Onsite-Offshore model and led a team of 13 members for multiple projects

• Excellent written and verbal communication skills with ability to interact with individuals at all levels

SKILL SET:

• Operating Systems: Z/OS, OS/390, MVS,Windows 8, Windows 7, Windows XP, Windows 2000, UNIX

• Languages: COBOL, RPG, JCL, VSAM, CICS, SQL, Assembler, DB2 procedural language and SQL Server

Procedure Language and SQL Server Report Writer.

• Mainframe Tools: TSO/ISPF, Change-Man, CA Panvalet, ENDEVOR, Startool, File-AID, File Manager,,, XPEDITOR, IBM Fault Analyzer, EZYTRIEVE, REXX, SAS, BMC, SPUFI, DCLGEN, STROBE, WEB

SERVICES, POWER BUIDER STORED PROCEDURES, COMPAREX, JEM, JCK, XREF, SDSF, MF

Utilities, QMF, DFSORT, ICETOOL, MANVIEW, DB2 utilities,,FTP, CONTROL-M,IDCAMS, SYNC SORT,

MQ Series, TIVOLI, NDM, NAS,JES2,, IBM Data Facility Storage Management System doing system level

utilities

• Scheduling Tools: CA-ESP, CA-Scheduler, Autosys, OPCT

• Database Utilities: DB2 Load/ Unload, BMC Load/ Unload, BTEQ, Fast load, Fast Export, mload, Toad for

Oracle

• Version Control Tools: CHANGEMAN,

• Databases: DB2 V9, SQL, IMS DB/DC Version 5, SQL Server 2005 and 2008.

• Other tools: Remedy 7.x, XML, HTML,DOC1, Dialogue, IBM MQ Series, Share Point, MS Office 2010, MS

Project Management.

2 Professional Experience

3 Basware Inc., Chicago Illinois

06/12 to 02/14

4 Project Manager

2012-2014

• As a Project Manager my responsibility was to manage Customer projects where our team of Basware IT

consultants (developers, interface specialists, network support) works to implement the P2P software solutions

for the Basware Customer. Basware Inc. is a leading software provider of Financial Management and Purchase

to pay applications.

• Key responsibility was to work with the customer to scope out their current business environment and document

a solution and project plan for a successful implementation of the Basware P2P applications to the customer. Key

success factor was to configure the Basware P2P software to interface to various customers ERP systems (SAP,

BAAN, JDEDWARDS, and Oracle).

ConAgra Foods, Naperville Illinois

5

07/97 to 04/12

6 Last title Senior Systems Analyst / Project Manager

2010- 2012

• Primary role to management and provide DBA support in the development of Warehouse applications for

ConAgra Plants in the SAP WM Warehouse Management system.

• Provide technical and DBA support to the infrastructure of the ConAgra Third party warehouses running the Red

Prairie system.

• Provide Support for the ConAgra legacy applications running in the IBM mainframe environments.

2008 – 20010

• Project Leader - Design, developed and delivered a Grower System for ConAgra to contract with Agricultural

clients to track the growing, harvesting, procurement and payment of their crops.

• Provide Support for the ConAgra legacy applications running in the IBM mainframe environments.

2002 – 20012

• Senior DBA for DB2 UDB & Z/OS, MSSQL Server AND IMS DB/DC systems and Project Leader: Lead

projects to support the migration of the legacy Mainframe based applications to SAP R3.

• From 2002 to 2004 Project Leader for Sales Orders Entry conversion.

• From 2004 to 2005 Project Leader for Procurement Systems conversion.

• From 2005 to 2007 Project Leader for warehousing systems conversion.

• From 2000 to 2012 Provide Support for the ConAgra legacy applications running in the IBM mainframe

environments.

2001-2002 Senior DBA for DB2 UDB, MSSQL AND IMS DB/DC systems & Project Lead

• Supported implementation of the Red Prairie Warehousing Systems at our corporate warehouses.

• Provide Support for the ConAgra legacy applications running in the IBM mainframe environments.

2000 - 2001

• Senior DBA & Project Lead for supporting the design, development and installation of the Warehouse system at

the ConAgra production plant in Quincy MI.

• Provide Support for the ConAgra legacy applications running in the IBM mainframe environments.

1997 - 2000

• Y2K project leader for conversion and validation of subsystems meet the y2k compliance. Subsystems included

order entry, procurement, accounts payable, account receivable, inventory control and warehouse management

systems.

• Provide Support for the ConAgra legacy applications running in the IBM mainframe environments.

LAST KEY PROJECTS

From 2012 to 2014 my responsibility was to ensure the delivery of Basware P2P applications to Basware customer

by leading a team of Basware consultants on Customer each project. My Project Manager responsibilities were to

ensure the customer purchased applications were completed on time, within budget and meets the customer

requirements.

From 2010 to 2012 Project lead to redesign the interfaces between SAP and Red Prairie that required the follow

skills:

o System Analyst skills to translate User requirements into functional and technical specifications for the

IT teams to execute.

o Project Management skills to ensure key milestones are met, resources are managed; communicate

progress and achievements to Management and stakeholders. Also ensure a valid test and implementation

plan was developed.

From 2008 to2010 Project lead to design, developed and delivered a new application for ConAgra. Request was to

contract with Agricultural clients to contract for the growing, harvesting, and payment of their crops. That required

the follow skills.

o Business Analyst skill to map the business processes and identify what current or new IT solutions will

satisfy the requirements. Then cost justified the solutions, identified the ROI and partner with the Business

where we selected the right solution.

o System Analyst skills to translate User requirements into functional and technical specifications for the

IT teams to execute (both onsite and offshore development resource).

o Project Management skills to ensure key milestones are met, resources are managed; communicate

progress and achievements to Management and stakeholders. Also ensure a valid test and implementation

plan was developed.

o DBA Skills to design a new database application. I worked with the development teams first to

designed the logical schema of the database objects and then with the DBA team to implement this into a

physical design.

Rockwell International/Goss Graphics System Westmont, IL

1991 – 1997 IMS DB/DC & DB2 and Oracle DBA

1987 – 1991 Senior Programmer Analyst

1984 – 1987 Applications Developer

ANTONIO BELTRAN SKILLS & EXPERIENCE LEVEL

Support Level: Knowledge of Application

thru IT Project support.

Applications :

Key IT Support Contact for application)

Knowledgeable IT User

SAP Order Entry

Key IT Support Contact

SAP Inventory Management

Key IT Support Contact

SAP Warehousing

Knowledgeable IT User

SAP Accounts Payables

Knowledgeable IT User

SAP Accounts Receivables

Knowledgeable IT User

SAP B2B EDI Integration

Key IT Support Contact

Red Prairie Warehouse Management

Key IT Support Contact

Red Prairie Work Force Management

Knowledgeable IT User

IBM BPICS ERP

Experience Level (Beginner = Rarely used

package/tool, Mid-Range = Used package

Vendor Packages/Tools:

tool about once a week or month, Heavy

User = User Package daily)

Mid-Range

HP Quality Center

Mid-Range

BMC Remedy Change Management

Mid-Range

BMC Control-M Workload Automation

Mid-Range

MS Office

Mid-Range

MS SharePoint

Heavy User

MS SQL Server Report Writer version 2005

Beginner

MS Crystal Reports

Mid-Range

BMC Control-M Job Scheduler

Mid-Range

CA-7 Job Scheduler

Heavy User

Compuware FILE-AID, FILE-AID DB2 & FILE-AID IMS

Heavy User

Compuware OMEGAMOM Online & Batch Debugger

Experience Level (Beginner =Wrote SQL

Queries for IT Projects,

Mid-Range = Wrote Stored Procedures,

Designed logical and Physical Designs for

DATABASE SYSTEM

IT Projects,

DBA = Supported Database as DBA at

one time)

DBA Level

MS SQL Server 2005

Mid-Range Level

Oracle version 8i

Mid-Range Level

MS Access 2010

DBA Level

IBM DB2 for UDB and ZOS

DBA Level

IMS DB/DC version 5

Languages & Reporting Tool:

10+ years Coding and Writing Technical

VB Dot Net

Specifications for development teams

20+ years Coding and Writing Technical

Cobol

Specifications for development teams

5+ years writing Technical Specifications

SP ABAP

for development teams

1 Education

Bachelor of Arts in Math and Computer Science, University of Illinois at Chicago .

References will be furnished upon request.

Contact this candidate