Computer Science Accounts Receivable

TECHNICAL SKILLS:

Experienced withServer AS***/iSeries

Experienced with database theory and design.

Strong knowledge about IBM DB2, Microsoft SQL Server

Knowledge of structured query language (SQL)

General understanding of distributed computing architectures on Client/Server, Internet/Intranet, Enterprise

General understanding of the underlying operating systemWindows, Unix, Linux, AS400

General understanding of storage technologies, memory management, disk arrays, NAS/SAN, networking

General understanding of routine maintenance, recovery, and handling failover of a Database

Experienced with Erwin, CA solution.

Knowledge Visual Explain.

ABILITIES:

Work in a team and under pressure.

Effective communication.

Proactivity and responsibility.

Good interpersonal relationships.

Successful experience with personnel management.

Spanish, Italian and English fluently.

PROFESSIONAL EXPERINECE:

Banesco Universal Bank Venezuela January 2001 to Present

Data Base Administrator

Administration iSeries (i5) DB2 database and DB2 in LUW(for the warehouse and whole bank branches)

Database intonation on the iSeries (i5) DB2 such as IBS, debit card, credit card, accounting, credit, Internet Banking, among others.

Management, creation and database table modifications, views,index, store procedure, etc.

Creation tools to support thetask administration perform and keep the disk space in the best way.

Tuning database, queries, read and setting up indexes.

Realization of programs for debugging those files that occupy a large amount of space on the iSeries.

Management the use of disk space, review of replicas and Journal files over mirror and contingency machines.

Journaling tables when is needed.

Using Erwin tool, CA owner; creation relational database, working together with automation areas.

Coordinationfunctional testing on daily closures and testing in application improvements.

Using Visual Explain to view the statistics about the SQL statementsembedded and take actions for its optimization.

Troubleshoot incidents with iSeries database.

Creation chart to show the trend of growth ASPs and determine the guidelines to keep the ASP in the optimal values.

Review the authorization on different tables.

Creation Cl’s for debugging process, monitoring, management and control the databases.

Banesco Universal Bank Venezuela September1998 to September 2001

Support Analysti Series (i5) or AS/400 and 390

Review and implementation for passes to production environment by programs, tables, etc.

Creation of job description JOBD for each groups of users.

Establish monitoring jobs,running on different machines.

Administration of versions of programs and files

Establish standards and policies in the nomenclatures about:

1.The processes performed by the Planner

2.Programs

3.Libraries

4.Devices

5.Lines of Communication

6.Tables, views, triggers, store procedures.

Manage the processes of replicas through the MIMIX

Creation of data group Journal and receivers

Americer Venezuela January 1991 to June 1998

Computer Department Supervisor

Administration of client/server platform and the AS/400 C10.

Coordinate the different projects areas.

Coordinate backups

Review and testing of several applications such as payroll, billing, accounts receivable, accounts payable, inventory, accounting.

Execution of connection between the main building and the office.

Realization of CL programs for the AS/400 and FoxPro, Clipper for servers

Gruquica Venezuela February 1986 to December 1990

System Analyst

Carry out programs of different applications such as payroll, billing, accounts receivable, accounts payable, inventory, accounting, financial analysis etc

Implementation of closures and backups

EDUCATION:

Nueva Esparta University Venezuela Degree in Computer Science

Nueva Esparta Insitute Venezuela

Associate in Computer Science

Contact this candidate