Accounting, Financial analysis, SAP, advanced Excel, Tableau

Peter Kodjo

acz8rb@r.postjobfree.com ● www.linkedin.com/in/peterkodjo ● 914-***-**** ● Houston, TX 77583

Summary

● Competent professional seeking Staff accounting or Financial/Accounting analyst role

● Holder of BSc and MSc in Business and Professional Accounting [Status: U.S Citizen]

● Seeking full time/contract role after 3.5 years of DBA/MBA study at NCU.

● My skills and experience:

oU.S GAAP and IFRS (Codification and Convergence)

oGeneral ledger (GL)/Journal entries, Budgeting and Costing

oCorporate/Staff accounting, Financial analysis, Data analysis

oAccounting Research, Reporting and problem solving/troubleshooting

oAudit assistance, Month-end Close, Systems (SAP) and process improvements

oCompliance knowledge: Internal Controls (COSO) and Sarbanes-Oxley Act (SOX)

oSAP, Business Intelligence - Tableau, Excel Modeling [macros, pivot tables, v-lookups]

Education

Masters in Business Administration*(MBA), Northcentral University Scottsdale, AZ

Advanced Accounting & Research; GPA=3.82 April 2017

Master of Science (MSc), Long Island University Brookville, NY

Professional Accounting; GPA=3.76 May 2012

Work Experience

SUPER DOLLAR, Rosedale, NY

Accountant - Part-time September 2016 to May 2017

Flexible part-time job when not in a full-time job/while in school (NCU) from 2013 to 2017

Handled all Accounts Payable for stores: Reviewed, matched and processed invoices to pay

Communicated with vendors, monitored payments status; Resolved invoice discrepancies.

Used QuickBooks to produce financial reports; created and managed inventory database

Budgeting duties for all stores; managed store operations, controlled inventory shrinkage

STANDARD CHARTERED BANK, Newark, NJ

Junior Oversight Analyst - Controls, Americas – Contractor July 2016 to August 2016

Participated in KYC-Client Onboarding, TUPA, BSA, Sanctions, Controls, FATCA training

Performed quality checks on Suspicious Activity Reports (SAR) before filing in FinCEN

Supported the collection, collation and analysis of Controls and MIS data using MS Excel

Performed 90-day SAR supplemental reviews using MS Excel and Palantir

Reviewed SAR filings on past/current Anti-Money Laundering (AML) and Counter-Terrorist Financing (CTF) caseloads; complied with departmental Operational Risk Framework

Prepared auxiliary reports via Palantir, Tableau, Excel (macros, pivot tables, v-lookups)

Performed duties in a training role gaining industry knowledge as an oversight analyst

PSEG-LONG ISLAND, Hicksville, NY

Data entry/analyst contractor – Temp SAP-Costing project December 2015 to May 2016

Created asset/costing macros in SAP; formatted and analyzed the costing data in MS Excel

Performed SAP data input and analysis duties for the Distribution Design department

Prepared required reports and summary tables using SAP macros/data

SUPER DOLLAR, Rosedale, NY

Accountant - Part time role September 2012 to December 2015

Flexible part-time job when not in a full-time job/while in school (NCU) from 2013 to 2017

Handled all Accounts Payable for stores: Reviewed, matched and processed invoices to pay

Communicated with vendors, monitored payments status; Resolved invoice discrepancies.

Used QuickBooks to produce financial reports; created and managed inventory database

Budgeting duties for all stores; managed store operations, controlled inventory shrinkage

WESCO INTEGRATED SUPPLY, Port Washington, NY

Accounts Receivable clerk – Project role, temp May 2012 to August 2012

Performed accounting and analysis duties and reconciliations using MS Excel and Access

Researched disputed items and streamlined customer accounts using AS400 program

Investigated and researched customer accounts using macros, pivot tables, and v-lookups

Reviewed application of cash, collections, payment allocation and analysis of credits

BAMSI, Brockton, MA

Residential counselor - Weekends only April 2010 to August 2012

Practiced as a consumer advocate and implementation of Individual Service Plans (ISPs) and handled clients’ case management duties related to developmental, legal and medical roles

Performed medical administration, supervision/residential duties of special need clients

CHEVRON K LTD, Chevron Corp subsidiary, Nairobi, Kenya

Junior Accountant – Tax & Investments April 2007 to February 2009

Performed financial reporting and complied with tax reporting per IAS and U.S. GAAP accounting standards (Taxes IAS 12, ASC 740; and deferred tax- FIN 48)

Analyzed input & output VAT (sales & use tax) in SAP modules; adjusted incorrect postings

Compiled quarterly Tax-based balance sheet (TBBS) and Effective tax rate (ETR) reports

Performed tax chargebacks in SAP and month-end closing; complied with SOX guidelines

Performed fixed asset duties in SAP; recorded asset acquisitions, asset tagging, depreciation and disposals; performed physical counts, prepared asset analyses and schedules for audit

Utilized I.T skills efficiently: MS Access and MS Excel (macros, pivot tables, models, depreciation, v-lookup, PMT, and IF) functions to perform accounting and analysis duties

Technology (I.T) Skills

SAP FICO end user; Exposure to AS400, Palantir and Detica systems

Advanced Microsoft Excel (Modeling, data analysis, macros, v-lookups, pivot tables)

Microsoft Office suite (MS Access, MS Outlook, MS PowerPoint, MS Visio, MS Word)

Tableau (Business Intelligence Software), QuickBooks Pro 2016

Internet research skills, SQL-in-training

Contact this candidate