Fully remote Financial Analyst/Budget Analyst
Resume:
Alvin James
SILVER SPRING, MD
*****.***@*******.***
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 a keen attention to detail and commitment to client satisfaction and achieving increased 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: eCommerce courses in HTML, Access, Excel, PowerPoint and 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.
US Small Business Administration July 2020 –
Contractor: Remote
CARES Act and Covid-19 Disaster Loans:
Washington, DC
Budget/Loan Specialist (National Program)
Review SBA Covid-19 Cares Act loan applications and supporting documents submitted by small businesses, non-profits and individual applicants.
Perform online document search to validate business identity with Secretaries of State Offices, states licensing, regulatory and taxing authorities and other social media presence.
Contact loan applicants to gather required loan documents and request additional documentation to support loans.
Perform due diligence and add another borrower to meet minimum ownership percentage, if needed.
Decision loan and upload submitted documents to SBA portal.
Mitigate loan denial reasons flagged by Rapid system as non-conforming to SBA guidelines.
Engage with loan denial applicants on remediation steps necessary for loan application to be reconsidered.
Consult Team Lead for guidance on problem loans.
Draft/edit interagency agreements.
Draft/edit PowerPoint training slide desks for SBA loan approval procedures.
Draft process maps and training slide desks for SBA loan approval guidelines.
Draft/edit loan process procedures and recommend SOP’s to senior managers and loan officers.
Support annual OMB A-136 audit requirements exercising judgment in selecting and interpreting information.
Provide support to managers and program specialists in the budget development process.
Provide decision support and analysis to support the budget. 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.
Reviewed funding requests with Budget Operations manager and submitted funding requests to BETO Budget Office.
Cleaned up CPS database, revised and restructured 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.
Reviewed bi-monthly funds request submitted by program labs mangers for sufficiency and conformance to DOE Budget Office guidelines.
Extracted relevant data from Budget Office control table and prepared monthly available-to-spend reports for each lab.
Monitored and reported the status of approved, deferred and released funds and Congressional added resources.
Tracked, monitored and reviewed quarterly budget execution by research labs and other major research projects and alerted Budget Operations Manager of underperforming labs.
Produced periodic budgetary reports, and analyses as requested by senior management.
Performed current FY and prior FY budget reviews and analyses as requested.
Researched prior FY obligated funds returned by each national lab and outside contractors. US Small Business Administration Nov 2015 – July 2017 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.
Organized and established the District’s Premium Tax Unit.
Designed and developed an interactive, user-friendly PDF form 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.
-- DC L&H Guaranty Fund premium tax credits amortization form is still in use and has been adopted for use by several state taxing authorities.
Monitored the timely collection and auditing of approximately $70 million in annual premium tax revenues paid by over 1,300 entities.
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.
Participated in the development of the District’s short and long range premium tax revenue forecast.
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 databases 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.
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.
Contact this candidate