RICARDO JOSE MEJIAS RUIZ

Phone: (787-***-**-** Mobil

Address: *** ****** ** ******** ******** PR 00966-8707

E-Mail: acp8qm@r.postjobfree.com

PROFESSIONAL SUMMARY

Professional with 28 years experience in computing, the first 12 years as an employee most of the time and financial companies in the following 11 years as a consultant in different companies and financial services. Specialist expert developing coordination and direction systems in Mainframe environment, and experience in projects in client-server environment. Extensive experience in all phases of systems development, since the lifting of information, development, design, debugging, testing, deployment and documentation of information systems. Excellent interpersonal relations, to coordinate teamwork and customer service. Experience in planning, leadership and resource management projects.

Founder of a company that provided consulting services for Banco Mercantil and Cantv, for four years, managing a roster of 10 computing resources. Attitude responsible and committed to serious work.

TECHNICAL SKILLS

Development tools: Microsoft Visual Studio 6.0, Visual Studio.NET

Languages: Cobol, Cobol II, Natural, Basic, Fortran, Pascal, Dbase III, Dbase IV, Clipper, Visual Basic 6.0, SQL, PL/SQL,

Frameworks: Microsoft .NET 2.0 and 1.1

Databases: MS SQL Server 2003 Microsoft Access, Vsam y Total. Base de Datos DB2, Adabas, IDMS, Oracle

Operating Systems: Microsoft Windows (NT 4.0, 2000, XP, 2003, Vista) and DOS, Rsts/e, Vrx, Aos/Vs, Aos/Vs II, MVS/ESA, Os/390, Z/Os, Unix

Software: Crystal Reports, Cofs y Cofs-Tp, Sgu, Endevor, Jcl, Qmf, Xml, Entire Connection, Entire X, Direct Calls, N2O

Tools: Sniffer Pro, Microsoft Office, Microsoft Project, Visio Professional

Equipment: NCR Criterium, Data General Mv-10000 y Mv-40000, IBM 3090, Digital PDP 11/34.

Editors: Olpd, Topies, Sed, Roscoe, Tso, Development.

SUMMARY OF KNOWLEDGE (more significant)

View details of functions are reviewing the activities described in each company in this resume.

Adabas/Natural:

1) Departamento de Hacienda, San Juan, PR (4 Year 6 Months)

2) Sistemas Financieros APH (Customer: Bbva), Caracas, VE (10 Months)

3) Incapro (Customer: Cantv), Caracas, VE (9 Months)

4) Conalca Sistemas A1 (Customer Banco Mercantil), Caracas, VE (3 Year 3 Months)

5) Sistemas Multiplexor (Customer: Cantv), Caracas, VE (9 Months)

6) Banco Mercantil, Caracas, VE (5 Year)

Cobol y Jcl:

1) Sistemas Financieros APH (Customer: Bbva), Caracas, VE (10 Months)

2) Sistemas Multiplexor (Customer: Cantv), Caracas, VE (9 Months)

3) Banco Mercantil, Caracas, VE (5 Year)

4) Cavendes, Caracas, VE (4 Year 4 Months)

5) Bancarios Entidad de Ahorro y Prestamo, Caracas, VE (9 Months)

6) Oficina Central de Estadistica e Informatica, Caracas, VE (1 Year 7 Months)

PLl/SQL y SQL:

1) Hide Systems Inc, San Juan, PR (5 Year 10 Months)

2) Departamento de Hacienda, San Juan, PR (4 Year 6 Months)

3) Incapro (Customer: Cantv), Caracas, VE (9 Months)

4) Conalca Sistemas A1 (Customer Banco Mercantil), Caracas, VE (3 Year 3 Months)

5) Sistemas Multiplexor (Customer: Cantv), Caracas, VE (9 Months)

6) Banco Mercantil, Caracas, VE (5 Year)

WORK EXPERIENCE

Hide Systems Inc, San Juan, PR Ago. 2008 – Present

Senior Consulting Analyst.

Perform analysis functions and process development applications in the area of insurance both in emission and finance. Presentation of progress biweekly progress according to strategic and business plans related to the accounting area.

