Quality Control System

MARIO GARCIA

Msg. 936-***-****

Home 409-***-**** .

Cell 409-***-**** .

*************@*****.***

SUMMARY OF QUALIFICATIONS

Overall 29+ years of progressive experience with Information Technology

fulfilling varying roles such as a Systems Implementer, Senior Analyst,

Application Developer, Consultant, EDP Administrator, Systems analyst, and

Programmer. Has demonstrated expertise in project management, system

development, Application administration and management, analysis,

designing, programming, testing, implementation, maintenance and Data

Center management for IBM Mainframes and iSeries, AS/400 & Networking

environments. Works well as a team member and as well as independently and

can handle variety of projects at the same time.

Very strong professional background on variety of IBM platforms and

utilities, and architecting data integration solutions using the IBM

Information Platform technology stack, with extensive experience on IBM

Mainframes/ AS400, and several other brand Mainframes like CDC CYBER.

TOOLS/SKILLS

Languages

RPG IV, Free Format RPG, RPGILE, RPG ILE, RPG III, RPG/400, CL, JCL,

COBOL(CDC,MS,RM,DML,PRO,CICS,DB2), COBOL/400, FORTRAN, and JCL, .NET Web

applications using C#, SPEEDWARE, REACTOR, PROGRESS, FOX-PRO, VISUAL BASIC,

DBASE, ACCESS, GENTRAN.

Note: the experience with COBOL is 11 years and last time used was this

year 2007 under AS/400

UTILITIES

SQL, PL-SQL,QUERY, RLU, DFU, DBU, SDA, PDM, SEU, TRIGGERS, Stored

Procedures, Data Queues, XML, ODBC, DB2/400, Journal, VIEW,GENTRAN-EDI.

SOFTWARE & SYSTEMS

IBM OS(370), IBM OS/VS, CDC CYBER NOS/BE AND VE, DIGITAL, HP3000, IBM

iSeries, AS/400 / OS/400, SYSTEM 36, SUN UNIX, WINDOWS NT, WINDOWS XP,

DOS, HP WORKSTATIONS.

RDBMS

DB2-400, DB2, UDBC, DB2 Enterprise Server Edition,

Tools

EDI ASC II X12, XML, MPS-400, MS Project

Protocols

TCP/IP, FTP

EXPERIENCE (ONLY THE PREVIOUS 10 YEARS)

March 2010 - Current

MAPICS Developer

UST-GLOBAL

Client: DANA (Global auto-parts manufacturer Company)

Job responsibilities

. Provides technical expertise and guidance in the design,

programming, testing, documentation, implementation and

support of MAPICS XA applications.

. Provides Support to the User groups - Operations, helpdesk

and other development groups business/trading partners.

. Designs, codes, tests, documents, implements and maintains

RPG based applications. Provides support for production and

the operational versions of Autoparts Industry transaction

types.

. In-house needs and requirements, review design

considerations, compatible software.

. Provides customer support for package software (MAPICS) and

associated interfaces.

. Provides expertise and knowledge transfer, working with

application developers in EDI technologies. GENTRAN used in

the company.

. Provides technical input to assist in development of project

planning.

Environment

RPG 400, RPG ILE, RPG II, CL, SQL, EDI X12, AS400.

February 2010 - March 2010

Quality Control Enumerator

Census Jobs of USA

Client: Census Job (San Augustine, Texas)

Job responsibilities

. Census Job Quality Control.

Environment

San Augustine Texas Area cities.

January 2010 - February 2010

General Worker

Manpower

Client: Baseball Cube (Nacogdoches Texas)

Job responsibilities

. Plastic Machine operator.

Environment

Factory Machinery

September 2009 - October 2009

Inventory Reports Programmer

Sirius Solutions

Client: BAE (Sealy Texas)

Job responsibilities

. Provides Queries Reports from Inventory Data.

. Provides Support to the Inventory group about MAPICS.

Environment

AS 400, AS400 Query

April 2001 - December 2007

Project Lead / Consultant

mLogica, Inc

Client: Consolidated Terminals & Leasing Inc. (Ports Management Company)

Job responsibilities

. Provides technical expertise and guidance in the design,

programming, testing, documentation, implementation and

support of Terminal &Gate applications.

. Provides Support to the IT groups - database, Terminal

Operations, helpdesk and other development groups

business/trading partners.

. Designs, codes, tests, documents, implements and maintains

RPG applications. Provides support for production and the

operational versions of Shipping Industry transaction types.

. In-house needs and requirements, review design

considerations, compatible software.

. Performs mid-level system analysis and design functions, with

emphasis on Shipping/Container industry standards,

communication protocols and user interaction.

. Provides customer support for package software and associated

interfaces.

. Provides expertise and knowledge transfer, working with

application developers in EDI technologies. GENTRAN used in

the company.

. Provides technical input to assist in development of project

planning.

. Provides technical support related to Container Terminals

Operations including (Gate and Container Inventory

Operations, Bookings, Manifest, releases, Gate and yard

activities, vessel planning, Billing & Stevedoring, Demurrage

calculations, Hazardous information)

