Leandro Guimarães Faria Corcete DUTRA Brazilian, married, one child, born October 23rd, 1,971 Goals: Data Administration and Modelling; Systems Architecture Av Sgto Geraldo Santana, 1.100 - bl 6, apto 71 Campo Grande 04674-000 São Paulo, SP Brasil +55 (11) 5685 2219 (res) +55 (11) 9406 7191 (cel) Local hour: GMT-3 http://br.geocities.com.br/lgcdutra/cv_l.html leandro@dutra.fastmail.fm leandro.gfc.dutra@gmail.com AIM/ICQ: 61287823 Jabber, GMail: xmpp:leandrod@jabber.org Yahoo! Messenger: lgcdutra MSN Messenger: leandro@dutra.fastmail.fm EDUCATION Business Management Graduated 1,993 University of São Paulo Economy, Management and Accounting School Specific courses on Information Systems, Marketing and Human Resources CAREER Atech Funcaçã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. 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 June 2005 to April 2006 Data and Database Administrator • Reverse engineering of legacy Oracle and Progress databases, data modelling of new systems, interface with developers and analysts, building of a data dictionary. • Definition and enforcement of data administration standards. • Oracle v7 to 9i on Sun Solaris v9, Red Hat GNU/Linux Advanced Server and MS Windows 2000 and 2003 Advanced Server, MS SQL Server 2000. • Relational datacentric applications prototyping on Alphora Dataphor, declaratively implementing business rules. • Instruction on relational basics, modelling and database manipulation to new developers. Government of the Republic of Mozambique October 2004 to January 2005 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. • Planning and implementation of automated backup routines for Oracle and MS Windows servers, definition of Oracle database and MS Windows system security standards. • 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 February to October 2004 Systems Analyst and Administrator 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. Prefeitura do Município de São Paulo December 2003 to February 2004 Systems Analyst and Administrator Systems Administrator • Debian GNU/Linux 3.1 i386, host and terminals (thin client). Systems Analyst • Coordination of the Telecentros’ Debian GNU/Linux development and maintenance team. • Coordination of the development of the Debian GNU/ Linux Sacix distribution. Orange Communications, Lausanne, Switzerland France Telecom's Orange Group cellular phone and Internet operator November 2,001 to February 2,003 Test Environments Administrator Application and System Administration • Amdocs Ensemble test environments installation, maintenance & upgrade on HP-UX 11i, Oracle 8i, MS Windows NT 2000. • System administration procedures' documentation, streamlining, formalisation & automation. Amdocs Brasil Ltda World's biggest telephony Customer Care & Billing system vendor September 1,998 to July 2,001 Infrastructure Support Oracle database administration • Oracle 7 & 8 installation, upgrade & configuration. • Database upgrade, maintenance & configuration at several clients and 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. • Population and use of data warehouse Business Objects schemas. Data extraction and interfaces • Data export, import & load for interface with various systems. • Semantics and funcionality research for data warehousing. Test environment 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 DBA procedures. International Experience • 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. • BCP Telecom, Brazil 2 months: DBA. • Global Telecom, Brazil 10 months: data warehousing. • Telet, Brazil 1 month: data warehousing. • Algar Telecom, Brazil 1 months: DBA. • Amdocs Support Centre, Brazil DBA, database reverse engineering and documentation. LG Electronics da Amazônia Ltda Korean consumer electronics and computing manufacturer October 1,996 to September 1,998 IT Assistant • Unix and MS Windows NT systems administration. • Oracle and MS SQL Server database administration. • Users and developers second line of support. • On-the-job training of support personnel. • Deployment of all administrative support IT systems for initial two and a half-year phase of the company's implementation in the country. Banco Itaú SA Second biggest private Brazilian bank January 1,994 to October 1,996 Systems Analyst • Clean-up, update and maintenance of mission-critical batch mainframe routines during massive increase in data volume. • Initiated and helped conduct planning and implementation of automated inter-banking cash transfers. • Operation and users support. Ecodata Com e Ind Ltda February to July 1,993 Commercial Assistant • Market study for small printers, data entry systems and network communications. • Maintenance services clients prospection. • Helped structure a national distributors network. Siemens SA February to November 1,991 Trainee • In various areas during fast-paced restructuring and cultural change. SKILLS Languages • English: fluent. • Portuguese: native. • Spanish: good reading, basic conversation. • French: advanced Systems Analysis and Administration • Essential Systems Analysis • Data Modeling • Relational Databases • Structured Programming Tools Corporate (Mainframes & Unix) Administration • Oracle 7 and 8i • Debian GNU/Linux 3.0 PowerPC, i386 • HP-UX 11i • Sun Solaris Enterprise 2.6 • GNU CVS • Samba, aka HP-UX CIFS/9000 Server • Amdocs Ensemble Programming • ISO SQL, IBM DB/2, Oracle 8i. • CA Easytrieve Plus • IBM VS COBOL II • Unix shell (Korn and Bash). Use • GNU Emacs • IBM MVS/ESA • IBM JCL • IBM TSO/E, ISPF & ISPF/Edit Personal Computers Administration • MS Windows NT Server 4.0 & 2000 TS • NCD WinCenter & Citrix WinFrame • MS SQL Server 6.5 Programming • Borland Turbo Pascal v4 • MS Visual Basic 3 Professional • MS Visual Basic for Applications • Shell & batch files Use • MS Windows 3.1 to 2.000 Professional • Apple Mac OS 8.1 to X • IBM OS/2 Warp 3.0 • MS-DOS 3 to 6.22, DR-DOS • MS Office 2000 • AppleWorks 6 Document processing • W3C HTML 4.01 & XHTML 1.0, CSS 2. • SGML & XML • LyX