RPA Lead Developer• Develop automation processes for a federal credit union using UIPath Studio and Orchestrator• Fully programmed automated process to close overdrafted checking/savings accounts based on established business decisions within mainframe• Schedule, maintain, and troubleshoot a collection of bots to perform automated tasks in Hogan mainframe, Microsoft Office programs, and web browsers• Knowledge in RE framework, flow chart, and sequence… Show more RPA Lead Developer• Develop automation processes for a federal credit union using UIPath Studio and Orchestrator• Fully programmed automated process to close overdrafted checking/savings accounts based on established business decisions within mainframe• Schedule, maintain, and troubleshoot a collection of bots to perform automated tasks in Hogan mainframe, Microsoft Office programs, and web browsers• Knowledge in RE framework, flow chart, and sequence developmentLead Talend ETL - Merger/Acquisition • Worked as one of the lead ETL Developers with a federal credit union in merging data from acquisitions• Oversaw and developed on eight and counting mergers end to end, with 5 mergers being within 5 months of each other• Worked with Deposits, Loans, and Joint Borrower data to convert products and accounts from one credit union to the other• Able to convert from one data file/type to another• Read and write to database from Talend• Knowledge of using context variables and declaring global variables• Able to join multiple inputs• Custom Java routines to cleanse data or account for intensive mapping rules• In depth knowledge of filter/aggregation tools• TMap custom IF statements, concatenations, and filtering• Knowledge of normalization and database designDatabase SQL Server • Create/drop/update tables in congruence with current data received from merging credit union• Knowledge in creating views and functions• Understanding of joins, queries, and sub- queries Informatica ETL• Powercenter Developer level 1 & 2 self-study courses• Extracted, transformed , and loaded data from one database to another• Designed data mappings/mapplets inside Informatica• Worked with SAP team to get them the data they needed to design real-time disruption management application for airlines Show less