Jemerson Kleder Costa Dutra

· Migration.

I contributed to the migration of data from a proprietary application to a new platform, rebuilding the database structure from the ground up. This included creating indexes, tables, triggers, views, and rebuild PL/SQL packages while ensuring data integrity and compatibility with the new system. Throughout the process, I also optimized several procedures to enhance performance and reduce execution time for critical processes. As a result, the company successfully modernized its technological infrastructure, improving operational efficiency and better meeting business demands. including presentation of data modeling of the system.

• During my brief time with the company, I focused on analyzing packages and procedures to improve some query performance. I also collaborated on rebuilding specific indexes to optimize key database processes, leading to improved efficiency in critical operations.

• we were tasked with developing a comprehensive management application for the entire business. The system covered functionalities such as purchasing, invoice issuance, inventory control, and financial management. As part of the project, we were responsible for the complete creation of database objects, including tables, indexes, procedures, functions, and more. Oracle Forms and Crystal Reports were chosen as the core technologies to implement the solution.

We developed a system using Oracle Forms and Oracle Reports for application functionalities and Crystal Reports for generating detailed reports and dashboards. The system effectively managed the delivery of promotional items , product customization, and order tracking .

This solution enhanced the control of sales processes, streamlined product customization workflows, and optimized delivery operations. By providing better oversight, it significantly reduced delivery delays and improved overall operational efficiency.

During this time, I was introduced to Oracle APEX and began experimenting with small-scale developments, gradually exploring its potential for modern web-based application development.

we replaced the manufacturing module responsible for color assembly and product production orders using oracle reports and forms. We enhanced all production controls, significantly reducing manufacturing waste. Additionally, we optimized the product cost calculation process, reducing its duration from several days to just a few minutes.

· We developed stock market systems that streamlined operations by enabling purchase and sale orders to be sent directly to the stock exchange databases.

· The need for an integrated internal control system alongside the financial desk module led us to design and implement a complete back-office solution for the company, including a comprehensive accounting module.

I was the Oracle DBA from 1998 to 2010, during which I not only managed the database but also developed PL/SQL routines (Packages, Procedures, and Functions) and applications using Oracle Forms and Reports.

I actively participated in the development of critical modules such as inventory, manufacturing orders, MRP, logistics, purchasing, and production control.

One of the major challenges during this period was addressing system performance issues. To resolve this, we implemented an innovative solution using Oracle's Advanced Replication feature. We created three distributed databases across production units, which significantly improved system performance and ensured greater operational efficiency.

• IT Business Plan
• Management , Telecom and infrastructure of IT
• Review of Rules and procedures

• Dataflex Developer from factures modules (stock, MRP, Inventory)
• Skill of migration Dataflex to Oracle