YESID FRANCO

Phones: +1-561-***-****

Current Location: Boston, MA. USA.

E-mail: acradt@r.postjobfree.com; acradt@r.postjobfree.com

OBJECTIVES

To work in a company where I can expand my knowledge and my personal aptitudes in order to contribute significantly.

Also to have the opportunity to learn new tools for the technological and administrative level.

PROFESSIONAL PROFILE

Experience in analysis, design and system development of information in financial, insurance, and telecommunication sectors.

As well as, experience in administration of databases, support and maintenance of computer equipment and attention to users.

Extensive knowledge in programming tools such as Oracle SQL Developer, TOAD, c & pro*c languages; shell script, Perl, awk; ETL processes, Oracle PL/SQL, SQLLoader and Oracle DataWarehouse.

Self-training in Informatica 9.6, Oracle ODI, Oracle APEX.

PROFESIONAL EDUCATION

System Engineer- December in 1991

Financial Administration Specialist-December in 1994

EXPERIENCE AND ACHIEVEMENTS

Company: SOTEC CONSULTING

Boston, MA United States

December-2014 - currently

Position: Software Developer

Responsibilities:

Analysis, development and maintenance of processes batch to extract information about of Anti-Money Laundering, Norkom, McCracken Real State Portfolio and Parthenom Cards Administration System for the client SANTANDER-SOVEREIGN BANK in Boston,MA.

Proficient in tuning queries used in the application.

Experience in Database Application Development, Query Optimization, Performance Tuning and DBA solutions and implementation experience in complete System Development Life Cycle.

Knowledge: Windows, Oracle 9i-10g-11g, Pl/Sql, Sqlldr, Shell Script UNIX, Pro*C.

Company: PROCAM MEDIA

West Palm Beach FL, United States

June 2012 to December 2014

Position: Technical Consultant

Responsibilities:

Technical support in hardware and software, Developer Web pages

Knowledge: Windows, UNIX, Apple, Joomla, Perl, html, PHP, MySQL, Java

Company: ALTRAN CIS

Madrid, Spain, October 2007 to May 2009

Position: Consultant for the Customer MAFRE

Responsibilities:

Analyse, develop, support and maintain TRON21 and TRONWEB applications for the Treasury Module, developed with procedures, packages and Oracle triggers (PL/SQL) and Java programming.

Highly skilled in Performance tuning - analysing query plans.

Creation of reports with PL/SQL procedures from Oracle and generating xml code to templates JASPER.

User support and treatment of errors in system production.

Knowledge: Oracle 9i, Windows XP, JAVA, XML, PL/SQL Developer, Crystal Report, Jasper

Company: ACCENTURE - CORITEL

Madrid, Spain, February 2006 to October 2007

Position: System Analyst

Responsibilities:

Administration and technical support of the Database Oracle9i of the project METRO MADRID. Analysis, development, programming and maintenance of the different functions and procedures of the same project & Involved in Performance tuning of complex queries.

Knowledge: Oracle 9i, Siebel, Windows XP, JAVA, TOAD, PL/SQL

Company: EYES TECHNOLOGIES

Madrid, Spain, October 2005 to January 2006

Position: System Analyst

Responsibilities:

Analysis/development/maintenance of different programs for the client.

Knowledge: Oracle 9i, UNIX, TOAD, PL/SQL, shell script, awk, Perl

Company: WAIRBUT

Madrid, Spain, April 2005 to September 2005

Position: System Analyst

Responsibilities:

Analysis/development of processes batch to extract information of the warehouse for the different areas needed by the customer TRAVEL CLUB.

Optimized the performance using PL/SQL table types and record types.

Knowledge: Windows NT, Unix-SunOS 5.6; pro*c, PL/SQL for Oracle 9i, shell script, awk, tools of development of Oracle 8i and 9i.

Company: ARELANCE

Málaga, Spain, January 2005 to April 2005

Position: Analyst

Responsibilities:

Analysis/development/maintenance of programs for the client EROSKY.

Knowledge: Oracle 8i, FORMS 7.0

Company: AXPE Consulting

Madrid, Spain November-2003 to January 2005

Position: System Analyst

Responsibilities:

Analysis/development of the processes batch with tool pro*c for the invoicing of mobile phones, project ATARV3 of Telefonica I+D. Entrusted to administer, support and maintain the database Oracle 9.2. Analysis/development of the processes shell and pl/sql for the project of the Subsystem of SPM's Statistics, which is with platforms unix, sybase and Micro strategy.

Actively involved in fine tuning solutions and code reviewing.

Analysis/development of the processes batch with tools pro*c, shell script and awk down UNIX and database Oracle 8.1.7, for project MVC (Model of Client's Value) for Telefonica Advertising and Information.

Knowledge: Windows XP, Unix-SunOS 5.6; pro*c; PL/SQL for Sybase, shells script, awk. Tools of Development of Oracle 8i y 9i

Company: ATOS ORIGIN

Madrid, Spain March-2001 to November-2003

Position: Organic analyst

Responsibilities:

Analysis, development, programming and maintenance of the different functionalities for the client ENAGAS.

Administration and technical support of the Network on Windows NT, manager of the Database.

Knowledge: AIX, Windows 95 and NT. Developer 2000, Pro*C, PL*Sql, Shell Scripts, AWK. Database Oracle for AIX

Company: DYCSA

Colombia, August-2000 to March-2001

Position: Technical Analyst/Support Manager

Responsibilities:

Maintenance of the modules.

Invoicing the system of Telecommunications ELITE.

Equally, administer the database Oracle.

Knowledge: AIX, Windows.98, Pro*C, PL*Sql, Shell Scripts, AWK, Visual Basic 6.0. Database Oracle for AIX

Company: SCHLUMBERGER

SEMA – Colombia October-1998 to March-2000

Position: Technical analyst

Responsibilities:

Installation, technical support Windows NT and Unix, manager of the Database. Installation and support of the system of Credit cards TARSIS, for the clients of South America.

Installation realized in Quito - Ecuador.

Knowledge: AIX, AS400, Windows 95 and NT. Developer 2000, Pro*C, PL*Sql, Cobol, Shell Scripts, AWK. Database Oracle for AIX and DB2 for AS400

Company: BANCO GRANAHORRAR

Bogotá Colombia May-1995 to December-1997

Position: Professional IV

Responsibilities:

Analysis, design, development and project programming of different financial and administrative systems of the own company.

Knowledge: UNIX and DOS. C, ProC, Pl/SQL, SQL Plus, FORMS 3.0, Shell and AWK, Visual FoxPro, Visual Basic 3.0 y 4.0. Database ORACLE 7, Unify 5.0, Access.

Company: SIGMA

Bogotá Colombia November-1994 to May-1995

Position: Specialist

Responsibilities:

Development, maintenance and support of the administrative modules of the system "SIGMA".

Administration of the Database.

Knowledge: AIX, ACCELL 4GL, Database UNIFY 2000.

Company: BANCO SUPERIOR

DINERS CLUB – Bogotá Colombia Augost-1991 to December-1994

Position: System Analyst

Responsibilities:

Analysis, design, development of new requirements for the applications of Portfolio and Administrative Services (Fixed Assets, Purchases, Suppliers, Inventories).

Knowledge: UNIX and XENIX, ACCELL 4GL, Database UNIFY 2000

Contact this candidate