Lance M. Ratkoski
Bristol, RI ***09
*****.********@*****.***
WORK EXPERIENCE
Bank of America Providence, RI
Financial Analyst- Account Assignment (Contract Position) May 2016 December 2016
Examined the review and audit of financial information and reporting systems in accordance with GAAP.
Aided internal audit and local management with Sarbanes-Oxley audits.
Recorded, interpreted and reported financial information in support of general business operations.
Produced ad hoc analysis, research, financial reporting, and progress reports.
Analyzed financial results by identifying key performance indicators.
Reconcilied Balance Sheet accounts and maintained appropriate accruals.
Financial Analyst-Bank Account Operations and Projects (Contract Position) November 2015 May 2016
Analyzed financial activities using Excel modeling (VLOOKUP, pivot tables, formulas, etc.), including the monthly close process, balance sheet account valuations and reconciliations and expense budgets.
Reconciled cash flows and transactions between different accounting and treasury systems.
Monitored daily reports for accounting accuracy and reported financial information to management.
Examined financial data for accuracy and performed accounting corrections to data.
Financial System Analyst (Contract Position) July 2015 October 2015
Launched a new general ledger program and verified the data for accuracy of the program.
Conducted system requirements cases, capabilities, and limitation assessments for the general ledger program in order to analyze system performance, assessed system documentation and interfaces, and evaluated system improvements.
Identified and reduced risks through financial statement analysis and process testing.
Aflac Insurance, Inc. Warwick, RI
Summer Intern May 2014 August 2014
Researched company forecasts and evaluated trend analysis with Sales Force.
Developed queries and operating models for annual budgets and monthly forecasts.
Created and analyzed weekly and monthly spending reports for discrepancies over 10%.
MILITARY LEADERSHIP
United States Army Ft. Knox, KY
Private First Class Honorable Retirement May 2010
Analyzed inventory levels of equipment and controlled $15k in cash and equipment.
Generated reports detailing expenditures, disbursements and verified statements for accuracy.
Analyzed and interpreted monthly variances and trends between budgets and actual expenses.
EDUCATION
Capella University Minneapolis, MN
Master of Business Administration Presently Enrolled
Rhode Island College Providence, RI
Bachelor of Science: Finance Major & Economic Minor Class of 2015
ADDITIONAL INFORMATION
Skills: Auditing, Accounts Receivable/Payable, Balance Sheet Analysis, Cash Flow Analysis, Financial Reporting, Financial Reconciliation, Forecasting and Risk Management.
Computer: Advanced in Microsoft Excel, PowerPoint, and Word and experienced in Microsoft Access,
Oracle, SAP and SQL.