Post Job Free

Resume

Sign in

Years Experience Quality Assurance

Location:
Ireland
Posted:
April 24, 2014

Contact this candidate

Resume:

Kercyo Gentil

*, *********** **** ****, *** Laoghaire, Co. Dublin

Email: acdt94@r.postjobfree.com

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:

acdt94@r.postjobfree.com

. Carrefour Bank Finances Solutions: Manager: Mr. Marcos Carlos dos

Santos: acdt94@r.postjobfree.com

. Lodovico e Costa Lawyers Associated: Owner: Dr. Humberto Antonio

Lodovico: acdt94@r.postjobfree.com



Contact this candidate