John Penke

• Designed, developed, and tested Quarterly Attestation process to enable business users to Subscribe, Attest and Reject rules for Reconciliation
• Implemented Reporting feature across multiple regions to audit the attestation process on different levels
• Re-architectured Archival Process of huge volume of generated breaks (~2 Billion per month) to run independently using exchange partition which reduced the downtime of application by 50%
• Designed and programmed SpringBoot based Automatch API for seamless Data Transfer from TLM Reconciliation Engine to Machine Learning modules to enable auto reconciliation process
• Lead an analysis of highly scalable ETL jobs using Talend Open Studio to fetch transactions from TLM/QuickRec engines on a daily basis to enable manual reconciliation
• Designed Asynchronous job executor system to update the department Owner hierarchy using minimal hits to Global Directory
• Worked upon migration of 3 core components of RCM project for 19C Premium Database Migration

Skills: Java, SpringBoot, Hibernate, GWT (Front-end), Linux, Shell scripting, Oracle DB, Talend Open Studio, SDLC

• Designed custom reporting dashboards, Interactive UI viewing and updating for specific tables using GWT and email service to run in periodic manner as per business requirements
• Coded stand alone jobs using Quartz scheduler service and shell scripting to split files of huge volumes based upon a few columns
• Implemented interactive UI viewing and updating options for specific tables
• Lead production release activity of 7 RCM tools across 8 different instances
• Automated Database and config deployment processes across various TLM Instances using IBM UDeploy and TeamCity

Skills: Java, GWT, Linux, Shell scripting, SQL, GIT, JUnit, Mockito, GIT, SQL