Bruno Samuel Santos Lopes Email & Phone Number

State Of São Paulo, Brazil

São Paulo Area, Brazil

São Paulo E Região, Brasil

São Paulo, São Paulo

Migração de todo ambiente BI Oracle para Microsoft. Banco, Ferramentas de ETL, OLAP e Report.

São Paulo Area, Brazil

Business Intelligence Architecture design, modeling and development.

• Analysis and implementation (all phases) of the Financial and Property DMs;• Use of Georeferenced incorporating GoogleMaps with OBIEE;• Customization of the layout in the Interactive Dashboard, as well as integration with LDAP (AD) for authentication and authorization configuration in OBIEE;• Implementation of the Dynamic Dashboards OBIEE showing photos of properties;• Installation and configuration of OBIEE 11g and upgrade the design and adequacy of 10g to 11g (Oracle Fusion Middleware);• ELT from various data sources (Oracle and SQL Server database and Excel spreadsheets and text files) using ODI and Talend;• Main technologies used: SQL Server Database, Oracle Database 11g and 10, ODI, OBIEE (Oracle Business Intelligence Suite Enterprise Edition) and Talend.

• Integration of data from legacy systems with SEFAZ(in a public system of government of Brazil) using Talend ETL tool and Java frameworks for publishing mappings from the Talend as a Windows service;• Management reports with the BIRT tool;• Technical support for analysts and developers in the development and maintenance of Java J2EE systems;• Fixing bugs in legacy systems, Treads in java web systems, access to reports in crystal reports and also server configuration Jboss;• Analysis and development of multilayer systems Web, Web Services (using J2EE technology);• Training using BI tools Talend, Weka and Oracle database and MySQL for analysts, engineers and managers.

• Conceptual BI, ODI and OBIEE tools training for analysts, engineers and managers;• Technical analysis of the business environment on the client BI PRODESP involving DMs DETRAN, SERT, the Government Palace of Sao Paulo, among others;• Preparation of plan installation of Oracle BI tools;• Analysis and implementation (all phases) of the DW;• Using Georeferencing in OBIEE with GoogleMaps;• Structuring Tools Technical: Installation and configuration database and BI tools, advanced customizations such as: Creation / Modification of knowledge modules (KMS) in ODI; • Changing the layout in BIEE Interactive Dashboard and integration with BIEE Server other systems and tools by WebService.

• Analysis and development of the BI environment on the client CVC Turismo;• Analysis and implementation of technology standards for BI development environment;• Main technologies used: Oracle Database 10g, 11g OWB, OBIEE (Oracle Business Intelligence Suite Enterprise Edition), Talend, Java and. NET (3.5);• Load data from Web services, XML files and CSVs in Oracle database using the tool Talend Open Studio adjusting the generated Java script to be used by a web (J2EE). Generating XML files and CSVs from an Oracle database;• Multidimensional data analysis and development of complex reports in BIEE (Answers and Dashboards);• Installation and configuration tools OBIEE and OWB;• Implementation of the DW environment (ROLAP and MOLAP; ETL with Changed Data Capture, etc ... Slowly Changing Dimensions) by using OWB;• Customizing the layout of OBIEE;• Use the Web Service functionality of OBIEE by C# program;• OBIEE security integration with LDAP and log external table;• BIEE Integration with Google Maps, enabling the visualization of information on maps.

• Analysis and implementation of technology standards for the development environment of the organization's systems;• Technical support for analysts in the development of systems;• Analysis and development of multilayer systems Web, Web Services and Portals (Using Microsoft Technology);• Analysis and development of the BI environment (using Microsoft Technology);• Corrective maintenance and evolution of legacy systems (conventional and Power Builder ASP), integrating them with new systems;• Identification, analysis and development of IT services to automate internal processes;• Administration and technical support in IT projects;• Analysis and development at all stages of the WEB system 3 layers using .NET platform and database SQL Server and Sybase.

• Analysis and development of a system using ASP.NET technology and database-SQL Server;• Analyze and develop a system using ASP and database SQL-Server;• Datamart Development and ETL process optimization;• Correction and creating new models of load dimensions and facts in DW;• Analysis of multidimensional data to create new facts and dimensions in DW;• Analysis and implementation of new Cognos tools in Datamarts.

• Analyst development J2EE (JBoss container) and Oracle database;• Analysis, development and deployment of Datawarehouse in the State Department of Finance using of Oracle and SQL-Server databases and the Tools: OWB (Oracle), Data Transformation Services (DTS-SQL Server), Discoverer (Oracle), Business Objects (BO);• Analysis and development of system using the J2EE (JBoss container) and database-SQL Server;• Participation in the development team for the Integrated Management System using J2EE architecture (Server OC4J container) and Oracle database.

• Analysis and development of a web CRM system using J2EE architecture (JBoss container) and Firebird database;• Analysis, development and deployment of a CRM system using ASP language and IIS Server and MySQL database.

• Analysis and development of the intranet portal of the Superintendent of the INSS in Bahia / Brazil, containing automatic updating of data and news, using the programming language PHP (Apache) and MySQL and Oracle databases;• Analysis and development of a Web process control architecture using J2EE (OC4J container Server) and Oracle database;• Analysis and development of an internal system containing various information and control to service users and location of staff, using the programming language PHP and MySql database;• Analysis and development of an internal FAQ system, using the programming language PHP and MySql database.

• Development of a commercial cash management and inventory system using Delphi and Firebird database.

• Analysis and development of an intranet portal, containing automatic updating of data and news, using the programming language PHP (Apache) and database MySQL.

• Monitoring in computer services, development and support systems and network administration.

Specialist Of Database With Emphasis On Strategic Information, Ti

Bachelor Degree In Systems Analysis - Computer Science, Tecnologia Da Informação

Technical Degree In It, Ti