Profileimage by Apolinar MejaOsorio Ingeniero en Sistemas COBOL CICS DB2 JCLs CONTROL-M Natural Adabas TSO QMF from

Apolinar Mejía Osorio

available

Last update: 06.09.2022

Ingeniero en Sistemas COBOL CICS DB2 JCLs CONTROL-M Natural Adabas TSO QMF

Graduation: Ingeniero en Sistemas
Hourly-/Daily rates: show
Languages: English (Limited professional)

Attachments

CV Ing. Apolinar Mejia Osorio.doc

Skills

Mi experiencia profesional en el área de Tecnologías de la Información ha sido en el entorno Mainframe durante 20 años, trabajando como programador, analista, líder de proyectos e ingeniero de sistemas. He trabajado para diferentes empresas como son: TENARIS TAMSA, Gas Natural, BBVA Bancomer, Daimler Chrysler, HSBC, Nissan Mexicana, Grupo Financiero Serfin, Seguros Inbursa y Grupo Nacional Provincial. En estas empresas he realizado análisis, desarrollos de sistemas y mantenimientos a aplicaciones. He participado en los desarrollos del proyecto como son: Cash Flow, Siniestros Autos, Arrendamiento, Factoraje y Reserva de Riesgos.
En la industria automotriz he estado en los proyectos: control de inventores, requisito de material, sistema de producción de automóviles y transferencias, documento de embarque, factura electrónica. En el área del Banco mi participación ha sido en los proyectos: Tarjeta a su medida, Tarjeta instantánea, SAR, Impuestos seguros, Extractos estadísticos, Gestión de crédito, Líneas de crédito, Cajeros ATM, Tarjeta de pagos fijos. 
He utilizado los siguientes lenguajes de Programación en mainframe: COBOL (7 años), CICS (5 años), TSO (10 años), JCLs (10 años), Natural (12 años), IDEAL (1 año), SQL (5 años). Tengo experiencia en bases de datos: DB2 (7 años), Adabas (12 años), Datacom (1 año) y Access (1 año). Además, tengo conocimientos en otros lenguajes y herramientas como: QMF (5 años), Control-M (2 años) Metodologías Scrum (2 años) y Agile (1 año), Jira (2 años), Remedy (1 año), Changeman (5 años), Endevor (2 años), Xpediter (2 años), File Manager ( 2 años), SQL ( 5 años), Java (1 año), Visual Basic(1 año), C (1 año), Project (1 año), File Aid (2 años). También conozco la plataforma Windows y la paquetería relacionada con esta plataforma: Excel, Word, PowerPoint, Visio, Project, Lotus Notes. Mi experiencia en mainframe es vasta, he trabajado en ambientes ONLINE (COBOL, CICS, DB2, Natural, Adabas) y en BATCH (COBOL, DB2, TSO, JCLs, Natural, Adabas).

Project history

01/2019 - 06/2020
Systems Engineer
BSD Enterprise S.A. de C.V. (Internet and Information Technology, 5000-10.000 employees)

