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. • Identified application and technical solutions to solve issues with current system functionality• Assisted with design and implementation of enhanced client communication to the institution’s customers.• Provided in-house “Lunch and Learn” sessions on new features and enhancements for both internal business analysts and technical developers.• Relied on extensive experience and judgment to accomplish client’s goals.

• 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. • Implemented Escrow module and the automation of the feed from Core Logic (First American Tax Service) to AFS and back for the bank’s escrow accounts. • Interacted with Finance department and the General Ledger area for new product type rollouts.• Trained staff and helped the bank’s internal training staff develop and implement Flagstar specific training materials.• Utilized Microsoft Office Suite, ONBASE reports viewer, Lotus Notes and Foxtrot Software.

• 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.• Assisted in validation procedures and recording of defects through HP Quality Center Software.• Utilized Microsoft Office Products such as Word, Excel, Access, Live Meeting and Communicator.

• 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 throughout the system development life cycle (SDLC).• 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.• Created Business Requirements Document (BRD) and Business Requirements Specification (BRS) including in detail any screen layouts utilizing MS Word/PowerPoint .• Created detailed data mapping along with other supporting documentation for the programming staff.• Developed both high level and detail test scripts for unit, system, regression and user acceptance testing.• Developed specifications with the programming staff to provide any custom reports that were not able to be provided utilizing MS Office Suite products.• Developed training material in conjunction with the Course Developers.• Conducted end user training for all departments and any areas affected by the project.• Authored user documentation for any new products or enhancements.• Provided post implementation support and facilitated resolution of any problems identified.• Provided sales support and demonstrations of the system.• Knowledge, understanding and adherence to Federal, State and Local laws and regulations.

• 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