Description
Summary: Database Management: Design data structures with tables pull data with SQL queries text file data processing and analyzing data on Excel with programming, macros, formulas, pivot table and graphics familiar with many financial accounting systems. Financial reporting: Constructed financial statements (Income Statement, Balance sheet, and cash flow statement) independently management financial reporting to HUD years working experience on A/P, A/R Accounts reconciliations journal entries and accounts trends analysis monitoring program grants expenditures, adjusting entries on accounts. Financial analysis: On Excel, Access and related systems with advanced techniques. Accomplishments: Accounting: * Constructed Income Statements, Cash Flow Statement and Balance sheets statements (Richmond Redevelopment Housing Authority). * Management Financial Reporting with multiple criterions on monthly, quarterly and yearly demanding with restricted time lines. * Huge dollar amounts reinsurance collections through global wide insurance companies. * Huge volume accounts payables processing. * Both huge dollar amounts and huge volume accounts reconciliations with quality results. * Journal entries and accounts adjusting entries invoicing, collections. Computer Technology: * Created ways to processing text file data. Established database structures. * Adopted my suggestion to build a bridge between Excel and Financial System to automated journal entry processing. * Adopted my suggestion to use formulas to pull data to increase efficiency on management financial reporting. * Built queries to pull data from data libraries though Access to simplify working process and increased accuracy and efficiently to improve accounts reconciliation processing. * Built a database management system through Access on switchboard to organizing data and generating financial reports automatically. * Communicating with IT department with software built, wrote test menus and actual testing. * Helped co-workers to using Excel formulas, trained co - workers on new financial software. * Excellent customer services skills with internal & external customers with effective communications skills on phone, email, letters or face to face.