KWABENA NKANSAH KOBIA AMANFI

• 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.

• 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.

• 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.

• 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)

• 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.

• 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)