FRANCISCO ALIRIO GONZÁLEZ JIMÉNEZ
PROFESSIONAL EXPERIENCE
Senior Programmer/Analyst Developer ORACLE.
I work well with other, team work and I work well under pressure.
Strong problem solving abilities.
Excellent organizational skills, with ability to prioritize and multi-task.
Proven ability to thrive in a busy, fast-paced environment.
Ability to work independently.
Strong customer service experience/background.
18 years’ experience in PL/SQL and Developer Forms and Report from version 6i to 11g.
11 years’ experience in Oracle Database Administration from version 8i to 11G.
18 years’ experience using the methodology SDLC.
10 years experience in migration data system on diverse database AS/400 to Oracle, Oracle to SQL Server r12, SQL Server r12 to Oracle 11g and Banks software migration and new software development too.
Planning and execution of applications migration from Oracle 8 (mode character) to Oracle Forms and Reports 11g.
Strong experience in Creation of: Triggers, Stored Procedures, Packages, Functions, Jobs, etc.
Regularly communicates 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.
Translate 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 and/or client processes and practices to identify and recommend opportunities for enhancement.
Assessing work and information flows to identify and recommend appropriate solutions.
Providing overall solutions to complex application problems.
Providing application solutions or making technology selection decisions that are often made in situations where business requirements are not completely defined or changing.
Microsoft SQL Server SSRS & SSIS, SQL Tuning application, ETL and Loader SQL, TSQL (queries, stored procedures).
8 years as a Quality Assurance Analyst
OLAP databases, Oracle and SQL Server.
Solve software bug situations by controlling the flow using Bugzilla.
4 years’ experience in creation of cubes using SQL Server data warehouse prior processes using ETL load data, the information shown in the cubes are displayed by interacting with Excel using connections to the database DataMart company in which he worked, these data came from process deposits, withdrawals, payments of services, payments on personal loans, etc., in order to have a measure of efficiency of the customer and to establish new products or services to customers of the bank.
6 years on Administrating training area, having responsibilities as planning and execute trainings to administrative and executive areas into system level and banking operations.
All my experience is on Financial Institutions with maintenance and developing new applications of modules: Cash, Banks, Accounting, Taxes & Fees, Transferences, Credits, and others.
PERSONAL INFORMATION
Name: Francisco Alirio Gonzalez Jiménez
Address: Country El Salvador.
Contact Number: Mobile (503)- 7319-2800
E-mail: aczjtw@r.postjobfree.com, aczjtw@r.postjobfree.com
SKYPE Account faliriog
LinkedIn Account sv.linkedin.com/pub/francisco-alirio-gonzalez-jimenez/39/a34/1ab/
Civil Status: Married
Language Spanish/English
Religion: Evangelical Christian
Salary The published in supply this right.
EDUCATION
2005-2007Master of Applied Systems Networks
University Francisco Gavidia (UFG)
San Salvador, El Salvador
1989-2001 Bachelor in Journalism
University of El Salvador (UES)
San Salvador, El Salvador
2014- currently English Course in University Don Bosco, Soyapango, El Salvador
PROFESSIONAL EXPERIENCE
ORACLE TECHNICAL CONSULTANT
Company: Sysde International LTD of Costa Rica.
Begin November, 2014 to currently
Functions: Development of banking applications: customer management, accounting, loans, banks, pensions, among other applications 11g developer tools, I have 2 months start development with ADF Oracle.
Solve software bug situations by controlling the flow using bugzilla.
Implementation of banking applications, technical user support, Back office support, analysis and design of programs, analysis and design of reports, create database packages, functions, procedures, jobs.
SENIOR DEVELOPER
Company: Bank G&T Continental of El Salvador S.A.
Begin May, 2009 to September 2014
Main achievement: Reduction of the closing night of the loan module from 2:30 hours to 15 minutes.
Reduction by 75% of the requirements of data corrections, based on the timely modification of programs and/or reports.
Functions: Manage Modules: Loans, Current Account, and Module Iva Arango Software package Abanks 7.0,2,0 . System created with developer 6i on database 10g.
Improvements in: Procedure, Package, Function, Triggers used in the respective application. Building and improvements in the forms and reports of the applications.
Performance tests in controlled environments prior to release to production.
Data migration Abank’s System from Database Oracle to SOLX Database Microsoft SQL Server.
Developer reports using SSRS Microsoft R12.
Quality Assurance Analyst in the new applications developed C#.
PROGRAMMER / SYSTEMS ANALYST AND DBA JUNIOR
Company: Bank Promerica S.A. (El Salvador)
Begin March 1999, ended April,2009
Main achievement: Reduction by 80% in the Accounting module problems, by modifying and correcting programs and reports. Integration module with man cash module and module loan online payments.
Creating autonomous program for money transfer receipt with the company Ria.
Make application with Microsoft Accesso as an alternative for change in 2000, the application had everything needed to process transactions and handle the day balances of customer accounts, balances tellers.
Functions: Banca2000 Software Application Manager (SYSDE) maintenance: Module Cash, Bank Account Integra General Ledger, Customer Management, Taxes, Local transfers and other related application.
Development of new applications into modules in my charge.
Corrections to existing applications and create new programs to demand.
Performance tests in controlled environments prior to release to production.
Migration Bank applications for version 2.1 to 6i.
Tuning of the application forms and reports Migration 9i database to 10g.
Manager operational database implementation support database migration from Tru64 servers to HP- UX 11i ProLiant’s.
DataMart’s with SQL2005 Management.
SYSTEMS ANALYST
Company: Corporate Bank SA (Bancorp S.A.) (absorbed by Banco Promerica S.A.)
Begin December 1998, ended March,1999
Technologies used: QUERY400 AS400
Functions: Coordination of Processes night operators.
Create reports with IBM technology, using AS400 DB2 SQL for all administrative departments of the bank.
Data Migration AS400 banking system to ORACLE using flat files.
ASSISTANT ACCOUNTANT
Company: Bank deposits Assistant Uno SA (closed)
Begin July 1998, ended December 1998
Functions: Transaction log operations bank in savings account and Credit Card on account customers, Balance Daily and Accounting
TRAINING COORDINATOR AND INSTRUCTOR SYSTEM
Company: Bank Bancasa SA (closed)
Begin March 1993, ended July 1998
Technologies used: Unix Operating System.
Functions: Training Coordinator bank employees for administrative and operational areas.
Creation and Planning training of bank employees.
Operational Guidelines Creating processes.
Creating tutorials and manuals for use Probanks system in all operational and administrative areas of the bank.
Migration System Digital to Power System Brach and Banking Kindle products.
Team Member restructuring process, implementation of the new banking software, this was before the company was absorbed by the Bank Salvadoran.
Development Reports used Query AS400 and administration System Operative. Backup and Recovery.
Operator training systems, Cash Man, and administrative area personnel to the appropriate use of each agency's servers.
TECHNICAL SKILLS
Forms / Reports Oracle version from 2.1 to 11g
Microsoft Access
Loader SQL
PL/SQL
SQL*plus
SQL Tuning
EBS ORACLE 11G
Microsoft SQL Server 2008 R2
SSRS Microsoft.
Oracle Database version 8i to 9i
Oracle Database 10g version
Oracle Database 11g version
Toad SQL SERVER 5.7.0.605
Toad for Oracle 9.0.1.8
SQL Server Migration Assistant to for Oracle version 5.2.125
Visual Study C ++ 2010
Unix Operating System
AS400 DB2 QUERY400
Microsoft Source
Voice over IP with TRIXBOX on Linux
Java