Post Job Free

Resume

Sign in

Customer Service Data Enty

Location:
Roswell, GA, 30076
Salary:
1450 monthly
Posted:
August 11, 2023

Contact this candidate

Resume:

Melissa A. Smith, CFE

662-***-**** adyvai@r.postjobfree.com www.linkedin.com/in/melissa-a-smith

Education

B.S. Business Administration, Accounting and Finance, University of Tennessee, Knoxville

Summary:

Along with Bachelor of Science in Business Administration, Accounting and Finance, Melissa comes from Sales and highly financial regulated background where Data Analytics/ Accuracy has been a major concern. She worked very closely with several internal audit and accounting teams. She holds extensive years of experience in calculating several diversified accounting system payments such as payroll and bonuses, accounts receivable, homeowner optional insurance, and treasury payments. She is well versed with MS-Excel Macros, VLOOKUP, HLOOKUP, Pivot Tables, and applying different formulas. Data Analytics using ACL for trial balances (Mission, PeopleSoft, Oracle) payment applications.

Skills:

Data Analytics

Bank account administration

Risk environment analysis (likelihood and impact)

General ledger (Post entries AS 400, PeopleSoft, Oracle)

G/L reconciliations (Blackline, Oracle). Trial Balance Sheets

Executive Assistance and confidentiality (3yrs gaming and entertainment)

Customer Service

Communication (verbal and written)

Post contact notes in system (sales, collections, credit, medical, customer service)

MS Office Suite (Outlook, Excel, MS Word, PowerPoint)

Experience:

FedEx Trade Networks, Memphis, TN

Customer Service Representative, March 2021

Data Entry/keyboard to process foreign shipper and U.S. import files following customer SOP for time sensitive clearance.

Provide Communication written and verbal via phone, email, and teams.

Use multiple programs such as outlook, MS Teams, Galaxy- Jupiter Dashboard, and Duplex.

Sabbatical for health reasons. March 2020-March 2021.

Sabbatical to take care of mom

In home hospice care, May 2018-March 2020

FedEx Services, Memphis, TN

Internal Auditor Associate, January 2012 – May 2018

•Completed Audit Committee plan audits. Performed planning, fieldwork, and reporting portions of operational, financial, corporate, and P&C audits.

•Performed audit work on site such as walk throughs, observations, and financial trending.

•Analyzed risk and internal control compliance. Performed key Executive risk interviews and fieldwork.

•Completed business and fraud scan flow charts in Visio for key controls and risks.

•Identified systemic flaw in parts ordering process. Reduced US domestic inventory expenditures by 5% and saved an estimated $1MM by preventing duplicate orders in ordering system.

•Reviewed the overtime distribution system and assessed management selection process to reduce payroll related lawsuits. Ensured manual overtime instruction distributed followed. Tested Chronos and timeclocks for accuracy.

•Analyzed G/L accounts, contracts, and invoices for timing, approval, and amount. Reviewed financial analyses for facilities construction including NPV justification and certificates of liability for construction.

•Reviewed accounts payable, payroll and bonuses.

•Created G/L expense reports in Oracle.

•Analyzed trial balance sheets and evaluated GL entries for approval, GL code, accuracy, and timeliness. Looked at day before and day after close for revenue recognition issues. Assess information in Excel using VLOOKUP and pivot tables. Used Oracle.

•Used HLOOKUPS for financial cost analysis.

•Awarded Bravo Zulu for ‘Above and Beyond’ performance on dispatch operations and DWS system audit. Express tuition reimbursement subject matter expert.

ServiceMaster Global Holdings, Memphis, TN

Auditor II, August 2010 – December 2011

•Conducted assigned branch and HR audits for ServiceMaster operating brands: Terminix, TruGreen, and Merry Maids branch locations. Worked independently. Held entrance and exit conferences.

•Documented draft report audit scorecards for branch, audit, and HR management review. Branch scorecard testing programs included Revenue Recognition, Inventory, Fixed Assets, Data Security, Training/ Environmental Compliance, Human Resource OFCCP postings, payroll, and bonuses. Developed action plans based on audit results.

•Analyzed contracts, invoices, payroll, and bonus payments for timing, approval, and amounts.

•Prevented duplicate inventory orders from being stored offsite. Re-allocated inventory of approximately $300K to another branch.

•Worked with senior auditor on American Home Shield incentive payment audit. Reviewed company account reserves for anticipated insurance payments. Reviewed payroll and bonus payments with IRS, OFCCP, and company policy guidelines.

•Performed Sarbanes-Oxley testing for: payments (A/P), Debt and treasury compliance, accounts payable vendor master file process, tax payment process, payroll, and accounting close. Reported results to audit manager for company SOX self-certification and compliance report.

