Charles Kerns Email & Phone Number

Columbus, Ohio Area

• Heitmeyer Consulting, Westerville. OH March 2016 – March-2017AFS Business Systems Analyst Contractor for Huntington Bank
• Contractor for First Merit Bank ACBS conversion to HNB AFS Level III.
• Conducted data mapping session to documented conversion specifications for FMER ACBS system to AFS Level III.
• Implemented HNB balancing approach as well as financial balancing and data field validation reports.
• Utilized Microsoft Office Products such as Word, Excel, Access, Communicator and Skype for Business for IM and meetings.
• Developed ad hoc history reports of converted and non-converted FMER ACBS to HNB AFS and ACBS systems

Malvern, PA

• Performed analysis of client’s needs as stated in their business requirements document.
• Documented the design based on current system capabilities and the client’s request.
• Assessed and projected how the client’s changes will impact internal staff and enhance customer experience.
• Ensured that changes are in compliance with federal, state, and local banking regulations.
• Trained internal employees and external clients on changes and new procedures.
• Worked with clients’ back office support staff to help them understand and efficiently utilize the Profile system for Customer Origination, Loans and Deposits.

• Liaison and SME for AFS Commerce application including Commercial Lending, Business Banking Origination, Escrow, Relational Download and Collection.
• Created and submitted C1st cases and Change Control Requests on behalf of the bank.
• Lead Business Analyst for conversion of over 800 loans from DNA (Open Solutions, Inc.) to AFS via Foxtrot Software, including analysis, data mapping, test cases and conversion validation.
• Implemented Middle Market, Escrow and Specialized Lending into AFS Level III.
• Assisted in the creation of adhoc reports for Management and Finance utilizing RDL from the bank’s Data Warehouse.
• Worked directly with Commercial Loan Servicing in error resolution, daily procedures and General Ledger balancing.

• Contractor for Merrill Lynch ACBS conversion to AFS Level III.
• Assisted in data mapping of source system to AFS Level III.
• Developed and implemented balancing approach and customized balancing reports.
• Conducted weekly balancing activities meetings via Microsoft Live Meeting with various departments within the bank such as Finance, Letter of Credit, Recon, Business Partners and Market Financial Controllers.
• Direct interaction with Finance to determine General Ledger Accounts.
• Implemented automated procedures for determining officers through inter-bank cooperation and sharing of data.

• Implemented and trained on the AFS Level III software, including Commercial, Consumer, Dealer Floor Plan and Collections modules at clients’ sites.
• Lead Business Analyst for conversion of clients’ legacy systems as well as upgrades to the latest releases of the software and development of enhancements and new features to the AFS Level III and Vision systems.
• Interviewed and conducted Joint Requirements Design sessions (JAD) with mid-level management and end users, whether on client sites, conference calls or webcasts, to gather information for the user requirements document.
• Provided analysis of data received utilizing MS Access/Excel/Word to the client.
• Determined any functions that needed to be created throughout the project.
• Created Case Models, Business Process Mapping as well as Business Process Modeling with process flow diagrams defining new and old processes utilizing MS PowerPoint/Visio/Word.

• Start up and full charge of Consumer Loan Department including hiring and training.
• Implemented policies and procedures for direct and indirect automobile loans, home equity lines of credit, and student loans.
• Responsible for determining budget, goals, and advertising for Consumer Lending Division.
• Full charge of Collection Department, handling consumer, mortgage, and commercial loans.
• Compliance Officer responsible for compliance with all regulatory activities of Federal Home Loan Bank Board.
• Served on Asset Classification and Bank Operations Management Committees

• Implemented and managed the Consumer Credit Department with eleven employees.
• Responsible for a portfolio of over $46 million outstanding.
• Handled direct and indirect automobile loans, revolving credit equity, home equity, personal and student loans, and overdraft protection.
• Instituted and implemented new programs for consumer lending such as dealer wholesale floor plan