Developer Oracle

María José Camejo Alvarez

College Degree in Informatics

C.I.: V-10.866.946

AGE: 41 Nacionality: Venezuelan

Experience My experience the last years has been basically in Oracle Consultancy and additionally, counting on the accomplishment of the SAP academy in ABAP IV and the certification respective. I had experience for a year in that area.

Aug 2011 – Current Business Hunters Caracas

I work as Coordinator of Support, monitoring and speeding incidents of Oracle applications that meet analysts from other countries (Brazil, USA, India, Argentina) with whom I communicate daily in English (mostly written) or Spanish. Document Solutions important cases. Indirectly participate in user trainings. Elaborate daily logs. I advise analysts or users in certain cases. Elaborate queries daily orders and collections in PL / SQL. Prepare database environments for testing (Standardize data and condition Packages and Procedures).

Dec 2008 – Sep 2010 NSP Servicios de Tecnología. Caracas

• Modification and Elaboration of Packages, Procedures and functions on 9i DataBase with TOAD Tool.

• To export flat files to basic Tables of Data and Tables to Flat files to compare data.

• Modification of Window (Screen) of Order’s Detail and Tracking.(Oracle Forms 6i)

• Elaboration of Several Reports by Crystal Report 9.

• Development of the Multi Planta Project, that includes handling of several Operating Companies that will print tickets of Sodexo Company. To handle the user’s privileges to visualize data of the corresponding Operating Companies or of all these companies. The project includes the modification de 74 programs (Views, Procedures, Functions, Packages, forms, Reports) and 5 new programs (Forms, Reports, Procedures).

• Development of interface in ABAP IV for Intonation of the Process of Return of Invoices of Clients.

• Development of interface in ABAP IV for Creation of the Process of Return of Credits of Clients.

• Modification of some programs and elaboration of a program in ABAP IV that concatenates several UNIX files and them sends by mail. Tests of Development and Quality environment. to ask for transference to production environment.

July 2008 – Dec 2008. Ejecutivos de Ragot Caracas

Oracle Consultant (Assigned to client)

• Migration of 900 forms of Oracle Forms 6i to 10g

• Analysis of 12 forms and 2 Data models, with the respective indicative Matrice of the impact that implied in the forms the change asked for by the SENIAT. Finally 8 forms modified.

• Modification of 330 forms in Developer 6i, 137 Reports, 60 Pro C and some .SQL to add new field, new procedure and adaptations to all the queries that Users, Managements and Companies read, by change of 1 Company by User to Multicompany by User.

Oct 2007 – March 2008 Infogesa C.A. Caracas

Oracle Consultant (Assigned to client)

§ Modified packages in Oracle Data Base 10 g by use of the PL/SQL Developer tool for the Treasury and Finance areas.

§ Elaborated and modified programs in 9i Forms and Report 9i for the Treasury and Finance areas.

§ Modified programs in PRO C for the Treasury and Finance areas.

§ Developed reports in PL/SQL.

March 2006 – Oct 2007 Banesco Caracas

Systems Analyst

§ Modified Packages, Procedures and Functions in 9i Data Base by use of the Toad tool of the Messenger Program in XML using predesigned routines of XML to formulate request and answers that travel from Visual Banker, passing by the Parser, As 400, Integration Hub, consulting in the Rector (Insurance Systems in Oracle) and return to the main front end.

§ Elaborated Packages, Procedures and Functions in 9i Data Base by use of the TOAD tool of the Messenger Program in XML using predesigned routines of XML to formulate request and answers that travel from WEB tools to the rector (Insurance Systems in Oracle) and return to main front end.

§ Administered the tables in AS400, that conform the data types allowed in structures XML, because AS400 is the surroundings with which the Visual Banker tool located in the Banking Agencies communicates. Visual Banker is really the point of beginning of the passage of the data in the Banca Seguros project.