Responsible for the implementation of AutoGuard bouquet.

Development of generic processes cancellation policies for the automobile industry.

Development of generic renewal process for car industry auto policies.

Development of control points in the process of policy renewals.

In charge of the process of payment of commissions to producers.

Responsible for the daily closing cash.

Project coordinator for print outsourcing.

Responsible for withholding generation.

Responsible for coordinating, planning work of a group of 3.

Responsible for the generation of commission payments to agents and / or producers.

Responsible for the stabilization of the settlement processes of commissions.

Support audit unit

Environment: TRONADOR, TRONWEB, PL/SQL, UNIX, ORACLE 10g, CRYSTAL REPORT, CITRIX, Windows, Developen, packages, triggers procedure, VI Editor, debug, Remedy.

Departamento de Hacienda, San Juan, PR Jan. 2004 – Jun. 2008

Senior Consulting Analyst.

Development System means for public entertainment.

Maintenance System for the recovery of taxes vehicle and goods.

Developing Systems Manual and User System for the discretion of public entertainment.

Development Control Systems Documentation.

Development of Recovery Management Module for Increasing bill of lading unauthorized.

Responsible for the coordination, direction, Analysis and Design Systems Control Documentation, fees for public entertainment, and Recovery management.

Development of the interface for transmitting files Sponsors of taxes withheld (W2).

Analysis, Design, Development Notification system of fines on porters.

Environment:Z/OS, DB2, ABADAS, NATURAL, JCL, TSO, QMF, SQL.

Sistemas Financieros APH (Customer: Bbva), Caracas, VE Feb. 2003 – Dec. 2003

Systems Analyst

Maintenance System for the Altamira, Altair.

Conversion System Trust.

Environment: Z/OS, ADABAS, NATURAL, COBOL, JCL, TSO

Incapro (Customer: Cantv), Caracas, VE Apr. 2002 – Jan. 2003

Systems Analyst

Manual Claims System Development - SARE (Access 2000).

Manual billing System Development - FAMA (Access 2000).

Automatization, Melita & NAP Collections Management Statistics.

Automatization, Statistics on Payment Agreements.

Automatization, Statistics on withdrawals by reason of Payments.

Automatization, Campaign 40 DPD.

Development of collections related measurement indicators.

Automatization statistics collection.

Developing indicators for the cancellation of Managers Collection.

Environment:Access 2000, SQL, Visual Basic, Z/OS, ADABAS, NATURAL, JCL, TSO.

Conalca Sistemas A1 (Customer Banco Mercantil), Caracas, VE Nov. 1998 – Apr. 2002

Project Manager

Training in Natural Adabas to new personnel.

PayToll control.

Summary Income Tax payments (Venezuelan I.S.LR.).

Marketing.

Resource Selection.

Project Coordination and Direction.

Building the SICRI System (Banco Mercantil).

Design and Development of the system called "Lista Especial” [Special list] (Banco Mercantil).

Analysis, Design and Development of a System for Securities Control (Banco Mercantil).

Development of the system called “Transfer Agent” (Banco Mercantil).

Generation of conversion files for the Service Providers File (SAP for Banco Mercantil).

Conversion of MosaicPersonal Files.

Preparation of tenders.

Preparation of technical and economic proposals.

Lifting of information.

Customers Services.

Elaboration of Documentation.

Environment: Z/OS, DB2, ADABAS, NATURAL, JCL, TSO, ROSCOE, QMF, SQL, ENTIRE CONNECTION, ENTIRE X, DIRECT CALLS.

Sistemas Multiplexor (Customer: Cantv), Caracas, VE Dec. 1997 – Nov. 1998

Systems Consultant Senior

Maintenance of the ON LINE BANK application.

Development of programs for the SISCOM2K System (Commercial Systems Y2K).

Adaptation of the applications for Y2Y.

Environment: IBM 3090, ADABAS, NATURAL, COBOL, JCL, TSO, QMF, SQL, OS/390.

Banco Mercantil, Caracas, VE Dec. 1992 – Dec. 1997