•Ran ledger trial balance. Assessed information in Excel using VLOOKUP and pivot tables.

•Performed Data entry in PeopleSoft Oracle for selected samples to assess whether accounting entries valid and controls working as intended.

•Special project for accounts receivable payment lapping for cash payments.

•Reviewed treasury account structure and number of late debt payments for penalty fees. Action plan was a detailed, documented discussion with treasury management.

ServiceMaster Global Holdings, Memphis, TN

Treasury Analyst II, March 2009 – August 2010

•Initiated daily wire and ACH transactions. Consolidated cash. Provided treasury accounting with current and prior day activity statements. Updated shared cash forecast calendar with scheduled inflows/ outflows of cash. Recovered $10K+ escheated funds.

•Managed ServiceMaster operating accounts for TruGreen, Merry Maids, Terminix, and ServiceMaster Acceptance Corp bank accounts. Reconciled daily transaction activity in the treasury workstation. Resolved failed BAI files and reported transmission failure to bank. Updated treasury balance with same day information.

•Resolved suspected fraud and bank account fee noncompliance.

•Opened new bank accounts with authorized approved signatories based on corporate role. Security administrator for online banking platforms. Added new users, updated permissions, and off boarded users.

•Performed treasury team set up Kyriba. Worked on internal project to decrease/ consolidate bank accounts and achieve operational efficiency and bank account cost savings.

•Executed setting up a new corporate lockbox account.

•Debt back up: factored receivables letters of credit, and revolving lines of credit to provide working capital and minimize interest. Processed payments to prevent short term debt breakage/ late fees.

•Completed monthly reports for treasury and accounting managers.

Caesars Entertainment Corporation (Formerly Harrah’s entertainment), Memphis, TN

Treasury Clerk, July 2006 – March 2009

•Provided administrative support to the Vice President and Assistant Treasurer with dotted line responsibility to Director of Cash Management and Director of Investor Relations/ Debt Management.

•Review department P&L for Assistant Treasurer approval. Review Corporates sources and uses of funds for new acquisitions

•Managed opening/ closing 450+ location/ corporate bank accounts. Ensured accounts met company bank account policy, corporate bank account structure, and negotiated bank agreement requirements to add/ change needed services

•Completed special project to update authorized corporate signers in accordance with corporate resolutions on all accounts.

•Researched accounting information and developed ad hoc reports for Vice President/ Assistant Treasurer from monthly property and corporate accounting report books for executive memos and capital projects.

•Set up delivery for paper statements and BAI files for Treasura account management application.

•Researched and deposited miscellaneous A/R payments. Deposited average of $300K bimonthly. Provided G/L information and legible documentation copies to treasury accounting. Provided treasury accounting with monthly activity in Treasura.

•Opened new banks related to collateralized mortgage back securities during investment bank buy out. Worked as treasury point person with accounting to segregate revenue streams. Provided daily revenue reports to the Director of Cash Management.

•Researched accounting information and developed ad hoc reports for Vice President/ Assistant Treasurer from monthly property and corporate accounting report books. Maintained secure file drawers and filing room.

•Drafted treasury department responses for property level Gaming Board license renewals

•Used company systems: Treasura (TMS), Excel, Microsoft word and company iSeries accounting systems.

Hunter Fan Company, Memphis, TN

Credit Coordinator, April 2005 – June 2006

•Reviewed credit applications and credit resources in D&B, Credit Risk Monitor and local sources before extending business credit to new customers. Reviewed all credit limits on annual basis to increase/ decrease credit as needed.

•Managed small business accounts for Hunter Fan operating company. Initiated 75+ daily contacts for accounts receivable /DSO aging report at highest collection risk. Met collection goals. Entered lockbox payments and credit memos on AS400 ledger. Completed intercompany transfers of misdirected payments and notified sister company controller.

•Worked with sales and marketing to get market program discounts updated on short paid accounts meeting program goals.

•Provided original shipping export documentation to port of entry for overland freight shipping. Documents included: phytosanitary exemption letter, vessel bill of lading, weight, origin documents, orders, electrical power certificate.

• Identified systemic problem automatically releasing orders if a customer was inactive. Updated all inactive account credit limits to force manual review. Prevented estimated $300K potential bad debt based off two months actual expenses.

•Filed POD claims against delivery agents as needed. Reviewed vendor buying agreements. Assisted credit manager gather support for legal suit against largest vendor.

•Cleaned up service agent warranty G/L and sent official letters closing service agent centers as part of company strategy.



Contact this candidate