ernest sarkodie

Reviewed, collected and maintained organized complex financial data and their updated aggregate using MS Excel, Pivot tables, Lookup (H, V, X, IF, nested formula’s), Macros.
Managed several aspects of the monthly/quarterly/annual close procedures and deliverables, including journal entries, account reconciliations, expense analysis, trend analysis, and variance analysis, in compliance with GAAP.
Collaborated with cross-functional teams to gather and validate financial data, improving the consistency and reliability of reports.
Supported regulatory record keeping duties to maintain the effectiveness of financial data files, ensuring accuracy, timeliness, and thoroughness with an emphasis on quality.
Automated data collection and reporting processes, significantly reducing the time required to generate monthly and quarterly financial reports.
Analyzed historical financial data to identify trends, variances, and potential risks, providing actionable recommendations for strategic decision-making.
Developed and implemented Power BI dashboards to monitor compliance with regulatory and policy limits of budget variances.
Delivered ad hoc reporting analysis using Power BI to drill into specific variance differences and identify root causes at granular levels.
Deployed audit trails of data access records to facilitate accountability, compliance audit and investigations, and resolving urgent queries.
Presented general ledger accounts variance reports using SQL queries and Power BI to illustrate account variances between budgeted amounts and actuals.
Developed workflow for remediation steps.
Supported month-end, quarterly-end, and year-end accounting cycle closing reconciliation on account balances using SAP ERP.
Analyzed variances and built additional reports to explain the performance of investment portfolios and prepared monthly and quarterly Net Interest Margin reports.
Developed, maintained, and improved financial models and spreadsheets for the budget and quarterly forecasts.
Integrated diverse data sources into ERP systems to ensure comprehensive and accurate reporting across multiple business units while completing reconciliation activities.
Processed data journal entries and vendor feeds into general ledger accounts and processed Excel files from Oracle database to SAP ERP.
Assisted Supervising Manager in resolving and handling reporting issues and requests and provided assistance in documentation and review of internal control policies and procedures.

Supported regulatory record keeping duties to maintain the effectiveness and integrity of defined contribution and benefit plans data such as 401(k), Pensions, and 403(b) plans, ensuring compliance with IRS and ERISA regulations.
Verified and reviewed data specifications and requirements from automated work distributing software (AWD) and Salesforce (CRM) before migration to Parts+ ERP to focus on data processing and compliance testing, ensuring accuracy and completeness of plan sponsor data.
Aggregated year-to-date compensation data from different divisions using Excel pivot tables to drill into total compensation and deferral percentages and the matching formula associated with the plan tiers.
Processed prepared compensation data, current and retroactive compensations data, and applied calculations according to matching formulas and vesting rules.
Conducted audit trails, identified, assessed, and managed outliers or anomalies in automatically generated data regarding compensations and deferral contributions under retirement plans and resolved exceptions and discrepancies generated by the automated compliance software.
Executed preprocessing steps for defined compensation and benefit data using Excel sheets, VBA, macros, and pivot tables, and migrated processed data to PARTS+ on Azure cloud to complete deferral test, documentation, validation, and compliance processing.
Conducted data profiling and validation of imported data, data quality assessments, identified data anomalies, and recommended data quality enhancements and data quality assurance.
Produced visual charts using SQL and Power Query in Power BI on top-heavy plans that failed non-discrimination tests in each plan category.
Received and responded to requests regarding data problems in internal database, took appropriate actions, and applied checks and reconciled information data for accuracy.
Ensured updated data is consistent with internal enterprise systems while analyzing for trends, patterns, and gaps, and executed solutions in compliance with rules and controls.

Prepared financial data including balance sheets, income statements, and cash flow statements, utilizing Sage 300 reporting capabilities for accounting managers for auditing and tax analysis as well as bookkeeping for clients.
Utilised accounting software such as QuickBooks, Sage 300, and Simply Accounting in auditing principles, payroll general ledger postings, invoicing, and taxation issues.
Prepared payroll reports, including tax filings, year-end statements, and W-2 forms.
Conducted in-depth audit and cost variance analyses, identifying discrepancies that led to a 5% reduction in budgetary allocation costs.
Collaborated to implement a new cost tracking system, improving the accuracy of cost data by 25% and enhancing the decision-making process.
Played a key role in the annual budgeting process, resulting in a more accurate and realistic budget that reduced unexpected costs and improved savings.
Recorded revenue transactions to align with the month-end AR General Ledger with the AR report.
Posted Accounts Payable invoices and issued payment cheques for assigned accounts.
Reconciled vendor statements, investigating and resolving discrepancies.
Recorded payroll journal entries and month-end accruals to ensure accurate payroll transactions recorded in the accounting system.

Created reports and dashboards with Tableau, Power BI, and QlikView to visualize and transform complex data into clear concise insights that provided analytical data-driven decision-making support for stakeholders.
Used MicroStrategy and Alteryx to design interactive dashboards, scorecards, and visualized data to extract intelligence and drive data-driven decision making.
Deployed a DataStage solution that streamlined data extraction and transformation processes in an ETL process.
Performed statistical analysis and data manipulation using SQL, Python, and SPSS.
Led data migration projects, including extracting and transforming data from legacy systems and loading it into MicroStrategy for analysis and visualization.
Worked with relational databases such as Oracle, SQL Server, and MySQL to extract and load data using database-specific SQL and wrote SQL queries to extract data from databases for various projects, including creating schemas and tables.
Conducted regression analysis, variance analysis, and AB testing on large datasets using SAS and SPSS to identify correlation between key variables, trend analysis, and their impact on business outcomes, resulting in improved decision-making.