Data Analyst Staff Accountant

HASHIRU BABATUNDE NEWLAND

***** ******** ****** ***. *** Silver Spring MD 20904

: 240-***-**** : ***************@*****.**.**

OBJECTIVE

A diligent, resourceful, novel, and unwavering professional who is looking to use his present know-how and skills in compliance audit, compliance review, information technology, information systems reviews and business analysis to create added value to prospective employer business to succeed in today’s competitive environment.

EMPLOYMENT

Contractor for IBS Management & Consultancy Services, LLC at WASHINGTON METROPOLITAN AREA TRANSIT AUTHORITY

Supervisory Accountant July 2018 – Present

Review of project costs relating to capital improvement projects.

Coordinates with capital payment review team, account payable, office of procurement and materials and office project implementation & construction to resolve issues on review of project costs.

Coordinate with manager and senior manager to resolve queries on payment reimbursement packages.

Generate report of capital improvement project (CIP) costs on daily basis to determine new costs on my CIP portfolio.

Assemble package after review to summarize the costs and provide adequate documentation of evidence to support vendor invoices.

Requirements gathering for report creation – Work with manager, senior managers, and directors.

Development of BI reports and user’s procedure document.

PAYROLL NETWORK INCORPORATION

Payroll Implementation Data Analyst February 2016 – July 2018

Coordinate with payroll implementation staff, managers, and clients to extract data for payroll implementation.

Transform extracted data in a ready format and state for iSolved Human Capital Software.

Load transformed information into iSolved Human Capital Management Software.

Coordinate with managers and president of payroll implementation department and other departments to gather reporting requirements.

Develop reports and user’s documentation and train users of developed reports.

Contractor for Verdi Consulting Inc at DEPARTMENT OF HOUSING AND URBAN DEVELOPMENT

Compliance Review of FHA-Insured Loans for Post Claims - Amounts for compliance review per institution consist of claims for tens of millions to billions of dollars

Compliance Auditor (McLean Virginia) Staff Accountant May 2013 – February 2016

Planning – obtain relevant information to develop samples, analyze possible risks and risk areas and plan compliance reviews accordingly.

Field work – carry out the compliance review entailing explaining purpose, scope, and nature of the review process to the clients (banks and financial instructions), review compliance of sample files and compiled sample findings, and communicate findings to client.

Reporting – review compliance findings for appropriateness and sufficiency, re-project findings and prepare reports and respond the banks rebuttal.

Administrative – prepare monthly status report on reviews completed and in-progress, identify possible reviews, and research code of federal regulations, handbooks, mortgagee letters and other relevant sources of authoritative materials for the compliance reviews. participate in the development and improvement of review procedures and help streamline review materials and tools.

DEPARTMENT OF LABOR

OFFICE OF THE CHIEF FINANCIAL OFFICER

Preparation of Financial Statements and Support Documentation for Audit Readiness

Staff Accountant (McLean Virginia)

STAFF ACCOUNTANT December 2013 – March 2014

Trial Balance Testing – Test the relationship between account balances to ensure predictable relationship exist. Prepare report of unpredictable relations between balances.

Research of Tie Points – Research the reasons for abnormal balances and communicate to management.

Prepare reconciliation of treasure balances.

SKILLS AND ACCOMPLISHMENTS

Use Python, Spark and Pyspark to extract insight from data from the Azure Databricks and Azure Synapse platform.

Use SQL and Databricks SQL to extract insight from data from the Azure Databricks and Azure Synapse platform.

Create insightful automated reports using Microsoft Excel and Power BI reporting capabilities.

Designed Excel Macro-Enable/DAX and Power Query Template for non-labor draw at WMATA.

Designed Excel Macro-Enabled Template that reduced the time by 75% it takes to do the trial balance testing and format of relevant tie point relationships.

Designed Excel Macro-Enabled Template and Word Macro-Enabled Template to generate samples for upcoming compliance reviews and create sample related documents to prepare for on-site and in-house compliance reviews.

Explain to the clients the methodology used in the generation of samples and how sample findings are extrapolated/projected to the claim’s population.

Designed Excel Template to carry out finding projection in just 5% of the normal time required to manually carry out finding projection in Excel. On average completed 10 claim files per day during on-site or in-house review

Completed review of clients’ rebuttal and report writing within two business days.

Add value to audited businesses through recommendations of strong internal control processes.

Improved the integrity and reliability of clients’ computational process for figures included in financial statements, claims and other non-financial information.

Brilliant team player with exceptional analytical and problem-solving skills.

EDUCATION AND QUALIFICATIONS

2022 – 2022

Databricks Lakehouse Fundamentals

Project Management Professional (PMP)

2019 – 2019

Microsoft Certified Solution Associate (Business Intelligence Reporting) – Microsoft Corporation

Analyzing and Visualizing Data with Microsoft Power BI

Analyzing and Visualizing Data with Microsoft Excel

2018 – 2018

Microsoft Technology Associate (MTA) - Networking Fundamentals - Microsoft Corporation

Microsoft Technology Associate (MTA) - Security Fundamentals - Microsoft Corporation

Microsoft Technology Associate (MTA) - Windows Server Administration Fundamentals - Microsoft Corporation

2016 – 2016

Cybersecurity Nexus Fundamentals (CSX) - Information Systems Audit and Control Association, Illinois United States of America

2015 – 2015

Certified Information Systems Auditor (CISA) - Information Systems Audit and Control Association, Illinois United States of America

2011 -2011

Microsoft Office Specialist: Microsoft Excel 2010

2009 – 2010

Master of Business Administration (MBA) - Anglia Ruskin University, Cambridge United Kingdom

2007 – 2008

Association of Chartered Certified Accountants (ACCA) - Association of Chartered Certified Accountants, London United Kingdom

Contact this candidate