Senior Financial Analyst
The Commercial Real Estate Co.
Total des années d'expérience :14 years, 10 Mois
✎ Financial Modeling.
✎ Financial Analysis.
✎ Business Intelligence.
✎ Technical Analysis.
✎ Accounting.
✎ Ad Hoc. Reports.
✎ MIS Reports.
✎ Presentation Skills with PowerPoint.
✎ Microsoft Office with Power Query, Power BI & Tableau user.
✎ Excel with advanced functions “Vlook up, Hlook up, Index, Match, Indirect, Max, Min, Datedif, Sumif, Sumifs, Countif, Countifs, Pivot table, Power pivot, with VBA (Macros)”
✎ MS Access database with advanced functions, queries, forms, reports, ….)
✎ SQL.
✎ Ability to work under pressure & to work extended hours when necessary.
✎ Effective communication skills.
Using AX Dynamics ERP Microsoft Ver.-2012
✎Perform full set of accounts and ensure timely
closing of accounts.
✎Analyzing financial information detailing assets,
liabilities, and capital (Activity, Liquidity and Solvency
Ratios) with IS to get (profitability Ratios).
✎Building updated automation and dynamic analysis
for revenue, opex, cogs from first level up to top
segments by Power BI, Google Studio.
✎Preparing sensitivity analyzing business model per
segments, brands, customers and suppliers with
scenarios.
✎Building updated automation and dynamic V&H
analysis for P/L, IS & CF modeling with scenarios &
sensitivity analysis with dynamic projection.
✎Preparing annual budgets & Master Budget,
Comparing Act. with budget & revised budget.
✎Analyzing results, monitoring variances, identifying
trends & recommending actions to management.
✎Preparing business valuation by two methods
(Comparison, DCF) & Capital Budgeting
✎Updated dynamic online financial reports
presentation through office with mobiles screens.
Essential Duties and Responsibilities:
Financial work
❒-✍ Process Supplier's Invoices.
❒-✍ Process Suppliers' Payment.
❒-✍ Follow-up customer's payments.
❒-✍ Credit system.
❒-✍ Process Petty Cash.
❒-✍ Stock taking.
❒-✍ Following up bank (L/C’s, L/G’s)
❒-✍ Making bank reconciliation.
❒-✍ Process Trial Balance.
❒-✍ Process Profit & Loss Statement.
❒-✍ Process Balance Sheet.
Treasury work
❒-✍ Issues import and export letters of credits and guarantees and accepts payments.
❒-✍ Notifies exporters and importers of issuance of LC’s and LG’s
❒-✍ covering shipment of merchandise.
❒-✍ Reviews LC’s and LG’s documents to determine compliance with international standards.
❒-✍ Verifies terms of credits and guarantees, such as amount,
❒-✍ Compliance with established standards.
❒-✍ Coordinates customer credit information and collateral papers with Relationship Manager to comply with bank credit standards.
❒-✍ Types LC’s and LG’s and any related documents.
❒-✍ Records payments and liabilities and other customer account information.
Receivable work
❒-✍ Maintain up-to-date billing system
❒-✍ Follow up, collection and allocation of payments
❒-✍ Carry out billing, collection and reporting activities according to specific deadlines
❒-✍ Accounts reconciliation by VBA Excel in few seconds.
❒-✍ monitoring customer account details for non payments, delayed payments and other irregularities
❒-✍ maintain accounts receivable customer files
❒-✍ Follow established procedures for processing receipts, cash-etc
❒-✍ prepare bank deposits
❒-✍ investigate and resolve customer queries
❒-✍ process adjustments
❒-✍ organizing a recovery system and initiate collection efforts
❒-✍ communicating with customers via phone, email, mail or Personalty
Payable work
❒-✍ Review invoices and check requests
❒-✍ Sort and match invoices and check requests
❒-✍ Set invoices up for payment
❒-✍ Process check requests
❒-✍ Prepare and process accounts payable checks, wire transfers and cash payments
❒-✍ Reconciliation of payments
❒-✍ Prepare analysis of accounts
❒-✍ Monitor accounts to ensure payments are up to date
❒-✍ Resolve invoice discrepancies
❒-✍ Vendor file maintenance
❒-✍ Correspond with vendors and respond to inquiries
❒-✍ Produce monthly reports
❒-✍ Assist in month end closing
✎Verifies validity of account discrepancies by
obtaining and investigating information from sales,
trade promotions, customer service departments.
✎Carry out billing, collection and reporting activities
according to specific deadlines.
✎Posts customer payments by recording cash, checks,
and credit cards transactions.
✎Updates receivables by totaling unpaid invoices.
✎Maintains records by microfilming invoices, debits,
and credits.
✎Resolves collections by examining customer
payment plans, payment history, credit line,
coordinating contact with collections department.
✎Assist with month-end closing.
✎Protects organization's value by keeping
information confidential.
The Institute of Financial Consultants ® is an international organization for financial professionals. Institute of Financial Consultants ® and the Certified Financial Consultant ® marks are registered with US Government Patent & Trade Mark Office and with the National Certification Commission, USA. IFC offers an educational program leading to the designation of a Certified Financial Consultant ® (CFC) issued to qualified graduates. .Institute of Financial Consultants ® and Certified Financial Consultant ® mark are registered with US Government Patent & Trade Mark Office &the National Certification Commission, USA
International Auditing ( Cert IA )
International Financial Reporting ( IFRS )