Carlos D. freelancer experto en Oracle, SQL, SQL Server, MySQL, Sybase

Carlos D.

Solutions BI & Big Data

0 / 5


Programación y Tecnología

Habilidades (Máximo: 5)
Sobre mí
C_HANAIMP_1 - SAP Certified Application Associate - SAP HANA.

Over 2 year with SAP HANA, strong target in reduce processing time from SAP and Non-SAP environment, with big data concepts. RDS solutions for accelerated process and datamarts reports. Implementation BW on HANA and COPA on HANA solutions. Modelling, Data Loader, CE and SQL Scripts, Explain Plan.

Business Intelligence environment. Strong knowledge with technical and business definitions. Implementing ETL concepts (charge Full and Delta), data warehouse, dashboards, reports for desktop and mobile environment. SAP Business Object 3.x and 4, BW 3.5 and 7.x, SAP Data Integrator, Power Center Informatica, Oracle Discover.

Oracle DBA performing installation in high availability, administration of users and schemas, tuning of the database and PL/SQL, patching, migrating environments versions 7, 8i, 9i, 10 and 11i, development and validation of data modeling, procedures, functions, views and trigger PL/SQL in Windows and Red Hat Linux. Tools Forms, Reports, Discover, Toad and PL Developer. COLD Backup and HOTBACKUP/RMAN, 24/7/365 environment.

DBA SQL Server 2000 and 2005, performing backup recover, mirror, applying patches and hot-fix. Functions, views and trigger T-SQL. Optimization of query and T-SQL. Monitoring Jobs, fragmentation indices, Execution Plan, DTS. Import and export bases.

Development and administration environment for integrating processes using the concepts of BPM and EAI, Oracle Integration, SAP PI, Adapters, IDocs, RFCs and BAPIs.

Managing and developing with SAP MII for shop floor projects, appointment production discrete and process, kanban control, OEE, Dashboards, Video Wall, Bar code scanning, Handhelds and interface with SAP R/3 and ECC.

Over 15 years of experience in information technology area in the petrochemicals, iron and steel industry and manufacturing processes, aviation service, shoop floor, retail trade, telcom, healthcare  and high education industries.
Historia laboral
* TACK Information Tecnology: • SAP HANA project for implementation SPED PIS and COFINS taxes. Modeling, ETL Base Replication, development of the scripts, analytics and calculation views, customer Petrobras (Oil & Gas Industry). In partnership with Actual Consulting.

• Mapping of processes for production and quality records, aiming to become a single process for Randon companies (Fras-Le, Castertech, Master, Jost, Implementos, Suspensys and Veículos. Development systems for appointment in shop floor with SAP MII 12.1 tools include screens for bar code scanning handheld with Windows Mobile for process and discret manufacturing and integration with PP and QM modules for the SAP ECC (Automotive Industry). In partnership with Neoris Brasil.

• Modeling and development SQL Server 2008 database for QM reporting with KPIs integrating SAP QM and SAP MII 12.1 for CPKelco company. In partnership with Konitech consulting.

• Modeling and development SQL Server 2005 database for production report with HMI and SAP MII 12.1 for Klabin company. In partnership with Konitech and Projeto Otimiza consulting.

• Oracle consulter for database administrator, development with Forms and Reports version 3, 4.5, 5, 6i and PL/SQL for customers Philips Components, Phoenix Electronics, Vishay Semiconductors and UNISA - Santo Amaro University

• Specification, development and implementation for system SAGE in Clipper version 5.2d, for management and control for schools with courses kindergarten, basic, high school and university. Financial control and academic, integration with banking system national, ratings issuing reports, history report academic, control of classroom absenteeism, dashboard for monitoring the evolutions of the classes.

• Convert enterprise system from computer Tropus and Cobol Microfocus to Novell Netware and Clipper version 5.11. Especification, development and implementation for sales system, billing, accounts payable and receivable, inventory control and production kanban for JAP Janelas customer.

Rankeado: No está rankeado

Último login: Hace 8 meses

Registrado: Hace 5 años