Management Oracle

Andrade, Fabio Junio

Summary

Currently Technical Lead & SalesForce.com Architect at Roche Pharmaceutical in

Brazil. In the past senior IT Specialist in a wide variety of international and local

companies. Strong background as Logical and Physical ORACLE DBA, SQL Server

and DB2. Experienced over management, design and implementation end to end

solution. Also System Analyst emphasizing software engineering technical

publication systems, operations software over than 10 years of customer support

requires dedicated studies, so as to obtain brilliant results.

: 15+ years exp handle different kind of technology

Total Experience

components such SFDC, Siebel, Windows, UNIX, ORACLE, SQL

Server, DB2, ETL Power Center and BI.

: IBM/PC compatibles.

Hardware

: Linux/AIX/HP-UX/Solaris, Microsoft WinX Servers.

O. S.

: JCL, PL/SQL, Visual C++, Visual BASIC, .sh, .ksh, Visual

Languages

Page, Appexchange

: Oracle, SQL Server and DB2

Database

: Force.com, .Net

Plataform

: UML, Relational Databases, Object Oriented Design,

Design

Software QA;

: J2EE, EJB, JDBC, JSP, JSTL, Struts/Tiles, Servlets,

Java

Weblogic, WebSphere;

: Force.com, VisualForce, Appexchange, Apex Triggers, Service

SFDC

Cloud, Jason, ETL Integration

Page 1 of 12

Significant Projects and Companies

2007, May – till date) – based in Brazil

Roche Pharmaceuticals

Current Role: LATAM SFDC Platform Architect

Take parts in the Global ROCHE SFDC Platform Governance board actively

contributing in the setting of Platform;

Best Practices and Rules;

Coordinate execution of OLA LATAM Region has with PaaS Team in areas

like:

o Vendor Management - issues to SFDC;

o SSO and Security Management;

o Environments setup and maintenance;

o Deployments process;

o Performance & Monitoring;

o Backup & Restore;

Propagate SalesForce.com Technology & Cloud Computing Innovation for

Commercial Operations purpose focused in CRM, Digital Marketing and

Apps;

Owns and develop SFDC Platform roadmap for LATAM;

Ensures code base re-usability, simplification and optimization along with

the SFDC Interfaces in LATAM Region

Lead Technical Risk Analysis for new releases;

Previous Role 1: LATAM Technical Lead

Lead of design and implementation of technology solutions that optimally

support for CRM business;

Process and software integrated such as etl/tibco, sap, agnitio & others

pharmaceutical legacy systems;

Support and Development:

Page 2 of 12

Applies complex procedures and defined standards to meet current

business, customer and technical requirements and leads others in

resolution of complex problems;

Innovates and optimizes processes and methods within the domain to meet

system or user requirements and develop new functionality;

As part of dedicated project and part of a project team lead by a project

manager, plans and implements processes where required, and provides

technical leadership to the team, including offshore vendors and partners;

Leads specialist resources on technical issues within the domain on content

and provides detailed analysis of the operations and opportunities for

improvement;

Previous Role 2: Global Informatics Service & Solution Management

Infrastructure Services Planning & Delivery;

Overall responsibility of the Global Informatics Infrastructure Service &

Solution Management area for Roche Pharmaceuticals Commercial

Operations and Roche Diagnostics in the LATAM Region;

