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.