CURRICULUM VITAE

F RANCISCO ALIRIO GONZÁLEZ JIMÉNEZ

RESUME PROFESSIONAL EXPERIENCE

Senior Soft ware Analyst/Developer O RACLE.

I have 15 experience years in PL/SQL and Developer Forms and Report version 6i.

10 years experience in Oracle Database Administration from version 7. 3 to 11G.

Experience in Creation of: Triggers, Stored Procedures, Packages, Functions, Jobs, etc.

This tool I use this on my work at El Salvador, all time on Financial Institutions with maintenanc e

and developing new applications of modules: Cash, Banks, Accounting, Taxes & Fees,

Trans ferences, Credits, and others .

Planning and exec ution of applicati ons migration from Oracle 7.3(mode caracter) to Oracle Forms

and Reports 6i.

5 y ears experience in migration data system on diverse database AS/400 to Oracle, Oracle t o SQL

Server and Banks software migration and new soft ware development.

6 y ears on Adm inistrating training area, having responsibilities as planning and ex ecute trainings to

administrative and exec utive areas into system level and banking operations.

PLSQL Development experience ac ross the full lifecycle of an application (or report) inclu ding:

analysis, design, development, testing, maintenance & support of products built with PLSQL.

PLSQL for stored procedures and functions within packages, triggers and libraries.

Regularly communicat es and interfaces directly with stakeholders and end -users to obtain

requirements, validate software or application prototypes, perform testing, and coordinate roll -out

of applications or reports and end production.

Translat e user requirements to process and data requirements.

Interpreting business requirements and design application solution.

Ensure the designed specifications achieve business needs.

Analyzing project and/ or technical risk, using available information, to support business

recommendations.

Analyzing business an d/or client processes and practices to identify and recommend

opportunities for enhanc ement.

Assessing work and information flows to identify and recommend appropriat e solutions.

Providing overall solutions to complex application problems.

Providing applic ation solutions or making technology selection decisions that are often made in

s ituations where business requirements are not completely defined or changing.

I work well with others.

I team work .

I work well under pressure.

MSOffice, SQL Study 2008 R2, SQLServer Migration Assistant for Oracle v5. 1.

Data mining and OLAP Cubes in SQL SERVE R 2005.

Currently I’m learning Visual Studio 2010 Professional, C++ .

PERSONAL INFORMATION

Name : Francisco Alirio Gonzalez Jiménez

A ddress : Ciudad Delgado, San Salvador El Salvador.

Contact Nu mber: M obile ( 503)- 7 319 -2800

E- mail : fagjgo2@g mail.co m, acem46@r.postjobfree.com m

SKYPE A ccount faliriog

sv.linkedin.com/pub/francisco- alirio- gonzalez- jimenez/39/a34/1ab/

Linkedin A ccount

Civil Status : M arried

Language Spanish/ Englis h

Relig ion: Evangelical Christian

EDUCATION

2005- 2007 M aster of Applied Systems Networks

University Francisco Gav idia (UFG)

San Salvador, El Salvador

198 9- 2001 Bachelor in Journalis m

University of El Salvador (UES)

San Salvador, El Salvador

20 12- currently English Course

University Don Bosco

Soyapango, El Salvador

PROFESSIONAL EXPERIENCE

SENIOR DEVELOPER

M ain achievement: Reduction of the closing night of the loan module fro m 2:30 hours to 15 minutes.

Reduction by 75% of the requirements o f data corrections, based on the timely modification of programs and /

o r reports.

Functions : M anage Modules : Loans, Current Account, and M odule Iva Arango Software package Abanks

7.0,2,0 . System creaded with developer 6i on database 10g.

I mprovement s in : Procedure, Package, Function, Triggers used in the respective application. Bu ild ing and

improvements in the forms and reports of the applications .

Performance tests in controlled environ ments prior to release to production .

Data migrat ion A banks System to SOLX ( proprietary product of the G & T Continental Guatemala) ended

M arch,16,2014.

Co mpany: Banco G & T Continental o f El Salvador S.A.,

A ddress: 49 South Ave . / Passage Luis Po ma, Colo g n e F lor Blanca N 122, San Salvador .

Office Phone : (503) 2527- 6747

Begin May, 2009 to currently

Depart ment / Section : Depart ment of Develop ment

Co mpany Type: Regional financial co mpany dedicated to the recruitment and placement of funds by

b orrowing short and long term sector aimed at mediu m and large en terprises .

Technologies used:

Java, C ++, . ASP, SQL SERVER 2008 R2, Forms / reports 6i Oracle version, Oracle Database fro m 9i to

