Rui Rodrigues

Developed COBOL-based ETL processes to integrate business data and enhance data extraction and transformation, improving system efficiency and scalability. Improved ETL time frames from days to minutes, over 95%

• Delivered multiple projects within stringent deadlines, ensuring high-quality results and adherence to contractual commitments
• Streamlined manual processes and improved data quality, eliminating redundancies and reducing effort over 99%

• Led enhancements for the SABR and MARS Billing Systems, converting legacy IBI FOCUS logic to PL/SQL early or on-time
• Designed and implemented performance-driven solutions in an Agile/Kanban environment, ensuring reliability and maintainability

• Supported a large DB2/COBOL mainframe system, driving system enhancements to meet evolving government regulations and client needs
• Ensured system flexibility, performance, and maintainability through careful design and solution development
• Automated manual daily processes reducing time from over half a day to minutes

• Led a team of onshore and offshore resources to redesign and convert the CARS Auto Insurance System from VSAM to DB2, improving performance and scalability
• Reduced build and testing times through reusable components and tools, enhancing productivity and project timelines
• Created tools that enabled logical viewing and editing of files with large record lengths (over 32k) not otherwise possible on the mainframe environment

• Led key ETL projects, designing and developing COBOL-based systems and JCL jobs to support the Data Warehouse and Health Management data processing
• Created new process to accept and automatically process medical lab data feeds received multiple times daily from many external sources
• Delivered critical projects on time, meeting performance and auditing standards while coordinating onshore and offshore teams

• Managed and enhanced various health management and finance systems, improving accuracy, efficiency, and reporting capabilities
• Reduced nightly batch cycle failures by over 90% due to a philosophy of fixing root causes of multiple chronic problems
• Led an effort to enable a very large and complex accounting system to be executed thru Xpeditor enabling a large enhancement project to be implemented on time
• Led the conversion of GAAP process from mainframe to Oracle, cutting project time and costs significantly

• Led teams in supporting and improving critical valuation systems, including key contributions to Y2K efforts and annual Dividend Scale projects
• Reduced system costs and execution times by reengineering legacy processes and systems

• Led the creation of sophisticated systems for Dividend Estimates, Reinsurance Reserve Modeling, and reporting, delivering significant cost savings and improvements in data accuracy
• Modernized legacy COBOL systems to improve efficiency and reduce operational costs