Jorge Serna Lopez

adcze2@r.postjobfree.com

Los Caobos Plaza, 1004 Jacinto jalib

Guaynabo PR. 00968 - movil: 52 1-558*******

VISA TN MEXICAN

Phone 52 1 55-8100.3147 to Mexico

House : 52 1 55 2607.0044

SSN : *** - ** - 1610

PROFILE:

Professional with more than 15 years of experience developing projects in banking, insurance, Government, health Sector, telephony and Communications.

5 years of experience in application and development BI, ETL ( IPC, Datastage and Genius), Dashboard, Cubes

I have 6 years of experience working with DWH - TERADATA database, programming BTEQ and FastImport, FastLoad, MultiLoad, using tools of performance monitoring and, desing DWH, Datamart and Cubes

STK Puerto Rico & Caribe Corp

San Juan

Puerto Rico

Engineer ETL IPC

From: 07/2015

To: 07/2017

Support in solution of ETL IPC requirements project EVERTEC / Popular Bank / AT&T

Migration Mainfreme to Oracle, Data quality, Performance and tunning, development to DWH

Proyect Migration Big Data ( Oracle to Vertica) In AT&T

Support,Performance and Tunning, Texting to ETL IPC BBVA Bank (fiscal platform - of taxes to the Government)

Functional Experience:

DB2,ORACLE, BI

IBM/ LIVERPOOL – Departamental Store

D.F., Mexico

Engineer ETL IPC

From: 02/2015

To: 05/2015

Engineer ETL Datastage I

Support in solution of ETL Datastage requirements project Liverpool

Support and Solution of Problems,Performsnce and tunning DWH Teradata, for Liverpool

Support to user (Reports, Queries,Stored Procedures,Trigger and Dashboard)

Functional Experience:

DB2,ORACLE, TERADATA,BI

Tools:

IPC,Datastage, Unix,Shell,Teradata Tools, Microstrategy

HP/ NEXTEL – Telephonia

D.F., Mexico

Engineer BI

From: 08/2012

To:012/2015

Consultimg BI

Support in solution of requirements project LAR.Bancomer

Support and Solution of Problems,Performsnce and tunning DWH Teradata, for Nextel

Physical and logical models of databases relational and dimensional DataMart, and cubes

Development and maintenance of ETL (extraction, transformation and loading) use Ipc and genius tool

Administration, maintenance operation of the Nextel DWH in Teradata

Support to users (Paswword, Login,Acces,Profiles,reports,tables,Stored Procedures queries, statistics)

Support to customers in the world with problems where provide solutions BI.

Functional Experience:

Oracle, Teradata,BI

Tools:

IPC, Genus, Control M, Power designer, Unix, Shell, Microstrategy, Sql, language, MS Project, MS Word, MS Excel, MS Power Point

UADEC –Universidad Autonoma de Coahuila

Consultimg BI

D,F,, Mexico

Consultimg BI

From: 05/2011

To:06/2012

Administration, Performance, and tuning a database server, Teradata, Sybase and Oracle

Modelling, analysis, design, testing based on data RIEM, DWH - Ministry of health

Maintenance objects of data base SYBASE, SQL SERVER 2008 R2, Stored Procedures, tables, views, etc of the productive Bases of the Ministry of health

Generation of reports with Report Server,

Processes special BI (ETL, creation of cubes, MDX programming)

Functional Experience:

Web development experience, Java Applications., DWH, Cubes,Report

Tools:

Teradata, SQL Server 2008, SSIS,SSRP,SSAS, Office, Teradata Tools.

PCS MEXICO – BANCO IXE

D.F. Mexico

System Engineer

From: 04/2009

To:05/2011

System Engineer :

Analysis, design, programming and maintenance of applications of the Bank Ixe

TERADATA, SYBASE database objects, Stored Procedures, tables, views, etc of the Ixe Bank

Support to Application Ixe Teller, Ixe opera, Kt-Online, Tellerf Cafe

Functional Experience:

development and Sopport Aplication IXE BANKCMM Level 3, Internal Processes

Tools:

Languages Gupta, Teradata Tools, Power Designer, Cognos, Sybase,power builldeer Windows 2000/NT,Office

Frisa, S.A.

Huixquilucan Estado de Mexico

Data Base Administration

From: 03/2002

To:03/2009

Development & database manager

Responsible for the Administration and safeguarding of the data Bases of the company

(Production, historical, payroll, malls, developments, Enkontrol)

Installation and configuration of servers of data Base

Implementation of security policies

Implementation of the DRP (Disaster Plan)

Monitoring and analysis of performance of servers

Replication process between base of database (corporate and branch offices, Replication Server)

Performance and tuning database servers

Analysis, development and construction of administrative applications (Power Builder, inventory, work unit prices), analysis and documentation of processes for new developments

Start-up and implementation of the modules of the SIPDI (sales, internal services, accounting, collection, store, unit prices and work), data migration, Testing testing, load processes of information, reports design, statistical reports and management

Table service, technical support, service and advice to local and remote users

Design of data base, data mining and design of Cognos cubes

ASE 12.504 15.01 version-version migration

Replication Server (corporate offices to Baja california Sur)

Preventive maintenance to the computers, printers, etc.

Functional Experience:

Sopport,. Development, manager database

Preventive maintenance on PC.

Tools:

Sybase, Power Builler, Cognos,Power designer, Bradmark, Embarcadero, Windows NT, office, Norton Antivirus and Norton Utilities

EDUCATION:

Universidad Autonoma de Mexico -UNAM

Cd. Mexico

1986 - 1991

Computer Engineer

Master’s Network Lan

Upgrade - SISCO NETWORK (PHOENIX COLLEGE ARIZONA)

PROFESIONAL DEVELOPMENT:

DBA SYBASE

Sybase de Mexico

2007

Performance and Tunning

Sybase de Mexico

2007

Replication Server

Sybase de Mexico

2007

DBA SQL 2008

Microsoft de Mexico

2009

DBA Teradata

Teradata de Mexico

2012

BI

Microsoft de Mexico

2010

BI -Teradata

Teradata de Mexico

2012

LANGUAGES:

Spanish native, English 60% fluent

TECHNICAL/MANAGERIAL SKILLS:

Primary Profile:

Software Engineer for Java client/server systems, C/C++,Gupta

Secondary Profile:

Gathering and analysis of requirements and delivery of solutions

Hardware:

Windows 2008, 3007, XP, Windows 2000 and older versions, Unix, AIX and Linux

Operating Systems:

Windows 2008,20073, XP, Windows 2000 and older versions, Unix, AIX, and Linux

Programming Languages:

Java (3 years), Visual.net(2 years), C++ (3 years), HTML (2 years).

Databases:

DB2, MySql, SQL SERVER, SYBASE,ORACLE,TERADATA,VERTICA

App. Servers:

Tomcat, Websphere, Rational Application Development, Eclipse

Other:

UML, Netbeans IDE, XML, MS Project,Office, Putty, Sql,Embarcadero, Toad, Microstrategy,Cognos.

REFERENCES

Contact information

Name: Marco Rosales

Tel.551-***-****

Mail:adcze2@r.postjobfree.com

Position:DBA Sql Server

Name: Salvador Trejo

Tel.554-***-****

Mail:adcze2@r.postjobfree.com

Position: Dba Oracle

RECOMMEND A FRIEND

Contact information

Name: Norma Romero

Tel.55746574

Mail:adcze2@r.postjobfree.com

Profile: Gerente Recursos

Name: Juan Marcos Gonzalez

Tel.553-***-****

Mail:adcze2@r.postjobfree.com

Profile: Java Programmer

Contact this candidate