10g ., Toad fo r SQL SERVER 5.7. 0.605, 9.0.1.8 Toad for Oracle, SQL Server Mig ration assitant to for

Oracle version 2.5.1259 (HSE ), Visual C++ 2010 Express, Microsoft Source ( 60 ) .

PROGRAMMER / SYSTEMS ANALYST AND DBA JUNIOR

M ain achievement: Reduction by 80% in the Accounting module problems, by modify ing and correcting

p rograms and reports. Integration module with the module man cash loan online payments.

Creat ing autonomous program for money transfer receipt with the company Ria.co m.

Functions : Banca2000 Software Application Manager ( SYSDE ) maintenance : Module Cash, Bank Account

Integra General Ledger, Custo mer Management, Taxes, Local transfers and other related applicat ion.

Develop ment of new applications into modules in my charge.

Correct ions to existing applications and create new programs to demand.

Performance tests in controlled environ ments prior to release to production.

M igration bank applications for version 2.1 to 6i.

Tuning of the application forms and reports Migration 9i database to 10g.

M anager operational database imp lementation support database migration fro m Tru64 servers to HP - UX 11i

Pro liants.

Datamarts with SQL2005 Management.

Co mpany: Bank Pro merica S.A. ( El Salvador )

A ddress: Building Pro merica D.C. The Gran Via Antique Cuscatlan, El Salvador

Office Phone : (503) 2513- 5000

Begin March 1999, ended April,2009

Depart ment / Section : Depart ment of Develop ment

Co mpany Type : Regional Financial co mpany dedicated to the recruitment and placement of funds by

b orrowing short and long term sector aimed at SM Es.

Technologies used : Forms / reports Oracle fro m version 2.1 to 6i, Oracle Database from 7.3 to 10g ., Toad

for Oracle 8.0 and Unix Operating System, Jdeveloper oracle .

SYSTEMS ANALYST

Functions : Coordination of P rocesses n ight operators.

Create reports with IBM technology, using AS400 DB2 SQL for all ad min istrative departments of the bank .

Data Migrat ion AS400 banking system to ORACLE using flat files.

Co mpany: Corporate Ban k SA ( Bancorp S.A . ) (absorbed by Banco Pro merica S.A . )

address: This enterprise currently Closed.

Office Phone :

Begin December 1998, ended M arch,1999

Depart ment / Section : Depart ment of Develop ment

Co mpany Type : Local financial co mpany dedicated to the recruitment and placement of funds by borrowing

s hort and long term targeted consumer sector, micro and med iu m enterprises.

Technologies used : QUERY400 A S400

ASSISTANT ACCOUNTANT

Functions: Transaction log operations bank in s avings account and Credit Card o n account customers, Balance

Daily and Accounting

Co mpany: Bank deposits Assistant Uno SA (closed)

address:

Office Phone :

Begin Ju ly 1998, ended December 1998

Depart ment / Section : Depart ment of deposits .

Co mpany Type : Local financial co mpany dedicated to the recruit ment and placement of funds by credit card.

TRAINING COORDINATOR AND INSTRUCTOR S YS TEM

Functions : Training Coordinator bank emp loyees for administrative and operational areas.

Creat ion and Planning train ing of bank emp loyees.

Operational Guidelines Creating processes.

Creat ing tutorials and manuals for use Probanks system in all operat ional and administrative areas o f the bank.

M igration System D igital to Power System Brach and Banking K indle p roducts .

Team Member restructuring process, implementation of the new banking software, this was before the

company was absorbed by the Bank Salvadoran .

Operator training s ystems, Cash Man, and admin istrative area personnel to the appropriat e use of each agency

's servers,

Co mpany: Bank Bancasa SA (closed)

address:

Office Phone :

Begin March 1993, ended July 1998

Depart ment / Section : Training and Develop ment Depart ment .

Co mpany Type : Local financial co mpany dedicated to the recruit ment and placement of funds by placing

consumer loans.

Technologies used: Unix Operat ing System,

TECHNICAL SKILLS

Forms / Reports Oracle vers ion fro m 2.1 to 6i (10)

EBS ORA CLE 11G(4)

SQL SERVER 2008 R2 (7)

Oracle Database version 7.3 to 9i (10)

Oracle Database 10g version (8 )

Oracle Database 11g version (6 )

Toad SQL SERVER 5.7.0.605 (6)

Toad for Oracle 9.0.1.8 (10),

Sql Server M igration Assitant to for O racle version 5.2.1259 (7 )

Visu al C ++ (5 ).

Unix Operating System (6 )

A S400 DB2 QUERY400 (10)

M icrosoft Source (6),

Vo ice over IP w ith T RIXBOX o n Linu x ( 80)

Java (6)

Contact this candidate