Reporting/Accounting/Financial and Operational Analysis• Developed and produced weekly gross margin, pro-forma and cashflow models, integrating direct accounting and working data for internal and required bank/loan reporting.• Implemented and administered online software solutions: Bullhorn ATS, ZohoCRM, SpringAhead T&E, BambooHR, Zapier, and Asana.• Developed detailed recurring and ad-hoc reporting in Bullhorn/Canvas (based on IBM Cognos).• Directly managed AP, AR and daily cash balance reconciliations (QuickBooks Enterprise).• Produced a wide variety of reporting (i.e. weekly dashboard reports, sales performance, VMS account reconciliation, weekly task/project tracking, etc.).• Subject Matter Expert for all IT, computer, and software issues.

Financial Analysis• Expert in Excel and Access, with the ability to manipulate large quantities of data and formulate useful and relevant reporting tools using pivot tables, lookups, and VBA.• Performed data (SQL) warehousing in ZohoReports with standardized KPIs and dashboard for staffing firm.• Developed reports in MS Power BI, Excel Power Query and PowerPivot.• Created Excel spreadsheets/pivot tables to calculate and organize fabric requirements, production and delivery schedules for a fashion start-up. • Implemented NetSuite/OpenAir for startup IT consulting firm; developed regular and ad hoc reports for senior management.• Developed financial model, created standardized COA for case subjects/expert witnesses in bankruptcy proceeding practice.Accounting• Performed bookkeeping tasks using QuickBooks (Online, Premier and Enterprise) to manage AR, AP, collection reporting, and bank/credit card reconciliations.• Converted multiple years of bank statements from paper and PDF into digital form, mapping all transactions and importing into QuickBooks to recreate historical financial statements.• Converted retail client from legacy BusinessWorks to QuickBooks, managing chart of accounts, lists, and inventory reconciliation.• Developed beginning chart of accounts and processes for startup film Production Company. Technology• Evaluated several software packages for small business clients including: QuickBooks, Salesforce.com, vTiger, SugarCRM, MS Dynamics CRM, NetSuite OpenAir, SpringAhead, Bill.com, BaseCamp, Asana, Airtable, StitchLabs, and Zapier.• Performed IT network and PC support tasks such as troubleshooting and upgrading hardware, applications, printers, and network set-ups.• Extracted (‘Scraped’) contact information from national association website for client (member) to execute direct mail and online marketing programs.• Developed/published WordPress website from templates and plugins.

Builder• Residential builder involved with project selection, design, permitting, bidding, sub-contractor relationships through to punch out, completion and sale.• Self-taught use of Vectorworks CAD program to design 4 single family homes which were built and sold in the Virginia Highlands/Morningside area of Atlanta.

PlumRhino Consulting • Programmed Outlook customization to be used as recruiting database for project-based staffing needs • Implemented intranet database used for candidate and lead tracking, job order fulfillment, and internal collaboration• IT “Help Desk” troubleshooting organization hardware and software technical problemsBank of NY • Redesign, in Excel, of vintage Lotus spreadsheet and macros used to determine dollar amounts of client bond calls Northern Trust • Assisted senior management in ad hoc information gathering and analysis • Researched and clarified ongoing hardware/software contractual expenditures • Designed Excel budgeting template; comparing ongoing expenses with budget figuresPremier Bank (acquired by BB&T)• Reconstructed and consolidated two years’ worth of financial statements for 12 acquired banks by collecting general ledger financial data from disparate off-line legacy systems • Extensive data mapping to format information into current accounting structure by importing and manipulating raw data into Excel Pivot Tables and Access to ensure balance with actual reported resultsMaxxim Group• Designed Excel planning and budget template for nationwide retail chainRollins, Inc., • Assisted with several financial analysis related projects for Orkin

Financial Reporting Manager • Managed internal reporting team on all aspects of business for three divisions with over 400 operating locations, presenting mainframe data with desktop applications.• Authored regression studies analyzing and offering concrete recommendations on topics such as:  Optimal seasonal staffing levels and estimated cost of turnover.  Return on investment and break-even projections for externally generated sales.  Responsible for accumulating and summarizing quantitative and qualitative information on ongoing field and marketing test operations.  Integrated internally available statistics with interviews and outside intelligence to make recommendations for senior management. Managed maintenance of mainframe data warehouse. Initial data mapping and clean up for subsequent JD Edwards/Pilot Software conversion.