YESID FRANCO
Phones: +1-561-***-****
Current Location: Boston, MA. USA.
E-mail: **********@*****.***; **********@*****.**
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