Post Job Free

Resume

Sign in

Sql Server Customer Service

Location:
El Salvador
Salary:
$35/hour
Posted:
March 29, 2017

Contact this candidate

Resume:

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



Contact this candidate