Valter M.

Data Engineer

Oracle Developer Analyst
1/2/2020 - Present

Developed and maintained screens, reports, and applications using Oracle Forms Builder and Reports Builder. Expertise in creating and managing database routines including packages, procedures, functions, and triggers, as well as generating tables, synonyms, and managing users. Automated the execution of database routines to enhance operational efficiency. Led the migration of existing screens from Oracle Forms to APEX (version 5.0), ensuring seamless transition and functionality. Prepared comprehensive documentation for all migrated applications, ensuring clarity and ease of future maintenance.

Developer Analyst
8/2/2019 - 2/2/2020

Developed expertise in Oracle database modeling and management, including the creation and modification of tables. Utilized Oracle Designer to develop new transactions and reports. Managed user privileges and application scheduling through a custom transaction. Focused on enhancing a widely used HR system, adhering to CMMI documentation standards. Gained proficiency in the Genexus tool for the generation of existing transactions.

Systems Analyst
5/2/2018 - 4/2/2019

Served as a Systems Analyst responsible for reengineering analysis, corrections, and new implementations based on client requests facilitated through Jira tickets. Tasks ranged from adding new fields in screens, detailing reports, developing new applications, to crafting system modules, all documented meticulously with step-by-step instructions and accompanied by pgPLSQL scripts when needed. Post documentation, the work was handed over to the development team. Utilized tools such as Jira, pgAdmin, pgModeler, and Microsoft Office to perform the duties effectively. Specialized as an analyst within a hospital control system framework.

Oracle Developer Analyst
8/2/2014 - 5/2/2016

Developed proficiency in Oracle Database and ERP systems, undertaking analysis, updates, optimizations, and tuning of database routines. Maintained and developed new applications, ensuring robust functionality and performance. Collaborated periodically with clients to monitor system performance and gather new requirements, integrating feedback to enhance the ERP system's capabilities and efficiency.

Oracle Developer Analyst
4/2/2014 - 8/2/2014

Developed proficiency in PLSQL, Oracle Data Integrator (ODI), Oracle Forms and Reports, and Oracle Application Express (Apex). Conducted extensive work in EDI (Electronic Data Interchange), ETL (Extract, Transform, Load), and BI (Business Intelligence) routines. Created detailed system diagrams using Enterprise Architect, performed tuning of existing routines to enhance performance, and conducted maintenance in legacy Clipper routines.

PLSQL Developer Analyst
11/2/2013 - 3/2/2014

Developed proficiency in PLSQL with extensive experience working on SPED load routines using data from SAP. Undertook customization, fault correction, and performance tuning of existing routines. Created new routines for monitoring, verifying, and validating data. Proficient in identifying inefficiencies and implementing optimizations to enhance system performance. Demonstrated strong analytical skills and a deep understanding of database management and data integrity protocols.

Oracle Developer Analyst
4/2/2013 - 7/2/2013

Demonstrated expertise in Oracle SQL and PL/SQL while working on EDI process routines, including customization, failure rectification, performance tuning, and the creation of new routines. Successfully generated a control screen for EDI files, facilitating the verification of involved data, quantities, implicit billing, and the status of generated EDI files within a specified period.

Oracle Data Analyst
11/2/2012 - 4/2/2013

As an Oracle Data Analyst, gained expertise in data replication between CAD1 databases located at headquarters in Rio Grande do Sul and CAD2 at the branch in São Paulo. Ensured consistency and adherence by optimizing, debugging, and generating involved routines. Developed and managed Schedule Jobs to automate these processes. Designed and implemented a monitoring screen for these replications using Oracle Forms and Apex, ensuring efficient and reliable data synchronization.

Oracle Consultant
9/2/2011 - 9/2/2012

Excelled as a PL/SQL Consultant in Porto Alegre, specializing in modeling and generating new applications. Expertise in developing comprehensive project documentation and implementing complex database routines, including thorough testing and approval processes. Showcased advanced skills in report generation using Crystal Reports 2008.

Oracle Developer Analyst
4/2/2011 - 8/2/2011

Demonstrated expertise in the analysis, modeling, and generation of database routines including procedures, functions, and triggers using Oracle tools. Developed comprehensive skills in database management and optimization, ensuring the efficient and effective operation of database systems. Utilized advanced Oracle toolsets to build and maintain robust applications, contributing to streamlined workflow processes and enhanced data integrity.

