Post Job Free
Sign in

Database Developer

Location:
Toronto, ON, Canada
Posted:
February 08, 2017

Contact this candidate

Resume:

OBJECTIVE

To obtain a position in I.T where I can help the organization grow in value utilizing my experience, capabilities, and abilities.

PROFESSIONAL QUALIFICATION

●Full master in ORACLE (Tuning and PL/SQL), SQL Server(T-SQL, Tuning, SSIS, SSAS, SSRS);

●Analysis and development of improvements in scripts (and data objects), backup and recovery of database;

●Team Leader, proactive worker, passionate about challenges, problems solver, technical support experience;

●Years of experience in Unix, Shell Scripting, ETL Process, OLAP and OLTP;

●Certified Scrum Master, ORACLE OCP – PL SQL Developer, and ORACLE OCA - 11g Administration;

SKILLS

Languages: Oracle PL/SQL, SQL, T-SQL, HTML, PHP, JAVA, CSS, JavaScript.

Databases: Oracle, MS SQL Server, MySQL, PostgreSQL.

Applications: SQL*Plus, PL/SQL Developer, Toad for Oracle, CA ERWin, Oracle Developer Data Modeler, Microsoft SQL Management Studio, MS Report Service, MS Integration Service, MS Analysis Service, Pentaho, MS Office.

Source Control Systems: SVN, Subversion, TFS, Tortoise SVN.

Operation Systems: Windows, Linux.

WORK EXPERIENCE

North Shore Marketing Solutions – Toronto – Canada Oct/2016 – Dec/2016

Northshore is known for providing TOP Results in the fields of Business Consulting and Business Solutions.

Website: www.northshoresolutions.ca

Account Manager

Promote and sell products and services offered by Rogers including Residential Solutions, Security / Business and Home Automation, and Wireless Solutions.

Analysis of the products already purchased by the customer and proposal of better options with a better price.

Capgemini – São Paulo – Brazil Sep/2010 – Aug/2016

With more than 180,000 people in over 40 countries, Capgemini is a global leader in consulting, technology and outsourcing services.

Website: www.br.capgemini.com

I worked at Capgemini for 6 years, where I had a great career and the opportunity to work with different technologies and job positions. Furthermore, I had an opportunity to develop an accurate knowledge of business also working on many different projects.

System Analyst- Database Developer

Analyze scripts, data, development/improvement of procedures and functions.

Built several SQL in Oracle and MS SQL Server to manipulate files data and output text files (txt, csv, Excel, DBf, mdb).

Built several queries (SQL) to evaluate the Data Quality.

Performed the Data Modeling of Relational and Dimensional database.

Controlling of database objects, backup and database recovery.

Business Intelligence (OLAP), data mart and data warehouse.

Built ETL process.

Focus on the resolution of the problem in the code and with data.

Developed stored procedures, functions, triggers, packages using DBMS Oracle and MS SQL Server.

Technologies Used: PL/SQL, SQL, T-SQL, Microsoft SQL Server, ETL, Oracle Database, Unix, Shell Script, CA Erwin, MS SQL Management Studio, SSRS, SSIS, SSAS, TFS, Excel, Access.

Marketdata – São Paulo – Brazil Feb/2010 – Set/2010

Marketdata is a data-driven marketing services company, recognized by the know-how in Database Marketing, CRM, Analytics, and Data-driven Communications solutions.

Website: www.marketdata.com.br

System Analyst- Database Developer

Development of DBM (Database Marketing), documentation of processes from the database and UML. Analysis and extraction of existing public using QlikView for BI reports.

Extraction activities and analysis of existing public.

Built several SQL to manipulate files data and output text files (txt, csv, Excel, DBf, mdb).

Built several queries (SQL) to evaluate the Data Quality.

Technologies Used: Microsoft SQL Server, ETL, CA Erwin, MS SQL Management Studio, SSRS, SSIS, QlikView.

IBM – São Paulo – Brazil May/2009 – Jan/2010

International Business Machines Corporation (commonly referred to as IBM) is an American multinational technology company, with operations in over 170 countries. IBM manufactures and markets computer hardware, middleware and software, and offers hosting and consulting services in areas ranging from mainframe computers to nanotechnology.

Website: www.ibm.com

System Analyst

Develop applications and processes (corrective and evolutionary) in the system TronWeb Customer MAPFRE.

Develop applications and processes (corrective and evolutionary) in the system META Customer LATAM.

Technologies Used: Java and Oracle (PL/SQL).

LATAM - The Company is currently the largest Brazilian airline by market share and fleet size.

MAPFRE - It is the leading insurance company in Spain and the largest non-life insurance company in Latin America.

Mapfre – São Paulo – Brazil Nov/2008 – May/2009

It is the leading insurance company in Spain and the largest non-life insurance company in Latin America.

Website: www.mapfre.com.br

System Analyst

Promote developments (PL/SQL) and keep order in the system TronWeb, analyzing data integrity and processes in insurance policy.

Technologies Used: Oracle (PL/SQL), Unix, Shell Script.

EDUCATION

Bachelor in Management of Information Technology

Ibirapuera University – Aug/2009

Technician Degree in Technical Software Development

Unibratec University – Dec/2004

CERTIFICATES

Oracle Certified Professional - OCP Oracle Advanced PL/SQL Developer;

Oracle Certified Associate – OCA Oracle Database 11g Administrator;

Scrum.Org – Scrum Master;



Contact this candidate