Leandro Guimarães Faria Corcete Dutra

Career

Atech Fundação Aplicação de Tecnologias Críticas

Independent Software Vendor, since May 2007

Data Administrator

• Setting data modelling and coding standards.
• Creation and revision of data models.
• Technological platforms evaluation.
• Application data troubleshooting.

Orolix Desenvolvimento de Software Ltda

Internet Service Provider & portal, July 2006 to May 2007

Data and Database Administrator

• Setting data modelling and coding standards.
• Creation and revision of data models.
• MySQL & PostgreSQL administration on Debian GNU/Linux & Red Hat Enterprise i386.
• MySQL replication and backup.
• Technological platforms evaluation.

Toyota do Brasil Ltda

Automobiles, June 2005 to April 2006

Data Administrator

• Reverse engineering of legacy Oracle and Progress databases, data modelling of new systems, interface with developers and analysts, building of a data dictionary.
• Creation of data modelling and database coding standards, revision of models and applications for standards compliance and performance.
• Relational datacentric applications prototyping in Alphora Dataphor, implementing declaratively bussiness rules.
• Evaluation of data dictionary and modelling tools.
• Instruction on relational basics, modelling and database manipulation to new developers.

Database Administrador

• Oracle 8i to 10g on Sun Solaris, GNU/Linux and MS Windows 2000 to 2003 Advanced Server, MS SQL Server 2000.
• Oracle 8i performance tuning, revision of Oracle 9i applications database performance.
• Migration of databases from MS SQL Server to Oracle.

Independent Consulting

First semester 2005

Systems Administrator and Architecture

• Planning and implementing office automation systems for reduced licensing and hardware costs.

Republic of Mozambique

Tax reformation project, October 2004 to December 2005 (temporary)

Database Administrator

• Administration of medium-sized, distributed Oracle 9i databases on MS Windows 2000 Advanced Server in development, testing and production for national tax collection.
• Definition of Oracle database and MS Windows system security standards, planning and implementation of automated backup routines.
• Training of local personnel on DB concepts and DBA tasks, Unix concepts.
• Implementation of GNU/Linux i386 for testing future integration into (and eventually superseding of) MS Windows infrastructure as a platform for database and applications serving.
• Data load from various legacy systems.

Systems Architect

• Proposed and designed a new, centralised system for significant licensing and support cost savings based on free software such as GNU/Linux and possibly PostgreSQL.

Web-Link Tecnologia Ltda

Payment cards and retail project, February to October 2004 (cancelled project)

Systems and Database Administrator

• Installation, configuration and administration of Oracle 8i, 9i and 10g databases on Debian GNU/Linux 3.1 i386.
• Installation, configuration and administration of PostgreSQL.

Systems Analyst, Data Modeller

• Systems analysis for a credit card system.
• Data modelling for credit and pre-paid cards, Web portal.

Municipality of São Paulo

Community Computing project, December 2003 to January 2004 (temporary)

Team Coordinator

Systems Analysis

• Coordination of the Telecentros’ Debian GNU/Linux development and maintenance team.
• Coordination of the development of the Debian GNU/Linux Sacix distribution.

Systems Administration

• Debian GNU/Linux 3.1 i386, host and terminals (thin client).

Orange Communications, Lausanne, Switzerland

France Telecom’s Orange Group cellular phone operator, November 2001 to February 2003

Test Environments Administrator

Achieved the reduction of function workload from 250% (two resources, overloaded) to 70%.

Application Administration

• Amdocs Ensemble test environments installation, maintenance & upgrade on HP-UX 11i, Oracle 8i, MS Windows NT 2000.

Systems Administration

• Instruction to users, management & testers on system architecture & operation; training of successor.
• System administration procedures’ documentation, streamlining & automation.

Amdocs Brasil Ltda

World’s biggest telephony Customer Care & Billing system vendor, September 1998 to July 2001

Infrastructure Support & Team Coordination

Oracle database administration

• Oracle 7.3 to 8.1 installation, upgrade & configuration.
• Database upgrade, maintenance & configuration at several clients and the internal development site.
• Creation and maintenance of SQL and Unix shell scripts.
• Application, database and DBMS troubleshooting & tuning in a BEA Tuxedo transaction processing environment.

Database and database server models documentation

• Reverse engineering and maintenance of Oracle Designer repository and diagrams for documentation of physical database.
• Creation and operation of data mining Business Objects schemas.

Data extraction and interfaces

• Data export, import & load for interface with various systems.
• Semantics and funcionality research for data warehousing.

Test environments administration

• Planning, creation, troubleshooting and maintenance of database and Unix testing accounts in multiuser testing environments.

Training and Instruction

• Instruction to developers, users and new DBAs on Amdocs Ensemble architecture and data model.
• Instruction to new employees on relational database concepts, Unix tools and Oracle issues.
• Training new employees on Amdocs application DBA procedures.

International Projects

Amdocs Israel

3 months: IT infrastructure, development & deployment training.

BellSouth Guatemala

6 weeks: test environments administrator, DBA.

TeleRing Austria

2 weeks: DBA, performance tuning.

Bell Canada

1 month: DBA.

TeleDanmark

3 weeks: DBA.

Vodafone Germany

2 months: DBA, user training.

LG Electronics da Amazônia Ltda

Korean consumer electronics and computing manufacturer, October 1996 to September 1998

IT Assistant

Deployment of all administrative support IT systems for initial two and a half-years phase of the company's implementation in the country.

Database Administrator

• Oracle 7 and MS SQL Server 4 databases administration.

Systems Administrator

• Unix and MS Windows NT systems administration.

Team Leader

• Users and developers second line of support, coordination of the first line.
• On-the-job training of support personnel.

Banco Itaú SA

Second biggest private Brazilian bank, January 1994 to October 1996

Systems Analyst

• Clean-up, update and maintenance of mission-critical batch mainframe routines during massive increase in data volume.
• Planned, designed, and helped implement the automation of inter-banks cash transfers.
• Operation and users support.

Programming

• IBM COBOL II, sequential files, VSAM, DB/2; MS Visual BASIC.