Database Analyst
1/2/2011 - 1/2/2011

Developed expertise in creating routines and managing databases for accounting and tax audit applications, particularly focusing on importing data from various client ERP systems into SQL Server databases. Excelled in identifying faults or missing information within accounting and tax areas, including SPED and NFe. Demonstrated advanced proficiency in SQL Server and database management.

Oracle Developer Analyst
1/2/2010 - 1/2/2011

Excelled in the Arezzo Footwear project, designing and implementing routines to manage stock control, storage, costs, inventory, financial, accounting, and tax matters. Developed and maintained screens for execution or maintenance of data used by these routines and reports. Specialized in the import/export of data to SQL Server for updating remote stock bases, prices, and product characteristics. Ensured robust version control of routines and applications using SVN.

Oracle Analyst/Developer
1/2/2010 - 1/2/2010

Developed proficiency in dynamic SQL for table modification, creating routines to streamline and automate this process. Designed and implemented an application to generate scripts for populating tables involved in global telephone routing tests, utilizing Forms 6i and 10g. Enhanced data visualization capabilities by generating a front-end interface with Oracle Apex, allowing for effective viewing of statistics.

Oracle Consultant Analyst
1/2/2007 - 1/2/2009

Focused on enhancing interfaces between installed ERP systems and Oracle EBS, and the tax tool, leveraging expertise in Oracle EBS and MasterSAF. Specialized in customizing and optimizing routines and reports, with a strong emphasis on generating new reports and maximizing performance in data import routines through tuning and new methodologies. Engaged in extensive application and report maintenance, particularly utilizing Oracle Forms version 6i. Conducted detailed mappings of SPED fiscal and accounting data, as well as the generation, customization, and tuning of interfaces between proprietary Oracle ERP systems and MasterSAF. Demonstrated a consistent ability to address specific client requests efficiently and effectively through optimized technical solutions.

Oracle Developer Analyst
1/2/2005 - 1/2/2007

Developed procedures and triggers as an Analyst and Programmer utilizing Oracle Forms and Reports. Created sophisticated database routines such as procedures, functions, and triggers while employing CVS for version control. Spearheaded the development of a corporate portal using Oracle Portal. Enhanced business intelligence systems through the PL/SQL Web Toolkit, retrieving and analyzing data from Microsiga, and generating comprehensive reports using Crystal Reports version 10. Contributed to BI system development by crafting reports with Oracle Discoverer and generating ETLs from data imported from Sybase databases.

Developer Analyst
1/2/2003 - 1/2/2005

Engaged in the modeling and generation of database routines, triggers, procedures, and functions for the development of an ERP system, utilizing databases such as PostgreSQL, Oracle, and SQL Server. Utilized ERWin for data modeling, and Crystal Reports version 9 for generating reports and text files for banking communication. Developed accounting triggers and functions for balance recalculation, as well as procedures and functions for cash flow management. Contributed to manufacturing orders by implementing material requisition and stock reduction functions, along with MRP routines based on consumption averages over recent months. Designed warehouse maintenance (WMS) routines, incorporating the option of using data collectors. Implemented transportation-related triggers and procedures. Enhanced cash flow functionalities through the implementation of various visualization options using Crystal Reports, further supported by routines developed in Visual Basic and SQL.

Oracle Developer Analyst
1/2/2003 - 1/2/2003

Served as an Oracle Developer Analyst in Porto Alegre, focusing on providing services to a major client in modeling and generating programs and reports. Demonstrated expertise in implementing database routines, including triggers, procedures, and functions. Utilized advanced Case and Developer tools in version 6i to accomplish these tasks, ensuring the seamless performance and integration of database solutions.

Oracle Developer Analyst
1/2/2000 - 1/2/2002

Developed proficiency in Oracle Designer 2000 and Developer 2000, with extensive technical experience in proprietary SGE systems. Specialized in creating accounting routines, Cash Flow systems, Accounts Receivable, Accounts Payable, and developed routines for Production Control Planning (PCP) and Inventory management. Demonstrated analytical skills in system migration to version 6i via Case and Developer tools. Modeled and generated comprehensive Cost systems and Asset Control systems. Exhibited strong capabilities in using Forms Builder for chart development. Conducted user training sessions and prepared detailed instructional manuals.