§ Carried out basic commands of 9i Data Base by way of the TOAD tool like CREATE OR REPLACE PACKAGE, CREATE OR REPLACE PROCEDURE, CREATE/TRUNCATE/DROP TABLE, GRANT (Execute, Select, Insert, Update, Delete), CREATE PUBLIC SYNONYM CREATE SEQUENCE, ALTER TABLE, etc.

§ Adapted the Programs done in PL/SQL of the Banca Seguros project and to generate understandable structures XML by the programs of the Extranet to produce what nowadays it is the access that has the clients of Banesco to solicit by the Extranet, the “Policy of Integral Life” through following Link: https://www.banescoseguros.com.ve/cotizadores.asp?o=COT1

Sept. 2005 – Feb. 2006 Grupo – SMS Caracas

System Consultant

§ Modified Packages, Procedures and Functions, inherent to the CARRIER System

§ Designed Windows in form 6i application and Modified Windows in 6i and 9i Forms application for the CARRIER System.

§ Modified and Designed Reports in Reports 6i and 9i for the CARRIER System.

§ Executed basic commands of 8i and 9i Data Base by use of the Toad and SQL Navigator tools.

March 2004 – Aug. 2005 Multinacional de Seguros Caracas

System Analist

§ Transferred hundreds of Forms and Reports from Developer 6i to Developer y Reportes de Developer 6i a Developer 9i.

§ Carried out and Modified PL’s in SQL Navigator.

§ Participated in redesigning the traditional Oracle Style Menu in the entire Insurance System to a tree style menu as handled in Explorer Windows with its due maintenance of administrative windows, user role and defining the Menu Options.

§ Designed Windows in the application form 6i for Collections from the Health Module.

§ Designed Module for Adjustment Consultation for the Automobile Module.

§ Transferred hundreds of forms of the Character Mode to 6i Forms for one of the Multinational Companies with due service to the user on how to work the insurance system in graphic form.

§ Transferred a great part of the data of another of the Multinational Companies, from AS400 to Oracle.

§ Carried out constant maintenance of Forms and Reports of the INSURANCE SYSTEM in any of its modules.

§ Developed different processes for data loading and flat (plain) files for Batch Accounting processes and different improvements for Manager Reports. (Management Reporting).

Jul 2003-Nov 2003 Solutions4biz/Seguros Popular St.Domingo RD

System Consultant

§ Elaborated different reports for the Collective Life Policy Module with regard to Premium Projections, emission of Policies, Rehabilitation of Policies, etc using the Reports 6.0 tool of Developer 2000 and Oracle 9i Data Base.

§ Elaborated a small Budget Module adhered to Executive Solution to Business Intelligence for the underwriter This is composed of 5 windows with their respective controls in auditing and security using the Oracle Forms 6i tool of the Developer 2000 and Oracle 9i Data Base in which I defined all the plain (flat) tables necessary for the system. Carried out the necessary transfer to Production.

§ Gave training to users of the Budget System.

2003–1999 Infogesa Caracas

System Consultant

§ Did maintenance to Phase I of the SISTEL Telephone System developed with the Oracle Forms 4.5 tool and Reports 2.0; in Oracle Data Base 7.3; with respective technical support to users.

§ Participated in the development, maintenance and technical support of Phase I of SISTEL and its transfer to Forms 6.0 and Reports 6.0. Together with the development and maintenance of PL/SQL programs that run in a programmed manner through Shells of Unix HP.

§ Together with Data Base personnel, transferred SISTEL to Oracle 9i with regard to BD. This required adaptation from the Shells of Unix HP to Sun 5.0.

§ Transferred window details of SISTEL so that they could be supported on windows Platform XP and company standards.

§ Started the development of Phase III of SISTEL with Forms 6.0.

July 1999 Ejecutivos de Ragot / Telcel Caracas

System Consultant

§ Migration of many windows of Oracle Forms Forms3 y Report1 in character mode to Forms 4 y Reports 2 in character mode.

1997–1999 SHL Systemhouse Caracas

System Administrator

