Lucas Bianchi

Senior Oracle Retail Consultant @ Wipro

About

BI Consultant (ETL/DW) with 13+ years' experience. Knowledge in all project steps such as requirements and metrics gathering, impact analysis, estimations, documentation, development, deployment, delivery and support. Oracle Retail Consultant (BI, Integration) with 6+ years' experience. Implementation and customization in ORMA module, and knowledge in ORMS, ORFM modules. Clients - Retail: Lojas Renner (BR), Makro (Latin America, BR), Pepco (Europe, PL) - Finance: GetNet (BR) - Broadcast: RBS Group (BR) Areas of Expertise - Retail - Data Migration - Data Warehouse & Business Intelligence - Integration ETL / Integration: - OIC (Oracle Integration Cloud) - ODI (Oracle Data Integrator) - Pentaho - DataStage - PowerCenter Informatica - SSIS (SQL Server Integration Services) Database: - Oracle 11g - Oracle 12c - Exadata - MySql - Microsoft SQL Server Oracle Retail - ORMA - ORMS - ORFM - ORDW - RIB - RSB - MFCS - OIC - RI Programming: - PL/SQL - Python

Country

Brazil

City

Gravataí

Industry

Information Technology & Services

Skill

ETL (Extração, transformação e carregamento), ODI, Oracle PL/SQL Development, Oracle, SQL, Microsoft SQL Server, Microsoft SQL Server Integration Services, Pentaho Data Integration, Informatica PowerCenter, IBM Data Stage

Experience

Senior Oracle Retail Consultant

Wipro

2021-10 - Present · 5 yrs

Senior Oracle Retail Integration Consultant Lojas Renner EDEN project • Supporting the Integration Architect during the CRP phase, leading client workshops and identifying key requirements for third-party system integrations. • Configuring Oracle Retail integrations with OIC (Oracle Integration Cloud) via webhooks. • Developing OIC flows to enable seamless communication between Oracle Retail and external systems. Oracle Retail Integration Consultant ERP Pepco EU project - Development integrations with RestFull services to enrichment information for third-party systems. - Development of framework for generation events to data integration of DW and other systems. Oracle Retail Integration Support - Definitions and maintenance of PL/SQL codes, Oracle Data Integrator 11g, Oracle Data Integrator 12c. - Resolution of incidents (SLA / service level) through attendance, registration of actions and solutions/guidelines on the functionalities and rules involved in the system. - Interaction with other solvers for resolution, handling and monitoring of incidents. - Analysis, development and approval of solutions, monitoring of tests and deployments in order to validate and formalize the solution.

Senior Oracle Retail Consultant

Logic, Part of Accenture

2016-2 - 2021-10 · 5 yrs 9 mos

Porto Alegre e Região, Brasil

- ETL development and database integration, scheduling ETL routines for Data Werehouse. - Customization of ODI flows for Oracle Retail Analytics. - Data integration for several systems(PLM, MDM, Sensormatic, etc) with Oracle Retail Service Backbone, Oracle Retail Integration Bus.

ETL/Integration Specialist

IBM

2015-9 - 2016-2 · 6 mos

Porto Alegre

- Development ETL routines, extracting from CRM to new Data Mart. - Definitions and maintenance of PL/SQL codes, Oracle Data Integrator 11g, Oracle Data Integrator 12c.

ETL/Integration Specialist

DBC Company

2010-4 - 2015-9 · 5 yrs 6 mos

Porto Alegre, Rio Grande do Sul

- Outsourcing in clients (GetNet, Renner, RBS) - Analysis, development and approval of solutions, monitoring of tests and deployments in order to validate and formalize the solution. - Expertise in Analysis and Coding. - Definitions and maintenance of PL/SQL codes, Oracle Data Integrator 11g, Oracle Data Integrator 12c.

ETL Developer

RCI - Analytics Intelligence

2009-1 - 2010-4 · 1 yr 4 mos

- Worked on projects from design and architecture to development and roll-out - Modeled data structures optimized for the creation of reports and dashboards - Translated business requirements into functional specifications for ETL processes - Implementation of ETL routines