Data Analyst

AMANUEL KALATA

Phone: 678-***-**** • Email: ********@*****.***

PROFESSIONAL OBJECTIVE

Results-driven, problem solving professional seeking to utilize business processing, data analysis and technical skills with finance and accounting background to secure long term financial or data analyst position in a collaborative team environment.

Basic knowledge in SAS programming with clinical trials and Adhoc reports (SAS, SAS-SQL, SAS-Macros)

Over 3 years’ experience in SmartView retrieve and ad hoc reports

Experienced in OBIEE reporting software and Essbase logic

Basic knowledge of Tableau Software

Business Process Analysis, Data Analysis, and data management– successfully performed all facets of enterprise level BPM (ARIS, VISO, and Case Complete), including design of process architecture and development of modeling standards

Accounting and Finance professional with over 4 years’ experience preparing payment reconciliations

Experienced reviewing the vendor A/R aging reports and reconciling items against A/P payment records

Experienced with handling, researching, and analyzing large amounts of data using Microsoft Excel and Basic knowledge of Microsoft SQL (2005, 2008R2, 2012)

EDUCATION

Georgia State University, J. Mack Robinson College of Business - Atlanta, GA

Bachelor of Business Administration, Major: Finance

Technical Skills

Base SAS - SAS-SQL SAS-Macros- SAS Enterprise Guide SAS Foundation-9.4

Strong Excel - VLook-Up and Pivot Table

Business Analysis - Case Complete Enterprise Architect, ARIS BPMN Modeling, VISIO, Snagit, UML

Data Analysis Basic - Performance Tuning MS SQL, Teradata, Waterfall, Agile, Scrum

Business Intelligence software – Oracle (Hyperion, OBIEE), Qlikview, Tableau

MSSQL Server Installation 2014

Windows - Windows7, Vista, Windows XP, Windows10

PROFESSIONAL EXPERIENCE

IHG, InterContinental Hotels Group PLC – Atlanta GA March 2015 – Present

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 that 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

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

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 work flow 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

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

St. Joseph’s Hospital, Atlanta GA July 2007 – September 2006

Pharmacy Tech. II

Conduct inventory and data entry

Prepared IV’s, TPN’s and pain medications

Performed routine technician duties under supervision of doctors and nurses

Assisted in training new employees

References available upon request

Contact this candidate