Alvin James

Summary

Demonstrated initiative, integrity and resourcefulness, with advanced skills in financial analysis, quantitative analysis and economic research, combined with advanced written communication skills.

Developed analytical procedures and designed data algorithms for agency budgets identifying significant trends and abnormal balances in conformance with OMB circular A-136.

Database development and management skills include Access, SQL, SAS, advanced Excel macros, Dashboards, Pivot Tables, and Java Scripts.

More than 10 years of US Government, District of Columbia Government and private sector experience in program areas including financial analysis, budget analysis, economic analysis, business process integration and competitive analysis.

Effective at organizing and coordinating efforts toward the achievement of desired business objectives and creating value added.

I consider myself a data driven professional, with keen attention to detail and commitment to client satisfaction and achieving increase value added for the contract.

EDUCATION AND TRAINING

Cornell University, M.A.

City College of New York, B.A.

Graduate School USA, Advanced Excel 1.8 CEU: February 2020

SAS Institute, SAS Programming 1: August 2016

National Association of Insurance Commissioners (NAIC):

Annual e-Commerce Conference and Technical Training in Microsoft Access,

Oracle Queries, Advanced SQL, Advanced Excel and Microsoft Office Products.

Graduate School USA: Courses in HTML, Access, Excel, Web Page Design.

EXPERIENCE

Served as Financial Analyst/Economist, Budget Analyst and Loan Officer with the US Small Business Administration, US Dept. of Energy/EERE/BETO, Financial Economist with the D.C. Department of Insurance, Securities and Banking, D.C. Department of Consumer and Regulatory Affairs.

Graduate fields of study include Monetary and Financial Economics, International Trade, and Economic Development/Planning.

Small Business Lending, CARES Act and Covid-19 Disaster Loans: July 2020 –

US Small Business Administration, Contractor, Remote:

Washington, DC

Loan Officer/Loan Specialist (National Program)

Review SBA loan applications and supporting documents submitted by small businesses, non-profits and individual applicants.

Contact loan applicants to discuss loan documents and request additional documentation to support loans.

Mitigate loan denial reasons flagged by Rapid system as non-conforming to SBA guidelines.

Request IRS 4506T and add another borrower to meet minimum ownership percentage, if needed.

Decision loan and upload submitted documents to SBA portal.

Transmit loans recommended for approval to the funds obligation and funding stages

Email loan recommended approval or denial information to loan applicants.

Engage with loan denial applicants on remediation steps necessary for loan application to be reconsidered.

Consult Team Lead for guidance on problem loans.

US Department of Energy, EERE/BETO January 2018 – April 2020

The Building People, Contractor

Washington, DC

Budget Analyst/Financial Analyst

Provided contract support to Budget Operations Manager

Engaged in daily budget operations for creating funding actions and tracking obligated funds to DOE national research labs and other major research consortiums.

Review funding requests with Budget Operations manager and submit funding requests to BETO Budget Office.

Cleaned up CPS database, revised and restructure BETO/EERE CPS sub-system to reduce and mitigate non-synched funding authorization requests.

Attended bi-monthly DOE/BETO budget meetings for Budget Operations manager.

Produced ad-hoc report request from Budget Operations manager on year-to-date budget status as required.

Participated in preparing line-item budget requests for each national research lab.

Review bi-monthly funds request submitted by program labs mangers for sufficiency and conformance to DOE Budget Office guidelines.

Download Budget Office control table and prepare monthly available-to-spend reports for each lab.

Monitor and report the status of approved, deferred and released funds and Congressional add resources.

Track, monitor and review quarterly budget execution by research labs and other major research projects and alert Budget Operations Manager of underperforming labs.

Development periodic budgetary reports, and analysis.

Perform current FY and prior FY budget reviews and analyses as requested.

Research prior FY obligated funds returned by each national lab and outside contractors.

Banking and Small Business Lending: Nov 2015 – July 2017

US Small Business Administration/STS-MAAG Contractor:

Washington, DC and Rockville, MD.

Financial Analyst/Economist

Prepared and reviewed Loan Oversight Committee (LOC) meeting documents.

Researched SNL website regarding bank regulatory enforcement actions by the Federal Reserve or state banking authorities.

Researched Colson database for banks and non-bank lenders Fiscal Transfer Agent information regarding SBA 1502 unreported loans.

Researched Dunn and Bradstreet (D&B) database for banks and non-bank lenders with SBA 1502 unreported loans and portfolio balances.

Reviewed individual loans by bank and non-bank lenders and loan service providers (LSP) for SBA loan statutory compliance requirements.

Researched lender Loan Compliance Requirements in SBA LPA and PIMS databases.

Produced ad-hoc data analysis reports using Excel, Access, and SAS data analysis tools.

Extensive Excel experience. Experience with the use of pivot tables, pivot charts, Vlookup, macros, conditional formatting, and other Excel data analysis functions.

DC Dept. of Insurance, Securities and Banking Apr 2002 – Jan 2015

Insurance Regulation: Government of the District of Columbia, Washington, DC.

Financial Economist

Responsible for administering the D.C. Department of Insurance, Securities and Banking Insurance Premium Tax statutes and ensuring the timely collection and auditing of approximately $70 million in annual premium tax revenues paid by over 1,300 entities.

Organized and established the District’s Premium Tax Unit.

Responsible for ensuring regulatory compliance of each licensed insurance company’s annual premium tax return and tax payments to the District of Columbia.

Developed algorithms for analyzing each insurance company’s premium tax return against the company’s financial statement filed with the National Association of Insurance Commissioners (NAIC).

Created, developed, enhanced and maintained Access and Oracle relational data bases for tracking and reporting on the District’s premium taxes and fees paid by over 1,300 licensed insurance companies.

Designed SQL queries to extract, transform and load data from Oracle data warehouse into Access database.

Analyzed premium tax data and produced Access, Excel and Oracle management reports.

Designed, developed and implemented Java script enabled, web-based PDF online user friendly interactive premium tax and installment collection forms used by insurance companies in filing five lines of insurance premium and retaliatory taxes.

Recommended several changes to certain pages of the NAIC statutory blank financial statements to improve data access, queries and financial reporting by subsidiaries.

Participated in the Insurance Department’s audit accreditation standards review by the NAIC.

Worked with a team of actuaries, statisticians, financial analysts and auditors to document and defend the Insurance Department’s audit performance standards review to the visiting NAIC accreditation team on a three-year review cycle.

Tracked, monitored and audited the statutory amounts and limits of Accredited Certified Investors tax credits acquired by DC Certified Investors and used by the original investors, transferred to subsidiaries, assumed through mergers and acquisitions or sold to other entities over the lifetime of the original credits.

Participated in the development of the District’s short and long range premium tax revenue forecast.

Designed and developed interactive, user friendly PDF forms for reporting and tracking DC Life and Health Guaranty Fund premium tax credits amortized at 10 percent per year over a revolving 10-year cycle.

Contact this candidate