Data Analyst Accountant

Farrag Yousef

Personal data

Address: *** **** **, ********, *****, NJ

Phone: 732-***-****

E-mail: ******.*.******@*****.***

Education

B.SC, Cairo University, Accounting Dept. 2007 GPA: 3.1

Diploma of Analysis of the Stock Market, Cairo University, 2009

Professional Certifications

CAMS (Certified Anti Money Specialist).

MCITP (MS SQL server 2008).

Microsoft Dynamics AX (Trade and Logistics).

Experiences:

The Port Authority Of New York & New Jersey (Contract – CRA Inc.) New York

Violations Business Analyst 4/2019 – Till now

Responsibilities:

Compile evidence to escalate violations to collection agencies

Compile supporting documentation for vehicle suspension of persistent violators through the NY DMV registration suspension program

Conduct research of violation accounts using Crystal Report, SQL reporting systems

Run queries, conduct research and analyses, and communicate findings with customers, with contractors, and various levels of staff throughout the Agency

Make appropriate modifications to documents based upon reviews and track and manage the signature process for memo approvals

Track and monitor approvals and appeals for reporting purposes

Perform other duties as assigned

Data Engineering Training and Internship New Jersey

Sollers Collage 10/2018– 02/2019

Curriculums:

ETL & Data Warehouse Fundamental

Oracle development

Informatics

Tableau

Alteryx

Hive

AWS Fundamentals

Quality Assurance

BNP Paribas – Contract New York

KYC Analyst 1/2018 - 10/2018

Responsibilities:

Support the KYC VP and work with the KYC Team analysts to perform

KYC file reviews related new and existing customers

Interface with account officers for all KYC related tasks and inquiries

Review and analysis of customer risk rating increases and decreases

Participate in Team meetings where presentations may be required

Prepare document and review KYC related reports

Send notification requests to account officers and track responses received

Aid with periodic audits, risk assessments and compliance reviews

Conduct OFAC and AML due diligence screening

Conduct periodic compliance report reviews

Conduct Google search, World Check, Dow Jones, Factiva Press,Alacra,

and Lexis Nexis search and collect all relevant information for investigation.

Conduct alert analysis and ensure red flags are properly identified; negative

news is disposition relevant analysis is accurate and sufficient; supporting documents are saved;

Run SQL commend on Prime Platform to filter results as required from team leader

Make recommendations based on investigation result and escalate alerts that warrant further investigation

Conduct preliminary case investigation and draft case recommendations

Completing the initial customer risk rating process consistent with the Bank’s established processes.

Ensuring that all on boarding documentation has been collected.

Completing KYC reviews in a timely manner and in accordance with a risk-based schedule.

Amazon – Contract New York

KYC Analyst 3/2017 - 1/2018

Responsibilities:

Performing KYC file reviews related new and existing customers

Participate in Team meetings where presentations may be required

Prepare document and review KYC related reports

Conduct OFAC and AML due diligence screening

Conduct Google search, World Compliance, and Lexis Nexis, Bridger search

and collect all relevant information for investigation.

Conduct alert analysis and ensure red flags are properly identified; negative

news is disposition relevant analysis is accurate and sufficient; supporting documents are saved;

Make recommendations based on investigation result and escalate alerts that warrant further investigation

Completing KYC reviews in a timely manner and in accordance with a risk-based schedule.

Extract date from LexisNexis Platform using SQL commends.

Saint-Gobain – Contract Egypt

Marketing Research Analyst 12/2014 - 11/2015

Responsibilities:

Collect data on consumers, competitors and consolidate information into actionable items, reports and presentations

Understand business objectives and design surveys to discover prospective customers’ preferences

Compile and analyze statistical data using modern and traditional methods to collect it

Interpret data, formulate reports and make recommendations

Working with Data analysis tools like Excel, SQL to build reports that support management decisions.

World Top Flowers Saudi Arabia

Accountant & Data Analyst 11/2012 – 11/2014

Responsibilities:

Prepare journal entries

Complete general ledger operations

Monthly closings and preparation of monthly financial statements

Reconcile and maintain balance sheet accounts

Draw up monthly financial reports

Prepare analysis of accounts as requested

Assist with year closings

Administer accounts receivable and accounts payable

Prepare monthly payrolls and commission

Preparation of the final annual financial statements and reports assessed

Account/bank reconciliations

Review and process expense reports

Dings different variety of reports utilizing SQL commend, Crystal Report, an d SSRS

Xceed Egypt

Customer Services 9/2009 – 11/2011

Responsibilities:

Handle and respond to constant inbound phone calls via telephone.

Deliver service and support to end-users using and operating automated call distribution phone software.

Interact with customers to provide and process information in response to inquiries, concerns, and requests about products

Gather customer’s information and determine the issue by evaluating and analyzing the symptoms;

Maintain and promote a positive attitude while meeting productivity goals

Demonstrate the ability to create, add, edit and troubleshoot within the client system

M.C.C Constructions Egypt

Accountant 2/2008 - 9/2009

Responsibilities:

Create project accounts in the accounting system

Authorize the transfer of expenses into and out of project-related accounts

Review and approve supplier invoices related to a project

Review and approve overhead charges to be applied to a project

Review account totals related to project assets and expenses

Investigate project variances and submit variance reports to management

Create different variety of reports utilizing SQL commend, Crystal Report, an d SSRS

Skills

Applications (MS SQL, SSRS, C#, Oracle, MS Access, Alteryx, Python (NumPy, Panads, Matplotlib), Informatica, Tableau, AWS, Jira)

Languages (English, Arabic).

Leadership/Volunteer Development

The Building Blocks NJ 7/2017

International rescue committee (IRC) 8/2017

Contact this candidate