Systems Coordinator

Development of Processes for Credit Cards Prornotional Activities:

- Usage incentive,

- USA 94 Word Cup,

- Master Card : The Worid is in your Hands.

Supervisor of the profitability model of a Credit Card (Multisoft Contract)

Supervisor of the SAIT System development (System Integral Customer Service System, Megasoft Contract)

Supervisor Warning Bulletin balancing (Megasoft Contract)

Development of the, Deferred Interest System (maturity of interests since 1993 to date)

Analysis, Design and Development of Bar Code for Credit Card Statements of Account.

Maintenance of the chains of credit card billings.

Maintenance of die Billing Programs for Credit Cards.

Modifications for die correct treatment of bounce checks and adjustments to minimum payment calculations .

Optimization of the conversion of prospect customers for Associated Entities of die Bank.

Responsible for the fee calculation as issuer and payer of the Associated Entities of the Bank.

Laser 4050 and 4090 Printers Programming, for the generation of the credit card statements of account.

Generation of marketing letters for credit card customers.

Blocking and de- blocking of credit card for surpassing the maximum amount allowed for charges in US$ (exchange control)

Stock holders System Maintenance.

Development of a support module for the public sale of CANTV stocks (Clipper)

Development of a control module for Securities under custody in the vault area.

Automatization of International Transfers

Environment: Z/OS, DB2, ADABAS, NATURAL, COBOL, JCL, TSO, ROSCOE, QMF, SQL, Archivos VSAM y TOTAL.

Cavendes, Caracas, VE Apr. 1988 – Oct. 1992

Systems Analyst

Development of the liquid Assets Fund.

Analysis and development of the "Cheque Ahorro” product system.

Development of Payroll Systems programs.

Development of Activity Programs for the Fund Stock holders.

Participation in the liquid Assets Fund System conversion.

In charge of the development of the process for checkbook requests and deliveries to Banco Provincial and to customers.

Responsible for daily clearance and closing.

Responsible for the System of Normal and Special Partícipations.

In charge of redesigning the data base for the Partícipations and Cheque Ahorro Systems.

Leader of the DOCHN Project (Financial Documents) for remittance of funds, in the following activities:

Information surveying, conceptual design of the system, technical and commercial profile, detailed design, activity planning, implementation and development strategies definition, user training, documentation of procedures for batch processing.

Planning and control of the activities of a group of programmers.

Consultancy for the development of modules and programs for various systems.

Appointed to direct optimization study of the Financial Participations System.

Coordinator of the Participations System conversion, including: reorientation of the mechanism for distributed capture, placement standardization, Data Base redesign, changes in the closing module oriented to daily due dates, issuance of management information for decision making, analysis of interfaces with Treasury, Accounting, liquid Assets Fund and Credit Portafolio.

Environment: Mv-10000, Mv-40000, Aos/Vs, Aos/Vs II, SED, COBOL, IDMS, TPMS, SGU.

Britanica de Seguros, Caracas, VE Dec. 1987 – Mar. 1988

Systems Programmer

Finishing the System for Control of Records of Pure Breed Animals. Among the modules: Weight Control, Vaccination Control and Artificial Insemination Control. (For “Inversiones Agropecuaria Guanarito”).

Trust control and registration.

Development of programs for tax control (I.S.LR. and ARC forms).

Development of programs for savings fund.

Creation de Sheets and Macros in Lotus 123, for profit analysis of policies financing.

In charge of the administration of a network of 12 microcomputers.

Environment: Windows, Dbase, Clipper

Bancarios Entidad de Ahorro y Prestamo, Caracas, VE Dec. 1986 – Sep. 1987

Systems Programmer

Maintenance and development of programs for the online transactions manager (TRAMPRO).

Participation in the Financial System conversion (COFS a COFSTP),

Creation of programs for the conversion of agencies, account modification and issuance of balances.

Development of programs for the Mortgage Loan System.

Desarrollo de Programas del sistema de Prestamos Hipotecarios.

Maintenance of the Payroll system

Maintenance of the Account Receivables System.