. Provide technical support related to Railroad Hub Container

Operations using COBOL 400 and .NET Web Pages

Environment

RPG 400, RPG ILE, RPG II, CL, SQL,COBOL, .NET, EDI X12, XML, AS400.

October 95 - March 01

Outsourcing IT Consultant

KERNEL CORPORATION (Software Consultants)

Clients: Several industries in Mexico and USA

Job responsibilities

. Development of a complete module associated to MAPICS,

(analysis, design, code, test, and implementation for

HUSSMANN AMERICAN IN MONTERREY, MEXICO

. Analyze and Design other small applications related to

MAPICS, Cost accounting, etc.

. Full support for IT related to engineering, purchasing,

warehouse and manufacturing operations of HUSSMANN AMERICAN.

. Conversion from RPG S-36 to RPG-400 for MANCO CO, SAN ANTONIO

TEXAS. Playing role as Business Analyst, Conversion Analyst,

Re-design and Testing for all systems in Company (MANCO CO),

Activities: Modular Analysis, Impact Analysis, Re-Design and

Coding, etc.

. Develop a Marketing Report System (Sales Analysis System),

using Procobol and Oracle, In a CDC CYBER 930 and a SUN, UNIX

machine. Coordinating two programmers for CIGARRERA LA

MODERNA, S.A DE C.V.

Environment

RPG-400, SQL-400, CL, JCL, COBOL-400.

Showing cobol expertize FROM MORE THAN 10 YEARS AGO

1990 Company: Procasa Mexicana, Monterrey Mexico

Team leader

Using COBOL, PC, DATA-GENERAL NOVA, RM-COBOL

Project Management and Development:

Design of Cost System and coordinating its development

Accounting System Maintenance

Production Registration System Maintenance.

Coordination of Payroll System operations and Development.

Benchmarking for acquiring a new computer for this company. It was chosen a

HP 3000 computer

1987 Company : La Perla Minning Co in Chihuahua Mexico

EDP Installation Responsible.

Working with IBM S-34, IBM OS, Using RPG, COBOL.

Leading following personnel: one programmer and a computer operator.

Systems developed: Annual Tax System.

Implementing new Payroll System.

Operation and Maintenance of following systems:

Accounting System, old Payroll, and Inventory system

1980 - 1986 Company : VITRO CRISA AND VITRO ENVASES MONTERREY MEXICO

ANALYST, COORDINATOR AND CONSULTANT FOR:

Human Resources, Payroll and Logisstics

Using COBOL MAINFRAME AND PCS

NOS-BE and NOS-VE FROM CDC

Leading groups of analyst-programmers and users,

Coordination and Systems Development

Activities:

Team Leader for development of Logistics System for Cufin,

Development of Control System for Inventory and Production Internal

Traffic,

Maintenance of Old Sales System,

Develop Personnel System for Cristaleria S.A,

Salaried Personnel Information System,

Sales Statistics system.

Consultant in Marketing and Statistics procedures using SPSS software

package

Implement Costs Module.

Consultant and Coordinator of Every Human Resources Systems for Vitrocrisa

Division of Vitro

CDC CYBER 810 PROGRAMMING, COBOL USING RDBMS.

Programming data base systems for Logistics

1979 - 1980 Internee : John-Deere and Dinamica Monterrey Mexico

Role: Maintenance Programmer

Projects: Lead Times and Maintenance

Using COBOL, FORTRAN, In a IBM 370 RJE Environment with IBM OS/VS

Changes in order to implementation of RIMS Inventory Control System,

Lead Times system,

Scrap and Reclaim Analysis System,

Quality Control and Productivity system called FATE

Experience Summary

Concept Version Years of Basic Intermedia Advanced

Experienc Level te Level

e Level

PROJECT MANAGEMENT 12 *

ANALYSIS AND DESIGN 16 *

INTERNET/INTRANET 2 *

DEVELOPMENT 21 *

COBOL 10 *

RPG AND AS/400 9 *

VISUAL BASIC 1 *

DBMS 1 *

FORTRAN 3 *

CLS 6 *

JCL AND CCL 10 *

ORACLE 1 *

WINDOWS 3.11 3 *

WINDOWS 95 5 *

WINDOWS 98 3 *

UNIX 1 *

MS-OFFICE 5 *

MS-OUTLOOK 98 2 *

MVS 12 *

VSE 3 *

.NET-C# 1 *

EDUCATION and Teaching experience

1976-1981 Bachelor of Administrative Computer Application Systems, from the

ITESM in Monterrey Mexico (ITESM is the TOP University/College level

education institution in Latin America.

1990-1991 Taken several courses from Master in Business Administration (MBA

not completed).

Teacher at high school level: Several subjects at a technical school while

studying professional career, including English, Cost Accounting, Math,

Programming, etc.

Teacher: Several years at University level at Universidad Regiomontana

(Monterrey, Mexico)

Subjects included: Statistics, Systems Analysis, Systems Modeling, Cost

Accounting, System General Theory, and Programming.

Contact this candidate