§ I participated in the elaboration of the System “El Dorado”, module “Attention to the Client” for the Ministry of Energy and Mines on the Oracle 7,3 Data Base, with Developer 2000 and Designer 2000, under a contract with Intesa. A quite system, with diverse bows to applications GIS, tools of Work Flow and applications under Visual BASIC.

§ I gave support to the application developed by the company; SHL TRANSFORM (that is Base of

§ knowledge) to the clients; including definition of servant and basic creation of Data with SQL Server

§ I made backup & recovery of data in Windows NT 4.0.

1995–1997 C.A. Conduven Caracas

Senior System Analyst

§ I made the Module of Attention to the Client of the system of Credit and Invoicing; which was migrated of LINC15/DMS II under Unix, to Oracle 7,3 under NT 4,0 and tools Developer 2000 and Designer 2000.

§ I gave Support to Users in Machines Macintosh and PC.

§ I participated in the network management, under 3,51 Windows NT and Macintosh.

§ I dictated courses to users of the company, on applications Windows and Macintosh.

1992–1995 Aprycot / DB-KEY Caracas

Support Analyst

§ While I belonged to these 2 contractors, I worked in Corpoven S.A. (branch of pdvsa):

§ I gave to support to users in applications Windows and MsDos.

§ I did configurations and facilities concerning Software and changes of cards and memory concerning Hardware.

§ I administered networks under Novell 3,11 and 3.12.

§ I dictated courses to users about Windows applications.

1991–1992 Silog/Landec S.A. Caracas

Programmer

§ I developed the System of Accounting, under DBase IV.

§ I gave maintenance to systems developed in I turbo Pascal 5,0.

§ I gave support in Unix Santa Cruz Operation to clients.

1990–1991 Laboratorios Behrens Caracas

INCE Apprentice

§ I realised workings of Operator of platform VAX/VMS.

§ I analyzed, redesigned and reconstructed the System of Accounts To pay in Cobol.

§ I gave maintenance to Systems of Accounts To receive, List and Inventory in Cobol.

Formation Mayo 2008 SAP Caracas

§ ABAP IV Academy and obtain the certificate in June.

2007 Oracle Caracas

§ Course of intonation of PL/SQL 10g.

2005 Universidad Alejandro Humboldt Caracas

§ I studied the last years of Engineering of Systems, through equivalences Technical degree University Superior, but I did not culminate.

2000 Course of English with particular professor Caracas

§ I received 3 weekly classes of English, more than all conversational one, during 6 months, with a particular professor, in my office, before initiating the labor activities.

1999 Universidad Central de Venezuela Caracas

§ I studied until 2do. Level of the 4 levels of “English like foreign language”, in the school of modern Languages.

1996-1998 Universidad Yacambú Caracas

§ I studied 2 years of the Specialization in Management, Mention: Networks and Telecommunications, without culminating.

February 1997 C.A. CONDUVEN Caracas

§ Continuous improvement (16 hours)

November 1996 C.A. CONDUVEN Caracas

§ Developer 2000 Forms 4.5 (40 hours)

April 1995 Corpoven S.A. Caracas

§ Basic course of Administration of Solaris (24 hours)

October 1994 CYGNUS Caracas

§ Netware TCP/IP Transport (40 hours)

September 1994 CYGNUS Caracas

§ Netware Service & Support (40 hours)

December 1993 EPSON VENEZUELA S.A. Caracas

§ Networks I Introduction (20 hours)

§ Networks II Administration (20 hours)

June 1992 EDUPRAXIS Caracas

§ Introduction to Unix (12 hours)

§ Programming Shell Unix (40 hours)

§ Unix Tools (12 hours)

1987-1992 Colegio Universitario de Caracas Caracas

• College Degree in Informatics

1989-1990 Centro de Formación Comercial INCE Caracas

§ Basic course of Programming and Advanced

§ Programmer

Interests

To improve my economic condition and the continuous learning.

Fast learning. Excellence in the handling of relations with the

client. Dominion of PL/SQL

Languages High level of reading and writing of the English Language.

Intermediate Level English conversational.

High level of understanding in English Technician

Contact this candidate