Amanuel Kalata

Phone: 678-***-**** • Email: ad4fl1@r.postjobfree.com

Professional Summary

Detail-oriented and self-motivated professional armed with hands-on experience in customer service and client relations management. Known for reliable track record of superior service and success in attaining customer satisfaction and generating profit for the company. Articulate communicator with the ability to communicate with internal partners and key clients, while maintaining versatility in a fast-paced and high-pressure work environments

EDUCATION

Georgia State University, J. Mack Robinson College of Business - Atlanta, GA Bachelor of Business Administration, Major: Finance Technical Skills

Strong Excel - VLOOKUP and Pivot Table

Business Analysis - Case Complete Enterprise Architect, VISIO, Snagit, UML Data Analysis -Basic MS SQL, Teradata, Waterfall, Agile, Scrum Business Intelligence software – Oracle (Hyperion, OBIEE, SmarView), Tableau MSSQL Server Installation 2014

Windows - Windows7, Vista, Windows XP, Windows10

PROFESSIONAL EXPERIENCE

ekal Capital Solutions, LLC (self-employed) December 2018 – January 2023 Funding Consultant and Business Developer

• Provide small and large companies with business funding

• Examine, evaluate, and process loan applications.

• Administer thorough review and research and enable validation of mortgage documents

• Advise existing customers on various loan programs based on the customers’ financial needs

• Interview applicants to collect information concerning their financial needs, objectives, and status

• Analyze clients financial/credit worthiness to ensure conformity with builders and lenders standards

• Ensure all loans were properly documented with accurate and complete information

• Analyze Proforma for construction projects

• Develop and structure Proforma for projects

IHG, InterContinental Hotels Group PLC – Atlanta GA November 2015 – November 2018 Business Intelligence Application Analyst

• Assist implementation of key performance business intelligence solutions for hotel winning customer metric system

• Create and develop reports including line charts, pie charts, and trend analysis reports

• Assist with implementation of business intelligence dashboard and assist with validating data

• Design and implement test plans for user acceptance (UAT) that ensure new program functionality is delivered to meet business requirements

• Provide educational documents and training materials to new global hotel users for application of new software special metric system

• Contact IT resources, external vendors and partners regarding program operations, system procedures and data interpretation

• Document functional and non-functional business analysis requirements using Visio, BPM, and Snagit software

• Provide training documents for new business intelligence reporting software user and assist hotel management with understanding how reported data affects best business practice Amanuel Kalata

Phone: 678-***-**** • Email: ad4fl1@r.postjobfree.com

IHG, InterContinental Hotels Group PLC – Atlanta GA March 2015 – October 2015 Financial Controller Specialist/Analyst

• Analyze accounting entries and prepare financial statements

• Trace accounting entries through the accounting system and update journal entries

• Reconcile financial data and prepare data to address audit requests

• Provide financial reporting data management utilizing PeopleSoft, Teradata, and Oracle Business Intelligence

• Provide SOX & financial statement audits

• Identify control gaps/concerns and develop and document procedures to address financial control concerns

• Document functional and non-functional business analysis requirements using Visio, BPM, and Snagit software

• Prepare Use Case for financial and business requirements

• Assist with implementing and configuring systems for financial software

• Prepare test plan and test cases for system update and upgrade Department of Community Affairs/US Treasury - Atlanta GA February 2013 – March 2015 Accounting Assistant

• Prepared payment reconciliation and weekly and monthly payment reports

• Reviewed and identified new and existing loans scheduled for payment

• Reconciled payment records against the general ledger and system cumulative totals

• Identified, researched and remediated payment variances

• Contacted lenders to assist with ACH setup and reviewed monthly trial balance reports

• Field questions from internal and external customers regarding payment issues and concerns

• Reviewed and reconciled attorney title and closing invoices

• Compiled and prepared weekly attorney check requests

• Prepared monthly attorney invoice reporting for legal department and Deputy Commissioner

• Reviewed vendor A/R aging reports, reconciling items against A/P payment records

• Assisted in the preparation of Treasury reporting Wells Fargo Home Mortgage - Atlanta GA December 2012 – January 2013 Quality Assurance Analyst Level II (Mortgage QC)

• Reviewed loan documents, files and on-line transactions to determine if programs, processes, and documentation are in compliance with internal company requirements, insurer guidelines, investor requirements, and government regulations

• Reviewed underwriting, regulatory compliance, foreclosure, bankruptcy, fraud, fair lending, and servicing

• Evaluated overall loan documentation (application, appraisal, title, credit, loan-to-value, legal documents) and system documentation to determine investor and/or regulatory issues

• Ensured corrective action, accurate data input, and adherence to proper procedures

• Identified risks and/or problems and interacted with the appropriate parties for timely resolution

• Recommended standards, policies, and/or procedures to correct noted deficiencies Department of Community Affairs/US Treasury - Atlanta GA January 2010 – December 2012 Data Analyst

• Responsible for transferring and exchanging data with lenders for borrowers approved for mortgage assistance

• Prepared and downloaded loan data files of approved borrowers Amanuel Kalata

Phone: 678-***-**** • Email: ad4fl1@r.postjobfree.com

• Uploaded and downloaded secure data from FTP sites and through secure e-mail

• Worked with servicers on Common Data File (CDF) exchanges

• Worked with lenders to postpone/stop foreclosures

• Maintained database of loan information

• Assisted closing department streamline with their workflow by researching data from the server and online

• Developed experience working with Microsoft Excel and CSV files

• Developed basic knowledge and experience with several types of databases such as SQL and database design structure

• Assisted on-site IT support duties

Department of Community Affairs/US Treasury - Atlanta GA January 2010 – December 2012 Loan Processor

• Determined risk assessment & assisted in final decision for eligibility of the Hardest Hit Fund Payment Assistance Program

• Evaluated credit reports, appraisals, financial statements, tax returns, assets, work history and ratios to determine risk factor for the investor as well as loan criteria guidelines. Products included - FNMA/FHLMC/FHA/USDA

• Maintained a high level of customer service by being proactive with customers, operational staff, closers, and title companies

G-Squared Financial, LLC, Atlanta, GA February 2008 – December 2009 Senior Mortgage Consultant

• Originated mortgages for home purchases, refinancing, and new home construction using Conventional, FHA and VA loans

• Solidified contacts with local realtors, contractors, financial advisors, potential borrowers, and other referral sources

• Reviewed financial data, appraisal reports, credit reports, verifications and documents as required

• Analyzed information provided by clients to assist with finding appropriate loan programs and restoring credit score in order to qualify for the best rate

• Processed and reviewed executed loan documentation to ensure compliance with all state and regulatory requirements

North Metro Atlanta Mortgage, LLC, Atlanta, GA January 2005 – February 2008 Mortgage Consultant

• Originated mortgages for home purchases, refinancing, and new home construction using Conventional, FHA and VA loans

• Reviewed financial data, appraisal reports, credit reports, verifications and documents as required

• Analyzed information provided by clients to assist with finding appropriate loan programs and restoring credit score to qualify for the best rate

• Processed and reviewed executed loan documentation to ensure compliance with all state and regulatory requirements

References available upon request

Contact this candidate