Years Experience Quality Assurance
Resume:
Kercyo Gentil
*, *********** **** ****, *** Laoghaire, Co. Dublin
Email: ******.******@*****.***
Contact Number: 089-***-****
Linkedin profile: http://www.linkedin.com/pub/kercyo-gentil/17/62b/894
Summary
4+ years in retail market / 4+ years in financial and banking market / 2+
years telecommunications market / 9+ years in legal market.
6+ years experience: Data warehouse, Business Intelligence and CRM /
Database Marketing, Data analyze, data mining, extract files, data model,
data segmentation, AD-HOC analysis/Queries and development OLAP reports to
support strategic decisions.
6+ years experience: development load data (ETL), monitoring, automation,
specification control and Data Quality through PL/SQL and Inform tica
PowerCenter.
6+ years experience: ETL and Database: Inform tica PowerCenter, Oracle
9i/10g, PL/SQL, UTL_FILE package, SQL Loader, development complex Stored
Procedures, Packages, Jobs, triggers, queries, DDL/DML and Microsoft
Access.
6+ years experience: modeling and programming: PL/SQL, PowerCenter, Scripts
UNIX/DOS, Database Architecture and Quality Assurance
2+ year experience: Microsoft SQL Server and Firebird.
6+ years experience: development Mailling's for marketing campaigns,
Measurement of campaign results, ROI, through control group.
6+ years experience: Technical support for clients and servers, network
development, setup Win Server/AD/DHCP/DNS/TCPIP/Linux Router, access
control, Backup DAT tape, support level I, II and III for servers and all
network clients.
Education
Post Graduate in Business Administration
FGV - Funda o Get lio Vargas - 2010/2011 - S o Paulo/Brazil
Graduate in Information Technology
UNIB - Universidade Ibirapuera - 2003/2006 - S o Paulo/Brazil
Experience
NET Services Cable TV
06/2011 - 02/2013
www.netcombo.com.br
Database Marketing Analyst Sr
. Responsible for the Data Quality Area and interactions with system
manager Addresses (GED).
. Restructuring the load data models and specification development
. data load (ETL) process automation, documentation, controls and loads
online panels.
. Targeting public and generate mailings for marketing/CRM campaigns,
data segmentation, targeting and extraction of data for outbound
marketing activities and integrated systems (SOA).
. Development AD-HOC/Scheduled analysis and Queries.
. Validation and Quality Assurance (QA) of campaigns and work done in
the area.
. Measurement of campaign results for monetization/sales area
Carrefour Bank Finances Solutions
07/07 - 06/11
www.carrefoursoucoes.com.br
Business Intelligence Specialist PL
. Participation in the planning of Direct Marketing campaigns of retail
and bank.
. Data Mining and data segmentation, targeting and extraction of data
for outbound marketing and CRM activities, Mailling's and extract text
files.
. Development of Behavioral Studies, using rules of relationship and
statistical modeling.
. Development of OLAP reports to support strategic decisions and AD-
HOC/Scheduled analysis and Queries.
. Measurement of campaign results using the Control Group.
. Specification and development of data load (ETL) process automation,
documentation and load control using Oracle PL/SQL and Informatica.
. Responsible process of developing ETL Migration (development, tests,
migration to environment production, documentation and scheduling)
from Oracle Procedures/Packages/SQL loaders to Informatica. Over 50
ETL process migrated in different scenarios, file types and schedules.
Lodovico e Costa Lawyers Associated
07/98 - 07/07
www.lodovicoadvogados.adv.br
Administrative / I.T Coordinator
. Development of management reports, contact and negotiate with
costumers and other relevant administrative activities.
. Responsible for cash flow, billing, collection and other financial
routines.
. Extract information and management reports by query direct from
database Firebird, Microsoft SQL Server 2000 and Oracle 10g through
PL/SQL (Oracle) or Query analyser (SQL Server) presenting on Pivot
table and OLAP cube by Excel.
. Development of IT infrastructure, Technical support for clients and
servers, Hardware maintenance and replacement (Motherboard, HD, and
others components), installing Win Server/AD/DHCP/DNS/TCP/IP/Linux
Router (Coyote Linux), access control, Backup DAT tape, support level
I, II and III for all network clients.
. Projects to reduce costs.
. Research and implementation of ERP system (SISJURI) Company BCS Info
by TOTVS group.
. Team Leader of administrative office.
Main tools used
. Oracle 9i/10g and PL/SQL: Queries DDL/DML / Procedures/Packages /
Views / Functions / Jobs / Etc.
. MS SQL Server and Firebird
. Inform tica PowerCenter 8: Map/Maplet/WorkFlow/Worklet/Monitor/Task
. Scripts: DOS And Unix Scripts
. MS Excel: OLAP Pivot Table/VBA/Function/Grafic/Macro/Report
. MS Access, MS Project, MS Visio, MS DOS, Lotus Notes, Ultra Edit, Toad
Courses
. Inform tica Power Center 8 Developer Training - Softtek - S o
Paulo/Brazil
. Access 2000 Advanced - Ka Solution - S o Paulo/Brazil
. DBA OCP Oracle 10g Preparation for certification - En-Sof - S o
Paulo/Brazil
. MS SQL Server 2000 - Impacta - S o Paulo/Brazil
. SAS Base Programming / Data Integration Studio / Guide / Customer
Intelligence - SAS - S o Paulo/Brazil
. General English - Active Language - Dublin/Ireland
Voluntary Works
Workshop: Database in practice - Practice Areas and opportunities.
Local presentation: ETEC - Technical School Institute Paula Souza.
Audience: 140 students of technical IT Date: 26/04/2012 and 17/05/2012
Presentation of Workshop on Database Technical School in public for first
year students of technical IT courses
Main topics covered:
. What is it and how work a database / Departments of companies using
database / Opportunities, top careers and salaries.
References
. NET Services Cable TV: Manager: Mr. Marco Aur lio Barbosa:
*****.*******@***********.***.**
. Carrefour Bank Finances Solutions: Manager: Mr. Marcos Carlos dos
Santos: ************************@*********.***
. Lodovico e Costa Lawyers Associated: Owner: Dr. Humberto Antonio
Lodovico: *********@****************.***.**
Contact this candidate