Financial Analyst Systems

SHALINDA FARMER

Email: ***************@*****.***

Phone: 404-***-****

LinkedIn Profile: shalinda-farmer-mafm-411041217

EDUCATION

Keller Graduate School of Management - Decatur, GA Master of Accounting and Financial Management

Georgia Southern University - Statesboro, GA

Bachelor of Business Administration in Accounting

PROFESSIONAL EXPERIENCE

Vaco Staffing August 2020- Current

Business and Financial Analyst-

Contracts held: Reckitt Benckiser, Voya Financial, Mass Mutual Insurance, PMI, Oxford Industries, and Focus Brands Restaurant Group

Effectively prepared and presented financial projections for departments according to actuals, contract amounts and budgets

Create and communicate timely, accurate and consistent financial planning, budgeting, forecasting and management reporting for the business group and identify and effectively communicate business insights from the financial data to enhance decision making.

Independently handle complex issues with minimal supervision, while escalating only the most complex issues to appropriate staff.

Created Models for forecasting brand management such as products and other related inventory.

Utilized Gross Margin analysis for product pricing to determine profitability.

Created a Cost-plus Total Pricing Model (TPM) for products to determine profitability and sustainability, and customer attraction in retail stores for Reckitt brands (Lysol, AirWick, Finish, etc).

Prepared full deck reports monthly for restaurants and retail stores.

Daily and Weekly reconciliation of Bitcoin and Coinbase, as well as other digital currencies, to client’s portfolio.

Analysis of digital currencies identifying KPIs, history, customer retention, and diversification in portfolio.

Developed process documentation for process improvement for accounting department for month end close, inventory, sales, and other key reconciliation processes.

Develop ad hoc analysis and complex modelling including cost of services and associated trends, both financial and nonfinancial, to enable decision making and evaluate key performance indicators.

Monthly PBT (Profit Before Tax) analysis, forecasting and budget KPIs presentation to division.

Provide input and identify opportunities to improve process, data and technology to drive standardization and simplification of financial planning, budgeting, forecasting and management reporting.

Prepared monthly balance sheet account reconciliations and overhead allocations in Blackline

Implemented Blackline integration from TRECS at Oxford Industries, ensuring all prior balances and data is pulled over correctly for successful migration.

Lead migration from SAP to S4HANA, through testing, meeting facilitations, process and system documentation and education/training to complete migration.

Streamlined the Blackline matching process, utilizing Sandbox to vouch Point of Sale systems (Shopify) feeding into Blackline properly.

Successfully set up Blackline match rules, and accounts for credit card transactions, which integrated with SAP.

Lead weekly team meetings as Blackline team lead to ensure smooth transition of integration and to resolve any processing issues.

Worked closely with Blackline implementation team, whereas having weekly status update meetings to ensure implementation is completed before deadline and all feeds are properly processing.

Created and approved tasks in Blackline

Uploaded and manually entered journal entries in Blackline.

Performed over 800 balance sheet reconciliations in Blackline and acted as Financial Approver to approve journal entries where needed.

Performed key System Administration duties such as granting access in Blackline.

Reviewed and approved journal entries, analysis, and reconciliations, and effectively analyzed and prepared summaries of financial results for senior-level management

Supervised and performed month-end close processes, including agreement review, account reconciliation preparation, and preparing/posting journal entries for revenue related accounts and contra revenue accounts.

Coordinating with other members of the finance team to review financial information and budgets.

Effective time management to meet deadlines and ensure department operations.

Responsible for all company revenue recognition and reporting. Including but not limited to, creating complex journal entries for recording revenue, reporting on revenue, internal growth, requisition counts, customer discounts, etc.

Partner with peers in cross functional financial teams to achieve the finance strategy and strategic goals of the business or function and implement effective and efficient tools, models and reporting to deliver insights and ensure accuracy and transparency.

Researched accounting issues and resolved AR and AP issues.

Identify trends in performance and provide recommendations for budget and improvement.

Monthly balance sheet account reconciliations and overhead allocations to variance analysis.

Providing financial models and forecasting for product and store profitability

