Summary
Overview
Work History
Education
Skills
Accomplishments
Affiliations
Software
Timeline
TECHNICAL
TECHNICAL
Generic

KWABENA NKANSAH KOBIA AMANFI

DATA/BUSINESS INTELLIGENCE ANALYST & ACCOUNTANT
Newark,NJ

Summary

An Accounting/IT professional with over nine (9) years' experience in various domains such as Finance, Aviation and Healthcare. An enthusiastic individual with extensive experience in Data Analysis, Data manipulation, Data Extraction, Research and Reporting in different formats and from various sources. Thorough working knowledge of HIPAA policies and procedures. Proven ability to learn, utilize in-house databases and systems to maintain strategic vision of the organization and link it with everyday work. Able to perform multiple duties in business analysis, project or program management, and functional leadership. A wonderful team player who can relate and work efficiently with diverse groups.

Overview

12
12
years of professional experience

Work History

Financial Reporting - Data Analyst (Contract)

Dealer Owned Warranty Company
Parsippany, NJ
12.2022 - 12.2023
  • Prepared standardize reporting using Power BI and/or SQL.
  • Developed report in Power BI and or/Excel.
  • Used Python or similar tools to automate processes, also bulk importing data.
  • Develop ETL processes and/or databases to support the reporting process.
  • Perform ad hoc analysis and projects as needed.
  • Prepare clear and concise documentation of all work performed.
  • Analyze client's performance & provide additional insights.
  • Prepared ceding report for reinsurance and warranty company.
  • Reconciled reinsurance and warranty companies ceded reserves, cancellations, claims and CLIPs.
  • Performed data reconciliation for correction on clients dashboard.

Accountant/Data Analyst (Part-time Contract)

