PROFILE

Senior database administrator and engineer, experienced within the domains

of manufacturing, retail, insurance, banking, services, government,

pharmaceutical, and logistics.

SUMARY OF QUALIFICATIONS

. More than 20 years of experience in database administration, systems

development, and project management

. IBM Certified DB2 database administrator and iSeries developer

. Specialized in System i performance and tuning

. ERP implementation experience including JDE, SAP, MAPICS, BPCS, and

CIEL

. Java, SQL, CLP, ABAP, RPG, COBOL, PHP and C programming experience;

. Experience in: iDoctor, iSeries Navigator, Hawkeye, Vision Director,

Aldon, WebSphere, HATS, ERWin, Popkin System Architect, IBM Warehouse

Manager ETL, DB2 Connect, DB2 Data Studio

. Linux, Windows, Unix, i5/OS, AIX, and HPUX system administration

experience

. Knowledge of BI, EDW, EIS, Content Management, and Data Mining;

. Skilled in cultivating excellent relationships with colleagues,

employees, and superiors;

. International consultant experience contracted by IBM, UN and Inter-

American Development Bank;

. Team management and mentoring experience.

. Working ability in English, French, and Spanish;

. Flexible to adapt to changing requirements;

. Logic and organized, with ability to work under pressure

PROFESSIONAL EXPERIENCE

TBC Corporation, Palm Beach Gardens, Florida USA 2009

-Present

Enterprise Database Architect

TBC Corporation is the nation's largest vertically integrated marketer of

tires for the automotive replacement market. The Company's retail

operations include Company-operated tire and automotive service centers

under the "Tire Kingdom", "Merchant's Tire & Auto Centers", and "National

Tire & Battery" brands, and franchised stores under the "Big O Tires"

brand. TBC markets on a wholesale basis to regional tire chains and

distributors serving independent tire dealers throughout the United States,

Canada, and Mexico.

Objectives:

. Coordinated the creation and maintenance of enterprise databases

including Ecommerce, POS, ASW, JDE, SAP, SOA, and Epicor;

. Identified all corporation's databases, documented and administered

access security, performance, redundancy, DR, High Availability, and

backups;

. Identified the top transactions that have the greatest share in the

database load compared to total database time

. Provided performance and tuning suggestions for DB2 applications to

increase throughput and performance

. Applied indexing proactive and reactive strategies to improve

performance

. Participated in support planning and the development of long-term

strategic goals for systems and software in conjunction with end-

users, IT team members, and department managers.

. Worked as part of a collaborative, matrix team, providing technical

expertise on service management tools.

. Coordinated with network engineering, business application, system

administration, and database administration functions to implement

desktop, server, and operational application systems that utilize

industry best practices to meet corporate objectives.

. Performed a wide range of system administration duties on IT

databases, IT support applications, and other services including

install, debug, maintain, upgrade, and general support.

. Collected and reviewed system data for process improvement purposes.

. Recommended, scheduled, and performed software and hardware

improvements, upgrades, patches, reconfigurations, and/or purchases.

. Conducted research on emerging products, services, protocols, and

standards in support of systems software procurement and development

efforts.

. Normalized JDE and POS databases by eliminating deleted records,

orphans, and by enforcing referential integrity.

. Reduced company risk by enhancing test environments and ensuring test

veracity.

. Enhanced the capabilities of the Technical Services team in the areas

of Client Systems, Helpdesk, and Change/Incident management through

application of essential specialized skills.

. Administered DB2 databases on System i, Linux and Windows for SAP,

SOA, and POS implementations

. Optimized access plans and performance working on plan cache and

applying appropriate index strategies and maintenance.

. Performed SAP basis and PI administration tasks

Recochem Inc., Montreal

2006 - 2009

DB2/iSeries Developer and Project Manager

Recochem is a chemical manufacturing international company with 700

employees and production facilities in Canada and Australia. The head

office is located in Montreal.

Objectives

. Organized the exploitation of Jacana, the company's BI tool, allowing

users to analyze information coming from MAPICS and other local

developments;

. Analyzed, planned and implemented improvements to the iSeries database

performance by applying indexing strategies, best practices, database

access, SQL access plans, etc;

. Coordinated the database integration of a company takeover in

Australia;

. Implemented a new company into MAPICS database;

. Boosted the Business Intelligence analysis tools;

. Migrated Australia into Montreal iSeries database;

. Managed the implementation RF bar code project using DB2/400;

