Oracle Developer

Alexandre Aragão Pinto dos Santos

Macaxas Street, 130, ap 46

São Paulo, SP, 04282-000 – Brazil Mobile: +55-11-971******

Linkedin: linkedin.com/in/alexandre-aragão-a83a6b12/ Email: *********@*****.***

PROFESSIONAL SUMMARY

Experienced and motivated Oracle/JAVA Developer with 14 years of experience working for the biggest insurance and financial companies in Brazil. Committed and pro-active to find the best solutions for any kind of situation.

SKILLS AND ABILITIES

More than 14 years of full time Oracle Development (PL/SQL, Forms and Reports).

More than 4 year of experience working with MySQL and SQL Server .

More than 2 years of experience working with Java (SpringMVC, JPA+Hibernate, WS-SOAP and REST, Jboss, tomcat, OC4J and more).

Lot of experience working with massive data (insurance companies and billing companies) and high availability.

Superior multi-tasking skills, and work well under deadlines and pressure.

WORK EXPERIENCE

Tokio Marine Seguros S.A., 01/2013 – present

Oracle/Java analyst

Responsable for all physical and digital documents created and sent to our customers and brokers.

Developed PL/SQL batch process calling REST WS to create PDF documents in CSF tool, sending e-mails and files to multiple printcenters.

Tunning of oracle printing batch process, getting 70% of improvement of performace.

Developed services and interfaces for credit card process with CIELO and payment registration using webservices and SSH.

Kiman Solutions Ltda, 03/2012 – 01/2013

Oracle system analyst

Responsable for all physical and digital documents created and sent to our customers and brokers.

Developed PL/SQL batch process calling REST WS to create PDF documents in CSF tool, sending e-mails and files to multiple printcenters.

Tunning of oracle printing batch process, getting 70% of improvement of performace.

Developed services and interfaces for credit card process with CIELO and payment registration using webservices and SSH.

Elucid Solutions Ltda, 07/2010 – 03/2012

Oracle system analyst

Responsable for all physical and digital documents created and sent to our customers and brokers.

Responsible for the development of interface processes between energy companies and distributors with the governmental organization (SEFAZ) in the generation of “SPED Fiscal” and SPED PIS / COFINS. Development and maintenance of billing and accounting processes for invoices of the entire Rede Energia, Copel, Elektro and others group.

Creation of technical documentation for analysis and development of customer solutions based on a design plan created by the company's product áreas.

Support the client team to develop processes for validation and tunning.

Kiman Solutions Ltda, 12/2008 – 06/2010

Oracle system analyst

Main projects and achievements:

Responsible for the development of interface processes between proprietary life and pension system for satellite systems of Sulamérica, Safra, Mapfre, Real / Santander and Caixa Vida e Previdência.

Customer team support for process development for process validation and tunning.

Development of various interfaces between KIPREV data, Kiman's pension system, and legacy systems.

Implantation of life and pension insurance module for the Real Tokio Marine Vida e Previdência acting as intermediary between customer and supplier of the kiprev system.

Migration of certificates and policies from Mainframe to Oracle 10g.

Allianz Seguros S.A, 03/2004 – 12/2008

Oracle system analyst

Main projects and achievements:

4 years and a half in Opus project, core policy management system in Oracle Forms and Oracle PL / SQL, working on the maintenance and development of new modules and products using agile / XP methodology.

Outstanding performance in the ERP migration project purchased for an internally developed system, involving data migration and proposal management modules, policies, commissions, clients and printing.

Implantation of eight new insurance products in the platform mentioned above, among them: Forest, agricultural, RCTRVI and automobile. A module was developed for proposal generation, policy issuance and endorsements.

Development and implementation of the collection module for preliminary surveys and provisional coverage in Oracle 10g.

Solid knowledge in insurance of the most varied products, such as: Automobile, Forestry, residence, condominium, company and great risks.

Experience with cascading model development for the ERP migration project, due to the project's criticality. After migration, Agile / XP methodology was used to develop and maintain the processes.

EDUCATION

DATA PROCESSING TECHNOLOGY, FIAP - 2000 – 2003.

ECONOMICS, Universidade Presbiteriana Mackenzie, 2009 – 2012.

SPECIALIZED TRAINING

1Z0 051-ENU: Oracle Database 11g: SQL Fundamentals

1Z0 144-ENU: Oracle Database 11g: Program with PL/SQL

1Z0 146-ENU: Oracle Database 11g: Advanced PL/SQL

ASP.net – Bras & Figueiredo

ADO.net – Bras & Figueiredo

Webservices - Bras & Figueiredo

Contact this candidate