Blanca Otalora

(Local to North Miami Beach, FL and available for phone/ in-person

interview)

Summary:

. Extensive experience with AS/400 system and in all areas of data

processing including every aspect of design, programming, implemented,

operations and system maintenance.

. Good working experience on CLP, RPGIII, RPGIV, RPG400, RPGILE, RPG

Free, SEU, SDA, PDM, RLU, DBU etc.

. Worked in the implementation of DataWarehouse with the Microstrategy

software.

Skills:

. Job of Control: OCL Procedures and CL Programming (CLP). AS/400, iSeries,

RPG III, RPG IV, RPG ILE, RPG Free, Structured, Modular Design. Arrays,

Data Areas, Data Structures, Relational Database Design and

Normalization, DB2/400: DDS-Physical Files, Logical Files, Join Files,

Data Dictionaries. Screen Design Aid (SDA): Menus, Display Files, Sub-

file programming. File Transfer Protocol (FTP), Query/400 and Open Query

File (OPNQRYF), SQL Embedded, MICROSTRATEGY Software, System

Administration: PTFs, System Values, Basic Configuration, Security

Administration: User Profiles, Authorization Lists, Object Authority,

Operations-Backup & Restore, Print Management, Job Scheduler, Microsoft

Office 2007 (Excel, Word, Access, PowerPoint)

Education:

. Bachelors in System Engineer, Universidad Distrital Fco. Jose de

Caldas, Bogota, Colombia, Jul 87

. Bachelors in Physics and Mathematics, Universidad Pedagogica Nacional,

Bogota, Colombia, Aug 84

Experience:

Insignia Auto Parts/ Opustone, Miami, FL

Sep 08 - Present

Programmer AS/400

. Worked in systems development and programming in the iSeries, embedded

SQL, and RPG400, RPGILE.

. Currently working in the update of the new version 5.0 System 2000

with the developments make in our company according with their own

policies used and that makes it different from others.

. Development of a system that is used for managing delivery routes for

the distribution of the products from the auto-parts warehouse to the

customers.

. Adapt the system 2000 the VAI (Vormittag Associated Inc.) to use the

Pallets how a new measure of storage in the warehouse of OPUSTONE

(Distribution company Tile) at the same owner.

. Change the inventory module allows to inventory periodically the

products by area selected (bins) without having to wait until year-end

inventory. Several programs were modified for this purpose.

Credibanco Visa, Bogota, Colombia

Jul 98 - Dec 06

Coordinator in Exchange and Compensation

. Design, developments and implementation of new project in RPGIII,

RPGIV, RPGILE.

. Documentation and standardization of the new development.

. Implementation and assembly of the data storage System (Data

Warehouses).

. Advising in the design of the multidimensional database in Oracle.

. Helped in the assembly, administration (management users' security)

and finally training to end-users with the MICROSTRATEGY software in

the Server, for the company and for the member banks of the

association.

. Support end-users in the use, query and generation of reports to

Senior Management to analyze and understand the information business

and thus helping them with strategic decisions that enable them to

maintain with leading ahead as a Company.

. Maintenance and improvement of the process of compensation and

exchange that Credibanco-VISA performs to the 16 member banks.

. Support to users and changes according of the policy of the business.

. Training and support to end users.

. Was reporting directly to the Director.

Aseguradora Grancolombiana, S.A., Bogota, Colombia

May 95 - Mar 98

Programmer Analyst in RPG

. Development and implementation of new programs, satisfying the changes

and improvement for a Car Insurance company.

. Maintenance and support with reports and consult applications

utilizing sub-file processing.

La Interamericana cia. de Seguros Generales., Bogota, Colombia

Oct 92 - Mar 95

Programmer Analyst in RPG

. Implementation and revision of the company's various computer

applications in RPGIII.

. Development and implementation of new programs along with changes, for

improvement of a Life Insurance company.

. Provided maintenance and support to end users.

Colpapel S.A., Pereira, Quindio

Oct 90 - Mar 92

Programmer in RPG

. Migration of the applications of inventory of S36 to AS/400.

. Maintenance and support to end users.

. Development and implementation of new programs.

Contact this candidate