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.