Attention of productive incidents for customers TENARIS TAMSA (Manufacturing company of pipe and carbon steel profiles) and TUCA (Caribbean tubes). Analysis and solving of productive problems related to the manufacture of pipes and steel profiles. Time management for incident care, review of the functionality of the commands (objects) that present the incidents in their operation, modifications to the code of the objects involved in the productive problems, unit tests, integration tests, tests with him user, move from modified objects to the productive environment of TAMSA and / or TUCA.

                    Maintenance of TAMSA and TUCA interfaces, incident handling in batch mode with JCLs handling and in line with command handling (Application functions such as: PIP (Production Statistics), APT (Warehouse Finished Products), ISA (SAP Interfaces), AUT (Communication with Automation), CAP (Accounts payable), CCO (Credit and Collections).

                    Using Scrum and Agile Methodologies to perform analysis, design, maintenance, coding, unit and user testing, documentation in Jira and Remedy and object implementation of Scoring PyME Online and Prequalification SME applications in production.

                    Preparation of the requirements in Remedy to document the release of the different modified objects and be able to pass them to production. Monitoring, tracking, updating, and completing tasks in the Jira tool.


06/2016 - 01/2018
Systems Engineer
Informática Integral Empresarial S. A. de C. V. (Sinersys)

Customer: Nissan Mexicana S. A. de C. V.
Since: From June 2016 to January 2018.
Company: Informática Integral Empresarial S. A. de C. V. (Sinersys)
Position: Systems Engineer.
Activities: Conversion of the Control and Acquisition System and Equipment (SCAPE) to the
SAP/ABAP system. Generation of the EIPL file for shipment to SAP.
Generation of the EIPL and BOM files in the NEDM project for shipment to SAP.
Performing analysis and design, creation of DDMs (ADABAS database tables), project time
management, programming, unit testing, integration tests, system release in production,
follow-up to post-implementation.
Development of Natural/ADABAS to SAP/ABAP interfaces, query screens,
maintenance screens, weekly and monthly reports, high screens and changes.
Environment: Mainframe (IBM), using tools of software as: COBOL, Natural, Adabas, JCL and TSO,
Microsoft office, SDSF, DFSMS, ISMF and DFSort utilities.

05/2013 - 04/2016
System Engineer
INDRA Sistemas México S.A. de C.V.

Customer: Gas Natural S. A. de C. V.
Since: From May 2013 to April 2016.
Company: INDRA Sistemas México S.A. de C.V.
Position: System Engineer.
Activities: Participation in projects of Gas Natural. I am doing analysis, design and maintenance
of systems, modifying databases, programming, unit testing, user testing, Implantation,
production lunch, production support. I am sending information extractions databases
tickets requested by Business partner, users of Natural Gas. Participation in projects:
Unpaid, Precut payments, mass change situation recovered gauges, Reclassification of
commercial and industrial customers, Personal loan Inbursa, Update telephone Centers Gas,
Conforming fractionated, Transactions made and pending delinquency Mexico SIAT-SGC.
These developments use Natural, Adabas as programming tools: JCL as a tool for batch
processes and Microsoft Office for documentation used for these developments.
Bad debts, Precorte payments massive change situation recovered meters, Reclassification
of commercial and industrial customers , Personal loan Inbursa , Update phone centers Gas
, Conforming Fractionated , completed and pending transactions .
For each of these projects the following activities were carried out:
Analysis and design requirements Gas Natural Fenosa.
Generation of functional and technical specifications.
Diagramming processes each request.
Development of the requirements specified by Gas Natural Fenosa
Unit testing, comprehensive testing and regression testing.
Release to production.
Support Post Implementation. Creating User manuals and Help Desk.
Tickets or productive incidents:
Review and analysis of each production incidence specified on the ticket.
Modification or creation of the process to resolve the issue.
Generation of technical and functional documentation of the process to resolve the issue.
Request a production support to execute the corresponding process of solving the problem.
Send information to the user of Gas Natural Fenosa for the process of solving the
incidence for approval.
Close of ticket or issue resolved in F1, with the approval of the user.
Using tools of software as: COBOL, DB2, Natural, Adabas, Control-M, JCL and
TSO.
Environment: Mainframe (IBM), using tools of software as: COBOL, DB2, Natural, Adabas, Control-M,
JCL and TSO.

05/2011 - 04/2013
Analyst - programmer
Informática Integral Empresarial S. A. de C. V. (Sinersys); Alta Calidad en Servicios de información S. C. de P. S. de R. L. de C. V. (Hildebrando)

Customer: Nissan Mexicana S. A. de C. V.
Since: From May 2011 to April 2013.
Company: Informática Integral Empresarial S. A. de C. V. (Sinersys)
Position: Analyst - programmer.
Activities: Participation in the projects of Click and Secondary Ubications, realizing
analysis, design and maintenance to the programs. In all these changes the tools that
were in use were: as language of COBOL and NATURAL programming, the database was ADABAS,
besides the fact that the JCLs and the TSO were in use as tools for executing the
processes BATCH and Line. Administering the project and taking the control of times,
checking in agreement to the plans of work that the dates and established goals were
taking to themselves I finish.
Allocation of material to primary locations, Secondary Locations, Locations auxiliary.
The following activities were carried out:
Analysis and design requirements Primary project locations.
Analysis and design requirements Secondary project locations and auxiliary locations.
Creation of databases for the project Locations Primary
Creation of databases for the project Locations Secondary and auxiliary.
Development of programming for projects: Locations Primary and Locations Secondary
Generation screens consultations, screens maintenance locations, brilliant displays of
locations, weekly reports, monthly reports annual reports, interfaces card printing
inspection, empty fronts cards, card fronts with material.
Unit testing, user testing, comprehensive testing and regression testing of projects:
Locations Primary and secondary locations.
Generation of documentation for release to production projects: Locations primary and
secondary locations.
Liberation production projects Locations primary and secondary.
Support Post Implementation. Creating or user manual.
Support production (production Incidences)
Contact the user to request evidence of the occurrence.
Analysis of the incidence productive with the information provided by the customer.
Review the process for solving the productive impact.
Modification of the process that generated the productive impact.
Generation of documentation to request via ticket upgrade the production process.
Generating evidence or run the production process for validation with the user.
Closing the incidence or with the approval of the user.
Environment: Mainframe (IBM), using tools of software as: COBOL, Natural, Adabas, JCL and TSO

Customer: HSBC S. A. de C. V.
Since: From December 2009 to April 2011.
Company: Alta Calidad en Servicios de información S. C. de P. S. de R. L. de C. V. (Hildebrando)
Position: Systems Engineer.
Activities: Analysis, design, maintenance, codification and implantation of programs in the TRIAD
system, applications of card to your measure, risk, OH collections, in the area of
credits and payment Authorizer of Cards. Elaboration of technical documentation for the
liberation of these systems, unitary tests, you try volume, tests with the user,
Implantation.
Projects:
TRIAD and OH Colections System (risk analysis of loans, credit cards, mortgages, personal
loans, status review, review dates of payments, late payments, status delay payments,
customers in arrears, maintenance and creation of new programs Collection for the
system).
The following took place:
Training for learning or TRIAD system taken by videoconference.
TRIAD System Installation Collection in the area.
TRIAD use and management system for credit risk analysis (credit cards, personal loans,
mortgage loans).
Report generation system Collection.
Creating new collection system programs.
Diagramming the status indicators credits.
Creating Batch processes or to generate weekly and monthly reports.
Unit testing, comprehensive testing and regression testing of TRIAD System.
Liberation or TRIAD production system.
Support Post release
Collection module (Credit Card, Debit Card)
Activities:
Analysis of requirements Collection System for credit card and debit card.
Development of system requirements Collection for credit card and debit card.
Unit testing, testing environments UAT, OAT (QA environment and pre-production
environment).
Release to production. Support Post release.
Environment: Mainframe (IBM), using tools of software as: COBOL, CICS, DB2, JCL, TSO, Altair,
Change man, VSAM, Endevor.

08/2007 - 11/2009
Systems Engineer
Alta Calidad en Servicios de información S. C. de P. S. de R. L. de C. V. (Hildebrando)

Customer: BBVA-Bancomer S. A. de C. V.
Since: From August 2007 to November 2009.
Company: Alta Calidad en Servicios de información S. C. de P. S. de R. L. de C. V. (Hildebrando)
Position: Systems Engineer.
Activities: Analysis, design, maintenance, codification and implantation of programs in the
applications of card to your measure, exponential points, instantaneous card, in the area
of means of payment Authorizer of Cards. Elaboration of technical documentation for the
liberation of these collectors, unitary tests, you try volume, tests with the user,
Implantation.
Area Payment Systems - Collector (Bcom, Mobile Banking , Bancomer and ATMs Line)
The following activities were carried out:
Analysis and development of specifications for new requirements in the area of means of
payment.
Analysis and modifications to the components of Collector module to implement new
requirements for the area of means of payment.
Development of the new requirements for the area of means of payment, Collector module
Creating Batch processes or for generating area weekly and monthly payment media reports.
Unit testing, comprehensive testing and regression testing of the new requirements
Collector module.
Release to production of new developments or modifications Collector module components.
Support Post releasing new products in the area of media Payments
Environment: Mainframe (IBM), using tools of software as: COBOL, CICS, DB2, JCL, TSO, Altair,
Change man.

04/2006 - 07/2007
Programmer Analyst
Tecnología en Sistemas de Computo S. A. de C. V. (TSC)

Activities: Analysis and programming in the system of Invoicing for the accomplishment of documents
of Shipments. Implementing several functions as discharge of documents of shipments, by
means of apprehension of the information, by means of orders of exits of shipments with
the corresponding information. Printing of documents of shipments, cancellation,
invoicing of these shipments. Automatic issue of documents of shipments of returns of
Equipment emptied racks and containers.
Area Billing - Shipments Material (Import and Export)
the following took place:
Analysis and Billing system development Shipments material import and export.
Development of shipping documents (Altas, outputs orders, printing documents)
Automatic issuance of shipments of vacuum equipment returns, racks and containers.
Unit Testing and comprehensive testing system Material Shipments.
Liberation production system Material Shipments.
Post release or Support system Material Shipments.
Environment: Mainframe (IBM), using tools of software as: COBOL, CICS, DB2, Files VSAM, JCL, TSO,
Xpediter.

09/2005 - 03/2006
Programmer Analyst
Azatec

Customer: Kimberly Clark de México S. A. de C. V.
Since: From September 2005 to March 2006.
Company: Azatec.
Position: Programmer Analyst.
Activities: Analysis and programming in the system of Electronic Invoicing. Doing the interface for
the Electronic Invoicing taking the Invoicing as a base in line. Implantation the
electronic Invoicing in line.
Environment: Mainframe (IBM), using tools of software as: COBOL, CICS, Files VSAM, JCL, TSO.

04/2000 - 08/2005
Analyst - programmer
Integral Managerial Computer science S. A. de C. V.

Customer: Nissan Mexicana S. A. de C. V.
Since: From April 2000 to August 2005.
Company: Integral Managerial Computer science S. A. de C. V.
Position: Analyst - programmer.
Activities: Participation in the projects of Inventor control, Stock Status; realizing analysis,
design and maintenance to the programs for the union Renault - Nissan. The analysis that
was done was to see that so much the changes were affecting him to these systems and to
do an estimation of hours / man, hereby to cover the modifications as promptly as
possible and that in addition the price of these changes was economic and viable for the
client Nissan Mexicana. The design that was done was on some databases in order that they
could support the changes and one was affecting in the most minimal thing the already
existing thing. In all these changes the tools that were in use were: as language of
NATURAL programming, the database was ADABAS, besides the fact that the JCLs and the TSO
were in use as tools for executing the processes BATCH. Administering the project and
taking the control of times, checking in agreement to the plans of work that the dates
and established goals were taking to themselves I finish.
Environment: Mainframe (IBM), using tools of software as: Natural, Adabas, JCL and TSO.

03/1998 - 03/2000
Project leader
Grupo Financiero SERFIN S. A. de C. V.

Company: B. C. C. Professional services S. A. de C. V.
Position: Project leader.
Activities: Participation in the Project of Conversion of the year 2000. Realizing the implantation
of systems, modified by the mistake of four digits in the year, the information that it
was containing dates, proved them with counterfoils of information, testing with the
involved users. Sure Statistical Extracts in which COBOL was in use, DB2 and CICS. The
systems that were modified as ELECTRA and SAR in which the NATURAL language was in use,
ADABAS, JCL and TSO, other systems as Customs Taxes, administration of the personnel, I
finished the project to modifying, planning activities and times, resting on the software
of project administration PROJECT. The control of reports of activities of the assigned
personnel and simultaneously the reports of the activities concluded to the Bank manager
of the system area.
Environment: Mainframe (IBM), using for the accomplishment the following software: Natural, JCL,
TSO, COBOL, DB2 and CICS.

Local Availability

Only available in these countries: Mexico

Other

Tengo experiencia en los siguientes lenguajes de Programación y herramientas en la plataforma mainframe:
COBOL (7 años)
CICS (5 años)  
TSO (10 años)
JCLs (10 años)
DB2 (7 años)
SQL (5 años)
QMF(5 años)
Natural (12 años)
Adabas (12 años)
File Aid (2 años)
Xpediter (2 años)
Changeman (5 años)
Endevor (2 años)
File Manager (2 años)
Control-M (2 años)
Altamira (3 años)
Tengo conocimientos en metodologías como:
Scrum y Agile,
Otras herramientas:
Jira, Remedy, Project, Java, Visual Basic, plataforma Windows y Microsoft Office: Excel, Word, PowerPoint, Visio, Project, Lotus Notes.
Profileimage by Apolinar MejaOsorio Ingeniero en Sistemas COBOL CICS DB2 JCLs CONTROL-M Natural Adabas TSO QMF from Ingeniero en Sistemas COBOL CICS DB2 JCLs CONTROL-M Natural Adabas TSO QMF
Register