Roche Pharmaceuticals/TIB MOLBIOL
Howell, NJ
07.2022 - 08.2023


  • Identified and documented detailed business rules and use cases based on requirements analysis.
  • Extracted and interpreted balance sheet and profit & loss data data patterns to translate findings into actionable outcomes.
  • Synthesized complex analytics-derived insights into easy-to-understand, actionable recommendations for business users.
  • Prepared monthly reports (Profit or Loss, Balance Sheet, receivables ageing, payables ageing, sales YTD and trial balance to the corporate reporting head quarters.
  • Generated and presented reports to the management team regarding the status of fixed assets, depreciation, and other relevant metrics.
  • Calculated and recorded depreciation following accounting standards.
  • Provide accurate asset-related information for financial reporting.

Data Analyst

Bristol Mayers Squibb
Summit, NJ
01.2019 - 09.2022

• Worked closely with the project team to normalize the data and availability for visualization and supported the project by training the team on the use of the dashboards.

• Created Tableau Dashboards that meet accessibility and requirements as applicable and as a design principle.

• Wrote complex SQL queries using advanced SQL concepts like aggregate functions, Group by, and OLAP (Online Analytical Functions). • Created mock-up layout design and wireframes using visualization features available in tableau and other internally provided tools.

• Developed ETL scripts in Python using Pandas library to get data from one database table and insert, update the resultant data to another database table.

• Define and implement routine reports (daily/weekly / monthly) of key performance metrics and action item alerts as well as on an ad hoc basis to drive results.

• Work directly with our provider partners and other internal units in designing and implanting evolutionary changes.

• Demonstrated a high level of expertise with healthcare data and healthcare informatics with solid understanding of HIPPA compliance and GPO Audits.

• Ad-hoc data extraction through queries in SQL, Excel, SAS, Tableau report, or PDF.

Revenue Manager/Financial Data Analyst

Africa World Airlines
Accra
10.2016 - 11.2018
  • Reviewed customer contracts and purchase orders for revenue recognition and verified compliance with company policies and standards.
  • Partnered with pricing, inventory management, commercial and revenue integrity teams to develop robust data intelligence and tools for passenger and cargo revenue management optimization lifecycle.
  • Created focused reporting, aligned with optimization lifecycle workflow, through Tableau dashboard development
  • Gathered and analyzed multi-format files received from various business users, Third-party entities, and Insurance carriers.
  • Developed reporting to support pricing/flight optimization system health to monitor data upload issues and large changes in forecasted demand/price.
  • Reconciled large and complex agents deposits and commission statements against bank deposits using various analytical methods.
  • Created data mapping documents and business logic to facilitate data migration and data integration into Oracle ERP.
  • Perform extensive QA using excel (lookups, Formulas, pivot tables, etc.) to validate files are loaded accurately according to mapping, business rules, and logic.
  • Calculated and reconciled monthly screening revenue in accordance with established corporate terms.
  • Developed and distributed quarterly management revenue and analysis reports using tableau.
  • Performed month-end reconciliation and developed reporting metrics in coordination with corporate finance executives.
  • Facilitated migrations of revenue and receivables data from SAP to Oracle while working with a project set up team to ensure the accurate set up of contracts.
  • Played a key role in maintaining less than 10% of outstanding receivables over 60 days.
  • Collaborated with the finance team to analyze financial data and provided insights for financial decision making purposes including revenue forecasting and budgeting.
  • Resolved escalated customer issues and boosted recovery rates by 90%.
  • Recorded the cost and details of newly acquired fixed assets.
  • Calculated and recorded depreciation expenses for fixed assets based on appropriate methods (e.g., straight-line, declining balance)

Financial Accounting Analyst

Aero Surveys Limited(Starbow)
Accra
08.2014 - 09.2016


  • Developed spreadsheet models for diverse projects and analysis.
  • Tracked prices, yields and other trends to correctly interpret impacts on our flying routes programs.
  • Created and maintained precise and accurate route models, charts and reports.
  • Monitored and analyzed financial, statistical and operational data trends.
  • Prepared and contributed to financial statements by accurately reporting fixed asset values and depreciation expenses.
  • Ensure adherence to accounting standards, tax regulations, and company policies in fixed asset accounting.
  • Maintain detailed records of all fixed assets, including purchase invoices, depreciation calculations, and disposal documentation.
  • Organized and managed all documents related to fixed assets, ensuring easy retrieval for audits or reference.
  • Periodically reconcile the fixed asset ledger with physical asset counts to identify discrepancies.

Business Intelligence Data Analyst

Stanbic Bank Gh
ACCRA, GHANA
04.2012 - 07.2014
  • Developed database architectural strategies at modeling, design and implementation stages to address business or industry requirements.
  • Documented and communicated database schemas using accepted notations.
  • Reviewed project requests describing database user needs to estimate time and cost required to accomplish projects.
  • Planned and installed upgrades of database management system software to enhance database performance.
  • Collaborated with system architects, design analysts and others to understand business and industry requirements.
  • Wrote complex SQL queries using advanced SQL concepts like aggregate functions, Group by, and OLAP (Online Analytical Functions)

Education

Professional - Accounting And Finance

ASSOCIATION of CHARTERED CERTIFIED ACCOUNTANTS
GLASGOW
07.2014 - 2020.12

Bachelor of Science - ACCOUNTING AND FINANCE

UNIVERSITY of PROFESSIONAL STUDIES
ACCRA
06.2014 - 2017.07

Skills

    RDBMS

undefined

Accomplishments

  • Used Microsoft Excel to develop debtors recovery tracking spreadsheets.
  • Achieved 85% of debt recovery through effectively reconciling receivable account using of various analytics tools.
  • Supervised team of eleven (11) staff members.

Affiliations

  • ASSOCIATION OF CHARTERED CERTIFIED ACCOUNTANTS

Software

Oracle ERP

SAP ERP

Radixx

SAGE 100 ERP

QuickBooks

Tally

Timeline

Financial Reporting - Data Analyst (Contract)

Dealer Owned Warranty Company
12.2022 - 12.2023

Accountant/Data Analyst (Part-time Contract)

Roche Pharmaceuticals/TIB MOLBIOL
07.2022 - 08.2023

Data Analyst

Bristol Mayers Squibb
01.2019 - 09.2022

Revenue Manager/Financial Data Analyst

Africa World Airlines
10.2016 - 11.2018

Financial Accounting Analyst

Aero Surveys Limited(Starbow)
08.2014 - 09.2016

Professional - Accounting And Finance

ASSOCIATION of CHARTERED CERTIFIED ACCOUNTANTS
07.2014 - 2020.12

Bachelor of Science - ACCOUNTING AND FINANCE

UNIVERSITY of PROFESSIONAL STUDIES
06.2014 - 2017.07

Business Intelligence Data Analyst

Stanbic Bank Gh
04.2012 - 07.2014

TECHNICAL

Business Intelligence Tool

Tableau, Power BI, Excel and PowerPivot, SSRS

Databases:

MS SQL SERVER

2008/2012/2016/2018, MySQL 5.2, 5.7, Oracle 9i, 10g, 11g

Proficient in Microsoft Office

(Excel, Access, Word, and PowerPoint)

Operating Systems

(Win XP, Vista, 7, Windows Server 2008,

2010(X32, X64),)

ETL / Other Tools SSIS,

Erwin Data Modeler, ER Assistant, ALTERYX, Informatica

Querying Tool

0SQL Management Studio 2008/2012/2016/2018,

SQL Plus, SQL Developer, Python 3.9.6, SAS

TECHNICAL

Business Intelligence Tool

Tableau, Power BI, Excel and PowerPivot, SSRS, Jira

Databases:

MS SQL SERVER

2008/2012/2016/2018, MySQL 5.2, 5.7, Oracle 9i, 10g, 11g

Proficient in Microsoft Office

(Excel, Access, Word, and PowerPoint)

Operating Systems

(Win XP, Vista, 7, Windows Server 2008, 2010(X32, X64),)

ETL / Other Tools,

SSIS , Erwin Data Modeler, ER Assistant, ALTERYX, Informatica,Power Query

Querying Tool

0SQL Management Studio 2008/2012/2016/2018, SQL Plus, SQL Developer, Python 3.9.6, SAS

Programming Language

SAS, TSQL, PL-SQL, Python, Scala


KWABENA NKANSAH KOBIA AMANFIDATA/BUSINESS INTELLIGENCE ANALYST & ACCOUNTANT