Pl Sql Technical Skills
Resume:
Europass
Curriculum Vitae
Personal information
First name(s) / Surname(s) Rubens Costa
Address(es) Rua Tenente-General Zeferino Sequeira, 22 9 Fte
Portugal
Telephone(s) +351-*********
Fax(es)
E-mail adyurd@r.postjobfree.com
Nationality Portuguese
Date of birth May, 14 1975
Gender Male
Desired employment / BI Consultant / PL/SQL Developer
Occupational field
Work experience
Dates November 2013 – Present
Occupation or position held ETL Development Team Leader
Main activities and responsibilities Responsible for the following activities:
Design logical and physical models based on customer requirement documents
(Oracle DataModeler)
Define development planning
Source / Destination mapping
Software lifecycle and teams responsibility on each step
Develop Oracle objects needed to extract, transform and load data into
Datawarehouse (DW)
Reference Data maintenance
Define transversal processes to use in DW
Development of shell scripts to call oracle procedures, including logging and error
handling
Development of crone tab to manage DW processes
This project developed my technical skills in PL/SQL, SQL Developer, Oracle Data
Modeler, Oracle 11g, Shell Script, Unix, MsOffice.
Name and address of employer Affinity, Av. António Augusto de Aguiar, 5 5ºD, Lisbon, Portugal
Type of business or sector IT
Project Owner / Final Client Portugal Telecom
Dates June 2012 – November 2013
Occupation or position held Business Analyst, ETL Developer
Page 1/6 - Curriculum vitae of For more information on Europass go to http://europass.cedefop.europa.eu
Rubens Costa © European Union, 2004-2010 24082010
Main activities and responsibilities Participate actively building the solution design, modelling and concept definition in
transversal BI project for major Telecom Company in Portugal, integrating several
sources that include Customer, Billing Account and process, Portfolio information for
fixed line business.
BI Model definition support in Telecom business perspective
Functional requirement specification and definition
Development of business workshop material to be discussed with IT department and
final client. Development of ETL process
Participated on workshop to define source data interfaces and integration process
Development of functional and technical specification and other supplementary
documentation, including packages definition, procedures, views, table creation.
Participated in test phases (E2E and UAT) executing the correction of defects and
performance issues
This project developed my technical skills in PL/SQL, Oracle 11g, Shell Script, Unix,
Tortoise SVN, CCA Harvest, QC Quality Center, MsOffice, DataStage, MicroStrategy,
SAS.
Name and address of employer Integer Consulting, Av. 5 de Outubro, 67 4ºDto, Lisbon, Portugal
Type of business or sector IT
Project Owner / Final Client Portugal Telecom
Project Provider Maksen
Dates April 2012 – May 2012
Occupation or position held Siebel Consultant
Main activities and responsibilities Administration of CV Telecom Product Catalogue in PT Sistemas de Informação
project.
Maintenance of Reference Data.
Analysis of new requirements
Development of relevant documentation
This project developed my technical skills in Siebel 8, Siebel Tools.
Name and address of employer Olisipo, Av. 5 de Outubro, 67 4ºDto, Lisbon, Portugal
Type of business or sector IT
Project Owner / Final Client Green Cape Telecom
Project Provider Portugal Telecom – Sistemas de Informação (PTSI)
Dates January 2011 – January 2012
Occupation or position held Functional Analyst
Page 2/6 - Curriculum vitae of For more information on Europass go to http://europass.cedefop.europa.eu
Rubens Costa © European Union, 2004-2010 24082010
Main activities and responsibilities Product and Services functional analysis for Order Entry System with strong customer
relation skills
Configuration of specified services, through XML and application tools, including
complex product relationship (Package solutions)
Order Entry - CRM integration project
Order Entry - ConceptWave OrderCare (Order Management) integration project
Post go live support and war-room team leader
Development of relevant documentation
In this project i developed telco business knowledge and my technical skills in XML
structure, C# and SQL Server
Name and address of employer Integer, Av. 5 de Outubro, 67 4ºDto, Lisbon, Portugal
Type of business or sector IT
Project Owner / Final Client Portugal Telecom – PT Prime
Project Provider Indra
Dates October 2008 – October 2010
Occupation or position held Reference Data Manager
Main activities and responsibilities Definition, organization and installation of required Reference Data
Administration of Siebel Product Catalogue according Safaricom business needs
through implementation of integrity rules
Development of relevant documentation
Release control and execution
This project developed my technical skills in Siebel 8, Siebel Tools, MsAccess and
MsExcel (VBA) and PL/SQL
Between jun/09 and Sep/09 i worked in the client office in Nairobi
Name and address of employer Celfocus, Av. D. João II, Lote 1.03.2.3, Parque das Nações, Lisbon, Portugal
Type of business or sector IT
Project Owner / Final Client Safaricom
Project Provider Celfocus
Dates January 2008 – October 2008
Occupation or position held Billing Consultant
Main activities and responsibilities Analysis and development of:
- Billing system business requirements
- Agent commission system
- Corrective developments
- Application support (secondary systems made in PL/SQL)
ARBOR Kenan BP system configuration for rating, services and products.
Page 3/6 - Curriculum vitae of For more information on Europass go to http://europass.cedefop.europa.eu
Rubens Costa © European Union, 2004-2010 24082010
System test specification and execution
Development of relevant documentation
Release control and execution
This project developed my technical skills in Kenan BP 8.5, Unix, Windows, Shell
Script, Perl, ProC, Phyton, Homemade Order Manager, PL/SQL (Oracle 9i) and Java
Name and address of employer Celfocus, Av. D. João II, Lote 1.03.2.3, Parque das Nações, Lisbon, Portugal
Type of business or sector Telecommunications
Project Owner / Final Client ONI Communications
Dates June 2004 – January 2008
Occupation or position held Billing analyst-programmer – PTC project
Main activities and responsibilities Analysis and development of support applications for the Portugal Telecom billing
system, specifically and with great success:
- Electronic invoice automation
Corrective developments for the main billing system
Application support
Development of relevant documentation
This project developed my technical skills in MVSO, DB2, ORACLE 9i, PL/SQL, Oracle
Forms 6, MsAccess 2003 and VBA
Name and address of employer PT Sistemas de Informação - http://www.ptsi.pt
Type of business or sector IT
Dates February 2001 – June 2004
Occupation or position held Billing analyst-programmer – Marconi Project
Main activities and responsibilities Analysis and development of support applications for Marconi France and Marconi
Suisse billing system and support systems, made in PL/SQL and based on ORACLE
database
System tests development and execution
Corrective maintenance
Production support
Development of relevant documentation
This project developed my technical skills in ORACLE 8i, PL/SQL, MsAccess 2003 and
VBA.
Name and address of employer PT Sistemas de Informação - http://www.ptsi.pt
Type of business or sector IT
Education and training
Dates September 2008
Title of qualification awarded Advanced PL/SQL developer
Principal subjects/occupational PL/SQL Development
skills covered
Name and type of organisation ORACLE
providing education and training
Page 4/6 - Curriculum vitae of For more information on Europass go to http://europass.cedefop.europa.eu
Rubens Costa © European Union, 2004-2010 24082010
Dates February 1996 – February 1997
Title of qualification awarded Systems programmer
Principal subjects/occupational Programmer languages and system analysis skills
skills covered
Name and type of organisation Citeforma – http://www.citeforma.pt
providing education and training
Level in national or international Understanding Speaking Writing
classification
European level Spoken Spoken
Listening Reading
interaction production
English Proficient Proficient Proficient Proficient Proficient
C2 C2 C1 C1 C1
User User User User User
Spanish Independent Independent
B2 B2 A2 Basic User A2 Basic User A2 Basic User
User User Common European Framework of Reference for Languages
Social skills and competences Team work: I always worked in team, some larger than others, with complex
development interactions.
Mediating skills: I worked as project manager for small projects.
Intercultural Skills: I worked 3 month in Kenya
Organisational skills and I always worked in ISO and ITIL Certified companies where document organisation is
competences very important.
Computer skills and competences Program languages: PL/SQL, VBA, Java, VB6, ProC, C#, Shell script, Oracle forms
Database: Oracle, SQL Server, MsAccess, DB2
Operating systems: Windows, Unix, MVSO
Excellent with Microsoft Office tools, TOAD and SQL Navigator, Visio, Remedy, Siebel
eCommunications, and billing systems
Other skills and competences Runnig and TaeKwonDo Songahm practicing
Driving licence I am a holder of a Portuguese driving licence. Category A and B
Page 5/6 - Curriculum vitae of For more information on Europass go to http://europass.cedefop.europa.eu
Rubens Costa © European Union, 2004-2010 24082010
Page 6/6 - Curriculum vitae of For more information on Europass go to http://europass.cedefop.europa.eu
Rubens Costa © European Union, 2004-2010 24082010
Contact this candidate