Environment: NCR Criterium, Vrx, Olpd, Topies, COBOLl, Trampro, Cofs, Cofs-Tp, JCL.

Oficina Central de Estadistica e Informatica, Caracas, VE May. 1985 – Dec. 1986

Systems Programmer

Tutorship for three months.

Maintenance of programs with daily, monthly, serniannual execution and issuance of yearly statistical books.

Assistance in adaptation of the External Commerce System.

Maintenance of the systems for National Industry, Social Statistics, Agricultural and Internal Commerce Census.

Analysis and programming of the system of Birth Year Books.

In charge of training and assistance to trainees.

Creation of JCL

Environment: NCR Criterium, Vrx, Olpd, Topies, COBOL, JCL.

EDUCATION

Associate Degree in Informatics

Institute Univesitario of Industrial Technology 'Rodolfo Loero Arismendi '(I.U.T.I.R.L.A.) 1988

Bachelor Degree in informatics

University "Simón Rodriguez" Licentiate in Managernent, major in Informatics 1992

SEMINARS / CONFERENCES / TRAININGS / CERTIFICATIONS

Fundamental Aspects of Savings and Loans,

Telecommunication Principles,

Systems Structured Analysis,

Data Base Design,

Systems Structured Design,

Adabas: concepts and functionalities,

Introduction to Natural 2.2. Programming,

Natural 2.2. Intermediate Level Programming,

Systems Structured Analysis,

Basic Skills for Supervision,

Compendium: Attendance to introductory information shop,

Commercial Excellence in FacetoFace Sales,

Natural,

Cams Technical Support,

Umbrella Programmers Class,

Discovering at Microsoft Visual Basic 4.0,

Client/Server,

Commercial Management System Version 2.2 phase I,

Systems of franchises,

HTML Introduction,

XML Introduction,

Entire X Communicator Introduction,

Building Distributed Applications with Entire X Communicator-Entire Screen Builder Overview,

Visual Basic,

Ingles Conversational (Basic),

Ingles Grammatical,

PL/SQL.

OTHER ACTIVITIES

Course Instructor, Diagramming and Logics (Apr-93 E.I.C.).

Course Instructor, Cobol Programming Language (May-93 E.I.C.).

Course Instructor, Basic Programming Language (Agu-93 E.I.C.).

Course Instructor, Dbase III (Jul-93 E.I.C.).

Years Technical:

ADABAS-NATURAL

Expert

+4 / 13 years

Analyst & Design Systems

Expert

Currently used / 19 years

Cobol

Expert

+4 years ago / 17 years

DB2

Intermediate

+4 / 12 years

JCL

Intermediate

+4 / 18 years

Roscoe

Intermediate

+4 years ago / 11 years

SQL

Intermediate

+4 years ago / 6 years

TSO

Intermediate

+4 / 17 years

Visual Basic

Beginner

1 year ago / 1 years

Vsam

Expert

+4 years ago / 17 years

IDMS Intermediate +4 years ago / 6 years

Pl/sql Intermediate +5 Years

Summary Technical Knowledge:

Languages Cobol, Cobol II, Natural, Basic, Fortran, Pascal, Dbase III, Dbase IV, Clipper, Visual Basic, SQL, PL/SQL,

File Vsam y Total. Base de Datos DB2, Adabas, IDMS,

Other Olpd, Topies, Sed, Roscoe, Tso,

Packages Access 2000, SQL Server, Excel, Word, Power Point 2007,

Operating System Rsts/e, Vrx, Aos/Vs, Aos/Vs II, MVS/ESA, Os/390, Z/Os, Windows 2000, Windows XP,

Handler Transactions Trampro, Tpms,

Packages Financials Cofs y Cofs-Tp,

Products: Sgu, Endevor, Jcl, Qmf, Xml, Entire Connection, Entire X, Direct Calls

Teams NCR Criterium, Data General Mv-10000 y Mv-40000, IBM 3090, Digital PDP 11/34.

Availability Negotiable.

Phone (787-***-**-** Cel.

E-Mail acp8qm@r.postjobfree.com

Contact this candidate