ACCOUNTANT / BI Specialist
ABE Corporate Cameroun
Total years of experience :20 years, 10 Months
Access and Organise the General Accounting and Reporting process in accordance to OHADA and IFRS.
•Manage GL Accounts for Proper Reporting using Quick Books.
•Measure, Evaluate and Reform the Inventory Valuation Process.
•Accounting and Reporting of Inventory.
•Manage month-end close process and produce month-end Reports.
Developing, deploying and monitoring ETL tasks using SQL Server Integration Services (SSIS) packages.
•Strategy design, development, implementation and testing of the ETL using SSIS.
•Monitoring and scheduling ETL processes using DTS EXEC utilities and batch file.
•BI & Reporting (SSAS, SSRS, Tableau, PowerPivot and Performance Point):
•Data warehouse design and analysis.
•Modified existing dimensions and cubes using star schema on SQL Server 2008R2 to achieve the efficiency of SQL Server Analysis Server (SSAS).
•Online Analysis Processing (OLAP), created cubes, dimensions for schemas.
•Developed Scorecards with advance set of dashboards using different Business Intelligence SSRS, Performance Point Server and Tableau.
•Developing various types of reports like Drill Down, Drill Through, Matrix, and Parameterized using SQL Server Reporting Services (SSRS).
To set-up a system of stock control, stock movement and stock reports.
Organize shipment schedules and storage layouts.
Identify and remove bottlenecks in storage, deliveries and departmental coordination.
Coordinate shipments between customers and vendors.
Control reports on truck movements and expenditure schedules.
Set-up a system on supplier’s follow-up.
Set-up a recovery schedule.
(Fixed Asset, Account Payable, Treasury & Inventory and General Ledger)
•Task:
•Payment of suppliers’ due balance manually and via on-line banking.
•Manual input of suppliers’ invoices, cheque requisitions, import licenses (DI) and custom duties into Oracle.
•Charge with the liaison and treatment of suppliers’ invoices between the supply, Logistic units and banks.
•Calculation and reporting on monthly Forex gain / loss
•Follow-up on asset acquisition, tracking, depreciation and disposal.
•Assets movements and usage.
•Accounting for assets, CIP and GL journals.
•Accounting for inventory and inventory valuation.
•Suppliers’ Account Reconciliations and Bank Reconciliations.
•Accounts analysis, investigation of variances and making corrective proposals for sound monthly, quarterly and yearly reports.
•Reconciliation of Accruals, Prepayments and Suspense accounts.
•Month-end control and posting of manual journals
•Analysis of monthly Unrealised and Realised Forex Gain & Loss.
•Activities and responsibilities:
•Capture on a daily basis all supplier invoices, cheques requisitions, utilities bills (Sonel, SNEC, Custom duties lease & others) and SGS declaration d’importation and check if in accordance with approval authority.
•Resolving suplliers’ payment queries with banks.
•Timely preparing of suppliers payments, strict respect of payment terms and satisfying suppliers’ requirements and queries.
•Ensure proper documentation of invoices and payments referenced and filed.
•Reconciliation of suppliers statements and accounts.
•Assets valuation and reproting.
•Bank reconciliation
•Stock management and reconciliations.
•Month-end reconciliation of GL accounts.
- Perform monthly consolidation process and produce key financial reports, including balance sheets, income statements, cash flows and other key performance indicators.
- Gather, review, analyze and consolidate financial data.
- Assist in the development of department budgets and ongoing monitoring of budget performance.
- Investigate and explain operational and financial variances to budget.
- Provide direction to department managers on appropriate finance and accounting treatment to ensure brand consistency.
- Serve as liaison between financial staff and operating departments.
- Support executive decision-making process through producing in-depth financial analysis, including quarterly earnings presentations.
- Support operating departments by performing financial and operational analysis of alternatives.
- Assist in managing big data to indicate operations performances and trends.
- Assist in business operation projections.
Computation and analysis of monthly tax liabilities & tax returns.
•Preparing periodical Financial Statements.
•Annual and mid-year Audits.
•Preparing Financial Year end DSF.
•Business Consultation & Advisory.
Task: Preparation of invoices.
•Declaration of monthly tax liabilities.
•Book keeping and preparation of Income and cash flow statements.
MS certification MS SQL Server/ SSIS / SSRS / SSAS Developer (On going).
Certification IAS / IFRS 23/09/07 – 27/09/07
Certification “LE DROIT COMPTABLE OHADA” 18/08/06 – 20/09/06
BSc. Hons Accounting
G.C.E Advance Level Certificate
GCE ORDINARY LEVELS