Provide IT Services to develop Roche affiliates sales in LATAM (> 2000

users Siebel-based CRM, > 700 Roche websites, Marketing Tools, Business

Intelligence & In field Execution applications (Sales Measuring, Monitoring

and Automation).

Previous Role 3: Senior DBA – Global Team and Service Manager Latin America SPOC

Tecnologies: Oracle / SQL Server (more than 200 instances and more than 1000

databases)

Provide technical support and maintain consistent configuration, implementation,

operation and support of:

Database Services (DBS) operations, monitoring & problem resolution;

Configuring and managing development, UAT and production database

environments;

Database administration and maintenance support services;

Page 3 of 12

Database configuration, implementation and optimization;

Capacity and performance tuning; [

Security coordination, testing and administration;

Service level and QA compliance;

Ensures ITSM framework, CPE processes, tools and SOP’s are

implemented, utilized and supported end to end;

Ensures CPE Guiding Principals are fully understood and practiced;

ITIL best practices;

IBM BRAZIL

PROJETC NAME: DACMT - DELIVERY ASSET & CONFIGURATION MANAGEMENT TOOL

: IBM, BRAZIL.

CLIENT

: 2004, Nov – 2007, May

Duration/Size

Role : Logic DBA - Design & Implementation of Relational Models –

ORACLE and DB2 UDB

Environment : Oracle 10g, Oracle9ias, SunSolaris, Apache

WebServer/Tomcat, PHP/JAVA (J2EE), Tivoli. RUP (UML),

Description :

DACMT is a system to manage, control, and protect an organization's software

assets, including management of the risks arising from the use of those software

assets. Basically, is the entire infrastructure and processes necessary for the

effective management, control and protection of the software assets within an

organization, throughout all stages of their lifecycle.

Responsibilities :

Logical and Physical DBA - Design & Implementation of Relational Models and

Data & Database Administrator (Oracle, Rational Rose) / RUP(UML) and JAVA

System Analyst

Administration of the Oracle10gi databases, Oracle9i Application Server,

Oracle9iAS Portal and WebDB on Sun Solaris 9/7 platform (Sun Ultra 5/10,

V250), including performance tuning, user management, security and

backup strategy development, shell script writing to automate

administrative functions.

Page 4 of 12

Technical support and maintenance of the consumer information system for

grant management. The system is based on Oracle8i and Oracle9iAS

Portal.

Development and implementation of the information system for grant

management, including database design (using Oracle Designer 6i),

PL/SQL coding, development and testing of complicated modules, forms

and reports. The system based on Oracle8i, Oracle 9iAS Portal.

Resume:

I helped optimize the system, for example making the XML/XSLT

transforms 100 times faster from Tomcat and Apache, and made the database

calls to an DB2 and Oracle database over 200 times faster using PL/SQL. I

converted a lot of code from PHP to Java, in order to create a pure Java solution,

using Struts and Tiles. Used Lucene to create a Swing Application for code base

mapping. I also introduced many tools to the organization that made work more

productive for the other developers, and spent a lot of time in a mentoring role.

*Running on SUSE Linux and Windows.

PROJECT NAME: SEPE (SYSTEM ELECTRONIC EMB PUBLICATION)

: EMBRAER (GLOBAL AEROSPACE COMPANY, BRAZIL).

CLIENT

: 2003, June – 2004, Nov

Duration/Size

: Analyst Developer

Role

Environment: PL/SQL, Oracle, SQL Server, DFC JAVA(JBuilder) / VB,, RUP

(UML)

Description:

SEPE is a system for maintaining and management the fragments customized of

each technical publication for each customer, such as, release date, reviews,

effect, start review, end review, scenes, publications and distributions worldwide.

To design and develop to completion a new client facing internet XML Business

Messaging Service to handle incoming business requests and outgoing progress

reports between SEPE and major clients. The system received, managed and

routed messages in an Origo XML format. A composite object model was

persisted to a relational database. A web front end was created to manage and

monitor this information and errors were monitored and could fixed and

resubmitted

Responsibilities :

Page 5 of 12

Oracle Applications Database Administrator

Operating System: Sun Solaris 8 and Windows 2000 Server

Upgraded 8.0.5 database to 8.1.7 and implemented sever partitioning with

8.0.6 to enable Oracle Applications 11.0.3 to work with 8.1.7.

Apply database and applications patches

Create test web servers, web listeners, form servers, concurrent managers,

and databases from the production environment for 11.0.3.

Troubleshoot problems with web server, web listener, forms server,

concurrent managers, and database on 11.0.3.

Make changes to standard Oracle Applications forms and reports using

Designer/Developer for testing purposes as advised by Oracle Support.

Upgrade from 11.0.3 to 11i.

Upgraded 8.0.5 database to 8.1.7 and implemented sever partitioning with

8.0.6 to enable Oracle Applications 11.0.3 to work with 8.1.7.

Create custom concurrent requests to perform database maintenance.

Write Korn shell scripts to monitor and maintain the Oracle Applications

database.

Write SQL scripts to monitor tablespace and extent growth.Developer

Leader team.

Resources Management Planning and Control Worksheets;

New IT technologies focal point ORACLE focused;

PROJECT NAME: ACMCP (ACTIVITY CONTROL AND MANAGEMENT CUSTOMER

PRODUCTS)

: EMBRAER (GLOBAL AEROSPACE COMPANY, BRAZIL).

CLIENT

: Sep, 1999 – May, 2003

Duration/Size

: Analyst Developer / Tester

Role

: Oracle 8, Windows NT, PL/SQL

Environment

Description :

ACMCP system responsible for consults and storing all parts of EMBRAER

aircrafts.

Page 6 of 12

ACMCP is the repository for maintaining the pieces such as: wings, fuselage,

security and safety systems, flaps angle, and others. Nowadays almost

employers that work in pipeline are uses this system.

Projects’ auditing - Modify and programs improvement for some features that

already existent.

Parts System - Production support problem analysis and resolution for the

Parts/Distribution, and aircraft applications software, which included a several

interfaces modules.

Responsibilities:

Oracle Database Administrator

Oracle 8.0.4 DBA (for Windows NT 4.0) Responsible for database

installation, configuration, version upgrades, backup, recovery,

performance tuning, user administration

Database design and Windows NT 4.0 Domain administration.

Responsible for server installation, configuration, backup, recovery,

and user administration.

PROJECT NAME: FFAS - FULL FINANCIAL APPLICATION SYSTEM

CLIENT : FUNCATE – FOUNDATION FOR SPACE RESEARCH, APPLICATIONS AND

TECHNOLOGY - BRAZIL

: July 1996 – Aug 1999

Duration/Size

: Analyst Software Developer / Tester

Role

: PL/SQL, ORACLE8i, COBOL, AIX, OFA

Environment

Description :

FFAS system responsible for all financial applications and storing step by step of

all purchasing process Accounts Payable, and Plant Data Collection applications

and approval sheets.

Ps.: Major development efforts included rewrites.

Responsibilities :

Support approximately 100 users on Oracle Financials 11.0.3.

Apply application patches.

Page 7 of 12

Create and maintain custom responsibilities and menus.

Installation of Web applications server, Oracle Applications server and

Oracle Forms server. Configuration of DAD, WAS cartridges.

Migrated 4 instances from MVS OS/390 to IBM AIX RS/6000.

Set up to share APPL_TOPs over different instances

Move all custom programs and reports to production. This involves

enforcing naming standards, maintaining the custom application top, and

setting up concurrent requests.

Make changes to standard Oracle Applications forms and reports using

Designer/Developer for testing purposes as advised by Oracle Support.

Troubleshoot problems with web server, web listener, forms server, and

concurrent managers, and database.

Create test web server, web listeners, form servers, concurrent managers,

and databases from the production environment.

Create tablespaces, tables, and users for custom applications.

Maintain user security.

Maintain Oracle schemas and SGA region.

Assist Programmers and Developers with Oracle problems.

Write Korn shell scripts to monitor and maintain the Oracle Applications

database.

Write SQL scripts to monitor tablespace and extent growth.

Perform analysis, coding, maintenance, and testing of applications using

COBOL, CICS, ODE, MSA Information Expert, and JCL.

Support GEAC Financials and GEAC Payroll applications.

Answer users' questions on an ongoing basis.

Resolve various application failures due to data entry errors or system

errors. Involves identifying problems and implementing corrective actions.

Write COBOL programs to convert legacy data to an Oracle Applications

database.

Write SQL*Loader control files for uploading legacy data to interface tables.

Page 8 of 12

Education

Bachelor: Computer Science from Vale do Paraíba University – 1998 - 2002

Processing Data Computer from Industrial College Technical – 1995 -

1997

Technical Training

Sales Force.com Admin – Cloud2be – Sao Paulo - 16h

Virtual Machine – ESX VMare – Triple S – São Paulo – 40h

Siebel Administrator – Captani / São Paulo – 104h

DBA10gI Oracle RAC – MADRID – Espanha – 40h

OR10g–Oracle Database10g: SQL Ed 2– São Paulo–BR – 40h

OR10g – Oracle Database10g: Program PL/SQL– São Paulo–BR – 40h

DBA10gI Oracle Database10g – Administration I– São Paulo–BR – 40h

DBA10gI Oracle Database10g – Administration II – São Paulo–BR – 40h

Negotiation Skills – FGV – São Paulo – 28h

SGML/XML DTD Implementation - Arbortext – Ann Arbor, MI - USA;

Techniques for DTD Maintenance - Arbortext – Ann Arbor, MI - USA ;

ACL Design and Implementation - Arbortext – Ann Arbor, MI - USA ;

PL/I Programming Language at IBM – Hortolândia-SP

SLD – Security Logical Data – (CICS/MVS)

Borland Delphi Development

Legacy Documentum Technology (JAVA, OminiMark, Visual Basic 6)

Training Unix Aix 5.3 at IBM

Page 9 of 12

Project related and other Training:

Marketing Farmaceutico – IPOG – São Paulo – 12h

ITIL Foundation – São Paulo –BR-40h

Take care you Customer

Growing as Leadership

Presentation Skills

Language Proficiency

Ability Expectations Englis

Portug Spanis

h

uese h

Ability for overseas

Fluent

X

assignment

Advance Able to take an overseas X

X

d business trip unaccompanied

Read and Write ability with

Interme limited verbal skill (able to

diate take an overseas business trip

with an assistant).

Able to communicate with

Basic people from other countries

at a minimum level

Other Information

Award :

Received US$ premium through “good idea” project and successfully completing

automation project as analyst and developer in operational technical publications

at EMBRAER.

Page 10 of 12

International Experience:

Latam SFDC Architect Platform – (2014, Ago)

• Warsaw, Poland;

• Basel, Switzerland;

• San Francisco, US;

Latam CRM Technical Lead – (2012, Ago)

• Warsaw, Poland;

• San Francisco, US;

Global Service Manager Team – (2011, Jul)

• Basel, Switzerland;

• Freiburg, Germany;

• Strasbourg, France;

ROCHE Sales Forces Representative Forum;

• Buenos Aires, Argentina;

Global Database Team Meeting & Integration and ORACLE10g RAC Training

o Location: Madrid, SPN and Lisbon, PT (2007, Oct);

Business trip and professional presentation about new aircraft and

operational software with a potential customer

o Location : Fort Lauderdale, USA (2003, Dec) ;

Visit to authorities of Brazilian Air Force at Consulate to provide maintain

and improves on the database.

o Location: Buenos Aires, AR (Jan and Jun, 2004);

Availability for Travel : Yes ( X ) No Page 11 of 12

Personal Information

General : Brazilian, Engaged, 35 years old;

Mobile Number / email : +55-11-984**-****/********@*****.***.**

Visa : US B1/B2 – valid till 2022.

Page 12 of 12

Contact this candidate