Post Job Free

Resume

Sign in

Data Warehouse

Location:
United States
Salary:
55000+ per year
Posted:
June 30, 2015

Contact this candidate

Resume:

Bruno Vieira Battistini

*** * **** ******

New York City - NY

United States

10128

acqill@r.postjobfree.com

Skype: keitaro_c4

646-***-****

www.genexis.com

SUMMARY

Born July 26th 1986 in São Bernardo do Campo - SP - Brazil.

Fluent in English language.

Basic knowledge of Spanish, Japanese and Italian languages.

Interested in discovering and further improving new IT knowledge in the fields of programming with SQL, Data Warehousing/Marting and ETL Modelling processes.

Highly experienced in thinking of new solutions and methods to achieve the goals desired by the company. Trustworthy employee that is there for the company whenever needed.

Easy learner of new technologies, motivated by new challenges and to learn.

Availability to move outside Brazil. Have B1/B2 US Visa until 2022

EXPERIENCE

Database Developer and Programmer - Genexis Informações para Negócios LTDA

São Paulo, São Paulo, Brazil --- 2006-2015

Company focused in gathering retail market information (Sell-Out) from Wholesalers, processing it and generating Reports to Manufacturers which are published through Qlikview over the Web. Using a self-developed ETL Tool the information is stored in SQL Database which is then processed into a Data Warehouse and further on to a Data Mart, which is the source for the Reports. Our Clients include Reckitt Benckiser, Unilever, Danone, Hypermarcas, Hersheys, Pandurata, Diageo, Pernod Ricard, P&G, and others.

Experience in optimizing processes (Stored Procedures specially), modeling database solutions, including the design of Data Warehouses and Data Mart,mostly through Star Schema, and the associated processes, implementing them over an SQL Server.

Experience in analyzing data for reports and information retrieval according to client’s briefing.

Experience in Developing Incentive campaigns for sales improvement and companies KPIs, modeling the respective Databases and processes to achieve the level of information desired for publishing.

Experience in logical line of thinking and bringing up possible solutions for client’s briefing scenario.

Company also manages E-commerce between Pharmaceutical companies in Portugal like Sanofi Aventis, Jaba, Novartis, DLA and others, and prior to that Pfizer, Biolab, Achè, GSK, J&J.

Experience in developing business rules to attend client’s briefing regarding commercial transactions.

Experience in developing procedures and modeling of databases for integration with C# web sites or other platforms according to the company technologies.

Accomplishments

●Advanced T-SQL programming skills

●Intermediate SSIS

●Intermediate SASS

●Advanced Development of Stored procedures and processes

●Process optimization

●Data Warehouse modeling

●Data Mart Modeling

●Knowledge in improving database performance to match users expectations

●Programming in C like languages (C#, C++)

●Programming in Python

●Basic SAS

●Intermediate JavaScript knowledge

●Basic JQuery knowledge

●Basic PostgreSQL knowledge

●Intermediate Qlikview skill

●Average knowledge in Windows/Unix platform

●Developed several incentive campaigns for companies like Reckitt Benckiser, Unilever, Danone.

●Developed Producer/Consumer Design Pattern application for ETL using Python and SQL Database

●Developed a variety of business rules on SQL for companies commercial transactions on E-commerce

●Developed ABC curve and VMI processes on SQL

●SQL process optimization and Modeling improvement for FEMSA’s Data Mart and Data Warehouse

●Average knowledge in Oracle Data Integrator (ODI)

●Deployed Emptor-Commerce platform at IMS Health over a period of 6 months and provided support for new requests, new functionalities and troubleshooting.

EDUCATION

Faculdade de Engenharia Celso Daniel - Fundação Santo André

Computer Engineering - Emphasis in Software - 2005-2009

5 year course emphasizing in Computer and Software Architecture, Database Administration and Programming, Calculus and Analytical Mathematics, Programming Logic and Practice. Graduating Thesis on Human Interaction with computing systems through use of webcams and gestures.

SKILLS

●Calculus and Physics

●Java Language

●Advanced SQL Language

●Advanced Data Warehouse Modeling

●Advanced Data Mart Modeling

●Qlikview Developement

●Basic SAS

●Programming Logic and Algorithms

●Computer Architecture

●Data Structure

●Chemistry

●English

●Artificial Intelligence

●Network protocols

●Fluent English (CAE Certificate Number 001*******)

●Fluent Portuguese

●Basic Japanese (Noryokko Shikken Level 4)

●Basic Italian (CILS Level A1)

●Basic Spanish



Contact this candidate