. Coordinated the workload of 4 programmer/analysts;

. Coordinated the archiving, purge and reorganization of ERP database

. Participated in the configuration of DR HA using Vision iTera E2

. Participated in upgrades of OS/400 and PTF application

. Improved the DB2/400 performance and security

. Participated in the centralization of two iSeries into one single

System i by using Logical Partitions

K hne+Nagel

2000-2006

iSeries consultant and project manager

KN is a logistic international company with head-quarters in Germany,

20,000 employees and facilities in all countries all over the world. The

head office is located in Germany.

. Engineered applications integrating different technologies such as

DB2, SQL Server, MySQL, Postgres, Java, and SQL;

. Implemented vendors' remote access to corporate applications with

HATS.

. Implemented Popkin's System Architect and ALDON

. Developed statistics, interfaces, and reports using DB2, SQL, Java and

RPG ;

. Improved database performance on DB2 applications

. Developed Java and SQL stored procedures for ETL;

. Designed, developed and implemented a sales performance analysis

application using only SQL and shell scripts;

. Instructed regional developers in the use of efficient database access

techniques;

. Developed interfaces BAPIs for SAP SD

. Developed ALV and conventional reports in ABAP/4 for MM and SD

. Developed batch input interfaces with external customers

3M de Argentina

1996 - 2000

DB2/iSeries Database administrador and Developer

3M is a manufacturing international company with offices and production

facilities in most countries of the world. The head office is located in

Minnesota, USA.

. Managed database projects for manufacturing and administration;

. Supervised the team members (4);

. Implemented database best practices.

. Optimized performance and throughput of DB2/400 database

. Year 2000 database upgrade

Unilever

1988 - 1996

DB2 for iSeries DBA and iSeries system administrator

With operations in 100 countries and 174,000 employees Unilever is one of

the largest companies in the world.

. Participated in the process of downsizing from Mainframe to System/38

. Participated in the migration process from S/38 to AS/400

. Upgraded several versions of OS/400 in central and distributed AS/400

. Consolidated information by implementing communications between 5

AS/400

. Recommended and took appropriate actions to analyze and solve database

performance and communications problems;

. Developed a new EIS application using external and SQL stored

procedures

. Developed Oracle PL/SQL, scripts, and Pro C programs on AIX

. 24 hours support of accounting, manufacturing, and HHRR applications

. Participated in the migration to SAP/R3 developing interfaces,

batchinputs, and reports

Citibank NA

1986-1988

AS/400 RPG Developer

Citi has had a presence in Argentina since 1914, and now have a consumer

and corporate customer base of more than 2,540 million individual accounts

and businesses. With over 2,500 employees serve their local communities

every day, providing consumer, corporate and investment banking services,

insurance and investment products to customers.

. Implemented a new Banking System named CORE

. Documented and developed local modules for regional customization

. Customized CORE for local regulations and requirements

. Migrated mainframe database to CORE DB2/400 database

. Implemented CORE across the South American region

Independent Consultant (short term part-time contracts or support)

. SQLiaison Montreal (2009) ( DB2 UDB DBA)

. Pitt Shoes (2006 to 2007) (DB2/iSeries DBA)

. IBM Data Management Business Partner for Software (1996 to 2006) DB2

DBA

. United Nations Program for Development UNPD (2004) DB2/iSeries DBA

. Inter American Development Bank (2003 to 2005) DB2 and Postgress DBA

. Iceberg Solutions (2002 to 2003) DB2 UDB DBA

. Banca Nazionale del Laboro (2000 to 2001) DB2 UDB DBA

EDUCATION

Strayer University

. Master of Science in Information Systems (Ongoing)

McGill University

. Certificate in Management (2009)

. Certificate of proficiency in English (2007)

AMA international (American Management Association)

. Coaching and Motivation (2007)

Universidad De Buenos Aires

. Bs in Physiology with a mayor in Computer Science (recognized by

University of Miami)

IBM Professional Certifications and courses

. ILE RPG Solution Expert i5 (2005)

. DB2 UDB DBA V4 et V5 (2000)

. HATS and Webfacing

. iDoctor for System i

. Websphere studio

. Websphere Application Server

ITTC (IBM, SUN and SAP education Business Partner)

. ABAP Academy (1999)

. WebSphere Application Server (2000)

. WebSphere Development Studio (2000)

HAWKEYE

. PATHFINDER

Vision Solutions

. E2 Itera HA

. DIRECTOR

References available upon request

Contact this candidate