Sports and Imports Collisions - Duluth, GA (Remote) January 2019 – August 2020

Sr. Lead Accountant

Prepared and Managed bi-weekly payroll including direct deposits, distribution of checks, and state and federal tax payments.

Prepared and submitted annual, quarterly, and property tax returns.

Managed employee records, onboarding, and benefits

Managed full preparation and distribution of financial statements.

Oversaw preparation of Month End close process for financial statement preparation.

Developed policies and procedures.

Filed federal, state, and local tax documents as well as Sales and Use Tax returns.

Review Purchase orders and match with invoices for payments

Performed AP and AR duties when needed.

Creative Financial – Sandy Springs, GA (Remote) June 2012 – January 2019

Senior Accountant/ Financial Analyst

Accomplished Full Charge Bookkeeping for S and C Corporations, as well as LLCs.

Managed full preparation and distribution of financial statements.

Endowment daily and monthly activities for non-profit organization- Jewish Federation of Greater Atlanta

Cash or stock application of endowment checks to accounts

Daily monitoring of stocks for endowment related funds

Monthly financial reporting for non-profit which specifies donors and their contribution classes and presentation to CFO and COO.

Successfully lead annual audits, communicated with auditors and completed audit worksheet for non-profit – Jewish Federation of Greater Atlanta (JFGA).

Filed federal, state, and local tax documents by preparing property tax returns, extensions, quarterly payments, estimated payments, and payroll returns as well as Sales and Use Tax returns.

Managed accounts receivables to resolve accounts over 60 days old.

Managed Month-end close process and developed policies and procedures for accounting department functionalities

Managing tax liens for city and county, tracking payments and processing payoffs up to $3 million

Prepare monthly and quarterly analysis reports for managing partners.

Supervised Accounts Payable, Account Receivable, Investment Portfolio accounts as well as Endowment

Accurately performed bank and brokerage statements reconciliation on assigned accounts in a timely manner.

Maintained investment section of general ledger in an accurate and timely manner, including but not limited to, recognizing, and recording all transactions as generated by brokerages / bank statements and all other routine functions of endowment operations.

Smith, Gambrell, & Russell, LLP – Atlanta, GA June 2008 – June 2012

Senior Accountant/ Financial Analyst

Supervised a team of accountants and respective accounting functions (AP, AR and Collections)

Reviewed and approved journal entries, analysis, and reconciliations, and effectively analyzed and prepared summaries of financial results for senior-level management

Supervised month-end close process

Performed analysis of financial statements for year-end budgets

Reviewed accounting policies for consistency and compliance with GAAP and SOX controls and identified areas for potential efficiencies.

Completed assessment of fixed asset management to execute the depreciation of each asset at the end of each year to ensure accurate deprecation numbers.

Prepared monthly balance sheet account reconciliations and overhead allocations

Processed daily banking and foreign currency transactions, which included wires and ACH management.

Monitored daily ZBA Transfers and bank account line of credit balances upwards of $5 million per case without a single mishap.

Led year-end external audit, including the preparation of requested schedules, and communication with auditor.

Reviewed domestic and international transactions from other systems feeding to the general ledger for accuracy to execute ad hoc reports on variances in monthly financial reports.

Executed daily cash reconciliation, including investment and petty cash accounts, in order to successfully manage funds in firm's main operating accounts.

Prepared property, city commercial rent and state tax returns and tax work papers in support of tax return Manage full preparation and distribution of financial statements.

TECHNICAL SKILLS

Microsoft Excel (V-LOOKUP, Pivot tables), SAP, SAP Analytics Cloud, S/4HANA, TM1, Fusion, ServiceNow, Solver, Cost-plus Pricing Models (TPM), Bitcoin, Coinbase, Blackline, NetSuite, Power BI, Power Query, People Soft, QBO, Sage Accounting, Elite, QuickBooks Online, Oracle, SharePoint, MicroStrategy, Lawson, Workday, Monday.com

LinkedIn Profile: https://www.linkedin.com/in/shalinda-farmer-mafm-411041217

Contact this candidate