Renato M.

Data Engineer

Oracle PL/SQL VB Programmer Analyst
6/1/2022 - 3/1/2023

Developed proficiency in Oracle PL/SQL and Visual Basic (VB) for both online and batch systems within the insurance domain. Conducted extensive work in database management and scripting using Oracle PL/SQL, showcasing a strong ability to write complex queries, stored procedures, and performance tuning. Demonstrated significant skills in application development and maintenance using VB, ensuring efficient process automation and system integration. Built and optimized insurance-related applications, adhering to industry standards and best practices. Applied agile methodologies to improve system delivery and user satisfaction.

Systems Analyst
12/1/2020 - 2/1/2022

Engaged in analysis and programming of batch systems utilizing PL/SQL. Developed technical expertise in custom insurance applications tailored for the insurance industry. Executed complex data manipulations, transformations, and ensured high performance and reliability of batch processes. Leveraged Oracle Database technologies to maintain robust data integrity and efficiently handle large datasets. Utilized version control systems to manage code changes and collaborate with other developers. Created detailed technical documentation supporting all developed functionalities.

Development Consultant
9/1/2015 - Present

Oversaw development initiatives focusing on Microsoft Office (VBA) and Oracle Forms, with a specialization in PL/SQL for batch systems in the insurance and payroll sectors. Contributed to community training for FlutterFlow, demonstrating a strong commitment to knowledge sharing and community engagement.

Oracle PL/SQL Forms Programmer Analyst
10/1/2013 - 2/1/2015

Developed proficiency in Analysis and Programming using Oracle Forms and PL/SQL within governmental systems. Demonstrated expertise in executing impact analysis and tracking for multiple projects, utilizing Oracle Forms, Java, and PL/SQL. Produced comprehensive Use Case Specifications to guide project implementation and ensure alignment with business requirements.

Oracle PL/SQL Programmer Analyst
10/1/2012 - 10/1/2013

Specialized in Analysis and Oracle PL/SQL Programming within the Private Pension sector. Responsibilities included creating detailed system specifications, providing robust support for JAVA programming, and managing homologations in accordance with FEBRABAN standards. Expertise extended to scheduling system processes and offering comprehensive customer support, ensuring smooth operational continuity and adherence to regulatory requirements.

Student
1/1/2012 - 12/1/2012

Developed proficiency in project management principles adhering to the PMP Standard and PMI guidelines. Utilized project management tools such as Microsoft Project, JIRA, and Asana to streamline project planning and execution. Demonstrated expertise in Agile and Waterfall methodologies to deliver projects within scope, time, and budget constraints. Conducted risk management processes, including risk identification, assessment, and mitigation planning. Successfully managed cross-functional teams, facilitating effective communication and collaboration. Applied earned value management techniques to monitor project performance and progress. Leveraged advanced Excel skills for data analysis, reporting, and dashboard creation to support decision-making. Executed stakeholder management strategies to align project goals with organizational objectives and ensure stakeholder satisfaction.

COBOL Analyst/Programmer
6/1/2011 - 2/1/2012

Developed expertise in COBOL, DB2, and CICS within IBM mainframe environments, focusing on social and financial systems. Gained proficiency in integrating Mainframe COBOL with Micro Java components to enhance system functionality. Demonstrated strong analytic and programming skills, ensuring robust and seamless integration between mainframe and modern technologies. Worked extensively with mainframe architecture to support and optimize complex financial transactions and social service applications.

Network Administrator
7/1/2007 - 5/1/2011

Served as IT Supervisor specializing in user support, with expertise in the implementation, development, and management of networks using Windows Server SBS 2003/2008. Managed relationships with third-party service providers and hardware and software suppliers, including Dell, Alterdata, TOTVS, SolidWorks, Proteus, McAfee SaaS, Lanschool, and Winconnection. Overseeing PABX billing systems and internet links, ensured the integration and operational efficiency of various technological resources.

Analyst/Programmer ORACLE FORMS
5/1/2006 - 5/1/2011

Executed comprehensive analysis of requirements, training sessions, and development for ERP systems using Oracle PL/SQL Forms and Report Builder on SUN and Windows XP platforms. Integrated PL/SQL functionalities with Bematech ECF through ORA_FFI and Java, demonstrating robust knowledge of enterprise resource planning and proficiency in combining PL/SQL with external interfaces and Java components to enhance system capabilities. Developed technical expertise in Oracle database management and report generation, contributing to seamless ERP functionalities and effective data handling.

Cobol Analyst Y2K
1/1/2000 - 12/1/2001

Adapted legacy systems in the COBOL language to accommodate date formats with four-digit year identifiers (DDMMYYYY). Utilized an SEEC utility integrated with Excel macros, making significant adaptations using VBA to enhance functionality and compatibility.

COBOL Analyst/Programmer
6/1/1999 - 11/1/2005

Developed and programmed a Bank Return Control system with .csv file generation on Unisys mainframe using DMSII, Cobol, and WFL. Implemented file transfer to FTP Server for subsequent retrieval on the Internet via Excel (VBA), accompanied by a PowerPoint tutorial. Conducted maintenance, development, and programming tasks (DMSII, Cobol, WFL) for the Benefit Payment System via Magnetic Media (TP), optimizing its speed and efficiency within the Banking Network (INSS/FEBRABAN). Acquired advanced technical expertise in Unisys systems, Cobol programming, and workflow language operations, ensuring high-performance data handling and streamlined banking processes.

Manager of Microcomputing Division
6/1/1987 - 11/1/1995

Managed user service in a distributed environment of microcomputers and IBM terminals (IBM-VM, Windows/Netware, DataGeneral MV8000, and Cobra 480), including outsourcing services. Successfully led project management initiatives including restructuring of cabling, remote support for branches, and re-programming using Clipper and Visual Basic. Oversaw production and support functions for the legacy environment, specifically the Cobra 480 and MV8000 systems.

Development Manager
12/1/1982 - 5/1/1987

Managed the support and production area in the Cobra 500 environment, integrating systems with IBGE's mainframes (IBM). Led the development, project management, and implementation of a Private Pension System utilizing COBOL, ensuring precise control over the payroll for sponsoring companies. Initiated and established computer activities by implementing Operations and Maintenance (O&M) protocols, fostering a robust technical and operational foundation.

Development Manager
1/1/1978 - 10/1/1982

Managed programming teams specializing in COBOL for private pension systems, specifically within the railway network, Nuclebrás, and VARIG. Utilized the Constantine method and standard coding practices to ensure portability across multiple systems, including UNIVAC, IBM, and BURROUGHS. Developed proficiency with the 8085 microprocessor (Cobra 300). Played a key role in the conversion teams for financial systems at Banco Intercontinental (PrevCaixa) and Mesbla S/A, with extensive experience spanning from 1971 to 1977 on IBM platforms.

Analysis and Development of Systems at Veiga de Almeida University
2023 - 2025

Insurance Technology Management at National School of Insurance
2022 - 2023